MAS - Bi Solutions Inc. - GS35F0882P

GENERAL SERVICES ADMINISTRATION

Federal Supply Services Authorized Federal Supply Schedule Price List

Multiple Award Schedule On-line 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.

FSC Group: Information Technology FSC Class: IT Services Contract number: GS-35-F-0882P For more information on ordering from Federal Supply Schedules go to the GSA Schedules page at GSA.gov.

Contract period: Sept. 22, 2019 through Sept. 21, 2024 BI Solutions, Inc.

4075 Linglestown Rd, # 180 Harrisburg, PA 17112 717-695-3624 https://bisolutions.net/

Contract administration: Teresa Lanza 717-695-3624 (office) 717-576-5095 (mobile) Teresa.Lanza@BIsolutions.net

Business size: Small Socioeconomic status: Women Owned Business

Price list current as of Modifications #PO- are Net (discount deducted)

CUSTOMER INFORMATION

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

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:

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.

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

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 Specialist III

Functional Responsibilities:

Eight to ten years of management consulting, systems integration or systems development. Possesses in-depth knowledge of program design using standard business intelligence platforms i.e. SAP BW, R/3, Business Objects, Cognos, Hyperion, MicroStrategy and Oracle. Demonstrable experience implementing comprehensive end-to-end business intelligence environments for clients. Work includes application development (including ability to customize report content using programming languages and scripting languages). Demonstrable experience undertaking 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 for the purpose of delivering advanced reporting environments to end-users. Creates metadata interfaces between database structures and COTs reporting tools. Incorporates business rules identified in Project Design Descriptions into meta data presentation packages for use by Business Intelligence Consultants. Creates advanced report content and oversees the creation of report content by junior staff. Makes use of extensive experience to engineer high quality and robust reporting solutions. Focuses on the delivery of engagement results to the client from a technical perspective. May require involvement in several engagements simultaneously and the coordination of other consultants involved in a specific project phase. Must have excellent people skills in order to communicate and train the user community. Provides feedback to the proper developer teams and senior staff. All development personnel must be able to professionally represent BI Solutions in interactions with clients, from management to end-users, to provide both remote and on-site application development services and support.

Minimum Experience: 8 years of relevant experience Minimum Education: Bachelors

Engagement Specialist

Functional Responsibilities: Eight (8) years of management consulting, systems integration or systems development. Should have at a minimum an 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. The Engagement Specialist is a technical consultant that can combine programming, security, database, and software package knowledge to engineer industry leading technical solutions and to resolve issues that lower-level consultants cannot address satisfactorily. May require involvement in several engagements simultaneously and the coordination of other consultants involved in a specific project phase. Must have excellent people skills in order to communicate and train the user community. Provide feedback to the proper developer teams and senior staff. All BI Solutions development personnel must be able to professionally represent BI Solutions in interactions with clients, from management to end-users, to provide both remote and on-site application development services and support.

Maintenance Support

Functional Responsibilities: Develops requirements from a project’s inception to its conclusion in the subject matter area for simple to moderately complex systems. Assists other senior consultants with analysis and evaluation and with the preparation of 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: 6 years of relevant experience

Programmer Analyst I

Functional Responsibilities: One (1) to four (4) years of related experience performing 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. 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 programmers. All BI Solutions development personnel must be able to professionally represent BI Solutions in interactions with clients, from management to end-users, to provide both remote and on-site application development services and support.

Minimum Experience: 1 years of relevant experience

Programmer Analyst II

Functional Responsibilities: Five (5) to eight (8) years of related experience performing 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 for the final program or system. Analyzes problems in terms of such factors as 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. May provide advice on system design configurations, procedural and technical aspects of automated records, hardware acquisition, and maintenance. Develops and writes machine or other suitable source language instructions required for computer processing. All BI Solutions development personnel must be able to professionally represent BI Solutions in interactions with clients, from management to end-users, to provide both remote and on-site application development services and support.

Minimum Experience: 5 years of relevant experience

Project Manager II

Functional Responsibilities: At least five (5) years of experience performing complex functional activities of the project by providing management and technical direction to project personnel. Must 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, and oversees the successful completion of all assigned tasks. Reports on program status.

Senior Business Intelligence Consultant

Functional Responsibilities: Five (5) to seven (7) years of management consulting, systems integration or systems development. Possesses in-depth knowledge of program design using standard business intelligence platforms, i.e. SAP BW, R/3, Business Objects, Cognos, Hyperion, MicroStrategy and Oracle. Demonstrable experience implementing comprehensive end-to-end business intelligence environments. Work includes application development (including ability to customize report content using programming languages and scripting languages). Demonstrable experience undertaking 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 for the purpose of delivering advanced reporting environments to end-users. 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. Makes use of experience to engineer high quality and robust reporting solutions. Focuses on delivery of engagement results to client from a technical perspective. May require involvement in several engagements simultaneously and the coordination of other consultants involved in a specific project phase. Must have excellent people skills in order to communicate and train the user community. Provides feedback to the proper developer teams and senior staff. All development personnel must be able to professionally represent BI Solutions in interactions with clients, from management to end-users, to provide both remote and on-site application development services and support.

Senior Data Warehouse Consultant

Functional Responsibilities: Five (5) to seven (7) years of management consulting, systems integration or systems development. Analyzes and develops computer software processing a wide range of capabilities, including data warehouse technologies, business data models, data modeling for the warehouse (dimensions and star schemas), 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. Responsible for managing the data warehouse metadata, the documentation of the data warehouse design, and for adopting naming standards. Analyzes user interfaces, maintain hardware, software, and database performance tuning, analyze workload and computer usage, maintain interfaces with outside systems, analyze proposed system modifications, upgrades and new COTS. Must have excellent peer-to-peer communication skills. Provides technical direction to junior staff. All BI Solutions development personnel must be able to professionally represent BI Solutions in interactions with clients, from management to end-users, to provide both remote and on-site application development services and support. Should have at a minimum an in-depth knowledge of program design on standard systems. Work includes application development, infrastructure planning, and system integration activities. Performs as a Data Warehouse Developer on large-scale database management systems, knowledge of computer equipment, and ability to develop complex software to satisfy design objectives.

Subject Matter Specialist II

Functional Responsibility: Seven (7) to ten (10) years of experience in the IT field. At least 5 years of combined new and related older technical experience in the IT field directly related to the required area of expertise. Defines the problems and analyzes and develops plans and requirements in the subject matter area for moderately complex to complex systems. Coordinates and manages 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; software development methodologies; and modeling and simulation.

Minimum Experience: 7 years of relevant experience

Subject Matter Specialist I

Seven (7) to ten (10) years of experience in the IT field. At least 5 years of combined new and related older technical experience in the IT field directly related to the required area of expertise. Defines the problems and analyzes and develops plans and requirements in the subject matter area for moderately complex to complex systems. Coordinates and manages 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; software development methodologies; and modeling and simulation.

Minimum Experience: 4 years of relevant experience

Technical Writer

At least three (3) years writing technical documentation for a software or technology company. Exceptional technical writing and editing skills. Proven ability to write documentation for both non-technical business users and administrators. Ability to consistently meet deadlines and deliver high-quality materials. Proven track record of innovation for making online documentation more usable and useful for customers. Ability to learn quickly and adjust priorities in a dynamic environment with short release cycles. Demonstrated ability to adhere to existing styles and processes and contribute towards improving them as necessary. The Technical Writer is responsible for understanding, translating, writing, and editing technical information such as reports, manuals, and system documentation into standardized and easily understandable format. The Technical Writer must be able to express ideas clearly and logically. The Technical Writer is responsible for preparing and reviewing all documentation. It is highly desired that the Technical Writer possess the following skills and attributes: Use MS Office including Word (writing macros, setting/formatting tables, creating forms), Excel, and PowerPoint as a means of creating, organizing, and maintaining project documentation. Apply recognized quality assurance standards (e.g., SEI-CMM/CMMI, ISO 9000, ITIL, etc.) to IT projects. Make use of excellent written communication and organization skills. Research, designs, schedules and implements documentation projects. Defines the target audience and documentation components. Outlines manuals and writes documentation that is technically accurate and conforms to company's style. Assists the management team with plans and outlines for assigned projects. Researches new writing methods, processes and tools

Trainer

At least four (4) years’ experience in system development, training, or related fields. 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.

Minimum Experience: 4 years of relevant experience

PRICING INFORMATION

Applies to SINS: 54151S

9/22/2021-9/21/2022 Year 2 9/22/2022-9/21/2023 Year 3 9/22/2023-9/21/2024 Year 4 9/22/2024-9/21/2025 Year 5 9/22/2025-9/21/2026

image1.jpg