Newmont Data Cleansing Project Overview ECCMA International Cataloging Conference

1
Newmont Data Cleansing Project OverviewECCMA
International Cataloging Conference

• October 26, 2006

2
Newmont Data Standardization Overview

• Agenda
• Company project overview
• Project approach
• Lessons learned
• Results going forward

3
Company Overview

• 2005 Revenues
• 4.4 billion
• 2005 Equity Production
• 6.4 mm Ozs
• 2005 Equity Reserves
• 93.2 Ozs mm

4
Business Drivers for Standardization
5
Goal and Guiding Principles

• All sites will catalogue the same items in the
  same fashion, including names, descriptions and
  associated classification links (catalog and
  associated data).
• Guiding Principles
• Adopt an open standard (eOTD)
• Based on NATO Schema familiarity and system
  base
• Linked to UNSPSC for global spend analysis
• Design a system and process to lower the pain
  across the sites
• Level of effort resources
• Cost
• Catalog the right items
• Remove duplicates and obsolete (archive)
• Integrate eProcurement program to move items to
  Suppliers catalogs

6
Project Approach
210,000 Items Globally - One Year to Cleanse
7
Implement Catalog Cleansing States
All levels may be simultaneous at sites and
globally
8
Implement Global Team Structure
Denver
Nevada
Total Team 1 Program Manager 1 Project
Manager 4.5 Catalog Mgrs .5 Dictionary Owner 7
Catalogers 1 3rd Party/Vendor Additional
outsourced cleansing
1 Program Mgr 1 Project Mgr Ensure the
project is going smoothly, resolve issues, find
resources
.5 Catalog Mgr .5 Dictionary Owner Clean NEV
Items, ensure dictionary grows correctly
Peru
Ghana
Indonesia
1 Catalog Mgr 2 Catalogers Clean MYSRL
items, submit new Item Names
Australia
1 Catalog Mgr 1 Catalogers Clean NGGL items,
submit new Item Names
1 Catalog Mgr 3 - Catalogers Clean PTNNT and
NEV items, submit new Item Names
1 Catalog Mgr 1 - Cataloger Clean NAL items,
submit new Item Names
9
Implement Architecture
1. All Items into Central Repository 2. SW
Auto-match to NMD 3. SW Match to OEM (part ) 4.
SW facilitates global cleansing 5. SW Match to
Newmont part
NEV
NAL
Global Repository
Level 1 Clean Item Name
MYSRL
Level 2 - Partial Attribute
NGGL
Level 3 - Full
PTNNT
Newmont Catalog
NMD
OEM
10
Perpetuate
New operational activity to support clean data
CLEAN DATA
Biz Process Tools Roles
11
Other Deliverables

• In addition to data cleansing
• Newmont Master Dictionary (complete)
• Cataloging Manual (complete)
• Catalog Item Request (planning)
• Enhanced supplier data (planning)
• Governance/maintenance

12
Lessons Learned

• LOE
• Spreadsheet cleansing
• Cleansing not linear
• Catalog moving target
• Track and collaborate
• Catalog synchronization
• New roles/responsibilities
• Single instance ERP

13
Benefits Realized To-Date

• Early results at our pilot site
• 14,000 potential duplicates
• 25,000 archived items
• Enhanced improperly coded items (tens of
  thousands)

14
Meeting 2007 Goals

• Catalog Item Request 2006/2007
• Standards and workflow automation
• Standardized Manufacturer Mnemonics 2007
• Issue How to maintain standard
• Enhanced Supplier Data 2007
• Implement requirements
• Catalog Synchronization 2007
• Issue standard external workflow
• Implement Data Steward