A Case for Enterprise Data Management in Banking

A lot of right this moment’s challenges for banking establishments may be addressed by a structured enterprise knowledge administration initiative

2 Contents 1 Introduction 3

2 A Altering Panorama 4 2.1 Regulatory Imperatives 4 2.2 Trade Tendencies 5 2.3 Knowledge Administration, Evaluation and Reporting 6 3 EDM Capabilities and Technique 8 3.1 EDM Parts and Capabilities 8 3.2 EDM Technique 10 3.3 Architectural Issues 11 3.4 Finish-to-end Knowledge High quality Assurance 11 3.5 EDM Governance and Management 13 4 Advantages of an EDM Program 14 5 Conclusion 15 A Case for Enterprise Knowledge Administration in Banking 3 the way in which we see it Knowledge administration has been pushed to the forefront right this moment by the multi-pronged squeeze of compliance, threat administration, working efficiencies, efficient shopper relationships and advertising and marketing.

A Case for Enterprise Data Management in Banking
A Case for Enterprise Data Management in Banking

All of those features depend on the accuracy of information for efficient resolution making. A number of enterprise teams like threat, operations, buying and selling and compliance view the identical data otherwise. This will result in materials disputes about knowledge high quality, definitions, data storage, and management. An enterprise knowledge administration (EDM) program brings all of those knowledge associated features below one umbrella, holding duty to determine requirements of conformity, integrity and reliability thereby growing effectivity and throughput.

To achieve success, an EDM crew requires a deep understanding of the drivers for an EDM technique, the constructing blocks of an efficient EDM implementation and numerous design issues. This white paper supplies an summary of EDM capabilities and methods. It additionally touches on architectural issues and implementation features of an EDM program. Lastly, it summarizes the advantages accrued by an EDM implementation. 1 Introduction 4 Because of the monetary disaster, the banking trade has seen main adjustments in regulatory necessities and trade requirements, which impose extra calls for on knowledge administration, evaluation and reporting methods.

2.1. Regulatory Imperatives The 2007 monetary disaster has put a highlight on banks who’ve been below fireplace for offering excessively dangerous loans. These loans together with weak laws have been the perpetrators of the monetary disaster. Since then, there was a paradigm shift in the direction of transparency as buyers and regulators require extra data to be launched publicly. This has resulted in an elevated sense of urgency to adjust to numerous laws with a view to keep the boldness of assorted stakeholder teams.

Lending The subprime disaster and subsequent financial institution failures have clearly demonstrated how dangerous loans can cripple worldwide monetary markets. The disaster served a wake-up name to banks, prompting them to display screen debtors extra fastidiously. This led to sharp decline within the loans to company debtors. Research reveal that new lending in 2008 was far under new lending in 2007, even earlier than the height of economic disaster from August to October 2008.1 Publish-crisis, banking establishments are topic to growing compliance and reporting necessities. Numerous loans sanctioned by banks are scrutinized to make sure that they adjust to statutory necessities.

Managing compliance has subsequently develop into a difficult job, particularly for companies with world attain since laws are sometimes country-specific. Danger reporting, capital and liquidity A bunch of latest laws have surfaced to handle most of the flaws with respect to threat administration and capital adequacy that grew to become seen in the course of the monetary disaster. Worldwide Monetary Reporting Requirements 8 (IFRS 8) and Basel III deliver new compliance calls for that can influence the enterprise fashions of banking establishments. IFRS 8 lays down disclosure necessities with respect to monetary statements. Basel III will impose extra capital constraints on banks and different monetary service suppliers.

Basel III focuses on capital and funding by specifying new capital goal ratios and setting out requirements for brief time period funding. These laws are anticipated to have a considerable influence on the banking trade. The underlying ideology behind these laws is to extend liquidity whereas concurrently making the worldwide banking system extra protected and safe. The banking trade faces stiff challenges to merely to realize the technical compliance with the laws. Silo applied sciences add one other layer of complexity when assembling correct, holistic threat studies to fulfill laws.

2 A Altering Panorama 1 Financial institution Lending Throughout the Monetary Disaster of 2008, White Paper, Victoria Ivashina and David Scharfstein, Nov 2008, [online] accessible from http://www.folks.hbs.edu/dscharfstein/Lending_During_the_Crisis.pdf Rules and trade traits are imposing extra calls for on knowledge administration methods. A Case for Enterprise Knowledge Administration in Banking 5 the way in which we see it Transparency and accountability Publish-crisis, new laws have been created to implement transparency and accountability within the monetary system whereas implementing guidelines for shopper safety.

The Dodd-Frank Wall Road Reform and Shopper Safety Act is a major and large step on this course. This act touches all features of economic system. It goals to create an advance warning system to finish bailouts for ‘too massive to fail’ establishments and in addition recommends a powerful shopper monetary safety watchdog. These laws additionally mandate enhanced regulatory reporting capabilities. So as to adjust to such sweeping regulatory adjustments, expertise should play a significant position. 2.2. Trade Tendencies The continuing world monetary disaster, with its historic dimensions, may have an enduring influence on the worldwide banking trade and the world financial system. Banks are searching for development opportunities2 , however their success could be very a lot dependant on their means to construct vital mass and profitable operations in these financial instances.

The regulatory panorama has strengthened considerably, with governments in lots of markets implementing way more stringent guidelines—comparable to minimal capital necessities—placing stress on companies to boost capital. This monetary stress has elevated concentrate on operational efficiencies and is driving investments in automating credit score underwriting platforms with scorecards and fashions, fraud and assortment analytics, and enhancing knowledge and threat analytics capabilities. Some banks are progressing from utilizing qualitative or analytical fashions to the deployment of predictive fashions for threat and buyer analytics.

Amid the elevated necessities on capital adequacy and optimum utilization of capital, financial capital administration and threat adjusted return on capital (RAROC) have develop into a prime precedence for banks. Loss forecasting and stress testing have gained elevated significance within the present financial state of affairs and are the norm right this moment. Basel III—which is at the moment being debated by regulators and establishments— would require banks to carry extra capital of particular varieties.

It introduces a minimal leverage ratio and capital necessities towards liquidity threat. It additionally contains necessary capital buffers for capital conservation and a discretionary countercyclical buffer, which permits nationwide regulators to require extra capital during times of excessive credit score development. 2 Bruised however not damaged: The World banking development agenda, KPMG Report, 2011, [online] accessible from: http://www.kpmg.com/Ca/en/IssuesAndInsights/ArticlesPublications/Paperwork/bruised-not-broken-banking-survey.pdf 6 Different essential traits within the world banking trade are: ■ Enterprise intelligence practices are being built-in with buyer relation administration (CRM) and there’s a stronger concentrate on predictive and behavioral modeling instruments.

This mixture is quick changing into the central cog for cross promoting, buyer lifetime worth administration, threat administration and restoration administration. ■ Banks have began to appreciate the potential of social media analytics and content material monitoring and are aligning their CRM instruments with Twitter and Fb. ■ With the expansion of fraudsters and hackers, safety threats for all companies however particularly banks have mushroomed.

Among the many massive drivers of funds safety are new encryption initiatives and efforts to deliver interoperability to point-to-point transaction encryption.3 ■ With the emergence of cell banking, banks should restructure their enterprise mannequin and enhance collaboration with companies in playing cards, funds and telecom domains. ■ Banks will likely be ramping up their private finance administration (PFMs) choices to assist clients notice their monetary objectives and to keep away from disintermediation.

2.3. Knowledge Administration, Evaluation and Reporting Rising from the Nice Recession, banks are confronted with the overwhelming job of successfully operating their and in addition assembly the necessities of current and future laws.

Particularly, a few of their essential enterprise knowledge administration wants are: Regulatory compliance and threat administration Regulatory compliance and threat administration calls for typically result in massive IT outlay. These necessities embrace complying with the necessities of Dodd Frank Act, BASEL II/III, Sarbanes-Oxley Act, IFRS, Equal Credit score Alternative Act, Durbin Modification, RESPA and assembly the opposite threat and compliance associated wants of the group. Regulation will drive up the price of enterprise for a lot of massive monetary establishments.4 3 11 Financial institution

IT Tendencies for 2011, Article, 2011, [online] accessible from: http://www.americanbanker.com/btn/24_1/11-trendsfor-2011-1030508-1.html 4 Progress options in a altering world: World Trade Outlook, Deloitte Report, [online] accessible from: http://www.deloitte.com/belongings/Dcom-Albania/Localpercent20Assets/Paperwork/al_fsi_banking_260606.pdf A Case for Enterprise Knowledge Administration in Banking 7 the way in which we see it Buyer relationship administration CRM initiatives drive to successfully handle buyer interactions, and within the course of enhance buyer retention, buyer loyalty and income per buyer. Associated to those CRM initiatives is the constructing of information marts and knowledge warehouses and reaching the “single buyer view” to higher make the most of buyer data. Banks are shifting from a product-centric method to a client-centric method with a 360-degree understanding of their shoppers to higher handle and keep shopper relationships.

Profitability and efficiency administration Efficiency administration is now seen as a mechanism spanning throughout finance, operations, IT and the shopper, and the main focus is on constructing and enhancing a number of helpful metrics and efficiency gauges. This data is then used for higher evaluation of enterprise efficiency and effectivity within the system and for utilizing efficiency metrics to incentives and compensation. Given these necessities, the primary problem banks face are figuring out and evaluating their present processes and knowledge flows in a posh community of disparate legacy methods. 8 Enterprise Knowledge administration is the event, execution and supervision of plans, insurance policies, applications and practices that management, defend, ship and improve the worth of enterprise knowledge and knowledge belongings. 5 http://en.wikipedia.org/wiki/Data_management

3 EDM Capabilities and Technique Given the trade traits and IT challenges highlighted within the earlier part, one of many prime issues for banking establishments is to overview their knowledge administration capabilities, establish deficiencies and formulate a roadmap to handle the gaps. In line with the Knowledge Administration Affiliation (DAMA): “Knowledge administration is the event, execution and supervision of plans, insurance policies, applications and practices that management, defend, ship and improve the worth of information and knowledge belongings.”5 This definition utilized to enterprise huge knowledge is Enterprise Knowledge Administration (EDM). 3.1.

EDM Parts and Capabilities A complete EDM program includes of a number of capabilities. So as to allow these capabilities, there are a number of parts that first must be in place. The pre-requisite parts and key capabilities are listed under. Pre-requisite parts ■ Knowledge Administration Imaginative and prescient – a company wants to explain the imaginative and prescient and rules or core values round which its enterprise knowledge administration program is predicated. ■ Knowledge Administration Targets – objectives of an EDM program must be associated to strategic enterprise objectives, aims and priorities.

These, moreover, must be adopted by and communicated to key stakeholders. ■ Governance Mannequin – An EDM program must undertake an enterprise-wide mechanism by which this system is managed, funded and carried out. ■ Points Administration and Decision – the group has the power to establish, triage, observe, and replace standing for all knowledge and integration points recognized throughout “enterprise as traditional” (BAU) actions or ongoing knowledge administration initiatives. ■ Monitoring and Management – Collective capabilities for measuring and reporting on the standard and effectiveness of the info administration program because it operates as a part of the BAU surroundings.

A Case for Enterprise Knowledge Administration in Banking 9 the way in which we see it EDM capabilities ■ Essential Knowledge Stock – Essential Knowledge consists of these knowledge components (and their enterprise definitions) that the enterprise deems as essential for resolution making and compliance. This stock ought to be made in session with enterprise customers.

The Essential Knowledge Stock helps prioritize or comprise the scope of an EDM program. ■ Knowledge Integration – This covers the processes and instruments for acquisition, composition and enrichment of information from totally different sources right into a single unified retailer or view.

Knowledge integration usually is completed by constructing an enterprise knowledge warehouse, from which knowledge is sourced instantly into analytical engines, or into knowledge marts that feed the analytical engines. Knowledge integration additionally addresses the management processes which might be used to observe knowledge integrity as knowledge flows from knowledge producers to knowledge customers. ■ Knowledge Profiling – Knowledge profiling is the examination of information to gather statistics and traits concerning the construction of obtainable knowledge.

It’s used to help in vital knowledge evaluation, knowledge classification, knowledge integration and influence evaluation. ■ Knowledge High quality – Knowledge high quality measures whether or not knowledge is ‘match for supposed use’. Knowledge high quality is often measured alongside the size of accuracy, completeness, conformity, consistency, duplication and integrity, with every dimension carrying totally different weight based mostly on the supposed use of the info. Finish-to-end knowledge high quality permits for comparability of information high quality throughout the info circulation at a cut-off date in addition to throughout time (traits). ■ Metadata Administration – Metadata is details about the info itself. Metadata captures attributes of information like the sort, size, timestamp, supply, proprietor and so on., in addition to relationships in knowledge (semantics), and helps with knowledge traceability and lineage.

Use of uniform strategies and instruments for outlining, amassing, and managing data metadata ensures that knowledge is recognized persistently throughout the enterprise. ■ Grasp Knowledge Administration – Grasp knowledge or Grasp file is the one, authoritative and agreed upon supply of information that’s vital for enterprise operation. It usually contains persistent non-transactional knowledge like buyer, product, worker and so on. Grasp knowledge administration ensures that there’s a single constant model of vital knowledge used throughout the enterprise. ■ Reference Knowledge Administration – Reference knowledge is used to categorise or categorize knowledge. An instance is the product grasp which accommodates the checklist of all merchandise together with their attributes. As with metadata and grasp knowledge, reference knowledge administration additionally performs an essential position in knowledge integrity and consistency. ■ Knowledge Privateness (Anonymization) – This contains processes, algorithms and expertise platforms that are required to make sure that the

Contents of any data object (knowledge set) absolutely adjust to data privateness and safety legal guidelines and laws. 10 3.2.EDM Technique A top-down strategic method to EDM aligns enterprise priorities to particular EDM parts and capabilities. The method also needs to consider present state of every related functionality towards the specified future state.

An evaluation based mostly on a knowledge administration maturity mannequin is an effective place to begin for an EDM technique and roadmap definition initiative. An information administration maturity mannequin assesses the above-mentioned capabilities with respect to the readiness of the agency from a folks, insurance policies, expertise and adoption perspective. This helps the agency establish gaps and prioritize initiatives alongside a nicely designed road-map to realize the long run state. A top-down strategic method to EDM aligns enterprise priorities to particular EDM parts and capabilities.

Assume Domestically, Act Domestically Few outlined guidelines & insurance policies about knowledge high quality and knowledge integration. Similar knowledge might exist in a number of functions, and redundant knowledge is commonly discovered in numerous sources and information. Knowledge possession and software possession are synonymous. Assume Globally, Act Collectively Firm understands {that a} extra unified view is important if it needs to derive any actual worth from its knowledge. It wants to increase the attain of the info through checks and balances in order that it’s clearly managed as a worldwide asset. Assume Globally, Act Domestically Organizations attempt to reconcile the results of inconsistent, inaccurate or unreliable knowledge as dangerous information are recognized. The beneficial properties are sometimes seen on a division or division stage, however firm is beginning to set up some finest practices for knowledge governance. Assume Globally, Act Globally Knowledge is unified throughout knowledge sources in line with enterprise guidelines established by enterprise knowledge governance processes.

A significant cultural shift has occurred. As an alternative of treating points of information high quality and knowledge integration as a collection of tactical tasks, firm has a program for managing business-critical knowledge. Governance is Enterprise As Ordinary Knowledge governance is second nature. ROI for data-related tasks is tracked persistently. Innovation is inspired. Enterprise worth of information is acknowledged. Prices are lowered as processes develop into extra automated and streamlined. HIGHReward Folks, Insurance policies,

Expertise Adoption INITIAL REACTIVE DEFINED MANAGED OPTIMIZED Danger LOW LOW Exhibit 1: Knowledge Administration Maturity Mannequin A Case for Enterprise Knowledge Administration in Banking 11 the way in which we see it A layered structure permits for implementing expertise capabilities as shared providers. 3.3.Architectural Issues Whereas making a roadmap for creating or enhancing EDM capabilities, there may be typically an inclination to construct in end-to-end performance in every system in a siloed trend. Such tactical approaches usually result in even greater challenges by way of inconsistent, duplicated and typically unreliable knowledge, processes, studies and selections. To keep away from this subject, Capgemini recommends a layered method the place every horizontal perform or functionality (expertise) is managed individually as a shared service throughout the vertical perform or functionality (enterprise).

Exhibit 2: Layered Structure & Shared Providers Method Portfolio Administration Fund Operations Gross sales & Advertising Danger & Compliance Finance & Accounting Audit & Authorized Data Administration Basis Utility Administration Analytics & Modeling Reporting & Dashboards 3.4.Finish-to-end Knowledge High quality Assurance Whereas designing a knowledge high quality program, most banks focus solely on knowledge in a warehouse. This method is flawed as a result of it doesn’t establish all sources or causes of poor high quality knowledge, and extra importantly it doesn’t affirm that knowledge in the end used for evaluation and reporting is of excellent high quality. 12 On this method, knowledge high quality is measured at a number of contact factors as knowledge flows by way of the enterprise course of. Metrics from every measurement is saved in a centralized knowledge high quality mart, which feeds right into a centralized knowledge high quality dashboard. Particular answer issues and necessities are outlined within the desk under.

Exhibit 3:

Knowledge High quality and Enterprise Processes The advisable method to make sure end-to-end knowledge high quality is to design a program that considers all the knowledge from supply methods to closing studies, as proven under. DQ Mart DQ Dashboard Pipeline & Deal Administration Mortgage Docs & Knowledge Entry Origination / Servicing Programs Staging Space Enterprise Knowledge Warehouse Knowledge Marts & Purposes Enterprise Reviews Guide Guide Automated Automated Automated Automated Guide DQ Measurement Course of Expertise priorities ought to be pushed by enterprise priorities, and supported by a powerful governance and management mannequin. Issues Necessities Integration of outcomes from numerous knowledge high quality processed (guide and automatic) into Knowledge High quality Mart Guidelines must be aggregated and aligned to knowledge high quality dimensions.

Scorecards and weights additionally must be designed Integration of outcomes from feeds (Excel, SAS, IDQ) Knowledge High quality Mart ought to accommodate guide and automatic feeds Traceability and aggregation of outcomes Knowledge High quality Mart design ought to accommodate traceability of components by sources Government stage dashboard with drill down capabilities The dashboard and reporting instrument design ought to be in sync with the drill down ranges and hierarchies Exhibit 4: Finish-to-end Knowledge High quality Answer A Case for Enterprise Knowledge Administration in Banking 13 the way in which we see it 3.5.

EDM Governance and Management Within the layered structure and end-to-end knowledge high quality program design, it may be seen that enterprise features, processes and capabilities are supported by the expertise features and capabilities as shared providers. On this method, the enterprise priorities are the first determinants of expertise focus areas; and it’s essential that the EDM initiative is launched as a joint effort between enterprise and expertise teams. These views must be supplemented by a powerful governance and management mannequin whereby the administration units the insurance policies and tips, and supplies the controls and funding to make sure efficient implementation and operations of EDM capabilities.

It’s the governance and management mannequin that gives the organizational structure, and defines the roles and duties (folks and processes) required to operationalize the EDM technique. Exhibit 5: EDM Governance and Management Enterprise Knowledge Enterprise Perspective Expertise Perspective Governance Management Enterprise Data Logical Data (e.g. BDW) Enterprise Course of Bodily Knowledge 14 4 Advantages of an EDM Program The advantages of an EDM program to banking establishments are finest analysed from the lenses of the enterprise capabilities that it helps and allows. Every enterprise perform probably has its personal distinctive wants round knowledge and therefore the advantages correspond to these distinctive views.

A couple of illustrative advantages are talked about under. ■ For operations, a centralized reference knowledge administration system will supply nice benefits in offering correct, well timed and constant knowledge throughout methods. This can end in an enormous discount in reconciliation actions and can enhance the effectivity and effectiveness of assorted groups. ■ For threat administration, EDM presents amongst different issues the power to accurately establish counterparty threat. Correct measurement and administration of enterprise huge threat measurement and administration can be nearly unattainable with out correct, dependable and constant knowledge supplied by an efficient EDM. ■ Advantages to finance and accounting from EDM are apparent contemplating the efficiency evaluation and administration studies they produce which might be considered by exterior stakeholders (regulatory and market) and inner customers (board, senior administration and resolution makers).

EDM can permit these studies to be licensed with a better diploma of confidence. ■ Knowledge integrity and consistency, which permit for better confidence within the administration studies and selections, are of nice significance from an audit, authorized and compliance perspective as nicely. ■ Gross sales and advertising and marketing operations are immensely benefited from an EDM by way of the power to have a single view of buyer that permits efficient cross-selling and up-selling.

A Case for Enterprise Knowledge Administration in Banking 15 the way in which we see it 5 Conclusion EDM has develop into extra essential than ever earlier than. A financial institution or monetary establishment embarking on an initiative to launch or revitalize its EDM program wants to bear in mind the next essential features:

■ An environment friendly EDM program ought to be designed to be in tune with the group’s personal particular and distinctive enterprise wants. ■ It’s essential to design a program that brings collectively stakeholders from each enterprise and expertise sides. ■ Expertise options ought to be considered as enablers of enterprise capabilities and ought to be pushed by enterprise wants. ■ To develop, maintain and mature an EDM program, a complete framework together with governance and management components is required. ■ It is very important keep a stability between strategic long-term aims and tactical fast wins. ■ A profitable EDM program is one which builds sturdy foundations, and on the identical time permits for steady evolution as enterprise grows or transforms. Copyright © 2012 Capgemini. All rights reserved.

About Capgemini and the Collaborative Enterprise Expertise Capgemini, one of many world’s foremost suppliers of consulting, expertise and outsourcing providers, allows its shoppers to remodel and carry out by way of applied sciences. Capgemini supplies its shoppers with insights and capabilities that increase their freedom to realize superior outcomes by way of a singular method of working, the Collaborative Enterprise Expertise™. The Group depends on its world supply mannequin referred to as Rightshore®, which goals to get the suitable stability of the perfect expertise from a number of places, working as one crew to create and ship the optimum answer for shoppers.

Current in 40 international locations, Capgemini reported 2010 world revenues of EUR 8.7 billion and employs round 112,000 folks worldwide. Capgemini’s World Monetary Providers Enterprise Unit brings deep trade expertise, progressive service choices and subsequent era world supply to serve the monetary providers trade. With a community of 21,000 professionals serving over 900 shoppers worldwide, Capgemini collaborates with main banks, insurers and capital market firms to ship enterprise and IT options and thought management which create tangible worth. For extra data please go to www.capgemini.com/financialservices