Xinyi Chen Email & Phone Number

Fremont, California, United States

Created more than 30 Tableau dashboards to comprehensively monitor and evaluate warehouse operations, driver/shipping performance, delivery efficiency, and user experience, including pick/pack uph, driver productivity and delivery on-time rate, etc. Led initiatives for process improvements and policy updates.• Designed dynamic models for product selection and item pricing to refine product gross margins, enhance competitive advantage, and optimize promotional strategies, ultimately resulting in a 5% increase in profitability for the mail order sector, by considering factors such as product cost, sales volume, freight costs, and competitor pricing strategies, etc.• Employed Python and Excel for comprehensive analysis of driver performance, vehicle capacity, and efficiency of warehouse operations. This strategic analysis was designed to control spending without compromising customer satisfaction, ultimately resulting in an 11% reduction in fleet operating costs for the year 2023.• Developed and continuously refined a comprehensive multidimensional forecasting model using Python. The model, based on sales trends and future projections, helps the fleet plan ahead for off-peak season vehicle purchases/leases and employee hiring, while enhancing warehouse and distribution collaboration.• Leveraged MySQL and PostgreSQL for data extraction, aiding in the creation of informative reports, and supported dynamic ETL updates to align with evolving business requirements.

• Conducted in-depth analysis of competitor products' features and gameplay data using MySQL, Python, and Excel, providing insights to game engineers in their design decisions. • Provided data-driven support to UXR team by analyzing market research surveys with Python, identifying key factors contributing to player retention or churn.

New York, New York, United States

• Conducted data analysis of call center counselor's performance using MySQL and Python, resulting in a 23% decrease in non-emergency call duration.• Conducted analysis of call and chat records to identify areas for Counselors’ scripts improvement, leading to a 15% decrease in emergency call frequency.

Bethesda, Md

• Developed, led, and analyzed patient housekeeping satisfaction surveys using SPSS & Excel to identify staff work performance and provide insights to improve care. Increased survey satisfaction rates by 20%.• Analyzed daily hotspot inspection reports using Excel to identify the reasons for underscoring, reducing hotspots numbers by 10%.

Nanjing, Jiangsu, China

• Developed, led, and analyzed patient housekeeping satisfaction surveys using SPSS & Excel to identify staff work performance and provide insights to improve care. Increased survey satisfaction rates by 20%.• Analyzed daily hotspot inspection reports using Excel to identify the reasons for underscoring, reducing hotspot numbers by 10%.

Nanjing, Jiangsu, China

Master'S Degree, Business Analytics

Master'S Degree, Health Services Administration

Bachelor Of Arts - Ba, Public Health Management