The Palais de la Bourse (Stock Exchange Palace) in Lyon, France was erected in 1862 at the epicenter of the silk trade from which the city thrived. Today it is still one of the most remarkable landmarks of the city.
Client: Large Multinational Bank and Custodian
Requirement: Migrate two disparate Derivative Trading System database instances to single internally supported environment, merging the data into a uniform normalized single instance.
Rationale: The objectives were to gain additional control and flexibility over the business / technical environment and to establish a single instance of the Derivative Trading System to support a standardized service delivery for all of the Bank’s OTC (“Over the Counter”) derivative clients.
Capabilities: The scope encompassed business process re-engineering to support absorbing the administration and overhead, development of migration programs, re-configuring system integration, development of use and test cases, documenting an operational procedures manual, developing a migration strategy and deployment plan.
Our Contribution: O3 assumed Project Management responsibility for the data migration testing, integration testing, deployment, parallel testing, production rollout and post production business and technical support.
Approach: The approach was divided into two primary components; 1) Develop static, trade and market data migration programs and 2) Configure a single internal Derivative Trading System environment to support a production environment with normalized configuration. The development component involved first documenting the data migration inventory and requirements for history, audit trails and versions. A gap analysis to the core trading system extraction and loading utilities was performed to identify the additional development required. Technical specifications were created for the development items. Each development component was independently unit tested and validated against expected results. The process included testing on dynamically changing data as new customers, new financial instrument templates and new trades were added on a daily basis. The second component focused on the business application, developing robust functional specifications detailed technical specifications, based on industry best practices.
Results: Successful migration of the databases into a single in-house database without any data loss, disruption to the customers or business slowdown, on time and on budget. The process for transferring knowledge to the customer business and technical personnel occurred as part of the post production support process.