Enterprise Data Warehouse (EDW) Report Writing Support Project

Background
The U.S. Army Corps of Engineers (USACE) Resource Management requires an Expert SQL programmer as the Baltimore District has no in-house capability/expertise to modify existing reports and creating additional reports as requested through the Enterprise Data Warehouse (EDW) helpdesk tickets and/or the Corporate Business Report (CBR) Program Manager. Baltimore District facilitated the shutdown of CBR and transitioned approximately 500 existing reports into the EDW system. All queries/reports were recreated in EDW using official USACE established procedures, and utilized Crystal Reports, Aginity, SQL, and PL/SQL.

Work Details
The contractor is required to modify all current reports per USACE needs and convert alternate formats of existing reports.
The programmer will work with the regional Project Development Team (PDT) through the CBR Program Manager to create a dashboard reporting a variety of budget information. The programmer will create and modify reports for USACE’s mandated reporting system, EDW, using Crystal Reports and Aginity Workbench for Netezza. The reports will primarily use tables copied from the Corps of Engineers Financial Management System (CEFMS). The programmer will create Dynamic Lists of Values (DLOVs) in Crystal Reports and join multiple tables together when creating reports. The reports will include parent-child relationship queries, sub-queries, and recursive relationships.

Period of Performance
The awarded firm fixed-price contract shall consist of a base year and four option years.

Place of Performance
Work is to be accomplished on-site at the Baltimore District Offices located at 2 Hopkins Plaza, Baltimore, MD.