The stock exchange needed a data warehouse to analyze trading and payment patterns of members of the exchange, based on well defined risk classes for risk containment and maintaining market integrity. With the diversity in data storage technologies, data semantics, and database management techniques across multiple applications, managing and integrating information was a major issue.

Hence, there was a need for reports that required historical information to be retrieved and analyzed required huge amount of system resources and need less to say, the associated time.

NSEIL's requirements demanded an integrated, unified data pool that was truly subject-oriented, time-variant and nonvolatile. The Wipro team undertook the end-to-end implementation of this data warehouse from requirement analyses to final integration and user training. This included technical architecture design, tool selection, data extraction, metadata management, integration and training . The project was divided into two phases. The first focused on the risk containment application for the securities corporation, while the second phase involved the implementation of the upgrade path to the realization of the enterprise-wide data warehouse solution.

This is the largest data warehousing project that has been implemented in India. With an initial size of more than 500 Gigabytes of data, it offers the following features:

• A scalable Information Architecture that will allow the information base to be extended and enhanced over time.
• Detailed analysis of member patterns, including trading, delivery and funds payment.
• Fraud detection and sequence of event analysis.
• Ease of reporting on voluminous historical data
• Provision for ad hoc queries and reporting facilities to enhance the efficiency of knowledge workers
• Data mining to identified the co-relation between apparently independent entities.

The successful implementation of this large, complex project has earned us high satisfaction ratings from our client.