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.
Technologies