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 assisted in building IBPAS Architecture Vision, taking under consideration the stakeholders’ concerns. Leveraging the Oracle EPM  as a foundation upon which Sonora built the financial systems architecture, design of budget formulation and payroll systems, integration architecture and design of interfaces for connecting to the external applications.

Sonora collaborated with FDA to create a system modernization plan, aimed to enhancement of IBAPS and integrate advanced acquisition planning process and a comprehensive budget formulation solution. We collaborated with FDA to develop and host end-to-end budget planning tools that is based on the IBAPS concept for other DHHS Operating Divisions.

Sonora applied Agile and human-centered design approach for developing recommendations, thereby improving the analytical models and finding ways to figure out whether our perception and hypotheses of DHS’ needs are accurate and valid. We provided tailored modeling applications to enable “what-if?” drills predicated on multiple scenarios and to ensure the instantiation of the RPA Requirements Traceability Matrix (RTM).

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 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, and implementation of a budgeting/forecasting/reporting application with integration to a 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, calculate and reporting FTEs, planning obligations, and tracking and monitoring triggers at multiple funding sources