About the Client

The Acquisition Integration Directorate under the Secretary of the Air Force (SAF/AQX) is responsible for the planning, management and analysis of the Air Force research and development, and acquisition investment budget. Each year, SAF/AQX gathers information from sources around the globe, then prepares and submits budget justification documents “ detailed descriptions of nearly $40 billion in Air Force resources “ to the Office of the Secretary of Defense (OSD) and Congress. The directorate then manages the execution of the appropriated budgets to ensure adherence to OSD guidelines for the timely obligation and expenditure of funds and compliance with Federal Appropriations Law.

The Challenge

Central to the client mission are several critical information systems used to track and manage funds, provide budget development and submission functionality, document congressional action, track the movement and direction of funds, and serve as the "system of record" for budget and cost reporting. SAF/AQXR required a comprehensive data analysis capability to efficiently track, understand, and manage its portfolio of Air Force appropriations.

The Solution

Segue Technologies Inc.® developed an analysis toolkit for SAF/AQXR, which facilitates the integration of data from numerous logistics, budget, cost, and accounting systems, into a single On-Line Analytical Processing (OLAP) engine. This information forms the basis from which budget/cost documentation packages are assembled, reports are created, and in-depth financial analysis is conducted. Through this tool, SAF/AQXR logisticians and financial managers are able to gain valuable insight and perform predictive modeling of USAF programs.