xBRL US Pacific Rim Workshop

Database and Business Intelligence Workshop

Karen Hsu
Director Product Marketing, Informatica
Extend Data Transformation and Exchange
The Informatica Economy Enabled Through Data

On-demand Enterprise Traditional Partner Trading

(SaaS) Enterprise Enterprise (B2B)

SEPA

xBRL

SWIFT

On-demand Integration Enterprise Data Integration B2B Data Integration

Data Quality Across the Whole Enterprise

2
The Information Platform
To Enable Business Imperatives

Improve
Improve Modernize
Facilitate Customer Outsource Increase
Decisions & Business &
Regulatory Mergers & Service & Non-core Partner network
Reduce IT
Compliance Acquisitions Operational Functions Efficiency
Costs
Efficiency

Informatica On Demand

Develop + Manage

PowerExchange PowerCenter – Metadata Manager

Access Discover Cleanse Integrate Deliver

B2B Exchange Data Explorer Data Quality B2B Exchange

Audit + Monitor + Report

On-demand Integration Enterprise Data Integration B2B Data Integration

Data Quality Across the Whole Enterprise

3
 Vision: Enterprise Wide Transformation
Typical Infrastructure Streamlined Processing
eCommerce Systems Interface Diagram

CUSTOMER EDIFACT REPORTING

SWIFT eCommerce Supported Formats
Paymo de WTX Payment Origination
SLF– • Payment Origination w/Remittance Advi ce
Single • BAFF – Bank of America Flat File (Proprietary)
PEP+ Off-Shore
MT103 Lockbox • UBAFF (International only)
Message MT900 SAG Lockbo x Format: • X12 – 820 Paym ent Order / Remittance Advice
Chicago
Based MT910 Merge • X12 – 835 Health Care Claim Payment / Advice
MT7xx’s Lockbox • EDIFACT – PAYEXT , DIRDEB v96a
SWIFT ACH, Merge
Letter of • SAP IDOC – PAYEXT
MT103 Wire,
Credit • T D-CPA (Canadian ACH Payments)
ACX Lockbox
GMD GMX ACS SEPF – Single Electronic Payment Reporting
(router) Payment Format • X12 – 821 Financial Inform ation (Cks Paid)
NACHA • X12 – 827 Financial Return Notice (US ACH only)
Return Items Multibank • X12 – 828 Debit A uthorization (Cks Issue)
Map to 827 Global • EDIFACT – FINSTA Financial Statement
GF2 Advice (Payments Issued)
GBS US Lockbo x
Data Express
(Aries/6283) BAI (Multiple Sites)
Receipts Origination
Batch • BAI – LBX (1, 2 and ERP)
CRF / • X12 – 820 Paym ent Order / Remittance Advice
PAYORD RapidPay (US LBX, ACH and W ire)
(Home Banking • EDIFACT – DIRDEB
Ca FINSTA & Payment Consolidation) • X12 – 810 (IPP – Invoice Presentment Payment)
Bulk FX lcu CREMUL,
late BAI2 CIE
dA 823 Receipts Reporting
Cli mt Enhanced
en Asia Receipt • X12 – 823 Lockbox (US LBX, ACH, Wire and

TRADE
t Ac & International Receipts)
co Ra System
Enterprise un te s • X12 – 835 Health Care Claim Payment / Advice
Gateway t In
fo • X12 – 827 Financial Return Notice (Check and

PARTNER
ACH Debits)
Receipts BAI2 • EDIFACT – CREMUL (International Receipts)
Multibank

PO
Electronic Payments Translation BAMTRAC • EDIFACT – FINSTA (International Receipts)
File Delivery Translation Distribution
Treasury
Distribution • X12 – 821 Financial Inform ation Reporting (Prior
820 or Fax
X12.820 • Day, Current Day reporting)
Information
IDS • X12 – 822 Account Anal ysis (Formatted by APX
ePayable eCommerce Corporate DDA W eiland 822 Express Software)
DRS Systems • BAI – Information Reporting
• EDIFACT – FINSTA, Enhanced BAI2 (Prior Day,
Current Day Reporting)
SMS Treasury
Trade INFORM
Translation Trade Purchase Order Origination
Translation Corporate • X12 – 850 Purchase Order
DISC ARP Distribution Distribution (Repository) • EDIFACT – DOCAPP (Docum entar y Credit
Application)
• EDIFACT – ORDERS (PO Message)
Standard INFORM- • EDITFACT – AUTHOR (Authorization message
Register Invoice Commercial i n/out)
Data PO Data (Repository) • EDIFACT – DOCAMI (Documentary Credit
Check WINR

PO Order
Amendm ent)
Poorman Non-Financial
Purchase

Payroll
Douglas ECI EDTUP Returns Trade Invoice Reporting
Order
IMPACS • X12 – 810 Invoice (T riggers Payment W hen
Tracking T erms/ Conditions Met)
DPS Sites (DDA, SDA..) • EDIFACT – INVO IC (Invoice message)

Tracking SWIFT
• EDIFACT – DOCINF (Docum entary Credit
Issuance)
Treasury
ERPs Payroll Other Apps Customer • EDIFACT – DEBMUL (multiple debit advice)
Workstatio ns

•100s of formats
•Multiple interaction channels Reduce processing costs
•1000s of combinations of formats, and costs of integrating
protocols, rules between channels data across product lines to
•Lack of data and process standardization target new or existing
•Unable to support growth in volume relationships

4
Accelerate Adoption of xBRL
• Reduce risk
• Leverage existing expertise and infrastructure for lower TCO
• Pre-built transformations to industry standards
• Best-in-class transformation specification environment

• Accelerate xBRL usage from within to outside

• Transform any file to and from xBRL
• Documents (excel, PDF, word)
• Proprietary, COBOL\PL1
• Complex positional and delimited files
• Industry standard interoperability (standard to standard, version to version, e.g SWIFT
MT, MX, BAI)
• Ensure quality of data
• Manage and monitor data coming from sources and going to
destinations

5
Before: Shenzen Stock Exchange
Issuers Stock Exchange Custodian\
Brokers
Flat
Flat file
file

SF Enterprise
T P actions DB
T 564
Flat
Flat file
file M Flat file
Flat file

Fax PDF
Fax

SM
TP
SM
PDF
TP

Business user
time lost in
error analysis
20+ IT
persons Flat
Flat file
file
PDF
full time

6
Shenzen Stock Exchange with Informatica
Issuers Stock Exchange Custodian\
Brokers
B2B Data
Transformation Data Quality

Flat
Flat file
file

Enterprise 564
SF MT
T P
actions DB

Flat
Flat file
file
Flat
Flat file
file

Fax PDF

SMTP

SM
TP Web
Port
al
PDF B2B Data Exchange

Sources Data Feeds

management Monitoring
7
Automatic extraction of Annual Report PDF to
XML canonical format
Semi Annual
report

8
 ref123

KEY BUSINESS IMPERATIVE

Accelerate time-to-market of credit ratings
• Enable customers to respond quickly to market
Large Credit changes
Rating Agency • Replace manual process of copying and pasting
from PDF files to analytics application
• Replace hand coded excel extraction VB
macros

THE CHALLENGE B2B ADVANTAGE RESULTS/BENEFITS

• Need to analyze raw data • Best-of-breed • Eliminated need for 40-80
coming from 10,000 different transformation for people every month to
formats every month unstructured (PDF) and extract data with up front
• 40-80 people required per financial reporting formats investment of 60 days
month to extract the data • Leverage existing • Ability to support any new
from these formats, delaying resources familiar with format or industry
the publishing of securities PowerCenter for end to end standard quickly
ratings data integration

9
B2B Data Exchange
B2B Data Exchange

SWIFT Monitoring

Partner Management Data

Warehouse
Managed File Transfer

il Data Transformation
Ema

PowerCenter

Adapters Quality Identity

External sources Internal Systems

10
Business and IT Collaboration
Step 1: Profile the Data with Informatica Data Explorer

Catalog of Issues
•Completeness
•Conformity
•Consistency
•Accuracy
•Duplicates
•Dependencies
• Cleansing
specifications
• Transformation
specifications
SME Profiles and tags anomalies with Informatica
Data Explorer (IDE)

Developer Reviews anomalies with Informatica Data

Explorer (IDE)

11
Data Quality Dimensions Framework

Completeness What data is missing or unusable?

Conformity What data is stored in a non-standard format?

Consistency What data values give conflicting information?

Accuracy What data is incorrect or out of date?

Duplicates What data records or attributes are repeated?

Integrity What data is missing or not referenced?

12
Business and IT Collaboration
Step 2: Continued. Establish Metrics and Define Targets

SME
Create scorecards (i) for the initial business case and (ii) as the
basis for web based monitoring

Developer Configures and deploys web based data quality reports for
monitoring on an ongoing basis – using Informatica Reporting
or a 3rd party reporting tool

13
Business and IT Collaboration
Step 3: Design and Implement Data Quality Rules
• Standardize values

• Correct missing or
inaccurate data
• Enrich the data

• Identify and
consolidate duplicate
records

SME Assists with design of Data Quality rules in Informatica Data

Quality (IDQ)

Developer Creates Data Quality rules with Informatica Data Quality (IDQ)

14
Exception Management process
Step 4: Manage exceptions and consolidate

Data Exception
Sources Target
Quality Management
Checks

Records that passed

Cleansing DQ rules
and High
Matching Quality
Low Rules Exceptions Data Data
Quality Quality
Data Assistant

Browser based exception review and manual consolidation process

15
 Business and IT Collaboration
Step 5: Monitor Data Quality Versus Targets

• Informatica’s scorecarding
and reporting also support
monitoring of quality over
time
• Companies can utilize
Informatica’s toolset to
perform the monitoring or
utilize 3rd party reporting
tool

SME Monitors the quality of data to determine if objectives are being

met. Uses results to support root cause analysis

Developer Review results to determine if rule enhancement is necessary as

part of the automated data quality process

16
Accelerate Adoption of xBRL
• Reduce risk
• Leverage existing expertise and infrastructure for lower TCO
• Pre-built transformations to industry standards
• Best-in-class transformation specification environment

• Accelerate xBRL usage from within to outside

• Transform any file to and from xBRL
• Documents (excel, PDF, word)
• Proprietary, COBOL\PL1
• Complex positional and delimited files
• Industry standard interoperability (standard to standard, version to version, e.g SWIFT
MT, MX, BAI)
• Ensure quality of data
• Manage and monitor data coming from sources and going to
destinations

17
 Thank you