- Required integration with an outdated mainframe budget formulation and execution system
- Clients' data and reporting requirements were constantly changing due to changes in OSD guidelines
- Client's lack of experience with their data and submission procedures due to high turnover made it difficult to design the system consistently and accurately
|
- Implemented an Excel pivot table reporting tool to serve as an intermediary between the budget system and the EAS database and to provide the client with
robust reporting capabilities unavailable in their budget system
- Designed a flexible database and object model to allow for changes to be implemented quickly and efficiently
- Used the most recent OSD guidelines and leveraged the knowledge gained from the Army implementation of EAS to design the system interface and generated
exhibits correctly
|
- Air Force analysts have better visibility into budget data changes to more accurately formulate their justifications
- Budget data changes are made instantaneously to all affected exhibits without requiring any action from analysts, allowing them to remain focused on data
analysis and justification
- Last minute exhibit guideline changes are implemented quickly and accurately to meet submission deadlines
- Provides consistency to offset the knowledge lost from high analyst turnover, lessening the negative impact on the Air Force's ability to submit accurate J
books on time
|
