Informatica mdm multidomain
This presentation is the property of its rightful owner.
Sponsored Links
1 / 68

Informatica MDM - Multidomain PowerPoint PPT Presentation


  • 111 Views
  • Uploaded on
  • Presentation posted in: General

Informatica MDM - Multidomain. Hemang Desai Softpath. Agenda. Introduction MDM Features Reference Data Management Accelerator Competitive Intelligence Enablement Summary. 2011 MDM Magic Quadrant. 2011 Data Integration Magic Quadrant. 2011 Data Quality Magic Quadrant. Leaders.

Download Presentation

Informatica MDM - Multidomain

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Informatica mdm multidomain

Informatica MDM - Multidomain

Hemang Desai

Softpath


Agenda

Agenda

  • Introduction

  • MDM Features

  • Reference Data Management Accelerator

  • Competitive Intelligence

  • Enablement

  • Summary


Proven technology leadership

2011 MDM

Magic Quadrant

2011 Data Integration

Magic Quadrant

2011 Data Quality

Magic Quadrant

Leaders

Leaders

Challengers

Challengers

Visionaries

Visionaries

Niche Players

Niche Players

Source: Gartner Research (October 2011)

Source: Gartner Research (September 2011)

Source: Gartner Research (June 2011)

Proven Technology Leadership

No 2 in DQ

No 1 in Data Integration

No 1 Visionary in MDM

Leaders

Challengers

Ability to Execute

Visionaries

Niche Players

Completeness of Vision


Informatica success story large fashion specialty retail in the us

Informatica Success Story:Large Fashion Specialty Retail in the US

KEY BUSINESS IMPERATIVE

High Impact 1:1 Relationship Marketing.

Channels

Full line Stores

Rack

Web

Credit Card

  • The Challenge

    • Unable to achieve goals because company didn’t have a single view of the customer across multiple channels, nor did they capture key relationships across customers, products, and employees.

360-degree

View of

Customer

Employees

Household

  • Informatica Advantage

    • Informatica MDM system is used to:

      • Gain a consolidated customer and employee golden record.

      • Manage complex many-to-many relationships and hierarchies of parent customer, employees, and products.

Products

Items

Item Classes

End Users

Business Use

  • Results / Benefits

    • Improve customer loyalty, KYC, SAT, Segmentation, Direct marketing, and Promotions.

    • Increase Revenue & Expand market share

    • Reduce IT operations costs

Customer SAT

Cross-sell/

Up-sell

Sales

Marketing

1-1 Marketing


Informatica mdm multidomain

$

International Media GiantEnterprise MDM for Product Lifecycle Management

KEY BUSINESS IMPERATIVE

Enterprise MDM for Product Lifecycle Management.

Product

Lifecycle

  • The Challenge

  • In their current environment, the company lost sight of single and trustworthy source for many of the product attributes, resulting in the creation many manual processes for distributing and sharing information about the product, often using different sources for the same attribute.

  • As a result, the enterprise lacks a single version of the truth for the product.

  • Informatica Advantage

  • The company is using Informatica MDM and Informatica Data Quality to create a single, trusted repository for films and television title information (products) and the delivery of that to the right people, at the right time, and in the right format.

  • Results / Benefits

  • Informatica MDM and Data Quality improved the accuracy and consistency of title information across the different systems.

  • Informatica MDM and Data Quality dramatically improved the data governance of title information.

Theatrical

Release

Pay Per View

Cable

Network

Films and

Television

Series

Back –End Systems/

Applications

Rights

Mgnt

MediaMgnt

MusicMgnt

ERP

Reporting

Business Use

End Users

Digital Media Creation & RegistrationProcess

Sales & Marketing

Editing , Content Developers

ContentPublishing

Informatica Company Confidential – Do Not Distribute


Informatica success story global 50 leading global investment bank

Informatica Success Story:Global 50 Leading Global Investment Bank

KEY BUSINESS IMPERATIVE

Counterparties

Enterprise-wide Multidomain MDM to Enable Straight through Processing.

GlobalCorporations

MediumBusinesses

SmallBusinesses

  • The Challenge

    • Bank faced two key business challenges:

      • Maximizing trade automation (Straight-through processing)

      • Managing credit risk across clients and internal investments

  • Informatica Advantage

  • Bank deployed Counterparty Master MDM system to support Trade Execution and Credit Risk Management.

  • MDM system will keep hundreds of downstream trading systems synchronized with the most accurate legal entity information, ensuring that trades flow automatically without manual intervention.

Public Sector

Private Sector

Business Use

  • Results / Benefits

  • Increased client satisfaction due to quicker trade execution.

  • Risk managers are able to view risk concentrations fromany perspective.

  • $11M savings annually, freeing $300M to be invested elsewhere.

End Users

TradeSettlement

Credit RiskManagement

RiskManagers

Traders


Agenda1

Agenda

  • Introduction

  • MDM Features

  • Reference Data Management Accelerator

  • Competitive Intelligence

  • Enablement

  • Summary


Informatica mdm informatica mdm helps you to

Informatica MDMInformatica MDM helps you to…

Consolidate and rationalize master data from different systems across the enterprise to improve transactional and analytical processes. This reduces errors earlier in the process and increases the accuracy of reporting


Proven enterprise deployments

Proven Enterprise Deployments

“By leveraging a well-thought-out MDM strategy, we have been able to strengthen the customer experience and support our critical compliance efforts.”

— Johnson & Johnson


The information challenge how to streamline and govern data across silos providers

The Information ChallengeHow to streamline and govern data across silos & providers

Merchandising

Analytics

Human

Resources

Price

Management

Customer

Experience

Supply Chain

External

DataProviders

?

Data

Governance

?


Challenge redefined data in siloed systems

Challenge Redefined: Data in Siloed Systems

Others …

CRM

Product Systems

ERP/Finance

Internet/Web

Location

Customer

Product

Product

Supplier

Customer

User Interface

Application Logic

Data


Breaking the silos

Breaking the Silos…

User Interface

Others …

CRM

Product Systems

ERP/Finance

Internet/Web

Application Logic

Service

Oriented

Architecture

Location

Product

Product

Supplier

Customer

Customer

Data

Master

Transaction


Informatica single master data platform

Informatica – Single Master Data Platform

User Interface

Others …

CRM

Product Systems

ERP/Finance

Internet/Web

Application Logic

Single View of Customer

Spend Consolidation

Compliance and Risk Mgmt

Others…

Customer

Location

Product

Supplier

Customer

Data

relationships

Master Data Management


Top business drivers for mdm according to gartner survey

Top business drivers for MDMAccording to Gartner Survey

Internal & Channel Partner use only


Why informatica

Why Informatica?

Horizontally Integrated Out-of-the-Box

  • Only vendor whose platform integrates the 3 key areas, Out of the Box


Informatica mdm multidomain

Why Informatica?

Vertically Integrated Out-of-the-Box

  • A complete MDM product from data model up through UI


Informatica universal mdm

Informatica – Universal MDM

Architectural Styles

Data Domains

4

3

1

2

Consolidation

Registry

Customer

Product

Centralized

Coexistence

Household

Organization

Universal

MDM

Uses

Deployment Modes

Data Integration

Data Quality

On premise

Cloud

Data Services

Data Profiling

Hybrid

Internal & Channel Partner use only


Informatica mdm an integrated solution

Informatica MDM An Integrated Solution

Discover

Relate

Cleanse

Master Data Management

Master

Data

Resolve

Govern

Recognize

Model

Operational

Applications

Applications

Deliver Timely, Trusted, Relevant Master Data

Homegrown Apps

External

CRO’s

Analytical

Deliver

Access

CRO’s

Portal/ Dashboard

Data Marts

Third Party

Data

Business Intelligence

Data

Warehouse


Informatica mdm hub detailed functionality

Informatica MDM Hub - Detailed Functionality

Hub API

Core Capabilities

  • Schedule Group

  • Get Batch Group Status…

Integrate

  • Create Customer

  • Get Sales Transaction…

DataInteraction

Consume

Near Real-time

Batch

Real-time

  • Get Matched Records

  • Set Record State…

Govern

BusinessInteraction

Sync

Federate

  • Authenticate User

  • Register User…

Data Security

Secure

DataGovernance

Workflow

State Mgmt.

  • Add Product Relationship

  • Delete Party Relationship…

Row &ColumnLevel Security

Relate

Authentication

Authorization

Consolidate

  • Merge Records

  • UnMerge Records…

Party& Product

Party

Product

  • Search Party

  • Search Product…

Match

Trust Framework

Link

Merge

  • Get DnB Tree

  • Get Axciom ID…

Enrich

Deterministic& Fuzzy Logic

Internationalization

Data Mastering

  • Cleanse Address

  • Standardize Product Name…

Cleanse

Organization

Demographics

  • Get Party

  • Add Product…

Open Cleanse Architecture

Data Transformation

Standardization

Model

Metadata

Multi-Entity

Configuration

Content

History

Lineage

Match

Survivorship

Validation Rules

Party

Product


Proven and pragmatic approach to mdm

Start small anywhere …

scale in many ways…

in months, not years

Proven and Pragmatic Approach to MDM

Start with MDM Hubs that can scale in many directions…

Transaction

Across different styles

Registry

3 mo

Coexistence

Consolidated

8 mo

To Securities, Assets, Locations…

Client

CounterParty

Asset Management

6 mo

9 mo

Risk & Exposure

Across solutions

Across business divisions, geographies

Processes and Employees


Fortune 50 global wealth management firm increasing revenue with an extended customer view

Fortune 50 Global Wealth Management Firm Increasing Revenue with an Extended Customer View

  • Situation

    • Improve Financial Advisors’ (FA) productivity.

    • Business Problem

    • 70% of FAs’ time spent on back office functions.

    • Root Cause

    • Account-centric instead of customer-centric view.

    • Solution

    • Real-time access to an Extended Customer View withintheir custom-built business application.

    • Benefits

    • Increased FA productivity by 30%, resulting in almost 10% increase in revenue per FA.

    • Cross-sold Jumbo mortgage loans from retail bankingdivision to current customers.

    • Increased sales of banking products from 35,000 to 80,000 among brokerage clients.

Counterparties

Customers

Accounts

Trustee

Organization

Growth

Retirement

Income

Prospects

Individuals

End Users

Fin. AdvisorServices

ContactMgmt.

  • Same DayAcct. Opening

  • Financial Advisors

ComputerTelephony

Profiling


Fortune 500 financial services provider enterprise wide multidomain mdm to support compliance

Fortune 500 Financial Services ProviderEnterprise-wide Multidomain MDM to Support Compliance

  • Situation

    • In 2004, the bank was identified by the Fed. Reserve to implement rigorous standards for capital management as identified by Basel II.

    • Business Problem

    • Unable to uniquely identify counterparties at the legalentity level.

    • Unable to link credit exposures to counterparties and aggregate them based on legal entity hierarchies.

    • Root Cause

    • Counterparties stored in multiple locations.

    • Outsourced the cleansing and maintenance process, but challenges remained:

      • Multiple login to different applications

      • Non integrated workflow

      • Manual reconciliation

    • Solution

    • Informatica MDM uniquely identifies counterparties and legal entity hierarchies.

    • MDM system cross references exposures to each legal entity and provides the ability to summarize these exposures.

    • Benefits

    • Compliance with Basel II requirements.

    • Enables accurate calculation of capital requirements.

    • Better decision making by management due to greaterinsight into businesses and associated capital costs.

Counterparties

Corporations

Cities

Banks

Ltd. Partnerships

Insurance Companies

Broker/Dealer

End Users

Business Use

RiskAnalytics

Capital

Estimation

Credit

Analysis

  • Lines ofBusiness

  • Ent. RiskMgmt.


Informatica mdm multidomain

Fortune 50 Pharmaceutical Services CompanyEnterprise-wide Multidomain MDM for Operational Efficiency

Core Masters

  • Situation

    • Company had four key distinct business processes –corporate account management, contract creation & administration, order to cash, rebates & reconciliation.

    • Business Problem

    • The four business processes were disconnected

      • Health care professionals were not connected to accountsand contracts

      • The accounts were not connected to orders and contracts

    • Unable to determine contract performance and execute rebate payments.

    • Root Cause

    • Company had separate master data for each of the fourkey business processes.

    • The master data lacked data quality and ownership.

    • Solution

    • Company developed five distinct core masters – customer, affiliations, product and product hierarchies, list price, sales alignment.

    • Master data is consumed through various applications including order entry, contracting by 14 operating companies.

    • Benefits

    • Create consistency and standardization across medical devices and pharmaceuticals divisions.

    • Improved customer service efficiency and effectiveness.

    • Ensure SOX validation and compliance.

    • Establish a master data foundation for contract excellence.

Customers

Affiliations

Pricing

Product/Product Hierarchies

Sales Alignment

End Users

Business Use

Contracting

Order Entry

Warehousing/Analytics

Compliance

Order Entry

Contracting

Marketing

Sales

R&D


Informatica mdm business critical the ultimate measure of software

Informatica MDM – Business CriticalThe Ultimate Measure of Software

“Applications and even Trading Systems can have downtime – but the MDM Hub cannot go down…ever”

Uptime

ROI

“Very few systems can measure their ROI in the billions…”

US Intelligence Organization

Accuracy

“If we miss a match, you’re risking people’s lives. It’s that simple…”

“Changing an application is hard - changing MDM requires redoing the entire IT landscape”

Reach


Informatica master data process flow

Informatica Master Data Process Flow

Informatica Trust FrameworkTM

Consumers

(Master Reference or Relationship Data)

Rules-based Configuration Tools

Sources(Reference or Relationship Data)

Consolidation Process

Staging

Queued for Merging

Landing

ETL

f(x)

Data Warehouse

Auto Merge

Manual Merge

ETL

Dynamic Cell-Level Survivorship

Insert/Update

Data Source

Match

Un-Merge

Delta Detection and

Cleansing

f(x)

Queued for Matching

f(x)

Events

Msg Queue

Raw

Reject

Target Data Model

Management

Name

Data Consumer

New

Apply Trust and Validation

Apply Trust and Validation

Address

Product

XML/SOAP

f(x)

Msg Queue/

Services

Insert/Update

f(x)

Metadata

Application

Rules

Content

Hierarchy

Validation

State Mgmt

Workflow

Event Trigger

History

Lineage

X Ref

Trust Score

Audit

Delta Detection and

Cleansing

Application


Multi deployment informatica data controls power your existing applications with mdm

Multi-Deployment: Informatica Data ControlsPower your existing applications with MDM

Informatica data controls deliver and leverage the benefit of MDM to Business Users on any application

CRM, SFA, ERP, Supply Chain and Legacy applications

Capabilities:

Provides Master Data ‘In-Context’ for Business Users

Enhances the capabilities of existing application investments

Examples:

Hierarchy Manager

History Viewer

Duplicate Detection

SFDC Account

IDC Hierarchy Management Control

Internal & Channel Partner use only


Multi deployment wherever whenever however

Multi-DeploymentWherever, Whenever, However…

  • Federated MDM

  • Different instances for various divisions (M&A, Regulatory,…)

  • Support cross-enterprise, cross-instance business processes

  • Interoperability and Consistency

  • MDM in the Cloud

  • Initial Loading

  • Performance Bursting

  • User Acceptance Testing

  • Partner-driven processes/data

  • MDM as a Service

  • For Cloud Applications

  • Shared dataset

  • Shared business process

  • Value added services

Customer

Product

Internal & Channel Partner use only


Why customers select informatica for mdm comprehensive unified open economical mdm

Why Customers Select Informatica for MDMComprehensive, Unified, Open, Economical MDM

Comprehensive

Unified

Open

Economical


Agenda2

Agenda

  • Introduction

  • MDM Features

  • Reference Data Management Accelerator

  • Competitive Intelligence

  • Enablement

  • Summary


Vendor competitive summary

Vendor – Competitive Summary


Informatica mdm multidomain

FS - Reference Data Management

  • Comprehensive data model: ~ 75 entity types, ~ 12 instrument types, ~ 40 relationship types

  • Robust Rules Package - Data Quality, Match, Survivorship

  • Out-of-the-box business user interface

  • Out-of the box analyst interface


Counterparty reference data

Corporations

Corporations

Counterparty Reference Data

KEY BUSINESS IMPERATIVE

Improve Credit Risk Management Analysis and Regulatory Compliance (i.e. Basel, Dodd-Frank Act)

Credit risk

Market risk

Operational risk

  • The Challenge

  • Inconsistent and inaccurate counterparty information in existing risk applications

  • Inaccurate risk rating and analysis = higher capital reserves

  • Non-compliance with Basel requirements

  • Informatica Advantage

  • Ability to access existing counterparty information regardless of source and format

  • Identify and address unforeseen data quality issues

  • Accurately recognize, resolve, and relate counterparties to each other with detailed hierarchies

  • Synchronize with downstream systems and databases

Data Stewards

Cities

Cities

Banks

Banks

Insurance Companies

Insurance Companies

Ltd. Partnerships

Ltd. Partnerships

Broker/Dealer

Broker/Dealer

  • Expected Benefits

    • Consistent and accurate counterparty information to improve credit risk exposure analysis and reporting

    • Achieve Basel and other regulations

Existing Data

Data Integration & Data Quality


Counterparty

Rating

Rating

Rating

Rating

Counterparty

Centralize, manage, and manipulate Counterparty relationships providing a global view of exposure

Exposure

Global Ultimate

Counterparty B

Counterparty A

Position

Position

Subsidiary

Portfolio

Portfolio

Obligor

Issuer

DEF Mutual Funds

-----------

-----------

GHI Bonds

-----------

-----------

JKL Securities

-----------

-----------

MNO Mortgage

-----------

-----------


Managing counterparty reference data with informatica mdm

Corporations

Corporations

Corporations

Corporations

Managing Counterparty Reference Data with Informatica MDM

Existing Counterparty Data in Different Systems

Cities

Cities

Cities

Cities

Banks

Banks

Banks

Banks

Insurance Companies

Insurance Companies

Insurance Companies

Insurance Companies

  • Golden Record

  • Legal Entity Identification

  • Define Relationship Hierarchies

Ltd. Partnerships

Ltd. Partnerships

Ltd. Partnerships

Ltd. Partnerships

Broker/Dealer

Broker/Dealer

Broker/Dealer

Broker/Dealer


Agenda3

Agenda

  • Introduction

  • MDM Features

  • Reference Data Management Accelerator

  • Competitive Intelligence

  • Enablement

  • Summary


Informatica mdm multidomain

Internal & Channel Partner use only


Agenda4

Agenda

  • Introduction

  • MDM Features

  • Reference Data Management Accelerator

  • Competitive Intelligence

  • Enablement

  • Summary


Mdm enablement

MDM - Enablement


Agenda5

Agenda

  • Introduction

  • MDM Features

  • Reference Data Management Accelerator

  • Competitive Intelligence

  • Enablement

  • Summary


Informatica mdm multidomain

Informatica Solution

Business

Users

PowerCenter Real Time

Applications

PowerCenter / PowerExchange

BI

Exceptions

DQ Scorecard

MDM – Data Governance

Data Quality

Legacy

Applications

RDBMS

CEP

Proactive Monitoring

B2B Data Exchange

Structured

MDM

Legacy

XML

Metadata Manager


  • Login