Download PDF
Meilleurtaux manages its mortgage loan business and risk with QlikView
Technology Category
- Analytics & Modeling - Real Time Analytics
Applicable Functions
- Sales & Marketing
- Business Operation
Use Cases
- Real-Time Location System (RTLS)
Services
- Data Science Services
- System Integration
The Challenge
Meilleurtaux, a leading mortgage loan financing broker in France, was facing challenges in managing its rapid growth and gaining insights into client profiles, loan files, and scoring to identify the right business to undertake. The company was working with more than 80 reports, created in Excel, each requiring access to 2 million records stored in an Oracle database. This overloaded the database and indicated that new investments in servers would have to be made. In addition, the creation and maintenance of these reports required the work of 10 IT department employees, who were spending a great deal of their time building up the reports and were also confronted with major issues of inconsistency. The implementation of a more adequate and scalable platform solution was becoming crucial.
About The Customer
Meilleurtaux, founded in 1999, is a mortgage financing broker based in France. The company works with more than 110 banking partners, striving to offer loans with the best terms to individuals. It acts as an intermediary and, for each contracted loan, gets a commission paid by the banking institution. Initially available exclusively online, Meilleurtaux started building a network of agencies in France about 3 years ago. It is the only company in its field offering two integrated and complementary distribution networks, contributing to the company’s development and reputation.
The Solution
Meilleurtaux deployed QlikView to roughly 10 management team leaders in less than 1 week. With QlikView, Meilleurtaux can now analyze business activity across multiple lines of business and monitor the processing status of its client loan files and associated scoring. With QlikView Server, Meilleurtaux easily consolidated and handled the large data volume of 2 million records across 2 Oracle databases. Within a month, QlikView had become an indispensable tool for the various management teams at Meilleurtaux. The company, Ysance, was retained as the systems integrator. It was responsible for deploying the QlikView platform and initial development of the main management charts and graphs. Technically, the challenge was to consolidate and convert transaction data from two different operational systems, in order to implement a system that would facilitate decision-making.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.
Case Study
Samsonite Track&Go
Travellers spend their lives discovering new places and meeting new people from all around the world. It can be such a wonderful experience, but sometimes it can turn into a disaster when your luggage gets lost. In 2014 alone, more than 24 million pieces of baggage were lost. Fortunately, 95% of them were found and returned to their owners. However, that leaves more than 1 million items of baggage that have never been recovered.
