A Tier‐1 Bank headquartered in Netherlands. The bank in India, Japan, Hong Kong and the UAE, was operating through RBS until these units (all customer, accounts, balances and interest accruals, import/export financing, loans and deposits data ) were transferred to ABN AMRO Bank N.V.
The source data were provided as flat files, separated per branches (Hong Kong, Japan and UAE), which then had to be transformed, consolidated and loaded into the target system. The loading process had to keep the data consistency and integrity. Major incompatibility in Limit structures for the legacy and target system required several iterations until the final approach was approved.
The migration had not been given enough priority in the early stages and the ABN‐AMRO Operations and Credit Risk departments were not prepared for the transition. However, the aggressive timeframes that had been set could not be changed.
Validata’s V‐Conn was selected to manage the extract, transform and load process, as well as providing the staging area for the data Reconciliation of data, both static and transactional, was also delivered.
