Attachment 6 10182023 TSOW 5 Requirements Analysis and Process Improvement.pdf

Enterprise Services Center (ESC)

FINANCIAL SUPPORT SERVICES

Task Statement of Work (TSOW)

Requirements Analysis and Process Improvement Branch

ATTACHMENT 6

October 18, 2023

Version 1

Statement of Work Requirements Analysis and Process Improvement Branch, AMK-350

Financial Services Support Contract December 01, 2023

Introduction and Overview The Financial Services Division of the Enterprise Services Center (ESC) excels in providing financial management services within the Government. Currently, we provide these services for the entire Department of Transportation (DOT) as well as five non-DOT agencies. The Requirements Analysis and Process Improvement Branch (AMK-350) of the Mike Monroney Aeronautical Center is at the forefront of optimizing and enhancing system functionalities within the Enterprise Services Center (ESC). Our dedicated team of requirements analysts excels in managing both internal and external requests for system changes and updates across platforms, including Delphi, PRISM, and Reporting, to name a few. Additionally, we are actively involved in the onboarding of new customer agencies. The Requirements Analysis and Process Improvement Branch is proud to oversee the ESC Robotic Process Automation (RPA) program. We employ state-of-the-art tools like UiPath to deliver RPA services to various divisions within the ESC. This dedication to innovation and efficiency highlights our commitment to ongoing process improvement and addressing the ever-changing needs of our stakeholders.

Scope General: The contractor shall provide all personnel, management, supervision and other items or services as necessary to perform financial support related to administrative and accounting services as identified in the statement of work below. Please reference the contract SOW for general requirements. The contractor will work tasks as assigned for

AMK-350.

Description of Work:

Business Analyst – (EDQ), level II The EDQ business analyst will provide business management functions such as data quality, data analysis, data migration, requirements identification and analysis, financial planning, analysis and control of data as it pertains to business requirements. These functions include business process analysis to describe and create defined business and operations controls and processes.

The analyst works across the enterprise to execute data quality initiatives and contributes to the foundation for all data-driven decision making. Drives development of solutions to provide business partners with the insight they need to understand the quality of the data they use to make business decisions on a daily basis.

The contract personnel perform data profiling across multiple data types, validate the data quality through business rule development, review and analyze data profiling results, and participate in the data investigation workshops. Use the approved methodology and tools to identify, analyze and investigate data for the value and accuracy relative to a particular asset as well as a given data element. Principle duties and responsibilities consist of the following (but are not limited to):

• Creation of data quality mappings and rules based on identified requirements

• Profiling and assessing business unit data to identify anomalies

• Working with the Business Units to identify data quality rule requirements against identified anomalies

• Active contribution in all SAFe ceremonies

These activities will include Enterprise Data Quality (EDQ) exception reporting as well as Business Process Re-engineering (BPR) for the Financial Services Division of ESC. These activities will support Do Not Pay initiatives, reducing the number of improper payments, subledger to general ledger exception reporting, and overall improved data quality.

Secondary Duties for Business Analysts Perform comprehensive functional and/or technical review of application configuration in customer's Oracle Financial system or other financial system; document issues discovered and recommend corrective actions, including:

• Functional module set ups

• SLA rules and set ups

• Projects set ups (in the Projects Accounting modules)

• CEMLI Review

• Functional /Technical Documentation

• Bulk File Upload

• Feeder System interfaces

• Conversion Activity/Recommendations

Support the Oracle Service Request (SR) lifecycle by reporting Oracle software issues discovered within customer's Oracle Financial system during the performance of the above tasks and activities, including:

• Create SRs

• Track and report on SRs

• Follow up on SRs with Oracle

• Collaborate with Oracle Support on researching and troubleshooting related to SRs through resolution.

• Coordinate with customer/customer's contractors to apply Oracle patches to test instances

• Support testing of Oracle patches

• Coordinate with customer/customer's contractors to migrate tested/approved patches to production

• Closeout SRs

ESC standard operating procedures will be provided by ESC. These are living documents and may require periodic updates and/or changes.

Reporting

All labor expended shall be substantiated by a summary sheet for the invoiced period listing employee name, date, labor category, number of hours actually worked and supported by the information/report from CMIS. The summary should also include a narrative describing the work performed during the month and description of issues or difficulties.

Travel

Travel is not required for this task.

Work Schedule

Contractor support shall report to duty or remote location Monday thru Friday. Contractor must be present during core hours – 9:30 am to 11:00 am and 1:00 pm to 2:30 pm daily.

Contractor shall neither report to work before 6 am nor work later than 6 pm unless approved in advance by COR.

Program requirements may dictate work to be performed at times and days other than those prescribed. Under these circumstances, the COR may authorize workload. In an instance where the work is “Over and Above” the CO may negotiate the change.

For Telecommuting, reference PWS Paragraph 2.10. These are the general requirements for teleworking. When task assignments require performance at the duty location; teleworking is not an option for the position. In this task, the Accounts Payable General Clerk cannot perform their work assignments in a remote location.

Communications Skills: Contractor personnel should be able to effectively communicate with other individuals at all levels within organizations and with differing economic, social, cultural or educational backgrounds. They should have skills in oral and written communications and the ability to exercise tact in dealing with others in a courteous and diplomatic manner.

Quality Assurance Government personnel may from time-to-time observe Contractor operations. These personnel will not interfere with Contractor performance.

At no time shall the Contractor’s personnel be supervised by FAA managers or other FAA or Government personnel. FAA will provide, as needed by the Contractor, limited assistance in the form of technical and policy guidance through the assigned COR.

Performance Requirements The contractor service requirements are summarized into Task Deliverables that relate directly to the mission. The acceptable quality levels (AQL) briefly describes the minimum acceptable quality levels of service required for each requirement. These thresholds are critical to mission success.

The Method of Surveillance and Corrective Actions/Disincentives shall be provided as an attachment in the QASP.

Task Deliverable(s) Applicable Standard(s) Acceptable Quality Levels (AQL) Business Analysts EDQ Administration

Task COR: Cindy Drummond, cindy.drummond@faa.gov, 405 954-1877 mailto:cindy.drummond@faa.gov

Enterprise Services Center (ESC)