MAS - Bi Solutions Inc. - 47QTCA24D00E5

GENERAL SERVICES ADMINISTRATION

Federal Supply Services

Authorized Federal Supply Schedule Price List

Online access to contract ordering information, terms and conditions, up-to-date pricing, and the option to create an electronic delivery order are available through GSA

Advantage!®, a menu-driven database system. The INTERNET address GSA Advantage!® is: GSAAdvantage.gov.

Multiple Award Schedule

FSC Group: Information Technology FSC Class: IT

Services Contract number: 47QTCA24D00E5

For more information on ordering from Federal Supply Schedules go to the GSA

Schedules page at GSA.gov.

Contract period: 8/13/2024-8/12/2029

BI Solutions, Inc.

4075 Linglestown Rd, # 180

Harrisburg, PA 17112 717-695-3624 https://bisolutions.net/

Contract administration:

Teresa Lanza 717-695-3624 teresa.lanza@bisolutions.net

Business size: Small Socioeconomic status: Women Owned Small Business

Prices Shown Herein are Net (discount deducted) https://bisolutions.net/ mailto:teresa.lanza@bisolutions.net

CUSTOMER INFORMATION

1a. Table of awarded special item number(s) with appropriate cross-reference to item descriptions and awarded price(s).

SINs SIN Description Labor Category Description Page

Awarded Price Page

54151S Information Technology Professional Services OLM Order Level Materials

1b. Identification of the lowest priced model number and lowest unit price for that model for each special item number awarded in the contract. This price is the Government price based on a unit of one, exclusive of any quantity/dollar volume, prompt payment, or any other concession affecting price. Prices are based on a unit of one (1) Labor Category for SIN 54151S. Prices are not based on geographic location.

Please see page 4-9 for Labor Category Descriptions and page 10 for table of awarded NET GSA prices.

1c. If the Contractor is proposing hourly rates, a description of all corresponding commercial job titles, experience, functional responsibility and education for those types of employees or subcontractors who will perform services shall be provided. If hourly rates are not applicable, indicate “Not applicable” for this item. Not applicable.

2. Maximum order:

SINs Maximum Order

54151S $ 500,000,000

OLM $ 250,000

3. Minimum order: $100.00

4. Geographic coverage (delivery area). Domestic

5. Point(s) of production (city, county, and State or foreign country). Harrisburg, PA

6. Discount from list prices or statement of net price. Prices shown herein are net prices

7. Quantity discounts. None

8. Prompt payment terms. Information for Ordering Offices: Net 30. Prompt payment terms cannot be negotiated out of the contractual agreement in exchange for other concessions.

9. Foreign items (list items by country of origin). None

10a. Time of delivery. (Contractor insert number of days.) To be negotiated at time of offer.

10b. Expedited Delivery. Items available for expedited delivery are noted in this price list. To be determined at Task Order level.

10c. Overnight and 2-day delivery. Not Applicable

10d. Urgent Requirements. To be determined at Task Order level

11. F.O.B. point(s). Destination

12a. Ordering address(es). Attn: Teresa Lanza

BI Solutions, Inc.

4075 Linglestown, Rd, #180 Harrisburg, PA 17102

Phone: 717-695-3624 Email: teresa.lanza@bisolutions.net

12b. Ordering procedures: For supplies and services, the ordering procedures, information on Blanket Purchase Agreements (BPA’s) are found in Federal Acquisition Regulation (FAR) 8.405-3.

13. Payment address(es). BI Solutions, Inc

4075 Linglestown, Rd, #180 Harrisburg, PA 17102

Phone: 717-695-3624 Email: teresa.lanza@bisolutions.net

14. Warranty provision. Not Applicable

15. Export packing charges, if applicable. Not Applicable

16. Terms and conditions of rental, maintenance, and repair (if applicable). Not Applicable

17. Terms and conditions of installation (if applicable). Not Applicable

18a. Terms and conditions of repair parts indicating date of parts price lists and any discounts from list prices (if applicable). Not Applicable

18b. Terms and conditions for any other services (if applicable). Not Applicable

19. List of service and distribution points (if applicable). Not Applicable

20. List of participating dealers (if applicable). Not Applicable

21. Preventive maintenance (if applicable). Not Applicable

22a. Special attributes such as environmental attributes (e.g., recycled content, energy efficiency, and/or reduced pollutants). Not Applicable

22b. If applicable, indicate that Section 508 compliance information is available on Electronic and Information Technology (EIT) supplies and services and show where full details can be found (e.g. contractor’s website or other location.) The EIT standards can be found at:

www.Section508.gov/. Not Applicable

23. Unity Entity Identification (UEI number). JHUNY5TCBZK7

24. Notification regarding registration in System for Award Management (SAM) database. BI Solutions, Inc is registered and is active in SAM http://www.section508.gov/

LABOR CATEGORY DESCRIPTIONS

Applicable SIN - 54151S Note: For all positions, minimum Education criteria can be adjusted in lieu of documented equivalent profession experience as acceptable to the customer.

Business Intelligence Consultant, Senior

Functional Responsibilities: Provides management consulting, systems integration or systems development and in-depth knowledge of program design using standard business intelligence platforms.

Implements comprehensive end-to-end business intelligence environments. Work includes application development (including customized report content using programming languages and scripting languages), infrastructure planning and system integration activities. Participates in the design and resource allocation for large business intelligence implementations. Works closely with database modelers to create robust data source connections. Creates metadata interfaces between database structures and COTs reporting tools. Incorporates business rules identified in Project Design Descriptions into metadata presentation packages for use by Business Intelligence Consultants. Creates advanced report content and oversees the creation of report content by junior staff. Provides feedback to developer teams and senior staff. Interacts with clients, from management to end-users, to provide both remote and on-site application development services and support.

Minimum Experience: Five (5) years of relevant experience Minimum Education: Bachelor’s degree

Business Intelligence Specialist III

Functional Responsibilities: Provides management consulting, systems integration, or systems development. Provides in-depth knowledge of program design using standard business intelligence platforms. Implements comprehensive end-to-end business intelligence environments. Work includes application development (including customized report content using programming languages and scripting languages), infrastructure planning and system integration activities; participates in the design and resource allocation for large business intelligence implementations. Works closely with database modelers to create robust data source connections to deliver advanced reporting environments. Creates metadata interfaces between database structures and COTs reporting tools. Incorporates identified business rules into meta data presentation packages. Creates advanced report content, engineers high quality and robust reporting solutions, and oversees junior staff. Provides feedback to developer teams and senior staff. Interacts with clients, from management to end-users to provide application development services and support.

Minimum Experience: Eight (8) years of relevant experience

Data Warehouse Consultant, Senior

Functional Responsibilities: Provides management consulting, systems integration or systems development. Has in-depth knowledge of program design on standard systems. Work includes application development, infrastructure planning, and system integration activities. Performs on large-scale database management systems, has knowledge of computer equipment, and ability to develop complex software to satisfy design objectives. Analyzes and develops computer software processing a wide range of capabilities, including data warehouse technologies, business data models, data modeling for the warehouse, Extract-Transform-Load (ETL), Executive Information Management, and Decision Support System. Expert knowledge of various database management systems, relational database methodologies, and data warehouse database methodologies. Manages the data warehouse metadata, the documentation of the data warehouse design, and adopting naming standards. Analyzes user interfaces, maintains hardware, software, and database performance tuning, analyzes workload and computer usage, maintain interfaces with outside systems, analyzes proposed system modifications, upgrades and new COTS. Provides technical direction to junior staff. Interacts with clients, from management to end-users, to provide both remote and on-site application development services and support.

Engagement Specialist

Functional Responsibilities: Management consulting, systems integration, or systems development.

Provides in-depth knowledge of program design on standard systems. Work includes application development, infrastructure planning, and system integration activities, including integration with existing or custom developed authentication providers. A technical consultant who can combine programming, security, database, and software package knowledge to lead technical solutions and to resolve issues. Provides feedback to the developer teams and senior staff. Interacts with clients, from management to end-users to provide application development services and support.

Maintenance Support

Functional Responsibilities: Assists senior information technology consultants with analysis, evaluation, and recommendations for system improvements, optimization, development, and/or maintenance efforts in the following specialties: information systems architecture; networking;

telecommunications; automation; communications protocols; risk management/electronic analysis;

software; life-cycle management; software development methodologies; and modeling and simulation.

Minimum Experience: Six (6) years of relevant experience

Programmer Analyst I

Functional Responsibilities: Performs routine design, coding, and documentation of application programs for computers and related equipment used for scientific or commercial projects. Performs programming tasks based upon specifications and flow diagrams. Analyzes and translates concepts into program modules for testing, debugging, refinement, and integration with other modules.

Prepares draft documentation including program and user documentation. Functions as a member of a software development team under the guidance of more experienced.

Minimum Experience: One (1) year of relevant experience

Programmer Analyst II

Functional Responsibilities: Performs routine design, coding, and documentation of application programs for computers and related equipment used for scientific or commercial projects. Under minimum supervision, analyzes, designs, codes, and documents complex applications for large-scale computers and related equipment appropriate to scientific and commercial projects. Performs technical tasks using both standard and nonstandard analysis, design, and programming methods and techniques. Determines customer requirements. Analyzes problems in relation to user requirements, input data and form, output data and form, available computer configuration, processing turnaround requirements, input and output checking, and overall problem-schedule requirements. Advises on computer requirements and limitations to help define automation needs. Develops and writes machine or other suitable source language instructions required for computer processing.

Project Manager II

Functional Responsibilities: Performs complex functional activities by providing management and technical direction to project personnel. Regularly exercise independent judgment and a high level of analytic skill in solving complex technical, administrative, and managerial problems. Provides overall direction for all project level activities. Under limited supervision, responsible for all aspects of project performance (i.e., technical, contractual, administrative, financial). Manages and supervises personnel involved in all aspects of project activity, organizes, and assigns responsibilities to subordinates, reports on program status, and oversees the successful completion of all assigned tasks.

Subject Matter Specialist II

Functional Responsibilities: Applies subject matter expertise to analyze and define problems, develop plans and requirements in the subject matter area for complex systems. Coordinate and manage the preparation of analysis, evaluations, and recommendations for proper implementation of programs and systems specifications in the following specialties: information systems architecture; networking;

telecommunications; automation; communications protocols; risk management/electronic analysis;

software; life-cycle management; technology, software development methodologies; and modeling and simulation.

Minimum Experience: Seven (7) years of relevant experience

Subject Matter Specialist I

Functional Responsibilities: Applies subject matter expertise to analyze and define problems, develop plans and requirements in the subject matter area for moderately complex to complex systems.

Coordinate and manage the preparation of analysis, evaluations, and recommendations for proper implementation of programs and systems specifications in the following specialties: information systems architecture; networking; telecommunications; automation; communications protocols; risk management/electronic analysis; technology, software; life-cycle management; software development methodologies; and modeling and simulation.

Minimum Experience: Four (4) years of relevant experience

Technical Writer

Functional Responsibilities: Responsible for understanding, translating, writing, and editing technical information into standardized and easily understandable formats, such as reports, manuals, and system documentation for both technical and non-technical business users. Applies recognized quality assurance standards to IT projects. Researches, designs, schedules, and implements documentation projects. Defines the target audience and documentation components. Assists the management team with plans and outlines for assigned projects. Researches new writing methods, processes and tools.

Trainer

Functional Responsibilities: Develops and revises training courses and prepares appropriate training catalogs. Prepares instructor materials (course outline, background material, and training aids).

Prepares all material (course manuals, workbooks, handouts, completion certificates, and course critique forms). Trains personnel by conducting formal classroom courses, workshops, and seminars or side-by-side training.

Minimum Experience: Four (4) years of relevant experience

PRICING INFORMATION

Applies to SINS: 54151S

Labor Category Year 1

8/13/2024- 8/12/2025

Year 2 8/13/2025- 8/12/2026

Year 3 8/13/2026- 8/12/2027

Year 4 8/13/2027- 8/12/2028

Year 5 8/13/2028- 8/12/2029

Business Intelligence Consultant, Senior $157.50 $162.23 $167.09 $172.11 $177.27

Business Intelligence Specialist III $157.50 $162.23 $167.09 $172.11 $177.27

Data Warehouse Consultant, Senior $134.68 $138.72 $142.88 $147.16 $151.58

Engagement Specialist $151.60 $156.15 $160.84 $165.65 $170.62

Maintenance Support $135.50 $139.56 $143.75 $143.97 $148.29

Programmer Analyst I $117.08 $120.59 $124.21 $127.94 $131.78

Programmer Analyst II $131.43 $135.38 $139.44 $143.61 $147.92

Project Manager II $138.61 $142.76 $147.05 $151.47 $156.01

Subject Matter Specialist I $109.50 $112.78 $116.16 $119.66 $123.24

Subject Matter Specialist II $120.68 $124.30 $128.03 $131.86 $135.82

Technical Writer $103.19 $106.29 $109.48 $112.76 $116.14

Trainer $135.77 $139.85 $144.04 $148.35 $152.81