Devon Asare — Data Analyst
Columbus, OH
Data analyst six months out of a full-time analytics program, working a part-time contract while looking for a first full-time role. Built the donor-retention dashboard a 9,000-name file had never had, and spent five years before that turning a dental practice front office into numbers people acted on.
Experience
Data Analyst (part-time contract), Hilliard Trails Conservancy · July 2026 – present
20 hours a week for a land trust with a 9,000-name donor file.
- Built the retention dashboard the organization had never had, showing that 38% of lapsed donors left after a single gift.
- Deduplicated the donor file against 11 years of event records, removing 1,340 duplicate households before a mailing that cost $0.62 apiece.
- Automates the monthly board report in Python; the previous version took a volunteer six hours to assemble by hand.
Practice Manager, Glenmoor Family Dentistry · August 2020 – December 2025
Scheduling, billing and a six-person front office for a practice seeing 140 patients a week.
- Cut no-show appointments from 14% to 5% by rebuilding the reminder schedule around when patients had actually booked.
- Recovered $58,000 in denied insurance claims in two years by tracking denial reasons nobody had recorded before.
- Renegotiated the supply contract after charting 18 months of usage, taking $9,400 a year out of consumables.
Projects
- Columbus bus reliability — Capstone: where the delays on a city transit system actually come from.
- Ohio small-business lending gap — Federal loan disclosures joined to county business counts.
Education
- Certificate Data Analytics, full-time program · Riverlight Data Academy · January 2026 – June 2026
- B.A. Communication · Ohio University · August 2016 – May 2020
Skills
- Analysis: SQL, Python (pandas), Excel, Cohort analysis, A/B testing, Regression
- Visualization: Tableau, Power BI, Matplotlib, Dashboard design
- Data handling: PostgreSQL, Data cleaning, Record deduplication, ETL scripting, Google Sheets
Certifications
- Microsoft Certified: Power BI Data Analyst Associate — Microsoft
