|
A team of 25 consultants from Wipro was involved
in this project. Since the project involved a
very high level of complexity in dealing with
different data sources the entire warehouse team
was classified into three broad categories:
- Base Operations
- Infrastructure
- Project Teams
Many data warehousing efforts were carried out in
parallel. The teams spearheaded the following five
different Data warehousing initiatives:
- Strategic Sourcing:This pooled purchasing
data from 16 operational systems
- Business Metrics: This defined and managed
quality metrics
- MSD Data Mart: This analyzed shipment data
- Quality Metrics:This analyzed data on business
performance
- Employee ODS: This provided a single source
of employee data in a standard format.
The Corporate Information Factory (CIF) was employed
to build the Data Warehouse and Data marts. We
evolved a data workbench to handle the requirements
of the architecture.
The following technologies were used:
Hardware:Sun Solaris
Data Mart and staging database Oracle 8.0.5
Data ETL: Informatica, SQL* Loader, PL/SQL programs
OLAP Analysis: Oracle Express, Oracle Discoverer,
Visual Basic, Excel
Our unique onsite-offshore Model enabled the company
to execute the project on-time, on budget. Development
time was reduced through the use of standards,
templates and reusable
procedures.
|
