Data Warehousing Solution for One of Europe's Largest Financial Services Groups
The client sought a business intelligence solution to consolidate the mortgage administration processes, provide better sales cycle management, mortgage product performance analysis, financial forecasting based on sales demands, fraud detection and general mortgage operational reporting. Infosys delivered a highly scalable solution.
The Client
The client is one of Europe's largest financial services groups in corporate and commercial banking, retail banking, credit cards and general insurance. The company sells mortgages to corporate and retail customers through various channels. These mortgage systems run on different technology platforms and follow different business processes.
Business Need
- Consolidate the mortgage administration processes for all brands and BI for different brands
-
Satisfy better sales cycle management, mortgage product performance analysis, financial forecasting based on sales demands, fraud detection and general mortgage operational reporting.
The Challenges
The biggest challenge was to provide scalable architecture for consolidating huge amounts of data.
Our Solution
Infosys designed and implemented a data warehouse solution to extract information from the Mortgage Sales Application and administration systems of different brands and house them in a single data warehouse database. This resulted in a highly scalable solution that met the following requirements:
Implementation Process
Infosys followed an iterative phased approach to implement the solution that included the following phases:
Benefits
Highly scalable solution to meet the following requirements:
- Transaction volume expected: 73 Million per year; annual growth rate of 110%
- Size expected: 180 GB at the end of Year 1; annual growth rate of 45%