Attachment 1 - Performance Work Statement.pdf

Department of the Navy Manpower and Reserve Affairs (M&RA)

Manpower, Analytics, and HR Systems (MAHRS) Directorate Performance of Work Statement

1.0 INTRODUCTION

The Department of the Navy (DON) employs just under or around 200,000 civilians at more than 1,326 naval activities throughout the world. The DON’s Total Force (active and reserve military, government civilians and contractor services personnel) provides the essential expertise, administrative and technical continuity, and quality-of-life program support necessary for the DON to meet its military mission. The Manpower and Reserve Affairs (M&RA) Manpower, Analytics, and Human Resources Systems (MAHRS) Directorate works in partnership with the other Assistant Secretary of the Navy for Manpower and Reserve Affairs (ASN (M&RA)) subordinate organizations such as DON’s Equal Employment Opportunity (EEO), OCHR and Office of Force Resiliency, the DON Total Force Human Resources community, DON Commanders and Department of War (DoW) key stakeholders to perform tasks and functions necessary for meeting the DON’s needs in human resources (HR) governance, information technology systems, and data analytics in support of new initiatives and current operations of the HR life cycle.

2.0 BACKGROUND

The MAHRS Directorate is an Echelon I organization reporting to the Secretary of the Navy via the ASN (M&RA). Specifically, MAHRS is chartered to oversee, develop, and maintain policy, on Total Force Manpower, HR Information Technology (IT) Systems and Total Force and HR Data while ensuring compliance with DoW and DON policies for HR system and data operations, certifications, and modernizations. MAHRS manages Human Capital (HC) and HR data architecture and integration solutions in support of DON and M&RA strategies; and leverages foundational data repositories, curates data attributes and modernizes towards an innovative Total Force environment enabling visualization and modeling to support decision making. MAHRS develops, delivers, and sustains HC business analytics and tools to improve and support data-driven decision making within the

DON.

The mission of DON’s Office of EEO is to advise senior leaders and management officials on any issues involving EEO, provide policy and guidance, manage all stages of complaint process to include counseling, investigation and adjudication, manage all stages of reasonable accommodation to support change in work environment or normal standard operating procedures that will enable an individual with a disability to have an equal opportunity to participate, and provides training.

3.0 PURPOSE

The purpose of this solicitation is to provide qualified, experienced, certified, subject-matter and technical expertise and management support within Information Technology, System and Data

Governance, Analytics, Human Resource Information Systems, and Equal Employment Opportunity to facilitate the overall objectives of the Department of the Navy, M&RA impacting the entire DON Total Force workforce and ultimately support the warfighter. The work effort is to provide experienced technical specialists, business analysts, and experts to maintain HR/IT governance, systems and database administration, MAHRS’ migration of infrastructure into the Navy’s Amazon Web Services (AWS) Cloud solution, Business Intelligence (BI), Oracle’s Enterprise Business Systems, and DON’s Jupiter data architecture and tools. Key tasks will align to:

(a) Human Capital Solutions Management: Oversee, support the development of, and maintain policy and governance on Total Force Manpower, HR-Information Technology Systems and HR Data while ensuring compliance with DoW and DON policies for HR system and data operations, certifications, and modernization;

(b) Human Capital Systems Operations: Oversee, manage, implement and sustain HC/HR- IT systems infrastructure, systems and applications, portals, and help desk operations in compliance with DoW and DON policies for HR systems; and modernize towards new and innovative systems enabling high performing day-to-day operations across the

DON;

(c) Total Force & HR Business Intelligence: Design, develop, deliver and sustain HC business analytics, tools, dashboards, reports, metrics, and models to improve and support data-driven decision making with the DON; and

(d) EEO: Support senior leaders and management officials on any systems issues, creation of policy and guidance, investigation, analysis and recommendations for adjudication, and develop training.

4.0 TASKS

4.1 Program Management. The contractor shall develop a program management plan, which will identify a primary POC to coordinate with the MAHRS Contracting Officer Representative (COR) (or designee) to address strategic, performance and operational issues, identify contractor staff in specific functional areas as identified within Sections 4.0 and 5.0 of this PWS, identify implementation and tracking plan for assigned tasks and deliverables by contractor staff, identify vacated position plan to fill required labor categories within 20 days due to staff turnover, virtually meet with MAHRS COR each month, or as requested, to discuss tasks status, anticipated risks, and staffing or performance issues towards successful performance of all tasks, and provide monthly status and progress reports to the COR (or designee).

4.2 System and Data Governance. The contractor shall support the MAHRS systems and data governance team in the formation and execution of systems and data governance framework, charters, business processes and standard operating procedures.

• Identify, collect and analyze total force manpower, human resources, and related systems and operational policies and procedures for completeness; documenting gaps and work with key stakeholders to draft and update artifacts

• Review key total force manpower and human resources documented workflows and processes to verify compliance to DoW, DON and related federal information technology, information assurance, and cybersecurity policies and procedures; and identify gaps and work with key stakeholders to draft and update artifacts

• Identify and maintain tracking plan of current and future tasks, to include current status, projected completion dates, and actions completed/to-be completed

• Perform audit finding management tasks for compliance with operational teams, per DoW/DON Risk Management Framework (RMF) policies, within assigned timeline of assignment

• Generate draft Business Case Analysis (BCA) and Business Enterprise Architecture (BEA) documents in support of manpower and human resource human capital strategy initiatives

• Collaborate with system and data stewards or data delivery teams to populate content (e.g., business taxonomies, data dictionary terms, data standards, mappings) in the Data Governance tools.

• Support the tracking and compliance to DON Chief Data Officer (CDO) and DON Chief Information Officer (CIO) policy and governance such as data standards, data cataloging compliance, and IT system reviews and compliance.

• Provide support to governance board logistics with support to developing agendas, tracking topic requests and action items, developing documentation and administrative support where needed.

4.3 Information Technology Solutions and Rationalization. The contractor shall assist MAHRS in the facilitation of total force manpower and human resources system and application portfolio management in compliance to SECNAVINST 5000.36A.

• Complete quarterly compliance review for systems within MAHRS’ Human Resources Management Portfolio utilizing the DoW’s Information Technology Portfolio Repository for the DON (DITPR-DON), and the DON’s Application and Database Management System (DADMS) systems; provide consolidate summary report of status, risks, and anticipated actions to resolve

• Provide support for DoW/DON portfolio management activities and processes in providing support to business capability documents, portfolio management processes and IT system certifications as required by the DoWI 5000.75 and associated policies

• Plan, track, document and manage projects, workload management, risks, task assignments, new or enhancement requirements, process improvements, timeliness, staff assignments, costs, recommendations and deliverables of system and application modernization initiatives for legacy and new enterprise solutions

• Analyze current and future program effectiveness, value, evaluate risks, prioritize and support the management of projects of new technology and requirements to ensure alignment with organizational strategies

• Develop communication strategies plan within the first four months of task order start date, which incorporates partnership engagement strategy with key stakeholders (e.g. Functional Area Managers (FAMs)) and operations in support of the DON’s HC/HR IT Portfolio

4.4 Data Analytics. The contractor shall assist MAHRS supporting advanced analytics in data mining, business analyses, data integrity, data acquisition, reporting and analysis of sophisticated and interconnected DON Total Force data models within DON’s Jupiter environment which drives strategic decision making by DON senior leadership.

• Applies working knowledge in the application of concepts, principles, and technical capabilities to perform varied tasks

• Develops and subsequently revises senior-level White Papers, Briefs or Communication products; on-time completion and delivery for scheduled or reoccurring products while completing ad-hoc tasks within defined timeline

• Maintains reporting, dashboards, and metric tracking tools or systems by continually updating data; meeting established data refreshed schedules

• Demonstrates attention to detail when compiling and reporting information; reviews work to ensure that information complies with quality standards

• Work assignments will vary in scope with assigned completion dates which will be tracked by MAHRS Division Heads; use of standard and specialized business software to assist in managing business processes and performance through Business Intelligence tools, such as Cognos Business Intelligence, and DoW’s Advana and DON’s Jupiter solutions, specifically Databricks and Qlik Sense.

4.5 Data Science. The contractor shall help drive innovation in an area focused on DON’s Manpower and HR Total Force workforce, through many data sources and processes, to propose and apply novel and adaptive analytic solutions to solve complex organizational and workforce business challenges or problems.

• Design and develop statistical analyses (including predictive, inferential, supervised, non-supervised, ensemble, and clustering/segmentation), visualize the output of statistical models, present and interpret the output of predictive models, and perform quality assurance tasks as assigned and tracked by MAHRS leadership

• Performs initial data Extract Transform Load (ETL) and cleaning as necessary in preparation for modeling

• Perform exploratory data analysis and model-fitting to reveal data features of interest to include machine learned and predictive modeling; bi-weekly updates on assigned models and products required

• Develop conceptual design and models, within 60-90 days as assigned, to address mission requirements, develop qualitative and quantitative methods for characterizing datasets in various states; and perform analytic modeling, scripting, and/or programming

• Maintains accepted standards for code and data documentation and versioning

• Work collaboratively and iteratively throughout the data-science lifecycle

• Design and develop analytics and techniques for analysis; and analyze data using mathematical and statistical methods

• Evaluate, document and communicate research processes, analyses, and results to customers, peers, and leadership using the data science methodology framework to produce repeatable, explainable data science modeling.

4.6 Analytics Visualization. The contractor shall provide various metrics, automation, and visualization analytics support and produce products to demonstrate total force manpower, HR and related data results in an easily digestible manner for technical and non-technical personnel from DON Senior leadership to Command-level program managers.

• Design and develop visualization products which take complex information from multiple data sources and create appealing interactive data visualizations of performance measures and other metrics

• Design, develop and support statistical and predictive analytics dashboards and reports utilizing Business Intelligence tools such as Cognos BI, Qlik, and Databricks

• Transform data sources into data tables within tools to include Cognos BI, Qlik, and Databricks

• Create data models within Qlik that join multiple data sets and tables

• Create and maintain report specifications and process documentations as part of the required data deliverables

• Communicate with key stakeholders and technical teams to achieve project objectives, delivering cross functional visualization solutions

• Development, maintenance and enhancement of the organization’s data infrastructure and reporting environment; and identifies and implements opportunities to improve or standup data- driven decision making across the organization

• Ensure all data management activities are conducted in accordance with high quality standards and compliant with DoW and DON regulations.

4.7 Data Architecture. The contractor shall provide enterprise-wide data design and optimization of conceptual architecture and data solution design projects (conceptual model, integration model, sourcing) in alignment with DON’s Total Force Manpower and HR portfolio and data strategy; and align designs and support goals as defined within National Security Strategy and Executive Orders.

• Collaborate with DoW and DON IT domains to support the goals of MAHRS in alignment with DON CDO and improve the availability of trusted data for decision making and insights

• Generate high level operational concept documents, describing the interactions between the subject architecture and its environment, and between the architecture and external systems

• Utilizing Jira or similar project management tools, create, modify, maintain and document baselines for transformation efforts and standardizations across solutions to DON CDO policies and regulations; and translate enterprise or business needs into long-term information architecture patterns and solutions

• Provide data modeling and data validation services that produce flexible, extensible data structure design solutions that support effective business decisions; and create and manage multiple data design deliverables including data models, data diagrams, data flows and corresponding metadata within designated timeline

• Assist in the development, implementation and sustainment of various strategic data architecture initiatives around master data management, data quality, data management policies/standards, data governance and metadata management

4.8 Data Engineering. The contractor shall provide data engineering support to the data architect in implementing and executing the DON’s and MAHRS’s Data Strategy and High Level Total Force Data Hub to include data modeling, data hub development and engineering in support of executing the implementation plan. This includes engineering support to the Total Force Data hub and its associated hubs in the DON’s data and analytics environment Jupiter in support of the HC/HR Data Domain.

• Provide engineering expertise and assistance in the development, implementation and sustainment for data architecture and data hub implementation

• Develop engineering and implementation plans in support of data hubs, data acquisition and data modeling activities to lay the infrastructure to support data driven decision making leveraging the DON’s data and analytics platform

• Support development and engineering of data sets, data processes and data acquisition to support the data hub activities and development

• Oversee Databricks clusters, to include ensuring that they are in alignment with DON rules and guidelines, and to document all cluster parameters for both internal and external use

4.9 Windows System Administrator. The contractor shall be responsible for managing and supporting day-to-day Microsoft Windows system administration activities for infrastructures within the DON’s On-Premise and AWS environments; providing technical expertise and support of DON’s critical business systems and associated support applications within the MAHRS portfolio.

• Assess systems and applications in accordance with DoW Secure Technical Implementation Guides (STIG) and/or Security Requirement Guides (SRG)

• Generate and interpret Assured Compliance Assessment Solution (ACAS) scans to identify system vulnerabilities and monitor remediation efforts or mitigation strategies

• Continuously monitor to assess security and privacy controls in compliance to DoWI 8510.01, Risk Management Framework (RMF), to assess the effectiveness of the controls to achieve and support sustainment of MAHRS’ Human Resources Civilian Portfolio (HRCP) System’s Authority to Operate (ATO)

• Installation, configuration, and advanced troubleshooting of MS Windows Operating Systems

• Installation, configuration and advanced troubleshooting for IIS, Tomcat and Apache

• Assess and resolve networking assigned issues associated with vLan tagging, sub-netting, routing, link aggregates, LACP, etc. as configuring virtual networks and devices that leverage specific network technologies is required

• Manage, update, patch and maintain infrastructure hardware to include Virtual Servers, Physical Servers, Storage Area Network device, HP Blade Enclosures Blade servers and 3PAR Storeserv Storage Arrays

• Support tasks associated with migration of MAHRS On-Premise infrastructure and systems into Navy’s AWS

• Maintain Active Directory environment; and setup and maintain system and application user accounts as defined by MAHRS’ policy

• Document and submit Domain Name System (DNS) server updates within Navy and DoW DISA Domains

• Assess and resolve connectivity, communication and technical issues with MAHRS’ systems and applications to include Defense Civilian Personnel Data System (DCPDS), Benefits GRB- Platform Suite, EEO Suite (IComplaints and NEAT), HRLink, Department of the Navy Civilian Authoritative Data Source (DONCADS) Oracle database, MRIT and related MAHRS software

• Analyzes and resolves problems associated with the operating system’s servers, hardware, and applications software. Detects, diagnoses, and reports Window related problems on servers, including system failure analysis and recovery; insuring the consistency and integrity of file systems

• Complete assigned service tickets through MAHRS’ service ticketing system in support of MAHRS IT portfolio

• Monitor all database log files to detect errors and potential problems. Analyze throughput processing to provide tuning alternatives and more effective/efficient CPU utilization. Monitor database disk space allocation and utilization

4.10 REMOVED

4.11 Informatica ETL Administration. The contractor shall be responsible for analyzing, developing, testing and maintaining data Extract Transform Load (ETL) extraction procedures utilizing Informatica power center from a variety of data sources within DoW and DON.

• Perform and support Informatica ETL application installation, configuration, updates and patches

• Provide guidance on Informatica technical solution implementation, performance analyses of data issues, interprets implications of design, and help to ensure that data ingestion design meet business and solution needs

• Assess and identify Oracle DBMS optimization or tuning requirements to maximize system performance and efficiencies

• Database administration support to multiple databases within MAHRS’ Civilian HR Portfolio, including DONCADS, Benefits GRB Platform Suite, EEO Suite and various Oracle or related relational databases adhering to OPM, DoW, or DON HR regulations and mandates

• Data warehousing functions to DONCADS utilizing IBM’s Cognos BI and Informatica ETL power center tool sets; integrating DoW, DON and Office of Personnel Management (OPM) Oracle databases within DONCADS

• Design, develop, and maintain Informatica ETL power center scripts to support automated DONCADS data interfacing to DON’s Jupiter data repository

• Analyze, design, develop and maintain Informatica ETL power scripts in support of data interface programs between Oracle databases for the purposes of extracting and combining information from different databases, consolidation of similar databases, improving performance, streamlining existing interfaces and generating queries/reports

• Maintain, upgrade, test, and verify Informatica ETL power scripts between DoW DCPDS/ DoW’s Enterprise Personnel System and DON DONCADS/Jupiter environments; monitor nightly interfaces and resolve any errors encountered

• Perform daily monitoring of all database log files to detect errors and potential problems. Analyze throughput processing to provide tuning alternatives and more efficient/effective CPU utilization. Monitor and maintain database disk space allocation and utilization. Troubleshoot and resolve any user reported Oracle database problems

• Complete assigned service tickets through MAHRS’ service ticketing system in support of MAHRS IT portfolio

4.12 Data and Interoperability Reporting. Contractor shall be responsible for the design, development, implementation, and maintenance of reports and extracts utilizing Oracle Cloud Human Capital Management (HCM) and Cognos Business Intelligence (BI) products.

Oversee the design, development and maintenance of complex analytical queries, reports, and visualizations within Oracle Transactional Business Intelligence (OTBI) and BI Publisher.

• Analyze, document, design, develop and implement OTBI/BI Publisher data exchange, or extract, solutions between DoW’s Oracle HCM system, DoW’s Enterprise Personnel System, Authoritative Data Environment (ADE) and DON’s Oracle DONCADS data repositories

• Assess and document functional requirements for data exchange solutions between Oracle HCM DoW’s Enterprise Personnel System, MAHRS Cognos BI DON/DONCADS, ADE, DON Jupiter, and related data repository to review and assess complex data architecture and modeling solutions

• Monitor and maintain data quality during the development of custom data models, data sets, templates, reports and dashboards utilizing Oracle HCM, OTBI, BI Publish and/or Cognos BI in partnership with key stakeholders

• Analyze, design, migrate/develop and sustain migration of MAHRS’ HRLink Cognos

BI

• Design, develop and implement reports, metrics, dashboards and advanced visualization features utilizing HTML, XML, Java, and Cognos BI, ensuring no unauthorized cookies and/or plug ins are required

• Generate and deliver test plans, test applications, migrate test applications to production, and transfer knowledge to client, in the form of Data Dictionaries, Standard Operating Procedures, and User Guides

• Develop analytical data extracts and power cubes via Cognos BI Analysis Studio and PowerPlay Studio

• Design conceptual and logical models for the data warehouse and communicate physical designs to the database users

• Program automated Cognos BI scripts to execute and distribute standard reports on a monthly, weekly, or daily schedule adhering to Secure File Transfer Protocols

• Setup and Execute Automated Secure File Transfer Protocols

• Complete assigned service tickets through MAHRS’ service ticketing system in support of MAHRS IT portfolio

4.13 DCPDS/DoW’s Enterprise Personnel System HR Support. Contractor shall be responsible for supporting DoW’s DCPDS and the Enterprise Personnel System by working day-to-day operations, troubleshooting, functional requirements, transactional processing, data interfaces, performance and appraisals, and related tasks in support of the DON civilian workforce.

• Perform personnel transactional processing within the DoW’s DCPDS Enterprise Suite, both production and the test Quality Center environments, in accordance OPM’s Code of Federal Regulations and Guide to Personnel Processing

• Perform and support the DON civilian workforce with performance transactions within the Defense Performance Management and Appraisal Program (DPMAP) module of DCPDS with research, assessment, and resolution of performance-related transactions

• Perform and support DON’s Wage Mariner civilian personnel with transactional processing within DCPDS, performing quality assurance on all Wage Mariner software modifications and/or enhancements as implemented by DoW. Assess, prepare, generate, and submit Change Request Transmittals (CRTs) to DHRA DMDC for Wage Mariner annual pay table and Wage Mariner software problems for resolution.

• Resolve complex problems concerning DCPDS personnel transactions and interfaces to the Defense Civilian Payroll System (DCPS). Research, assess, and evaluate system and interface problems. Create scenarios to duplicate and identify the source of system and interface problems. Input application transactions on appropriate database and analyze test results. Generate DCPDS problem reports in accordance with DCPAS mandates and submit via Quality Center

• Perform research and analysis on DON DCPDS personnel processing software problems; generating and submitting System Change Requests (SCR) and CRTs to DHRA DMDC requesting system changes and/or enhancements in support of DON requirements

• Conduct DCPDS and Enterprise Personnel System release testing. Test SCRs, CRTs, and problem reports as specified in DHRA DMDC’ release documentation within designated timeframe. Input transactions within Quality Center test system and verify test results

• Prepare and submit DON’s unique salary pay tables annually; coordinate with DOW DCPAS, DDODHRA DMDC, MAHRS, and OCHR’s Pay & Compensation Program Managers to ensure DON’s compliance with OPM mandates

• Complete assigned service tickets through MAHRS’ service ticketing system in support of MAHRS HRCP system; escalating DCPDS issues to DoW’s Remedy Tracking System to resolve system and/or pay problems

• Ability to perform personnel transactional processing within the DoW’s Enterprise Personnel System Suite in accordance OPM’s Code of Federal Regulations and Guide to Personnel Processing

• Attend, participate, and generate meeting summaries on DoW, DFAS, and DON Program Manager meetings in support of DCPDS Enterprise Suite, Wage Mariner Payroll Implementation, DFAS, and OPM initiatives

4.14 Business Systems Analysis. Contractor shall be responsible for performing day-to-day HR functions for multiple departments supported by MAHRS within the DON’s M&RA organization to include, but not limited to the Executive Management Program Office (EMPO), and the Office of Force Resiliency (OFR). Tasks include content management within Microsoft SharePoint sites; design and development of reports, dashboard, metrics and visualizations utilizing business intelligence tools such as Cognos BI, Qlik, Databricks, DON/Jupiter, or similar; generation of clear and concise documentation and case management; and technical and operational support for systems.

• Updates and maintains content on required Microsoft SharePoint sites ensuring materials are continually updated and refreshed as assigned

• Analyze, document and propose recommendations for new Microsoft SharePoint sites in support of new projects, draft site function requirements and document project goals, phases, communication, and implementation plans

• Examines current and new business procedures, operating procedures, and workflows to identify and report recommendations towards process improvements or restructuring

• Generate System and Functional Requirement’s Documentation with clear, concise, business and functional requirements, identifying potential solutions for functionality and reporting needs for assigned MAHRS, EEO, Manpower, HR or related system or application

• Update and maintain MAHRS and EEO Policy, Guidance, Standard Operating Procedures, Business Processes and related documents

• Create, coordinate and complete test scenarios for enhancement features, bug fixes, system upgrades, and new implementations

• Create and support HRLink and/or Jupiter reports, dashboards, metrics and visualizations utilizing Cognos BI, Qlik, Databricks, and/or DON Jupiter tools

• Design, develop and complete ad-hoc analyses, reports, and presentations consistent with the level of effort identified by the MAHRS and EEO program managers, to include HR performance metrics, hiring metrics, timeliness, quantity, and other DON HR requirements utilizing Cognos BI, Qlik, Databricks, DON/Jupiter, or similar tools

• Assist in developing and populating the corporate dashboards and scorecards with metrics data and briefing charts as requested. Support includes, but not limited to, creation/maintenance of new and existing metrics on the M&RA HR Portal, Cognos-based tools like HRLink, or DON/Jupiter, and in the creation/maintenance of reports related to dashboard or scorecards

• Provide technical and functional user system support for EEO iComplaints, Navy Electronic Accommodations Tracker (NEAT), Federal Sector EEO Portal (FEDSep), and the Investigations and Resolutions Case Management System (IRCMS) systems within the DON EEO Community

• Design and develop processes to capture Applicant Flow Data, Occupational Civilian Labor Force (OCLF) benchmarks and Barrier Analysis trigger analyses database tables to automate the process

• Prepare briefing charts to include analysis and detailed data explanations

• Prepare weekly, monthly, or quarterly reports at the DON, Command or Organizational level as assigned; include documented data and calculations used in product generation

• Prepare briefs in support of the Office of Personnel Management (OPM) and DoW metric requirements; requires regular downloads from data sources to generate the final brief.

• Provide logistical support for assigned events supporting MAHRS and EEO

4.15 Information Technology Technical Support. Contractor shall be responsible for providing Information Technology help desk support to end users in the creation, update, and sustainment of authorized system user accounts in compliance with defined access control for each system, and for helping end users through MAHRS help desk system, emails, and phone calls to assist with routine requests and problems and escalating when required.

• Perform functional administration of user accounts, access controls, and management of user’s accounts for assigned HR systems supported by MAHRS utilizing MAHRS Help Desk tool e.g. CANYON

• Provide technical end-user support via telephone, email or MS Teams chat

• Respond to end-user problems based on standard operating procedures

• Support MAHRS team towards continuing process improvements to establish streamlined engineering practices, build automations that directly mitigate repeatable challenges, and advocate to increase process efficiency related to functional administration of accounts

• Excellent in oral and written English communication; and customer service skills

4.16 Scrum and Agile Planning. Contractor shall be responsible for providing expert requirements management and agile planning, tracking, and execution of work across MAHRS. The contracting shall participate in systems requirement reviews and coordinates with customer/functional representatives and the MAHRS team to clarify requirements. The contracting shall apply a data-driven, project approach to perform requirements analysis;

create requirement specifications and documentation; prioritize based on customer and stakeholder objectives; and provide status through until closure

• Leads planning efforts to develop and maintain the MAHRS Road Map, aligning customer and stakeholder priorities; outcomes from governance board activities; and resource capacity.

• Provides expert-level consultation in area of agile practices and techniques (i.e.

Scrum, Kanban). Develops and coordinates an agile framework; configures the selected agile tool(s), performs administrative tasks to ensure integrity of the documented work; and ensures robust data is available for reporting and identifies relevant metrics

• Serves as the “Scrum Master” and is responsible managing and facilitating stakeholder meetings to develop plans; eliciting leadership support in the development of project schedules; Sprint planning & status meetings; task framework; facilitating accomplishment of work; backlog tracking; preventing scope creep; mitigating risk; and establishing and maintaining team velocity

• Ensures team dynamics across divisions and influences positive action and accountability for the directorate’s work. Shields the team from outside distractions and interferences. Facilitates discussion, decision-making, and conflict resolution

• Assists with internal and external communication, improving transparency, and radiating information. Supports and educates the product owner(s), especially with respect to grooming and maintaining the product backlog. Assess the Scrum maturity of the team and organization.

• Support curation and documentation of tasks and associated agile scrum workloads, backlog tasks, etc. in the DON’s agile planning tool, JIRA

4.17 Communications Support. Contractor shall be responsible for providing support for the development of executive-level presentation and briefing material within the directorate.

The contractor shall participate in topic brainstorm sessions, team meetings, and presentation design sessions to turn content provided by the team into quality, executive-level briefing material.

• Ensure the desired message is being communicated both through the content text as well as the graphic supporting the topic

• Create a library of graphical templates that the team can use to quickly assemble content in a non-textual presentation

• Conduct graphic design review sessions on final material production

4.18 Knowledge Management (KM) & KM Portal Support. Contractor shall be responsible for providing content creation, deployment, and management of all MAHRS documentation and artifacts in a knowledge management portal(s).

• Develop a knowledge management process for MAHRS to manage all artifacts

• Deploy process content provided by MAHRS team will be deployed through repeatable process

• Routine maintenance and monitoring of the KM Process and Portal(s)

• Assist in the development of Teams sites to support MAHRS KM process and ensure compliance with KM best practices

5.0 DELIVERABLES AND MILESTONES

Deliverables

PWS

paragraph reference

Frequency or Upon Award Date

Notes

Identification of Project Manager

4.1 Within 5 days of Award

Refilling Vacated Labor Categories

4.1

Within 20 days of vacancy

Meeting with COR (or designee)

4.1 Monthly or at a mutually agreed frequency, as required

Monthly Status and Progress Report

4.1

Fifth working day of e ach month

System and Data Governance Policy

4.2

As assigned by Enterprise Services Division (ESD) Director

Business Case Analysis & Business Enterprise Architecture Documents

4.2

4 Month post Tasking

ESD Director to identify timeline for each BCA based on Complexity of the system.

HRM Systems RMF Review Report

4.2 Quarterly

HRM FAM Quarterly Review

4.3

Quarterly

Review of HRM Systems within DITPR- DON and HRM Applications within

DADMS

IT System and Data Architecture Review and Modification

4.2 As Assigned by ESD

Director

Artifact updates or updated to the ARIS

HRM FAM

Communication Strategy Plan

4.3 Within 4 months of Award

Governance Administrative Support Documentation

4.2 10 days before or after Governance meeting based on ESD Director Assignment

IT System & Application Roadmaps

4.3 Quarterly If roadmaps are created

into dashboard this would be transitioned to validating data quality

vs. editing / updating document

System and Project Management Tracking Report

4.3 Every 3 Months

Systems and Applications as assigned by ESD Director

Establishment of HRM Data Models within Jupiter

4.4 As assigned by TF&HRBI Director

Due to complexity, data model completion dates will vary

White Papers, Briefs or Communication Products

4.4 As assigned by TF&HRBI Director

Due to complexity, data model completion dates will vary

Statistical Models (predictive, inferential, 4.5

Within 2-3 months of Assigned Model; or as determined based on complexity

Due to complexity, data model completion dates will vary. It is expected that the data science supervised, non-supervised, ensemble, and clustering/ segmentation) lifecycle is followed and iterative incremental deliverables are produced in the development.

Exploratory Data Analysis and Model- Fitting Tracking Report

4.5 Weekly

Model Performance Metrics Report

4.5 Within one week of

model development.

Data Models within Qlik for Visualization

4.6 Bi-Weekly

Visualization Products 4.6 Bi-Weekly

Statistical and Analytical Dashboard and Reports

4.6

Bi-Weekly

Data Design and Architecture Analysis Report

4.7

Monthly

Maintain JIRA, or similar project management document tool, of on-going initiatives and projects

4.7

Weekly

Perform Resolutions on ACAS

4.8, 4.9

Bi-weekly

Cluster maintenance and documentation

4.8 Monthly

Validate Information Assurance & Technology patches, upgrades, application functionality

4.8, 4.9, 1st/3rd Fridays of each month

RMF/ATO

4.8, 4.9, ATO achieved via RMF process requires continue compliance via IT related tasks

DNS DISA and/or Navy Submission Requests

4.8 1 Week of Assignment

Validate O/S & S/W Cybersecurity and Information Assurance patches, upgrades, tasks, application functionality

4.8, 4.9, Weekly

Service Ticket Completion

4.8, 4.9, 4.11, 4.12, 4.13, 4.14

5 days of receipt or as assigned

Service tickets are normally completed within 5 days, timelines adjusted for complex requests

ETL Scripts

30 days of receipt or as assigned

Normally within 30 days; timeline adjusted for complex requests

Enterprise Personnel System OTBI/BI Publisher Queries, Reports and Extracts Updates

4.11

Every 3 Months

Based on DoW Enterprise Personnel deployment

Migrate Cognos BI/v10 reports to Cognos BI/V11 reports and new visualization

4.11

Analytical Data Extracts & Power Cubes

4.11 Quarterly

DCPDS CRT & SCR 4.12 5 days of assignment

Enterprise Personnel System User Testing

4.12 Weekly Based on DCHRMS

replacement project status

System and Functional Requirements Documentation

4.12, 4.13

30 days of receipt or as assigned

Dashboard, Reports, Metrics for analysis performed

4.13

1-5 days of receipt

Technical and Functional System Administration for

MAHRS

Systems/Applications

4.13

Daily

Tracked through Service Ticket Desk

OCLF Benchmarking Report

4.13 Monthly

Weekly, Monthly, and Quarterly EEO Reports

4.13 As assigned due date by EEO Director

User Account creation, modification or termination

4.14

Daily

Tracked through Service Ticket Desk; minimum of 12-15 tickets per day

MAHRS Road Map Creation and updates

4.15, 4.16

Monthly

JIRA, or similar, Project Management & Tracking Tool

4.16 Daily

Project Plans 4.16 Aligned with sprint/scrum cycle

Tracked in JIRA

Executive level Presentations, Infographics, and other Briefing material

4.17 As assigned due date

by MAHRS division leadership

Library of graphical components that can be used to quickly turn textual material into an executive presentation

4.17 As assigned due date

Deployment of content to the knowledge management portal

4.18 As assigned due date

Knowledge Management Process updates

4.18 45 days after award

KM Process Improvement & Monitoring

4.18 As assigned due date

by MAHRS leadership Post KM Process Development

KM Best Practices Guide

4.18 As assigned due date

by MAHRS

6.0 PERFORMANCE REQUIREMENTS SUMMARY. Contractor performance objectives are summarized in the following table.

Task(s) Performance

Element Performance Requirement

Surveillance Method

Acceptable Quality Level

(AQL)

4.1 Delivery of

Contractor Program Management Plan

Contractor Program Manager to generate Program Management Plan identifying plan to track and monitor staff, tasks, risks, and Communication plan.

100% verification by COR (or designee)

100% by contract award or within 10 days of contract award.

4.1 Monthly Status

and Progress Report

Contractor Program Manager to provide monthly report clearly identifying tasks and work completed, issues, and monthly costs per labor category.

100% verification by COR (or designee)

Receipt by the 5th day of each month.

4.2 MAHRS/HCSM

System and Data Governance Policy

Bi-Weekly, demonstrate work completed in support of the ESD System and Data Governance Policy establishment to the Director, ESD.

100% verification by COR (or designee)

Completed 5 months after contract award.

4.2 Business Case

Analysis (BCA) & Business Enterprise Architecture

(BEA)

Generation, review, and/or completion of BCAs/BEAs packages submitted to

MAHRS/ESD.

100% verification by COR (or designee)

Completed 2 months after

BCA/BEA

assigned.

4.2 HRM RMF

Quarterly Review and Tracking Report

Utilizing eMASS/RMF system, complete quarterly HRM Systems review, compliance, and

100% verification by COR (or designee)

Deliverable required only for the specific fiscal quarters falling within the active

Authority to Operate status.

6-month performance period.

4.3 HRM FAM

Quarterly Review

Utilizing DON's DITPR- DON and DADMS systems, complete quarterly HRM FAM reviews, tasks, and compliance checks.

100% verification by COR (or designee)

Deliverable required only for the specific fiscal quarters falling within the active 6-month performance period.

4.3 HRM FAM

Communication Strategy Plan

Complete the generation of HRM FAM Communication Strategy Plan.

100% verification by COR (or designee)

100% by contract award or within 30 days of contract award.

4.3 System and

Project Management Tracking Report

Establish and maintain System and Project Management tracking business process utilizing Jira, or related tool, to establish real-time tracking (system, staffing, workload, projected costs, etc.) of human capital system initiatives.

100% verification by COR (or designee)

Monthly review of updated human capital system initiatives within designated tool due on the first working day of the month.

4.4 Establishment of

HRM Data Models within Jupiter

Perform analysis, generate data mappings from data source(s), design, develop, and support implementation of HRM Data Models within the DON's Jupiter data lake.

100% verification by COR (or designee)

97% Completed within one day of the assigned deadline as defined in JIRA and the sprint planning.

4.4 White Papers, Briefs, or Communication Products

Generation of requested White Papers, Briefs, and/or Communication Products.

100% verification by COR (or designee)

100% drafted and delivered within one day of assigned deadline as defined in JIRA and the sprint planning.

4.4 HRM

Sustainment Report for Jupiter Dashboard, Reports, and Metrics

Per functional requirements identified, generate output products (reports, dashboards, metrics, graphics, etc.)

within HRLink or Jupiter Systems.

100% verification by COR (or designee)

100% drafted and delivered within one day of assigned deadline as defined in JIRA and the sprint planning.

7.0 QUALIFICATIONS: The minimum qualifications for these tasks are:

7.1 Senior Program Manager

• Minimum Bachelor’s Degree from an accredited College or University or a minimum of 5 years of contract program management operational experience

• Ten (10) years of demonstrated experience within a Department of Defense Agency as a Senior Program Manager

• U.S. citizenship

• SECRET Clearance

7.2 Senior Governance Analyst

• Bachelor’s Degree in computer science, information management or equivalent;

• Demonstrated experience with business systems requirements, acquisitions and sustainment operations (e.g., DODI 5000.75, SECNAVI 5000.2G, BCA, BEA)

• Three (3) years of demonstrated experience as a Senior governance, operations, and/or compliance analyst

• Five (5) years of strong analytical skills with the ability to identify, quantify, and effectively raise business risks associated with system or data quality or non-compliance

• U.S. citizenship

• SECRET Clearance

7.3 Senior IT Solutions and Rationalization Specialist

• Bachelor’s Degree in computer science, information management or equivalent

• Five (5) years of experience in Business Requirements Analysis demonstrating strong analytical skills with the ability to identify, quantify, and effectively raise business risks associated with system or data quality or non-compliance

• Five (5) years of expertise in program management, project management, change management, and communications

• Three (3) years of experience in IT project management

• Excellent communication, written and interpersonal skills

• Current Network+, Security+, or higher as defined by DoW CIO Information Assurance (IA) Certification requirements

• U.S. citizenship

• SECRET Clearance

7.4 Senior Analytics Specialist

• Bachelor’s Degree in computer science, engineering, mathematics, statistics, business or a similar field

• Five (5) years of experience in Business Requirements Analysis demonstrating strong analytical skills with the ability to identify, quantify, and effectively raise business risks associated with system or data quality or non-compliance

• Three (3) years of Business Intelligence systems or tools; preferred Cognos Business Intelligence, Qlik, Databricks, and DON enterprise data hub Jupiter

• U.S. citizenship

• SECRET Clearance

7.5 Data Scientist

• Bachelor’s Degree in computer science, engineering, mathematics, statistics, business or a similar field with 2 years of relevant experience (or Master’s Degree in relevant field)

• Three (3) years of relevant experience in data mining, advanced analytical algorithms, programming, data science or software engineering

• Experience with Python, R, and Databricks. Additional experience with any or all of the following (Cognos BI, PowerBI, Qlik, other DON/Jupiter tools, Excel)

7.6 Analytics Specialist – Visualization

• Experience with Qlik and Databricks is required. Additional experience in any or all of the following (Cognos BI, PowerBI, DON/Jupiter tools, Excel) is helpful.

• Three (3) years of relevant experience in data mining, advanced analytical algorithms, programming, data science or software engineering

• U.S. citizenship

• SECRET Clearance

7.7 Data Architect

• Bachelor’s Degree in computer science, engineering, mathematics, statistics, business or a similar field

• Three (3) years of relevant experience in modeling processes and data using architecture discipline and industry modeling standards

• Three (3) years of relevant experience in utilizing data management, enterprise repository, data modeling, data quality and data mapping tools

• Current Network+, Security+, or higher as defined by DoW CIO Information Assurance (IA) Certification requirements

• U.S. citizenship

7.8 Data Engineer

• Bachelor’s Degree in computer science, engineering, mathematics, statistics, business or a similar field

• Three (3) years of relevant experience in data using architecture, data engineering, data hub / data warehouse development

• Three (3) years of relevant experience in utilizing data management, enterprise repository, data modeling, data quality and data mapping tools

• Current Network+, Security+, or higher as defined by DoW CIO Information Assurance (IA) Certification requirements

• Experience with Databricks required

• U.S. citizenship

• SECRET Clearance

7.9 Windows System Administrator

• Bachelor’s Degree in computer science, engineering, mathematics, similar field, or Ten (10) years of demonstrated experience

• Ten (10) years of experience as Windows System Administrator

• Ten (10) years of experience of with Web Servers; such as IIS, Apache, and Tomcat

• Ten (10) years of experience applying DISA STIGS, IAVA’s

• Five (5) years of experience supporting Active Directory

• Five (5) years of experience working with security compliance tools such as ACAS

• Five (5) years of experience with HPE Blade technology and Storage Array Networks

• Five (5) years of hands-on experience working with virtual environments

• Current Network+, Security+, or higher as defined by DoW CIO Information Assurance (IA) Certification requirements

• U.S. citizenship

• SECRET Clearance

7.10 REMOVED

7.11 Informatica ETL Administrator

• Bachelor’s Degree in computer science, engineering, mathematics, similar field, or Five (5) years of demonstrated experience

• Five (5) years of experience performing Informatica ETL operations and connectors for cloud- based and on premises ERP systems like SAP, Oracle, Oracle Fusion Cloud, and PeopleSoft

• Five (5) years of Oracle DBMS experience within large-scale database enterprise system

• Current Network+, Security+, or higher as defined by DoW CIO Information Assurance (IA) Certification requirements

• U.S. citizenship

• SECRET Clearance

7.12 Data and Interoperability Reports Specialist

• Bachelor’s Degree in computer science, engineering, mathematics, similar field, or Five (5) years of demonstrated experience

• Five (5) years of experience with Cognos BI v10 and/or v11 or Oracle HCM

• Five (5) years of experience with metadata modeling, ETL, or relational database development

• Three (3) years of experience utilizing federal HR data

• Must have completed a Network+, Security+, or higher as defined by DoW CIO Information Assurance (IA) course completion or certification requirements or achieved certification

• U.S. citizenship

• SECRET Clearance

7.13 DCPDS Human Resources Specialist

• Bachelor’s Degree or Five (5) years of demonstrated experience in DCPDS

• Five (5) years Human Resources Staffing and Processing experience

• Five (5) years DCPDS Enterprise Suite and DCPS experience; operational and problem solving through analysis, problem statements, testing and verification

• Two (2) years with Oracle’s HCM Cloud (DCHRMS) Enterprise experience

• Completed NACI or ANACI background verification

7.14 Business Systems Analyst

• Five (5) years of experience with design, development, and sustainment of reports, dashboards, metrics utilizing Cognos BI, DON/Jupiter tools or similar

• Three (3) years of experience utilizing federal HR data

• Two (2) years of Microsoft SharePoint content management

•…