The company had started a business intelligence initiative to cater to the management information requirements of their global Commercial Foreign Exchange (CFX) business. They wanted a system that would help them evaluate critical business performance parameters. The management information data mart project was planned for the following key applications

	Customer profitability analysis
	Monitoring Key Performance Indicators(KPIs) using dashboards

The Wipro team was responsible for the analysis, design and implementation of the business intelligence solution. We prepared a business case for the data mart and then developed and deployed it. Our solution offered dashboard reporting to measure the success of business performance against key CFX strategies, using Key Performance Indicators (KPIs). Provisions were made for ad hoc querying and reporting. The system supported multi-currency conversions.

The following technologies were used

	Source system: Siebel
	Hardware: Sun Solaris
	Data mart and staging database: Oracle 8 data ETL PL/SQL programs
	OLAP analysis: COGNOS Powerplay, COGNOS Impromptu, COGNOS visualizer, Impromptu Web Reports (IWR)

The solution allowed the client to constantly monitor its CFX business and fully exploit the strategic information gathered from its CRM system. Our application supported a web interface that made access to the information simple. This was a fixed price project where the risk was carried by Wipro - it was completed on schedule and within budget.