---
description: Fictional entry-level data analyst project-first resume
template: resume
theme: accessible-high-contrast
paper: us-letter
margins: compact
fontSize: 9.8
lineSpacing: 0.64
titlePage: false
toc: false
headingNumbers: false
equationNumbers: false
columns: 1
header: ""
footer: ""
language: en-US
---

# Lucius Varro

New Cinna, Illinois | 312-555-0124 | lucius.varro@example.com | github.example.com/lucius-varro

## Entry-Level Data Analyst

Statistics graduate who uses SQL, Python, spreadsheets, and Tableau to clean data, test assumptions, communicate uncertainty, and turn analysis into decisions. Project work emphasizes reproducible queries, documented data quality checks, clear visualizations, and concise recommendations.

## Analysis Projects

### City Service Request Operations | SQL, Python, Tableau

- Cleaned and joined 128,000 fictional open-data service records across requests, locations, categories, and closure events; documented duplicates, missing coordinates, and inconsistent status labels.
- Wrote SQL window functions to compare median closure time by request type and service area while separating open cases from completed cases.
- Built a Tableau dashboard with volume, backlog, aging, and closure-time views; recommended staffing review for two categories with sustained backlog rather than treating raw request count as performance.

### Subscription Retention Cohorts | Python, pandas, Jupyter

- Analyzed a synthetic 24-month subscription dataset containing 18,400 accounts, plan changes, support contacts, and cancellation events.
- Defined cohort and churn rules before analysis, tested sensitivity to reactivations, and found that first-30-day product adoption separated retained and canceled cohorts more strongly than signup channel.
- Delivered a reproducible notebook, data dictionary, validation checks, and a one-page brief proposing an onboarding experiment rather than claiming causation from observational data.

### Campus Food-Waste Forecast | Excel, Power Query

- Consolidated 52 weekly inventory and meal-count files, standardized units, and reconciled source totals against the dining office ledger.
- Compared seasonal-naive and four-week moving-average forecasts; reduced holdout mean absolute error from 18.7 to 13.2 portions for the highest-volume meal category.

## Education

**B.S., Statistics, Minor in Economics** | Philippi Lakes University | May 2026

Relevant study: regression, experimental design, probability, database systems, data visualization, econometrics

## Experience

### Operations Assistant | Philippi Lakes University Library | New Cinna, IL

*September 2023-May 2026*

- Reconciled weekly room-use and equipment records, investigated exceptions, and maintained documented spreadsheet controls for a four-person operations team.
- Replaced a manual monthly summary with a Power Query workflow, reducing preparation time from approximately three hours to 35 minutes while preserving source-level review.
- Presented recurring demand patterns to library staff and helped revise evening equipment coverage for examination periods.

## Technical Skills

**Analysis:** SQL, Python, pandas, NumPy, Excel, Power Query, descriptive statistics, regression, experiment interpretation

**Visualization:** Tableau, matplotlib, seaborn, dashboard requirements, chart annotation

**Practice:** Git, Jupyter, data dictionaries, validation queries, reproducible notebooks, stakeholder summaries