Remaining Items – Technical Assistance and Coordination Outcomes Database

The US Army Corps of Engineers (USACE) Humphreys Engineer Center Support Activity (HECSA) is seeking information from industry to determine the capabilities of industry and determine interested sources for a new requirement. This is a Sources Sought Notice for Market Research purposes only. This is not a request for proposals. The Government will not reimburse for any costs incurred to submit a response to this Sources Sought Notice.

The Government reserves the right to reject in whole, or in part, any private sector input as a result of this market survey. The Government is not obligated to inform respondents of the results of this survey. It is anticipated that a contract will be award using FAR Part 13 - Simplified Acquisition Procedures (and may use FAR Part 12 – Acquisition of Commercial Items).

Interested sources should respond to the attached questionnaire and submit a Statement of Qualifications to help facilitate the Government's market research. The Government will analyze all of the responses and determine if this requirement is suitable to do a total or partial set-aside for small businesses. If the pool of small businesses is insufficient, the Government may elect to solicit this requirement using full and open competitive procedures. The Government does not intend to rank submissions.

The Institute for Water Resources (IWR) is a United States Army Corps of Engineers (USACE) Field Operating Activity (FOA) located within the Washington, DC National Capital Region (NCR), in Alexandria, VA and with satellite centers in New Orleans, LA; Davis, CA; Lakewood, CO; and Pittsburgh, PA.

IWR was created in 1969 to analyze and anticipate changing water resources management conditions, and to develop planning methods and analytical tools to address economic, social, institutional, and environmental needs in water resources planning and policy.

IWR is currently responsible for several water resources activities or programs, including evaluation of Civil Works (CW) strategic plans, CW policies and programs, investment and financial analysis, performance measurements and evaluations, infrastructure analysis, climate change and other water related activities. IWR provides technical assistance to USACE divisions, districts, laboratories, as well as other Federal agencies, international organizations, financial institutions, and partner countries.

Assistance encompasses a broad range of topic areas related to levee and dam safety, risk assessment, dredging requirements, port/waterway transport, aquatic ecosystem restoration, environmental stewardship, flood and drought risk management, emergency preparedness, watershed planning, regulatory, multipurpose water resources including hydroelectric power, water supply and reallocation, recreation, and other water and related land resources issues.

The Remaining Items (RI) Technical Assistance and Coordination Outcomes (TACO) database, RI-TACOd, was developed in 2022 and directly supports program managers and users of the National Flood Risk Management Program (NFRMP), Floodplain Management Services (FPMS), and Planning Assistance to States (PAS) programs. The relational database application resides within the Amazon Web Services (AWS) GOV cloud, which is managed by USACE’s Civil Works Business Intelligence (CWBI) program.

RI-TACOd uses AWS cloud-native tools and open-source technical solutions. The tool serves as the primary mechanism to gather and record project/study proposals for the NFRMP, FPMS, and PAS programs. This includes collecting proposals, ranking/prioritizing for eligibility, selecting for funding, tracking and reporting progress, and mission closeout.

The AWS tools and scripts provide users with the means to submit their information, and program managers with the ability to manage and evaluate the process throughout its lifecycle. With RI-TACOd now deployed, USACE has identified operation and maintenance (O&M) tasks that are necessary for the database to continue to thrive, as well as new development tasks to help advance the tool to its next phase of existence.

It is anticipated that a firm fixed price task order will be awarded to Contractor to provide support to the Government for modernization of RI-TACOd. Activities within major task areas will be evaluated and prioritized by the CWBI Program Management Office (PMO) and NFRMP/FPMS/PAS program managers (referenced as the “USACE” Project Delivery Team [PDT] within this PWS) in consultation with the Contractor. Activities will reflect program requirements, user issues, and available resource levels.

Several major task areas are to be managed through this delivery order. The task areas are described in Section 4 of the PWS. A description of general tasks includes the following:

General database development, assistance, and maintenance for DynamoDB and/or PostgreSQL databases. General development, assistance, and maintenance with web-based data entry interfaces and report generation. The current interface uses ReactJS. General assistance in integrating with other USACE AIS, including the Enterprise Data Warehouse (EDW), Corps of Engineers Financial Management System (CEFMS), and Project Management Information System (PROMIS).

General assistance in interfacing with customers and ensuring the Data Entry and Reporting system remains operational. General assistance with development of data services to ensure program data can be used within existing USACE tools (ex. Microsoft PowerBI). General assistance to program managers in multiple business areas; this may include compiling reports for the managers, attending meetings, and presenting at meetings.

Delivering training to users, database administrators, program managers, and others on how to enter data and pull reports once the new tool is operational. Maintaining and enhancing system documentation. Maintaining cybersecurity compliance, risk management framework documentation, and remediating vulnerabilities. See the Questionnaire and PWS for additional information. Please direct all correspondence to Mr. David A. Kaplan, Contracting Officer at email: David.A.Kaplan@usace.army.mil.