Business Intelligence - emagine.co.uk

1 Business Intelligence Industrialising all automating information and insight delivery Customers increasingly require on-demand insights from operations in order to respond to the dynamic Business environment. The technology marketplace offers plenty of choices for clients' Business Intelligence technologies, which create heterogeneous, or fragmented enterprise and Business Intelligence Architectures. Customers want to better deliver value from their existing investments, as well as investing in new technologies to reduce this Total Cost of Ownership (TCO) whilst improving consistency and Offerings Servicing Enterprise Business Intelligence Architectureemagine understands that Business Intelligence and Analytics delivery requires a comprehensive understanding of data integration, management, modelling and visualisation disciplines.

2 Our multi-skilled consultants have a track record of delivering excellence across the Business Intelligence Architecture spectrum, by leveraging our specialised technologies to increase overall engagement has invested in our delivery-focused Center of Excellence (COE) which builds our BI Architectural thinking capability and ensures measurable results for engage with clients throughout the entire BI/Analytics idea to market Lifecycle. Our key offerings include: Architecture/Platform Consultancy Programme/Platform Delivery System/Platform Operations Delivery Skill Augmentation and Skills TransferDriven by our proprietary COE, our unique, agile and interactive approach delivers early benefits to clients, including the incremental evolution of the architecture incrementally.

3 Our COE provides remote delivery governance, which mitigates the functional, technological and delivery risk for the BankingFXCorporate BankingRisk and P&LFinance and RegulatoryStrategic IPV ReportingOperations and ComplianceEnterprise Analytics Service OperationsBUSINESS INTELLIGENCE1. Scope2. Build3. Deploy4. OperateCOEP rinciples. Best practice, Guidelinesemagine Experience Summary and Case StudiesFX Operations The client's existing QlikView application reporting on FX trades ad performance issues and could not be rolled out across the organisation. emagine re-engineered the data model, delivering timely analytics, including ad-hoc analysis, to deliver personalised data to users. Our Business Intelligence /Analytics methodology breaks the conventions of traditional system emagine30+Years of banking experience24 Countries 135M revenue in 2018>1000 Staff 7041 emagineCorporate BankingLGD Program for a Tier 1 Investment Bank emagine's client needed to deliver the Probability of Default (PD) and Loss Given Default (LGD) information for UK commercial customers to evolve a global solution for all relationship managers.

4 Emagine worked with stakeholders to conceptualise the solution components which integrated internal trade details with client specific financial details and industry-specific indices through data integration, statistical/analytics model and visualisation and P&LStrategic IPV Reporting at a Tier 1 Investment Bank Global Valuations Group (GVG) required a single analytic platform to support daily , mid-month and month-end IPV processes, reviewing IPV results, including scenario testing, architected design and delivering 9 operational analytics applications. The QlikView onshore/offshore team delivered management control on position testing, valuations and provisions, including pricing framework and decommissioned and RegulatoryP&L Analytics (DART) for a Tier 1 Investment Bank The existing P&L reporting solution through Essbase and Cognos technologies lacked fundamental analytics capability for daily and monthly P&L processes.

5 Emagine designed and delivered separate daily and monthly P&L analytics applications using QlikView technology providing executive dashboards and analytics capabilities for senior and ComplianceRFI Monitoring for a Tier 1 Bank emagine was asked to monitor and report on Financial Crime and Compliance, including Regulatory Compliance activities right across the clients' glob-al Business . This included, but not limited to, integrated alerts, cases, STR and RFIs from Universal Case Management BankingBI/DW Program Delivery at a Tier 1 Investment Bank emagine architected a technical solution that delivered an ETL-data warehouse-MDM Reporting programme which integrated sub-ledger, P&L, Risk, HR, external data, and Reference Data on Informatica, oracle warehouse, DRM, Essbase, Cognos/ QlikView.

6 As well as Liferay technologies which delivered an inital release in only four SERVICESCLIENT DELIVERYT ransactionFit for PurposeArchitectureBuildImplementationSo lution ArchitectureCapacity PlanPrioritisationProduct Road MapTechnology upgradeData ScopeData RefreshPADD eployment ChecklistCapacity UsageSupport KTPlatform MonitoringCapacity UsageSLA MonitoringProduct Road MapDesignDiscoverSponsorshipHL Use CaseNFRB udgetData ModelApplication LayerETL ProcessConfigurationDocumenta-tionSystem MonitoringIssue AnalysisEnhancementsSLA MonitoringData ModelApplication LayerETL ProcessConfigurationDocumenta-tionemagin e and the emagine logo are trademarks or registered trademarks of emagine Group in the United Kingdom and in other territories.

7 Other companies, product, and service names are the property of their respective owners. This publication is issued for general guidance only. Copyright emagine Consulting Limited 2016. E&OE. All Rights Reserved. 17040303emagine Consulting Limited, Floor 6, 33 Gracechurch Street, London EC3V 0BT, 041