- Development of data warehouse to create a single source of data for all reporting need
- A consolidated and common reporting system across all the brands
One of the largest office furniture manufacturers in the USA
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. The client’s requirements included: 1. Development of data warehouse to create a single source of data for all reporting needs, 2. A consolidated and common reporting system across all the brands
Defined metadata and process of management
Solution for managing different customer ids 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 & ensured timely delivery
-
Improved customer relationship management
Digital Technology Enablement & Integration
The client is a leading provider of web hosting services. The objective was to replace multiple legacy systems and provide a single window to clients.
CASE STUDY
Bidder Recommendation System
Our client is an E-Commerce company offering a wide range of eSelling, eSourcing, eFinance services. The objective was to provide a price estimation solution for the bidder recommendation system.
CASE STUDY