Master data management (MDM)

Master Data Management is on the short-list for many CIOs, it is worthwhile to consider how MDM projects are spawning in organizations and how an organization can evaluate their potential for success. Recent surveys by some industry analysts recommend what the software mega-vendors such as IBM, SAP, and Oracle have been hyping—that CIOs must look at the MDM effort holistically and embark upon an enterprise-wide MDM initiative. Today, MDM is a seductive vision that is sold primarily to the CIO office. However, the mainstream success of MDM depends on enrolling business as the sponsor—or the master—of such initiatives, because master data is inherently tied to solving business problems. Rather than falling victim to mega-vendor promises, CIOs are now opting for a more prudent approach that enables them to start small with a business-sponsored project to demonstrate the high return on investment (ROI) that can be realized using MDM technology, and then evolve that technology into an enterprise-wide MDM platform over time.

Data Governance in Infancy

The MDM vision being sold to the CIO paints a picture where all information silos within the organization are dissolved and the data is set free to flow among systems in real-time; data that is accurately unified with other data and is transmitted securely and viewed discretely by each business user at their desired frequency and latency. At a loftier level, the IT vision being presented is one that supports a set of universal definitions of all core business data entities—or master data—that are shared across all business processes and systems.


This vision is certainly alluring but also appropriate in order to tear down decades of legacy data silos. However, the first task CIOs face in realizing this vision is addressing data governance issues. Specifically, organizations must determine who defines the customer and standard product description; who knows of the correct relationship between customer and organization; who resolves the conflicts among these data sources, and more importantly, who owns the data? With all these considerations, it is not surprising that settling data governance policies and practices is an enormous, corporate-wide undertaking that has the potential for political strife.
Ironically, the critical assumption underlying the MDM debate today is that IT can manage master data. This implies that IT can anticipate, define, and standardize on a complete MDM technology stack in advance of the negotiated outcome of data governance issues between business and IT. The assumption is flawed and may prove to be fatal for the entire master data management category. Realistically, it could take three to five years at most organizations for the critical data governance issues and organizational priorities to be fully resolved, and for data governance policies and processes to be implemented.

Enter the Business Master

Consequently, it is mandatory for IT to work with business units to identify who the customer is, what the product is, and how products and customers are related—since business owners are the subject matter experts of business entity data. Moreover, if poor data has a negative impact on the business process, it is the business that needs to solve the problem and subsequently, the business that benefits from improvements in master data. This brings to light the new reality—business has to be the master of master data management. After all, who is more suited to answer these and other related questions such as: who is the customer that placed the order; is this employee authorized to approve the order; what product did we promise to ship; and what is the correct shipping location?

Without business enrollment in the MDM initiative, the project is often doomed from the start. Unlike other IT issues related to data management, master data and its management is not merely infrastructure. The business impact of master data is direct and its monetary benefits are measurable with ROI metrics. Given that the language of business is not the language of master data—the challenge lies in translating business issues and benefits into master data issues and MDM solutions.
For the business executive, improvements in master data are all about improving business performance, enhancing customer experience, reducing operational costs, and ensuring regulatory compliance. Consider for example, a Vice President of Sales Operations challenged by lead assignments, commission payments, and order management processes. Using an MDM solution, customer data can be accurately identified with different accounts and products, and based on assignment rules can be synchronized across CRM and ERP systems to reduce operational costs and improve sales productivity. Another example is a senior executive in the Financial Services Wealth Management sector tasked with freeing up Financial Analyst’s time spent on data administration and new account opening processes to focus on advising clients. An MDM solution can address the management of customer profile and account information to allow Financial Analysts to better manage their customer relationships while saving millions of dollars from streamlined account administration processes. Finally, consider a Chief Compliance Officer at a pharmaceutical company who needs to ensure all physician information is accurately tracked in order to comply with pharmaceutical marketing regulations—as the business executive is accountable for compliance, not the CIO’s office.

Start Small and Build on Proven Success

Recognizing and engaging with business units and encouraging them to serve as the sponsor of the MDM initiative has several implications for how the MDM vision may be achieved and the extent of its success. To start with, predicting the entire set of requirements across all critical business processes is no longer necessary. It is more important to select one functional area with high business impact and demonstrable ROI—by allowing the organization to start small with a MDM project that can be realistically deployed within three to nine months. After all, business units will not have the patience or appetite for long-term deployments. Secondly, it is necessary to select a MDM technology platform that easily integrates with existing heterogeneous IT infrastructure in order to reduce the required investments. Finally, an MDM platform should be fully extensible and able to evolve into an enterprise-wide MDM platform that is capable of spanning across multiple MDM projects as they are deployed and integrated across business divisions and geographies.


In summary, while the seductive vision of MDM is currently being sold to the CIO office—it is presented under the flawed assumption that IT can manage master data. For MDM initiatives to succeed, it is critical to enroll business owners as the sponsor—or the true masters of master data. Remember, business units require an immediate ROI on such projects rather than a future vision of an enterprise-wide MDM platform—even when promised by a mega-vendor. A more prudent approach is to start small with a MDM technology that delivers rapid ROI for defined business sponsored projects. More importantly, the MDM platform should be able to evolve along with the emerging consensus on corporate data governance policies without constraining the business. After all, your business success does not reside solely with the efforts of IT professionals, so neither should your master data management efforts

About the Author
Anurag Wadehra is Vice President of Marketing and Product Management at Siperian, Inc., developers of an award-winning platform for adaptive master data management. For further information, contact the author at This e-mail address is being protected from spambots, you need JavaScript enabled to view it or visit the company’s website at http://www.siperian.com

 

Customer Data Integration

While researching, I found an old article that talks about putting a business case for customer data integration and establishing an MDM track. For those who are looking for such answers, this is a good one to read.

Technology expenditures are viewed with a critical, if not jaundiced, eye these days so creating enterprise-wide alignment around the business benefits to be obtained is a critical part of the process. Nowhere is that need more evident than in enterprise software deployments like CDI. One of the most valuable tools for creating that alignment is the ROI analysis.

Creating Internal Alignment

Getting alignment means addressing three separate issues that any proponent of an enterprise technology investment needs to keep in mind:

  1. Creating the support network.

CDI is a "community good"; everyone benefits from having clean and consistent customer data even if they do not directly invest in the project. Even departments who are not touched by the mastered customer data benefit from improved reputation in the marketplace, better customer retention, better branding, and a higher stock price. In such an environment, it can be hard to find an individual executive sponsor. If, for example, each of 10 departments would have a realizable benefit through cost savings or new revenue of $1,000,000 over the first year, then funding a project of $2,000,000 would seem to be a slam dunk with a 500% ROI during year one. But no individual department has a large enough benefit to willingly step up and sponsor the project, so you have three options:

  • Secure a C-level sponsor who can envision the benefits from the enterprise level to drive the initiative (best),
  • Create a Coalition of business owners who will benefit from the initiative (second best), or
  • Drive the Initiative out of the IT Department (generally not an easy or particularly effective thing to do).
Even when a C-level sponsor for the project is secured, having a support network of business owners throughout the organization who understand and believe in the initiative will make implementation much faster and more effective. In practice, creating the coalition of LOB managers is often a prerequisite to getting C-level attention. CEOs, COOs and CFOs don't have much bandwidth for abstract ideas and proposals, however meritorious. If, however, a significant number of their key management personnel are all talking about and demanding a solution to one particular problem - i.e. a single view of the customer - they will listen and respond.

  1. Creating alignment around common goals.

CDI projects are like the three blind men and the elephant: what it looks like depends on where you grab hold of it. CDI projects encompass a wide range of potential benefits, and that's a very positive thing. But when key business owners are describing the project in completely different terms to other executives within your enterprise (like, say, the CFO), this can create a impression of an ill-conceived and poorly planned initiative.

It is important that the group share a vision for the project, the key deliverables and the necessary phasing of the project over time. It is even worth your time to craft an "elevator pitch" that you can use internally to describe the initiative. Creating the shared vision also creates accountability in and between the group members for delivering on key elements of the project. Thus the credit card division understands that if they don't get their documentation of requirements completed by the end of the month, they will delay critical work for mortgage processing.

  1. Building the financial case for CDI investment.

With benefits distributed throughout the organization, the financial returns for enterprise software are difficult to quantify. Without hard numbers to plug into the ROI analysis the project is unlikely to go forward. And today's typical CFO is going to be looking for key participants to "sign up" for revenue improvements or cost reductions from the project. Those participants, however, are not going to bet their careers on fuzzy concepts like "better customer data" or "customer lifecycle management". The analysis has to go one or more levels deeper, and LOB owners need to be involved in the process of defining requirements and quantifying the expected benefits.

The ROI Model

There are as many ROI models as there are projects. These models do, however, tend to share some common characteristics and have some common requirements. Our goal here is to push the ROI away from "art" and more toward "science" by detailing some of those common elements and the methodology for evaluating them.

From a high level, a typical company has a "hurdle rate" for new investment, particularly for enterprise technology investments. In simplistic cases that hurdle rate is usually dependent upon the company's target operating margin plus some cost overrun allocation. If, for example, a company has a 20% margin and is targeting 25%, any project that has an expected ROI higher than 25% moves them closer to the goal, and higher ROIs move them there more quickly. The time horizon is also a factor - if the goal is 25% margins in 2006 and the proposed project will not yield any benefits until 2007, that's a non-starter.

More common is a budget-based ROI hurdle. The typical company, especially in financial services, has a wide range of potential investments that they are considering, all of which meet or exceed margin-based targets. The company, however, has a limited IT budget and therefore needs to establish an internal benchmark rate that is designed to act as a filter ensuring that only the highest ROI projects move forward.

It is important to understand that CDI needs to be evaluated just as any other prospective IT investment. Despite the fact that CDI is an emerging technology and as such is grossly underutilized in corporations worldwide, our purpose is not to justify the CDI decision but to evaluate it. Failure to adopt this impartial approach risks contaminating the results, and CDI is, as we shall see, a strong enough initiative to stand on its own.

It is a good idea to discuss the ROI analysis process with the CFO or his representative at the earliest opportunity. Often the Finance department has sophisticated multi-factor ROI models already in use and is going to want to plug your numbers into that model for evaluation. You can save a lot of time and effort by understanding the model and the required data points at the beginning of the evaluation rather than trying to retrofit and revisit at the end.

ROI Benefits - Creating the List

The first step in any ROI analysis is documenting the expected benefits. This can be a daunting task, because customer data touches so many operations, divisions, applications, and delivery channels. Moreover, there are various ways to classify and organize the benefits.

One common dividing line is between "Business Benefits" and "IT Benefits". The advantage in this approach is three fold:
  • Different parties are clearly responsible - business owners come up with the benefits for their business units, and IT comes up with technology benefits list.
  • IT benefits tend to be more strategic - the IT organization has to deliver on longer term capabilities like more rapid transaction processing and more rapid product introduction, which are harder to quantify. Without attribution of dollars in cost savings or revenue, having IT benefits as a separate list escalates those strategic initiatives in the ROI presentation.
  • Each list plays better for specific audiences - the COO and CFO are likely to focus on the customer-related benefits and upside revenue potential from CDI initiatives, which tend to be on the business benefits list. The CIO and CTO are more likely to focus on the strategic technology advantages behind a CDI project, and the improved ability to execute against internal deliverables.
The disadvantage to the "Business Benefits" and "IT Benefits" division is that it is somewhat artificial. Most if not all IT reasons for undertaking a project are, in the final analysis, business reasons. If, for example, IT wants to do the project because it will reduce the amount of exceptions that need to be managed, the reason for undertaking this is to keep costs down and improve profits, which is a business reason. If they want to do it because it moves them closer to a true service-oriented architecture, the economic benefits are in reduced future integration expense and more rapid deployment of new products which drives revenue, i.e. business reasons. Nevertheless, this approach is common because it is clear, simple and companies understand it, and the benefits listed above outweigh the disadvantages.

A second approach is the "Benefits by Department" approach, in which benefits for each business unit, (and often, each delivery channel and constituency) are documented. Example classifications might be:

Departments
  • Sales
  • Marketing
  • Service - Call Center
  • IT
  • HR - Employees
Channels
  • Customers - web
  • Customers - branch
  • Partners
Finally, the sheer number of metrics which are affected by CDI projects can be daunting as well. At Siebel, data on over 9,000 metrics from more than 100 implementations is compiled and analyzed on an ongoing basis. All of these will obviously not apply to all CDI projects, but a thorough analysis is a significant undertaking in any substantial company. Fortunately, the focus for an ROI analysis is not on an exhaustive analysis of all potential ROI sources, but on identification and estimation of the top 10-20 Key Performance Indicators (KPIs) that will impact your business.

It is always best to start with your own internally-generated list of CDI benefits. It is simply too easy to rely on vendor-supplied materials or industry studies or articles, which tend to be too high level. A typical stated benefit from those sources might be:

"Increase customer retention"

This is much less useful, and much less convincing, than a targeted and customized benefit statement such as:

"Customer attrition rates in 2005 were 7.8% versus an industry average of 5.5%. Our target for 2006 is one percentage point below the industry average, or 4.5%. This would result in an additional 925,000 customers by year end 2006."

Aside from the benefits of creating your own internally generated list of expected CDI benefits, it is important to check that list against other published materials. This can be an eye-opener, particularly when the CDI initiative is driven by a specific departmental or operational requirement (e.g. Gramm-Leach-Bliley Privacy compliance). Likely sources include industry associations, CDI vendors, systems integrators and market analysts.

For example, The CDI Institute (http://www.the-cdi-institute.com/) published a study in July 2005 entitled, "Customer Data Integration as Foundation for Unified Customer Views: Key Industry Scorecards for 2005-06". In this report the key business and IT drivers for current CDI initiatives in various industries are detailed.

In Financial Services, The CDI Institute compiled polling results from 33 institutions to identify the top five business reasons for major financial institutions to undertake a CDI project:
customer data integration, business challenges, cdi, customer data hub, master data


Source: Customer Data Integration as Foundation for Unified Customer Views: Key Industry Scorecards for 2005-06, A CDI Institute MarketPulse(TM) White Paper, July 2005, used by permission.

I have personally validated these results through several "CDI Workshop" engagements with customers, designed to create the vision and ROI analysis for a CDI initiative.
While having an exhaustive list of KPIs for CDI benefits is not an imperative, it is important that all the major requirements from all affected areas of the company are captured.

Time and again we have seen enormous amounts of time and effort wasted by pursuing the wrong goals. Most commonly, this arises when a company is evaluating build vs. buy in their customer data integration solution. Addressing tactical departmental level concerns such as creating a cross-referencing key or integrating a data quality solution leads to initial evaluations that substantially underestimate the effort.

When the issue is escalated to an enterprise level, new issues emerge such as reconciling the various data models in use across the company, or the sophisticated hierarchy and relationship management requirements in the B2B areas of the company. It is not uncommon to see companies start with initial estimates of 1,000 - 2,000 man-days of engineering effort to build a CDI solution, only to see it expand to over 5,000 days once all the major requirements are captured.

Quantifiable vs. Fuzzy KPIs

The central problem in crafting a credible ROI analysis for CDI initiatives is that many of the benefits are difficult to quantify. If a CDI solution enables a company to consolidate customer feedback and service requests, such that they understand customer needs better and are able to more quickly introduce new products that differentiate them in the marketplace, what is that worth? It may be matter of incremental revenue for one company, and a matter of survival for another.

Moreover, many of the benefits are particular to one company, or one department, or one application. Context matters in determining benefit. The benefits from being able to centrally manage exceptions and discrepancies in customer data from one central location (data stewardship) depend directly on the degree to which such exceptions and discrepancies occur. It may be a small matter for one department that uses only one core system for processing, but a mission-critical initiative for another running multiple systems or channels (i.e. administering multiple products, or multiple systems resulting from mergers or acquisitions).

If we examine the universe of potential KPI metrics for CDI, we see data types that range from "precisely quantifiable" to "very hard to determine" and from "objective" where hard data is available either internally or from industry statistics to "subjective" where benchmark data is not readily available. Thus a particular KPI can be precisely quantifiable, and yet be subjective if such calculations have not been done before. Or a KPI can be very hard to determine, and yet be objective if sufficient studies or analysis exist to provide confidence in the anticipated outcomes.

It would be nice to divide these up into quadrants and focus on objective, precisely quantifiable metrics, but in reality these KPIS exist along a continuum which is different for every company. Yet clearly, if data is too subjective or too hard to determine, we cannot classify it as measurable.

If we were to attempt to characterize these KPIs in graphical form, it might look like this:
customer data integration kpi


Figure 2: Hard versus fuzzy KPI data

It is therefore highly useful to look at measurable data first. In many cases, the ROI from KPIs that are measurable is sufficiently high to justify moving forward with the CDI project. In fact, this has been the case in all but two of over two dozen CDI projects I have been involved with. If the expected ROI is high enough from the measurable KPIs, simply complete the ROI analysis with those factors and list the others (unmeasurable and partially measurable metrics) in the explanatory text.

If the anticipated returns from measurable KPIs come up short, then it's time to move on to the "somewhat measurable" category. There will be two sets of likely candidates here -

  • those that are closest to belonging in the measurable category, requiring the least effort to estimate and the most reliable estimates, and
  • those that are most strategic, providing the larger contributions to anticipated returns and which therefore take priority in analytical efforts.

Finally, in the "unmeasurable" category will be several KPIs for CDI returns that are strategically important, and which should not be left out. Your ROI analysis will typically have a page or more of introductory text in which the project purpose is defined, the various approaches analyzed and the reasons for undertaking it listed. This is the place to include strategic objectives that are very difficult to quantify.

From recent CDI Workshop engagements some of these unmeasurable KPIs that we have encountered have included:

  • Branding - appearing as "one bank" to customers regardless of channel
  • Creating a branded service experience across all channels
  • Increased employee satisfaction
  • Reduced cost of adding future operational systems to the IT architecture
  • Reduced average hold time in call center
These types of benefits are real and often substantial, but they are both hard to determine and subjective with regards to the ultimate impact on the bottom line.

As a final note, once the ROI analysis framework is complete, it is worth revisiting the high level strategic documents for your company. Look at the mission and values statements for both the departments and the company as a whole. Reread the chairman's comments in the latest annual report. Couch your ROI proposal in similar language and position it as driving toward those larger corporate objectives. These are the metrics for which the senior management will be accountable to shareholders, and it is language that will resonate in the corner office. Positioning CDI as a feather in their cap in the fight for excellence is a winning proposition.
 

Master Data Management Introduction

In a connected world, collaboration and sharing are key principals. In particular, the faster our networks are and the better our connectivity is, the more your organization will benefit from information sharing and operational collaboration. In turn, as we share more information among our partners, our connectedness is enhanced as well. It is not just systems that work better together, but the people managing those systems forge better working relationships, leading to more effective management of the business and ultimately, to competitive advantage. However, the more we share information, the more we realize that years of distribution of computing power and business applications into vertical lines of business has led to “islands of information coherence.” Data architectures designed to support operational processes within each business application area require their own definitions, dictionaries, structures, etc., all defined from the aspect of that particular business application.

The result is that the enterprise is composed of multiple, sometimes disparate sets of data that re intended to represent the same, or similar, business concepts. Yet, to exploit that information or both operational and analytical processes, an organization must be able to clearly define hose business concepts, identify the different ways that data sets represent those concepts, ntegrate that data, and then make it available across the organization. And this need has ntroduced a significant opportunity for organizational information integration, management and haring. n this white paper, we will discuss how these processes comprise a master data management MDM) program. We will look at questions such as:

• What is master data management?
• What are the characteristics of “master data”?
• What are some architectural approaches to MDM?
• What are the organizational challenges of instituting an MDM program?
• How does data quality figure in?

This paper is the first in a series exploring the basics of master data management, the policies nd procedures employed, and the tools and techniques used for a successful MDM program.

The Origins of Master Data

The introduction of workgroup computing coupled with desktop applications ushered in an era of information management distribution. Administrative control of a business application, along with its required resources, brought a degree of freedom and agility to a business manager. However, by virtue of that distribution, the managers of a line of business could dictate the processes and constraints associated with the development of their own vertical applications to run their own lines-of-business, leading to variance in the ways that business concepts and objects are defined.

Not only that, the increase in both power and functionality at the desktop has engendered an even finer granularity of data distribution, allowing an even greater freedom in describing and modeling business information. And whether it is in the mainframe files, the database server, or in the spreadsheets on your desktop, we start to see a confusing jumble of concepts, along with creative ways of implementing those concepts.

Over the past ten years or so, the pendulum has swung back to centralized computing (such as data warehousing) for applications that help improve the business, with the intention of consolidating the organization’s data into an information asset to be mined for actionable knowledge. And while the centralization of information for analysis and reporting has great promise, this in turn introduces a different challenge. As data sets are integrated and transformed for analysis and reporting, cleansing and corrections applied at the warehouse imply that the analysis and reports may no longer be synchronized with the source data. In essence, this just clarifies the benefit of creating a single source of truth for all enterprise applications – not just for analysis or reporting – and this embodies the concept of master data.

For example, consider your company’s customers. Each customer may participate in a number of business operations: sales, finance, customer service. Some of your customers may even participate in different contexts, perhaps as vendors or suppliers. In each of these contexts, the customer may play a different role, and in turn, the business may value some attributes over others depending on the context. But you clearly want to ensure that your business processes don’t fail because the customer appears multiple times in different data sets. In addition, you want to be confident that the customer’s activities are accurately portrayed in management reports.

Figure 1: Various representations of the same person and company data appear in different application contexts.

In other words, different business applications record transactions or analysis regarding entities and their activities. And it is desirable for all the business applications to agree on what those entities and activities are. We can summarize two objectives:

• Integrate the multiple variations of the same business entities into a single (perhaps virtualized) source of truth.
• Enable enterprise applications to share that same view of the business objects within the enterprise.

Defining Master Data

So far we have used terms such as “business concepts” or “business entities” when referring to master data, but what are the characteristics of master data? Master data objects are those core business objects that are used in the different applications across the organization, along with their associated metadata, attributes, definitions, roles, connections and taxonomies. Master data objects are those “things” that we care about – the things that are logged in our transaction systems, measured and reported on in our reporting systems, and analyzed in our analytical systems. Common examples of master data include:

• Customers
• Suppliers
• Parts
• Products
• Locations
• Contact mechanisms

For example, consider the following transaction: “David Loshin purchased seat 15B on US Airways flight 238 from Baltimore (BWI) to San Francisco (SFO) on July 20, 2006.” Some of the master data elements in this example and their types are shown in Table 1 (below).

Master Data Object

Value

Customer

David Loshin

Product

Seat 15B

Flight

238

Location

BWI

Location

SFO

Table 1: Master data elements.

Master data tends to exist in more than one business area within the organization, so the same customer may show up in the sales system as well as the billing system. Master data tends to be relatively static, and does not change frequently. Master data objects may be classified within a hierarchy

For example, we may have a master data category of “party,” which in turn is comprised of “individuals” or “organizations.” Those parties may also be classified based on their roles, such as “prospect,” “customer,” “supplier,” “vendor,” or “employee.” While we may see a natural hierarchy across one dimension, the taxonomies that are applied to our data instances may actually cross multiple hierarchies. For example, a party may simultaneously be an individual, a customer and an employee.

In turn, the same master data categories and their related taxonomies are used for analysis and reporting. For example, the headers in a monthly sales report may be derived from the master data categories (such as sales by customer by region by time period). Enabling the transactional systems to refer to the same data objects as the subsequent reporting systems ensures that the analysis reports are consistent with the transaction systems.

What is Master Data Management?

As opposed to being a technology or a shrink-wrapped product, master data management (MDM) is comprised of a mixture of business applications, methods and tools. These aspects can implement the policies, procedures and infrastructure that support the capture, integration, and subsequent shared use of accurate, timely, consistent and complete master data.

what is master data management, what is mdm, mdm, mdm governance

Figure 2: Governance drives the actions and quality requirements for a successful MDM deployment.


• Assess the use of core information objects, data value domains and business rules in the range of applications across the enterprise
• Identify core information objects relevant to business success used in different pplication data sets that would benefit from centralization
• Instantiating a standardized model to manage those key information objects in a shared repository
• Managing collected and discovered metadata as an accessible, browsable resource, and using it to facilitate consolidation
• Collect and harmonize unique instances to populate the shared repository
• Integrate the harmonized view of data object instances with existing and newly developed business applications via a service-oriented approach
• Institute the proper data governance policies and procedures at the corporate or organizational level to ensure the continuous maintenance of the master data repository

Numerous technologies have, in the past, been expected to address parts of this problem through customer master tables or industry-specific consolidated product management systems. But these applications have been criticized (perhaps unfairly) as a result of the organizational management approach to their implementation: largely IT-driven, presumed to be usable out of the box, lacking enterprise integration and suffering from limited business acceptance. Resolving the issues pointed out by that criticism is what defines some of these considerations for implementing a successful master data management program:

• Effective technical infrastructure for collaboration
• Organizational preparedness
• “Round-trip” enterprise acceptance and integration
• Measurably high data quality
• Data governance

Architectural Approaches to MDM

Let’s consider an MDM infrastructure. In the best of all possible worlds, we desire a service-oriented environment that can support new applications while allowing for incremental integration with legacy applications. There may be many ways to develop a master data repository. Here, we explore three conceptual architectural approaches to developing this capability, each addressing different organizational needs. It is interesting to note, though, that once the MDM concept is accepted within the organization, it is relatively easy to transition between solution frameworks.

In a Central Master Data System, for each data “domain,” a set of core attributes associated with each master data model is defined and managed within a single master system. The master repository is the source for managing these core master data objects, which are subsequently published out to the application systems. Within each dependent system, application-specific attributes are managed locally, but are linked back to the master instance via a shared global primary key. In this approach, new data instances may be created in each application, but those newly-created records must be synchronized with central system.

architectural approach mdm, mdm architecture, mdm approach

Figure 3: In the central master approach, core attributes are published out to, and synchronized with dependent applications.

In a Mapped Master System, an existing application system is selected to be the master, and other systems become dependent on that system as the main repository. New data instances are created in the master, which are then propagated to other systems. In this approach, different data objects are not necessarily linked by a global primary key, so it may be necessary to define mappings to link objects between systems. When new objects are created, they are distributed out to other applications, and similar to the central master approach, the other applications may not modify core attribute values but may introduce and modify their own application-specific attributes.

mapped master system, mapped master data, mapped mdm

Figure 4: In the mapped master approach, core attributes are created and managed solely in the master, and there must be a process to map objects between different systems.

In a Hub Repository, a single repository is used to manage the core master system, and data is not replicated to other systems. Applications request information from central hub and provide updates to the central hub. Since there is only one copy, all applications are modified to interact directly with the hub.

hub and spoke repository, hub and spoke master data

Figure 5: The MDM hub provides a single source and interacts with applications via a service oriented approach.

There are other alternate approaches as well, yet all the approaches share these characteristics:

• Relevant core master data is managed within a single repository
• Dependent applications rely on publication of master information via a service-based approach
• An investment must be made in integrating data from across the application systems to identify the best sources of high-quality master data as well as that data’s use in dependent applications

Regardless, once the MDM system is in place, the corresponding data quality assurance and data governance framework must be in place to ensure ongoing synchronization.

Organizational Challenges and Master Data Management

A key success factor in creating a master data management program is an early understanding of the transition of responsibilities for data oversight and governance that will impact your organization. Years of distribution of business applications into vertical lines of business have led to discrete islands of information. As a result, the IT and data management structures associated with those lines of business have erected barriers to collaboration.

In addition, the politics of information ownership and management have created artificial fiefdoms overseen by individuals for whom centralization holds no incentive. And lastly, consolidating master data into a single repository transfers the responsibility and accountability for information management from the lines of business to the organization. Because of this, some of the greatest challenges to success are not technical – they are organizational.

It is largely because of these issues that MDM should be considered as a “program” and not as an application. Focusing on these directives will distinguish a successful MDM program from one destined for failure:

Organizational Preparedness: Anticipate that a rapid transition from a loosely-coupled confederation of vertical silos to a more tightly-coupled collaborative framework will ruffle a number of feathers. Assess the kinds of training sessions and individual incentives that must be established in order to create a smooth transition.

Data Governance: As management responsibility and accountability transition to the enterprise team, it is important to define the policies and procedures governing the oversight of master data. By distributing these policies and seeking proactive comments from across the different application teams, you have an opportunity to create the stewardship framework through consensus while preparing the organization for the transition.

Technology Integration: As is often the case, new technologies that are dependent on application packages are like the tail wagging the dog. Recognize the objective to integrate technology to support the process instead of develop process around technology.

Anticipating Change: As with any paradigm shift, proper preparation and organization will subtly introduce change to the way that people think and act. Since the nature of a master data management program is to integrate data for competitive advantage, encourage individuals to begin to explore new ways to exploit master data for improving business productivity.

Download Article

 

Insurance Application Architecture - IBM

Insurance for On Demand Business

As the insurance industry continues to deal with a fast pace of change, insurers face stark new challenges. In today’s marketplace, survival favors the agile; speed can be a critical differentiator; and the organizational status quo is often a liability. Successful insurers are beginning to adapt to continuous, unpredictable and accelerating change. Many insurers still struggle to manage a complex web of legacy silos, disparate systems, redundant functionality, excess capacity and inconsistent service levels. Enthusiasm for IT spending and decentralization has exacerbated the problem, saddling firms with overlapping – and often unproven – technologies. For many insurers, the results are all too familiar: disjointed operations, redundant capabilities, inefficient cost structures and duplication of work across product, geography and business lines.

Most insurers still operate largely within a vertical business structure, whereby distribution occurs mainly by product silo and operations are biased toward internally manufactured or developed products. Achieving material cost reductions in this structure is difficult, and consumers generally see very little or no differentiation among insurers. Given their financial challenges, insurers can no longer afford to have capabilities duplicated across product silos, with each product operating its own processes, systems and specific channels. This duplication causes significantly greater complexity in insurer operations, impacts costs and speed to market, and often increases operational risk.

In large enterprises, initiatives that attempt to optimize these processes in isolation, without first merging them, fail to fully address their complexity and overlapping functions. Process optimization generally focuses on vertical integration and often within single products or business units. To achieve a step change in performance, today’s highly complex insurance operating models must be simplified. Moving from process transformation to enterprise transformation is the key that will
unlock significant benefits for insurers.

Technology is a fundamental change enabler, but IT decisions need to remain firmly rooted in the business needs of the organization. To operate on demand, your organization will need to transform the way it operates by re-evaluating its business processes as well as its technology infrastructure.

Business Transformation
Most insurance firms know they need to change, but question if the analytical tools available to them are up to the task. Traditional, linear approaches, such as business process re-engineering, are useful for optimizing workflows and often yield improved sub-processes, but they do little to highlight similar activities that are scattered across separate processes within the enterprise. Successful insurers require a new way to view their business operations, one that will help them adapt and thrive in an environment of continuous change.

An insurance specific Component Business Model (CBM) helps by simplifying the way insurers look at their operations. With CBM, executives can extract themselves from the process “rut” and get at the real sources of value that drive their companies. They can identify the unique, standalone building blocks that comprise the insurer as a whole. Viewing business activities as autonomously managed components that can be optimized individually for greater value to the whole business enables decision makers to cut through historical boundaries that may have built up along organizational, product, channel, customer, geographical and informational lines.

Application Transformation
The use of component-based business modeling, underpinned by industry models, such as the IBM Insurance Application
Architecture (IAA), enables insurers to define their target business architecture and transformation goals. This drives
application transformation and often the design and implementation of new application solutions. The IAA models, with a rich
set of industry application component definitions, are a key accelerator for the logical design and architecture of building new
functionality.

Download Article

 

Master Data Management - White Paper Contents Copyright(c) SAP

1 EXECUTIVE SUMMARY
For many companies maintaining distributed IT landscapes, common master data is crucial for business success. But managing it can be a challenge. Many companies find them­selves storing the same duplicate master data across a number of different locations and systems. This produces redundancies and inconsistencies that can cost money, disrupt business, and adversely impact the quality of customer service.
Fortunately, SAP® Master Data Management (SAP® MDM) – a building block of the SAP® NetWeaver™ – enables companies to store, augment, and consolidate master data, while ensuring consistent distribution to all applications and systems within the IT landscape. Working across heterogeneous systems at multiple locations, SAP MDM leverages existing IT investments in business-critical data, delivering vastly reduced data mainte­nance costs through effective data management. And by en­suring cross-system data consistency, SAP MDM accelerates the execution of business processes, greatly improves decision making and helps companies maintain competitive advantage.

2 INTRODUCTION
Business processes without consistent master data have little business value-and can even negatively impact a company’s ability to compete. Within the context of large, heterogeneous IT landscapes, misaligned and inconsistent master data leads to costly data redundancies and even misleading analytics that can result in faulty business decisions.

But achieving master data consistency for all systems within a distributed IT environment has traditionally proven difficult. This reason alone explains why branch offices often work in­dependently of the larger enterprise. Mergers and acquisitions, too, present significant problems with regard to consistent master data. While at a technical level, companies can indeed link new software solutions obtained in an acquisition – true integration at the business process level is routinely impeded due to fundamental incongruities between master data models.

Ultimately, master data management (MDM) enables depend­able cross-system, enterprise-wide business processes and ana­lytics – ensuring that everyone involved in the process has access to the same information and knowledge. This is why a solution that enables both the consolidation of master data as well as the availability of consistent data across systems bound­aries offers a decisive competitive advantage.


MDM – A COST SAVINGS EXAMPLE

Take the example of a large retail company, Big Retail, Inc. Over time, Big Retail acquires three other retail establishments and operates them as wholly owned subsidiaries while maintaining their individual brand identities. These are Valuable Products Unlimited, The Quality Goods Company and Affordable Merchandise, Inc.
Running similar businesses, all three companies sell Deliciously Tasty Chocolate Bars. Each year, each of these companies buys approximately $100,000 worth of these chocolate bars from the manufacturer, Worldwide Chocolates. Lacking an integrated order process that links all three shops to the headquarters of Big Retail, each company deals with Worldwide Chocolates independently. In effect, then, Big Retail spends $300,000 annually for Deliciously Tasty Chocolate Bars.
However, because the master data from order processing is not integrated, Big Retail is unable to see this simple fact. Using MDM techniques to connect the order processes, on the other hand, Big Retail is able to see exactly how much annual busi­ness it does with Worldwide Chocolates and is able to negotiate a better deal. While Worldwide Chocolates awards a 5% dis­count on orders of $100,000, it is willing to award a 15% dis­count on the $300,000 order placed by Big Retail. Thus, with each subsidiary dealing with the manufacturer independently, Big Retail saves only $5,000. But when negotiating from infor­mation obtained through properly managed master data, Big Retail saves $45,000 – a significant cost savings that comes right off the bottom line.

SYSTEMS INTEGRATION VS. INFORMATION INTEGRATION

Some companies assume that enterprise-wide systems integra­tion will achieve, in and of itself, the kind of process and infor­mation integration that enables the smooth running of busi­ness on a global scale. This is not the case. To put it more precisely, systems interoperability is a prerequisite for business process integration, but doesn’t achieve the goal alone. Un­fortunately, many companies get bogged down in the details of the systems integration initiative – and never move on to the issues of master data required for full process and information integration. This is understandable. After all, traditional inte­gration initiatives require tremendous amounts of time and resources (coding point-to-point connections at the API level). As discussed later, a more efficient approach would be to employ an enterprise application integration (EAI) approach, using an exchange platform that ensures message handling, semantic mapping, routing and the queuing of data.
Once system interoperability is achieved, master data-at a busi­ness object level – needs to be exchanged and mapped on top of this technical integration layer. This, too, can be challenging. Companies engaged in such an effort will need a solution that can consolidate and harmonize master data – as well as enable consistent data maintenance and meticulous enterprise-wide data object distribution. Without such a solution, companies will continue to make the same mistakes – and continue to pay for them. A few examples:

  • Costly, inefficient customer management: Customers want efficient service. But when customer information is loosely dispersed across a wide range of applications, this is a tough demand to meet. Without consolidating this infor­mation, customer management processes are forced to rely on locally available information – which is often incomplete or even obsolete. This can significantly detract from a com­pany’s business performance – both in terms of cost efficien­cy and customer loyalty.
  • Proliferating parts diversity: For companies involved in the manufacture or assembly of physical goods, the storage, pro­curement and cataloging of parts requires tremendous enter­prise resources. Redundant master data can present a distort­ed picture of parts inventory, causing vexing supply chain gaps. Without efficiently managed master data, companies will continue to generate the kind of redundancies and low data quality that prohibit the smooth execution of collabora­tive logistics processes.
  • Faulty cross-group reporting: As companies manage their bottom lines, inventories must be reduced, prices matched, and procurement processes streamlined. Cross-group report­ing forms the basis for the business decisions that guide these initiatives. But when it is based on inconsistent, ill-managed data, cross-group reporting can lead to the kind of faulty executive decision making that adversely impacts business competitiveness.

A properly implemented MDM solution can solve all these problems – by sharing harmonized master data across system boundaries, fostering enhanced business collaboration, and ensuring cross-system data consistency regardless of the physi­cal location or vendor origin of independent systems within the distributed IT environment.
We now turn to a detailed explanation of concepts central to Master Data Management.

THE MDM CONCEPT

Successful MDM in a heterogeneous IT environment involves more than the integration of systems. Master data must be accounted for and supported in its overall cross-system context throughout each business process.
At the same time, while companies may readily see the business advantages to properly managed master data, they cannot afford the downtime required to implement large enterprise-wide software packages. In addition, in this time of IT budget consciousness – following years of intense IT investment – most companies are in a mood to use what they already have rather than replace existing investment. That’s why any MDM solution must be:

  • Quickly implemented without altering the existing systems landscape
  • Tailored to the company’s business and organizational requirements through flexible business processes and the mapping of organizational structures
  • Introduced on a step-by-step, evolutionary basis that minimizes disruptions to the daily flow of busines

 

Download PDF Article

 

 
<< Start < Prev 1 2 Next > End >>

Page 1 of 2