David Wyllie
david@wyllie.org
SAP
SCM SNP Functional and Technical Consultant
Profile
David Wyllie is an SAP consultant with over 12 years experience in Supply Chain
Modeling and mastering various solving methods used to generate build plans and
perform distribution requirements planning.
David’s experience spans the full scope of the implementation life cycle
including pathfinding, blue-printing, system design,
configuration, testing, training, conversion, and post-implementation support. Dave has also accumulated high tech industry experience
in product planning and over eight years in designing, developing and
delivering of complete training packages.
Experience Highlights:
Experience/Project Work
ANW Consulting Inc. 2007
- Present
IBM Business
Consulting Services 2004
– 2007
Intel Corporation 1995
– 2004
Intel Corporation – Acquisition
and SCM Implementation, Hillsboro, OR
Dec 2010 – Sept 2011
APO Functional Consultant, SNP lead consultant
·
Design a SNP solution for an acquisition that will
utilize CTM solve to generate a purchase requisition schedule for a 5 stage
manufacturing flow.
·
Configure SNP for multiple planning books to provide
weekly and monthly views of as well as front end and back end manufacturing
processes.
·
Configure CIF integration between ECC and SCM to allow
for master data and transactional data to flow between both systems.
·
Troubleshoot CTM results and determine root cause when
outcome doesn’t match expected results.
·
Design and deliver end user training to international
audience.
·
Provide onsite support during stabilization.
Clorox – Testing and
documentation
Oakland,
CA
Sept 2010
– Nov 2010
APO SNP Functional Consultant
·
Review new business processes and create test cases
that put processes thru paces.
·
Use Test Director to build test scenarios and execute
testing.
·
Provide SCM expertise during Consolidation Testing and
User Acceptance Testing.
Aptina Imaging – CTM analysis and troubleshooting
San
Jose, CA
Aug 2010 – Sept 2010
APO SNP Functional Consultant
·
Review existing SNP configuration and recommend areas
of improvement.
·
Troubleshoot CTM results and determine root cause when
outcome doesn’t match expected results.
·
Implement solutions to fix data issues that affect CTM
results
·
Develop macros to create alerts for specific inventory
situations.
·
Document changes to configuration and master data.
·
Suggest business process changes that would improve
data quality.
·
Train IT team on changes and proposed new processes.
Intermec Corporation – Midrange
Planning, Rough Cut Capacity Planning,
Everett,
WA
Dec 2009 – June 2010
APO Functional Consultant, SNP lead consultant
·
Was the lead SNP consultant in a DP-SNP-GATP project
that went from Blueprint to Go-Live in 6 months. Model included 5 DC locations, 3 vendors and
over 56,000 Product Location combinations.
·
Developed a midrange planning solution that utilized
SCM’s CTM solver to create STRs while respecting vendor capacity and lead
times.
·
Set up CIF integration with ECC for master and
transactional data.
·
Developed process chains to automate CTM runs and
create database alerts.
·
Created custom macros and alerts to meet unique
business requirements and metrics.
·
Performed all unit testing and provided support for
integration testing.
·
Responsible for correct set-up of all Master Data that
was both manually created and transferred from ECC via CIF. Used APO Loader to create 3000
Product/Location combination.
·
Provide post implementation support and knowledge
transfer to super-users.
Intel Corporation – Distribution
Replenishment and SAP Replatforming Projects, Folsom,
CA
May 2009 – Nov 2009
APO Functional Consultant, SNP lead consultant
·
Develop prototype models to demonstrate CTM functionality
to path finding team and compare against other solvers.
·
Responsible for all Master Data cut-over activities
and ensuring 100% accuracy across all product/location combinations in both SCM
and ECC systems.
·
Provided on-site support thru stabilization period by troubleshooting
bugs/user-issues, documenting issues and on the job training.
·
Worked with multiple business units to design and
configure planning books that meet the business units’ requirements and is in
full compliance with existing SAP processes used in other divisions.
·
Develop new macros based on existing processes and
configuration use throughout the company, but required changes to meet new
business requirements.
·
Document comprehensive configuration guide and
functional test cases.
·
Provide periodic updates to upper management on
development work, issues encountered and possible solutions.
·
Quickly and efficiently transfer knowledge of design
and development work to client.
Standard MicroSystems Corporation – Midrange Planning, Rough Cut Capacity Planning, Distribution
Replenishment Planning,
Sep 2008 – May 2009
SCM Functional Consultant, SNP lead consultant
·
Was the lead SNP consultant to develop a midrange
planning solution that utilized SCM’s CTM solver to constrain all resources in
near term, and fully unconstrained in the rough cut capacity planning range.
·
Developed a DRP solution using SNP Heuristics and
Deployment to generate supply feasible STR’s that integrated seamlessly with CTM
processes.
·
Designed, tested and implemented a custom safety stock
method that combined the standard SAP methods and client’s customized version
of Target Days’ Supply.
·
Performed all Unit and Integration Testing including complete
documentation of each test case.
·
Developed and delivered training to user groups and
provided post implementation support onsite.
·
Set up alerts to provide timely information about inventory
situations and resource utilization that allowed planners to make intelligent
decisions regarding their products.
·
Work closely with PP/DS team to ensure successful
handoff of Planned Production Orders into PP/DS environment.
Intel Corporation – Distribution
Replenishment Project, Folsom, CA
Sep 2007 – Sept 2008
APO Functional Consultant, SNP lead consultant
·
Worked with client business analysts in an SCM 5.0
environment as a lead SNP functional consultant.
·
Developed various prototype models of a distribution
network using several methods of SCM solvers to generate a replenishment
schedule for worldwide distribution centers.
·
Integrated R/3 and SCM systems using native Core
Interface (CIF) functionality by setting up, maintaining, and trouble-shooting
Integration Models for master data elements and transactional data.
·
Designed and implemented a solution for combining
customer requirements of two separate business units that share common product SKUs
into a single model and solve.
·
Developed and demonstrated planning with MRP Areas and
safety stock planning using native SCM standard and extended methods, as well
as developing macros to determine custom safety stock methods.
·
Design, develop and deliver training to end users.
·
Tested and compared output of CTM, Deployment, and
Optimizer solvers and reported to business teams with the results.
Nestle
Jan 2006 – Sep 2007
·
Lead and coordinated Integration and
User Acceptance testing efforts for SAP-APO portion of nationwide SAP release
to production.
·
Responsible for the 100% data
integrity of over 80,000 product/location combinations, 22 locations, and 100
transportation lanes.
·
Analyze SAP-APO Deployment results and
troubleshoot problem areas in Master Data.
·
Document business critical test cases,
scenarios, scripts and results as well as track issues thru resolution.
·
Facilitate the gathering of client
requirements and participate in determining a solid solution.
·
Develop templates used to collect
Master Data from business groups and work with technical team to populate that
data into SAP-APO system in preparation for conversions.
·
Manage post implementation
stabilization support by tracking and resolving enhancement requests, bugs, and
training issues.
Cisco – non-SAP Project Management Application project,
Sept 2005 – Jan 2006
Training Strategy Specialist
·
Work with client’s training team to
analyze training needs and develop a strategy for in-house developed
application.
·
Develop overview material and detailed go-live
training that included hands on exercises.
·
Coordinate and deliver end user training Receive
customer queries and own customer issues thru to resolution.
Advanced Micro Devices,
May 2005 – Aug 2005
Demand Planning Implementation Support
·
Analyze, design, develop and implement
comprehensive end user training strategies for DP Planning Books.
·
Maintain master data and CVC’s for new products.
·
Receive and take ownership of customer queries and end
user issues thru to resolution.
·
Monitor batch jobs and fix failures. If necessary, manually start batch jobs.
·
Test new functionality in Planning Books for upcoming
releases.
International Paper,
Feb 2005 – Apr 2005
Integration Test Support
·
Develop test case framework to which more
detailed scripts could be created and managed.
·
Maintain test director data base.
·
Develop templates used to collect
Master Data from business groups.
Intel Corporation, Folsom, CA
Jan 1998 – Nov 2004
Supply Chain Training / Web Developer
·
Led training design, development and
delivery effort of SAP-APO Bootcamp to over 300
students in
·
Analyze, design, develop, implement and
evaluate a comprehensive training strategy for a multi site SAP-APO
implementation.
·
Coordinate with project team and
business user groups to develop and deliver training packages.
·
Quickly master new functionality of SAP
and internally developed applications and create training material.
·
Train planning and logistics audiences
on planning tools and Intel business process.
·
Learned new web development tools and
became group expert.
Intel Corporation, Folsom, CA
Oct 1995
– Jan 1998
Divisional Product Planner
·
Act as direct interface between manufacturing
and geographic marketing organizations.
·
Generate monthly build plan to match
supply against demand and support division inventory strategies.
·
Micromanaged product availability for
all customers when products were severely constrained. (efforts resulted in helping Chipset Division
achieve “Vendor Of Choice” recognition by IBM).
·
Develop tools to identify next quarter
shipment opportunities that could be legally pulled-in to current quarter. (efforts increased 3rd quarter
sales by $24 million.)
·
SAP SuperUser for 1996 R/3 implementation.
Education
Bachelor of Science, Business Management,
APICS CPIM
Certification, 2004