Creatis Bank Manages Regulatory Compliance with Talend Data Integration Suite

Managing many databases, the bank depends on Talend's open source integration solution to feed a Data Warehouse that guides its compliance requirements to the Basel 2 directives.
We calculate that with Talend Data Integration we reduced development time by a factor of 3 - a particular advantage for teams involved in the migration project. Talend's solution lets us handle data extractions via a graphical interface that accelerates the production of the documentation and notations that Basel 2 requires.
Stéphane Leclercq, Head of Standards and Development

Specialist in loan consolidation

A specialist in loan consolidation for the past 10 years, Creatis has been part of the Cofidis Group since 2006. Its main activity is the purchase of consumer credit through its retailing channel, via a network of brokers. Creatis has nine agencies distributed over the Nord-Pas-de-Calais and Picardy and provides local banking services and a large range of savings plans to individuals and associations.

Creatis also offers consumer credit via a call center and its website. Today the fast growing company has 250 employees and has developed a multi-channel and multiproduct approach to win new customers.

An evolving information system

Creatis needed to reconcile two constraints to further its IT development. In addition to continually evolving the technical architecture, the organization and the processes of the company in coordination with various departments (marketing, risks, sales, financial, etc.), Creatis had to ensure the daily performance of the information system as well as its operational security. Like all banks, Creatis wanted to implement a responsive Information System that would allow it to proactively satisfy its customers.

Therefore, when the bank decided to restructure its mortgage package in 2007, a new information system was developed to manage and market it. The original information system remained in use and evolved to handle other bank products and credit (personal loans, reserve money, etc.) whose migration to the new system would come later. The original database was split into two independent parts. By the following year all bank accounts had migrated to the new Information System based on two software packages - Viveo's for banking and Efibank to manage credit-the AS/400 databases and web interfaces developed in Java.

To monitor these activities, Creatis relied on a system developed in-house which was directly connected to the original database. "Because of the new multi-database architecture, data extraction became more complicated and required a lot more work,"€ explained Stéphane Leclercq, Head of Standards and Development at Creatis. "€œWe quickly became aware that we needed to develop a real data warehouse that would let us efficiently analyze our activities. Our Research and Development department was tasked with identifying appropriate data integration products, focusing on open source solutions."€

Talend Data Integration: a quick response to increased regulatory constraints

Creatis began by testing Talend Open Studio for Data Integration. "€œIn addition to our traditional banking activities, regulatory requirements put in place by Basel 2 required that we reconcile both IT systems and implement a five-year data report. Talend's solutions were particularly effective in this context because of their ability to easily manage multiple databases. After exhaustively testing Talend Open Studio for Data Integration, we opted for Talend Data Integration whose additional collaborative features allowed our three developers to manage projects as a team."€

In addition, the Java-based solution and its Eclipse development interface have accelerated its implementation. "€œTalend's ease-of-use is a plus,"€ said Stéphane Leclercq, "because there's no down-time spent learning the product. We can focus on business and regulatory aspects instead of wasting time resolving technical issues."€

Today, the data warehouse is near completion. It drives all financial activities and bank clients. Each branch manager is now able to get a dashboard of their customers and the central controlling department globally consolidates all financial activities. For example, daily reports indicate contract status and monthly reports help manage various activities, such as litigation.

"€œSeveral extractions have been developed to meet our regulatory requirements,"€ said Stéphane Leclercq. "€œFirst, we developed a model score with Experian, which helps us calculate profits and losses, in a database dedicated to risk management. We also analyze certain banking activities, such as types of credit cards sold to our customers. Today, most of these extractions are integrated into a spreadsheet, such as Open Office, but we plan to install a free open source viewer - like QlikView - to improve our analytic process."

€Development time divided by three

Today, Talend Data Integration is at the heart of Creatis' monitoring system. "€œIn selecting Talend Data Integration, we made a strong strategic choice that meshes well with our parent company, Cofidis, which also uses this solution. We didn't want our multi-database architecture to get in the way of data extraction and Talend Data Integration helped us achieve that,"€ explained Stéphane Leclercq. "€œWe calculate that with Talend Data Integration we reduced development time by a factor of 3 - a particular advantage for teams involved in the migration project. Talend's solution lets us handle data extractions via a graphical interface that accelerates the production of the documentation and notations that Basel 2 requires. Creatis plans to take advantage of Talend's consistency and quality to meet other regulatory requirements. For example, the bank needs to verify data entered by business referrers who directly access its information system." 

Creatis takes advantage of Talend's Java libraries to aggregate the data produced by its J2EE application. "€œWe have developed services to produce specific calculations - such as monthly payments for credits - consistent with our internal business rules,"€ concluded Stéphane Leclercq. "In addition, through a customizable system of permissions, our developers can share projects and collaborate more easily than before, increasing productivity. Finally, we are very satisfied with the reliability of the solution and have had no need to contact to Talend Support Services. The forums and documentation on Talend's website have enabled us to respond quickly to the few questions we faced!"