Transforming complex datasets into decisions. Python, SQL, and Tableau practitioner with applied experience in education analytics, macroeconomic research, and program performance.
Investigated and corrected compromised academic data for a multi-school district. Identified anomalous test score records, replaced invalid entries with NaN using Pandas, and recalculated district-wide and school-level summaries — including pass rates by spending, school size, and school type — to restore data integrity before reporting.
Built a Python script to audit a 369,711-record election dataset for a Colorado congressional district. Automated calculation of candidate vote totals and percentages, county-level turnout analysis, and winner determination. Script designed for reuse across any future election dataset with no code changes.
Analyzed rideshare performance data across urban, suburban, and rural city types from January–May 2019. Computed total rides, total drivers, average fares per ride and per driver by market segment. Built multi-line time series charts with Matplotlib to surface seasonal fare trends and inform market strategy recommendations.
Analyzed 4,000+ Kickstarter campaigns to surface success patterns for theater plays. Built pivot tables segmenting outcomes by launch month and funding goal range. Used COUNTIFS() and percentage calculations to identify optimal launch windows and funding thresholds, visualized through line charts with trend interpretation.
Designed and maintained an interactive Tableau dashboard tracking student outcomes and program KPIs for a nonprofit serving 450+ students in Zambia. Conducted data cleaning and transformation using Python and SQL; produced quarterly reports used by leadership for evidence-based curriculum and resource decisions.
Contributing analyst for zambiamacro.ai, a macroeconomic signal research engine tracking Zambia's copper-hydrology-FX-debt transmission loop. Collaborated on indicator logic review and framework validation for the Energy-Debt Reserve Competition Ratio model, a composite index designed for sovereign stress assessment.
Open to data analyst, research analyst, and public sector data roles in the Sacramento region and beyond. Available for immediate discussion.