Attachment 5C MBAS SAnDS PWS Support.pdf

TASK ORDER (TO) PERFORMANCE WORK STATEMENT (PWS)

SPACE AND NAVAL WARFARE SYSTEMS CENTER, ATLANTIC

SHORT TITLE: Corporate Strategy Business Intelligence and Strategic Analysis Support

1.0 PRIMARY PLACE(S) OF PERFORMANCE

The following site(s) identify contractor employees’ originating office location and the location of government provided facilities, if applicable to this TO. Travel locations (i.e., temporary duty sites) are specified in the Travel Section under TO PWS Para 10.0.

a. Contractor facility

b. SPAWARSYSCEN Atlantic, Charleston facility

2.0 TASK ORDER PURPOSE

2.1 BACKGROUND

SPAWARSYSCEN Atlantic Corporate Strategy (Code 84000) requires the capability to perform strategic analyses to support decision making. Primary areas of focus including Business

Intelligence, Data Strategy, Advanced Analytics, Process Improvements, Metrics/Dashboards and

Strategic Measures. These efforts supported the command in establishing enterprise-level perspectives and consistent analytical approaches.

2.2 SCOPE

These efforts will support Corporate Strategy and the Strategic Analysis and Decision Support

Integrated Project Team with strategic measurement, data analytics, data mining and the development of universal data sets to provide leadership with decision quality information in pursuit of strategic and operational goals, support internal and external data calls, and support the development and execution of the data strategy.

3.0 APPLICABLE DOCUMENTS

3.1 REQUIRED DOCUMENTS

The contractor shall utilize all required documents listed within the basic contract as applicable to this

TO.

3.2 GUIDANCE DOCUMENTS

The contractor shall utilize all guidance documents listed within the basic contract as applicable to this TO.

3.3 ACRONYMS

BOBJ – Business Objects

BI – Business Intelligence

COG – Command Operating Guide

CPIMS – Continuous Performance Improvement Management System

CSWF – Cyber Security Workforce

DW – Data Warehouse

DWBIS- Data Warehouse Business Intelligence System

IPT – Integrated Product Team

LDS – Local Data Store

NERP – Navy Enterprise Resource Planning

SAnDS – Strategic Analysis and Decision Support

3.4 DEFINITIONS

JIRA – JIRA is an agile software tool used to track projects.

4.0 SECURITY REQUIREMENTS

4.1 ORGANIZATION

Work performed under this task order will be “unclassified"

4.2 PERSONNEL

Prior to any labor hours being charged on contract, the contractor shall ensure their personnel

(including administrative and subcontractor personnel) have obtained and can maintain favorable background investigations at the appropriate level(s) for access level required by this task order, and if applicable, are certified/ credentialed for the Cybersecurity Workforce (CSWF). Investigations are not necessarily required for personnel performing unclassified work who do not require access to government installations/facilities and/or government IT systems/IT resources

5.0 COR DESIGNATION

The Contracting Officer Representative (COR) for this task order is Robert L. Kemp, 84000 who can be reached at phone (843) 218-3793; e-mail: Robert.l.kemp@navy.mil

6.0 DESCRIPTION OF WORK

6.1 BUSINESS ANALYTICS

The contractor shall develop and use efficient, standardized data methodologies to support shaping and executing command-wide strategic and operational analyses associated with complex and frequently unprecedented business problems with bi-directional situational awareness. The contractor shall ensure consistent, standardized data input to authoritative data systems to perform advanced analytics in operational and business decision-making methodologies throughout a life cycle including development, mathematical modelling, analytical reasoning, predictive analytics, statistical analysis and simulations. They must be familiar with best practices associated with data modeling, continuous process improvements, and organizational management.

6.1.1 Predictive Analysis

PA efforts will seek to frame future outcomes within an acceptable level of reliability, and includes development of what-if scenarios and risk assessments in order to better understand customer requirements, product and service value to capitalize on potential opportunities and / or avoid future risks. PA will include a number of techniques, including data mining, statistical modeling and machine learning to help analysts make future business forecasts.

6.1.1.1 The Contractor shall extract information from existing data sets in order to determine patterns and predict future outcomes and trends.

6.1.2 Environmental Scans

6.1.2.1 The Contractor shall support the Government PM with developing a system to gather and analyze information (internal and external) relevant to the mission and functions of

SPAWARSYSCEN Atlantic. Perform analysis of collected information to identify trends, opportunities and threats to future operations based on current strategic and operational goals. Prepare graphical depictions of analysis to support the Executive Steering Council meeting schedule.

6.1.2.2 The Contractor shall support the Government PM with building a repeatable scenario based planning framework and the development and analysis of a likely future scenario based on current relevant indicators.

6.1.3 Business Intelligence

6.1.3.1 The Contractor shall support the Government PM with providing recommendations, designing and building dashboards, reporting solutions, and data integration using the BOBJ 4.x reporting suite. Provide best practices, knowledge transfer and process recommendations to BI technical team.

6.1.3.2 The Contractor shall support the Government PM with administration and user management business intelligence activities that includes: release management, user security administration, Business Objects security development and testing, Business Objects administration and creating and executing test plans for upgrades, major security model changes supporting license usage, system utilization, and user profile usages in order to maximize license and system resources.

6.1.3.3 The Contractor shall support the Government PM with gathering information from Portfolio and Competency business areas and system SMEs in order to recommend a data model or report requirements for BI solutions.

6.1.3.4 The Contractor shall support the Government PM in developing Command repeatable metrics to support internal and external data calls, including; Portfolio/Competency reviews, Intelligent

Workbook, Command Scoreboard, Weekly Staff Meeting, Naval Laboratory /Center Coordinating

Group (NLCCG), Integrated Product Team Health Metrics, Weekly Tactical Update and A-11 Budget

Planning.

6.1.3.5 The Contractor shall support the Government PM with the identification and analysis of strategic initiatives that support the Command strategy. Analysis shall include; development of metrics/measures for each initiative and alignment of initiatives with Command strategy.

6.1.3.6 The Contractor shall assist Government PM with monitoring initiatives that support strategy to measure the progress towards achieving goals, check for continued alignment with requirements and consider sufficiency in view of any apparent gaps in performance with recommendations for adjustments.

6.1.3.7 The Contractor shall support the Government PM with creating and maintaining BI knowledge transfer materials, BI software development lifecycle processes, data dictionaries, and end user supporting documentation.

6.1.3.8 The Contractor shall support the Government PM in the development of Data Warehouse data models (relational as well as multidimensional / dimension modeling), Extract Transfer Load (ETL) strategies, Business Objects universe and report development to support BI.

6.1.3.9 The Contractor shall support the Government PM with recommendations for the development and deployment of the organization’s metric’s and data strategy to enable continuous improvement of

BI to include:

a. Apply data management and data base modeling expertise to plan and manage data quality, integration, scaling, and redundancy.

b. Engage with BI and technical teams and SMEs actively to build relational and non-relational models and provide recommendations for ETL, integration, and data migration solutions.

c. Lead and manage the data eco-system ensuring security, performance SLA, and other business and technical requirements are met and serve as the team's data strategist and advisor to direct data practices.

d. Evaluate Oracle databases to recommend performance tuning and optimization for data queries in a self-service BI environment.

6.1.3.10 The Contractor shall support the Government PM with SPAWARSYSCOM Enterprise BI development, coordination and implementation.

6.1.3.11 The Contractor shall support the Government PM with data modeling consistent with data in

NERP to transfer information into Data Warehouse Business Intelligence System (DWBIS).

6.1.3.12 The Contractor shall support the Government PM with extracting data from NERP that supports the inclusion of multiple data elements to satisfy Command data requirements.

6.1.3.13 The Contractor shall support the Government PM with performing quality assurance of data elements to validate report accuracy.

6.1.4 Organizational Analysis

6.1.4.1The Contractor shall support the Government PM with survey design and implementation.

Provide enhancements to the pre-existing conceptual design for managing surveys. Deliver best means of soliciting survey inputs by leveraging the web-based tool (www.surverymonkey.com).

Utilize effective survey instruments and/or capabilities to be used for designing, deploying, executing, accumulating, measuring, analyzing, and communicating feedback from customers, teams, employees, partners, peers and stakeholders (herein referred to as

“Survey communities”).

6.1.4.2 The Contractor shall support the Government PM with survey execution and deploy a link or interface of survey for survey communities to access and respond. Collect survey results from survey communities and provide survey results from private / public sectors, SPAWARSYSCEN Atlantic as well as from other approved surveys from strategic alliance partners to SPAWARSYSCEN Atlantic.

Provide configuration management & integration of outgoing customer-based surveys.

6.1.4.2 The Contractor shall support the Government PM with survey results and analysis. Assess surveyed communities with a qualitative review that identifies trends and common themes amongst surveys. Identify relevant trends and driving forces in surveyed communities. Perform high level assessments and root-cause analyses and providing statistical analyses of survey results--break out statistics as determined by survey requirements.

6.1.4.3 The Contractor shall support the Government PM with survey results communications and develop and submit graphical displays using the capabilities within SurveyMonkey and/or Microsoft products and deliver integration and trend analysis of incoming customer-based survey results.

Provide survey results in tabulated / reported format. Develop communication plans for publishing surveys results and actions over the Survey Management life cycle.

6.1.4.4 The Contractor shall support the Government PM with survey support. Recommend improvements to survey management. Identify strengths and weaknesses in survey management techniques. Benchmark survey approaches and best practice techniques used elsewhere in private / public sectors.

6.2 PROGAMMATIC SUPPORT

6.2.1 The Contractor shall assist the Government PM in the creation of Project Objectives Actions and Milestone (POA&M) tracking, utilizing industry best practices and the development of internal and external communication plans for each project.

6.2.2 The Contractor shall support the Government PM in developing and monitoring project roles, responsibilities and skills to create a staffing management plan that supports projects.

6.2.3 The Contractor shall support the Government PM with a risk assessment associated to each project that recommends prioritizing their effects and measuring risk implications of project objectives.

6.2.4 The Contractor shall support Government PM with ensuring the successful accomplishment of day-to-day operations including serving as project liaison to the Government by attending project-related meetings including progress reviews, design reviews, briefings, focus groups or IPTs.

6.2.5 The Contractor shall input, track and update SAnDS projects in the JIRA tool and provide monthly status reports on project progress (CDRL A001).

6.2.6 The Contractor shall perform general administrative functions to include:

a. Meeting coordination and minutes.

b. Inventory/accountability of NMCI laptops assigned to contractors.

c. Completing Navy/SPAWAR specific annual training.

6.3 TASK ORDER ADMINISTRATION

6.3.1 Basic Contract Requirement

In accordance with the basic contract PWS and the requirements of this task order PWS, the contractor shall develop and submit documentation (see CDRL under Para 12.1.1) for TO administration

7.0 GOVERNMENT FURNISHED INFORMATION (GFI)

No GFI is provided on this TO.

8.0 GOVERNMENT FURNISHED PROPERTY (GFP)

8.1 TYPES OF GFP

No GFP is provided on this TO.

9.0 CONTRACTOR ACQUIRED PROPERTY (CAP)

Contractor Acquired Material (CAM) includes Operating Material and Supplies (OM&S). This includes materials purchased by the contractor that will be incorporated into, or attached to a deliverable end item or that may be consumed or expended in performing a TO. CAM provided by the contractor shall consist of material identified in Attachment # 3. The proposed estimated CAM cost cannot exceed the not-to-exceed (NTE) value cited in the applicable pricing model.

10.0 TRAVEL

For planning purposes, the contractor shall provide adequate personnel to support the travel requirements listed below. The proposed estimated travel cost cannot exceed the not-to-exceed (NTE) value cited in the applicable pricing model. Travel estimates are in accordance with the latest Joint Travel Regulations

(JTR) for DoD Civilian Personnel.

# Trips # People # Days/Nights From (Location) To (Location)

2 2 5/4 Charleston, SC San Diego, CA

11.0 TRANSPORTATION OF EQUIPMENT/MATERIAL

No transportation of equipment/material is required by the contractor on this TO

12.0 DELIVERABLES

12.1 CONTRACT DATA REQUIREMENTS LIST (CDRL)

12.1.1 Administrative CDRL

As referenced under TO PWS Para 6.3, the following table lists all required administrative data deliverables, Contract Data Requirements Lists (CDRLs), applicable to this task:

CDRL # Deliverable Title

TO PWS

Reference

Para

Frequency Date Due

A001 Program Management Reports, General

6.1 – 6.2 MTHLY

30 Days after TO award (DATO) and monthly on the 10th

A003 Contract Status Report 6.3 MTHLY

30 Days after TO award (DATO) and monthly on the 10th

A004 Task Order Status Report 6.3, 8.1, 8.2, 8.2.1

MTHLY

30 Days after TO award (DATO) and monthly on the 10th

A005 Task Order Closeout Report 6.3 1TIME NLT 15 days before completion date

A006 Cyber Security Workforce (CSWF)

Report

6.3 MTHLY

30 DATO and monthly on the 10th

A007 Contractor’s Manpower Report 6.3 QRTLY 15 Jan, 15 Apr, 15

Jul, & 15 Oct

A008 Invoice Support Documentation 6.3 ASREQ Within 24 hrs from request

A009 Limitation Notification & Rationale 6.3 ASREQ Within 24 hrs from occurrence

A014 Cost and Milestones Schedule Plan 6.3

One time with revisions

(ONE/R)

NLT 10 DATO;

revision NLT 7 days after receipt of govt review

A015 Contractor CPARS Draft Approval

Document (CDAD) Report

6.3 MTHLY

30 DATO and monthly on the 10 th

13.0 SUBCONTRACTING REQUIREMENTS

Subcontracting requirements are in accordance with the basic contract. If the prime contractor is planning to utilize subcontractor(s) on this task order, the prime contractor shall specify the applicable subcontractor in their proposal prior to award. Per clause 52.244-2, if a subcontractor (includes tier 1, tier 2, tier 3, etc.) is proposed by a prime and is not approved on the basic contract, formal justification is required and subject to government approval. NOTE: This paragraph will be revised prior TO award to specify any approved subcontractors as proposed by the selected offeror.

14.0 ACCEPTANCE PLAN

Inspection and acceptance is performed by the COR on all services, data, and non-data deliverables in accordance with the Quality Assurance Surveillance Plan (QASP), Attachment 1.

15.0 OTHER CONDITIONS/REQUIREMENTS

15.1 GOVERNMENT FACILITIES

Government facilities (i.e., office space, computer hardware/software, or lab space) will be provided to the majority of labor categories supporting this task order. All Contractor personnel with supplied government facilities shall be located at SPAWARSYSCEN Atlantic in Charleston, SC. The majority of Contractor personnel work under this task order will be performed during normal working hours between the hours of 0600 and 1800 Monday through Friday except Federal holidays or when the Government facility is closed due to local or national emergencies, administrative closings, or similar Government directed facility closings when practical. Contractors with assigned

Government office space may occasionally perform work at the contractor facility or outside normal working hours when requested and approved through the COR. The Government may authorize

Contractors to perform work from home when there are circumstances that impede task performance at the Government facility. Prior to approving work from home, the Contractor must have a telework, or work from home type agreement for all Contractor employees requesting to work from home that has been approved by the COR. Requests to work at the Contractor facility, outside normal duty hours, or from home, must include the time and date the work will be accomplished, the nature of the work with the supported task order paragraph, and the reason the work must be accomplished outside the Government facility or after hours.

Pursuant to clause 5252.237-9602, when conversing with Government personnel during business meetings, over the telephone, or via electronic mail contractor and subcontractor personnel shall identify themselves as such to avoid situations arising where sensitive topics might be better discussed solely between Government employees. Contractors and subcontractors shall identify themselves on any attendance sheet or any coordination documents they may review. Electronic mail signatures shall identify company affiliation.

15.2 TO SUPPLEMENTAL PESONNEL

As specified in basic contract Clause 5252.237-9600, the minimum personnel qualifications for each labor category are identified; however, for those categories listed below, specific experience is applicable specifically to this TO.

15.2.1 Project Manager

Specific Experience: 7-10 years’ experience in complex data integration projects and successful

Business Intelligence implementations experience is required.

15.2.2 Management Analyst 2 or 3 and Technical Analysts 3 or 4

Specific Experience:

- 3-5 years Business Intelligence experience in designing and building dashboards, reporting solutions, and data integration using the SAP Business Objects 3.1 (or newer) reporting suite.

- 3-5 years’ experience in Business Intelligence software development lifecycle processes, data dictionaries, and end user supporting documentation, Business Objects reporting suite, Data

Warehousing and industry best practices.

- 3-5 years’ experience with Software/Application development version Release Management software/application user security administration and management Business Objects 3.1 (or newer) security model development, testing, and implementation Business Objects 3.1 (or newer) User

Administration.

- 3-5 years’ experience in Data Warehouse data models including relational as well as multi-dimensional / dimension modeling, Data Extract Transfer and Load (ETL) strategies. Business

Objects 3.1 (or newer) universe development and report development.

Note: Specific experience may be applied using any combination of the identified labor categories.

15.2.3 Subject Matter Expert (SME) 4

Specific Experience: 7-10 years’ experience in planning, design, implementation, analysis and management of various surveys and the use of survey tools to evaluate organizational and customer experience, i.e. SurveyMonkey.

15.3 KEY PERSONNEL

As specified in basic contract Clause 5252.237-9601 Key Personnel will be identified at base contract level. The résumé for any proposed individual not already approved (on the base contract level - Key

Personnel) in any task order , and whom is key personnel on the cited on the TO labor category is subject to COR approval prior to the individual charging to the task. Contractor shall submit the required resume no later than 10 days after TO award. The contractor shall track and maintain a list of Key Personnel in the Staffing Plan with is part of the monthly Task Order Status Report (TOSR)

CDRL. The following list of basic contract labor categories will determine the Key Personnel applicable to this task order:

# Labor Category

1 Project Manager

2 Subject Matter Expert 4 (Para 6.1.4)

15.4 CYBERSECURITY WORKFORCE DESIGNATION

This task order requires contractor personnel to perform cybersecurity functions. In accordance with

DoD 8570.01-M Information Assurance Workforce Improvement Program Manual, the cybersecurity workforce is comprised of the following categories: IA Technical (IAT) and IA Management (IAM));

and specialties: Computer Network Defense Service Providers (CND-SPs) and IA System Architects and Engineers (IASAEs). Based on the IA function provided by the individual, an IA designator is assigned that references an IA category or specialty. The following Labor Categories shall meet the IA

Designator, IA Level/Position, and have the estimated Primary/Additional/Embedded hours performing

IA duties:

IA Designator &

Level/Position

Quantity

Personnel

IAT II (3)

15.5 NON-DISCLOSURE AGREEMENT (NDA) REQUIREMENTS

Contractors shall submit a completed “Conflict of Interest and Non-Disclosure Statement” form, Attachment 2, for every employee working on the contract and appropriate corporate officer on behalf of the corporation.

The Contractor shall appoint an officer within the Company who is authorized to bind the Company to the terms of the signed non-disclosure agreements executed by each employee or subcontractor. The officer of the Company shall also sign each non-disclosure agreement.

As a condition to receiving access to the data, the Contractor shall meet the following criteria:

(a) Prior to having access to proprietary data, obtain the agreement of the applicable person or entity to permit access by the Contractor to such data.

(b) Use the data solely for the purpose of performing duties under this contract.

(c) Not discuss with, disclose, release, reproduce or otherwise provide or make available the data, or any portion thereof, to any employee of the contractor unless and until each person has executed a copy of the individual non-disclosure agreement.

(d) Not discuss with, disclose, release, reproduce or otherwise provide or make available the data, or any portion thereof, to any non-government person or entity (including, but not limited to any subcontractor, joint venture, affiliate, successor or assignee of the contractor), unless the KO (and any contractor claiming the data is proprietary) have given prior written approval, and the person receiving the data has executed an individual non-disclosure agreement.

(e) Establish safeguards to protect such data or software from unauthorized use or disclosure.

(f) Indoctrinate its personnel who will have access to the data as to the restrictions under which access is granted. Any other use, disclosure, release or reproduction is unauthorized and may result in substantial criminal, civil and/or administrative penalties to the contractor or to the individual who violates this special contract requirement or non-disclosure agreement.

(g) Appropriate restrictive legends will be included by the Contractor on any copies and reproductions made of all or any part of the data and any data that is derived from, based upon, incorporate, include or refer to the data. When the Contractor’s need for such data ends, the data shall be returned promptly (within ten (10) business days) to the appropriate government program personnel.

However, the obligation not to discuss, disclose, release, reproduce or otherwise provide or make available such data, or any portion thereof, shall continue, even after completion of this contract/order.

Any actual or suspected unauthorized use, disclosure, release, or reproduction of such data or violation of this agreement, of which the company or any employee is or may become aware, will be reported promptly (within one (1) business day) to the contractor’s program manager, who will inform the KO within five (5) business days of receiving the report.

16.0 LIST OF ATTACHMENTS

Attachment 1 – Quality Assurance Surveillance Plan (QASP)

Attachment 2 -- Non-Disclosure Agreement (NDA) form

Attachment 3 – Contractor Acquired Material (CAM)