Federal Drug Administration Budget Formulation, Execution & Reporting



Federal Drug Administration Budget Formulation, Execution & Reporting

Overview of the Engagement

The FDA’s Office of Financial Management (OFM) required support in building IT-driven capabilities for improved budget formulation and budget execution.

Description of the Scope of Work Performed

Sonora & Associates provided custom acquisition application and integration services for the optimization of tools to improve forecasting and reporting within FDA’s acquisition/grant process. We assisted with the pricing needs, expense planning, modernization roadmap, a break-even analysis for calculating Return on Investment (RoI) and driving their purchase decisions. We provided support in complex analyses, including cost‐performance modeling and forecasting tools. Sonora leveraged the Oracle Hyperion to build financial management capabilities that help FDA with an enhanced availability of information to support improved decision making, accountability, and transparency.

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 helped FDA maintain a balanced IT Investment portfolio that ensured for any given funding investment, the best return to the agency’s mission and functions were achieved. As a part of CPIC planning, we helped FDA in making investment decisions based on the fiscal analysis, and RoI calculation We provided support for preparing the monthly OMB IT Dashboard reporting and internal quarterly Control Reviews.

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, and 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 monitor triggers at multiple funding sources.