SOURCES SOUGHT ATTACH 1 - DRAFT SOW.pdf

STATEMENT OF WORK

DATA ANALYTICS SUPPORT

1.0 Scope

The objective of this effort is to obtain system analysis, software and system engineering and analysis, development, application and customization, and technical writing services to assist the Southwest Regional Maintenance Center (SWRMC) with carrying out its duties and responsibilities to manage and track ship repair and associate contracts, purchases, funds administration and related metrics using the NAVSEA Power BI and the Fusion Suite of applications.

2.0 APPLICABLE DOCUMENTS

The following documents are applicable to the work with in this contract.

Software Engineering Institute's Capability Maturity Model Integration Process

12207.0 Institute of Electrical and Electronics Engineers (IEEE) Standard for Information Technology - Software Life Cycle Processes Department of Defense Federal Information Security Management Act (FISMA) guidance SECNAVINST 5239.3C, Department of the Navy Information Assurance Policy OPNAVINST 5239.1C, Navy Information Assurance Program DoD Instruction, 5200.02, Personnel Security Program SECNAV Manual, M-5510.30C, DON Personnel Security Program DOD Regulations, 5300.2-R, Personnel Security Program SECNAVINST 5510.30 (Series), Department of Navy Personnel Security Program SECNAVINST 5510.36 (Series), Department of Navy Information Security Program DOD Manual, 5220.32-M, National Industry Security Program Operating Manual (NISPOM) DOD Instruction, 8500.01, Cybersecurity DOD 5220.22-M (Series), National Industrial Security Program Operating Manual (NISPOM) National Security Decision Directive 298 (Series), National Operations Security Program (NSDD) 298 DOD Manual 5205.02 OPNAVINST 3432.1 (Series), DON Operations Security DoDI 5200.48 Controlled Unclassified Information (CUI)

3.0 TECHNICAL REQUIREMENTS

3.1 Program Management

3.1.1 Identify a Project Manager to organize, plan, schedule, implement, control, analyze and report on all elements of this contract and directly coordinate knowledgeable resources to identify work strategies and provide recommendations for current and planned program management tasking to meet specified objectives.

3.1.2 Prepare reports for the Comptroller and Comptroller staff. Coordinate work efforts of the contractor workforce in support of SOW Section 3.1.

3.1.3 Prepare, present and discuss the status of the contract by completing a monthly Contract Status Report

(CDRL A001).

3.1.4 Provide project management support to include project design and planning, plan execution, monitoring and management of projects/initiatives, project status/risks, and tracking/reporting. (CDRL

A002, CDRL A004)

3.1.5 Provide strategic communication and stakeholder support to include communication/message development, stakeholder engagement, status reporting, and site visits (as necessary).

3.1.6 Align identified comptroller goals, projects, and programs to support overarching business purposes of the SWRMC Code 600 Finance Department.

3.1.7 Provide Navy ERP & Navy program evaluation and performance management to include current state needs-assessments, development of evaluation methodology/criteria, cost-benefit analysis (pre- or post-program implementation), and ongoing performance monitoring.

3.1.8 Provide integration of commonly used data systems, collaborative platforms, and internal systems to facilitate creating meetings, agenda building, meeting management, Fusion Suite site sustainment, and industry and best practices research.

3.1.9 Provide innovation support services to identify ways to improve processes and outcomes.

3.1.10 Provide data collection, analyses, and metric development to produce actionable data shared among internal and external stakeholders.

3.1.11 Provide financial and Fusion support services to shape the program management implementation strategy and process.

3.1.12 Provide strategy development, visualization, information/data mapping, technical requirements development, recommended data solutions/architectures, test strategies, and executive products and services to support Center initiatives.

3.1.13 Assist strategic workshops and meetings/events to support road mapping strategic planning way forward.

3.1.14 Provide visual information mapping techniques to rapidly develop concepts or simple visual products from stakeholder interviews, technical documentation reviews, visual workings sessions, and client product review sessions.

3.1.15 Work with internal and external stakeholder groups to develop new and improved capabilities based on use cases and business needs through facilitated working sessions leverage user centered design best practices; assist with development teams on requirements improvement and implementation.

Internal stakeholders are the departments within SWRMC. External stakeholders include JIRA, PACFLT, Financial Management System (FMS) II etc.

3.1.16 Support the development of business outcomes and associated metrics and measures that illustrate the return on investment (ROI) of process improvement and automation efforts.

3.1.17 Assist with preparation of draft agendas, financial/budget reports, minutes, trip reports, attendance lists, action item lists, program reviews, design reviews, and recommendations; maintain historical records of these meetings for ready retrieval and reference; compile reference information packages for ready access in support of meeting attendance and action item and deficiency resolution; obtain meeting spaces, communicate with attendees and coordinate the distribution of meeting materials prior to and upon the conclusion of meetings/conferences/workshops; distribute meeting notices and minutes in accordance with Center common practices and procedures. (CDRL A003)

3.1.18 Support this effort with recommendations for the development and deployment of the organization’s metrics and data strategies, data requirements, data migration, and testing requirements to enable continuous improvement of Business Intelligence by applying data management and data base modeling expertise to plan and manage data quality, integration, scaling, and redundancy; support by performing quality assurance of data elements to validate report accuracy.

3.2 Financial Management

3.2.1 Assist in developing reports and deliverables that will facilitate the Comptroller in drafting and maintaining the budget of the projects and/or programs following the appropriate work breakdown structure to support the appropriation being managed for the project/program; ensure that all budgets are planned in the authoritative financial system in accordance with the command’s business rules.

3.2.2 Provide financial analysis support to key support areas associated with financial reconciliation, Financial Improvement and Audit Readiness (FIAR), and organization financial statements; assist in compliance with the Financial Auditability and Integrity Act to ensure that all support documentation is available to support this requirement; provide financial analysis and recommend processes or improvements to processes associated with FIAR.

3.2.3 Assist with risk assessments and implement corrective actions to enhance internal controls over financial reporting and business processes. Assist with internal control testing frameworks to validate compliance with internal and external audit requirements. Assist with pre-audit readiness assessments/internal control programs to ensure compliance with financial reporting requirements and address potential audit findings.

3.2.4 Assist with root cause analysis on audit findings, material weaknesses, and control deficiencies, including Independent Public Accounting (IPA), Notices of Finding and Recommendations (NFR).

Coordinate NFR feedback from Subject Matter Experts (SME) to determine any necessary revisions to draft NFRs. Track and report NFR response status, collecting source files and performing crosswalks to previously identified deficiencies to inform the root cause analysis and Corrective Action Plans (CAPs).

3.2.5 Provide technical assistance with the development of CAPs to address deficiencies, ensure sustainability and ascertain that the root cause of the deficiency is resolved. Leverage tools such as the Audit Response Center (ARC) Tool and Deficiency Tracking Tool (DTT) for documentation, communication, monitoring of audit processes and reporting remediation efforts. Monitor CAP implementation, track remediation progress and validate controls upon CAP completion.

3.2.6 Act as a liaison between stakeholders and independent auditors to streamline communication and ensure alignment throughout the audit process. Facilitate audit response initiatives, including the review of audit samples and NFRs, gathering and packaging of key supporting documents (KSD), coordinating documentation exchange, addressing auditor inquiries and resolving issues.

3.2.7 Assist with maintaining comprehensive documentation of internal control assessments, CAPs, and risk management activities to support certification assertions. Assist with preparation and submission of annual statements detailing of effectiveness of internal controls, deficiencies and progress toward remediation.

3.2.8 Deliver tailored training programs and workshops on CAP development, internal controls, audit readiness and remediation best practices. Maintain a repository of guidance documents, FAQs, and case studies to support workforce education and awareness of FIAR initiatives.

3.2.9 Define and track Key Performance Indicators (KPI) to measure progress toward FIAR objectives.

Provide regular reports on remediation efforts, audit outcomes and risks. Establish feedback mechanisms for continuous improvement based on audit findings and stakeholder input.

3.2.10 Assist with development and execute change management strategies to ensure smooth adoption of FIAR initiatives. Establish clear communication channels to share updates, successes and challenges.

Conduct regular stakeholder meetings and briefings to maintain alignment on goals and expectations.

3.2.11 Provide financial analysis support to include research accounting errors, recommended corrective actions, and administrative support to document all accounting transactions.

3.2.12 Assist in ensuring all appropriate costs are accounted for in the budget of the project and/or program they support.

3.2.13 Provide management analysis and forecasting needs in support of RMC initiatives as well as data calls and external activities to include PACFLT, CNRMC and NAVSEA.

3.2.14 Assist with knowledge transfers of financial management, policies, regulations, and processes to the workforce.

3.2.15 Assist the government in the preparation of reporting for annual budget process; assist the government with fiscal management to include monitoring reports, budget drills, financial and manpower analysis, and cost analysis.

3.2.16 Assist with preparing documents and artifacts for government to review in response to financial data calls and audits. Provide insight to the Comptroller on emerging and changing Department of Defense financial policy, laws, and regulations that may impact business rules and operations.

3.2.17 Support data integrity efforts through proper data tagging and data associations to advance analytical capability and responsiveness.

3.3 Accounting

3.3.1 Support development and implementation of activities aimed at maintaining and improving the general health of the Center’s financial management processes, people, and capabilities, including support to budget, accounting, data reconciliation, and system modernization. Data reconciliation may include, but is not limited to, reconciling data between systems needed for data transfers, or reconciling data that is mined as part of a data cleansing and organizing process. Financial Operations activities shall incorporate due consideration for security, such as data sensitivity, legal, or other regulatory issues, contingency operations, and recovery of financial information.

3.3.2 Provide assistance in support services to the Center Comptroller, including:

Provide assistance in support services for the Government Travel functions Provide assistance in management of the Government Travel Charge Card Provide assistance in administrative functions for the Defense Travel System Provide assistance in support services for the Government Payroll functions Assist as a Defense Civilian Payroll System Customer Service Representative Provide assistance in Navy ERP Work Force Management customer service support and trainings

Provide assistance in support services for the Vendor Pay functions Provide assistance in Funds Control functions to include processing various types of funding instruments and obligating documents Assist with Monitoring and validating Dormant Account Review, Quarterly (DARQ) Review requirements Assist management of the Reimbursable Work Orders (RWO) policy implementation and sustainment Assist in Mock and Year End Close efforts Provide assistance in support services for the General Accounting functions Support and assist in efforts resulting from audit requirements Assist compiling statistical information from financial data extracted from various financial systems Provide assistance in reporting financial conditions, reconciling financial discrepancies, and providing documentation to support recommended corrective actions Assist with maintaining status and performance metrics Provide assistance in support services for the Budget administrative and execution functions

3.4 Business Intelligence (BI)

3.4.1 Perform comprehensive technical and analytical support by bringing together skills, technologies, and innovative business practices and data visualization tools to solve business problems using a combination of gathering, organizing, and distributing financial information to improve the Comptroller’s strategic decision-making and performance. .

3.4.2 Perform advanced analytics in strategic business decision-making methodologies throughout the strategic life cycle including scenario planning, mathematical modelling, analytical reasoning, predictive analytics, statistical analysis, and simulations.

3.4.3 Support Business Intelligence (BI) through requirements, development, deployment and sustainment of the Center’s data sources to include creation and use of BI reports to respond to multi-source complex data calls; provide support with creating and maintaining BI knowledge transfer artifacts, materials, BI software development lifecycle processes, data dictionaries, and end-user supporting documentation.

3.4.4 Develop, implement, and maintain Business Intelligence solutions that enable rapid analysis of operational data that support Center strategic and operational decision-making.

3.4.5 Develop and recommend data visualizations to link decision makers to the authoritative data, technical requirements, and test data in a meaningful and actionable way.

3.4.6 Develop analyses including as-is and to-be process modeling, requirements developing/mapping, data modeling, and functional/technical economic analysis of alternatives, and ensure consistent, standardized data input to authoritative data systems.

3.4.7 Employ business analytics to develop and use efficient, standardized data and testing methodologies to support the development of technical business system requirements, improved data analysis, and better testing strategies, to help solve complex business problems; ensure consistent, standardized data input to authoritative data systems to perform analytics that support operational and business decision-making methodologies and improved technical requirements.

3.4.8 Provide Predictive Analysis (PA) extracts or leverage data from existing sources to develop patterns, outcomes and trends. PA efforts will seek to develop risk assessments and alternative solutions to ensure customer functional and technical requirements are met while capitalizing on potential opportunities and/or avoid future risks. PA will support analyses to develop business forecasts.

3.5 Business Process Improvement

3.5.1 Support all aspects of Process Management, including Continuous Performance/Process Improvement

(CPI), with managing and analyzing data, metrics, and reports for program performance, special projects and risk analysis; assist the government in optimizing the use of disparate data sources for timely, accurate, and relevant inputs to critical business decisions/solutions.

3.5.2 Assist in the development of executive strategy, plans, and initiatives to include change management.

Development support of these plans is inclusive of analysis of current and proposed business practices, performance of organizational assessments, development of improved processes and procedures, and identification and tracking of major technical and programmatic issues. Support is also inclusive of the development and updating of strategies to support program requirements by collecting and analyzing data, preparing outlines, conducting analyses of alternatives, and conducting technical and programmatic assessments.

3.5.3 Perform process analysis, improvement identification, and root cause analysis.

3.5.4 Facilitate sessions to solicit information to adequately analyze and document processes.

3.5.5 Develop, maintain, and enhance specialized automation workflow tools using IT solutions to improve operational efficiency.

3.6 Learning & Development

3.6.1 Support the established Center Process, Tools, and Data Governance through change and configuration management with an objective of in-house knowledge transfer that provides the stakeholder with sufficient understanding and comprehension such that if the stakeholder wishes to become a mentor, trainer, or super-user, the user will be enabled and educated to do so with the instructional material provided.

3.6.2 Provide support for go-live of new solutions to quickly capture iterative improvements to inform requirements.

3.6.3 Deliver a report for each identified artifact that supports the training and communications of solutions (i.e. Training Slides, User Guides, Training Videos etc.).

3.6.4 Leverage training needs analysis to develop organizational learning strategy and design learning plans for the Center; advise the appropriate buy-versus-build training approach for instructor-led training, eLearning or blended solutions.

3.6.5 Support the design and development of training courses using industry standard training development software to create classroom, virtual, eLearning and micro-learning video solutions.

3.6.6 Work with subject matter experts (SMEs) to define learning requirements and objectives, organize learning modules and develop relevant training presentations, learning supplementals (e.g. videos, desk guides) and develop course evaluations.

3.6.7 Utilize and operate tools with power bi reports to deploy and maintain applications

3.6.8 Shall have the capability and experience to obtain licenses and intergrade work data to develop the tools in cooperation with the stakeholders.

3.7 Navy Enterprise Resource Planning (ERP) Migration

3.7.1 Develop, for each migration, a detailed, resource-loaded schedule as a comprehensive migration roadmap with clearly identified tasks, milestones, and interdependencies to yield full system migration through stabilization. The schedule shall be developed in accordance with an approved Work Breakdown Structure (WBS) for migrations. The Contracts Contractor schedule (CCS) shall include sequencing of all work products, deliverables, tasks, dependencies, interdependencies, task owners, resource requirements and durations.

3.7.2 Document a Contractor Risk Management Plan detailing the approach to integrate the contractor risk assessments into the risk management process.

3.7.3 Manage integration of various migrations' execution. Develop tracking and reporting mechanisms to ensure all release activities are identified, discussed, updated, reported on, and closed by the scheduled timeline.

3.7.4 Provide guidance on migration methodology with a focus on accounting and financial statement impact. Revise or produce new standard process documentation including templates, standard operating procedures (SOPs), and work guides to support all phases of migration activities. Review and provide feedback of any documentation aligned with identified audit/migration artifacts collected to ensure completeness, accuracy, and traceability to requirements as requested. Provide support to effectively respond to Notice of Findings and Recommendations (NFRs) issued against or arising from Budget Submitting Office (BSO) system migration.(CDRL A005)

3.7.5 Implement and codify continuous process improvement with an outcome focus on streamlined and effective migrations that avoid unnecessary risks or repetition of prior migration pitfalls.

3.7.6 Manage and provide status of metrics for all migration phases through completion of stabilization to effectively enable Government decision-making.

3.7.7 Conduct and coordinate outcome-based migration and stabilization communication sessions and implement communication strategy across all migration processes and phases with all relevant stakeholders.

3.7.8 Develop end-to-end business processes throughout all project phases of the migration to include Requirements Development and As-Is/To-Be Business Processes.

3.7.9 Facilitate data management of legacy data to Navy ERP throughout all project phases of migration to include Data Health Assessment, Data Cell/Migration, Data Mapping, Post-Migration Data Validation.

3.7.10 Perform planning, development, delivery and execution of cutover initiatives from migration through stabilization. Conduct final review of migrated data to validate all data was successfully migrated from an accounting and functional standpoint.

3.7.11 Perform data reconciliation to include reconciling data with financial statements and summary level departmental reporting, validation of line items loaded to general ledger accounts and budget line items. Generate reconciliation packages required to support yearly financial statements and audit activities.

3.7.12 Support end-to-end User Acceptance Testing (UAT) development, planning, and implementation through in-depth stakeholder coordination and monitoring.

3.7.13 Implement Organizational Change Management Strategy for migration stakeholders.

3.7.14 Recommend, manage, and provide training which effectively initiates and sustains knowledge transfer covering all applicable Navy ERP functional areas and is to be conducted as a predecessor to all migration phases through completion of stabilization and any other areas needed to support a comprehensive and successful system migration.

3.7.15 Provide end-to-end user management transition to yield a successfully mapped, transitioned, trained, and supported user base able to execute ERP functions.

3.8 SAFETY AND ENVIRONMENTAL REQUIREMENTS

The contractor shall comply with applicable document SWRMCINST 51008 and OPNAV M-5100.23. These requirements shall be incorporated into the Contractor's Safety and Health Program.

3.8.1 OCCUPATIONAL NEAR-MISHAP/INJURY/ILLNESS REPORTING AND DART RATE

The contractor shall verbally report all near-mishaps, incidents, injuries, and illnesses of contractor personnel related to the performance of this contract to SWRMC ESH Department Management and the COR immediately upon becoming aware of such an incident. An initial incident report utilizing the NAVSEA Standard Item 009- 74 form shall be provided to these same parties within eight (8) working hours of the incident. A final incident report of the same format, complete with root-cause analysis, shall be provided promptly after incident investigation has been completed.

The contractor shall provide an OSHA 300A report initially and annually thereafter to the SWRMC ESH Department and the COR. The report shall include Total Case Incident Rate (TCIR); and Days Away, Restricted, and Transfer (DART) rate data, along with hours worked for SWRMC during the annual period.

3.8.2 MISHAP PREVENTION AND ACCIDENT/INCIDENT INVESTIGATION

The contractor shall participate in SWRMC mishap prevention programs and processes as they relate to contractor personnel under this contract. The contractor shall support accident, incident, near-miss, and/or property damage critiques and investigations related to the performance of this contract, or when the contractor is witness to any accident, incident, near-miss, and/or property damage that SWRMC is critiquing and/or investigating. This includes interviews, support contractor personnel statements, photographs, and any other processes involved/included in the critique and/or investigation.

3.8.3 OCCUPATIONAL INJURY/ILLNESS DOCUMENTATION

The contractor shall maintain all records, documentation and reporting requirements associated with injuries and illnesses of contractor personnel related to the performance of this contract, as required by OSHA 29 CFR 1904, Recording and Reporting Occupational Injuries and Illnesses.

3.9 EMERGENCY ACTION PLAN

For all emergencies, SWRMC occupants and personnel located within SWRMC spaces at the time of an emergency will follow SWRMCINST 3440.4 Emergency Action Plan (EAP).

4.0. GOVERNMENT FURNISHED PROPERTY

Contractor will be provided a government laptop.

5.0 DATA DELIVERABLES

CDRL A001 – Contractor’s Progress & Status Report (Monthly) CDRL A002 – Contract Status Report (ECRAFT Report) CDRL A003 – Technical Report-Study/Services CDRL A004 – Record of Meeting/Minutes Report CDRL A005 – Transition-in Plan CDRL A006 – Transition-out Plan CDRL A007 – Cyber Security Workforce (CSWF) Report CDRL A008 – Trip/Travel Report

6.0 OTHER

6.1 Security

6.1.1 The contractor shall ensure all support contractor personnel shall be able to access Navy installations with a Common Access Card (CAC) within sixty (60) calendar days of contract award or date of hire. Any exceptions shall require written concurrence by both the applicable Department management personnel and the

COR.

6.1.2 Contractor employees must accomplish all training requirements as mandated by DOD, Navy, and SWRMC within the timeframe promulgated at the time of the training requirement. These requirements must be accomplished by all contractor employees, whether or not they possess a CAC or have access to NMCI/Navy computer-based training modules. The contractor must comply with changes and updates to training requirements by keeping support personnel in compliance with the most current instructions. Current training requirements include the following (subject to change):

Initial Orientation (Required once contractor checks in to SWRMC, One-Time Requirement) DON Records Management (Yearly Requirement) DOD Cyber Awareness Challenge (Yearly Requirement) DON Annual Privacy Training SWRMC Annual Security Refresher (Yearly Requirement) NCIS Counter-Intelligence Awareness Briefing (Yearly Requirement) Operation Security (Yearly Requirement) DoD Mandatory Controlled Unclassified Information (CUI) (Yearly Requirement) DON Derivative Classification (If SIPR is Required, Yearly Requirement)

6.1.3 The contractor shall comply with the security directives used regarding the protection of Controlled Unclassified Information (CUI), DoDI 5200.48 CUI. The contractor may receive unclassified informational materials from the Government that are marked as Controlled Unclassified Information (CUI). This information is not authorized for release to the general public. Pertinent information is to be released only to contractor personnel who have a need to know for the purpose of contract execution or as directed by associated document markings or distribution statements. The contractor shall take proper safeguards to ensure that any such material received will be properly protected from unauthorized or inadvertent disclosure. If there are any questions regarding the requirements for protection or the release of CUI, the contractor shall refer those questions to the ACO.”

6.2 Operations Security (OPSEC)

6.2.1 “Critical Information (CI) is an adversary’s target of choice. Seemingly harmless UNCLASSIFIED data combined with other conversations, presentations, e-mails or documents could reveal classified information.

Personnel will employ proper Operations Security (OPSEC) and protect Critical Information.” DO NOT

DISCUSS CRITICAL INFORMATION WITH PERSONS WHO DO NOT HAVE AN OFFICIAL “NEED TO

KNOW.”

6.2.2 All contractor personnel assigned to this contract must adhere to, and comply with applicable Operations Security (OPSEC) measures in accordance with DoD Directive 5205.02 Operations Security Program. The Contractor shall protect critical information associated with this contract to prevent unauthorized disclosure. For a full list of SWRMC’s Critical Information, see SWRMC Critical Information List, SWRMCNOTE 5510 of August 29, 2022

6.3 Place of Performance

This effort may require the contractor to be on-site at SWRMC facilities onboard Naval Base San Diego (NBSD) to support the requirements as directed by the COR. It is also possible that infrequent travel to CONUS locations outside the San Diego and Southern California area may be required.

6.4 Travel

Minimum (2) CONUS trips per year to support demonstration of reports to PACFLT. (CDRL A006)