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.
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
The redesign of DOJ’s financial reporting/financial management systems resulted in a streamlined and consistent data loading process.