Data analyst

Callum Osei

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

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.