TECHNICAL SKILLS

 

SQL, Python (Pandas, NumPy, Matplotlib, Seaborn, scikit-learn, BeautifulSoup, Nltk), Microsoft Excel, Google G-Suite, Tableau, Data Wrangling, Exploratory Analysis, Hypothesis Testing, Modeling, Data Visualization, Regression Analysis

 

​

TECHNICAL PROJECTS

 

Amazon Review Scraper and Analysis

 

• Built a web scraper using Python to retrieve correct data from a mass of HTML and store review data into a CSV for a single item on Amazon

• Scraped 180,000 reviews for the Amazon Fire Stick and stored them in a CSV in preparation for analysis

• Analyzed the review data which resulted in finding the most common issue reviewers have (which was less than 3% of all reviews) is with the remote

 

 

Instacart

 

• Munged one million rows of data in SQL to find what attributes have the greatest effect on decreasing days between orders for individual users

• Constructed subqueries in SQL to calculate each order date from last order date and days since last order

• Joined 8 tables in SQL to form one table with all relevant information in preparation for analyzing and visualizing in Tableau

• Ran statistical analysis in Tableau to determine the 4 factors that most influence days between orders

• Ultimately I recommended gathering more data because the correlations were not statistically significant

 

 

Star Wars Box Office Sales

 

• Cleaned 1000+ rows of data in SQL in preparation for constructing a report

• Calculated a running sum of total box office sales day to day with subqueries constructed in SQL

• Joined 4 tables in SQL including inner joins, to form one table as a report on box office takings by day for each film

 

 

The Data Behind Electric Automobiles

 

• Pulled datasets from Data.gov, The World Bank, and other sources for the purpose of investigating why the electric automobile has become a viable industry in the last 20 years

• Cleaned over 40,000 rows of data in Excel and joined 4 datasets to make visualizations in Tableau

• Discovered that the electric automobile industry has become a reality because of government support

 

 

WORK EXPERIENCE

 

Maintenance Technology Systems

Data Collection Technician

Manti, UT

January 2017 - Present

 

• Specialized in machinery vibration data; focused on the quality and efficiency of collection

• Created a streamlined process that cut manual assembly time on one of our circuit boards from 90 minutes per unit down to 40 minutes per unit

• Performed market research and priced items to move in order to liquidate $14,000 worth of obsolete inventory that would have gone to the landfill otherwise

 

​

LEADERSHIP EXPERIENCE

 

Badger Mountain Ropes Course

Assistant Supervisor

Ephraim, UT

May 2017  - August 2017

 

• Supervised 20 facilitators of 350+ youth that came to the ropes course each day

• Ensured safe practices by giving feedback to facilitators frequently on their safety practice and facilitation of learning

 

EDUCATION

 

MissionU (Part of WeWork)

San Francisco, CA

Jan. 2017-Aug. 2018

Studied: Data Analytics & Business Intelligence

 

Snow College

Ephraim, UT

Aug. 2016- Apr. 2017

Studied: Communication