X

Information Management Services

Case Studies

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:

  • 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%

Implementation Process
Infosys followed an iterative phased approach to implement the solution that included the following phases:

  • Business requirements analysis
  • Data warehouse dimensional modeling
  • Architecture design
  • ETL (Extract, Transform and Load) and business intelligence

    reporting development and implementation

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%

Share the page

  • Tweet
  • Share on Facebook
  • Share on LinkedIn
  • Google+