|
Wipro with its expertise in Data Warehouse solutions
participated in helping the client with the problems
of Data Quality and Performance issues. Subsequently
we partnered to provide the design, development
and implementation of three other data marts;
Capital Costing data mart, Time Administration
Data Mart and Key Performance Indicators data
mart.
The following technologies were used:
- Hardware: Sun Solaris
- Data Mart and Staging Database: Oracle 8.0.6
1
- Data ETL: Platinum tools, PL/SQL, SQL bulk
loader, Informatica Power Center 1.7.2
- OLAP Services: Business Objects 4.1, VB application
on WinNT webserver, Coldfusion, Macromedia,
Front end application using Java
These data marts help customer bench mark operational
performance against the industry standard, pinpoint
the bottlenecks, effectively track capital investments
to ensure better ROI, analyse the electricity
usage by customer type to identify usage patterns,
cross-sell opportunities, reduce payment defaults
and optimize IT resources usage for higher business
impact.
Wipro currently maintains and runs the customer
information data mart using its ODC infrastructure.
The Scope of Support and Maintenance activities
includes, Business Objects Administration, Informatica
Administration, Functional Enhancements, and Application
Support & Maintenance Activities like:
- Monitoring of the ETL jobs from offshore for
CSS Data Mart.
- Quick Fixes, data quality issues fixing from
Offshore.
- Implement slowly changing dimensions as required
by business.
- Report on the status of load processes, job
failures, rejected data and its' root cause
analysis, etc.
|
