Breaking Games logoCurrently an Extern @Breaking Games·🟢 Open to work
Li Wan portrait

Aspiring Data-Driven Strategist

I'm currently honing my skills at Wayfair, focusing on AI Agent & Automation to make impactful decisions.

Work samples

Discover my work in operational strategy and analytics, showcasing my journey and the skills I've developed along the way.

  • Amazon Operational Strategy & People Analytics Externship
    Amazon Operational Strategy & People Analytics Externship
    Amazon logo

    Amazon · Jul 2026 · ✅ Verified by Extern

    Amazon Operational Strategy & People Analytics Externship

    Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90. You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely. It’s part research, part strategy—and all about learning how people data drives big decisions.

    Top performerData AnalysisPythonStrategyOperations
  • Wayfair n8n AI Agent Engineering Externship
    Wayfair n8n AI Agent Engineering Externship
    Wayfair logo

    Wayfair · Aug 2026 · ✅ Verified by Extern

    Wayfair n8n AI Agent Engineering Externship

    Learn one of the most in-demand skills shaping the future of work: building AI agents. In this externship, you’ll step into the role of an AI Agent Developer and use n8n to design agents that think, plan, and act on real data — automating insights, decisions, and workflows. No coding experience required. By the end, you’ll create a live dashboard powered by your own AI agents, gaining hands-on experience that applies to any role or industry — from marketing and consulting to product management and data science.

    AI Workflow DesignAI Agent DevelopmentPresentation SkillsWeb Scraping & Data Extraction

About me

I'm currently honing my skills at Wayfair, focusing on AI Agent & Automation to make impactful decisions.

I am an aspiring professional currently gaining experience through an externship at Amazon in Operational Strategy and People Analytics. Eager to officially launch my career, I am passionate about leveraging data to drive strategic decisions and enhance operational efficiency.

Externships

SQL & Database Architecture Externship with Breaking Games

Breaking Games

Experience

Wayfair - AI Agent & Automation Extern

Extern · Jul 2026 - Aug 2026

Amazon - People Analytics & Operations Strategy Extern

Extern · May 2026 - Jul 2026

Lead Orientation Leader

Berkeley International Office · Aug 2024 - Jul 2026

Data & Product Analyst Intern

Appa Health · Oct 2025 - Dec 2025

Research Analyst

University of California, San Francisco (UCSF) · Oct 2025

Scheduling & Front Desk Operations Staff

Berkeley City College · Oct 2021 - May 2023

Education

University of California, Berkeley

B.A. Data Science · Class of 2025

Skills

Data AnalysisOperational StrategyPeople AnalyticsProblem SolvingStrategic ThinkingAIAI Agent DevelopmentAI Workflow DesignAI-Driven InsightsAI Powered AnalyticsAR/VRArtificial IntelligenceChatGPTCanvaBusiness StrategyCampaign ManagementData ScienceData AnalyticsData VisualizationData Storytelling

✅ Verified by Extern

Amazon Operational Strategy & People Analytics Externship

Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90. You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely. It’s part research, part strategy—and all about learning how people data drives big decisions.

Data AnalysisPythonStrategyOperations

Overview

The work mapped floor roles, cleaned and analyzed employee feedback from Glassdoor and YouTube, and produced cohort-level summaries and a pilot-ready intervention. Deliverables included a role spreadsheet, cleaned review CSV, sentiment-processed text, a root-cause tree, cohort segmentation of 139 reviews, and a 5-slide pilot deck. The work was awarded Top Performer by Amazon.

Amazon Operational Strategy & People Analytics Externship
Google Slides
Access

What I've accomplished

I delivered a structured role spreadsheet, a cleaned CSV of Glassdoor and YouTube feedback, a cleaned_text column with sentiment-ready examples, a root-cause tree for Scheduling and Physical Exhaustion, a 139-review cohort segmentation with priority rankings, and a 5-slide pilot deck proposing a zone-led rest point and break-entitlement cards.

Top performer

Project breakdown

View all works

✅ Verified by Extern

Wayfair n8n AI Agent Engineering Externship

Learn one of the most in-demand skills shaping the future of work: building AI agents. In this externship, you’ll step into the role of an AI Agent Developer and use n8n to design agents that think, plan, and act on real data — automating insights, decisions, and workflows. No coding experience required. By the end, you’ll create a live dashboard powered by your own AI agents, gaining hands-on experience that applies to any role or industry — from marketing and consulting to product management and data science.

AI Workflow DesignAI Agent DevelopmentPresentation SkillsWeb Scraping & Data Extraction

Overview

The externship taught AI agent development with n8n focused on generating visual outputs from prompts. The work set up agent workflows and produced concrete artifacts, including a production-style prompt for a premium Organic Modern rug moodboard that specified layout, lighting, color codes, lens guidance, material close-ups, and export constraints.

Wayfair n8n AI Agent Engineering Externship
Google Drive
Access

What I've accomplished

I wrote a production-grade prompt that generated a premium Organic Modern rug moodboard, specifying layout, lighting, exact color codes, lens and shot guidance, material close-ups, and export constraints.

Project breakdown

View all works

✅ Verified by Extern · ⏱️ In progress

SQL & Database Architecture Externship with Breaking Games

Turn six messy CSVs into an analytics database and a Q4 dashboard that drives real business decisions. SQL + Claude.

Analytics Database DesignData AnalysisSQL FundamentalsData Storytelling

Overview

The externship converted six messy CSVs into a structured analytics database and built a Q4 dashboard for Breaking Games. The work mapped each data source, designed ingestion and schema patterns, and prepared queries for dashboard metrics. Delivered artifacts included the cleaned database schema and dashboard-ready SQL queries.

SQL & Database Architecture Externship with Breaking Games

What I've accomplished

I delivered a cleaned schema and a Week 1 Holiday Game Plan that included a data inventory, five 'instant answer' SQL queries, and documented JOINs and product-traffic queries for use in the Q4 dashboard.

Project breakdown

On Week 1 I inventoryed six data sources, ran SQL queries against the SQLite database, and produced five instant answers (top products by units and revenue, product count, total Meta ad spend, unique checkout sessions).

Google Docs
Access

I consolidated four messy spreadsheets by building dim_product, added product_id keys, joined sales and traffic tables with INNER and LEFT JOINs, and produced fact_product_performance plus a reorder recommendation based on aggregated revenue and units sold.

Google Docs
Access

I audited raw ad and referral data, built a dim_referrer taxonomy from 421 strings into seven channels, calculated campaign CTR/CPC/ROI, and produced a Q4 ad allocation plan with keep/cut recommendations based on attributed sales and spend.

Google Docs
Access

The project reviewed checkout data, tested hypotheses about bots and shipping friction, built a clean_checkouts view to filter automated noise, and recalculated abandonment rates with bots removed, producing a diagnosis report and recommendations.

Google Docs
Access
View all works