Analysis
Excel, SQL, SQLite, Python, pandas, scikit learn
Used in the SQL reporting, customer segmentation, market research, or operations cases.
Skills & methods
Skills and how I use them.
These are the tools and methods behind my projects. The examples explain what I used each one for and link to the work.
Browse focus areas ↗Analyze & validate
Work from records to a finding that can be checked.
Excel · SQL / SQLite · Python · pandas · scikit learn
Validated SQL joins for 99 products, reconciled customer and category totals, and compared five K means configurations.
Research & understand customers
Combine context, behavior, and competitor research.
Market research · Customer segmentation · Competitive analysis
Connected 2,857 stakeholder records with regional research. Summarized market trends in reports and moodboards.
Measure & experiment
Connect a testable question with a defined outcome.
A/B testing · Campaign audits · KPI definition · Engagement analysis
Tested 50+ ad variations, audited 122 posts and email sends, and identified a campaign measurement gap.
Report & communicate
Explain the finding and why it matters for a decision.
Plotly · HTML / Chart.js · Google Sheets · PowerPoint · Google Slides
Built a five KPI dashboard, presented market research, and revised expansion slides after staff feedback.
Position & collaborate
Connect customer needs with messages and product priorities.
Positioning · Benefit focused copy · Product roadmapping · Feedback synthesis
Rewrote product copy from competitor research and worked with developers to prioritize customer feedback.
Improve & automate
Make recurring work more structured and useful.
n8n · Gemini agents · Workflow automation · Excel
Automated competitor monitoring and Sheets updates. Used sales analysis to redesign product bundles.
Tools & methods at a glance
Analysis, communication, and the tools used across the projects.
Reporting & presentations
Plotly, HTML/Chart.js, Google Sheets, PowerPoint, Google Slides
Connected to the dashboard, research reporting, and presentation work described in the cases.
AI & workflows
n8n, Gemini, ChatGPT, AI agents, workflow automation, prompt engineering
Used n8n and Gemini agents for the Wayfair/Extern research workflow. The broader toolkit also includes ChatGPT and prompt engineering.
Additional BI tools
Tableau, Power BI
Additional tools. The published dashboards use Plotly and HTML/Chart.js. Native Tableau and Power BI workbooks are not included.
Working with people
Analysis needs a clear explanation.
At NYUC, I revised slides and a presentation script after staff feedback. At Romin, I worked with developers on customer feedback priorities. Through Binghamton’s Marketing Association, I explain marketing concepts and support fellow members.
Languages: English (native) · Mandarin Chinese (proficient)
See a worked example.
The samples include source data, calculations, and proposed plans.