Yishan Tang

Enthusiastic and inquisitive

Xuandu Tech Co., Ltd. Hangzhou, China

Digital Analyst Intern

Jun. 2023 - Aug. 2023

• Built a comprehensive database using SQL by integrating data from multiple sources and CRM systems, encompassing product categories, sales amounts, and customer information, to support personalized marketing strategies
• Conducted customer segmentation using Python and K-Means clustering, analyzed purchasing paths for different groups; Collaborated with the marketing team to design targeted strategies for high-value customers, increasing customer loyalty and purchase frequency
• Analyzed multi-channel sales data to identify pricing inconsistencies and channel overlap for high-selling products, enabling the marketing team to optimize channel distribution and increase profit margins

Hangzhou, China

Business Analyst Intern

Nov. 2022 - Jan. 2023

• Analyzed quarterly sales, customer feedback, and operational data from CRM and ERP systems using Excel and VBA macros. Automated error checks, reducing data preparation time by 16% and enhancing data accuracy
• Utilized Python to analyze sales data from 15 regions, identifying key growth drivers such as top-performing products and underperforming regions; optimized budget allocation, resulting in a 5% increase in overall sales
• Developed Tableau dashboards to visualize KPIs and sales performance; identified long delivery times as a driver of low satisfaction, leading to optimized logistics and improved customer satisfaction scores
• Designed a benchmark analysis system using Excel to compare regional sales, monitor KPIs, and identify trends. collaborated with sales managers to drive an 8% sales increase in underperforming regions

University of Rochester Rochester, NY

Master of Science in Business Analytics Jul. 2024 – Dec. 2025

North Carolina State University

Raleigh, NC

Master of Science Electronic and Computer Engineering Jan. 2023 – Dec. 2023