Success Stories

Data Warehousing Solution for Large Financial Services Company

The Client

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. UML delivered a highly scalable solution.

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.

The Solution

UML consultants 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: 380 GB at the end of Year 1; annual growth rate of 18%

Implementation Process

UML 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) , business intelligence
  • Report 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: 380 GB at the end of Year 1; annual growth rate of 18%


To hear more Contact UML Today.