Equa Bank clients were fully migrated to Raiffeisenbank in 12 hours
When Equa Bank was being merged into Raiffeisenbank in November 2022, we handled the migration of Equa Bank’s client data into Raiffeisenbank’s CRM system. We also ensured the client master data was propagated to the bank’s core systems.
We cooperated on defining the business rules for the migration process.
We connected subjects from Equa Bank with an existing master record in Raiffeisenbank or created a new one that was then copied into Raiffeisenbank’s other core systems.
We developed and designed the complete migration process, which resulted in a seamless merger of the two client bases into one.
Up to 450,000 people, each with almost 200 attributes, have been added to Raiffeisenbank’s client base.
The consolidated and unified data in the new client base offer a reliable foundation for Raiffeisenbank’s regulatory reporting to Czech and European authorities. This is more complex compared with Equa Bank’s reporting, so the requirements for data accuracy were high.
10 months of testing and agile development shortened the live migration of client data from 3 weeks to 12 hours
- Defining the rules and development of the migration process was done without any knowledge of Equa Bank’s production client data. This was extremely challenging, as it was, to a certain extent, a blind implementation.
- We then spent 7 months migrating and updating data in parallel in Raiffeisenbank’s systems so that Raiffeisenbank bankers could also work with Equa Bank clients.
- We held 5 dress rehearsals over 10 months to practice the migration. During each of these sessions, we had to update the base and identify attribute-level details that could obstruct the final large migration of products.
- Thanks to thorough testing and optimization, we were able to shorten the actual migration of client data from Equa Bank into Raiffeisenbank’s systems from the original 3 weeks to 12 hours.
18 months
were spent preparing the migration process
The unique approach
involved 6 months of updating data in both banks’ systems in parallel
200 attributes
on average, were migrated for each individual client
Phases of the client data migration process implemented by Adastra
Definition of the business rules
In cooperation with the bank’s business departments, we defined the business rules for the data migration. These related primarily to prioritizing attributes for merged clients so that, after the merger, we would have the best possible client records.
Creation of the master record
We defined which data to transfer from which systems and where to in Raiffeisenbank’s systems, including the “golden/master record” – i.e., the exact formats and structures of the data to be transferred.
Testing client data migrations
Over a period of 10 months, we continuously migrated client data in several phases as part of a testing program. We evaluated the data migrations and, based on the results and in cooperation with both banks, we adjusted the business rules set in the first phase of the project.
Data cleansing
At the same time, the input data were cleansed so that the banks would be working with client data of the highest possible quality in the new, joint data warehouse. We used the Ataccama MDC platform.
Regulatory reporting
The unified data were propagated to regulatory reporting. Raiffeisenbank had to report as a single entity from January 2022. We also participated in combining Czech and EU regulatory reporting, as Equa Bank reported under Czech legislation and Raiffeisenbank reports according to EU legislation.
Timeline of the process of merging the Equa Bank and Raiffeisenbank client bases
This process was repeated and improved with each cycle.
Development was initially “blind”, without real client data. We automated testing of the migration process as much as possible due to the huge volumes of data.
In the last 6 months, we processed live client data – we maintained all changes in the data in parallel in both client bases, in the original Equa Bank system and in the joint Raiffeisenbank CRM system.
The live migration of client data into a single system took place over the weekend of 12-13 November 2022 within 12 hours.
54times
in 6 months, clients’ birth numbers changed
6 clients
changed gender between March and November 2022
Our case studies
National Bank of Slovakia Embarks on a Transformative Data Journey
We are thrilled to partner up with Národná banka Slovenska on their mission to become a data-driven organization that can rely on its data. Our strategic data management partnership will provide NBS with effective data engineering automation solutions. For example, we will build a data warehouse and data lake where data reports are created right in the data platform rather than outside it, using AI as a key tool. This strategy is inspired by the big data approach and data management practices that we have previously applied in our tendering experience with ECB. We believe that such a partnership is not only achievable but also hugely beneficial and transformative.
Equa Bank clients were fully migrated to Raiffeisenbank in 12 hours
When Equa Bank was being merged into Raiffeisenbank in November 2022, we handled the migration of Equa Bank’s client data into Raiffeisenbank’s CRM system....
Adastra is helping emerging Bulgarian banking leader in their data migration journey
We are thrilled to have been selected as the key partner for the strategic Merger & Acquisition program of United Bulgarian Bank a...
Adastra helped ČSOB Finančná skupina to transfer all of OTP’s clients
We are happy to announce successful completion of the ČSOB-OTP data migration process. Over the last two years, we’ve helped ČSOB Finančná skupina transfer...
Get inspired on our blog
Adastra becomes a strategic partner of Škoda Auto University. Its specialists will teach data management, data science, and artificial intelligence courses
Adastra becomes a long-term strategic partner of Škoda Auto University. Its experts will be involved in teaching data management, data science, and artificial intelligence...
Meet our team: Martin, DWH/BI Developer
Today we are excited to introduce you to Martin, our DWH/BI Developer. A keen hiker and mountain lover, Martin shares his take on the...
Unraveling the Future: Top 8 Data Management Trends for 2023 and Beyond
The digital landscape is evolving at an unprecedented pace, and with it comes a new set of challenges and opportunities for IT professionals, data...
Interested in a similar solution? Contact us
