The client had acquired 8 product brands, each had their own order processing and sales data management application. Reports were generated through different extracts for different reporting applications.
One of the largest office furniture manufacturers in the USA.
- Development of a data warehouse to create a single source of data for all reporting needs.
- A consolidated and common reporting system across all the brands
Defined meta data and process of management
Solution for managing different customer id from source systems to a common ID into the DW
Designed a data model
Defined source to target mappings
Developed ETL solution from source systems to staging DB and then loading data into DW
Setting up refresh cycles
Support
-
Single source of data for reporting solutions
-
Improved product quality and ensured timely delivery
-
Improved customer relationship
Quality Control Defects
Our client is a Multinational automobile component manufacturing company. The objective was to drive down their manufacturing defects percentage.
CASE STUDY
Price Forecasting and Cash Planning
Our client is a Fortune 500 Oil & Energy giant. The objective was to analyze historic data and build a price forecasting solution based on forecasted production.
CASE STUDY