Data and Reports consolidation for US-based Automotive OEM Major

Business Problem: The Sales and Operations business users were unable to get an integrated view of their operations due to lack of consolidated data.

Our Solution: A Datawarehouse consolidating data across departments was proposed. The work involved the design, development and implementation of ETL  for the Datawarehouse implementation . An understanding of  the business work flow, the overall ETL – DW architecture and development of Dimensional load and Fact load jobs were key to the success.

Technology: Cognos Data Manager, Oracle 10g