Peter Tsai

As a data analyst with experience in the field, I work on the Uber Eats Operations Team, where I develop dashboards to provide strategic insights, write complex SQL queries to extract data from multiple sources, and use data to solve business challenges.

My goal is to become a professional data analyst, leveraging my business acumen and data analytics skills to deliver data-driven strategic insights and solve business problems.

Taipei, Taiwan

Education

National Chiao Tung University Sep. 2020 - Jun. 2022

Master's degree, Business Administration and Management - GPA: 4.22

Related Course: Big Data Analytics for Business Intelligence (Grade: A+)

Extracurricular Activities: National Taiwan University Data Analytics Club Member

University of Mannheim Feb. 2020 - Jun. 2020

Business Administration Exchange Student - Study Abroad Scholarship

National Sun Yat-Sen University Sep. 2016 - Jun. 2020

Bachelor's Degree, Finance - GPA: 4.03

Work Experience

Merchant Ops Specialist - Data Analytics • Uber Eats Jul. 2022 - Present

-Build automated dashboards with Python, SQL, and Google Sheets for APAC lead team, enabling them to monitor the legal compliance status of 70,000+ restaurants in Taiwan, resulting in a reduced churn rate from 28% to 0.5%

-Analyze campaign performance to develop actionable strategies that boost merchants' and platform's profits

-Provide regular updates on performance trends and insights to senior leadership and stakeholders

-Lead SQL training sessions for 10 team members to improve their capability to retrieve data independently

-Collaborate with cross-functional teams to identify key metrics and OKRs for tracking and reporting

Account Management Analyst Intern • inline Apps Oct. 2021 - Jun. 2022

inline is a booking management system helping 5,000+ restaurants to improve efficiency.

-Developed and managed over 20 dashboards in Google Sheets for monitoring restaurant reservations and food order performance across 5,000+ restaurants in Taiwan, Hong Kong, Singapore, Malaysia, and Australia

-Provided strategic recommendations to support restaurant partners by leading performance reviews in weekly team meetings and presenting Taiwan's restaurant reservation performance

-Implemented data pipeline automation using Python, Google Sheets, and Google Apps Script, resulting in a 95% reduction in manual processing time

Business Analyst Intern • Rainmaking Innovation Taiwan Jul. 2020 - Oct. 2020

Rainmaking Innovation is a UK leading firm for corporate innovation and strategy development.

-Developed a targeted marketing strategy for the newly launched pet insurance product by conducting regression analysis in Excel to identify the optimal approach to reach urban cat owners

-Estimated the potential market size of Taiwan's pet healthcare industry to be NT$20 billion using public data

Relevant Experience

[Side Project] Sign-up Rate Optimization • KKday Mar. 2022 - May 2022

KKday is a Taiwan-based e-commerce travel platform with over 1 million travelers.

-Managed and directed a team of 5 in processing behavioral data for 10 million users using GCP BigQuery

-Developed a Random Forest Machine Learning model using Python that achieved an impressive 97% accuracy rate in identifying key factors that impact visitor registration rate, including device type and visit frequency

-Suggested mobile apps download reminders and product recommendations adjustments to optimize sign-up rate

-Received approval for proposals from AI team lead, subject to feasibility studies

[Side Project] Customer Lifetime Value Optimization • SurveyCake Sep. 2021 - Dec. 2021

SurveyCake is a Taiwanese enterprise-level cloud survey service.

-Led 6 members to segment 100+ clients through K-Means clustering and defined customer value with RFM analysis

-Suggested new survey scenarios upsell strategy and usage tracking system to reduce customer churn rate

-Received commendations from SurveyCake's CEO and Account Manager team lead for implementing effective solutions

Licenses & Certifications

SQL Essential Training

Issued August 2021 · No Expiration Date

Managing and Analyzing Data in Excel (Office 365/Excel 2019)