Work Experience

Lucid Motors logo Analytics Engineer - Product Marketing (Co-op) at Lucid Motors

  • Identified and implemented a production process change that reduced installation cycle time by 70% and enabled over $1M in annual savings from productivity gains, winning the company Shark Tank (organizational and executive vote).
  • Built reusable analytics workflows and self-serve tools (including a text-to-SQL AI agent) that enabled non-technical stakeholders to access market and performance insights faster.
  • Automated Consumer New Vehicle Survey visualization with a Polars-based data pipeline and Excel model, replacing manual workflows and accelerating product pricing decisions.
  • Prepared and presented competitive analysis reports to senior leadership and executives for IAA Mobility 2025 and LA Auto Show, informing data-driven marketing plans and vehicle design decisions.

University of Washington logo Energy Engineer at University of Washington

  • Created reports on utility spending and quantified savings from energy efficiency measures.
  • Designed a database schema for building, meter, energy-use, and financial data to support a virtual campus energy model.

McKinsey & Company logo Data Analyst 1 at McKinsey & Company

  • Led product ownership of a tech talent survey analytics pipeline, defined requirements, designed ETL workflows and Tableau dashboards, and tracked outcomes across 20+ client projects.
  • Cut report delivery time by over 90% by building a custom Python application to automate recurring analytics report generation.
  • Deployed a Mixed Integer Programming optimization tool that informed initiative prioritization decisions across 5 McKinsey RTS studies.

McKinsey & Company logo Junior Data Analyst at McKinsey & Company

  • Overhauled database setup and ETL pipelines for ITSM datasets across 10+ client transformations, adding KPIs and statistical analysis that supported client productivity improvements.
  • Delivered IT cost optimization recommendations on the "Ignite" diagnostic product, including talent hiring strategy and the case for helpdesk automation through RPA.
  • Reduced data preparation costs by 65% by automating ITSM data cleaning with Alteryx workflows, cutting turnaround time by 80%.

McKinsey & Company logo Solution Delivery Intern at McKinsey & Company

  • Automated ITSM analysis with Alteryx workflows, reducing turnaround time by 80% and lowering data preparation cost versus manual Excel workflows.
  • Worked as a business analyst for an internal web application by gathering requirements with stakeholders and helping run UAT sessions.

Featured Projects

Highlighting selected projects. View all projects & achievements →

Sequel2SQL

Capstone project to improve SQL error correction with an LLM-based workflow for PostgreSQL.

  • Defined the architecture and built an LLM scaffolding that improves SQL error correction through a custom database toolkit, improving baseline performance by 6% on the BIRD-CRITIC benchmark.

Read more about this project →

E-Commerce Analytics Pipeline

Serverless analytics pipeline for e-commerce events using AWS and Spark.

  • Built a serverless medallion pipeline processing 500K+ e-commerce events on hourly and daily cadences, with pre-aggregated tables for faster downstream analysis.

Read more about this project →

Automated Vaux's Swift Counter

Computer vision pipeline for counting birds in a conservation use case.

  • Built a multi-stage pipeline using YOLOv11, SAM2, and custom trajectory tracking.
  • Developed for the Courtenay Museum's Vaux's Swift conservation project.
  • Reached over 90% accuracy in low and medium traffic scenarios.

Read more about this project →

Online Engagement & Review Behavior Study

Statistical study on how business responses are associated with review activity.

  • Analyzed 760K+ Google reviews using matched treatment/control groups and paired t-tests; businesses that responded to reviews were associated with 9 additional reviews on average versus non-responders.

Read more about this project →

Quizzatron

Web app that generates quizzes from prompts and documents using LLMs.

  • Built a quiz generation app in Streamlit with Google Gemini models.
  • Converted prompts and PDFs into interactive quizzes.
  • Used by classmates for faster practice-question creation.

Read more about this project →