1 / 14

Newmont Data Cleansing Project Overview ECCMA International Cataloging Conference

Newmont Data Cleansing Project Overview ECCMA International Cataloging Conference. October 26, 2006. Newmont Data Standardization Overview. Agenda Company & project overview Project approach Lessons learned Results & going forward. Company Overview. 2005 Revenues: $4.4 billion

loyal
Download Presentation

Newmont Data Cleansing Project Overview ECCMA International Cataloging Conference

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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 Oz’s 2005 Equity Reserves 93.2 Oz’s mm

  4. Site / Regional Corporate / Global Sourcing Leverage Component Standardization Opportunity Identification Apples to Apple Comparison Purchasing Inventory Item identification Unique instances of ERP databases NEV Newmont NAL MYSRL NGGL PTNNT 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. PERPETUATE DEFINE IMPLEMENT Select catalog standard Define internal standards Implement Business process/workflow Implement controls (Validation/Audits) Provide tools/training Cleanse catalog Update tables & associated records Project Approach 210,000 Items Globally - One Year to Cleanse

  7. Level I Level II Level III Research to full attribution Goal: 40% Item Names assigned Goal: 100% Apply existing data Automation and manual Goal: 60% 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 CatalogSynchronization: 2007 • Issue: standard & external workflow Implement “Data Steward”

More Related