Data Analyst Analytics

JOSH BARRETT

Dover, MA 508-***-**** ************@*****.*** LinkedIn Portfolio

TECHNICAL SKILLS

● Software: Microsoft Excel, Python, R, Tableau, Power BI, SQL, PowerPoint, Adobe Suite, QuickBooks

● Data Methods: Statistical Analysis, Data Visualization, Data Cleaning, Modeling, A/B Testing, Hypothesis Testing (t-tests, z-tests), Forecasting

● Additional Tools: Project Management, Business Intelligence, Report Generation, Data Discovery and Exploration

PROFESSIONAL EXPERIENCE

Chegg Skills 04/2024 – 11/2024

Data Analyst

● Produced and delivered data analytics projects focusing on business forecasting, price modeling, and statistical analysis.

● Developed expertise in tools and systems such as Pandas, PostgreSQL, Tableau, and Python to clean, wrangle, and analyze data.

● Designed and implemented key projects:

Health Analysis: Leveraged Python modules (Pandas, Seaborn, SciPy) to uncover correlations between obesity and health outcomes.

Housing Market Study: Conducted statistical significance testing (t-tests, z-tests in Excel) to analyze the effect of vinyl siding on property values.

Covid-19 Country Comparison: Built Tableau dashboards to visualize and compare pandemic response strategies across countries.

Revenue Growth Model: Designed Excel-based models for a rental car business, showcasing profit optimization strategies and achieving a projected 20% revenue increase.

● Built performance dashboards to streamline reporting and improve decision-making. Simon the Tanner 01/2018 – 09/2023

E-Commerce Specialist, Inventory Data Manager

● Established and scaled eBay and Amazon seller accounts, developing and executing targeted marketing strategies that drove annual online sales growth to surpass $200,000.

● Spearheaded inventory management for a diverse catalog of hundreds of product lines, utilizing advanced Excel functions (pivot tables, VLOOKUP, conditional formatting) to optimize stock levels, reduce overstock by 15%, and ensure seamless product availability.

● Conducted in-depth sales trend analysis and created actionable insights to guide strategic marketing campaigns, resulting in a 20% increase in conversion rates and improved customer retention. Parchment Press, Various Schools 09/2000 – 12/2017 Math and Statistics Teacher, Administrator, Curriculum Developer

● Taught advanced mathematics and statistics to middle and high school students, including AP Calculus.

● Developed and implemented curriculum for grades 1 through 12, impacting hundreds of educators and students.

● Oversaw educational programs for 100+ students, maintaining communication with stakeholders to ensure program success.

EDUCATION

Harvard University EdX — Online

Professional Certificates in Data Analytics (04/2024 – 10/2024)

● HarvardX CS50: Programming with Python

● Data Science: R Programming Basics

Clark University — Worcester, MA

B.A., Mathematics and Statistics, summa cum laude, GPA: 4.0 (06/1994)

Contact this candidate