Capital Markets Advisors

Turning Change Into Opportunity


Client Situation:

  • Global Investment Bank was interested in migrating the handling of its cash securities products from a legacy risk management system to a new broader cash securities data store. CMA resources were hired as the overall PMO for the development of the data store, as well as specifically to perform a current state analysis for the legacy system, managed by the derivatives IT team.


  • Worked with client to understand the current usage of the legacy database and the breadth of products it covers.
  • Performed interviews with business and technical resources for all systems feeding information to and drawing information out of the legacy database.
  • Based on interview, developed a detailed systems descriptions document on all up and downstream systems and the functions for which each system uses the legacy database.
  • Reviewed underlying data tales and fields and prepared a detailed data dictionary for all position and transaction tables for equities, futures, options, bonds, payments and FX products.
  • Developed process maps for all systems and the underlying data transformation performed by each system.

Key Benefits:

  • Developed detailed documentation on the legacy system, which never existed before.
  • Client obtained a full detailed description of all systems, which feed information to or extract information from the legacy database.
  • Detailed data dictionary will be used by client in the design and build of the future state data store to ensure it handles all current functionality.
  • Connect With Us

    Visit Us On FacebookVisit Us On TwitterVisit Us On Linkedin