Dat Analyst

Daniel X. Zhou

*** *. ******** **, 765-***-****

Mountain House, CA 95391 ******.********.****@*****.*** OBJECTIVE:

Seeking a full-time position in a Data Scientist role. EDUCATION:

Iowa State University, Ames, IA May 2019

Master of Science in Aerospace Engineering GPA: 3.52/4.0 Purdue University, West Lafayette, IN May 2014

Bachelor of Science in Aerospace Engineering

TECHNICAL ABILITIES:

C Statistical Modeling GD&T

Python Predictive Analysis Catia V5

SQL Big Data Solidworks

MATLAB Data Mining Autodesk Inventor

Tableau Machine Learning NX7.5

Oracle Applications Supervised Learning Avizo 7

IQMS Manufacturing ERP Natural Language Processing Statistical Process Control

Oracle RDBMS Cross Validation Gage R&R

MS SQL Server Random Forest Forgings

MS Office Support Vector Machine Castings

AS/400 Neural Network Automotive

UNIX Boosting Global Supply Chain

RESEARCH EXPERIENCE:

Graduate Research Assistant in Aerospace Engineering Department Ames, IA Iowa State University 7/2017-5/2019

● Compared various machine learning algorithms to predict airplane utilization rates with, resulting in as much as 28% improvement in test RMSE compared to a rolling average baseline, or 78 hours more accurate each month

● Developed a script via Python to automate downloads of historical airline raw data from public domains and to compute airplane utilization hours from the raw data

● Performed trend analysis of airplane utilization rates to aid maintenance and fleet planning decision making PROFESSIONAL EXPERIENCE:

Data Analyst Oakland, CA

Fairn & Swanson Inc 10/2019-Present

● Developed a tool using a fuzzy string matching algorithm to associate identical products together in a database of more than 60,000 SKU items, saving cost through the purchase of the lowest priced items

● Developed random forest and boosting decision tree regression models to improve upon the accuracy of the current forecasting tool

● Developed scripts for data extraction, transform, load (ETL) via SQL and Python to query and compile training data used for product depletion predictions

● Created automation tools that drive financial analysis and decision making, via computing bill backs by vendor, and forecasting and visualizing expiring inventory levels and depletion rates

● Created reports that provide insights into current inventory levels across multiple warehouse locations, amount of sales in wholesale and retail business units, incoming and outgoing shipments, in addition to open and closed purchase order tracking

● Created an Open-To-Buy template to guide inventory replenishment strategies for each upcoming fiscal year Zhou, D. Page 2

PROFESSIONAL EXPERIENCE (cont’d):

Data Analyst/Inventory Analyst Hayward, CA

Plastikon Industries 6/2019-10/2019

● Performed ETL on production data and created data visualizations that drive operator performance, resulting in worst performing employees becoming best performing employees

● Created data visualizations from raw financial data to steer inventory storage and planning, resulting in the reduction of raw material floor space usage by 50%

● Performed ETL on quality related data to create data visualizations that drive business intelligence on scrap reduction efforts

● Managed inventory control and purchasing duties through data analytics to keep production for automotive components for Tesla and Toyota running daily without interruptions Inventory Control Supervisor Des Moines, IA

Titan Tire/Goodyear Farm Tires 8/2018-6/2019

● Utilized random forest, support vector regression, neural network and boosting models to predict rubber orders, resulting in up to 23% improvement in accuracy, or 120,000 lbs per month, when compared to the current prediction program using real-time information

● Developed scripts via SQL and Python to query and compile training data used for rubber order predictions

● Assisted with developing a real-time inventory system and database for raw materials to track movement of stock

● Supervised six union employees to support daily forecasting and inventory control operations Intern-Operations Analyst/Manufacturing Engineer Baldwin, WI Donaldson Company 3/2018-8/2018

● Developed an automation script via Python to update labor hours on the production floor, reducing computation time from 3-4 days, to under 2 hours

● Utilized support vector regression and random forest decision tree models to forecast future labor hours, resulting in close to $200,000 in annual cost savings and 6,000 hours improvement over current labor hour forecasts each year

● Recommended a new design process and developed a new fixture for a part, resulting in a 8 minute reduction in manufacturing time, and cost savings of over $20,000 annually

● Managed capital equipment projects of over $30,000 in expenditure for new purchases

● Reviewed and revised engineering changes to current existing products, and created routing information and bill of materials for newly introduced products

Supplier Quality Engineer Albion, IN

Dexter Axle Company 9/2014-8/2016

● Identified defective supplier manufacturing processes, resulting in a 20% drop on average in non-conformance

● Initiated new projects with current and new suppliers by offering technical assistance during first article inspections, resulting in $10,000 in cost savings during trial production run for one part number

● Audited current suppliers and vetted new suppliers based on the ISO 9001:2008 quality management system

● Assisted with weight reduction of parts by using Finite Element Method to save $90 annually on one part number

● Submitted validation gage designs to suppliers for adoption in their manufacturing processes

● Developed a subjective mathematical model with which to rate suppliers Intern-Analytical Methods Models Seattle, WA

The Boeing Company 5/2012-8/2012

● Developed and programmed a Bayesian Network Model via MATLAB

● Used Regression, Bayesian Network and Neural Network to forecast airline response up to 50 years

● Evaluated and analyzed different statistical models and recommended the most accurate

Contact this candidate