Westcon-Comstor is the leading global distributor of business technology prodcuts. Westcon working as reseller for the manufacturers like Mitel, Audiocodes, CISCO, Microsoft, Avaya, Juniper and Check Point etc. Westcon use to send POS files to the vendors on daily, weekly and monthly basis as per manufacturer requirement. Westcon will generate the revenue on the sales which they performed on manufacturer products.

CBRE has many separate databases systems across the business. Bringing this separate information together into one data access point allows the company to leverage all CBRE information for countless objectives. The Enterprise Data Platform (EDP) consolidates this data from multiple sources to provide a unified and trusted view of this data set. EDP processes this source data through a transformation process where it is matched, merged and verified.

Ciscoisone of the Global Market Leaders in manufacturing of network equipment. Cisco maintains its own Data Warehouse. All the transactions performed by customers are recorded in oracle systems whichisOLTP data. Using Informatica data from Oracleismigrated to Teradata using Teradata SQL queries. Dataismainly classified under 3 streams: Bookings, Finance and Sales. I majorly dealt with Finance and Bookings streams which are core part of CISCO.

This project mainly aims to develop a best- in-class Enterprise Data Warehouse (EDW) solution which is robust and scalable to address the current and future information needs of GB. The project involves building a new Enterprise Data Warehouse (EDW) and Data Marts, which would be loaded addressing the existing EDW and source data Transformation concerns. Building a Common Integration Framework to integrate data into the new normalized EDW and the dimensional data marts. Transform the extracted data by cleansing, validating, de-duplicating the data against the identified business cleansing rules and derive the Master Data into MDM database. Load the cleansed data into the EDW and downstream the data into the respective data marts.