With Talend, we have structured our business data and automated its processing in a BI framework. With the performance of the solution, we can constantly increase the data volumes that we use, worry-free.Claude Martinez, Director of information Systems
Mutuelle Bleue operates in the areas of health and property insurance. The company offers individuals and businesses a full range of additional health and retirement benefits, in addition to auto and homeowners insurance. Mutuelle Bleue provides health coverage for 275,000 people, retirement benefits for more than 349,000 people and obligatory social security benefits for more than 112,000 artisans and shopkeepers, divided across three regional centers: Ile-de-France, Midi-Pyrenees and Lorraine. With a turnover of €160 million in 2012, it is the 28th largest interprofessional mutual company in France. Mutuelle Bleue is a social economy enterprise, defending the values of solidarity, efficiency and proximity.
Standardize business data
Data is at the heart of the insurance industry. Increasingly diverse and originating from multiple sources, it must also always be available and accessible by the people, who are in themselves increasingly diverse. Mutuelle Bleue is no exception to the rule: it operates in multiple areas (supplemental, retirement, property and casualty coverage), several sales channels, including indirect channels (brokerage) and therefore several information systems to orchestrate all the activities.
“One of the risks associated with multiple applications and information systems lies in the creation of information silos. Given the intense growth of data volumes generated by these applications and at the same time the increased need to open up our information systems to external players – for example to partner brokerage firms – we initiated a data structure standardization program, taking advantage of the implementation of a BI solution ,” explains Claude Martinez, Director of information Systems at Mutuelle Bleue. “This program first aimed to implement quality checks on each piece of data created, and secondly to organize, arrange and classify the information.”
Before the deployment of this new BI platform (based on the SUADEO application), Mutuelle Bleue did not have any form of truly structuring data. Requests were made directly to the business application databases with poor performances and increasingly complex maintenance as the demands of business users increased.
“We chose to use Talend Data Integration, which plays the role of orchestrator of data movements and quality checks. This solution, known for its openness, has the best quality/price ratio on the market. It supports all file formats in our information systems in addition to handling large volumes. What’s more, being well-known on the market, we had no trouble finding specialized resources,” clarifies Claude Martinez.
Talend Data Integration: orchestrator of interoperability
The Mutuelle Bleue BI project covers many aspects of its business: finance, commerce, HR, purchasing, etc. Its objective is to facilitate recurring and regulatory management by General Management and the Business Divisions. They now have many dashboards and reports, and some information is also distributed to external partners. These reports range from calculating staff and sales, to the consumption of services, activity monitoring, forecasting, budget simulations, etc.
“With Talend, we were able to both industrialize the production of all of these reports (which was impossible manually) and to structure our data to create a single processing logic across all of our applications,” continues Claude Martinez. “To do this, we recruited a Talend specialist who deployed the solution and developed the data integration flows.”
Mutuelle Bleue started testing with the Talend Open Studio for Data Integration community solution, which allowed it to validate its approach.
“Being able to test the functionality of a free solution is really fantastic. I would like to add that the selection of the tool was made before recruitment and performed using non-specialized resources, which illustrates how easy Talend Open Studio for Data Integration is to use,” comments Claude Martinez. “We then adopted Talend Data Integration to go one step further in terms of the technical implementation of our BI processes, while retaining our initial work. Today, first we centralize processing, and then we enter the results into a secure portal on a monthly basis. The processing will be carried out on a weekly basis.”
Responsiveness, flexibility and performance
The first results were achieved quickly. “With Talend, on the 1st or 2nd of each month, we are now able to see the results of the previous month, which was not the case beforehand. This responsiveness is appreciated by users who also stress better data quality,” enthuses Claude Martinez. “And this is a proven fact: we detect quality errors or defects earlier, and with our automated and “locked” processing, data quality is overall much better. Our ability to anticipate the future really benefits from this.”
Furthermore, any processing change no longer demands the complete resumption of the process, which contributes to the increased productivity of the IT department.
“With Talend, we have structured our business data and automated its processing in a BI framework. In the end, we have decompartmentalized our information systems, while opening them up to external partners. With the performance of the solution, we can constantly increase the data volumes that we use, worry-free,” concludes Claude Martinez.