The Wipro team started by studying and understanding the existing Siebel CRM system. They then identified and extracted data from that was required for reporting and analysis using the Cognos Decision Stream ETL tool. ·

We designed and implemented a data mart for customer information. Our solution included the generation of a range of analyses and reports using Cognos products like Impromptu and PowerPlay. These reports could be published on the web using Cognos upfront tools.

The following technologies were used

	Source system: Siebel, Filenet, Genesis
	Hardware: AIX, App server on Windows/NT, PC with Web browser
	Data Mart,Staging Database: Oracle 8.1.6 · Data ETL Cognos Decision Stream
	OLAP Services: Cognos IWR, PowerPlay, Upfront

The solution it allows the client to evaluate the performance of the CRN application through daily reports on

	Customer profitability
	Dealer performance
	Sales team performance

Dashboard reporting provides a global picture of revenue for the day and month · The project was executed using the fixed price model with Wipro carrying the project risk. Our onsite-offshore model and our Insta Intelligence framework ensured·that we could complete the project on time and within budget.