Analytics In Action

Results That Matter

Each project highlights how I combine technical tools with industry expertise to solve business-critical problems.

I specialize in benefits and compliance data, but my analytical process is transferable to a wide range of organizational challenges.

Employee Tenure Case Type Analysis

Tools: SQL, Excel

Question: How does the frequency of cases vary across tenure ranges?

Insight: Employees with over 3 years of tenure are involved in fewer total cases overall

Full Project: HR Trends

Employee Database Management

Tools: SQL

Schema Design: Tables for employees, salaries, departments, job titles, and relationships

Outcome: Organized information at your fingertips

Full Project: Employee Data

Tumor Volume Analysis

Analysis: Drug efficacy in mice

Tools: Python (Pandas, Matplotlib, SciPy, statistical summaries, box plot)

Scope: 249 unique mice, each monitored over time for tumor growth

Outcome: Capomulin and Ramicane showed the most consistent tumor volume reductions

Full Project: Lab Stats

Minimizing Strain on Systems

Problem: System Overload During Open Enrollment

Tools: Excel (AbleBits add-in), internal reporting

Workflow Optimization: Developed macro-based workflow to streamline uploads

Outcome: Prevented system crashes and reduced manual load time, protecting enrollment timelines

Boosting Participant Education

Problem: High support volumes (1,300+ participant emails, 200+ calls/day)

Process: Identified repeat inquiries and developed education materials to fill gaps. Also implemented ongoing education meetings.

Tools: Excel (log analysis), content creation, process design

Outcome: Reduced repeat inquiries, increased participant confidence, improved internal consistency, and decrease in lost participant funds at end of year.

Full Project Breakdown: Root Cause Analysis

Interested in more details? Want to make a project request? Contact me to get started!