Relating Expenses to Project Performance

Challenge

The Navy was relying on a manually intensive spreadsheet to manage its $3B Flying Hour Program. The Navy needed to combine several legacy systems into one data warehouse to support its reporting requirements and to be able to analyze its business practices.

Assistance Required

Utilize the industry standard Business Process Reengineering and Software Design and Analysis to identify complex business rules in order to combine seven data legacy source systems into one data warehouse.

Solution

CACI divided the project into three major phases

1. Immediate replacement of the legacy COBOL spreadsheet system that no longer had technical support
2. Final integration of the data from the legacy systems that gave business analysts visibility into the Flying Hour Program much more rapidly than with the previous system
3. Integrate more legacy systems, employ a commercial OLAP product for data forecasting and "What If" analysis

Results

The ACES development effort transformed a poorly executed legacy system to an Oracle client-server database resident in a wide area of networks. The system manages over $2.5B of annual appropriations. The system also conveys information to end users through a website titled ACE Reporter. In the first six months of operation managers attributed reallocation and prioritization of $43M in support operational requirements to insight provided by ACES.

The project

• Performed a migration from a legacy business system
  • Through BPR identified 75 business rules
  • Through reverse engineering of the COBOL code identified 40 additional rules
  • Following validation these rules were implemented within the modernized system
• Developed a 74-table Oracle database with 129 PL/SQL stored procedures and 133 table-based triggers using IEF KnowledgeWare
• Incorporated a web security system using FIPS 140-1 compliant browsers to provide clientele throughout the world with data access
• Identified significant savings, provided increased management control and produced more relevant data to support management decisions

For additional information contact Rick Dansey, 703-679-4286, rdansey@caci.com