Resume
Yan-Ming (Hugo) Huang
UC Irvine Merage MSBA · Expected Spring 2027
Open to Data Analyst roles — US & Taiwan
Summary
Business analytics graduate student with hands-on ad-tech data experience. I turn campaign, product, and customer data into measurable decisions — SQL, Python, and experiment design, with a background in how marketing data pipelines actually break.
Experience
Appier Inc. — Technical Solution Engineer Intern
Jun 2024 – Jan 2026- Onboarded 6–8 mobile advertising campaigns per day across JP, KR, Greater China, US, and EMEA markets, validating MMP integrations and defining the Appier-side event taxonomy (install, app open, purchase, in-app ad revenue) for each advertiser.
- Built a self-service tracking-diagnostic tool: co-authored SQL queries against the cross-MMP integration database, wrapped them in an internal API endpoint, and surfaced results in Google Sheets — letting interns confirm whether a test conversion reached the MMP or was misclassified as organic, without escalating to full-time engineers.
- Diagnosed post-launch performance anomalies and traced them to attribution-window misconfiguration and other postback-setting errors — the two dominant root causes — then codified the diagnostic path into a shared troubleshooting checklist.
- Automated HTML creative packaging with a Python backend and Next.js frontend, cutting a 30–60 minute manual task to a single upload; the tool remained in production after the workflow was outsourced to an external vendor.
Industrial Technology Research Institute — Talent Program Assistant
Apr 2023 – Apr 2024- Replaced an outsourced SPSS reporting workflow with an in-house Python/pandas pipeline: cleaned and grouped raw exports from 6–7 source databases into 29 structured worksheets feeding 40+ tables and charts for the platform's annual report to the Ministry of Education.
- Reduced the reporting cycle from a multi-week external engagement to a ~30-minute pipeline run, and left the notebook documented for successor interns to operate independently.
Skills
| Category | Items |
|---|---|
| Data & Analytics | Python (pandas), SQL, event taxonomy / schema design, experiment design |
| Domain | Ad tech attribution, MMP integration, GTM implementation |
| AI/LLM | Prompt engineering (Chinese sentiment lexicon-grounded scoring) |
| Collaboration | Cross-market English collaboration (JP/KR/Greater China/US/EMEA), documentation & onboarding design |
Education
- UC Irvine, Paul Merage School of Business — Master of Science in Business Analytics, Expected Spring 2027. Coursework in progress: BANA 200, 201A, 211.
- National Taiwan Normal University — Department of Technology Application and Human Resource Development, 2020–2025.
- Certificates: Google Data Analytics, Google Business Intelligence, Google Advanced Data Analytics (Coursera).