Data/ERP Analyst

Resume posted by sherryparker in Manufacturing.
Desired salary: $75,000.00
Desired position type: Any
Location: King City Oregon, United States

Contact sherryparker

Summary

20+ Years Manufacturing Experience across virtually all departments with a heavy focus in data analysis and ERP Systems.

Education

Udacity – Data Analyst Nanodegree (November 2016)

Portland State University – B.S., Social Sciences (June 2011)

Project Experience

Enron Person of Interest Algorithm (May 2016)

https://github.com/TheHalfling/Enron_POI

  • Authored Python 2.7 code that generates 3 pkl files, and a write up explaining the process
  • Constructed a machine learning algorithm to evaluate if people are part of the Enron POI group

Election Contribution Analysis (April 2016)

https://github.com/TheHalfling/Udacity_Nanodegree_Project4

  • Generated HTML file knitted from R
  • Evaluation of Individual contributions from Oregon to the 2016 Presidential campaigns

Interactive Visualization of Baseball Player Statistics (Aug 2016)

https://github.com/TheHalfling/Udacity_Project6

  • Coded in HTML, CSS and dimple.js
  • Interactive web visualization showing Baseball Player BMI vs Home Run Count

Experience

Jan 2015 to Present – DWFritz
ERP Analyst (10/2016 – Present)
  • Work closely with all departments identifying ERP pain points and opportunities for improvement
  • Facilitate implementation and integration of new ERP modules and systems such as Contract Planning
  • Train ERP users on new functionality
  • Design, implement, test and validate ERP enhancements and issue resolutions
  • Work to bring core business data into the ERP system, making sure it is reliable, relevant, accessible and reportable
  • Support various KPI initiatives from a data infrastructure perspective
Manufacturing Documentation Assistant (1/2015 – 10/2016)
  • Participate in ERP Implementation Team, SME for Manufacturing, Production Planning, Inventory Management, and Logistics functional areas. Additional support for Purchasing, Service, Project Assistants, and Sales Order Management.
  • Assist Manufacturing and other departments with documentation of procedures, answering technical questions, and training to use the ERP systems
  • Generate manufacturing metric tracking using Excel, link them to various other project management spreadsheets
  • Create technical documentation to facilitate manufacturing practices and computer systems
March 2011 to Jan 2015 – Photon Kinetics
Order Administrator (3/2013 – 1/2015)
  • Developed an automated, interactive Excel report that shows sales orders by vendor for use by Customer Support
  • Generated an automated, interactive Excel report that shows booked orders by year, with breakouts for each month and reflects cost, price and profit by month, quarter and year
  • Created standardized reporting of quality control measures for quarterly PowerPoint, utilized Excel graphs linked to PowerPoint slides
Production and Administrative Assistant (3/2011 – 3/2013)
Reporting to VP of Production and Engineering
  • Entered and maintained 200 purchase orders per month in support of Purchasing, interface with vendors and Production Planning to resolve issues
  • Evaluated weekly MRP data from an Excel report that generated a planned order list from the MRP system
  • Correlated in-house part numbers, manufacturer part numbers and vendor part numbers for use in generating BOM parts lists for vendors of turn-key circuit boards
  • Created Excel report that tracked physical location of hard-copy purchase requisitions through approval process
1997 to 2011 – Blount International, Portland, OR
Administrative Assistant
Reporting to Director of New Technology (10/2010 – 3/2011)
  • Tracked project costs daily and investigate any unexpected costs; worked with AP and Purchasing to resolve problems
  • Generated Ad Hoc report creation using Microsoft Excel and SAP to identify data that requires updating or correction and for use in engineering decisions
  • Maintain SAP Engineering BOMs for the New Technology Group (Engineering R&D Team)
Reporting to Engineering Systems (2/2009 – 10/2010)
  • Developed training material for Manufacturing Personnel, primarily step-by-step instructions to utilize SAP transactions
  • Created Excel report to track open work orders in Machine Shop by routing step
  • Cleaned and improved data and data collection techniques, such as moving 400 documents into SAP from a variety of individual systems
  • Standardized and updated processes for carbide maintenance to automate position reducing man hours required for position by 50%
Reporting to Divisional Engineering & Plant Manager (12/2006 – 2/2009)
  • Created Excel report showing a breakout of a year’s production by SKU and every BOM level feeding into it
  • Managed an Excel report using Pivot Tables analyzing monthly actual production as compared to forecast to explain variations to budget for cost of product
  • Assisted in data review for yearly budget cycle, month end budget figures and spot audits of departmental budgets for accuracy and error correction

Skills

  • Python2 (2 years)
  • Python3 (3 years)
  • R (1 year)
  • HTML (5 years)
  • CSS (5 years)
  • Excel VBA (10 years)
  • Excel (15 years)
  • PHP (3 years)
  • Javascript (2 years)

Specialties

    Project Management, Public speaking, Technical writing, Training

Spoken Languages

    English