United Kingdom

Choose another country to see content specific to your location.

Liquidity Risk Management: Pre-migration Data Assessment



  • Successful assessment of data and business logic requirements for the migration of the liquidity risk management solution to QRM


Banking Area 


  • Treasury and IT Systems


Skill Sets 


  • SQL

  • SAS

  • QRM

  • BCBS 239 Expertise




  • Liquidity Risk Management and Reporting

  • BCBS 239

  • Data Governance

  • Risk Calculator Migration

  • Pre-Migration Assessment




  • Banks must dedicate significant time and effort to accurately and comprehensively unpack years of code and business rules in legacy systems

  • Migrations should be flexible and avoid delays so that initial analyses do not become irrelevant

  • Understand the granularity of source system data and business rule attribute requirements before embarking on a system migration to QRM



To improve the agility and long-term value of its liquidity risk management capabilities, a large retail, corporate and investment bank initiated a project to migrate its in-house risk management solution to a vendor-product solution – QRM.


As part of the migration programme, Monocle was tasked with assessing and documenting the various existing data sources and business rules that existed in the client-built solution that was used for liquidity risk reporting and risk management. We were also tasked with building the initial daily and monthly automated process to source, transform and centralise the datasets that were stored across the organisation.


Monocle ensured that data quality controls were implemented to achieve compliance with BCBS 239 principles and built the reconciliations to ensure the dataset was aligned to the bank’s balance sheet. 





  • Comprehensive assessment and documentation of existing datasets

  • Automated process to source, transform and centralise the required liquidity risk data

  • Compliance with BCBS 239 principles


Key skills required 


  • Technical expertise to unpack large and convoluted ETL and data preparation code sets

  • Automation of data sourcing, conformance and reconciliation with consideration to BCBS 239

  • Ability to effectively assist the collaboration between Treasury and IT



"Monocle helped us immensely in identifying the gaps within the current process and providing recommendations on the optimal system deployment." - Head: Modelling and Analysis

How can we help you?

Contact us

What’s the latest with Monocle