SOLUTION SHEET ShareInsights

Data Migration for a Leading

Wholesale Bank in the US
 Index

Background 01

The Challenge 01

The Solution 02

Solution Accelerators and Reusable Components Across Phases 02

Communication Framework 03

Data Migration – Extract Transform Load (ETL) Architecture 04

Key Results 04

About Accelerite 05

Copyright All Rights Reserved ©2018 Accelerite Solution Sheet Dec 2018
 Accelerite Solution Sheet- Data Migration for Bank

Background

Mergers and acquisitions are often highly stressful events for banks. Massive volumes of data
need to be combined between banks, departments, and systems. The role that data migration
plays in ensuring business continuity during and post the merger of two banks is critical. Even
though the data migration process usually lasts for two to three years after a merger, the
impact of any glitches during the migration can last well beyond this time frame. When it
comes to data migration during a merger, the most significant success factor is assuring the
accuracy of the data that is migrated.

We recently helped one of the largest banks in the United States with over $1.95 trillion in
assets carry out a smooth transition during a major merger. The bank was in the process of
acquiring a Charlotte-based financial institution in a $15 billion deal. The merger meant that
more than a million users had to migrated based on their geographic location in twelve
conversion events. The timelines and dates for these events were fixed and there was no room
for any delays. Along with a million users, close to fifty thousand wholesale customer records
and their entitlements also had to be migrated. The migration was to be traced from forty-five
distinct sources to twenty-two targets with a whopping one billion data elements.

The Challenge

Data migration accuracy was a critical challenge that had to addressed extremely carefully. A
failed effort could have a devastating effect, both in terms of regulatory and statutory
reporting as well as reputation and loss of customers. Effective communication was a
daunting task with over three hundred people working onsite and offshore. Complexity further
spiralled with two independent vendors thrown into the mix. The two banks had vast
differences in their working cultures and if they were unable to get over these differences, the
merged unit would not be able to operate well as a single entity.

During the migration process, the number of data elements kept increasing exponentially as
banking transactions were on the rise post the merger. From an initial one-thirty million, the
total number of data elements went up to five hundred and seventeen million towards the end
of the migration.

Copyright All Rights Reserved ©2018 1 Accelerite Solution Sheet Dec 2018
 Accelerite Solution Sheet- Data Migration for Bank

The Solution

We approached these challenges with a phased solution that involved the right team across
each of the key stages of data analysis, implementation, and validation.

Data Analysis

Key Phases

QA and Validation Implementation

Frequent knowledge transfer sessions ensured that all team members had a comprehensive
understanding of all the modules in the banking application. This enabled resources to be
rotated efficiently across the different modules. Code reviews were implemented at various
levels before the build process to catch any defects at an early stage. In line with this, a sign-
off from gatekeepers, including business QA analysts, was mandatory at each level before go-
live. To ensure accuracy, unit test coverage was also reviewed by data analysts. A two-week
pre-SIT entry test was carried out prior to SIT to resolve any issue slippage from unit testing
due to missing data conditions.
The team leveraged several powerful and reusable solution accelerators and scalable
automation frameworks for data analysis, implementation, and QA. This led to a hundred
percent automation of all data migration test cases. It also provided the ability to reuse
components of the migration in other projects, including transformation functions, error
handling, and data cleansing routines.

Data Analysis Implementation QA and Validation

Data Analyst Solution Execution QA Automation

Documentation Tool Framework Framework

Solution Accelerators and Reusable Components Across Phases

Copyright All Rights Reserved ©2018 2 Accelerite Solution Sheet Dec 2018
 Accelerite Solution Sheet- Data Migration for Bank

Communication and conveying changes to the customer in a timely fashion is a key aspect of
the data migration process. A solid communication framework was established to ensure a
seamless flow of information, query resolutions and inputs between the onsite, offshore,
business, and customer teams. A detailed change tracker was maintained and sent with every
build along with unit test cases and scope. The build process was thoroughly streamlined to
create a cohesive work environment for multiple vendors.

Technical Team
Daily interaction during
Ad hoc Query analysis phase
resolutions and inputs
Onsite on- going basis Business
Technical Analysis Business
Teams Teams Ad hoc Query Teams
resolutions and inputs
on- going basis

Daily updates Daily updates Daily updates

Daily updates during
handover phase
Monthly review

Offshore Persistent Customer

Technical Management Daily updates Management
Teams Daily updates Teams Teams

Weekly status updates

Need basis

Communication Frequency Legends

Competency Team @Persistent Daily Weekly Monthly Ad- hoc

Communication Framework

Copyright All Rights Reserved ©2018 3 Accelerite Solutin Sheet Dec 2018
 Accelerite Solution Sheet- Data Migration for Bank

The team managed all aspects of data extraction, transformation, cleansing, validation and
loading into the target – and managed high volumes of data. They resiliently addressed issues
in the working environment such as potential problems with source and target connections,
disk space, and memory problems.

Source Target
Database Database

Application-wise,
Processed source data Staging
Area
Master sequence

ETL Job ETL Job ETL Job

Invalid data Valid data Non-compliant data

Sanity Yes Referential

Data error Valid data Target staging Referential
check integrity error
tables tables tables integrity check
passed ? check

Corrected data Corrected data

Data Data
Rejected data Rejected data
reconciliation reconciliation

Data Migration – Extract Transform Load (ETL) Architecture

Key Results

The team’s tireless efforts for over two years and strategic use of solution accelerators
ensured a successful merger of the two banks from a data migration perspective. Customers
and end-users were able to use all banking services as usual, without any interruptions
cropping up due to inaccurate data records.

% ?
Zero defects post 265% growth in the 80% reduction in test Query execution time
integration for all number of data execution time slashed from 80 to 11
releases elements migrated minutes

Copyright All Rights Reserved ©2018 4 Accelerite Solution Sheet Dec 2018
 Accelerite Solution Sheet- Data Migration for Bank

About Accelerite

Accelerite: Data Migration for a Accelerite is a Silicon Valley based company delivering secure business-
Leading Wholesale Bank in the critical infrastructure software for Global 1000 enterprises. Accelerite's
US product suite includes hybrid cloud infrastructure, risk-based
authentication, endpoint security, big data analytics, and the Internet of
Accelerite World Headquarters Things.
2055 Laurelwood Road To know more about Accelerite ShareInsights, visit www.accelerite.com/
Santa Clara, CA 95054 shareinsights
U.S.A.

Worldwide Inquiries
Phone: +1.855.464.4247

Copyright All Rights Reserved ©2018 5 Accelerite Solution Sheet Dec 2018