Major data migration project hinges on independent reconciliation validation
Based in the affluent Indian Ocean island of Mauritius, a leading financial services group was embarking on a major IT core system upgrade, dubbed project “Flamingo.” The project goals focused on leveraging new technologies to greatly improve customer service, operations, competitiveness, and risk mitigation. Ultimately, the aim was to elevate core banking functions to make great strides in four key areas – business, operations, service and technology.
This important and complex undertaking included crucial data migration from 16 legacy applications to the new systems. But, to ensure success, the bank needed to perform independent data migration testing or reconciliation validation. Done correctly, this would validate the correctness of migration by a third-party vendor, and meet target application requirements. Staying within the project budget was also a priority.
Reconciliation validation would need to include:
Quinnox team takes on challenges with expertise, rapid response, and proprietary tools
Our team was already part of a multi-phase Flamingo effort, so it was a natural choice for the bank to choose Quinnox to perform vital reconciliation validation. Because of the complexity of the data migration, as well as obstacles presented by a third-party vendor, the team had to overcome a number of significant and immediate challenges.
Reconciliation upstream applications came with an aggressive completion timeline to ensure go-live – within 18 hours of receiving the target data. This included all activities – data import, data transformation and comparison, defect analysis, and defect triage with the bank and system integrator. The complexity and volume of data was also a difficulty – some tables were as large as 30GB with over 50 million records. Missteps in version control, a high number of defects, unanticipated delays, and missing tables from data dumps received from target systems added to the challenges.
Fortunately, the Quinnox team was well-equipped to overcome all these obstacles. Even those that were unanticipated were addressed “on the fly,” ensuring Flamingo would fly on track. For example, a rapid response team was routed to a third-party vendor to quickly remediate issues and correct errors.
In addition, a variety of proprietary Quinnox tools and accelerators were used that helped overcome obstacles and add value, including:
Reconciliation validation delivered on time, providing high confidence to go forward
Data complexity, very large files, third-party missteps and delays, and other unexpected variables were swiftly dealt with by an expert team using powerful Quinnox tools, resulting in:
Best of all, the timely and efficient reconciliation validation services performed by the Quinnox team gave the bank’s IT team-high confidence in their critical data migration. It was a necessary and vital step in moving Flamingo forward, and manifesting this growing bank’s core IT system transformation goals.
Benefits by the numbers: