W912HQ22R0012 - IWR EMT RFP SF 33.pdf

CODE

(Hour)

PAGE(S)

until local time

X

A X B X C

D

EX

X G F 45 - 53

54 - 60 H 61 - 67

David.A.Kaplan@usace.army.mil

RATING PAGE OF PAGES

7. ISSUED BY

(Date)

IMPORTANT - Award will be made on this Form, or on Standard Form 26, or by other authorized official written notice.

Previous Edition is Unusable 33-134 STANDARD FORM 33 (REV. 9-97)

Prescribed by GSA FAR (48 CFR) 53.214(c)

1 67

(If other than Item 7)

15A. NAME 16. NAME AND TITLE OF PERSON AUTHORIZED TO

AND

ADDRESS

SIGN OFFER (Type or print)

OF

OFFEROR

AMENDMENT NO. DATE

15B. TELEPHONE NO (Include area code) 17. SIGNATURE15C. CHECK IF REMITTANCE ADDRESS

IS DIFFERENT FROM ABOVE - ENTER

SUCH ADDRESS IN SCHEDULE.

18. OFFER DATE

1. THIS CONTRACT IS A RATED ORDER

UNDER DPAS (15 CFR 700)

2. CONTRACT NO.

W912HQ 8. ADDRESS OFFER TO

See Item 7

9. Sealed offers in original and copies for furnishing the supplies or services in the Schedule will be received at the place specified in Item 8, or if handcarried, in the depository located in

CAUTION - LATE Submissions, Modifications, and Withdrawals: See Section L, Provision No. 52.214-7 or 52.215-1. All offers are subject to all terms and conditions contained in this solicitation.

10. FOR INFORMATION

CALL:

A. NAME (NO COLLECT CALLS)

DAVID A KAPLAN 703-428-8487

11. TABLE OF CONTENTS

SOLICITATION/ CONTRACT FORM

SUPPLIES OR SERVICES AND PRICES/ COSTS

2 - 14

X I CONTRACT CLAUSES

DESCRIPTION/ SPECS./ WORK STATEMENT X

PACKAGING AND MARKING

15 - 33 J LIST OF ATTACHMENTS

INSPECTION AND ACCEPTANCE

DELIVERIES OR PERFORMANCE

34 - 35 36 - 38

X K

REPRESENTATIONS, CERTIFICATIONS AND

OTHER STATEMENTS OF OFFERORS

CONTRACT ADMINISTRATION DATA 39 X

SPECIAL CONTRACT REQUIREMENTS

OFFER (Must be fully completed by offeror) X M

L INSTRS., CONDS., AND NOTICES TO OFFERORS

EVALUATION FACTORS FOR AWARD

NOTE: Item 12 does not apply if the solicitation includes the provisions at 52.214-16, Minimum Bid Acceptance Period.

is inserted by the offeror) from the date for receipt of offers specified above, to furnish any or all items upon which prices are offered at the price set opposite each item, delivered at the designated point(s), within the time specified in the schedule.

13. DISCOUNT FOR PROMPT PAYMENT

(See Section I, Clause No. 52.232-8)

14. ACKNOWLEDGMENT OF AMENDMENTS

(The offeror acknowledges receipt of amendments

AMENDMENT NO. DATE

to the SOLICITATION for offerors and related documents numbered and dated):

FACILITY

12. In compliance with the above, the undersigned agrees, if this offer is accepted within calendar days (60 calendar days unless a different period

SOLICITATION, OFFER AND AWARD

X

(X) SEC. DESCRIPTION (X) SEC. DESCRIPTION PAGE(S)

PART I - THE SCHEDULE

26. NAME OF CONTRACTING OFFICER (Type or print) 27. UNITED STATES OF AMERICA 28. AWARD DATE

EMAIL:TEL: (Signature of Contracting Officer)

CODE CODE

B. TELEPHONE (Include area code) C. E-MAIL ADDRESS

AWARD (To be completed by Government)

19. ACCEPTED AS TO ITEMS NUMBERED 20. AMOUNT 21. ACCOUNTING AND APPROPRIATION

22. AUTHORITY FOR USING OTHER THAN FULL AND OPEN COMPETITION:

10 U.S.C. 2304(c)( ) 41 U.S.C. 253(c)( ) (4 copies unless otherwise specified)

23. SUBMIT INVOICES TO ADDRESS SHOWN IN ITEM

24. ADMINISTERED BY (If other than Item 7) CODE 25. PAYMENT WILL BE MADE BY CODE

PART IV - REPRESENTATIONS AND INSTRUCTIONS

PART III - LIST OF DOCUMENTS, EXHIBITS AND OTHER ATTACHMENTS

40 - 43

PART II - CONTRACT CLAUSES

USACE HUMPHREYS ENGR CTR SPT ACTIVITY

ATTN: CEHEC-CT,

7701 TELEGRAPH ROAD

ALEXANDRIA VA 22315-3860

FAX:

TEL:

FAX:

TEL:

NOTE: In sealed bid solicitations "offer" and "offeror" mean "bid" and "bidder".

SOLICITATION

6. REQUISITION/PURCHASE NO.5. DATE ISSUED4. TYPE OF SOLICITATION

SEALED BID (IFB)

NEGOTIATED (RFP)

[ X ]

3. SOLICITATION NO.

W912HQ22R0012 24AUG2022

4:30PM 19SEP2022electronically via email as detailed below in 10 C.

1 PDF

W912HQ22R0012

Section B - Supplies or Services and Prices

ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT

0001 1 Job

EMT Operations and Maintenance - Base

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete the base tasks for the base year of services in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

FOB: Destination

PSC CD: DA01

NET AMT

ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT

0002 1 Job

Travel Costs Base Year

COST

The Government will reimburse travel at actual cost without any profit. The appropriate Government Official, Quality Assurance Personnel or Contracting Officer will approve travel. All invoices for travel shall be accompanied by supporting receipts.

FOB: Destination

PSC CD: DA01

ESTIMATED COST

ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT

1001 1 Job OPTION EMT O&M: Opt. Yr. 1

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete the base tasks (1-5) for Option Year 1 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

FOB: Destination

NET AMT

1002 1 Job OPTION Travel Costs Option Year 1

COST

The Government will reimburse travel at actual cost without any profit. The appropriate Government Official, Quality Assurance Personnel or Contracting Officer will approve travel. All invoices for travel shall be accompanied by supporting receipts.

1003 1 Job OPTION Option Task 1 - Opt. Yr 1

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 1 for Option Year 1 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

1004 1 Job OPTION Option Task 2 - Opt. Yr 1

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 2 for Option Year 1 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

1005 1 Job OPTION Option Task 3 - Opt. Yr 1

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 3 for Option Year 1 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

1006 1 Job OPTION Option Task 4 - Opt. Yr 1

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 4 for Option Year 1 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

1007 1 Job OPTION Option Task 5 - Opt. Yr 1

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 5 for Option Year 1 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

2001 1 Job OPTION EMT O&M: Opt. Yr 2

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete the base tasks (1-5) for Option Year 2 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

2002 1 Job OPTION Travel Costs Option Year 2

COST

The Government will reimburse travel at actual cost without any profit. The appropriate Government Official, Quality Assurance Personnel or Contracting Officer will approve travel. All invoices for travel shall be accompanied by supporting receipts.

ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT

2003 1 Job OPTION Option Task 1 - Opt. Yr 2

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 1 for Option Year 2 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

NET AMT

ITEM NO SUPPLIES/SERVICES QUANTITY UNIT UNIT PRICE AMOUNT

2004 1 Job OPTION Option Task 2 - Opt. Yr 2

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 2 for Option Year 2 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

2005 1 Job OPTION Option Task 3 - Opt. Yr 2

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 3 for Option Year 2 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool

2006 1 Job OPTION Option Task 4 - Opt. Yr 2

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 4 for Option Year 2 in accordance with the

2007 1 Job OPTION Option Task 5 - Opt. Yr 2

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 5 for Option Year 2 in accordance with the

3001 1 Job OPTION EMT O&M: Opt. Yr 3

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete the base tasks (1-5) for Option Year 3 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

3002 1 Job OPTION Travel Costs Option Year 3

COST

The Government will reimburse travel at actual cost without any profit. The appropriate Government Official, Quality Assurance Personnel or Contracting Officer will approve travel. All invoices for travel shall be accompanied by supporting receipts.

3003 1 Job OPTION Option Task 1 - Opt. Yr 3

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 1 for Option Year 3 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

3004 1 Job OPTION Option Task 2 - Opt. Yr 3

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 2 for Option Year 3 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

3005 1 Job OPTION Option Task 3 - Opt. Yr 3

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 3for Option Year 3 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

4001 1 Job OPTION EMT O&M: Opt. Yr 4

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete the base tasks (1-5) for Option Year 4 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

4002 1 Job OPTION Travel Costs Option Year 4

COST

The Government will reimburse travel at actual cost without any profit. The appropriate Government Official, Quality Assurance Personnel or Contracting Officer will approve travel. All invoices for travel shall be accompanied by supporting receipts.

4003 1 Job OPTION Option Task 1 - Opt. Yr 4

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 1 for Option Year 4 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

4004 1 Job OPTION Option Task 2 - Opt. Yr 4

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 2 for Option Year 4 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

4005 1 Job OPTION Option Task 3 - Opt. Yr 4

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 3 for Option Year 4 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

4006 1 Job OPTION Option Task 4 - Opt. Yr 4

FFP

Contractor shall provide all labor, supervision, management and materials necessary to complete Option Task 4 for Option Year 4 in accordance with the attached Performance Work Statement entitled "IWR Enterprise Management Tool (EMT) Operations and Maintenance".

Section C - Descriptions and Specifications

PERFORMANCE WORK STATEMENT

IWR ENTERPRISE MANAGEMENT TOOL (EMT) OPERATIONS AND MAINTENANCE (O&M)

PERFORMANCE WORK STATEMENT (PWS)

1. BACKGROUND

The EMT is an Institute for Water Resources (IWR) tool for project, program, and enterprise management using Oracle, ColdFusion and JavaScript. The EMT is made up of two components, a Project Management Tool and a Dashboard. The current Project Management Tool has been operational since 2009 and the Dashboard since 2015.

The Project Management Tool is a planning tool used by project managers, budget/program analysts and the IWR Corporate Board. In addition to Project Management Plans (PMPs) for individual projects, the EMT is a repository of data for all IWR projects and is used to generate project and corporate level reports.

The Dashboard is a management tool used by the IWR Corporate Board for enterprise management. It provides a single location for management to view a general IWR profile and evaluate the overall performance of the organization using key indicators (travel, overhead, funding and manpower). The displays show trends with the ability to forecast U.S. Army Corps of Engineers (USACE) data as it relates to IWR and is available for management to have monthly In Progress Reviews.

2. SCOPE

The EMT is a fully operational system currently residing within the Corps network and operating within the Civil Works Business Intelligence (CWBI) Amazon Web Services (AWS) Cloud hosting environment. The work under this contract shall provide the regular operations and maintenance for the EMT to support IWR program and project management and its enterprise oversight and management.

The creation and maintenance of virtual private clouds, web application firewalls, reverse proxies, software installation, etc. will be the responsibility of a third-party cloud provider. However, work under this contract requires a detailed understanding of AWS generally and the configuration of these technologies specifically in order to maintain the EMT application and request revisions to the configuration. It also includes a need to understand security at every level. Technologies used include AWS Elastic Container Service (ECS), AWS Code Pipeline, AWS CodeCommit, AWS Elastic Container Repository, Docker, AWS Simple Email Service (SES), AWS Secrets Manager, AWS CloudWatch, AWS CloudTrail, AWS Simple Storage Service (S3), and AWS Relational Database Service (RDS) for Oracle 19c in the CWBI Govcloud environment.

The contractor must be familiar with USACE Project Delivery Business Processes (PDBP) and related guidance, US Army Corps of Engineers Financial Management System (CEFMS) II, Program and Project Management Information System (PROMIS), the USACE Enterprise Data Warehouse and Chief Information Office (CIO)/G-6 Information Technology (IT) requirements and guidance along with industry best practices.

3. GENERAL REQUIREMENTS

The following sub-sections provide details of various general requirements for this effort.

3.1 Non-Personal Services

The contractor shall provide strictly non-personal services and contractor employees are not subject to direct supervision and control by the Government. The contractor shall advise and support the Government but shall not make final decisions or certifications on behalf of the Government nor perform any inherently governmental functions. The contractor and its employees shall not represent the Government nor appear to represent the Government in performance of these contract services. Contractor personnel shall clearly identify themselves as contractor employees in all interactions during contract performance.

3.2 Place of Performance

All work under this contract will be performed at the contractor’s site.

3.3 Period of Performance

The period of performance (PoP) for the base contract is twelve (12) months. Four optional years are also included, which will be executed at the end of each subsequent year assuming funds are available.

3.4 Materials

All materials, minus expendable supplies, purchased by the contractor with funds from this contract and used as part of this contract, become and remain the property of the Government.

3.5 Travel

Two onsite visits to the Alexandria, VA office by the contractor’s primary Program Manager and local team member (if required).

4. PERFORMANCE REQUIREMENTS (TASK AREAS)

4.1 Regular EMT Operations and Maintenance Task Areas

The activities within this task area will be evaluated and prioritized by the IWR Project Manager and contracting officer representative (COR). Activities will reflect program requirements and resolution of user issues. The testing of all database and interface modifications will be performed on government furnished equipment (GFE). This requirement is designed to provide service for 12 months from the date of award.

4.1.1 Task 1. Routine Maintenance: The contractor shall provide regular maintenance to ensure the EMT operates on a continuous basis to include:

• Posting of revised web pages and related files after local revision and testing. Typical tasks include:

o Maintaining ColdFusion Docker container image with web application o Deploying container locally in Docker and testing deployment locally prior to any push to

AWS ECS

o Deploying container to AWS ECS test environment and subsequent Quality Assurance (QA) o Deploying container to AWS ECS production environment and subsequent QA o Responding to vulnerabilities reported via container and website scans o Revising Docker container implementation based on needed revisions to address vulnerabilities or changes to the ColdFusion container images o Maintaining underlying JavaScript packages o Maintaining needed secrets for container deployment o Responding to revisions to the AWS ECS deployment task definitions o Creating of, responding to, and verification of Jira tickets

• Assistance with modification of database tables

• Resolution of minor operating bug fixes

• Minor report and functionality revisions

• Revisions to the EMT Control Panel

• QA related to posting of revised files

• Review EMT Dashboard files and operability

• Improvements to EMT Dashboard display and export layouts

• Improvements to EMT Project Management Tool display and export layouts

• New data code updates

• Resolving EMT user issues and assistance with monitoring implementation of new user registration

• Modifying IWR performance measure parameters tracked in the EMT

• Modifying required data format for display changes, such as revisions to EMT functionality when browser functionality changes, revisions to accommodate database or other platform updates or EMT CWBI configuration reviews

• Examples of FY21 and FY22 work in this category include revisions or updates to:

o Handling of existing and new fund appropriations to include Revolving Funds and revisions of associated reports o PMP Project Record and Project Status functionality o PM Tool Reports such as the Direct Funding by AMSCO report, Labor Hours by Supervisor Report and Budget Forecast Report o PMP Activities and Resources functionality o “All PMPs” and “Projects” functionality and display o Duplication and snapshot functionality in the PM Tool o PDF reporting related to browser changes o Software updates (jQuery, ColdFusion, etc.)

o Deliverables and Milestones functionality and reporting o User access and login (ongoing) o Dashboard Data Displays and revisions to available reports and graphics

4.1.2 Task 2. EMT Modifications: The contractor shall perform modifications to the EMT to provide management with required information views for management decisions to include both the Project Management Tool and Dashboard. This shall include Project Management Tool modifications to current reports and modules and generation of new reports. Dashboard modifications shall include performance measure target parameter changes and displays. Dashboard profile views display modifications, both graph and data, and some new views within the current data sets. The specific reports are TBD but shall include approximately 10 modifications and the development of 5 new reports. EMT Modifications will include:

Information views for management decisions for the Project Management Tool o Modifications to current reports and modules o Generation of new reports

Information views for management decisions for the Dashboard o Performance measure target parameter revisions o Performance measure display revisions o Profile view display modifications, both graph and data o New profile views (graph and data) within the current data sets

Finalize functionality needed to move the EMT to CAC log-in. Possible tasks include creating new log-in procedures in the EMT App using communication with Test Keycloak Server, revising people management to integrate with Keycloak Server and submitting required tickets to facilitate the transition.

Investigate ability to incorporate USACE data visualization services, such as Qlik Sense or Microsoft Power BI, for EMT Dashboard and reports in the Project Management Tool

Examples of modifications made in FY21 and FY22 include:

o Revisions to functionality, specifically in the PMP Obligation Project Plan module and reporting related to new USACE carryout rules o Revisions to functionality with Direct Funding by AMSCO report utilizing repositioned data for September reports o Creation of a new earned value report o Modifications to General Expenses (GE) 410 funding handling and reporting o Refinements to organization structure in both the PM Tool and Dashboard o Incorporating Projects without a P2 Number in the PM Tool

4.1.3 Task 3. Data Updates: The contractor shall support the Government team to refresh EMT data and production modules. The contractor shall perform regular quality assurance evaluations to ensure system integrity on a regular basis. The Project Management Tool is updated by the Government team mid-month and at the end of the month (approximately 15 files). The Dashboard is updated monthly using data updated for the Project Management Tool.

The Project Management Tool, Direct Funding Status by Army Management Structure Code (AMSCO), will be updated by the Government team within one business day of receiving notification of either data availability or data files while the complete Project Management Tool and Dashboard are updated within three business days.

The contractor shall make minor updates to underlying data structure, queries and views that are occasionally needed to support Project Management Tool and Dashboard reporting.

Contractor efforts related to this task shall include:

Perform regular QA evaluations to ensure system integrity Provide QA review of the Project Management Tool mid-month and end of the month (within 1 day of data availability) Provide QA review of the Dashboard end of the month (within 1 day of data availability) Review Project Management Tool Direct Funding Status by Army Management Structure Code

(AMSCO) report data within one working day of receiving notification of data availability Update queries and views that support Project Management Tool and Dashboard reporting Update underlying data structure that supports Project Management Tool and Dashboard reporting Assist the Government team with refreshing EMT data and production modules when needed.

Examples of additional specific work handled under this task during FY21 and FY22:

o Evaluate data regarding repositioned funds data incorporation with the monthly update and its effect on current reports and schedules o Data troubleshooting for both PM Tool and Dashboard o Migrate data to the appropriate CWBI AWS database (i.e. Production, Test or Development) o Appropriations structure review and revision for how data is pulled into the EMT

4.1.4 Task 4. Bi-Monthly In-Progress Reviews (IPRs) and Quarterly CWBI Sharing Sessions: The contractor shall participate in bi-monthly IPRs with the EMT Government team and in Quarterly CWBI Sharing Sessions. The IPRs shall be 1-hour in duration, and during the IPRs, the IWR Project Manager and COR will consult with the contractor to evaluate and prioritize specific EMT activities to be accomplished.

Additional requests for updates and enhancements will be forwarded to the contractor by the IWR Project Manager for evaluation and addressed by the contractor during the bi-monthly IPRs through prioritization recommendations. The contractor shall prepare an agenda for each IPR to facilitate discussions. Additional reviews shall be conducted upon request from the IWR Project Manager or the contractor for new or major revision activities. Other ad hoc meetings, such as with the CWBI team, may be required on an as-needed basis. During those months, the ad hoc meetings take the place of the bi-monthly IPRs. For situational awareness, the contractor shall also attend Quarterly CWBI Sharing Sessions that are 1-hour in duration and hosted by the CWBI Program Office. These sessions cover topics specific to CWBI regarding Management, Data, Technical, Cybersecurity and Operational updates.

4.1.5 Task 5. Documentation: The contractor shall update, create, revise and/or maintain:

Project Management Tool User Guide Project Management Tool and Dashboard report data loading and format parameters and process.

EMT System Data Management Manual EMT System Management Manual Dashboard User Guide Dashboard Technical documentation EMT for documentation for CWBI in DI2E EMT ticketing information for CWBI in Jira Online help documents and pages Test plan documentation ASD STIG checklist review

4.2 Option Year 1 EMT Operations and Maintenance Task Areas

The activities within this task area will be evaluated and prioritized by the IWR Project Manager and contracting officer representative (COR). Activities will reflect program requirements and resolution of user issues. The testing of all database and interface modifications will be performed on government furnished equipment (GFE). This

4.2.1 Task 1. Routine Maintenance: The contractor shall provide regular maintenance to ensure the EMT

• Posting of revised web pages and related files after local revision and testing. Typical tasks include:

o Maintaining ColdFusion Docker container image with web application o Deploying container locally in Docker and testing deployment locally prior to any push to

AWS ECS

o Deploying container to AWS ECS test environment and subsequent Quality Assurance (QA) o Deploying container to AWS ECS production environment and subsequent QA o Responding to vulnerabilities reported via container and website scans o Revising Docker container implementation based on needed revisions to address vulnerabilities or changes to the ColdFusion container images o Maintaining underlying JavaScript packages o Maintaining needed secrets for container deployment o Responding to revisions to the AWS ECS deployment task definitions o Creating of, responding to, and verification of Jira tickets

• Assistance with modification of database tables

• Resolution of minor operating bug fixes

• Minor report and functionality revisions

• Revisions to the EMT Control Panel

• QA related to posting of revised files

• Review EMT Dashboard files and operability

• Improvements to EMT Dashboard display and export layouts

• Improvements to EMT Project Management Tool display and export layouts

• New data code updates

• Resolving EMT user issues and assistance with monitoring implementation of new user registration Resolving or modifying functionality for CAC log-in and submitting tickets if needed related to

Keycloak server issues Modifying IWR performance measure parameters tracked in the EMT Modifying required data format for display changes, such as revisions to EMT functionality when browser functionality changes, revisions to accommodate database or other platform updates or EMT CWBI configuration reviews

4.2.2 Task 2. EMT Modifications: The contractor shall perform modifications to the EMT to provide

Management Tool and Dashboard. This shall include Project Management Tool modifications to current reports and modules and generation of new reports. Dashboard modifications shall include performance measure target parameter changes and displays. Dashboard profile views display modifications, both graph and data, and some new views within the current data sets. The specific reports are TBD but shall include approximately 10 modifications and the development of 5 new reports. EMT Modifications will include:

Information views for management decisions for the Project Management Tool o Modifications to current reports and modules o Generation of new reports

Information views for management decisions for the Dashboard o Performance measure target parameter revisions o Performance measure display revisions o Profile view display modifications, both graph and data o New profile views (graph and data) within the current data sets

Continue efforts to investigate the ability to incorporate USACE data visualization services, such as Qlik Sense or Microsoft Power BI, for EMT Dashboard and reports in the Project Management Tool

4.2.3 Task 3. Data Updates: The contractor shall support the Government team to refresh EMT data and production modules. The contractor shall perform regular QA evaluations to ensure system integrity on a regular basis. The Project Management Tool is updated by the Government team mid-month and at the end of the month (approximately 15 files). The Dashboard is updated monthly using data updated for the Project Management Tool.

The Project Management Tool, Direct Funding Status by Army Management Structure Code (AMSCO), will be updated by the Government team within one business day of receiving notification of either data availability or data files while the complete Project Management Tool and Dashboard are updated within three business days.

The contractor shall make minor updates to underlying data structure, queries and views that are occasionally needed to support Project Management Tool and Dashboard reporting.

Contractor efforts related to this task shall include:

Perform regular QA evaluations to ensure system integrity Provide QA review of the Project Management Tool mid-month and end of the month (within 1 day of data availability) Provide QA review of the Dashboard end of the month (within 1 day of data availability) Review Project Management Tool Direct Funding Status by Army Management Structure Code

(AMSCO) report data within one working day of receiving notification of data availability Update queries and views that support Project Management Tool and Dashboard reporting Update underlying data structure that supports Project Management Tool and Dashboard reporting Assist the Government team with refreshing EMT data and production modules when needed.

4.2.4 Task 4. Bi-Monthly In-Progress Reviews (IPRs) and Quarterly CWBI Sharing Sessions: The contractor

Sessions. The IPRs shall be 1-hour in duration, and during the IPRs, the IWR Project Manager and COR will consult with the contractor to evaluate and prioritize specific EMT activities to be accomplished.

Additional requests for updates and enhancements will be forwarded to the contractor by the IWR Project Manager for evaluation and addressed by the contractor during the bi-monthly IPRs through prioritization recommendations. The contractor shall prepare an agenda for each IPR to facilitate discussions. Additional reviews shall be conducted upon request from the IWR Project Manager or the contractor for new or major revision activities. Other ad hoc meetings, such as with the CWBI team, may be required on an as-needed basis. During those months, the ad hoc meetings take the place of the bi-monthly IPRs. For situational awareness, the contractor shall also attend Quarterly CWBI Sharing Sessions that are 1-hour in duration

4.2.5 Task 5. Documentation: The contractor shall update, create, revise and/or maintain:

Project Management Tool and Dashboard report data loading and format parameters and process.

EMT System Data Management Manual EMT System Management Manual Dashboard User Guide Dashboard Technical documentation EMT for documentation for CWBI in DI2E (or current application used by CWBI) EMT ticketing information for CWBI in Jira Online help documents and pages

4.2.6 Optional Task 1. EMT Modernization Phase 1: Modernize Dashboard – Modernize the EMT Dashboard by establishing it as its own microservice, including taking advantage of new cloud native tools available to the CWBI cloud. This will require data availability through a Representational State Transfer Application Programming Interface (REST API) service. This task will include project management, new system diagrams, new containerization, programming, quality assurance, documentation, and possibly design mockups.

4.2.7 Optional Task 2. Enhance CWBI Data Integration: Update CWBI data integration to include linking directly to CWBI data and reporting where allowed. This task may require additional data views in the database and updating of the monthly data update processes and, perhaps, underlying tables. This task includes designs illustrating any changes to data usage and how database table, view and query structure will change. It also includes project management, programming, quality assurance, and documentation.

4.2.8 Optional Task 3. Incorporate Qlik Sense or Microsoft Power BI: Based on the investigations done in Base

Task 2, the contractor shall implement the functionality required to incorporate Qlik Sense or Microsoft Power BI displays in the EMT Dashboard and/or reports in the Project Management Tool. The Government team shall acquire required licenses.

4.2.9 Optional Task 4. Refine Functionality for second Engineer Reporting Organization Code (EROC)’s use of the EMT: The previous EMT contract included a task to expand the EMT for use by a second USACE EROC (HQUSACE Planning and Policy Division). The contractor shall assist with adding parameters and reviewing current parameters for the additional EROC, ensuring data and reporting provide expected outputs. The contractor shall assist with processing monthly data updates and associated reports. The contractor shall expand Dashboard functionality to add the additional EROC.

4.2.10 Optional Task 5. Mandatory USACE Software Updates: The contractor shall perform the required coding changes due to USACE changes to application versions that impact application design or functionality.

The Government team shall acquire required licenses if applicable.

4.3 Option Year 2 EMT Operations and Maintenance Task Areas

The activities within this task area will be evaluated and prioritized by the IWR Project Manager and contracting officer representative (COR). Activities will reflect program requirements and resolution of user issues. The testing of all database and interface modifications will be performed on government furnished equipment (GFE). This

4.3.1 Task 1. Routine Maintenance: The contractor shall provide regular maintenance to ensure the EMT

• Posting of revised web pages and related files after local revision and testing. Typical tasks include:

o Maintaining ColdFusion Docker container image with web application o Deploying container locally in Docker and testing deployment locally prior to any push to

AWS ECS

o Deploying container to AWS ECS test environment and subsequent Quality Assurance (QA) o Deploying container to AWS ECS production environment and subsequent QA o Responding to vulnerabilities reported via container and website scans o Revising Docker container implementation based on needed revisions to address vulnerabilities or changes to the ColdFusion container images o Maintaining underlying JavaScript packages o Maintaining needed secrets for container deployment o Responding to revisions to the AWS ECS deployment task definitions o Creating of, responding to, and verification of Jira tickets

• Assistance with modification of database tables

• Resolution of minor operating bug fixes

• Minor report and functionality revisions

• Revisions to the EMT Control Panel

• QA related to posting of revised files

• Review EMT Dashboard files and operability

• Improvements to EMT Dashboard display and export layouts

• Improvements to EMT Project Management Tool display and export layouts

• New data code updates

• Resolving EMT user issues and assistance with monitoring implementation of new user registration Resolving or modifying functionality for CAC log-in and submitting tickets if needed related to

Keycloak server issues Modifying IWR performance measure parameters tracked in the EMT Modifying required data format for display changes, such as revisions to EMT functionality when browser functionality changes, revisions to accommodate database or other platform updates or EMT CWBI configuration reviews

Maintain required Qlik Sense or Power BI functionality for EMT Dashboard and Project Management Tool (if incorporated with previous Optional Task)

4.3.2 Task 2. EMT Modifications: The contractor shall perform modifications to the EMT to provide

Management Tool and Dashboard. This shall include Project Management Tool modifications to current reports and modules and generation of new reports. Dashboard modifications shall include performance measure target parameter changes and displays. Dashboard profile views display modifications, both graph and data, and some new views within the current data sets. The specific reports are TBD but shall include approximately 10 modifications and the development of 5 new reports. EMT Modifications will include:

Information views for management decisions for the Project Management Tool o Modifications to current reports and modules o Generation of new reports

Information views for management decisions for the Dashboard o Performance measure target parameter revisions o Performance measure display revisions o Profile view display modifications, both graph and data o New profile views (graph and data) within the current data sets

4.3.3 Task 3. Data Updates: The contractor shall support the Government team to refresh EMT data and production modules. The contractor shall perform regular QA evaluations to ensure system integrity on a regular basis. The Project Management Tool is updated by the Government team mid-month and at the end of the month (approximately 15 files). The Dashboard is updated monthly using data updated for the Project Management Tool.

The Project Management Tool, Direct Funding Status by Army Management Structure Code (AMSCO), will be updated by the Government team within one business day of receiving notification of either data availability or data files while the complete Project Management Tool and Dashboard are updated within three business days.

The contractor shall make minor updates to underlying data structure, queries and views that are occasionally needed to support Project Management Tool and Dashboard reporting.

Contractor efforts related to this task shall include:

Perform regular QA evaluations to ensure system integrity Provide QA review of the Project Management Tool mid-month and end of the month (within 1 day of data availability) Provide QA review of the Dashboard end of the month (within 1 day of data availability) Review Project Management Tool Direct Funding Status by Army Management Structure Code

(AMSCO) report data within one working day of receiving notification of data availability Update queries and views that support Project Management Tool and Dashboard reporting

4.3.4 Task 4. Bi-Monthly In-Progress Reviews (IPRs) and Quarterly CWBI Sharing Sessions: The contractor

Sessions. The IPRs shall be 1-hour in duration, and during the IPRs, the IWR Project Manager and COR will consult with the contractor to evaluate and prioritize specific EMT activities to be accomplished.

Additional requests for updates and enhancements will be forwarded to the contractor by the IWR Project Manager for evaluation and addressed by the contractor during the bi-monthly IPRs through prioritization recommendations. The contractor shall prepare an agenda for each IPR to facilitate discussions. Additional reviews shall be conducted upon request from the IWR Project Manager or the contractor for new or major revision activities. Other ad hoc meetings, such as with the CWBI team, may be required on an as-needed basis. During those months, the ad hoc meetings take the place of the bi-monthly IPRs. For situational awareness, the contractor shall also attend Quarterly CWBI Sharing Sessions that are 1-hour in duration

4.3.5 Task 5. Documentation: The contractor shall update, create, revise and/or maintain:

Project Management Tool and Dashboard report data loading and format parameters and process.

EMT System Data Management Manual EMT System Management Manual Dashboard User Guide Dashboard Technical documentation EMT for documentation for CWBI in DI2E (or current application used by CWBI) EMT ticketing information for CWBI in Jira Online help documents and pages

4.3.6 Optional Task 1. EMT Modernization Phase 2: Modernize Project Management Tool – Modernize the PM Tool, both reporting and project management plan functionality, to make it a standalone microservice taking advantage of new cloud native tools available to the CWBI cloud. This will require data availability through a REST API service. This task will include project management, new system diagrams, design mockups, new containerization, programming, quality assurance, and documentation.

4.3.7 Optional Task 2. Enhance CWBI Data Integration: Update CWBI data integration to include linking directly to CWBI data and reporting where allowed. This task may require additional data views in the database and updating of the monthly data update processes and, perhaps, underlying tables. This task includes designs illustrating any changes to data usage and how database table, view and query structure

4.3.8 Optional Task 3. EMT Branding and Layout – The contractor shall update the look-and-feel of the EMT to new USACE branding or other concepts. This task includes creation of design mockups, project management, programming, quality assurance, and documentation.

4.3.9 Optional Task 4. Refine Functionality for second Engineer Reporting Organization Code (EROC)’s use of

EROC (HQUSACE Planning and Policy Division). The contractor shall assist with adding parameters and reviewing current parameters for the additional EROC, ensuring data and reporting provide expected outputs. The contractor shall assist with processing monthly data updates and associated reports. The contractor shall maintain Dashboard functionality for the additional EROC.

4.3.10 Optional Task 5. Mandatory USACE Software Updates: The contractor shall perform the required coding changes due to USACE changes to application versions that impact application design or functionality.

4.4 Option Year 3 EMT Operations and Maintenance Task Areas

The activities within this task area will be evaluated and prioritized by the IWR Project Manager and contracting officer representative (COR). Activities will reflect program requirements and resolution of user issues. The testing of all database and interface modifications will be performed on government furnished equipment (GFE). This

4.4.1 Task 1. Routine Maintenance: The contractor shall provide regular maintenance to ensure the EMT

• Posting of revised web pages and related files after local revision and testing. Typical tasks include:

o Maintaining ColdFusion Docker container image with web application o Deploying container locally in Docker and testing deployment locally prior to any push to

AWS ECS

o Deploying container to AWS ECS test environment and subsequent Quality Assurance (QA) o Deploying container to AWS ECS production environment and subsequent QA o Responding to vulnerabilities reported via container and website scans o Revising Docker container implementation based on needed revisions to address vulnerabilities or changes to the ColdFusion container images o Maintaining underlying JavaScript packages o Maintaining needed secrets for container deployment o Responding to revisions to the AWS ECS deployment task definitions o Creating of, responding to, and verification of Jira tickets

• Assistance with modification of database tables

• Resolution of minor operating bug fixes

• Minor report and functionality revisions

• Revisions to the EMT Control Panel

• QA related to posting of revised files

• Review EMT Dashboard files and operability

• Improvements to EMT Dashboard display and export layouts

• Improvements to EMT Project Management Tool display and export layouts

• New data code updates

• Resolving EMT user issues and assistance with monitoring implementation of new user registration Resolving or modifying functionality for CAC log-in and submitting tickets if needed related to

Keycloak server issues Modifying IWR performance measure parameters tracked in the EMT Modifying required data format for display changes, such as revisions to EMT functionality when browser functionality changes, revisions to accommodate database or other platform updates or EMT CWBI configuration reviews

4.4.2 Task 2. EMT Modifications: The contractor shall perform modifications to the EMT to provide

Management Tool and Dashboard. This shall include Project Management Tool modifications to current reports and modules and generation of new reports. Dashboard modifications shall include performance measure target parameter changes and displays. Dashboard profile views display modifications, both graph and data, and some new views within the current data sets. The specific reports are TBD but shall include approximately 10 modifications and the development of 5 new reports. EMT Modifications will include:

Information views for management decisions for the Project Management Tool o Modifications to current reports and modules o Generation of new reports

Information views for management decisions for the Dashboard o Performance measure target parameter revisions o Performance measure display revisions

4.4.3 Task 3. Data Updates: The contractor shall support the Government team to refresh EMT data and production modules. The contractor shall perform regular QA evaluations to ensure system integrity on a regular basis. The Project Management Tool is updated by the Government team mid-month and at the end of the month (approximately 15 files). The Dashboard is updated monthly using data updated for the Project Management Tool.

The Project Management Tool, Direct Funding Status by Army Management Structure Code (AMSCO), will be updated by the Government team within one business day of receiving notification of either data availability or data files while the complete Project Management Tool and Dashboard are updated within three business days.

The contractor shall make minor updates to underlying data structure, queries and views that are occasionally needed to support Project Management Tool and Dashboard reporting.

Contractor efforts related to this task shall include:

Perform regular QA evaluations to ensure system integrity Provide QA review of the Project Management Tool mid-month and end of the month (within 1 day of data availability) Provide QA review of the Dashboard end of the month (within 1 day of data availability) Review Project Management Tool Direct Funding Status by Army Management Structure Code

(AMSCO) report data within one working day of receiving notification of data availability Update queries and views that support Project Management Tool and Dashboard reporting

4.4.4 Task 4. Bi-Monthly In-Progress Reviews (IPRs) and Quarterly CWBI Sharing Sessions: The contractor

Sessions. The IPRs shall be 1-hour in duration, and during the IPRs, the IWR Project Manager and COR will consult with the contractor to evaluate and prioritize specific EMT activities to be accomplished.

Additional requests for updates and enhancements will be forwarded to the contractor by the IWR Project Manager for evaluation and addressed by the contractor during the bi-monthly IPRs through prioritization recommendations. The contractor shall prepare an agenda for each IPR to facilitate discussions. Additional reviews shall be conducted upon request from the IWR Project Manager or the contractor for new or major revision activities. Other ad hoc meetings, such as with the CWBI team, may be required on an as-needed basis. During those months, the ad hoc meetings take the place of the bi-monthly IPRs. For situational awareness, the contractor shall also attend Quarterly CWBI Sharing Sessions that are 1-hour in duration

4.4.5 Task 5. Documentation: The contractor shall update, create, revise and/or maintain:

Project Management Tool and Dashboard report data loading and format parameters and process.

EMT System Data Management Manual EMT System Management Manual Dashboard User Guide Dashboard Technical documentation EMT for documentation for CWBI in DI2E (or current application used by CWBI) EMT ticketing information for CWBI in Jira Online help documents and pages

4.4.6 Optional Task 1. Enhance CWBI Data Integration: Update CWBI data integration to include linking directly to CWBI data and reporting where allowed. This task may require additional data views in the database and updating of the monthly data update processes and, perhaps, underlying tables. This task includes designs illustrating any changes to data usage and how database table, view and query structure

4.4.7 Optional Task 2. Refine Functionality for second Engineer Reporting Organization Code (EROC)’s use of

EROC (HQUSACE Planning and Policy Division). The contractor shall assist with adding parameters and reviewing current parameters for the additional EROC, ensuring data and reporting provide expected outputs. The contractor shall assist with processing monthly data updates and associated reports. The

4.4.8 Optional Task 3. Mandatory USACE Software Updates: The…