Meilleurtaux manages its mortgage loan business and risk with QlikView

We could, in less than a month, regain 20 to 40% of client business on the 10% of client files that had been previously turned down for a loan.

Nebojsa Stojanovic, IT Manager, Meilleurtaux

Bedrijfsprofiel

Regio:

Europe, France

  • Omzet: N/A
  • Bedrijfstak: Retail Banken
  • Functie: Finance, Operations, Sales

Background

  • Leading mortgage loan financing broker and intermediary in France with more than 110 banking partners
  • Headquartered in Paris, France
  • Achieved €55 million in revenue with 350 employees

Challenges

  • Manage rapid growth through detailed business activity analysis
  • Gain greater insight into client profiles, loan files and scoring to identify the right business to undertake
  • Consolidate data from multiple data sources to provide a holistic view of operations

Solution

  • Deployed QlikView to ~10 management team leaders across 3 functions in France:
  • Sales Analysis: Analyze business sales activity across multiple lines of business such as housing, health, auto, life insurance and mortgage
  • Operational Analysis: Monitor the processing status of its client loan files and associated scoring
  • Financial Analysis: Measure key financial metrics to management team on corporate performance across business segments
  • Rapid implementation in less than 1 week for mortgage loan scoring application with just 2 resources from partner, Ysance
  • Leveraged QlikView Server to consolidate data from 2 Oracle databases and Excel handling 2 million records in data volume

Benefits

  • Gained visibility into all sales activity across lines of business
  • Identified 10% of loan business that should be underwritten due to improved scoring that was initially turned away
  • Regained 20-40% of client business that was turned away
  • Rapid payback and ROI in less than 1 month through ease of use, fast implementation, and split second performance
  • Freed up team of 10 IT employees allowing them to focus on more strategic and profitable tasks than reporting

Related Resources

Andere Klantverhalen


Zoek