Data migration from Legacy System to in-house Proprietary System for one of the leading US Bank, including Migration of more than 40,000 Trades
Client: Large US Bank
Objective
To help one of the top US bank migrate from an existing Murex system to an in-house proprietary system via scripted and manual migration. Project required the migration of more than 40,000 trades across asset categories and 40 product types, including complex rate products and exotic products.
CRISIL's Solution
- Scripted Migration Approach
- Script Analysis: Analysed migration execution scripts to map data flow and lineage between legacy & strategy systems
- Rollback Testing: Checked the integrity of database to for restoration in case of erroneous operation
- Patch Update: Developed different patches for updating the fee, payment schedule and CSA mappingT
- echnology: FpML standard, XML, Unix, SQL & VBA
- Manual Migration Approach
- Data Mapping Templates: Worked with development team to design tools for bulk uploads and templates for data mapping & data transformations
- Data Control Checks: Implemented scripts, patches and checks for data quality (CDR, CSA mapping, payment schedules, fees & identifier patch)
- Data Validation: Designed validation for data dumps to meet accepted business rules
- Trial Migration: Checked downstream impacts in UAT environment before manual production deployment
Client Impact
- 100% completion of migration within the timelines and ahead of the decommissioning of legacy system
- Scripted migration of 22k trades and Manual migration of 18k trades
- Extensive and on-going post-migration support
Questions