Ailin W.

Experience

1. Business Intelligence Engineer

   Amazon

   Aug 2023 — Present · Seattle, WA, US

   Conducted A/B testing post-experiment analysis for Prime Video self-service email programs used by partners (HBO, Disney, Paramount, etc.), building 12 email engagement metrics with SQL, pipeline automation, and QuickSight dashboard to assist decision-making in funding.• Performed tagging on 30+ pages and 140+ features using Product Analytics Tool, Pendo, creating dashboards for 6 product teams to analyze user journeys through workflow, path, and funnel reports. These insights helped teams optimize feature engagement, streamline user flows, and improve overall product experience by identifying drop-off points and key engagement metrics.• Standardized code development across an 8-member BIE team by initiating and creating a centralized data repository with CI/CD features, including version control, branching, and code review, improving collaboration and code quality.• Developed 8 metrics using SQL to quantify financial and streaming impact of split licensing and asset sharing Prime Video offers. Built automated data pipeline delivered insights through QuickSight dashboard.• Hosted bi-weekly cross-functional team project planning meetings with 15 participants to enhance collaboration across PMs, engineers, and data teams through progress update, prioritization, and documentation.