Resume

Summary

Business intelligence and data-focused analyst with 6+ years managing reporting, forecasting, budgeting, and operational data workflows for federal public health programs exceeding $100M annually. Mathematics and Statistics background with experience in SQL, Python, Excel, requirements gathering, data cleaning, and translating stakeholder needs into reliable reporting and decision-support tools.

Technical Skills

• Programming & Data: SQL/SQLite, Python, pandas, FastAPI, JavaScript/TypeScript, React, Git
• BI & Analysis: Excel, forecasting, budget analysis, ad hoc reporting, data cleaning
• Data Workflows: requirements gathering, relational data modeling, ETL-style workflows, API design, CSV import/export
• Systems & Communication: Sage Intacct, Blackbaud, RuffaloCODY, documentation, training non-technical users

Selected Projects

Inventory Data Modeling & Reporting System

Magic: The Gathering inventory and valuation system
Case study | Public repository

• Built a full-stack inventory and valuation system using Python/FastAPI, SQLite, and TypeScript to ingest external card and pricing data, normalize records, track holdings, and produce auditable valuation reports.
• Designed relational data models and ETL-style workflows for pricing, valuation, import/export, bulk updates, data validation, and per-edit audit logging.
• Developed documented API contracts and reporting workflows to support searchable inventory, inline editing, transaction-style updates, and stakeholder-facing views.

Budget Forecasting Workflow Redesign

Structured Excel reporting workflow for public health grant management
Case study

• Replaced Word-based budget templates with a structured Excel workflow that improved data consistency, reduced user error, and shortened review cycles.
• Standardized recurring budget development and reporting processes for program and finance stakeholders.
• Created documentation and training materials to help non-technical users work more reliably with complex federal requirements.

Federal Public Health Emergency Funding & Reporting Project

APHL / CDC - $170M+, fully funded
Case study

• Orchestrated development of a fully funded $170M+ emergency COVID-19 cooperative agreement proposal to CDC under a two-week deadline.
• Consolidated budgets, workplans, and federal application materials across approximately 18 projects and 5 program directors into a unified submission package.
• Supported expansion of public health laboratory testing, workforce, data fellowship, and informatics infrastructure through an executable budget and workplan.

Experience

Association of Public Health Laboratories (APHL)

Senior Specialist, Grants Management
January 2024 to February 2026

Specialist, Grants Management
January 2022 to December 2023

Associate Specialist, Grants Management
January 2020 to December 2021

Senior Tech, Infectious Disease (Temp to Hire)
August 2019 to December 2019

• Managed budget administration, recurring reporting, and monthly forecasting for federal grant portfolios supporting $100M+ annually across approximately 50 funded projects.
• Produced recurring and ad hoc budget reports, forecasts, and analyses to identify trends, surface planning risks, and support allocation decisions.
• Gathered requirements from program and finance stakeholders and translated project-level plans into consolidated budgets, reports, and application materials.
• Built a structured Excel budgeting workflow to replace Word-based templates, improving data consistency, reducing user error, and shortening review cycles.
• Created SOPs, reference materials, and trainings that standardized reporting procedures and helped non-technical staff navigate complex federal requirements.

Grinnell College, Office of Development and Alumni Relations

Assistant Director of Annual Giving for Phonathon
August 2016 to August 2018

• Raised approximately $400K annually from 1,500+ donors through targeted outreach and team execution.
• Supervised 35 callers, including hiring, training, feedback, scheduling, and team operations.
• Managed and cleaned a 12,000+ record calling database and produced recurring reports using RuffaloCODY Campus Call Software.
• Used segment-level analysis to prioritize outreach and improve fundraising returns.
• Restructured incentive programs, contributing to a 50% increase in recurring gifts from FY17 to FY18.

Mathematics Department, Grinnell College

Research Assistant
May 2015 to August 2015

• Applied graph theory techniques to analyze integer relationships and produce new results in Ramsey Theory.
• Won Outstanding Presentation at the Joint Mathematics Meetings Undergraduate Research Poster Session.

Mathematics Grader
January 2014 to December 2015

• Evaluated proofs for combinatorics courses and strengthened precision in mathematical communication.

Phonathon Program, Grinnell College

Student Manager
September 2013 to May 2016

• Recruited and trained callers, provided performance feedback, and supported team operations.

Service & Activities

Cryptoparty, Code for America, Washington, D.C.
Guest Lecturer, September 2018 to November 2018

• Presented accessible lectures on Diffie-Hellman key exchange and RSA encryption for non-technical audiences.

Grinnell Singers
2012 to 2016

• Sang bass in the college choir.

Education, Leadership & Honors

Grinnell College
B.A., Mathematics and Statistics, May 2016

• Swan Memorial Scholarship at Grinnell College, awarded in 2015.
• APHL Leadership Academy, Class of 2023.
• Outstanding Presentation, Joint Mathematics Meetings Undergraduate Research Poster Session.