Financial Close Consolidation & Reporting for the Department of Justice



Department of Justice Financial Management Transformation

Overview of the Engagement

The DOJ, Criminal Division required support to review, assess and the document the financial reporting and consolidation processes; assist with improving financial management systems, financial reporting and analysis, strategic financial planning, and redesign the processes to improve efficiency and quality of information.

Description of the Scope of Work Performed

Sonora provided Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Hyperion Financial Management (HFM) Subject Matter Experts (SMEs) to customize web-based financial reporting software solutions to include: design, development, and deployment of enhancements and modernizations. Data were extracted from an Oracle Enterprise Management Architect (EPMA) application to be loaded into OBIEE while extracting billing details from a different source. Sonora supported the International Training Financial Management (ITFM) application to accommodate the reporting requirements that have been created in Oracle Business Intelligence to include problem-solving and any needed enhancements were identified.


Technologies Utilized:

Oracle Business Intelligence Enterprise Edition (OBIEE), APEX, Hyperion Financial Management (HFM), Oracle 12


  • Performing Business Process/Rules modeling
  • Financial reporting data analysis
  • Requirements gathering
  • Process improvements and system design

Results Achieved

The redesign of DOJ’s financial reporting/financial management systems resulted in a streamlined and consistent data loading process.