success story for global edi support · phase 2: edi migration to seeburger from qad’s qce •...
TRANSCRIPT
Success Story for Global EDI Support
Yanfeng All Rights Reserved 2
• Company Overview
• EDI Support Structure & Team
• Global EDI Support Requirements
• Daily EDI Support / Staff Augmentation
• Project Support
• Prioritization & Control
• Results
• Q&A
Agenda
Company Overview
YFAI All Rights Reserved 3
• World leader in automotive interiors
• 30+ years in interiors
• $9 billion in revenue
• 33,000+ employees
• 110 manufacturing and technical
centers in 20 countries
• Started as a joint venture between
Yanfeng & Adient in 2015, has
recently taken full ownership of the
joint venture
Company Overview
YFAI All Rights Reserved 4
Launched 13 plants and 16 other entities
between February and November of 2018
Launched 10 plants, 1 corporate office and 11
other entities between March and July of 2018
YFAI All Rights Reserved 5
EDI Management
Christoph Scheibner – Yanfeng, EMEA
Lee Cantrell – Yanfeng, NA
---------------------------------------
Michael Mina – Logan Consulting
(LC resources only)
EDI Resources - EMEA EDI Resources - North America
May 2017 – March 2021
• Phil Austin – Logan Consulting
Augmentation Resources (peak times):
• Internal EDI Analyst (Daniel)
• Logan EDI Consultant (Lou)
• Logan EDI Consultant (Fanny)
May 2017 – March 2021 (~4 years)• Lisa Dunaway – Logan Consulting
Augmentation Resources (peak times):• Logan EDI Consultant (Patti)• Logan EDI Consulting (Jim)• External EDI Consultant (Jason)
Locations - EMEA Locations – North America
Neuss DE
Namestovo SK
East London SA
Zatec CZ
Neustadt DE
Rosslyn SA
Luneburg DE
Grefath DE
Valencia ES
Cicerale IT
Melfi IT
Rocca IT
Kragujevac RS
Plana CZ
Cottondale, AL
McCalla, AL
Hayward, CA
Belvidere, IL
Louisville, KY
Highland Park, MI
Monroe, MI (2 plants)
Romulus, MI
Southview, MI
Harrison Township, MI (2 plants)
Bryan, OH
Fountain Inn, SC
Chattanooga, TN
Mississauga, ON, CA
Ramos Arizpe, MX (4 plants)
EDI Support Structure & Team
Yanfeng All Rights Reserved 6
Original Requirements – Staff Augmentation Roles – 2 Resources (US and EMEA)
Main responsibilities:
• Application Support:
• Incident Management (Approvals, Escalations, KPI’s, SLA’s)
• Change Management
• Assign internal resources to projects, major developments/enhancements
• Documentation and Communication of (support model, etc.) to end users
• Webinar/Training for new employees about support portal
• User access management (new users, assign/change roles, close accounts, audits)
• Environment or modules updates/upgrades
• Alignment regarding downtimes of environments between sites/regions
• Manage updates of databases
• Request new/retire environments
• Hardware performance monitoring is on QAD but decisions need to be taken in order
to maintain good QOS
• Regular governance reviews (changes, mediate conflicts between sites/regions)
Global EDI Support Requirements
Yanfeng All Rights Reserved 7
Original Requirements – Staff Augmentation Roles – 2 Resources (US and EMEA)
Main responsibilities:
• Application Support:
• Incident Management (Approvals, Escalations, KPI’s, SLA’s)
• Change Management
• Assign internal resources to projects, major developments/enhancements
• Documentation and Communication of (support model, etc.) to end users
• Webinar/Training for new employees about support portal
• User access management (new users, assign/change roles, close accounts, audits)
• Environment or modules updates/upgrades
• Alignment regarding downtimes of environments between sites/regions
• Manage updates of databases
• Request new/retire environments
• Hardware performance monitoring is on QAD but decisions need to be taken in order
to maintain good QOS
• Regular governance reviews (changes, mediate conflicts between sites/regions)
Global EDI Support Requirements
100%
0%
Project Support Daily Support/Staff Augmentation
40%
60%
Project Support Daily Support/Staff Augmentation
Yanfeng All Rights Reserved 8
Global EDI Support Requirements
Project Support (40%)• Upgrade EDI as part of QAD EE upgrade
• Move Yanfeng from QCE and current communication to another EDI provider – Seeburger
• Support new programs requiring EDI Onboarding
• Facilitated and assisted as needed to drive EDI related project to completion. • Online Supplier Planning and Scheduling capabilities using the QAD QCE Product
Daily Support / Staff Augmentation (60%)
Main responsibilities:
Yanfeng All Rights Reserved 9
The Logan Team was the first contact for both the plants and the suppliers when there was an
EDI issue
Main Activities:
• Support plants for new supplier EDI setups
• Tracking new setups for multiple new programs
• Liaison and Issue Resolution Facilitator between Yanfeng plant users, Yanfeng IT
management and QAD Inc
Daily Support / Staff Augmentation
Yanfeng All Rights Reserved 10
Phase 1: Migration from Legacy EDI to QAD EE using QCE
• New Supplier Codes, EDI IDs, and VAN or Communication Path
• Send Test Release Files and Receive Test ASN Files
• Troubleshoot Issues with the Data, and Connection
• Track Status of Each Supplier
Phase 2: EDI Migration to Seeburger from QAD’s QCE
• Liaison with the Seeburger Team for migration
Additional Changes:
• Streamline of EDI Versions, to Remove Support for Older / Legacy Formats
• Communication Method from Primarily VAN to OFTP2 / OS2 Direct Connect
Project Support
Yanfeng All Rights Reserved 11
Prioritization and Control
Phase 1 – QAD / QCE Migration
• Plants were requested to prioritize their suppliers
• Migration completed in conjunction with overall QAD ERP implementation
Phase 2 – Migration to New Provider
• Suppliers prioritized based on amount of traffic
Daily Support
• Evaluation of business need, size and timing of programs involved
Yanfeng management was the ultimate director of priorities and consulted when issues required escalation.
Yanfeng All Rights Reserved 12
Control
Policy of “communicate, communicate, communicate” was pursued
Main Tools Utilized:
SharePoint – Document repository
Smartsheet – Summary of Results for Management Status Reporting, EDI Master Data and
Preferred EDI Formats by Region
Tracker – Provided status for each transaction that Plant level. Plant users could view and
update as needed
Weekly Status Report – Status updates to Global EDI Managers from Consulting team
Prioritization and Control
Yanfeng All Rights Reserved 13
Tracker – This is an example of a tracker file. It walks the process of the supplier from
beginning to end and can list who is responsible for each step.
Example - Tools
YFAI
location
QAD Supplier
CodeSupplier Name
Total
Number of
Suppliers
Total
Suppliers
replied
Total
Suppliers in
Wip
Completed
Suppliers
Supplier
Survey
Sent
-Plant
Supplier
Survey
Received?
-Plant
PO
Available?
-Plant
QAD EDI
35.13.7 &
35.13.10
setup
(EDI)
QAD comms
status
(date)
(EDI)
YFAI test
EDI msg
sent to supplier
(date)
Plant Ops
Resource
Date Release
approved by
supplier
Plant Ops
Resource
Supplier
sent ASN
and
notifies
Plant Ops
Resource
Supplier
ASN Received
(date)
Plant Ops
Resource
Supplier
ASN
approved
by YFAI
(date)
HP 9001234 Acme 1 0 1 0 10-Jan 54398
HP 9016547 A-1 Supply 1 1 1 0 10-Jan 12-Jan 95048 15-Jan 1/16 -c READY to TEST
HP 9058271 ABC Resin 1 1 1 0 10-Jan 18-Jan 42320 18-Jan 1/18-r
HP 9042214 Bobs Textile 1 1 1 1 10-Jan 15-Jan 62482 20-Jan 1/21-c 22-Jan 24-Jan 24-Jan 25-Jan 25-Jan
HP 9026482 Johnson Fastening 1 1 1 0 10-Jan 13-Jan 54302 14-Jan 1/15-c 21-Jan 22-Jan
5 5 4 5 1 5 4 3 1 2 1 1 1
80% 100% 20% 100% 80% complete Ready to test 40% 20% 20% 20%
0 2
WIP File sent
1
Ready for QAD
Yanfeng All Rights Reserved 14
Smartsheet reporting – Smartsheet was leveraged to provide more robust reporting.
Example - Tools
Yanfeng All Rights Reserved 15
Grades: Daily Staff Support / Augmentation
Overall =
Mngt Satisfaction =
Plant Satisfaction =
Cost Effectiveness =
Grades: Project Support
Overall =
Mngt Satisfaction =
Plant Satisfaction =
Cost Effectiveness =
Results
Yanfeng All Rights Reserved 16
Questions?