Bond Administration

Case Study: Bond Administration - Global Bank Data quality, workflow and dashboard reporting combined

A top Issuing and Paying Agent in the global bond market now uses Omniscope internally to track all aspects of over 300,000 bonds and other debt instruments they administer.

Challenges:

• Diverse source databases undergoing continuous change/consolidation in different locations
• Inconsistencies and incompleteness of records required local 'data mart' database to consolidate/filter data
• SQL-based reporting scripts required constant changing and testing as the source databases and reporting requirements evolved.
• No integrated management 'dashboard' to monitor upcoming deadlines and manage peaks and valleys in staff workload.
• Finding/filing documents and spreadsheets associated with a given bond/issuer not quick or reliable enough.
• Client reporting involved faxing hundreds of pages to large issuers, or e-mailing ugly spreadsheets containing rows of data but no overall message, value-added or branding.

Omniscope Solution:

Client decided to adopt Omniscope as low-cost combined business intelligence reporting, data quality and workflow solution, with no relational SQL-based databases to maintain inside the department.

-Costly local 'data marts' eliminated, centrally administered databases now deliver large views/tables as 'meta-reports' directly to Omniscope. -Omniscope used to merge and transform data using conditional formula data validation columns. -Data consolidation, re-naming and high-level scrubbing now done quickly in the daily Omniscope source file by data quality staff. -Senior management now receive by email a daily report file (containing all the data) that opens as an interactive 'dashboard' slide show.

Daily Omniscope master file divided among Team Leaders for detailed scrubbing, adding links to associated documents, joining in the previous day's annotations/commentary, and prioritising key tasks before further dividing the file among their team.

Next step will be to start delivering client reports in branded, highly-visual, value-adding Omniscope files, as well as interactive Flash DataPlayers produced for each client using the companion DataPlayer Studio product.

Back to Finance Case Studies