Managing the liquidity, financial reporting and risks of such a large corporate treasury, implied a large and diverse portfolio of complex loans, bond-swap hedges, options and vanilla FX and money market deals. Covarius was mandated by BHP Billiton Treasury to identify, design and deliver the most automated solution possible to help migrate this extensive trade portfolio from SunGard Quantum to SAP TRM.
The initial complexities that this process encountered were centred around the vast differences between the design and architecture of both systems.
The term 'round peg in a square hole' was certainly appropriate. Compounding this problem where SAP specific vagrancies and differing Treasury terminology, which made data mapping a challenging task.
Covarius seconded a lead Quantum Architect, a lead SAP Data Migration expert and SAP Data Migration consultant for the 1SAP Treasury project, in order to solidify the 1SAP Treasury data migration and reconciliation.
The approach recommended to the client by Covarius included:
During the initiation of the data migration portion of the 1SAP Treasury project, it became clear that certain obstacles would need to be overcome to ensure BHP’s objective of automating and solidifying the extraction and validation of data from Quantum into SAP formats. The first of these obstacles including establishing an extraction and transformation layer (ETL) and a staging database for staging this data. The staging database relational table structure, lookup tables and data transformation (DTP) packages were built by the Covarius Quantum lead for BHP Billiton using a SQL Server 2008 database platform.
The second of these obstacles, notably validation of the staged data within the staging database, would require specialized ‘structured queries’ (SQL), stored procedures and programming logic that could be called within SAP Business Objects Crystal Reports, to ensure integrity of data extraction during SAP format export. Each SAP format extraction was accompanied by a validation output log. The Covarius Quantum Lead together with Covarius SAP Treasury data migration lead, jointly worked to construct these queries and crystal reports based on expert knowledge input from the Treasury business.
The development of such logic for BHP Billiton meant that by the time data had been extracted through this process developed by the Data Extraction team in London, very little validation was required to be performed by the Data Loading team in Singapore. The Cransoft warehouse for SAP data extractions, owned by the Data Loading team, was therefore maximally simplified and SAP formats could almost immediately be loaded via LSMW or Business Objects SAP function module call.
The final challenge was to build reconciliation reports to reconcile raw staging database outputs with extracted SAP formats and SAP TRM report post load outputs. This was built using a twenty thousand line VBA model which used various extraction imports to provide a detailed and summary breakdown of line item counts and transactional line to total value reconciliation, for each extraction.
BHP Billiton is a world first for a successful, 71.4% automated Quantum to SAP migration. Covarius, in conjunction with the 1SAP Treasury Data Loading team located in Singapore, delivered a number of world-first extraction mechanisms for automating the extraction, validation and migration of data from SunGard Quantum to SAP TRM using SAP Business Objects.
The result of this successful partnership was a mechanized data migration architecture that resulted in rapid reloading of transactional and master data during mock data conversion cycles and SAP test landscape preparation. This resulted in increased master data integrity, improved transactional data accuracy and faster data loading.
We are a consulting and technology solutions provider to treasuries and banks. We challenge the conventional by combining a disruptive thinking approach with business, technology and development expertise that pushes industry boundaries. Through our Advisory, Technology and Academy services, we are shaping the future for our clients by placing innovation at the heart of everything we do.CONTACT US
THE POWER OF DREAMS,