Accounting Data Warehouse for a Fortune 50 Mortgage Financial Services Organization

Challenge

  • Creating a data warehouse to support timely financial reporting
  • Huge traffic of data providers to ADW
  • Compatibility between interfaces to align vast number of consumers
  • Storing each and every change made to the data in ADW by audit team
  • Creating user friendly reports for validating data

CompuGain Solution

  • Implemented Ab Initio graphs to interact with Enterprise Production Framework (EPF)
  • Implemented Auto-recon module to reconcile source data files with source control files
  • Implemented Version Framework module to store the entire history of changes made to the database. This will allow the client to see point-in-time picture of the warehouse
  • Create a suitable/efficient model and build robust ETL code to automate the changes made to the data in ADW
  • Technology – Business Objects XI R2, Ab Initio, Oracle, Microsoft

Results

  • Successful implementation of ADW has enabled the streamlining of the data flow between systems that come together to generate company financial statements on time
  • Source to target data comparison reports and aggregate reports on the database load helped the business team tremendously in data validations
  • Timely Financial Reporting
  • Faster streaming of data providers to ADW
  • Allowed the client to see point-in-time picture of the warehouse