Xinyi Wang

Experience

1. Business Intelligence Engineer

   Amazon

   Aug 2023 — Present · New York, NY, US

   Automated scalable ETL pipelines by processing 20M+ sales, order, and delivery records in AWS Redshift, validating schemas, partitioning data, and consolidating 10+ tables into a unified core metrics table for scalable downstream performance analysis. Queried Checkout Weblab data to track post-experience metrics and generate insights improving customer acquisition; optimized SQL pipelines with advanced indexing, workload balancing, and CTE redesign, reducing refresh latency by 80%. Performed headroom analysis on package loss cases, proposed notification strategy optimizations to improve UI/UX, and validated through A/B testing, achieving $2.2M annual customer service cost reduction. Conducted COE analysis on Predictive Delivery Window outages, quantifying a 14% increase in customer contacts and 3.2pp CSAT decline, guiding leadership on resource prioritization, risk mitigation, and long-term operational planning. Enhanced QBR and leadership reporting by building Tableau dashboards and conducting QoQ/YoY trend analysis on 50+ purchase, NPDX, and post-ship metrics, partnering with PMs to contextualize business impacts and shape business strategy.

Education

• Rutgers University–New Brunswick

  Bachelor's degree, Mathematics

• The High School Affiliated to Renmin University of China

  High school, A-Level

• Hofstra University

  Bachelor's degree, Mathematics

  2017 — 2019

• Columbia University

  Master's degree, Operation Research

• Duke University

  Summer School