Search
Search

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

Request for services

Error Msg
Error Msg
Error Msg

Questions



Looking for high-end research and risk services? Reach out to us at:

 

United States
1-855-595-2100/
+1 646 292 3520

 

United Kingdom
+44 (0) 870 333 6336

India
+91 22 33 42 3000 /
+91 22 61 72 3000