IT Services

Home >> IT Services >> Business Intelligence and Data Warehousing >> Case Studies

Financial Data Warehouse (FDW) for a Fortune 50 Mortgage Finance Company More

Business Problem
  •   Create a data warehouse to support timely financial reporting
  •   A large number of data providers to FDW
  •   Vast number of consumers had to implement a good handshake mechanism between interfaces
  •   Audit: had to store each and every change made to the data in FDW, had to create a     suitable/efficient model and build robust ETL code
  •   Create complex reports to help the client, validate data

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 allowed the client to see point-in-time picture of the warehouse at anytime
  •   Source to target data comparison reports and aggregate reports on the database load helped the     business team tremendously in data validations

Benefit to the Client
  •   Successful implementation of FDW has enabled the streamlining of the data flow between systems     that come together to generate company financial statements on time



Process Automation and Enhanced Controls for a Fortune 50 Finance Company More

Business Problem
  •   The client needed to implement enterprise wide, centralized and integrated business intelligence     solution that is easy to use and accessible in timely manner to cross-functional and cross-     organizational users
  •   Provide single source of management information across the enterprise
  •   Different data sources for different divisions, different business rules and different business terms
  •   Parallel ERP implementation posed major challenges as source systems were unknown and     unstable

Solution
  •   Automated reports by customizing ERP tools
  •   Created a Data Quality Framework
  •   Created the Finance Data Mart
  •   Provided cross-divisional analysis using conformed dimensions, thus giving enterprise-wide picture     to decision makers
  •   Providing dashboards for higher level management for timely information
  •   Providing ad-hoc reporting and ad-hoc analysis as well as static reports
  •   Providing web-enabled and user-friendly access to reports

Benefit to the Client
  •   Improved reporting efficiency by 60%
  •   Enhanced Traceability and Audit ability of financial data
  •   Reliability and Stability of underlying systems



Data Quality Framework for a Fortune 50 Financial Bank More

Business Problem
  •   Provide single source of management information across the enterprise
  •   Different data sources for different divisions, different business rules and different business terms

Solution
  •   Created a Data Quality Framework
  •   Provided cross-divisional analysis using conformed dimensions, thus giving enterprise-wide picture     to decision makers

Benefit to the Client
  •   Created a single version of the truth for Customer data
  •   Reliability and Stability of underlying systems



Dual Shore Delivery for a leading Internet Technology Company More

Business Problem
  •   Need to contain costs in BI/DW projects
  •   Selecting a quality offshore vendor
  •   Design & Development of ETL Architecture for the Data warehouse

Solution
  •   Designing & Implementation of loads (development of mappings/workflows) for Different Classes
  •   Using tool’s abilities and making lot of mappings as reusable to source data for different locations
  •   Generation of Reports using Metadata for all the jobs
  •   Customized delivery model for aggressive schedules
  •   Delivered Quality Assurance Framework

Benefit to the Client
  •   Saved over 60% of the project costs
  •   Seamlessly integrated with client’s operations to contain costs



Data Lineage / Validation for Data Quality initiatives for Fortune 50 Finance Companies   More

Business Problem
  •   Need transparency for reconciling GL with source systems
  •   Lack of Data Validation and Controls
  •   Conflicting Data Sources

Solution
  •   Created centralized audited source for CDEs
  •   Automated data validation suites to test for reasonableness and completeness
  •   Implemented Waterfall Methodologies approved by Accounting policy
  •   Implemented comprehensive data lineage by identifying trusted data sources and dependencies

Benefit to the Client:
  •   Significant time and cost savings by closing the books in 5 days which had taken multiple months
  •   Created SOX approved controls that enhanced the auditors confidence
  •   Creation of an enterprise level trusted data source which benefited all business units