Wipro Technologies - IT Services, Product Engineering Solutions, Technology Infrastructure Services, Business Process Outsourcing, Consulting Services

Case Studies

Home

Case studies

Business Intelligence and Data Warehousing

Delivering an integrated capacity monitoring system for enhanced decision making

The customer

Leading provider of telephone, digital TV, broadband internet access services in the UK and Northern Ireland.

The challenge

As a result of a major acquisition, the customer was having two (02) systems that provided roughly similar functionality but used different network elements, protocols and information systems. The business users needed someone to bridge the information gap between the systems and provide similar information for decision-making. The objective was to build an integrated capacity monitoring system, which would allow them to proactively monitor the network traffic trends and plan the re-segmentation on both the platforms. Another key requirement from IT perspective was to minimize the maintenance overheads and leverage on existing tools and technologies to minimize the development cycle.

The solution

Wipro is currently a strategic partner providing system integration services to the customer. Team Wipro started by quickly understanding the key features of the new platform for which capacity monitoring capabilities were to be implemented and also reviewed the one already in place. For integrating the data from the two platforms, the strategy adopted was - gap analysis, which highlighted the similarities and the differences in the two systems.
Wipro has provided a flexible design that can accommodate the differences between the systems and implemented the same within a short period of 11 weeks only. The design was done with a view that it didn't involve extensive changes to the existing system.
This quick-speed system delivery enabled the customer to access the similar information from both the platforms and has led to significantly enhanced and improved decision making for the customer.

The technology

	Hardware: Sun E4800, Sun E450, Compaq Servers
	Operating System: Sun Solaris 8, NT 4
	RDBMS: Oracle 9I Enterprise Edition
	Data ETL: Perl /PL-SQL /SQL Loader/ Shell Scripts
	Data Modeling Tool: Visio 2000
	Reporting Tool: Cognos BI Suite