Budget Formulation, Execution & Reporting for FDA



Federal Drug Administration Budget Formulation, Execution & Reporting

Overview of the Engagement

The FDA’s Office of Financial Management (OFM) required support in the development and implementation of their new Resource Planning Application.

Description of the Scope of Work Performed.

Sonora & Associates provided custom acquisition application and integration services for optimization of tools to improve forecasting and reporting within FDA’s acquisition/grant process. Sonora worked with existing business processes and models to create two web-based applications (one custom application and a COTS application). To accomplish this, Sonora assessed and automated current and evolving budget formulation, execution processes, and calculations (e.g., Excel spreadsheets and Budget Data Requests). Integration of budgetary data analysis and analysis of historical data from UFMS, payroll data, and other performance measure sources. Sonora provided support in complex analyses, including cost‐performance modeling and forecasting tools.

Technologies Utilized:

Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator (ODI), Oracle Financial Data Quality Management (FDMEE), Hyperion Planning, Oracle Financial Reports, SQL, Oracle/Hyperion Essbase., JSP, HTML/JavaScript, J Query, JSON, HTML5

Demonstrated Experience

  • End-to-end experience with requirements, analysis, design, implementation of a budgeting/forecasting/reporting application with integration to general ledger.

Results Achieved

FDA is now able to budget/forecast obligations out of multiple funding sources (including various user fee CANs), also project payroll, calculating and reporting FTEs, planning obligations, and tracking and monitoring triggers at multiple funding sources.