United States Air Force - MPES
The A1M organization is the manpower office for the US Air Force. It oversees the Future Years Defense Plan (FYDP), the Air Force manpower budget voted on by congress. A1M tracks Air Force troop deployments, assesses current air and ground strength, builds requests for additional manpower resources, and performs manpower reductions. FYDP is the official system of record regarding all US Air Force manpower actions, for the Air Force leadership, the Joint Chiefs of Staff, the President, and Congress.
The legacy FYDP system used by A1M was a web-based application purchased from the US Army. The differences in methods of operation and accounting between the two service branches required A1M to massage and manipulate their data to fit the Army manpower system. As their data and reporting needs became more nuanced and individualized, the gaps between the system and A1M's business processes became more pronounced. This resulted in a cumbersome workflow and the need for more advanced reporting. A1M was inhibited their ability to operate efficiently and respond to Air Force leadership and Congress. Consequently, A1M was expending a large number of man-hours reworking, tracking, and double-checking data to compile their manpower reports.
Segue Technologies worked directly with the FYDP users to completely redesign their tracking system from the ground up. We began by documenting their existing data and workflow system. Then we designed a new and efficient SQL Server database for their specific data needs, featuring a normalized data structure, and a reliable archiving system using AJAX interface library. To accompany the database, we built a new ColdFusion Web application that is tailored to their business processes and streamlines the required steps and tasks of the legacy system. The Segue designed FYDP system allows A1M to operate more efficiently and with greater data security. Segue also provides ongoing support to A1M, making modifications, as required, to accommodate new evolutions in their processes.