0 © 2008 moneygram. proprietary and confidential. moneygram’s business intelligence...

1

© 2008 MoneyGram. Proprietary and Confidential.

MoneyGram’s Business IntelligenceImplementation for Oracle Applications

TCF OAUGMay 15, 2008

Pat ReddingKathy Follese

MoneyGram International, Inc.

2


MoneyGram International, Inc.

• Leading global payment services company

• 2nd largest global money transfer company

• Over 150,000 global money transfer agent locations

• Over 2000 employees worldwide

• NYSE company: “MGI”

3


Background

• MoneyGram’s current environment consists of a number of legacy operational systems

• Decided to implement Oracle EBS in 2004 to streamline operational systems

• Oracle GL/AP went live in Jan ’07• BI/DW for GL/AP went live in Dec ‘07• Currently in progress

– AR/Settlement– Agent Data Hub– BI/DW

4


More Background

• Many data sources, many projects• Each project with its own reporting solution• Many reporting /analysis tools:

– Discoverer– Native queries– Actuate– Excel/Access– Hyperion/Essbase

• Inconsistent information– Lack of standard definitions and reporting processes

• Lack of BI maturity– Reporting and spreadsheets

5


Challenges for BI/DW

• Immediate need for GL/AP• Near Real Time Reporting (NRT) to keep

operational reporting to a minimum• Transaction volume – ½ million money transfers

=> 2 ½ million trx/day (AR/Settlement)• Short time to implement• Minimally invasive for Oracle apps• Flexible architecture to expand beyond Oracle

applications• Minimize introducing new technology

– Informatica, Cognos

• Proven/Mature BI solution for Oracle Apps

6


Decisions Made

• Jaros – packaged data warehouse solution for Oracle Applications– Uses Informatica– Pre-built Operational Data Store for EBS– Pre-built Data Marts for EBS

• Cognos – BI toolsuite

7


The Big Picture

Oracle Financials(GL – AP)

Near Real-Time Information

(ODS)

Nightly Information(Data Mart)

BusinessUsers

Informatica ETL

Informatica ETL

COGNOS

IDSInformation

ServicesDirectory

MoneyGramEnterpriseWeb-Portal

8


Implementation Plan

GatherGeneral Ledger

andAccounts Payable

Requirements

PrototypeGeneral Ledger

andAccounts Payable

ReportingRequirements

FinalizeGeneral Ledger

andAccounts Payable

Reportsand

Queries

General Ledgerand

Accounts PayableReport and Query

Training

Sept ’07 – Dec ’07 (3 ½ months)

Development Timeline

General Ledger and

Accounts Payable

9


Implementation Plan

Gather Accounts Receivable

And Custom Financial

Settlement TransactionReporting

Requirements

Prototype Accounts Receivable

And Custom Financial

Settlement Transaction

ODS / Data MartAnd

Reports

FinalizeCustom Financial

Settlement Transaction

ODS / Data Mart

Accounts ReceivableAnd

Custom FinancialSettlement

Transaction Report and Query

Training

Sept ’07 – Ongoing

Development Timeline

Accounts Receivable and Custom Settlement Transactions

10


Jaros Architecture: ODS

Country Codes

Order Types

Order Lines

Reference/Lookup Tables

Item

Ora

cle

App

lica

tion

s

Operational Data Store

Customer

Detail Tables Master Tables

• Operational Data• Dimensionalized• Near Real Time

• Extraction• Light Transformation• LoadingAP – 1 hour

Rest Nightly

OM – 2 HrsOrder

HeadersOperating

Unit Sales Rep

Lookups

Functional Groups

11


Jaros Architecture: Data Mart

Contains Fact tables and Dimensiontables.

Many ODS detail tables make one fact table.

Dimension tables are sourced fromMaster tables in ODS.

Reference tables are used in this schemafor lookups such as terms and countrycodes.

Fact

Exclusively Star Schema

StrategicAnalysis

Contains Low Level Detail (user friendly, structured data)

12


Data Mart – Conformed Dimensions

OrdersDetailFact

Customer

Product

Date

OperatingUnit

Sales Rep

Set of Books

OrdersDetailFact

OrdersDetailFact

OrderDetails

13


AP Example

ODS Data Marts

AP Details• Payments• Invoices• Payment Schedules• Distributions• AP Sub-Ledger• Checks

• AP Payment Analysis • Payment Days (Snapshots)• Average Purchases-per-day (future)• Past – Present – Projected (future)• Trends

• AP Invoice Analysis• Invoice Price Variance (IPV) (future)• Vendor Balance

14


Where we were?

• Oracle Standard Reporting• Difficult to format data• Difficult to retrieve data with our

specifications for reporting• Difficult to perform analysis on data

15


Requirements for Business Intelligence/Data Warehouse

• Accurate and Reliable Data from Oracle• Retrieve data per Reporting Request

– Required fields needed on one report

• Easily Format data in Excel, PDF• Professional style of report• Ad hoc query ability• Near Real Time

16


Cognos/Data Warehouse

• Oracle information sent to data warehouse (restructured and reindexed for reporting)

• Option of Near Real Time Data with ODS• Data marts are nightly• Ease of capture all required fields• Ease of creating Excel or PDF formats

17


Cognos Query Studio

• Training is needed for end user• Fields need to be under respective

directory (Cognos namespace) for build• Easy to build a query on particular fields• Sort, Format, Group, UnGroup Queries

18


Cognos Report Studio

• Training needed to build reports• Standard Report can be created• Fewer, more flexible reports• Ease of running reports• Ease of converting to Excel

19


A Sample of Benefits

• Cognos reports allows analysis of AP information giving management ability to see opportunity in analyzing contractual obligations– Identified shipping costs going to South American Corridor

• Ease of On Demand reports for management and auditors. – Easily update date ranges– Easily update Supplier Names

• Savings of time and increase efficiencies to the business

20


Conclusion

• Moneygram goal is ease of business reporting • Gives management opportunity to quickly review

information for decision making purposes• Continue moving Oracle GL/AP and AR to Cognos

reporting and querying

FUTURE• Exploiting BI capabilities of Cognos

– Dashboards– KPI’s– Event Manager/Alerts– Blackberry capabilities

0 © 2008 moneygram. proprietary and confidential. moneygram’s business intelligence...

Documents