Attachment_1_-_APMS_Application_Development_DRAFT_PWS.pdf

CONTRACTOR SUPPORT SERVICES FOR THE U.S. COAST GUARD OFFICE OF

PROCUREMENT POLICY & OVERSIGHT (CG-913)

PERFORMANCE WORK STATEMENT

1.0 GENERAL.

1.1 SCOPE.

The purpose of this Contract is to obtain Contractor support services for the Office of Procurement Policy & Oversight (CG-913). The task is to integrate acquisition data from the Coast Guard’s Contract Information Management System (CIMS), Core Accounting System (CAS), Financial Procurement Desktop (FPD), Aviation Logistics Management Information System (ALMIS), and Naval Electronics Supply Support System (NESSS) into the Coast Guard Acquisition Directorate’s (CG-9’s) established acquisition data mart. This data is used to support the Coast Guard in developing acquisition performance metrics, measures and management reports.

Currently the Coast Guard uses the following systems: Compusearch’s PRISM software, SQL database software and Coast Guard’s Acquisition Performance Management System (APMS), and SAS Business Intelligence (BI) system.

1.2 BACKGROUND.

CG-913 has identified a need for acquisition performance metrics, measures and management reports to effectively manage its workload. The Coast Guard Acquisition Directorate has deployed and is operating a comprehensive acquisition performance management system, using commercial off-the-shelf Business Intelligence (BI) software. The performance management system, known as the Acquisition Performance Management System (APMS), is the SAS BI system consisting of enterprise business intelligence, data integration, and performance management components. APMS receives data from multiple sources both internal and external to the Coast Guard and displays the information for executives and managers through a portal, web reports and metrics.

1.3 CONTRACTOR PERSONNEL.

1.3.1 Qualified Personnel. The Contractor shall provide qualified personnel to perform all requirements specified under this Contract. All Contractor employees supporting under this Contract shall also be citizens of the United States.

1.3.1.1 Contractor personnel must have at a minimum 3 years of experience using SAS, a minimum of 1 year expertise in the following: SAS BI Dashboard Version 9.4; SAS Web Report Studio Version 4.4; Base SAS Version 9.4; Information Map Studio Version 4.4; SAS Enterprise Guide; SAS OLAP Cube Studio Version 4.4; SAS Data Integration Studio Version 4.7; and SAS Management Console Version 9.4; and must have a minimum of 2 years experience with SQL database software and writing SQL query statements.

1.3.2 Employee Identification. Contractor employees visiting Government facilities shall wear an identification badge that, at minimum, displays the Contractor name, the employee’s photo, name, clearance-level and badge expiration date. Visiting Contractor employees shall comply with all Government escort rules and requirements. All Contractor employees shall identify themselves as Contractors when their status is not readily apparent and display all identification and visitor badges in plain view above the waist at all times.

1.3.2.1 Contractor employees working on-site at Government facilities shall wear an identification badge. All Contractor employees shall identify themselves as Contractors when their status is not readily apparent and display the identification badge in plain view above the waist at all times.

1.3.2.2 For all Contractors working for the USCG, the Contractor shall utilize the Department of

Defense (DoD) Contractor Verification System (CVS) to apply for a Common Access Card (CAC) for their employees that require access to a USCG or other federally controlled computer information system.

1.3.2.3 The Contractor shall submit a list of employees to the Contracting Officer’s Technical

Representative (COR) for the CVS.

1.3.2.4 Contractor and subcontractor employees required to access a USCG, DoD, or other federally controlled computer information system and/or facility, or need Public Key Infrastructure authentication to perform their contractual duties shall use CVS to obtain a CAC.

1.3.2.5 The Contractor shall provide such forms to or request such information from Contractor employees that may be necessary for obtaining a CAC via the CVS. Completed forms and information shall be submitted as directed by the COR. Contractors are responsible for the accuracy and completeness of the information submitted and for any liability resulting from the Government’s reliance on inaccurate or incomplete information.

1.3.2.6 Contractor or subcontractor employees who are declined a CAC via the CVS are ineligible to perform work that requires a CAC under this contract. When an employee with a CAC is no longer performing work under this contract, the Contractor shall notify the COR on the same day the employee stops working and shall deliver the CAC to the COR within seven

(7) calendar days after such notification.

1.3.2.7 Coast Guard Headquarters (CGHQ) utilizes a standardized entry protocol called the

RAPIDGateTM Program for all vendors, suppliers and Contractors requiring routine access to CGHQ buildings to perform unclassified work. To participate, in the RAPIDGate Program, the Contractor must contact Eid Passport at 877-RAPIDGATE (877-727-4342) and provide a CGHQ sponsor point of contact (must include: name, phone number, and e-mail address). Final authorization to participate in the program will be granted by Coast Guard Headquarters Support Command Security and Safety Office.

1.3.2.7.1 The Contractor shall submit a list of employees to RAPIDGate and shall be responsible for all associated fees (initial and renewal) required to participate in the RAPIDGate Program.

1.3.3 Employee Conduct. Contractor’s employees shall comply with all applicable

Government regulations, policies and procedures (e.g., fire, safety, sanitation, environmental protection, security, “off limits” areas, wearing of parts of military uniforms, and possession of weapons) when visiting or working at Government facilities. The Contractor shall ensure contractor employees present a professional appearance at all times and that their conduct shall not reflect discredit on the United States, the Department of Homeland Security or the U.S.

Coast Guard.

1.3.4 Removing Employees for Misconduct or Security Reasons. The Government may, at its sole discretion, direct the Contractor to remove any Contractor employee from U.S. Coast Guard facilities for misconduct or security reasons. Removal does not relieve the Contractor of the responsibility to continue providing the services required under this contract. The Contracting Officer will provide the Contractor with a written explanation to support any request to remove an employee.

1.3.5 Conflict of Interest. The Contractor shall not employ any person who is an employee of the United States Government if that employment would, or would appear to cause a conflict of interest.

1.4 SECURITY.

Contractor access to unclassified, but Security Sensitive Information may be required under this Contract. Contractor employees shall safeguard this information against unauthorized disclosure or dissemination.

1.5 PERIOD OF PERFORMANCE.

The period of performance for this Contract is one (1) year from date of award with (4) option years.

1.6 PLACE OF PERFORMANCE.

The primary place of performance will be the U.S. Coast Guard Headquarters Building at 2703 MARTIN LUTHER KING JR AVE SE, Washington, DC 20593.

1.7 HOURS OF OPERATION.

Contractor employees shall generally perform all onsite work between the hours of 0800 and 1700, Monday through Friday (except Federal holidays).

1.8 KICK-OFF MEETING.

The Contractor shall attend a Kick-Off Meeting with the Contracting Officer and the COR five (5) business days after the date of award. The purpose of the Kick-Off Meeting, which will be chaired by the Contracting Officer, is to discuss technical and contracting objectives of this contract. The Kick-Off Meeting will be held at the Government’s facility.

1.9 GENERAL REPORT REQUIREMENTS.

The Contractor shall provide all written reports in electronic format with read/write capability using applications that are compatible with Coast Guard Standard Workstation (Windows 10 and Microsoft Office 2016 Applications).

1.10 PERFORMANCE REQUIREMENTS SUMMARY.

This contract includes a Performance Requirements Summary (PRS). In general, the PRS sets forth the expected outcomes (objectives) of the, the service(s) required of the Contractor to achieve the objectives, a performance standard per outcome, and a plan for a reduction in payment in the event the Contractor does not meet the performance standard. The PRS is not an exclusive remedy and inclusion of the PRS does not preclude the Government from using any other remedy available by law or contract terms, including reductions in payment in accordance with any clause for inspection of services.

1.11 INTELLECTUAL PROPERTY.

All Contractor developed processes and procedures and other forms of intellectual property first developed under this contract shall be considered Government property.

1.11.1 All documentation, photography and electronic data and information collected by the

Contractor and entered into or generated in support of this Contract shall be considered Government property, and shall be returned to the Government upon request or at the end of the performance period.

1.12 PROTECTION OF INFORMATION.

1.12.1 Contractor access to information protected under the Privacy Act may be required under this contract. Contractor employees shall safeguard this information against unauthorized disclosure or dissemination in accordance with the law and Government policy and regulation.

1.12.2 Contractor access to unclassified, but Security Sensitive Information may be required under this contract. Contractor employees shall safeguard this information against unauthorized disclosure or dissemination.

1.12.3 Contractor access to proprietary information may be required under this contract.

Contractor employees shall safeguard this information against unauthorized disclosure or dissemination in accordance with DHS MD 11042.1, Safeguarding Sensitive but Unclassified (SBU) Information. SBU includes information categorized by DHS or other government agencies as: For Official Use Only (FOUO); Official Use Only (OUO); Sensitive Homeland Security Information (SHSI); Limited Official Use (LOU); Law Enforcement Sensitive (LES);

Safeguarding Information (SGI); Unclassified Controlled Nuclear Information (UCNI); and any other identifier used by other government agencies to categorize information as sensitive but unclassified. The Contractor shall ensure that all Contractor personnel having access to business or procurement sensitive information sign a non-disclosure agreement (DHS Form 11000-6).

The Contractor shall continue to ensure employees safeguard this information when the new Controlled Unclassified Information (CUI) framework replaces the sensitive but unclassified (SBU) categorization.

1.13 SECTION 508 COMPLIANCE.

Section 508 of the Rehabilitation Act, as amended by the Workforce Investment Act of 1998 (P.L. 105-220) requires that when Federal agencies develop, procure, maintain, or use electronic and information technology, they must ensure that it is accessible to people with disabilities. Federal employees and members of the public who have disabilities must have equal access to and use of information and data that is comparable to that enjoyed by non-disabled Federal employees and members of the public.

All EIT deliverables within this work statement shall comply with the applicable technical and functional performance criteria of Section 508 unless exempt. Specifically, the following applicable standards have been identified:

36 CFR 1194.21 – Software Applications and Operating Systems, applies to all EIT software applications and operating systems procured or developed under this work statement including but not limited to GOTS and COTS software. In addition, this standard is to be applied to Web-based applications when needed to fulfill the functional performance criteria. This standard also applies to some Web based applications as described within 36 CFR 1194.22.

36 CFR 1194.22 – Web-based Intranet and Internet Information and Applications, applies to all Web-based deliverables, including documentation and reports procured or developed under this work statement. When any Web application uses a dynamic (non-static) interface, embeds custom user control(s), embeds video or multimedia, uses proprietary or technical approaches such as, but not limited to, Flash or Asynchronous JavaScript and XML (AJAX) then “1194.21 Software” standards also apply to fulfill functional performance criteria.

36 CFR 1194.23 – Telecommunications Products, applies to all telecommunications products including end-user interfaces such as telephones and non end-user interfaces such as switches, circuits, etc. that are procured, developed or used by the Federal Government.

36 CFR 1194.24 – Video and Multimedia Products, applies to all video and multimedia products that are procured or developed under this work statement. Any video or multimedia presentation shall also comply with the software standards (1194.21) when the presentation is through the use of a Web or Software application interface having user controls available.

36 CFR 1194.25 – Self Contained, Closed Products, applies to all EIT products such as printers, copiers, fax machines, kiosks, etc. that are procured or developed under this work statement.

36 CFR 1194.26 – Desktop and Portable Computers, applies to all desktop and portable computers, including but not limited to laptops and personal data assistants (PDA) that are procured or developed under this work statement.

36 CFR 1194.31 – Functional Performance Criteria, applies to all EIT deliverables regardless of delivery method. All EIT deliverable shall use technical standards, regardless of technology, to fulfill the functional performance criteria.

36 CFR 1194.41 – Information Documentation and Support, applies to all documents, reports, as well as help and support services. To ensure that documents and reports fulfill the required “1194.31 Functional Performance Criteria”, they shall comply with the technical standard associated with Web-based Intranet and Internet Information and Applications at a minimum. In addition, any help or support provided in this work statement that offer telephone support, such as, but not limited to, a help desk shall have the ability to transmit and receive messages using

TTY.

Exceptions for this work statement have been determined by DHS and only the exceptions described herein may be applied. Any request for additional exceptions shall be sent to the COR and determination will be made in accordance with DHS MD 4010.2. DHS has identified the following exceptions that may apply:

36 CFR 1194.2(b) – (COTS/GOTS products), When procuring a product, each agency shall procure products which comply with the provisions in this part when such products are available in the commercial marketplace or when such products are developed in response to a Government solicitation. Agencies cannot claim a product as a whole is not commercially available because no product in the marketplace meets all the standards. If products are commercially available that meet some but not all of the standards, the agency must procure the product that best meets the standards.

When applying this standard, all procurements of EIT shall have documentation of market research that identify a list of products or services that first meet the agency business needs, and from that list of products or services, an analysis that the selected product met more of the accessibility requirements than the non-selected products as required by FAR 39.2. Any selection of a product or service that meets less accessibility standards due to a significant difficulty or expense shall only be permitted under an undue burden claim and requires approval from the DHS Office of Accessible Systems and Technology (OAST) in accordance with DHS

MD 4010.2.

36 CFR 1194.3(b) – Incidental to Contract, all EIT that is exclusively owned and used by the contractor to fulfill this work statement does not require compliance with Section 508. This exception does not apply to any EIT deliverable, service or item that will be used by any Federal employee(s) or member(s) of the public. This exception only applies to those contractors assigned to fulfill the obligations of this work statement and for the purposes of this requirement, are not considered members of the public.

36 CFR 1194.3(e) - Fundamental Alteration applies to the portions of this work statement where the item requires changes to comply with Section 508 and would render the acquired item useless for its intended purpose. Examples of this exception include but is not limited to items such as live event simulators, and complex graphical user interfaces where the business requirement is to display data onscreen to identify a visual relationship and it is impossible to provide the same information and functionality with text. This exception does not apply to the entire EIT as a whole. For instance, a topographical map (for visual representation consisting of nothing more than information 'requiring' a visual relationship between two or more visual elements that can't be accomplished textually) may qualify for an exception, but the administrative portions and report features of the system would not be exempt. All portions of this work statement are considered not exempt unless explicitly identified by the COR. The COR shall be contacted for an itemized list of items that are approved to apply this exception. The DHS Office of Accessible Systems and Technology (OAST) should be consulted prior to applying this standard.

2.0 GOVERNMENT TERMS & DEFINITIONS.

CAC – Common Access Card CG-913 – Office of Procurement Policy & Oversight COR – Contracting Officer Technical Representative DHS – Department of Homeland Security USCG – United States Coast Guard

3.0 GOVERNMENT FURNISHED INFORMATION AND PROPERTY.

The Government will provide the following property and information to the Contractor for work required under this contract:

3.1 Government Furnished Information.

The Government will provide the Contractor access to the systems needed for the work required under this contract

3.2 Government Furnished Property.

The Government will provide the workspace, equipment and supplies, including no more than one (1) workstation, necessary to perform the on-site portion of the services required in this Contract.

3.2.1 The Contractor shall use Government furnished property only for the performance of work under this contract, and shall be responsible for returning all Government furnished property in good working condition, subject to normal wear and tear.

4.0 CONTRACTOR FURNISHED PROPERTY.

The Contractor shall furnish all facilities, materials, equipment and services necessary to fulfill the requirements under this contract, except for the Government Furnished Property specified in this performance work statement (PWS 3.0).

5.0 REQUIREMENTS.

The Contractor shall provide support to integrate acquisition data from the Coast Guard’s Contract Information Management System (CIMS) ), Core Accounting System (CAS), Financial Procurement Desktop (FPD), Aviation Logistics Management Information System (ALMIS), Naval Electronics Supply Support System (NESSS), Coast Guard’s Acquisition Performance Management System (APMS), and SAS Business Intelligence (BI) system into the Coast Guard Acquisition Directorate’s (CG-9’s) established acquisition data mart to support the Coast Guard in developing acquisition performance metrics, measures and management reports.

5.1 Data Extraction. The Contractor shall identify acquisition data from the source systems’ tables and work with the CG-9 Data Integration Team to pull data into APMS. The extraction process must refresh and process the complete data sets daily.

5.1.1 The Contractor shall transform the data from CIMS, CAS, ALMIS, NESSS, and FPD into the existing acquisition data mart that standardizes all variable sets to include creation of variables for use in acquisition reporting that are not part of the underlying systems.

5.2 Data Mart. The Contractor shall work with the CG-9 Data Integration Team to load all the data in a data mart available for BI users for canned and ad-hoc reporting.

5.2.1 The Contractor shall work with the CG-9 Data Integration Team to provide the data sets and Online Analytical Processing (OLAP) cubes that subset and organize data for the Coast Guard acquisition community. The Contractor shall work with CG-9 Data Integration Team to establish and configure/format all information maps for each data set to include the creation of custom variables.

5.2.2 The Contractor shall work with the CG-9 Data Integration Team to provide customized web-based reports and BI dashboard portlets for use by acquisition users.

5.2.3 The Contractor shall verify and validate existing documentation. The Contractor shall include, as a minimum, table name; data set name; label, type, length and format of all variables; description of data and dependent processes. The Contractor shall provide this documentation 30 days after award and updates as requested by the government.

5.2.4 The Contractor shall create canned and ad-hoc acquisition performance and management reports that shall be available for end users. Examples include pre-award reports that identify all pending awards and their status in the acquisition process, and post-award reports identifying all active contracts/orders and their status. The Contractor shall provide these reports to the Government as requested.

5.3. Status Reports The contractor shall provide monthly status reports to the Contracting

Officer, and COR via electronic mail. This report shall include a summary of all work performed, including an assessment of technical progress, schedule status, and any concerns or recommendations from the previous reporting period.

6.0 REFERENCES.

6.1 APMS Financial Data Mart Reference Guide

PWS Sec 7.0 Deliverables on the next page

7.0 DELIVERABLES.

The Contractor shall consider items in BOLD as having mandatory due dates.

ITEM PWS DELIVERABLE / EVENT DUE BY

1 1.10 Kick-Off Meeting Not later than five (5) business days after award.

2 5.2.3 Documentation 30 days after award and updated as requested by the Government.

3 5.2.4 Ad Hoc and Canned Reports

5 business days after requested by the Government.

4 5.3 Status Reports 5 business days after the end of the previous month

8.0 PERFORMANCE REQUIREMENTS SUMMARY (PRS).

The PRS table reflects the deliverables considered by the Coast Guard to be most important for the successful performance of this contract. This includes the expected standards of performance and positive or negative incentives.

CONTRACTOR SUPPORT SERVICES FOR THE U.S. COAST GUARD OFFICE OF

PROCUREMENT POLICY & OVERSIGHT (CG-913)

Objectives Required Service Performance

Standard

Incentives (positive or negative)

1. Data Extraction

Extract data to transform into data sets.(PWS 5.1)

No missing tables from the daily download based on the acquisition data as identified by the Government.

If the Contractor demonstrates repeated failure to meet requirements of PWS 5.1 in any given month of the performance period, as determined by the Contracting Officer with input from the COR, the results may be reflected in Contractor’s performance evaluation.

2.

Documentation and Reports

Provide documentation for Acquisition performance reports

Accurate and timely delivery (unless Government causes delay)

If the Contractor demonstrates repeated failure to meet requirements of PWS 5.2.4 in any given month of the performance period, as determined by the Contracting Officer with input from the COR, the results may be reflected in the Contractor’s performance evaluation.