Shopee, the top e-commerce platform in Southeast Asia and Taiwan, launched Shopee Xpress in Aug 2021 which became the leading delivery service in just one year.• Conducted operational and quantitative analysis on the delivery service, leading to a 66% reduction in parcel lost rate and a 50% reduction in delayed rate.• Designed and developed data visualizations to monitor and report on key performance indicators (KPIs), leading to a 35% improvement in sorting center workload.• Built machine learning models to provide insights for optimization, resulting in improved service quality and customer satisfaction, including a forecasting model for platform orders with 95% accuracy.• Optimized SQL queries and database performance resulting in a 67% reduction in server resource consumption, improving overall system efficiency and productivity.• Established policies and tools for BI team members to ensure data availability, usability, and integrity.
Python, SQL, Excel, JavaScript, DAX, Unix scripting, Google Sheets, Google Cloud Platform(GCP), Power Query, Tableau, VBA, Git, Docker, Hadoop, Airflow, Apache Spark, Scikit Learn, JIRA

1. Conducted ABC analysis and tuned demand forecast models for inventory management to allowing precise restocking, reducing overall stockout duration by 67%.2. Generated insights of Amazon seasonality for NA & EU market and built forecasting models to support the planning of a new product line, which generated 1 million USD in revenue in 6 months.3. Create static reports for monitoring ad campaign performance and conducted ad-hoc analysis to support business operations.4. Created guidelines for data exchanges between departments to ensure quality, efficiency and integrity.

1. Microsoft Access database management (designed, created, populated, maintain). VBA scripting for automation of administration process, reduce total processing time by 13%.2. Build and manage SQLite database. Create ETL pipelines for sales and customer data using Python. Clustering using RFM model and K-mean clustering algorithm using Python and SQL. Present insight findings to the head of sales. 3. Dashboard building in Excel using VBA script for quality control data.

Meowshroom startup team - First to turning mushroom bio-waste into pet products1. Build fundraising presentation decks with visualized customer survey data using Tableau.