Success Stories
Consider some of the following real world case study experiences of our team:
A major financial organization 'lost' 50 mm:
- Situation: Following an extensive data forensics effort it was determined the 50mm never existed. It had been previously booked and subsequently backed out. The incentive compensation system did not retain integrity with the operational system. The downstream DWH, consistent with data loads from the IC System, reported the incorrect results.
- Issue: The DWH lost major credibility through no fault of it's own. Management reactively spent hours on damage control.
- Solution: Implement load audit controls, rules and process to validate count and sums at various stages of load processing/reporting.
A large financial services back office project 'Go Live' lacked data integration visibility:
- Situation: Following an extensive back office development project the need was determined for integrity assurance of the data integration (ETL) processes and code.
- Issue: There was not enough time and resources to test all the ETL code. In addition, functionality enhancements occurred at a pace that made each prior testing phase results obsolete.
- Solution: Utilize rule driven approach with integrity audit checking developed by Business and data analysts to validate 'black box' ETL code.
An insurance company's combined risk was understated:
- Situation: It was determined that the combined product family risk exposure across all products sold at unique geographical locations was not sufficiently visible at an enterprise level.
- Issue: Lack of integrity, integration and visibility threatened the US Group's existence.
- Solution: Scope, design and implement MDM (Customer, Product, Geography, Organization) oriented architecture and custom build data integration, audit and analytical services.
A large business services company could not reconcile it's Balanced Scorecard results:
- Situation: Inability to reconcile Balanced Scorecard to financial systems caused by integration tools, lack of audit/reconciliation and process shortcomings.
- Issue: Inability to reconcile Balanced Scorecard to financial systems caused great concern among executive ranks in multiple departments.
- Solution: Analyze and determine logic breaks in ETL process. Implement hierarchy management solution (Hyperion DRM - formerly Razza) and corresponding domain/hierarchy audit for data loads.