Driving Efficiency and Insight with an Integrated Global Audit Platform

The customer is a leading global organisation. They sought to develop a unified data analytics platform to efficiently source, cleanse, transform, and analyse data across distributed teams, requiring a robust solution to support complex processes and decision-making at scale.

Challenge

The firm faced several challenges in their audit operation:

• Data Complexity: Handling large volumes of financial data from various sources, including SAP and Oracle systems.
• Global Scale: Managing processes across multiple countries and teams.
• Data Processing: Extracting, transforming, and analysing General Ledger and Sub-Ledger data efficiently.
• Visualisation: Creating meaningful insights from processed data.
• Scalability: Supporting increased adoption and upcoming products/releases.

Solution

Orion successfully implemented a comprehensive Global Audit Workbench Platform, which consists of:

1. Workbench Application:
   • Configuration-driven system
   • Seamless user onboarding with Azure PaaS authorisation
   • Batch job scheduling and user-initiated GL transformation
   • Activity log monitoring and subway status monitoring
   • Embedded Power BI capabilities for report editing and bookmark saving
2. ETL Data Engine (Rules Engine):
   • Utilises Informatica/ADF pipelines and other connectors for data extraction
   • Employs Databricks Compute for ingestion and transformation
   • Features a common rules framework with configurable data dictionary metadata, cleansing, data validations, error logging, and access management
   • Uses ADF and PySpark code for connectors to client ERP systems
3. PowerBI Visualisation:
   • Embedded PowerBI with sharing, collaboration, and edit capabilities for custom reporting

The solution leverages a state-of-the-art platform developed using Azure/Databricks tech stack.

Impact

The implementation of the Global Audit Workbench Platform provided numerous benefits:

• Efficient Data Processing: Processed over 80+ TB of data in two years.
• Comprehensive Analytics: Supports 30+ analytics with BYOA capability.
• Flexible Data Pipelines: Generic pipeline for custom GLA and ERP pipeline for GLA and Subledger analytics.
• Advanced Visualisation: Offers analytical views like Visual Ledger and Journal Entry Analysis.
• Global Collaboration: Enables federated innovation with global and member firms.
• End-to-End Support: Provides development support from inception to production.
• Transparent Governance: Ensures program transparency in execution.
• Scalability: Ready to support future products and increased adoption.

By implementing this solution, the firm has significantly enhanced its capabilities, improved data processing efficiency, and enabled better decision-making through advanced analytics and visualisation tools