Chengshun Zhao
State College
Summary
I'm an undergraduate student majoring in data science with solid data analysis and machine learning modeling skills. I'm proficient in Python (padas, state models), SQL, and visualization tools (PowerBI, Tableau). Familiar with user behavior analysis, building business metrics systems, A/B testing, KMeans, and DBSCAN algorithms, and possesses strong practical experience in feature engineering and anomaly detection. I have a strong interest in massive data analysis, intelligent decision-making methodologies, advertising recommendations, and causal reasoning. I possess strong self-learning and business understanding skills, can quickly identify business pain points, and leverage data to drive business growth. I look forward to further advancement and contribution in my data science internship at Tencent.
Overview
1
1
year of professional experience
Work History
Social Intelligence & Analytics (SIA)
Ipsos Market Research AG
06.2025 - 08.2025
- Conducted data cleaning and validation for brand datasets (e.g., Zeiss), ensuring accuracy in pricing tables and image/perception data sheets.
- Supported survey quality control by verifying Zesty Paws long survey IDs, correcting numbering errors, and aligning brand coding across large datasets.
- Assisted in brand evaluation projects, including PowerPoint topline summaries, visualizations, and executive presentation materials.
- Completed consumer interview transcription and editing, delivering structured bilingual (CN/EN) summaries for internal project documentation.
- Developed DP specification templates for AI pet brand surveys, ensuring consistent data pipeline standards.
- Conducted market research on high-end bottled water and luxury hotel personal care brands, contributing to consumer insights reports.
- Collaborated with senior researchers to draft innovation point summaries from pet owner in-home visits, highlighting consumer pain points and product opportunities.
- Gained hands-on experience with Excel (data cleaning, cross-tabs), PowerPoint (visual storytelling), and survey management tools, strengthening professional reporting skills.
Data Analytics Intern
Shanghai Kaiyu Information Technology Co., Ltd.
05.2024 - 07.2024
- Participated in AI Assistant Manager, Smart Store Inspection, and Data Platform analytics projects, enhancing operational efficiency and data-driven insights for retail chains.
- Utilized Python and SQL to clean and process over 100,000+ store video surveillance and foot traffic behavior records; conducted feature engineering and abnormal behavior modeling. Designed DBSCAN and K-Means clustering models to segment customer flow and detect anomalies, identifying patterns such as unattended counters and sudden traffic spikes.
- User behavior and sales analytics: Built in-store customer path analysis and conversion funnel models on the AI Assistant Manager platform to support headquarters in optimizing chain store operations.
- Integrated sales and traffic data to deliver multi-store, multi-dimensional data visualizations, enabling standardized data management across stores. Achieved a 15% reduction in inspection labor costs and an 8% increase in customer conversion rate for pilot stores.
- Produced customer persona reports (gender, age, in-store path, dwell time), supporting precision marketing strategies and improving overall customer engagement effectiveness.
Education
Bachelor of Science - Data Science
Pennsylvania State University
University Park, PA05-2026
Skills
- Data Analytics Skills: Python (pandas, numpy, statsmodels), SQL, Power BI, Tableau, Dash
- Statistical Analysis Skills: Multiple Regression Analysis, A/B Testing, Clustering (KMeans, DBSCAN)
Timeline
Social Intelligence & Analytics (SIA)
Ipsos Market Research AG
06.2025 - 08.2025
Data Analytics Intern
Shanghai Kaiyu Information Technology Co., Ltd.
05.2024 - 07.2024
Bachelor of Science - Data Science
Pennsylvania State University