Case Study: MiFID II
Pre/Post Trade Transparency

Key requirements

• Extracting list of user accounts from SAP database
• Contact users to establish if they are users that need access to solution and which reports are needed
• Consolidate replies to conform report & user scope
• Confirm and change in-scope list for reports & users
• Enrich in-scope reports lists, consolidate reports
• Business specified reports and data sources

Solution Design

• Current architecture rationalisation and mapping
• Target architecture mapping
• Infrastructure configuration (Test/ Product environment)
• Feeds delivery – numerous sources of data all to be delivered by INS (integrated solution)
• Data Warehouse design – outline of system tech & components
• Development Approach – technologies and team approach

Implementation & Testing

• Scope and analysis
• Database extension and configuration
• Report creation and delivery
• Dependency timelines – ongoing ACL decommissioning.
• Testing challenges and approach. Feed, Report and Business tests.
• Business acceptance approach

Key Deliverables

• Arrange for additional data feeds to be delivered/consumed into reporting database
• Add new data fields into the DWM data model
• Define a new BO universe based on DWM
• Specify and build the required set of reports in BO
• Perform technical & Business tests on BO report data
• Create support documentation for reports

Solution Benefits

• Integrated reporting (single data source) in keeping with new requirements ( BCBS239, IFRS9, Impairment calculation etc)
• Parent company already have ‘Business objectives’ connected to their DWH using similar design principals, they also decommissioned SAP BW.
• App rationalisation in reporting landscape, reduced complexity/cost for any future development work.
• Front end BO view is familiar to business and user friendly.