Data/ERP Analyst
- GitHub - The Halfling
- https://github.com/Thehalfling
- The Halfling
- https://www.thehalfling.com
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