📈 Rob Margherio Email & Phone Number

• Analyzes student and instructor feedback on our course material to identify issues or areas of clarification to support student learning
• Tests, validates and implements new changes to course material to make sure new content has little impact on student progression in the course experience

• Provide student’s guidance when facing trouble on assignments or specific concepts (in Google Sheets, MySQL, Tableau, Statistics, or Python) via virtual office hours or student email responses
• Grade student assignments on a weekly basis, providing industry backed feedback to grow student’s thinking of their assignments and the value they bring to future roles as data analysts

St Louis, Missouri, United States

• Order produce from farmers to share with our customers via customized boxes, using R Shiny dashboard/Google Sheets file to understand historic availability/purchase history
• Created a Google Sheets Food List document for compiling over 15 different farmers’ produce amounts which drives share offering decisions to an average 400 weekly members. This document saves 1 hour per week through.
• Enhanced Food List document in Google Sheets to provide full inventory as well as all items sold to create a one-stop shop for CSA decision making, which saves an additional 30 minutes per week

• Published a freight metrics report (using SQL, Alteryx & Tableau), which is monitored weekly by a dedicated freight team to track monthly spend, combining eight different vendor data sources
• Analyzed multiple time series models (ARIMA & ETS) for predicting freight spend & shipments across four different freight groups (totaling to eight different models to analyze) to assess if end of year goals would be.
• Implemented an unsupervised learning model (KNN) on individual freight shipments to identify groupings in shipments, on multiple numeric variables, to identify outliers (using R, Alteryx & Tableau)
• Created a hospital dining dashboard to monitor spend across 14 different health service organizations which was used to identify cost savings opportunities through price benchmarking

• Created an automated data capture process from multiple databases (Databricks, DB2 & PostgreSQL) to support a cross-functional parts predictive forecasting pilot project, which reduced customer downtime by having the.
• Produced two reports that use market basket and network analysis to transform data into new John Deere Expert Alert insights for an enterprise user group
• Led prioritization process for one of my team’s project lanes, in which I collaborated with and guided team members toward achievable projects with accurate deadlines that met our stakeholder’s priorities
• Compared two statistically similar enhanced data sets to quantify the value of John Deere Connected Support Expert Alerts, which showed value for customers, dealers and the company through proactive data-driven.

• Utilized data visualization techniques to mine customer telematics data and present findings to drive new product design decisions
• Led data quality efforts to monitor customer telematics data, which assured consistent and reliable data to customers
• Completed validation of a new enterprise notification system to monitor customer machine data and automatically notify dealers of impending failures
• Designed a data driven dashboard that uses telematics data and a patented algorithm to prioritize dealer fleets for the most “sick” machines to help dealer service departments prioritize work

Waterloo, Iowa Area

• Worked with technicians on over 70 cases to diagnose root cause of complaints in the field on multiple system areas with quick response times to maintain customer satisfaction
• Enhanced early problem resolution process by combining multiple data sources (warranty, telematics and product information) into one report that identifies issues earlier for product support teams

Waterloo, Iowa Area

• Developed class material to train 17 cross-functional stakeholders within our platform how SQL, Tableau and John Deere telematic systems work and ways to utilize this data in their daily jobs
• Prepared ad-hoc and production reports based on internal user requests using visualization tools (such as Tableau) and advanced custom SQL queries

Waterloo, Iowa Area

• Identified and analyzed hydraulic price savings and flow optimization opportunities on the new 8R series tractor using a decision matrix to prioritize potential modifications
• Designed hydraulic schematic for a new modular power unit that would help increase power on large agricultural equipment in the field

Silvis, IL

• Product Engineer, John Deere, summer intern:
• Developed hydraulic schematics, assisted in designs in ProE, and worked on concept pricing on a folding corn head support system
• Investigated and collaborated with an outside consultant on optimizing the new S-series combine hydraulic reservoir system

Master’S Degree, Data Science

UW LaCrosse’s MSDS program focuses on making a well-rounded data scientist. Topics covered: statistical methods, data modeling, database.

Bachelor Of Science (B.S.), Mechanical Engineering

Activities and Societies: Member of Mizzou Hydrogen Car TeamI was a part of the Mizzou Hydrogen Car team for four years. One of those four.