Warranty Data Warehouse

Challenge

Our client, a large warranty underwriter, had data for 9 years for all warranty claims and service records for the assets under its warranty. This information was critical for business profitability.

However, this large data was available mostly on legacy AS400/DB2 server and Sybase RDBMS on Windows. The data models were not consistent across different warranty products and platforms. The data was redundant and data structures were not optimally normalized. The database design was suitable for OLTP and not for analysis and hence any data analysis needed 24+ hours for execution.

In short, valuable “data” could not be converted into “information”.

Our Solution

workMETHODS professionals analyzed the goals and objectives and laid out a plan to implement phased Oracle BI solution. We analyzed existing data as well as gathered requirements.

workMETHODS business analysts worked with client IT and business teams to design and finalize an enterprise schema. Based on this blueprint, workMETHODS devised a star-schema for the data warehouse. Moreover, we developed an ETL process to continuously feed data from OLTP systems to OLAP.

We also developed 25+ multi-dimensional reports and provided ad-hoc reporting capabilities. This solution allowed users to slice-and-dice information for their business needs.

For legacy data, workMETHODS used data-cleansing tool [Carleton] and web services while migrating data from AS400 and Sybase OLTP systems.