Process Automation and Enhance Controls for a Fortune 50 Financial Services Organization

Challenge

  • Implement enterprise wide, centralized and integrated business intelligence solution
  • Provide single source of management information across the enterprise
  • Segregating data sources, business rules and business terms for different divisions
  • Parallel ERP implementation posed major challenges as source systems were unknown and unstable

CompuGain Solution

  • Implement enterprise wide, centralized and integrated business intelligence solution which will be easy to use and accessible in timely manner to cross-functional and cross-organizational users
  • Automate reports by customizing ERP tools
  • Create a Data Quality Framework
  • Create the Finance Data Mart
  • Provide cross-divisional analysis using conformed dimensions
  • Provide ad-hoc reporting, ad-hoc analysis as well as static reports
  • Microsoft, BusinessObjects XI R2, Datastage, Oracle IBM DB2

Results

  • Improved reporting efficiency by 60%
  • Enhanced Traceability and Audit ability of financial data
  • Reliability and Stability of underlying systems
  • Enterprise-wide picture to decision makers
  • Dashboards for higher level management for timely information
  • Web-enabled and user-friendly access to reports