CCaR_System_Support_II_PWS_(2018).pdf

PERFORMANCE WORK STATEMENT (PWS)

FOR

COMPREHENSIVE COST AND REQUIREMENTS (CCaR) SYSTEM

SUPPORT II

EGLIN AIR FORCE BASE, FLORIDA

Prepared By: AFLCMC/EBF, Eglin AFB, FL

8 November 2017

This document is compliant with FAR 37.602

TABLE OF CONTENTS

SECTION 1 – DESCRIPTION OF SERVICES………………………………………...………… 3

1.1 Operational Support…………………………………………………………………… 4

1.1.1 On-Site Help Desk Function………………………………………………… 4

1.1.2 Data Entry and Data Validation……………………………………………... 5

1.1.3 Data Reconciliation and Interface Support..………………………………… 5

1.1.4 Training and Instruction…………………………………………………….. 5

1.1.5 Software and Administration………………………………………………… 6

1.1.6 Integration Support………………………………………………………….. 6

1.1.6.1 SER 113390 – Schedule Functionality…………………………….. 6

1.2 General Information………………………………………………………………..….. 6

1.2.1 Place of Performance…………………………………….…….….………

1.2.2 Period of Performance…………………………………….…………....……. 6

1.2.3 Contractor Personnel……………………………………….………..………. 6

1.2.4 Qualifications………………………….…………………………….………. 6

1.2.5 Proficiency……………...………………………………………….………… 7

1.2.6 Meetings……………………………..…….……………………

1.2.7 Privacy Act………………….……………….………………………………..7

1.2.8 Normal Duty Hours…………………………..……….……….…………..… 7

1.2.9 Travel………………………….…………………….….……………………. 7

1.2.10 eCMRA………………………….………………………….……....…….… 7

1.2.11 Contract Management…………………………...…………………………. 7

1.2.12 Mandatory Provision…………..…………………………………………

1.3 Security………………………………………………………………………………… 8

1.3.1 Systems Security………………………….…………………………………. 8

1.3.2 Clearance and Disclosure…………………..………………………………… 8

1.3.3 Security…………………………………..………….………………………. 8

1.3.4 Contractor Identification Badges ……...…….………………....……………. 8

SECTION 2 – SERVICE SUMMARY………………………………………………….………. 9

2.1 General Tasks……………………….…………………………………………………. 9

2.2 Budget Analyst (BA)…………..……………………....………………………………. 10

2.3 Database Administrator (DBA)…………………………………………….…………. 10

SECTION 3 – GOVERNMENT FURNISHED PROPERTY AND SERVICES……………….… 11

3.1 Government Furnished Property and Services………………………………………… 11

SECTION 4 – APPENDICES……..……………………………………………………….……… 11

4.1 Appendix A……..……………………………………………………………………… 11

PERFORMANCE WORK STATEMENT (PWS)

Comprehensive Cost and Requirements (CCaR) System Support II

8 November 2017

1. DESCRIPTION OF SERVICES

Background: The Comprehensive Cost and Requirement (CCaR) System is an automated requirement management system which assists program and financial managers in planning, budgeting, and execution of those requirements. CCaR interfaces with a variety of Department of Defense (DOD) financial software tools including:

Automated Business Services System (ABSS)

General Accounting and Finance System (GAFS/BQ/G2)

System Metric and Reporting Tool (SMART)

Specialized Accounting and Finance Enterprise System (SAFES)

Defense Enterprise Accounting and Management System (DEAMS)

Local Contract Writing System

CCaR creates a central repository of requirement, cost, and budget information - reducing the time required to review, manage, program, and execute financial resources as well as standardizing the formats used across multiple organizations for these efforts. Additionally, the system is mandated for use by the

Air Force Life Cycle Management Center (AFLCMC) for all financial information and is used by their staff to review execution and other related subjects versus tasking calls to users locally.

Because of the complexity of the CCaR System these following positions are required to support organizations in funding, planning, execution, and reporting requirements within organizations and at higher headquarters. These positions will also provide functional and administrative expertise, and train personnel to adapt and maintain business processes:

Experienced CCaR Business Analysts (BA)

Experienced CCaR Database Administrator (DBA)

Purpose: The purpose of this effort is to provide CCaR BA and DBA support to the following organizations:

Air Force Life Cycle Management Center Other Locations (AFLCMC/OL), Staffs at Eglin

Air Force Base (AFB), FL

Air Force Life Cycle Management Center Armament Directorate (AFLCMC/EB), Eglin

AFB, FL

Foreign Military Sales within Armament Directorate (AFLCMC/EB), Eglin AFB, FL

Foreign Military Sales within Armament Directorate (AFLCMC/EBH), Hill AFB, UT

Foreign Military Sales within Armament Directorate (AFLCMC/EBR), Robins AFB, GA

Air Force Test Center 96th Test Wing (AFTC/96 TW), Eglin AFB, FL

Air Force Test Center 412th Test Wing (AFTC/412 TW), Edwards AFB, CA

Air Force Test Center, 704th Test Group (AFTC/704TG), Holloman AFB, NM

Air Force Test Center HQ (AFTC/HQ), Wright-Patterson AFB, OH

Air Force Research Laboratory Munitions Directorate (AFRL/RW), Eglin AFB, FL

Arnold Engineering and Development Complex (AEDC), Arnold AFB, TN

1.1 Operational Support

The Contractor shall be expected to use the CCaR and Executive CCaR associated databases and interfaces for all science & technology (S&T) and acquisition organizations, programs, and appropriations for all budgets. The BAs and DBAs shall be experts relative to the functionality and operation of the CCaR and

Executive CCaR applications, and shall be well-versed in Air Force Acquisition, financial and requirement management processes in order to ensure maximum use of CCaR capabilities to manage programs. The

BAs and DBA shall also be experienced in the various Air Force Weapon Systems and the funding processes related to the research, development and purchasing of these systems.

The Contractor shall provide:

program support system integration testing and installation end-user training data migration consulting services to facilitate, compile, recommend, and prepare guidance regarding system Approval Flows as they pertain to acquisition/S&T business processes (including budget definition, business rules, user privileges, and definable general data fields) and to prepare implementation guidance.

on-site support to program personnel who require CCaR and Executive CCaR technical and subject matter assistance metrics and feedback to the identified government POC on system use and accuracies coordination of system improvements troubleshooting activities and resolve reconciliation issues to include other systems (such as Commander’s Resource Integration System (CRIS), Mechanization of Contract

Administration Services (MOCAS), Electronic Document Access (EDA), and Shared Data

Warehouse) user account administration activities and update various privileges based on the user’s role assist customer in setting up CCaR records linking association between the CCaR record and budgeting association setting up contract actions in the Contracts module setting up and running monthly reporting requirements report database issues and system enhancements via trouble ticket or System Enhancement

Requirement (SER) ticket support of the overall CCaR system.

1.1.1 On-site Help Desk Function: The Contractor shall provide support to customers in the usage and operation of the CCaR and Executive CCaR System. The Contractor must be available during customer’s duty hours to answer functional/technical questions, as well as correct identified data anomalies or database issues. Issues typically will take anywhere from five minutes to several hours to resolve with the customer. The BAs and DBAs will be serving three large organizations encompassing 62 sub-organizations with an on-system population of 855 users at any given time across a full range of functional experts using the various modules of the system to manage programs and projects.

1.1.2 Data Entry and Data Validation: The Contractor shall assist the customer in properly entering and structuring their financial data for optimal use of the CCaR application. The Contractor shall provide assistance and guidance on proper structuring of CCaR and Customer data in order to publish information to Exec CCAR per SAF/AQ, AFTC HQ, and AFTC Wing instruction.

1.1.3 Data Reconciliation and Interface Support: The contractor shall provide reconciliation module connectivity to Defense Finance and Accounting System (DFAS) records, SAFES, and to GAFS/BQ/G2 for commitment, obligations, and expenditures resulting in the ability to track the entire life of any managed appropriation. The Contractor shall ensure that data automatically downloaded through the reconciliation module and contracts module into the CCaR application is complete and accurate. The

Contractor shall ensure pertinent DFAS data warehouse files are delivered on a daily (workday) basis and that the financial data within the system has the ability to automatically generate charts and reports to include, but not limited to, the following:

Budget Execution Review (BER)/Business Management Review (BMR)

Assistant Secretary of the Air Force for Acquisition (SAF/AQ) “Snake Charts” and

Detailed Program Forecasts (1537 charts)

Financial Management Spend Plans

1.1.4 Training and Instruction: At the request of the Government/customer organizations supported, the Contractor shall provide on-going contractor-developed/government approved training materials and shall provide customers with training on the usage of all CCaR and Executive CCaR features and functions. The Contractor shall provide written documentation of CCaR and Executive CCaR changes on which users will need to be trained. Coordination will be made with the CCaR POC at each supported organization to ensure an adequate number of training sessions are offered within timeframes necessary to support those personnel. The content and frequency of the training sessions are at the discretion of the customer. Training will be conducted in classroom, via customer appointment with BAs and DBAs, and via user guides. Such training guides, and related training materials shall become property of the government. Common training curriculum includes, but is not limited to:

Basic CCaR usage for financial managers

Advanced CCaR usage and Reconciliation Module Training for financial managers

CCaR Reporting and Oversight Training for senior managers

CCaR Contracts Module Training for contracting personnel

CCaR Forecast Training

1.1.5 Software and Administration: The Contractor shall interface with the developer of CCaR, Integrated Data Services (IDS) technical department in the identification and correction of technical issues. The Contractor shall investigate any identified data or software related issues and relay their findings to the appropriate IDS technical focal point. The Contractor shall also ensure that the data/technical issues are corrected and implemented and shall interface with the customer on the progress and schedule of identified issues. The Contractor shall perform all administrative functions for the CCaR database including, but not limited to:

Addition/Deletion/Modification of system users, authorities, and privileges

Addition/Deletion/Modification of budget information

Addition/Deletion/Modification of customizable data fields

Addition/Deletion/Modification of customizable workflows

Configuration of global database settings and features

Resetting or System user passwords

1.1.6 Integration Support: The Contractor shall provide CCaR technical expertise necessary to modify the CCaR/Exec CCaR software application to support the needs of integrating AFTC business processes into CCaR. A surge CLIN will be established as additional software modifications/changes are identified, however, currently, the following capability within CCaR and Exec CCaR is required for AFTC.

1.1.6.1 SER 113390 – Schedule Functionality: Request that the ability to upload project schedules be added to the program tool, Program Schedule chart be available in the BMRs and that the Schedule in

Web CCaR be published to Executive CCaR. This is a need for AFTC I&M program monthly, mid and end of year reporting. These are not MAR programs therefore use of SMART to import these schedules is not an option.

1.2. General Information

1.2.1. Place of Performance: Work shall be performed at Eglin AFB, FL; Hill AFB, Utah; Robins AFB, GA; Edwards AFB, CA; Holloman AFB, NM; Wright Patterson AFB, OH; Arnold AFB, TN.

1.2.2 Period of Performance: The contract shall be awarded for a 12-month basic period with four 12-month options. The basic period shall begin on or about 1 October 2018.

1.2.3 Contractor Personnel: Contractor employees shall identify themselves as contractor personnel by introducing themselves or being introduced as contractor personnel and displaying distinguishing badges or other visible identification for meetings with Government personnel. In addition, contractor personnel shall appropriately identify themselves as contractor employees in telephone conversations and in formal and informal written correspondence.

1.2.4 Qualifications: The contractor shall provide the necessary on-site personnel with the skills and qualifications to fully complete the required activities contained in this PWS. The BAs and DBAs will have a minimum of two-year continuous experience within the last five years working within, supporting and administering a CCaR system within an acquisition related workforce such as the AFLCMC, 96TW, and AFRL. The minimum of two years hands-on, knowledgeable experience is required based on the fiscal environment, the manning levels and limited manpower to become both experts in this system and also conduct financial and program management duties within organizations. The BAs and DBA will be

IDS Certified CCaR Administrators. The DBA/BAs will support users in 62 sub-organizations encompassing 855 users (See Section 1.1)

1.2.5 Proficiency: The contractor shall be proficient with the CCaR system, Oracle, and the Microsoft suite of software to include Excel, PowerPoint, Word, Internet Explorer, and Outlook. The contracted

DBA should have a minimum of 10 years in-depth Oracle experience to include installation, management, and recovery actions. In addition, knowledge of Microsoft Project is preferred.

1.2.6 Meetings: The Contractor Business Support shall attend/facilitate meetings and working groups related to CCaR and its usage as requested by the customer as well as attend all IDS held meetings to discuss the system. Attendance should be conducted via video teleconference unless prior approval is obtained by the government program manager.

1.2.7 Privacy Act: Work on this project requires personnel have access to privacy information. Contract personnel shall adhere to the Privacy Act, Title 5 of the U.S. Code, Section 552a and applicable agency rules and regulations. The contractor shall accomplish training necessary to access government computer systems.

1.2.8 Normal Duty Hours: Contractor personnel are expected to conform to customer agency normal operating hours, exclusive of Federal holidays. Normal duty hours will be from 0700 to 1600, Monday -

Friday. However, the workday may begin as early as 0600 and end as late as 1800. The requirement for

BAs and DBA is no more than 80 hours of work per 2-week pay period. Normal duty hours are eight hours per day. Hours of support may vary over the course of the contract. The contractor shall adhere to base closures and hours of operation. From time-to-time, weather or other unusual situations, such as increased Force Protection, dictate changes to the normal duty hours. When decisions on base closure are made during normal non-duty hours, such decisions will be transmitted via radio, television announcement, recall process, etc. and will be considered sufficient notification that the contractor should not report for duty and that the Government shall not be billed for work not performed. If the installation or facilities are closed, the Government may request the contractor to establish a temporary work environment and a schedule that will allow requirements to be met. The Government may allow the contractor to establish telework support with a schedule to allow all requirements to be met.

1.2.9 Travel: Services – The Government anticipates travel will be required in support of administration of the CCaR System. Travel cost must be pre-approved by the Contracting Officer or Designee before travel is accomplished. Travel Cost is reimbursed in accordance with FAR 31.205-46. No overhead or fees shall be added.

1.2.10 eCMRA: The Contractor shall report ALL Contractor labor hours (including subcontractor labor hours) required for performance of services provided under this contract for the all organizations serviced under this contract via secure data collection site. The contractor is required to complete and fill in all required data fields using the Contractor Manpower Reporting Application (eCMRA) web address:

http://www.ecmra.mil/. Reporting inputs will be for the labor executed during the period of performance during each Government fiscal year (FY_, which runs October 1 through September 30. While inputs may be reported any time during the FY, all data shall be reported no later than October 31 of each calendar year. Contractors may direct questions to the help desk at above link.

1.2.11 Contract Management: Only a duly appointed Contracting Officer, and no other government personnel, is authorized to change the specifications, terms, and conditions under this effort. The http://www.ecmra.mil/

Contractor’s Representative shall coordinate all activities and resolve any potential issues through the

Contracting Officer Representative (COR).

1.2.12 Mandatory Provision, Performance of Service During Crisis Declared by the National

Command Authority or Overseas Combatant Commander: IAW DODI 3020.37 (Continuation of

Essential DOD Contractor Services during Crisis) and aforementioned Air Force implementation, unless otherwise directed by an authorized government representative, it is determined services as identified in this PWS are NOT essential for performance during a crisis. The base could be closed because of security problems or other events. Unless otherwise notified by the government the contractor should listen to or watch one of the local television or radio stations for notification of a possible base closure.

1.3 SECURITY

1.3.1 Systems Security: The Contractor shall provide systems security engineering in accordance with

Air Force Instruction (AFI) 33-101 4.1 and AFI 33-202V1 4.2.1.2, 4.2.1.3, 4.2.1.7, 4.6.1., including preparation of Designated Approval Authority (DAA) interim and final packages. The Contractor shall limit database visibility and access to different users at the discretion of the government.

1.3.2 Clearances and Disclosure: The classification of tasks under this effort may range from unclassified to SECRET. All documentation required for security certification shall be the responsibility of the contractor and the client organization. All contractor personnel assigned to this effort shall possess and maintain eligibility for not lower than a current SECRET clearance. This position will involve working with potentially proprietary information and other information of a sensitive nature. The Contractor shall be required to sign a non-disclosure statement assuring the highest level of integrity and confidentiality.

The Contractor is required to provide current and accurate security clearance and security documentation for all of its personnel performing services on this contract when requested by the Government. When required to maintain access to required IT systems or networks, the contractor shall ensure that all employees requiring access complete initial and annual Information Assurance (IA) training, and maintain a current requisite background investigation. The Contractor’s Security Representative shall contact the

Command’s Security Manager for guidance when reinvestigations are required.

1.3.3 Security: The Contractor shall provide information and documentation to comply with the requirements identified in DD Form 254, DoD Contract Security Classification Specification, attached to this contract. The highest classification for these requirements is “SECRET.”

1.3.4 Contractor Identification Badges: Common Access Cards (CAC) - The Contractor’s PM or alternate shall complete all necessary documents for all Contractor personnel requiring access to Eglin

AFB. Common Access Cards (CAC) shall be required for all on-site Contractor personnel. The

Contractor’s PM shall ensure the Government representative in the local organization designated to authorize issuance of Contractor’s CACs (i.e. Trusted Agent (TA) receives a Visitor Request for each employee through the Contractor Verification System (CVS). Contractor personnel shall electronically submit application to the TA, once approved set up appointment at https://rapids-appointments.dmdc.osd.mil/ or go to the Eglin Military Personnel Section located in Bldg 210 to receive their CAC.

2. SERVICE SUMMARY

2.1 General Tasks:

PERFORMANCE OBJECTIVE PWS

Para

PERFORMANCE

THRESHOLD

SS #1

The Contractor shall provide expertise and guidance, as well as analyze problems that arise in the execution of the program and suggest solutions that can be derived through the use of the CCaR system.

1.1, 1.1.2, 1.1.3, & 1.1.5

95% of problems identified shall be closed within 5 days.

SS #2

The Contractor shall provide comprehensive

CCaR System applications training to include: Basic & Advanced CCaR usage, CCaR Reporting & Oversight for Sr.

Managers, CCaR Contracts Module and

Reconciliation Module Training

1.1.4 98% training accomplished/created within 30 days of

Government request.

SS #3 The Contractor shall provide technical expertise necessary to modify CCaR/Exec

CCaR

1.1.6, 1.1.6.1

Delivery dates are met.

Software will implement with less than two fixes.

SS #4 The Contractor shall be an IDS certified

CCaR Administrator. The Contractor shall be experienced with at minimum two years hands-on use of the system within an acquisition organization such as those covered here.

1.2.4 100% shall be required.

No deviations in proficiency.

SS #5

The Contractor shall report ALL contractor labor hours (including subcontractor labor hours) via http://www.ecmra.mil

1.2.10 The Contractor shall

completely fill in all required data fields using website. All Data shall be reported NLT

Oct 31 of each calendar year.

SS #6 The Contractor shall follow all security guidance provided by the installation.

1.3.1, 1.3.2, 1.3.3, & 1.3.4

100% of all security requirements shall be adhered to. No security deviations. The

Contractor must meet these requirements at all times during this contract.

http://www.ecmra.mil/

2.2 Budget Analyst (BA): Standard database assistance activities and skill set include, but are not limited to the following:

Must be IDS trained and certified

Must know the CCaR toolset and how to navigate, apply applications, and trouble shoot issues/disconnects for the customer organizations

Perform troubleshooting activities and resolve reconciliation issues

Perform user account administration activities and update various privileges based on the user’s role

Assist/train customer in setting up project plans to meet needs of the organizations

Assist/train customer in using application to perform monthly reporting requirements

Provide assistance in setting up contract actions in the contracts module

Assist/train the customer in linking association between the CCaR project plan and budgeting association

Assist in setting up and running monthly reports

Work with the DBA in reporting database issues to the contract company for upgrades to the system via trouble tickets

Assist customer in maximizing system capability

Provide in-classroom and one-on-one training as required by the Government

Be familiar with other systems to aid the customer in troubleshooting reconciliation issues

(such as CRIS, MOCAS, EDA, Shared Data Warehouse, and SAFES)

2.3 Database Administrator (DBA): Standard database maintenance activities and skill set include, but are not limited to the following:

Must be IDS trained and certified

Install Oracle database

Install CCaR and Looking Glass baseline data schema

Perform database backup and recovery of CCaR and Looking Glass

Set up and configure network connection-client/server, ODBC, JDBC, database link, encryptions, certificate server

Logical/Physical database design, familiar with ERD and Normalization process, Converting logical model into physical Database structure, implement Oracle/Sybase/SQL server

Databases, database conversion, unload/reload database

Monitor/tune the application performance, troubleshoot any problem, and optimize the database

Familiar with SQL and PL/SQL programming, mastering of writing/debugging package procedure, view, trigger, and database migration script

Perform database migration, includes client, web, and server migrations

Perform database upgrades

Perform data manipulation as necessary to download data correctly into the application

Monitor disk/CPU/IO usages to ensure continuous operation

Create and maintain database interfaces between multiple database applications

Familiar with network protocols, mail server, MAPI, firewall, certificate server

Master Windows 2000/2003/2008/2010 server

Familiar with Windows scrip, job scheduling

Capable of Client/server programming, installation and set up

Set up Web server and application server for Web programming

Perform database migration, database reorganization and optimization

Upgrade and migrate software and hardware

Install software patches for Oracle or CCaR application

Monitor database space, usage, optimizes performance

Maintain daily activities, i.e. batch jobs scheduler, DFAS and SAFES daily loads and other database link maintenance

3. GOVERNMENT FURNISHED MATERIAL AND EQUIPMENT

3.1 Government Furnished Material and Equipment: The Government will provide access to requisite program and technical information, as necessary, to carry out the requirements of this PWS. The

Government will provide the server and Oracle database software for this operation. The Government will provide access to facilities, equipment, and technical information necessary for the performance of this effort. Items will include office space, desk with chair, telephone, Automated Data Processing Equipment, office automation software used the program office, and access to electronic mail. In addition, the

Government will provide access to appropriate databases, to include passwords and account names as required for contractor personnel to perform the required tasks. Any items or process improvements created during this contract will remain the property of the Government upon contract completion.

4. APPENDIX

4.1 Acronyms and Abbreviations

ABSS Automated Business Services System

BA Budget Analyst

BER Budget Execution Review

BMR Business Management Review

GAFS/BQ Integrated Accounts Payable System

CAC Common Access Cards

CCaR Comprehensive Cost and Requirement

CRIS Commander’s Resource Integration System

CVS Contractor Verification System

DAA Designated Approval Authority

DBA Database Administrator

DEAMS Defense Enterprise Accounting and Management System

DFAS Defense Finance and Accounting System

DTIM Defense Transaction Interface Module eCMRA Contractor Management Reporting Application

EDA Electronic Document Access

MOCAS Mechanization of Contract Administration Services

S&T Science & Technology

SER System Enhancement Requirement

SDW Shared Data Warehouse

TA Trusted Agent