Slide 1: RQUEST TM - Regulatory Reporting
RQUEST TM - Regulatory Reporting An introduction to Regulatory Reporting Suite © 2011 vertiv
Slide 2: Regulatory Reporting
vertiv Regulatory Reporting vertiv CONFIDENTIAL Real-time configuration • Asset Class • Rules, Formulae and Cells Real-time trace-back • Results to sources • Data Lineage Hierarchical Rule Definition Interface Regulatory Reporting Reports Metadata for Rule-Cell association Rapidly changing regulator
Slide 3: Business Challenges
Business Challenges vertiv CONFIDENTIAL Rapidly changing Increasing audit Increasing Regulatory controls calculation requirements complexity • Limitation of • Visible • Increasing data organically grown calculations granularity – systems contract level • Need for cross • Trace-back • Time-series fun
Slide 4: Technology Challenges
Technology Challenges vertiv CONFIDENTIAL • Adhoc systems (Excel/Access/Scripts) System • Data Integration Challenges Limitations • Rules hard-coded into the system • Drill back to source not possible Implementation • Metadata and structural integrity missing Challenges • Reconciliation needs to be
Slide 5: RQUEST (Real-time Regulatory Reporting)
TM RQUEST (Real-time Regulatory Reporting) vertiv CONFIDENTIAL Financial Rules Manager RQUEST Two step transformation from transactions to report Built in Statistical functions and time-series analysis Regulatory Reporting Reconciliation Engine Ability to bring in multiple datasets to same
Slide 6: Vertiv's Regulatory Reporting: Management Calculations
vertiv’s Regulatory Reporting vertiv CONFIDENTIAL • Centralized Reference Data Management • Strong and robust data model - End to end functionality • Complete transaction data with no loss of granularity – Transparency issue Data • Unification – Bringing data from various sources together • Complete
Slide 7: RQUEST – Why a new product?
RQUEST – Why a new product ? vertiv CONFIDENTIAL Traditional Rule Limitation Vertiv’s Financial Manager Rules Manager • Good for • Cannot meet • Set Operations transactional processing volume needs • Does not H can meet volume • Good for low H typically access E requirements • Traceability / A volum
Slide 8: Regulatory Reporting - Features
Regulatory Reporting - Features vertiv CONFIDENTIAL Metadata driven approach makes it easy for on boarding new reports Two step rule transformation approach brings modularity to process Extensive support of finance functions ensure good coverage of the requirements Inbuilt traceability and Reconcili
Slide 9: Regulatory Reporting - Features
Regulatory Reporting - Features vertiv CONFIDENTIAL Report metadata links Report – Schedule – Part – Line - Cell This allows marrying a regulatory rule to a report cell Rule to Cell association allows trace back from cell to source Report metadata also ensures if all the line items are being
Slide 10: Features - Scalable and Efficient
Features - Scalable and Efficient vertiv CONFIDENTIAL Minimized trucking of data ensures scalability Two stage approach for regulatory reporting ensures minimized data movement and enhanced performance Reporting Data mart (Cell Definition) Second Level Second Drill Level back Rules Contract Leve
Slide 11: Features - Traceability and Lineage
Features - Traceability and Lineage vertiv CONFIDENTIAL 1* Data lineage Transformation PATH from 1* 2* source to target is always maintained 1* 2* Drill back 1* 2* Intermediate VALUES at various 1* 3* 2* stage are also maintained from source to target Identify sources of potential liquidity
Slide 12: Features - Adjustments Functionality
Features - Adjustments Functionality vertiv CONFIDENTIAL Robust Adjustment Module Adjustments can be made at various stages of report gen Adjustments can be applied to other reports Adjustments are version controlled and audit trail generated Updating transactions supported for privileged
Slide 13: Features - Sample reporting metrics
Features - Sample reporting metrics vertiv CONFIDENTIAL Contractual Spot Open maturity < 1wk 1wk -1m 1m-3m 3m-6m 6m-12m >12m Total Assets 110 20 10 Total Liabilities 70 30 20 Off Balance 20 Sheet Liquidity Mismatch -20 10 10 Mismatch as % of total -18% 50% 100% Assets • Dimension rich data mart supp
Slide 14: Features – Other key features
Features – Other key features vertiv CONFIDENTIAL Robust data integrator consolidates data silos Reconciliation module delivered for quick data checks Reports coverage for FFIEC 001-009, FR 2314 reports XBRL support for electronic filing Utilities like Hierarchy manager, Process Scheduler
Slide 15: Summary
Summary vertiv CONFIDENTIAL Regulatory Reporting warrants: Contract Level Data capture from several source systems Metric Level Processing Data Aggregations with drill down support Expandable for future requirements Ideal solution should offer Massive Data Handling Rules Drill back a
Slide 16: Appendix
Summary vertiv CONFIDENTIAL Appendix © 2011 Bintelgroup 16
Slide 17: RQUEST Edge
TM RQUEST Edge vertiv CONFIDENTIAL Dimension Traditional Rule Engines Vertiv RQUEST Methodology Processed one row at a time - slow Many rows can be processed at a time Execution Java/C++ Based SQL, CCL based Processing Mechanism Out of procedure In place data processing • Longer Times (Latency) • No
Slide 18: RQUEST Edge
TM RQUEST Edge vertiv CONFIDENTIAL Dimension Traditional Rule Engines Vertiv RQUEST Infrastructure Scalability Low-medium Highly Scalable • Clustering • Vertical • Grid / Cloud • Horizontal Processing choice Possible Limitations Diverse • Real-time (CEP) • Intra-day (Cache) • End-of-day (DB) Utiliti
Slide 19: Implementation Methodology
Implementation Methodology vertiv CONFIDENTIAL Definition Phase Testing Phase Define Liquidity Reporting Requirements Execute integration test cycle Define and Build Liquidity Reporting Business Case Execute system test cycle Define solution architecture Execute UAT test cycle Defi
Slide 20: RQUEST Edge
TM RQUEST Edge vertiv CONFIDENTIAL © 2011 Bintelgroup 20