6973GH-20-R-00138 ETRS Attachment 03 SOW Template.docx

Electronic Transaction Reporting Solution (ETRS) Statement of Work (SOW)

Electronic Transactional Reporting System (ETRS)

Statement of Work (SOW) Template

(ENTER COMPANY NAME HERE)

for Enterprise Services Center 6500 South MacArthur Boulevard Oklahoma City, OK 73125

(DATE)

v1

THIS PAGE INTENTIONALLY LEFT BLANK

Table of Contents

Electronic Transaction Reporting Solution (ETRS) Statement of Work (SOW) Template

Electronic Transactional Reporting System (ETRS) Statement of Work (SOW) Template

ETRS SOW Template

1. Background The Mike Monroney Aeronautical Center (MMAC) is a major organizational complex representing the Federal Aviation Administration (FAA), Department of Transportation (DOT), and other Federal agencies. The Aeronautical Center supports the safe and efficient operation of national and international aviation systems and provides competitive business solutions for its customers.

The Enterprise Services Center (ESC) is an organization located at MMAC. ESC operates as a Federal Financial Shared Service Provider; one of four federal financial management Centers of Excellence as designated by the Office of Management and Budget (OMB) to provide integrated business services and solutions to the Federal Government. ESC resides under FAA’s Regions and Center Operations Line of Business (ARC) and operates under a “fee-for-service” principle, which encourages business-like decisions creating more cost awareness and increased customer focus.

In furtherance of its Shared Service Provider designation, ESC focuses on external sales to the federal government market and improving internal operations. ESC actively pursues new business in support of the Government’s initiative for cross-agency servicing using Shared Service Providers, thereby realizing economies of scale. ESC consists of the Enterprise Business Office (AMK-10), the Information Services Division (AMK-200), and the Financial Services Division (AMK-300).

The Information Services Division (ISD) (AMK-200) provides information technology life cycle management in support of the ESC service portfolio, to include support to financial services and all aspects of technology and media services. The activities augment and amplify the business processes of local and national federal missions at departmental and agency levels supported by the Office of Management and Budget (OMB) Shared Service Provider (SSP) and General Services Administration (GSA) designations that the ESC maintains.

2. Objective Federal Aviation Administration (FAA), Mike Monroney Aeronautical Center (MMAC), Oklahoma City, OK, the Enterprise Services Center (ESC) operates under the Department of Transportation (DOT) as a shared service provider for financial services and systems within the Federal government. ESC is seeking to replace an unsupported reporting solution.

Within the Financial Systems, ESC has a broad spectrum of reporting avenues, and ESC’s customers have an equally broad set of report consumption needs. Oracle Discoverer is the ESC customers most relied upon transactional reporting tool due to its ability to meet standard, flexible reporting and ad hoc data consumption needs.

ESC’s Discoverer is a web-based, on premises installation with access integration through Oracle E-Business Suite (EBS), version 12.2. It currently contains approximately 55 subject areas, 2,000 folders and 45,000 workbooks. ESC’s Discoverer supports approximately 2,000 active reporting users, of which, roughly half construct their workbooks. The execution rate for reports is 3,000 per day and 65,000 per month. Reports vary in complexity but are predominately-tabular data results with a small mix of crosstab, or pivot table, layouts. ESC’s Discoverer End User Layer (EUL) is primarily based upon the Oracle Federal Financials EBS and Unison Procurement Request Information System Management (PRISM) data model designs with some custom folders included for specialized reporting. While these two data sources are noted specifically, additional sources exist.

The objective of this request is for the contractor to create a Statement of Work (SOW) for Section 2. Objective, paragraph Assumptions and paragraph Considerations, and all Tasks listed under Section 4 Requirements/Tasks, sub-sections 4.1 and 4.2. of the Statement of Objectives (SOO) which will be incorporated into the overall SOW. The Government’s overall objective of the SOO is to replace Oracle Discoverer with a scalable reporting solution that provides functionality similar to Discoverer. The Enterprise Transactional Reporting Solution must include a reporting tool that supports multiple data sources for relational, non-relational and analytical databases. It must also include a pre-built automated Oracle Discoverer migration utility.

To facilitate ESC’s implementation of the new reporting solution, pre-built transactional EBS reports and an EBS-based reporting data model must be included.

ESC is also seeking consulting services for implementation and training of the proposed solution.

Assumptions

· The contractor will migrate up to 250 existing ESC Discoverer Reports. ESC will migrate other existing ESC Discoverer Reports using the pre-built migration tool.

· The contractor will train ESC staff on both the technical and functional aspects of the proposed Enterprise Transactional Reporting tool.

· ESC will train end-users (procurement, financial, etc.) based on training and knowledge transfer detailed in this SOO.

· ESC will be responsible for all non-migrated Discoverer Reports based on training and knowledge transfer detailed in this SOO.

· ESC will be responsible for all security for the migrated reports based on training and knowledge transfer detailed in this SOO.

· The solution includes up to five individual environments to support Configuration Management (CM) processes. These include, but are not limited to Production, User Acceptance Test, System Integration Test, Development, and Disaster Recovery (or High Availability for Cloud based solution).

Considerations Please address the following in preparing your response:

· Indicate the deployment models available for your solution.

· On premise

· Cloud-based – e.g. Software-as-a-Service

· Specify the Product Support model(s) available for your solution.

· Specify the Licensing model(s) available for your solution.

Vendor Response:

3. Period of Performance The base period of performance is for 9 months from contract award with an optional six-month extension.

4. Requirements/Tasks The Contractor must provide all personnel, transportation, supervision and other items or services necessary to perform support and implementation services of the Enterprise Transactional Reporting Solution as defined in this document.

The government will provide any hardware if deployment is on premise.

4.1 Procurement of Enterprise Transactional Reporting Tool

Task 1: The Contractor must provide an Enterprise Transactional Reporting Tool with the following minimum requirements:

VENDOR’S RESPONSE:

Enterprise Reporting Capabilities

Oracle EBS

Unison PRISM (Not required)

Objective: The procurement of an Enterprise Transactional Reporting tool that meets ESC requirements.

4.2 Implementation Services

Task 2: Project Management Support for the Enterprise Transactional Reporting Solution Implementation

VENDOR’s RESPONSE:

Task 3: Initial Enterprise Transactional Reporting Solution Tool Installation and Configuration

VENDOR’S RESPONSE:

Task 4: Implementation of pre-built EBS transactional reports

VENDOR’S RESPONSE:

Task 5: Implementation of EBS-based reporting data model

VENDOR’S RESPONSE:

Task 6: Migration of up to 250 existing ESC Discoverer Reports

VENDOR’S RESPONSE:

4.3 Knowledge Transfer and Training Services

Task 7: Knowledge Transfer Sessions

VENDOR’S RESPONSE:

Task 8: Training for Reporting Tool

VENDOR RESPONSE:

4.4 Post Implementation Support Services

Task 9: Re-Creation of Reports Consulting

VENDOR RESPONSE:

5. Deliverables and Delivery Schedule The following is a table of required deliverables. Deliverables must be electronically submitted to the CO and COR. All deliverables (Plans, Presentations, Reports, Schedules, White Papers, etc.) must be completed using Microsoft Office 365 products, unless otherwise specified in the table below.

The FAA has up to 10 business days to review each deliverable. The government will accept or reject the deliverables in writing. In the event of the rejection of any deliverable, the contractor must be notified in writing by the COR and given the specific reason(s) for rejection. The contractor will be given a reasonable number of working days, relative to the assignment, to correct the rejected deliverable and return it to the CO and COR for approval.

Deliverable Number

10 days after Government notification from COR

The Contractor is not required to work onsite on federally recognized holidays unless requested by the FAA. Those holidays are listed below:

Any other day designated by Federal statute, executive order, or presidential proclamation.

Local determinations relating to adverse weather conditions, national emergencies, energy conservation, MMAC/Organizational determinations, etc., may require the Center to close. During such periods of closure, when Contractor employees are not permitted to work on-site, the contractor may work via telework.

6.2 Hours of Operation

The Contractor is responsible for conducting business, between the hours of 6:00 am - 6:00 pm Monday thru Friday except Federal holidays, when the Government facility is closed due to local or national emergencies, administrative closings, or similar Government directed facility closings. There could be times the Contractor may need to work outside of these hours, and this is acceptable if a request is made to the COR and it is approved. The Contractor will not be reimbursed when the Government facility is closed for the above reasons. The Contractor must at all times maintain an adequate workforce for the uninterrupted performance of all tasks defined within this PWS when the Government facility is not closed for the above reasons. When hiring personnel, the Contractor must keep in mind that the stability and continuity of the workforce are essential.

6.3 Place of Performance

The contract is to be perform primarily at the Mike Monroney Aeronautical Center (MMAC), 6500 South MacArthur Blvd, Oklahoma City, Oklahoma, unless otherwise mutually agreed upon between the Government and the Contractor.

The Contractor must be available to perform the above tasks remotely, using FAA-provided remote access capabilities, during off-hour periods, government closures, holidays, and upon FAA request. Telework capability may be authorized but must be approved by the COR, and CO.

When any such day falls on Saturday, the preceding Friday is observed and when any such day falls on Sunday, the following Monday is observed.

6.4 Personnel Security Requirements

Contractor personnel performing work under this contract must either have or be able to acquire a National Agency Check with Inquiries (NACI) at time of the proposal submission, and must maintain the level of security required for the life of the contract.

6.5 Kickoff/Periodic Progress Meetings

The Contractor agrees to attend a kickoff meeting convened by the CO. The COR and other Government personnel as appropriate will meet in bi-weekly meetings with the Contractor to review the Contractor's performance. These meetings must be at no additional cost to the Government.

6.6 Project Schedule

The contractor agrees to submit a schedule for all tasks required to complete specified outcomes and deliverables to the COR for review and acceptance. The schedule is to be submitted in Microsoft Project format, version 2016. The schedule is to be submitted within ten (10) business days from the date of the initial contract kick off meeting with the COR and be updated throughout the contract.

6.7 Periodic Project Status Reports

The contractor agrees to submit a weekly Contractor Project Status Report to the COR as an Adobe .pdf or Microsoft Word document every Monday pursuant to CDRL A002. These reports must be at no additional cost to the Government.

6.8 Contracting Officer Representative (COR)

The COR will be identified by separate letter. A letter of designation issued to the COR and sent to the Contractor states the responsibilities and limitations of the COR, especially with regard to changes in cost or price, estimates or changes in delivery dates. The COR is not authorized to change any of the terms and conditions of the resulting order.

6.9 Key Personnel

The Government considers the following roles as key personnel: Project Manager (PM), Alternate Project Manager (APM), Reporting Tool Expert(s) and Discoverer Migration Expert(s). Key Personnel are reported under CDRL A001.

Project Manager:

The Contractor must assign a Project Manager and Alternate Project Manager responsible for the performance of the work specified in accordance with the terms and conditions of the contract. The PM/APM must have full authority to act on behalf of the Contractor for all issues pertaining to contract administration of the contract. The PM/APM is considered Key Personnel as addressed in AMS 3.8.2-17. Due to the scope of this contract, it is envisioned that the Project Manager/APM will be only a quarter time resource. The PM/APM must be able to read, write, speak, and understand English. Qualifications for all key personnel are listed below.

The PM/APM must at a minimum have a Bachelor’s degree, successfully completed 24 hours of college level management or business courses, and have a minimum of five (5) years of project management or managerial experience in either private industry or the Government.

The PM/APM must also possess the following qualifications:

The Contractor PM/APM must be responsible for the following:

Reporting Tool Expert(s):

The Contractor must provide Reporting Tool Expert(s) responsible for the installation and configuring of the Enterprise Transactional Reporting Tool as well as the use of the pre-built EBS transactional reports and EBS-based reporting data model in a multi-tenancy environment.

Evidence should include customer information, dates engaged in effort, description of the requirement(s), offeror’s role, size and number of tenants by environment, number of pre-built reports used by the EBS modules, examples of data elements added to the EBS-based reporting data models to accommodate reporting needs and EBS Release / Version numbers.

Discoverer Migration Expert(s):

The Contractor must provide Discoverer Migration Expert(s) responsible for assisting ESC staff in the migration of existing ESC Discoverer reports and re-creating existing ESC Discoverer reports in a multi-tenancy environment.

Evidence should include customer information, dates engaged in effort, description of the requirement(s), offeror’s role, size and complexity of requirements, number of End User Layers (EUL), metadata, and reports migrated by type, and EBS Release / Version numbers.

6.10 Identification of Contractor Employees

All contract personnel attending meetings, answering Government telephones, and working in other situations where their Contractor status is not obvious to third parties are required to identify themselves as such to avoid creating an impression in the minds of members of the public that they are Government officials. They must also ensure that all documents or reports produced by Contractors are suitably marked as Contractor products or that Contractor participation is appropriately disclosed. Contractors will be required to wear badges at all times while on the campus of the Mike Monroney Aeronautical Center. Badges may be obtained at the Visitor’s Center at the main gate of the MMAC.

6.11 Contractor Travel

Travel may occur for customer requirements meetings and other customer support needs at the cost of the government. Travel will be paid in accordance with the Federal Travel Regulations (FTR) after advanced approval from the contracting officer through the COR. Travel costs for this contract will be a separate line item with a not to exceed amount stated on the award.

6.12 Data Rights

The Government has unlimited rights to all documents/material produced under this contract. All documents and materials, to include the source codes, scripts, and/or processes of any software, produced under this contract will be Government owned and are the property of the Government with all rights and privileges of ownership/copyright belonging exclusively to the Government (see AMS Clause 3.5-13 Rights in Data - General (October 2014)). These documents and materials may not be used or sold by the Contractor without written permission from the Contracting Officer. All materials supplied to the Government will be the sole property of the Government and may not be used for any other purpose. This right does not abrogate any other Government rights.

6.13 Organizational Conflict of Interest

Contractor personnel performing work under this contract may receive, have access to or participate in the development of proprietary or source selection information (e.g., cost or pricing information, budget information or analyses, specifications or work statements, etc.) or perform evaluation services which may create a current or subsequent Organizational Conflict of Interests (OCI) as defined in AMS 3.1.7-4. The Contractor must notify the Contracting Officer immediately whenever it becomes aware that such access or participation may result in any actual or potential OCI and must promptly submit a plan to the Contracting Officer to avoid or mitigate any such OCI. The Contractor’s mitigation plan will be determined to be acceptable solely at the discretion of the Contracting Officer and in the event the Contracting Officer unilaterally determines that any such OCI cannot be satisfactorily avoided or mitigated, the Contracting Officer may affect other remedies as he or she deems necessary, including prohibiting the Contractor from participation in subsequent contracted requirements which may be affected by the OCI.

6.14 Training Comment by Walswick, Monique (FAA): Corrected numbering The Contractor shall provide qualified employees to meet the tasks set forth and be responsible for Contractor employees. The Contractor shall provide verification to the Government that all employees receive all mandated training through the Monthly Status Report provided to the COR(s). These training classes are directed/mandated by Government regulation, FAA Administrator (AOA-1), or an FAA Security Element. This training shall be included within the task order.

6.15 Invoicing

All invoices submitted under the resulting contract must be reviewed and approved by the CO and COR for payment. Invoices should be submitted within 30 calendar days from the last day of the month to be invoiced and should track costs at the CLIN level to provide auditable details for payment approval.

6.16 Contract Management Information Management (CMIS) Tool

Contract employees providing services under this contract are required to enter their hours into the ESC CMIS system on a daily basis in order for ESC to accurately track labor costs per project, and provide a baseline for future budget projections. The Contractor Project Manager will receive direction on how to access and enter information into CMIS and will assure their staff is weekly entering accurate data. The appropriate project and task codes must be utilized for this project.

The Government will provide, without cost, the facilities, equipment, materials and services listed below. The Government property and services provided as part of this effort must be used by the contractor only to perform under the terms of the resulting contract. No expectation of personal privacy or ownership using any FAA electronic information or communication equipment must be expected.

7.2 Property

7.2.1 Facilities

The Government will provide facilities at the Mike Monroney Aeronautical Center, 6500 South MacArthur Boulevard, Oklahoma City, Oklahoma 73125, or other local Government leased/owned facilities, including all utilities, telephone, janitorial services and furniture for Contractor employees performing on tasks unless otherwise noted.

7.2.2 Equipment

The Government will provide the following:

7.3 Materials

The Government will furnish the following:

Government telephones are provided for use in conducting official business. Occasionally, Contractor employees are permitted to make calls that are considered necessary in the interest of the Government.

7.4.2 Computers and Internet and Electronic Mail (E-mail)

All Internet and electronic media access accomplished by Contractor employees (utilizing Government-furnished equipment) must be for official Government business and in support of task requirements. Use of computer systems for personal use is prohibited.

All e-mail access and use by Contractor employees must be in support of the individual’s official duties and task responsibilities. All information created, transmitted, received, obtained, accessed, or in any way captured electronically, using FAA e-mail systems is the property of the Government.

7.4.3 Canvassing, Soliciting, or Selling

Contractor employees must not engage in private activities for personal gain or any other unauthorized purpose while on Government-owned or leased property, nor may Government time or equipment be utilized for these purposes.

BEST PRACTICE. A best practice is a method or technique that has consistently shown results superior to those achieved with other means, and that is used as a benchmark for industry standards.

COOKBOOK. A document for an Contractor or administrator to follow that details the requirements and steps to install and configure a particular software package on a given hardware platform.

CONTRACTOR. A supplier or vendor awarded a contract to provide specific supplies or service to the government. The term used in this contract refers to the prime.

CONTRACTING OFFICER. A person with authority to enter into, administer, and or terminate contracts, and make related determinations and findings on behalf of the government. Note: The only individual who can legally bind the government.

CONTRACTING OFFICER'S REPRESENTATIVE (COR). An employee of the U.S. Government that is appointed by the contracting officer to administer the contract. Such appointment will be in writing and will state the scope of authority and limitations. This individual has authority to provide technical direction to the Contractor as long as that direction is within the scope of the contract, does not constitute a change, and has no funding implications. This individual does NOT have authority to change the terms and conditions of the contract.

CONTRACTOR PEFORMANCE ASSESSMENT REPORTING SYSTEM. This government application tracks contractor performance on various contracts throughout the federal government as reported by federal agencies they served.

DEFECTIVE SERVICE. A service output that does not meet the standard of performance associated with the Performance Work Statement.

DELIVERABLE. Anything that can be physically delivered, but may include non-manufactured things such as meeting minutes or reports.

ESC DELPHI. Delphi is the federal Department of Transportation’s financial accounting system. Twenty different agencies have accounting data stored in the Delphi system.

KEY PERSONNEL. Contractor personnel that are evaluated in a source selection process and that may be required to be used in the performance of a contract by the Key Personnel listed in the PWS. When key personnel are used as an evaluation factor in best value procurement, an offer can be rejected if it does not have a firm commitment from the persons that are listed in the proposal.

KNOWLEDGE TRANSFER. The act of a contractor communicating to designated customer staff, providing a variety of knowledge and information including, but not limited to the product, processes, procedures, best practices, lessons learned, and tips. The contractor should use various means of communication which can include one-on-one mentoring, observation/shadowing, question and answer sessions, documentation references, and white board discussions.

PHYSICAL SECURITY. Actions that prevent the loss or damage of Government property.

QUALITY ASSURANCE. The government procedures to verify that services being performed by the Contractor are performed according to acceptable standards.

QUALITY ASSURANCE Surveillance Plan (QASP). An organized written document specifying the surveillance methodology to be used for surveillance of Contractor performance.

QUALITY CONTROL. All necessary measures taken by the Contractor to assure that the quality of an end product or service meets contract requirements.

STANDARD OPERATING PROCEDURE. A standard procedure (s) to be used across the reporting system that addresses the daily, weekly, monthly, semiannual, annual and unique procedures that are not standard across IT as a whole. These documented procedures must be put in place to ensure services and products are consistently delivered to the customer.

SUBCONTRACTOR. One that enters into a contract with a prime Contractor. The Government does not have a private contract with the subcontractor.

WORK DAY. The number of hours per day the Contractor provides services in accordance with the contract.

WORK WEEK. Monday through Friday, unless specified otherwise.

All data deliverables shall be prepared and delivered in accordance with the corresponding CDRL items specified under the contract

While the list below constitutes potential reporting requirements that may apply to the contract, the Government reserves the right to require additional documentation not specified herein depending on the tasking. All data shall be delivered FOB Destination as specified in the CDRL. The Contractor shall furnish the CO one copy of the transmittal letter submitting any data requirements to the cognizant task COR and MMAC PM.

A001 – Contract Key Personnel Roster A002 – Weekly Status Report A003 – Government Furnished Property (GFP) Report

Procurement of Enterprise Transactional Reporting Tool

Task 1 – Procurement of Enterprise Transactional Reporting Tool Purchase of an Enterprise Transactional Reporting Tool meeting the minimum ESC requirements.

Implementation Services

Task 3 – Initial ETRS Tool Installation and Configuration Contractor must validate the Enterprise Transactional Reporting Tool is successfully installed and configured in a development environment.

Task 4 – Implementation of Pre-built EBS Transactional Reports Contractor must validate the pre-built EBS Transactional Reports are working properly and as intended.

Task 5 - Implementation of EBS-based reporting data model Contractor must deliver best practices of utilizing the EBS-based reporting data model to ensure future product support. Contractor must provide guidance and support to ESC staff.

Task 6 – Migration of up to 250 existing Discoverer Reports Contractor must provide guidance and support to ESC staff on utilizing the pre-built automated Discoverer migration utility. Contractor must be responsible for the migration of up to 250 existing Discoverer Reports.

Knowledge Transfer and Training

Post Implementation Support Services

Task 9 – Re-Creation of Reports Consulting

Contractor must provide guidance and support to enable the ESC Report Team staff in the re-creation of existing non-migrated reports in the Enterprise Transactional Reporting Tool.

ETRS SOW Template Page 18