In order to gain greater strategic advantage, one of our clients engaged Wipro to implement a data-warehousing model known as Value Chain Analysis (VCA). The client is a leading Water supply and Wastewater services Company in the UK. They have over 12 million customers and provide services such as underground pipeline and networks, integrated waste management solutions and maintenance & facilities management.

Wipro's proven track record in the data warehousing area, and its position as a valued development pool partner, clinched the deal. The Wipro team participated in the requirements capturing, architecture design, sizing and estimates, analysis and design, development and unit testing, integration and system testing, user acceptance testing support and initial post implementation support before handing over to Application Support team.

The VCA data mart will interface with multiple source systems like Peoplesoft, Capex Management System, CIS, and TWUL property information. The data sources include Oracle databases; MS Excel spread sheets, Peoplesoft etc. The data from the different sources will be integrated into a common data store before being populated into the VCA data mart. End user analysis will be through ROLAP reporting.