Data Migration from legacy system to in-house proprietary system for one of the leading US Bank
Client : One of the leading US banks
Objective
- Migration from existing Murex to in-house proprietary system via scripted and manual migration
Challenges
- Over 40,000 trades across asset categories and 40 product types to be migrated
- Complex rate products and exotic product through STP/scripted migration, not in original scope & parallel streams
CRISIL's solution
Scripted Migration Approach
- Script Analysis: Analyse migration execution scripts to map data flow and lineage between legacy & strategy systems
- Rollback testing: Checked the integrity of database to restore incase of erroneous operation
- Patch update: Developed different patches for updating the fee, payment schedule and CSA mapping
- Technology: 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
- Scripted migration of 22k and Manual migration of 18k trades to the strategic system
- 100% completion of migration within the timelines and decommissioning of legacy system
- Delivering knowledge transfer and providing post-migration support
Questions