The Classic MDM Use Case

Data harmonization is the classic use case for MDM and refers to the process of combining multiple data sources into an integrated, unambiguous entity “golden copy” record that can be used by consuming systems to feed a business process.

360-degree view of customer is one example where the goal is to create a customer record with the combined attributes that support the marketing view, the sales view, the finance view and the executive view. This view will be unique for each one, as opposed to the concept of a “single view” which is forces the same information on every user and consuming system regardless of whether it is relevant.

Data harmonization begins with matching new source records to an existing master record. Unmatched records can be “promoted” to establish a new master record.  Sometimes the biggest challenge is establishing that initial set of master records from a collection of duplicates within the same source. After matching to a master record, harmonization involves applying a set of business rules to establish master record attributes by resolving any conflicting or overlapping values from supporting source systems. For each surviving master record attribute, providing lineage to the supporting source information is absolutely critical.

A lack of harmonized data around customer, location, account, etc. is one of the main drivers for an MDM program. Effective MDM implementations must have the ability to integrate new sources quickly and effectively within a robust architecture that can manage model and data change through automation.

data harmonization sample view

Key Data Harmonization Capabilities & Benefits

Here is a list of features in Magnitude MDM that are not only essential to the harmonization use-case but also play a significant role in other operational master data management use cases.

Sophisticated Multi-Domain Modeling

Magnitude MDM business information models easily support any combination of complex structures across multiple domains – customer/party, product/thing, financial data, location data, etc. Magnitude MDM’s visual modeling capability coupled with a top-down, business-centric approach enables both IT and the business to collaborate in building sensible and effective master data processes. Reuse makes for a quick, efficient and cost-effective path to adding new domains, data sources, objects, attributes, and associations.

Managing Identifiers

Magnitude business information models can manage multiple identifiers for each subject. An identifier can be either primary or alternate, optional or mandatory. Model-driven validation quickly flags any duplicates based any of the available keys. Then, similar to any other business rule validation errors in Magnitude MDM, these duplicates are not rejected as part of the load but rather moved into a working context for subsequent mediation and resolution.

Automation

Magnitude business information models design and build the physical layer through the MDM engine and deliver the right amount of automation, governance, and control over the database objects and corresponding load processes. With a combination of a well-designed and robust business model, component reuse and model-driven automation, adding a new source system can be quick and efficient, rapidly delivering business value.

Robust Matching

Internal and external data sources can vary significantly in terms of grain, unique identifiers, and overall quality. Using a combination of direct and fuzzy matching rules, data stewards can quickly configure, test and deploy matching rules. Matching scores determine whether source records are automatically associated to a target, rejected or sent to an inbox for manual review.

Governance

A robust, customizable MDM workflow provides just the right amount of control over the business process of harmonization. Complete audit history captures what changes were made by whom and at what time. Model-based security controls which users can view, add or update categories or subjects. In addition, data subjects are managed in either working or published context to provide absolute control over which data can be made publicly available.

Time Variance

Any changes to models, subjects, attributes, and associations are captured across time. With this functionality, you can quickly retrieve any subject based on current state or how it existed at any point in time, providing an audit trail for compliance requirements.

Harmonization helps the business leverage disparate bits of information to provide greater perspective on master data subjects such as customer, account, location, etc. Harmonization coupled with an effective business model also provides the supporting context for all related records to broaden that perspective even more.

Other common uses of the Magnitude MDM solution include:

  • Reference Data Management – integrate and harmonize external and internal reference data – such as industry codes, entity identifiers, country codes, units of measure and conversion rates – used to categorize information across systems.
  • Hierarchy Management – visually manage and browse multiple different views of data for different uses across systems, easily handling re-organizations.
  • Central Master Data Authoring – create a centralized master data authoring system to create new records, apply custom business rules and then publish to consuming operational systems.
© Copyright 2017 Magnitude Software, Inc. All rights reserved. Magnitude Software is a registered trademark of Magnitude Software, Inc. in the U.S. and other countries. All other product and company names mentioned herein are used for identification purposes only and may be trademarks/registered trademarks of their respective owners

Chris Ney

Chairman and
Chief Executive Officer

Chris oversees Magnitude Software’s overall corporate vision and strategic direction.

As Chairman and CEO, Chris leads Magnitude Software’s corporate vision and strategic direction, driving the company’s acquisition, integration and growth strategies to extend the company’s global reach. Under his leadership, Magnitude Software has developed an unparalleled customer experience, strengthened its culture of innovation, and greatly increased profitability and shareholder value. In September 2014, Chris successfully secured up to $100 million in capital to further build Magnitude Software through product innovation, organic growth and strategic acquisitions.

Ney was previously Co-Founder and President of Silverback Enterprise Group, where the team completed the strategic acquisition of nine industry-leading enterprise software companies and leveraged their synergies to build two powerful new entities: Magnitude Software and Upland Software. Magnitude Software offers a family of award-winning solutions for enterprise performance management, master data management and data connectivity. Upland Software (Nasdaq: UPLD) went public in late 2014 and is a leading provider of cloud-based enterprise work management software with over 2,000 active enterprise customers and more than 235,000 active users in more than 50 countries.

Prior to co-founding Silverback, Ney was CEO of a series of Trilogy/Versata portfolio software companies. He previously served as Chairman of the Board, CEO and Founder of CoreTrac, a financial services CRM software company. Ney began his career working for investment banking firms Lehman Brothers and UBS.

He holds a Bachelor’s Degree in Economics from Texas A&M University.

LinkedIn

Lou Guercia

Chief Operating Officer

Lou is responsible for Magnitude Software’s global operations.

With more than 30 years of experience launching, operating and growing profitable technology companies, Lou ensures cohesiveness across all Magnitude Software functions, creating and implementing the operational strategy for the company’s growth. Lou is critical to the success of Magnitude’s product strategy and to integrating acquired and existing products, which serves as a growth multiplier.

Lou has held leadership roles at several privately funded companies, four of which led to successful exits. He was CEO of Scribe Software, a data integration solutions company, and WebDialogs, a SaaS-based web conferencing provider acquired by IBM. At IBM, Lou served as Director of Strategy and Operations for Online Collaboration Services within IBM Software Group. He began his career in sales at Xerox.

Lou holds a Bachelor of Arts degree from the University of New Hampshire.

LinkedIn

Kevin Mischnick

Senior Vice President,
Finance and Accounting

Kevin oversees global financial operations for Magnitude Software.

Bringing more than 25 years of financial experience to Magnitude Software, Kevin is responsible for a number of areas of the business, including Finance, Accounting, Legal and Information Technology.

Kevin’s background includes building and transforming financial teams into high-performing units, implementing systems and processes focused on cost savings and efficiency, and raising nearly $100 million in investor capital. He served as Senior Vice President of Finance for Multimedia Games Inc. and Capstar Broadcasting Corporation. Under his financial leadership, the market values of both companies increased more than tenfold.

Kevin is a certified public accountant and holds a Bachelor of Business Administration in Accounting from Texas Tech University.

LinkedIn

Tony Fisher

General Manager of Connectivity

Tony leads Magnitude’s Connectivity business, driving strategy, growth, product and operations as well as leveraging and integrating our Simba-based technologies for new Magnitude solutions.

An accomplished data management and big data marketplace leader, Tony previously served as the SVP, Business Development & Strategy at Zaloni, an award-winning enterprise data lakes management provider; prior to that role, he was Vice President, Data Collaboration & Integration at Progress Software, where he led the business line’s strategic direction and operations.

Prior to Progress, Tony was the CEO of Dataflux Corporation. He also served as Director of data warehouse technology at SAS. A key technology leader at SAS, Tony provided the engineering research and development direction that helped make SAS the market leader in data warehouse software sales.

Tony earned a Degree in Computer Science and Mathematics from Duke University.

LinkedIn

Darren Peirce

Chief Technology Officer and
Vice President of Products

Darren drives Magnitude Software’s technology direction and product delivery.

With responsibility for identifying the nexus of market opportunity, technology innovation and Magnitude’s current and future portfolio, Darren oversees Product Management, Product Delivery and Engineering Services while developing and maturing key partnerships with leading technology companies in support of product strategy.

Previously, Darren served as CTO and Group Vice President of Product Management at Kalido; prior to that role, he was the Lead Solutions Architect and Manager of Professional Services in the United Kingdom. He has also worked in senior consulting positions for companies such as Royal Dutch Shell and British Telecom.

Darren received a degree in Management from Intec College in Cape Town, South Africa, and studied Economics at the University of Stellenbosch.

LinkedIn

Susie Buehler

susie_450

Chief People Officer

Susie leads Magnitude Software’s global human resources strategy and operational execution.

Susie is a seasoned business leader with more than 25 years of human resources management and recruitment experience at technology companies. At Magnitude, she focuses on building business success through people success across all related disciplines, including talent acquisition, development and retention; compensation and benefits; and all people-related aspects of acquisition integration. She has expertise in HR management and operations and in strategic HR business partnership at rapid-growth, start-up and established high-tech companies with significant M&A activity.

During her career, Susie led HR and Recruitment in the U.S. and China as Vice President and Director of Human Resources at Appconomy. As Vice President of Human Resources and Chief People Officer at Moxie Software/nGenera she oversaw international employee growth. She also served as Vice President of Human Resources and Recruiting at Surgient Networks and worked as an independent strategic HR consultant within the technology industry.

Susie holds a Bachelor’s degree from Texas Tech University and a Master’s degree from Rice University.

LinkedIn

Mihir Shah

Executive Vice President,
Corporate Development and Strategy

Mihir is responsible for Magnitude Software’s acquisition and organic strategy.

Mihir has over a decade of experience leading acquisitions and strategy. During this period, he led several public and private company acquisitions, divestitures, and minority and majority equity investments.

Previously, Mihir was M&A Executive for IBM’s Information Management Software division, executing IBM’s inorganic strategy through M&A and strategic partnerships. He also served as Operating Executive for private equity firm, Golden Gate Capital, and as Vice President for Corporate Development at Aspect Software.

Mihir holds an MBA from the University of Chicago Booth School of Business and Master of Science from Worcester Polytechnic Institute.

LinkedIn

Amyn Rajan

General Manager,
Connectivity Solutions

Amyn is responsible for leading and growing Magnitude Software’s connectivity solutions business.

Amyn joins Magnitude Software with more than 25 years of experience, including as CEO of Simba Technologies, acquired by Magnitude in 2016. His responsibilities include working with strategic partners and driving product vision along with delivering revenue growth for the company’s data connectivity solutions.

Under Amyn’s leadership, Simba became a global leader in cross-platform, standards-based data access solutions for relational, multi-dimensional and non-relational data sources whose software is embedded by Amazon, Microsoft, SAP and Teradata. Prior to Simba he was CEO of Orbital Technologies, whose customers included Adobe and Microsoft; he also held the position of Vice President of Engineering at Orbital. Amyn’s background includes experience as a software developer at Microsoft and Adobe.

Amyn holds a Bachelor of Science degree in Computer Science from Simon Fraser University. He was appointed co-chair of the Faculty of Applied Sciences External Advisory Council at Simon Fraser University in 2011, and was named to Business in Vancouver magazine’s “Forty Under 40” in 2007.

LinkedIn

Karen McPhillips

Vice President,
Marketing

The mind that opens to a new idea never returns to its original state

Karen McPhillips drives marketing strategy and operational execution to grow the company profile, revenue and market position.

Leveraging 20+ years of transformational marketing experience, Karen fuels Magnitude’s corporate and existing portfolio marketing, collaborating to maximize the company’s business strategy while also supporting integration of acquired products and services.

Karen has served on leadership teams of public and private companies of all sizes, transforming marketing functions and generating both tangible and intangible value. Most recently at PlumChoice, she and her team repositioned the brand and metamorphosed the marketing function in support of the company’s pivot from IT support provider to leader in the cloud services and Internet of Things spaces. At Iron Mountain and its technology arm, Iron Mountain Digital, she created new marketing functions, introduced the marketing operations discipline, and spearheaded a closed-loop leads-to-revenue framework coupled with a brand-to-demand communication platform that raised the bar on marketing’s revenue influence. Prior to Iron Mountain, Karen held marketing leadership roles with SaaS back-up leader, Connected Corporation (acquired by Iron Mountain), and SilverStream Software, contributing to the company’s IPO and acquisition by Novell.

Karen earned a Bachelor’s degree in Journalism from St. Michael’s College in Vermont.