Recent grad with one internship
A statistics new grad with a single summer internship and two course projects. The resume works because the internship bullets read like an analyst's, not an intern's: a row count, a before-and-after on time saved, and a finding the team acted on. The one bullet that hurts it is the catch-all 'helped with tasks' line.
Jenna Castillo
Education
Experience
- Built a Tableau dashboard on a 1.2M-row Postgres orders table; cut the ops team's weekly reporting from about 6 hours of manual Excel work to a 20-minute self-serve view that is now their default Monday review.
- Wrote 30+ SQL queries to segment 84k customers into retention cohorts; surfaced a 3-month churn cliff in the small-business segment the team had not measured, which became the basis for a retention email test.
- Automated a Friday Excel reconciliation in Python (pandas); reduced a 90-minute manual task to a 4-minute scheduled script and removed two recurring copy-paste errors that had been corrupting the weekly numbers.
- Helped the marketing team with various data and reporting tasks as needed.
Projects
- Cleaned and analyzed 8M service-request rows in pandas; built a Tableau view showing a 4-day median response gap between the highest and lowest income ZIP codes, written up in a short public report.
- Joined the 311 data against Census ZIP-level income data and ran a two-sample t-test confirming the response-time gap was statistically significant (p<0.01); posted the joined dataset and query as a public GitHub gist.
- Designed a 40-question survey, collected 310 responses, and ran the regression that became the graded capstone; presented findings to a panel of three faculty.
- Ran a stepwise OLS regression identifying meal-plan status and commute distance as the two strongest predictors of monthly spending (R² = 0.34); the finding was cited in two classmates' capstones the following semester.
Technical Skills
One real internship is enough if every bullet names the data size, the tool, and what changed because of the work. Lead with the dashboard or query that someone still uses. Cut anything that starts with 'helped' or 'assisted'.
