200 likes | 748 Views
ARIBA. IT Staffing Requirements Timing Expectations Process & Tools for Ariba Spend Visibility. ARIBA - UPSTREAM. Key Business Processes: Spend Visibility Sourcing Contract Management Supplier Management. Supply Chain Organization to access consolidated “enriched data”.
E N D
ARIBA IT Staffing Requirements Timing Expectations Process & Tools for Ariba Spend Visibility
ARIBA - UPSTREAM Key Business Processes: • Spend Visibility • Sourcing • Contract Management • Supplier Management Supply Chain Organization to access consolidated “enriched data” Ariba On Demand / SAAS Quarterly \ Monthly “flat file” upload of Procurement related data (Pos, Invoices, Supplier Master …) Data to be sourced out of x12 ERPs systems across the Tomkins I&A Business Units
Ariba Spend Visibility Expected Files Spend Objects "Invoice.csv" for AP transactions table “PO.csv” for Purchase Order Line transactions Supporting tables “Account.csv” for General Ledger accounts table “CompanySite.csv” for Facility/Site location Master table “Contract.csv” for Contract Master table “CostCenter.csv” for Cost Center Master table “ERPCommodity.csv” for the Material Code Master table “Part.csv” for Item Master table “Supplier.csv” for Supplier Master table “User.csv” for the Buyer Master table “CurrencyMap.csv” for mapping Currency codes “UOMMap.csv” for Item Master table Reporting Time Line / Buckets All files listed here above need to be provided for Full cycle year 2009 Full cycles Q1 + Q2 2010 Supporting Documents & Tools Please refer to the valid version of documentation as well as the Samples posted on http://portal.interlake.net Userid: ariba226234 Password: tomkins2010
x2 Cycles for Spend Visibility – Minimum Expected Cycle 1 Cycle 2
x2 Cycles for Spend Visibility – Target Cycle 1 Cycle 2
Time Line Spend Visibility (IT Deliverables) • Kick-Off: 5/17 • Data Schema Training: 5/17 • C1 Collection Complete: 5/28 • C1 Validation Complete: 6/11 • C1 Enrichment Start: 6/14 • C1 Enrichment Complete: 7/23 • C1 Deployment Complete: 7/30 • C1 Refinement Start: 8/2 • C2 Refinement Complete: 8/13 • Kick-Off: 6/7 • C2 Collection Complete: 7/9 • C2 Validation Complete: 7/23 • C2 Enrichment Start: 7/26 • C2 Enrichment Complete: 9/3 • C2 Deployment Complete: 9/10 • C2 Refinement Start: 9/13 • C2 Refinement Complete: 9/24 6/11 Almost Done! 5/17 5/28 7/30 Kick Off Workshop with Ariba in Denver Mapping Extraction Initial Delivery Test, Validation Prepare Deployment C#1 Allocation - 100% Allocation - 40% Allocation - 20% 6/8 7/9 7/23 9/10 C#2 DELIVERY DEADLINE Mapping Extraction Initial Delivery Test, Validation Prepare Deployment C#2 Allocation - 100% Allocation - 40% Allocation - 20% 2/10 PRODUCTION Quarterly Delivery 2010 – Q3 PRODUCTION – DATA DELIVERY EVERY QUARTER
Team Matrix – IT Ariba Spend Visibility – NA C#2 Overall PM Beth Foster Project Manager Tomkins Global SCM IT Project Coordination Frederic Abgrall Project Coordinator Marc Heline Project Coordinator Technical Leads Shannon Lucero ETL Architect Keith Luers ARIBA Tech. Local ARIBA / Coordinator & Developers “……………………” Gates CA Inc “……………………” Gates Windsor “……………………” Gates Mectrol US/EU “……………………” Gates Argentina “……………………” Gates Brasil
DATA MAPPING DOCUMENT – INVOICE SAMPLE Please Retrieve under portal.interlake.net \ 00_Read_Me_First \ Appendix B - Tomkins Data Acquisition Schema.xls
DATA MAPPING TEMPLATE Please Retrieve under portal.interlake.net \ 00_Read_Me_First \ Appendix D - Tomkins Data Acquisition Schema.xls
DATA FILE SAMPLE – SAMPLE Oracle NA Please Retrieve under portal.interlake.net \ 02_SAMPLES_FOR_REFERENCE \ invoice2.csv
DELIVERY PLATFORM http://portal.interlake.net Userid: ariba226234 Password: tomkins2010
Closing Summary • Appoints Local Developers for Ariba SV C#2 • Appoints Coordinator for region or Business Units (Multiple ERPs) • Appoints Operational Point of Contacts to run the programs and upload the files post golive