N6230619K0009_Optics_Draft_SOW_3_June_19.doc

FOR OFFICIAL USE ONLY

3 June 2019 Ocean Measurements Department

Database and Analysis Division Optics Custom Processing Tools and Database Maintenance/Debugging/Modification/Upgrade/Enhancing Services ODPS, BDPS and OPTM Maintenance/Development/Enhancement Statement of Work 1.0 Background The Naval Oceanographic Office (NAVOCEANO), Ocean Sciences Division, Marine Optics Branch ingests data collected from an extremely large field of optical and bioluminescence sensors as staged on many varied and disparate data collection platforms, all of which are fed into products, such as Mine Warfare Environmental Decisions Aid Library (MEDAL), Bioluminescence Visual Detection Ratio products, Diver Visibility Estimate products, Laser penetration depth estimate products and many more. The data used to generate these products originate from NAVOCEANO surveys and require primary shipboard and secondary in-house processing software suites. These data are then loaded into NAVOCEANOs Data Warehouse for easy extraction during product generation. In accordance, software maintenance, repackaging, additions, and enhancements need to be undertaken to maintain, add to, and streamline the existing optics and bioluminescence software processing suites and to incorporate new data ingest routines to keep up with new sensor developments.

A new bioluminescence sensor (Underway Bioluminescence Assessment Tool – UBAT) is on-line on the TAGS ships which will require modification to the data processing tools and DWH loading scripts. In addition, there are a number of optics sensors which presently are not included in the data processing tool and require additions and modifications to the data processing tools and DWH loading scripts.

2.0 Scope of Work Contractor support is required to provide support, maintenance and debugging for existing Marine Optics Branch Optics Data Processing Suite (ODPS) and Bioluminescence Data Processing Suite (BDPS), as well as further development and maintenance for existing Marine Optics Branch Optics Data Processing Suite (ODPS) and Bioluminescence Data Processing Suite (BDPS) software applications. This includes maintaining, debugging/fixing, and also updating the data ingest software for new optics and bioluminescence sensors, and maintaining and improving efficiency with creating and loading data to NAVOCEANO Data Warehouse and the Threaded Ocean Data Base (TODB).

Delivered software shall adhere to Department of Defense (DoD) and Navy cybersecurity requirements as defined in DOD Instruction 8500.01, OPNAV Instruction 5239.1D, and applicable Security Technical Implementation Guides (STIGs). In particular, all applications developed for use on Navy information systems shall adhere to the latest active release of the Application Security and Development (ASD) STIG.

The day to day work activities will range from software engineering, programming, database design, metadata builds, and maintaining, troubleshooting and enhancing/improving the processing, loading, cataloging and archival of in-situ marine optics and bioluminescence data. The contractor shall work within a classified environment up to GENSER SECRET within NAVOCEANO spaces. The contractor will be performing two (4) primary functions: (1) maintaining and troubleshooting the ability of this software to process in-situ optics and bioluminescence data using Government Off the Shelf (GOTS) software and databases that may also utilize and/or have Commercial Off the Shelf (COTS) software elements embedded within it, to include COTS GUI, display, relational database, and GIS solutions; (2) maintaining and troubleshooting the ability of this software to archive and load in-situ optics and bioluminescence data into the NAVOCEANO Data Warehouse and the Threaded Ocean Data Base (TODB) (3) modifying, upgrading and enhancing the ability of this software to be able to process new types of in-situ optics and bioluminescence data using Government Off the Shelf (GOTS) software and databases that may also utilize and/or have Commercial Off the Shelf (COTS) software elements embedded within it, to include COTS GUI, display, relational database, and GIS solutions; and (4) modifying and upgrading this software to be able to archive and load all types of in-situ optics and bioluminescence data into the NAVOCEANO Data Warehouse and the Threaded Ocean Data Base (TODB).

3.0 Tasks Critical

3.1 BDPS (Bioluminescence Data Processing Software) and associated tools for BIOLITE/UBAT data

A. The contractor shall maintain and troubleshoot all tools within BDPS (Biolum Data Processing Suite) to ingest Underwater Bioluminescence Assessment Tool (UBAT) datasets.

3.2 ODPS (Optics Data Processing Software). Maintain and troubleshoot problems identified by data processing personnel in testing and operational use of ODPS and/or employ alternative solutions to address such problems, as follows:

A. ODPS – Optics Edit Feature

Troubleshoot, maintain and debug ODPS – Troubleshoot, maintain and debug the Optics Edit Feature to be able to continue to ingest and edit each of the following instrument data types: transmissometer data

B. ODPS - OptmFileFinder Feature

Troubleshoot, maintain and debug ODPS – Troubleshoot, maintain and debug OPTM File Finder Feature to continue to be able to ingest and find each of the following instrument data types: transmissometer data C. ODPS - Trackplot

Troubleshoot, maintain and debug ODPS – Troubleshoot, maintain and debug Trackplot Feature to continue to be able to ingest and display each of the following instrument data types: transmissometer data

D. ODPS - OpticsLoad

Troubleshoot, maintain and debug ODPS – Troubleshoot, maintain and debug Optics Load Feature to be able to ingest and load each of the following instrument data types: transmissometer data

E. ODPS - CTD_process_GUI.m

Troubleshoot, maintain and debug ODPS – Troubleshoot, maintain and debug CTD_process_GUI.m to be able to ingest, identify, and process each of the following instrument data types: transmissometer data Essential/Enhancing

3.3 BDPS (Bioluminescence Data Processing Software) and associated tools for BIOLITE/UBAT data

A. The contractor shall modify/enhance all tools within BDPS (Biolum Data Processing Suite) to address new collection types and emerging requirements in order to ingest Underwater Bioluminescence Assessment Tool (UBAT) datasets.

3.4 ODPS (Optics Data Processing Software). Make specific modifications and additions to ODPS identified during testing and evaluation by data processing personnel, and/or employ alternative solutions to enhance the following components, as follows:

A. ODPS - CTD_process_GUI.m

Update, modify and enhance ODPS – Modify and add to CTD_process_GUI.m to be able to ingest, identify, and process each of the following instrument data types: UNOLS transmissometer data, HyperPro profile data (Ed, Lu, Kd), SPMR/SMSR profile data (Ed, Lu, Kd), HyperProII profile data (Ed, Lu, Kd), AC9 profile data (a, b, c), and ACS data (a, b, c). Add the ability to merge ACS and AC9 data with CTD profile data to add depth and time to profile, add the ability to correct for high transmission in transmissometer profiles properly.

B. ODPS – Optics Edit Feature

Update, modify and enhance ODPS – Modify and add to Optics Edit Feature to be able to ingest, identify, and edit each of the following instrument data types: UNOLS transmissometer data, HyperPro profile data (Ed, Lu, Kd), SPMR/SMSR profile data (Ed, Lu, Kd), HyperProII profile data (Ed, Lu, Kd), AC9 profile data (a, b, c), and ACS data (a, b, c).

C. ODPS - OptmFileFinder Feature

Update, modify and enhance ODPS – Modify and add to OPTM File Finder Feature to be able to ingest, identify, and search/find files for each of the following instrument data types: UNOLS transmissometer data, HyperPro profile data (Ed, Lu, Kd), SPMR/SMSR profile data (Ed, Lu, Kd), HyperProII profile data (Ed, Lu, Kd), AC9 profile data (a, b, c), and ACS data (a, b, c).

D. ODPS - Trackplot

Update, modify and enhance ODPS – Modify and add to Trackplot Feature to be able to ingest, identify, and geographically/graphically display each of the following instrument data types: UNOLS transmissometer data, HyperPro profile data (Ed, Lu, Kd), SPMR/SMSR profile data (Ed, Lu, Kd), HyperProII profile data (Ed, Lu, Kd), AC9 profile data (a, b, c), and ACS data (a, b, c).

D. ODPS - OpticsLoad

Update, modify and enhance ODPS – Modify Optics Load Feature to be able to ingest, identify, prepare, and load each of the following instrument data types to the NAVO DWH: UNOLS transmissometer data, HyperPro profile data (Ed, Lu, Kd), SPMR/SMSR profile data (Ed, Lu, Kd), HyperProII profile data (Ed, Lu, Kd), AC9 profile data (a, b, c), and ACS data (a, b, c).

3.3 Technical Requirements

At a minimum, the contractor shall:

a. be capable of working with FORTRAN, Java and C programming languages.

b. be capable of working with various scripting languages (e.g. Perl, SQL, UNIX, Linux).

c. be capable of working in the Unix, Linux, and Windows operating systems.

d. be capable of working with Local Area Networks (LANs), Storage Area Networks (SANs) and Wide Area Networks (WANs), and be specifically familiar with NAVOs systems.

e. be capable of working with various GIS software packages (e.g. the ESRI suite).

f. be capable of programming in C, C++, Java, and native languages of various COTS scientific display software applications (e.g. ProSoft, WetView, Seabird, MATLAB, ArcGIS, MicroSoft Office Suite, etc.).

g. be capable of working with relational database software and technologies (e.g. Oracle).

h. have experience in system and software integration.

3.4 Status Documentation

The contractor shall provide Status Documentation on a monthly basis, to include:

a. A status report summarizing the progress made on the previous month's maintenance and/or enhancements requirements.

b. The time accumulated against each task order, and any reworking that was required.

c. Any problems and/or new or unusual developments encountered during software and/or database development.

d. Planned work for the following month.

e. The summary shall include suggestions by the contractor based on lessons learned to streamline or otherwise improve the process.

Based on the evaluation of this summary, and on deliverables received from the contractor, NAVOCEANO will determine if the work is acceptable, and if necessary may request revisions as necessary. The report may also establish if Government provided equipment and/or COTS software resources are adequate for the task at hand.

4.0 Deliverables

The contractor shall:

a. Provide the monthly status reports as the defined in section 3.6 digitally in Microsoft Word .docx or Adobe Acrobat .pdf via encrypted and signed email to the NAVOCEANO NP33 Contracting Representative (COR).

b. Provide source and executable copies of modified software, with makefiles, jar files, and scripts, to build and properly locate executables in the test and operational run-stream of all processes. This will include all resource files, destination tables, and other files necessary for the proper functioning of the software (as staged on the operational system, and the contractor shall also provide a redundant copy of same on hard media to the COR at the completion of any specific task order - e.g. CD or DVD).

c. Develop source code, integrate COTS software, and develop and link to databases in accordance with the Programming Practices, Standards, and Conventions (PMI/PPS&C). Deliveries must be made in accordance with procedures set forth by the NAVOCEANO Information Assurance, Oceanographic Information Systems, and Information Technology administration personnel.

d. Provide updates to appropriate documentation for all new or modified software in accordance with J-STD-016-1995 guidelines.

e. Ensure that all software and/or database deliverables are capable of working on both unclassified and classified systems.

f. Attend periodic meetings with COR and NAVOCEANO technical POCs as needed to discuss progress made, modifications that are necessary, and problems that need to be fixed or addressed.

g. Provide output of the DISA ASD STIG compliance checking tool, i.e., the ASD STIG “checklist”, for all delivered software.

In addition, any and all deliverables shall not create any conflicts with any existing routines in the entire flow of all processes, shall be backward compatible to work with previous formats, etc., and must be tested to the satisfaction of the government end user(s).

5.0 Point of Contact

NAVOCEANO Databases and Analysis Code NP31 provides funding and management for this effort. The NAVOCEANO NP31 COR is Mr. Craig Fisher (Code NP3) who can be reached at (228) 688-5848 or via email at craig.fisher@navy.mil. Technical POC is Kenneth Matulewski who can be reached at (228) 688-5476 or via email at kenneth.matulewski@navy.mil. All contractual documentation, approvals, tracking, review meeting events, and monitoring will be conducted by the COR and the Technical POC.

6.0 Period of Performance

The Period of Performance is 12 months from the start date of this task order (September 27, 2018 to September 26, 2019).

7.0 Special Requirements

Access to NAVOCEANO systems from outside the Buildings 1002 complex and Building 1032 is restricted. Therefore, a majority of the work accomplished under this SOW will be performed at NAVOCEANO. Operational support outside the normal working hours may require contractor personnel to report to NAVOCEANO. Space will be provided for contractor personnel assigned to this contract for the period of performance.

In order to access Department of Defense (DoD) information systems, non-disclosure agreements may be required of the contractor and the contractor’s employees. The contractor shall provide properly executed non-disclosure agreements to the Contracting Officer prior to the contractor beginning any work on the systems requiring non-disclosure agreements.

8.0 Security Requirements

Work will be up to and at the SECRET level. Contractor personnel shall be required to have the appropriate security clearance to perform tasks under this Statement of Work. The contractor shall comply with the security requirements specified in attached DD Form 254. IT Level II (sensitive information access) as defined in SECNAV M5510.30 is also required.

9.0 Distribution of Government Technical Information

All technical data provided to the contractor by the government will be protected from public disclosure and disclosure to other government agencies in accordance with the markings contained thereon. All other information relating to the items to be delivered or services to be performed under this contract may not be disclosed by any means without prior approval of the authorized representative of the Contracting Officer’s Representative (COR). The contractor shall provide adequate physical protection to such information so as to preclude access by any person or entity not authorized such access by the government.

10.0 Quality Assurance Surveillance Plan

Measurement

1) Verified and documented optics and biolum data loads into Classified and Unclassified NAVOCEANO Data Warehouse.

FOR OFFICIAL USE ONLY