The customer

The customer is a leading finance company with a global presence

The Challenge

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 Solution

The ICCG 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 ICCG - it was completed on schedule and within budget.