Joshua Bernick
Chandler,AZ
Overview
19
19
years of professional experience
Work History
Manager
Walgreens
Scottsdale, AZ
03.2009 - Current
- Analyzed sales and inventory trends to optimize stocking strategies, enhancing product availability.
- Cross-trained employees to increase team agility and streamline operations.
- Tracked donation performance; insights contributed to doubling area Red Nose Day contributions to $80K.
Sports Ticketing Analytics Intern (Unpaid)
University of Wisconsin–Madison Athletics
Madison, WI
06.2025 - 10.2025
- Developed season-ticket renewal likelihood model using Python and Excel to enhance retention strategies.
- Segmented customers by renewal risk, informing targeted retention efforts.
- Presented insights in Tableau and Power BI to guide ticketing decisions.
Business Analytics Intern (Unpaid)
Crane & Hoist
Tempe, AZ
05.2024 - 05.2025
- Conducted trend analysis using Excel and Python to inform pricing decisions.
- Analyzed revenue, cost, and utilization data to pinpoint profitable services.
- Provided insights that drove a 20% increase in higher-margin jobs.
Ticket Broker
Self
Pittsburgh, PA
03.2007 - 10.2018
- Analyzed market demand through spreadsheets to identify optimal buy/sell opportunities.
- Monitored profitability using Excel models to evaluate ROI, margins, and sales velocity for improved financial oversight.
- Tracked ticket inventory, pricing trends, and sales performance in Excel to inform strategic decision-making across sporting events.
- Automated calculations with formulas to enhance efficiency in assessing pricing scenarios and profit potential.
Education
Bachelor of Science - Business Data Analytics
Arizona State University
Tempe, AZSkills
- Business Analytics
- Data Visualization
- Predictive Modeling
- Statistical Analysis
- Data mining
- SQL
- Python
- Excel
- Tableau
- Power BI
- Team leadership
Projects
March Madness Tournament Optimization
- Designed an optimization model using Python and Excel to evaluate tournament picks
- Calculated expected value by seed and round, modeling risk–reward tradeoffs
Football Game Outcome Prediction Algorithm
- Built a logistic regression model using Python to predict NFL game outcomes
- Engineered key variables and validated performance against a holdout dataset, outperforming a 50% baseline
Timeline
Sports Ticketing Analytics Intern (Unpaid)
University of Wisconsin–Madison Athletics
06.2025 - 10.2025
Business Analytics Intern (Unpaid)
Crane & Hoist
05.2024 - 05.2025
Manager
Walgreens
03.2009 - Current
Ticket Broker
Self
03.2007 - 10.2018
Bachelor of Science - Business Data Analytics
Arizona State University