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 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.
- 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 biggest challenge was to provide scalable architecture for consolidating huge amounts of data.
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:
Infosys followed an iterative phased approach to implement the solution that included the following phases:
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%