SUMMARY:

A seasoned professional in SAP ERP with experience in Data Management, MM (Procure - To-Pay & Inventory Management), WM, PP, SD and some QM processes. I have strong data analysis, problem solving, and solution implementation skills which are vital to the managing and improvement of all processes maintained in SAP supply chain. Over 20 years of Manufacturing Management experience including positions as Production Planner, Master Scheduler, Production Supervisor, Operations Manager, Corporate Continuous Improvement Specialist (Toyota Production System & Kaizen), and Supply Chain Planner. My work pedigree is with major global corporations .

COMPUTER SKILLS:

Microsoft Word -Adv. Microsoft Excel (Vlookup, formulas, etc) Microsoft Access (Reports, queries, Macros, etc.)-Microsoft PowerPoint SAP ERP CRM APO/DRPLSMWs-ARIBA Win Shuttle & Transaction Shuttle-BPICS MRP II Software package Certified WinShuttle Master -SQL Server 2008 (Advanced queries & Reports)

PROFESSIONAL EXPERIENCE:

SAP Project Manager

Confidential

Responsibilities:

• Developed complete SAP implementation plan for 2 acquisitions of 450+ sites using AFS1, CAR (POSDT), and ECC 6.4
• Used Microsoft Project to manage the 2 different implementations (450 sites in Italy and 34 sites in Latin America.
• Used HP Quality Center to manage individual Unit testing, Integration Testing, and User Acceptance testing.
• Managed 35 different RICEFs for development which included Functional Specs, Field Mapping Documents, Technical Specs, and Unit Testing.
• Facilitated weekly implementation team meetings to monitor progress and address issues as they arose.
• Meet weekly with functional analysts and ABAP Lead to assist in keeping project moving in correct direction and address any issues as they arise.

SAP Data Migration Consultant

Confidential

Responsibilities:

• Developed Database Applications using Microsoft Access to convert legacy data extracts into complex format used for Data Services loading into SAP.
• Responsible for ETL for Material Masters, Vendor Masters, Customer Masters, PIRs, Source Lists, BOMs, Routings, Inventory, Purchase Orders, Production Orders, Work Centers, Profit Centers, WIP, Fixed Assets, and other data objects for MM, WM, QM, SD, PP, and FICO.
• Built Winshuttle scripts for loading data objects into SAP and extracting data out of SAP.
• Worked with the client to teach them the different fields in the Customer, Material, Service, and Vendor master so that they could assist in generating the logic for data conversion.
• Create Winshuttle scripts to extract data from R A.
• Confidential ’s SAP system for the purpose of data validation. I also developed other Access database applications to compare values of the load file with the values in SAP for data validation of the Mock and Production loads.
• Built queries in SAP to assist client in validating data for Vendor and Customer pricing. This included all key combinations and scaled pricing.
• Developed database application that would identify all customers and vendors missing relevant information for output conditions (i.e. customers missing email addresses necessary for sending invoices and vendors missing necessary data for delivering POs.
• Create Winshuttle scripts for creating complex Customer Master, Vendor Master, and Material Master data objects.
• Trained Jones employees on Master and Transactional data management to assist them in troubleshooting their own data. This was done to equip them to be independent of consultant assistance in maintaining their own data.
• Developed a Winshuttle/Microsoft Access application to enable 9 Purchasing personnel to process 900-1500 PO lines per day in less than 2 hours by developing custom reports with all necessary information and using published Winshuttle scripts to upload the data all at once.
• Worked with CEO and IT Director to structure the data department and the rolls of each member.
• Worked with Accenture implementation team to perform loads and document data conversion process.

SAP Manager.

Confidential

Responsibilities:

• Develop transition strategy to move from interface with P&G’s SAP client to interface with Duracell’s new SAP client.
• Create Winshuttle scripts to extract data from Duracell’s SAP client for the purpose of creating data objects in Confidential ’s system. This will replace the current EDI process that is much too cumbersome.
• Lead Kaizen teams to move production reporting to a paperless system which will save 4867 hours a year in processing time.
• Lead project to migrate the tool crib of over 8500 parts from an outdated system onto SAP for procurement processes & IM processes.
• Manage the roles and responsibilities for the SAP environment.

SAP Sr. Supply Chain

Confidential

Responsibilities:

• Assist in mapping Procure To Pay process with purchasing department and develop training for buyers new to SAP
• Develop custom reports for Purchasing department to assist in validating their Master Data and Transactional Data loads.
• Assist Purchasing and Warehousing end users in managing User Acceptance Testing (UAT) using HPQC
• Assisted Power Users to identify Master Data elements that are improperly populated or missing.
• Create Winshuttle Queries for validating data loads into the new SAP clients
• Create Winshuttle Transaction to demonstrate its ability to be used for data loads (BOMs, Recipes, Matl Masters, etc.)
• Create ABAP queries for custom reporting on master & transactional data (i.e. Classifications, characteristics, Sales Order, inventory, and open purchase orders)
• Develop facility-wide SAP training program which includes training strategy, course lists, course curriculum, and course material content to equip and empower the employees while transitioning from Oracle ERP to SAP.
• Facilitated SAP Navigation, SAP Report and Query Navigation, and other training classes prior to implementation.
• Used SAP Workforce Performance Builder (WPB) to create graphic demos and user manuals on the t-codes end-users needed to be trained on.
• Helped maintain test scripts in HP Life Cycle Management tool (also known as HPQC). This was used for managing integration testing, User Acceptance testing, and regression testing.
• Assisted in Public Relations rollout of SAP which included lunch-&-learns, distributing promotional gifts, developing banners and slides for public monitors throughout facility informing public of the upcoming go-live.
• Created Microsoft Access database applications for ETL processes in master and transaction data of all areas.
• Developed Microsoft Access databases that 100% compared the values on the approved load files with the field values extracted from the load target client and highlighted any differences.

SAP Supply Chain Lead

Confidential

Responsibilities:

• Manage quarterly RICEF implementations using ChARM & Solution Manager.
• Designed and evaluated solution alternatives based on Business needs. Yes that includes Purchasing
• Worked with Operations Center of Excellence to capture business requirements and create high level cost estimates.
• Lead 3rd Party Supply Chain AMS (MM/PP/WM/SCM) team of BAs to ensure SLAs were met for processing outage tickets logged by the business.
• Provided guidance and advice to the business on various proposed solutions keeping them as close to SAP Best Practices as possible.
• Created functional specifications used in enhancement modifications, interfaces or new development.
• Developed unit testing scripts in accordance with design requirements to insure all scenarios are properly checked.
• Documented business procedures, configuration changes, test scenarios, test plans and results for changes made in Production client.
• Responsible for identifying all of the potential risks involved with proposed enhancements prior to loading them into DEV, QA, or PROD environments.
• Created Winshuttle Direct scripts for mass updating fields in CRM using BAPIs and RFCs.
• Developed Microsoft Access Applications to assist enhancement teams in developing/implementing the proper configuration for various projects.
• Worked with Operations to insure new employees had proper roles assigned to them for their new positions.
• Researched different SAP best practices solutions to determine if they met business process needs.
• Tracked progress of quarterly enhancement projects being run by BAs in my Dept. and report results to management and the business.
• Informed business (Operations) and IT Senior management when there was a business outage and the status of the correction process. This kept them informed of when service would be restored, what the root cause of the outage was, and when pro-active corrective measures for the root-cause would be implemented to prevent future outages.

Master Data Mgt Consultant

Confidential

Responsibilities:

• Compared and reconciled configuration tables in different SAP clients to insure consistency.
• Created queries and reports for data testing.
• Worked with functional consultants to map data for loading into client’s Dev & QAS environments.
• Developed Access Database Applications for transforming data from multiple legacy systems into SAP Load format.
• Created Winshuttle Query and Transaction tools to extract and load data in various SAP instances.
• Collaborated with Data Services and Microsoft SQL Server developers to create ETL tools from the scaled-up models I created using Access.
• Worked with various Confidential Bottlers in data cleansing and normalization.
• Performed unit testing on new load programs used to migrate data from one system to another.
• Create Microsoft Access database to perform ETL on over 3.6 million lines of pricing data for over 7.5k customers and 2000 products, equipment, & services.

Master Data Mgt Consultant

Confidential

Responsibilities:

• Extracted Transactional data from N6P for Cut-over.
• Worked with Accenture functional consultants to map data for loading into client’s Dev & QAS environments
• Worked with Confidential Pharmaceuticals to cleanse and normalize data by generating custom reports to identify errors.
• Created a data repository for data mapping and data modeling using Microsoft Access.
• Created a Microsoft Access Application with macros to manage the mass migration of engineering change items like Bills of Materials, Master Recipes, and Production Versions. This tool identified the records that were relevant to be loaded into the new systems and which records were to be archived.
• Managed progress of data migration using Sharepoint.
• Created Transaction Shuttle Scripts for Material Master, Vendor Master, Master Recipes, Bills Of Materials, Text, PIRs, Cost Centers, Profit Centers, and other master data elements along with some transactional data elements.
• Use HPQC to document and validate data loads and store validation scripts.
• Created Functional and technical Specification documentation for Extraction and Transformation of Data.

SAP Consultant/Business Analyst

Confidential

Responsibilities:

• Experience using Winshuttle Query to extract data from SAP ECC in a controlled manner as to minimize demand on servers.
• Experience using Winshuttle Direct to load data into SAP ECC via BAPIs .
• Created complex queries using SQ01, SQ02, and SQ03 for performing Data Cleansing and mass changes using Winshuttle Transaction Shuttle.
• Created Access databases to model proof of concept solutions in SAP invoice release scenarios for transaction MRBR and for complex Master Recipe reports.
• Performed configuration changes in MM, WM, QM, and PP modules.
• Troubleshoot Supply Chain process problems for various clients and implemented solutions.
• Facilitate User Acceptance Testing at various client’s sites. Included organizing documentation, developing sample test data, and facilitated training of the end users.
• Troubleshoot client issues as they arise. Included working with the technical consultants to make sure proposed solutions met client’s specified needs.
• Investigated various seldom-used and obscure SAP transactions for possible solutions to avoid the use of ABAP Development to meet client needs.
• Developed Microsoft Access database applications for clients who wanted data quickly from SAP without having to pay for expensive & time consuming ABAP programming and development.
• Create custom queries and assigned them to transactions and users for downloading data from SAP in a user friendly format
• Performed mass data entry of materials, classifications, characteristics, PM Functional Locations, and other data elements from legacy systems
• Performed Mass Data management projects for various companies using Winshuttle and other tools like Microsoft Access, Excel, and SQL Server.
• Was the SAP Liason for Improvement initiatives at a local client to streamline the 3rd party drop-ship business (over $320 million annual revenue)
• Assist in the implementation of MRP Areas (both Sub-Contracting and Storage Location) for the use of capturing demand at various co-packers.
• Developed a data cleansing plan to assist clients in cleansing legacy data for ETL. This included development of a Microsoft Access Database to analyze materials, customers, and vendors to identify duplicates & potentially obsolete/inactive records.
• Created a Data Migration plan for various clients to insure master & transactional data is properly loaded into various systems (DEV, QAS, and Prod) for training and go live.
• Design warehouse (Stg Sections, Bins, pallet types, and storage unit types) for client about to implement SAP Warehouse Management module.
• Map client processes using Visio to identify possible outages & dis-connects.
• Capture questions and concerns from client & collaborated with senior consultants & ABAP developers to come up with a solution for problem tickets and small projects.
• Develop training material for clients to learn P2P and master data management skills.
• Work with clients to assist in preparing them to maintain their master data showing them skills like LSMW, Winshuttle, SQVI, SE16N, etc
• Assist in the configuration for a Warehouse Management implementation.
• Offer Administrative Assistance to update 6 months of RICEF work in RICEF Tracker & Community Manager (Client’s RICEF Management tool)
• Configured QM for Externally Procured materials to be inspected upon receipt.
• Wrote Winshuttle Scripts for Clients to maintain Customer Data.
• Trained Clients on how to put together a Master Data Organization.
• Trained on LSMWs for new clients to prepare them to do their loads.
• Trained Purchasing Dept (Buyers & Category Leaders) on the MM functionality of SAP and how to use it to perform their various functions.
• Manage Master Data for various accounts by doing mass data loads, updates, and changes for both Master Data and transactional data.

SAP MM Business Liason

Confidential

Responsibilities:

• Meet with operations leaders and end users to capture their data cleansing needs.
• Train end users on how to best go about maintaining & managing their Master Data elements.
• Develop SQL Server diagnostic tools to analyze raw data and transform it into user friendly reports for data cleansing, modeling, and budget analysis.
• Work with Process Owners to identify key result indicators and data points that need updating.
• Perform data mining exercises in SAP to gather pertinent data required for assisting supply chain in choosing the proper sourcing plant for different customer-product combinations.
• Identify opportunities to supply custom reports to Category Leaders which would reduce the demand on the Production Environment by using data from our data warehouse.
• Work with Business Unit leaders to develop a plan on how to best develop a non-intimidating program for subduing the mountains of dirty data that was not properly cleansed since going live in SAP.
• Work with IT Developers to insure that the needs of the field were properly implemented in the finished web-based Net Weaver tool. This way there is a relatively smooth transition for them to start using the product.

Global Master Data Management Analyst

Confidential

Responsibilities:

• Manage the cleansing of master data elements for Material Master (MM, QM, WM), Customer Service and Sales (SD), Vendor Management (PP & VM), Human Resources (HTR), and Accounting (FICO).
• Performed for over 2.8 million transactions in live environment for data creation, updating, and deletion. Database size of over 621k materials MARA, 89k customers KNA1, 71k vendors LFA1
• Use SQVI, SE16N, MS Access, SQL, and Excel to create custom and ad hock reports for all areas in SAP (ie. JSOX, Sales and Revenue, Six Sigma Projects, and cost study analysis).
• Create Customer Material Information Records (CMIRs), Purchasing Info Records (PIRs), Materials, Customers, Vendors, and other Master & Transactional Data elements using LSMWs, WinShuttle (Transaction Shuttle), and other Mass conversion transactions in SAP.
• Create Microsoft Access applications for analyzing and validating the integrity of data transfers from legacy systems into live SAP environments.
• Develop & publish Winshuttle templates for end users to easily submit requests for changes, creations, or deletions of data records using excel and/or access.
• Generate sales reports for upper management to identify revenue problems in the Order To Cash processes (i.e. invoicing, consignments, Certificates of Analysis, etc.).
• Responsible for managing and coordinating data transfer for plant closures & consolidations.
• Work with plant personnel to troubleshoot costing problems with materials. Developed Microsoft Access tool to quickly identify missing PIRs, SPT, BOMs, and other MRP fields.
• Worked with data repository to identify records that already exist in SAP prior to a go-live event to eliminate possibility of duplicate entries.
• Worked with PTF process team & Supply Chain to cleanse over 265k BOMs and 380k recipes.
• Work with subcontractors to assist in over 6 major roll-outs of SAP involving 38 Company Codes in 18 countries and 52 Sales Organizations.
• Work w/ different process teams to implement configuration changes in the live environment (i.e. mass BOM & Recipe changes, COAs, Billing and invoice strategies, consignment process analysis, bulk container tracking, etc)
• Responsible for coordinating changes in data for sales office consolidations, Customer hierarchy changes due to acquisitions, and new product launches.
• Worked with other legacy systems interfacing with SAP to insure data transfers into their databases were accurate (i.e. Atriom for MSDS processing and distribution, ARIBA for expense report processing, Helios, COGNOS, and D&B data loads for Credit limits)

Lead Master Data Analyst

Confidential

Responsibilities:

• Oversee daily activities of 18 analysts responsible for maintaining master data records in all areas of SAP (PTF, PTP, FI/CO, HTR, OTC)
• Wrote procedures and facilitated training for analysts and future users in the field that would be submitting requests for Master Data changes to our department.
• Developed Excel forms to accurately capture necessary data from our customers for creating new customers, materials, vendors, employees, profit centers, and other data elements in SAP.
• Worked with process teams to inform analysts and end users of changes in master data configurations both company related and SAP related.
• Participated in Six Sigma projects that improved invoice accuracy to insure customers were quickly and properly billed.
• Worked with internal customers and process teams to prepare for upcoming roll-outs by performing Day In the Life simulations and training for future users about to go live on SAP
• Standardized procedure for flagging records for deletion (materials, customers, vendors, PIRs, CMIRs, etc)

Supply Chain Network Planner

Confidential

Responsibilities:

• Responsible for managing inventory levels for North and Latin America for all bar soaps, body washes, and in-shower body lotions (i.e. Ivory, Old Spice, Zest, Camay, Oil of Olay, Safegard, and Herbal Essence).
• Responsible for insuring all distribution centers were properly stocked to meet customer demands.
• Performed root cause analysis on customer service outages for multi Billion Dollar Category.
• Developed Access database tool to extract data from SAP APO to give early warning when inventory of a product would be depleted.
• Managed Master Data integrity for APO/DRP and R/3 materials (6000 sku)
• Developed Access database tool to capture blocked IDOC information and generate a list of all in-transit shipments for products to prevent overstocking.
• Reviewed forecast accuracy report to identify changes in customer ordering trends and re-set safeties levels accordingly.
• Built trucks for interplant shipments to maximize weight, cube, and order picks.
• Investigated problems in SAP FIRST (Forecasting Integrated Reporting & Statistical Tool) to determine why production sites aren't getting accurate demand notification.
• Expedited transport of goods to meet customer orders at different distribution centers throughout North & Latin America.
• Managed inventory levels for initiatives, conversions, and discontinued products to insure pipeline was adequately supplied for Start of Ship and there was minimal residual inventory of phased out products.

Operations Manager/Supervisor

Confidential

Responsibilities:

• Oversaw entire site operations of 60 employees (liquid production, powder production, distilling operations, packaging, QC, shipping & receiving, material control and security departments).
• Insured all GMP's and Confidential operating procedures were strictly adhered to.
• Directed the activities of production Lead Operators to insure schedules are met and safety requirements are followed.
• Facilitated weekly safety and "state of the business" meetings with all departments to insure training was kept up and associates are kept in the loop of corporate decisions and changes.
• Lead spill team for the plant to insure all members were equipped and trained to handle various hazardous scenarios.
• Developed and maintained a Microsoft Access database to track and monitor late orders w/ their reason codes. This was used to direct the actions of Barrier Removal Teams to reduce late orders & cycle time.
• Assisted in development of Job Hazard Analysis training to proactively address safety issues in common procedures. These drastically reduced occurrences of safety issues by making operators aware of potential risks and problems prior to their performing the task.
• Performed internal quality audits to prepare for ISO 9002 and American Institute of Baking certifications.

Continuous Improvement Specialist

Confidential

Responsibilities:

• Facilitated and lead 25+ improvement teams at different sites which produced quantifiable improvements in the areas of cycle time, productivity, gross margin, quality, and cost reduction
• Trained management staff how to develop and implement shared visions, missions, and values which would focus their efforts and produce a synergy in the areas of most importance.
• Coached plant staff on proper use of process maps, Pareto charts, brainstorming, Fish-bone diagrams, data collection and analysis, identification of different types of waste, Andon, Poka-Yoke, 5-S, and other tools of lean manufacturing.
• Developed floor layouts for different sites that would improve their work flow and reduce work-in-process. This increased quality, reduced scrap, and cut back on over-runs.
• Assisted in implementing Toyota Production System (TPS) in a facility which resulted in an increased gross margin from 35% to 56%, reduced customer returns by 27%, and increased labor productivity from $138/manhour to $183/manhour.
• Facilitated a team which cut the cycle time on made-to-order products from 7 days to 4 days.
• Assisted Center Managers and their staffs in creating an environment that energized Kaizen improvement teams made up of production and support personnel.
• Lead an improvement team that produced an annual savings of $38k in raw material usage.
• Facilitated a team that reduced direct labor from 11% of total factory cost to 7% by changing machine layout and scheduling practices.
• Developed a standardized system of categorizing machine downtime that lead to a reduction in scheduled changeovers.
• Trained managers how to identify key result indicators for their direct reports that would help monitor performance in areas that are directly related to their department's goals.