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

Intelligent Transportation System & Control Technology Co.,Ltd.                                                                                                                      

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