In short
I taught high-school chemistry for seven years and kept ending up with the school’s spreadsheets. I finished a data analytics certificate in May and want an analyst role, in Columbus or remote, from January 2027.
Projects
01
Attendance early warning
Walnut Fork High School · 2024 to 2026
Which ninth graders will miss 18 days or more? Three years of attendance, about 151,000 rows, showed that the first 20 school days predict the rest. I built a list four counselors open each Monday. They made the calls. The list said whom to call first.
SQL, Python, a shared dashboard
18% → 13%of ninth graders chronically absent, in the first full year of the list
02
Where the lab budget goes
Science department, same school · 2025
Six teachers ordered supplies separately from a $38,000 budget. I cleaned 2,140 purchase-order lines and matched the same items bought twice or left to expire. The department now places one shared order a term.
Python, spreadsheets
$6,800a year in duplicate and expired stock, 18% of the budget
03
Saturday forecast for a food pantry
Northside Neighbors Pantry, volunteer · 2026
The pantry guessed its Saturday numbers and often ran short. I typed up 104 Saturdays of sign-in sheets, added school holidays and the day of the month, and tested a simple regression on the latest 12 weeks. They order produce from it now.
Python, linear regression, a one-page weekly printout
9%average miss over 12 Saturdays: about 14 households in a typical 160
Work
Chemistry teacher, Walnut Fork High School
Aug 2019 – Jun 2026
Five classes a year, about 140 students. Data lead for the science department from 2023. Explained variance to sixteen-year-olds every spring, which is good practice for explaining it to anyone.
Skills
- DailySQL with joins and window functions, Python for cleaning and charts, pivot tables
- StatisticsRegression, confidence intervals, reading an A/B test without fooling myself
- With peopleTurning a vague question into one the data can answer, then saying the answer plainly
Training
Certificate in Data Analytics
Franklin Park Technical College, evening program, September 2025 to May 2026
B.S. Chemistry, then a teaching license
Lakeshore State University, 2018 and 2019
Sample page. The names and numbers are made up.