-Analyze marketing campaign performance to develop effective strategies, supporting cross-functional teams and leading to a monthly revenue increase of USD 9.6 million -Enable APAC lead team with automated dashboards monitoring the legal compliance status of 100,000+ restaurants in Taiwan, supporting cross-functional teams to prevent a potential monthly revenue loss of USD 5.5 million -Craft and implement complex SQL queries to extract invaluable insights, empowering cross-functional teams to rapidly gain a comprehensive overview and make informed, data-driven business decisions -Provide updates on performance trends, insights, and business solutions to senior leadership and stakeholders

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 -Led the restaurant data labeling project, establishing the classification logic, and successfully completing the labeling of 5,000+ restaurants

NTU Data Analytics Club is a business club founded by a group of NTU students who are passionate about data science and aim to teach students how to use data analysis to solve business problems. -Placed 3rd out of 50 contestants in SQL coding competition -Designed and developed a data visualization dashboard on 2020 Taiwanese marriage registration using Tableau -Acquired advanced data analytics skills in SQL, Python, Excel, and Tableau for collecting, processing, analyzing, and visualizing data -Developed expertise in problem-solving and decision-making techniques that leverage data analysis and enhance business value

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

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 use-case 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

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