Song Peng
Lawrence,KS
Summary
Interested in SQL-focused roles. Proficient in leveraging SQL for data queries and analysis. Strong ability to utilize Tableau and Power BI for effective data visualization and insights presentation. Skilled in data analytics and equipped with bilingual communication skills in English and Mandarin.
Overview
5
5
years of professional experience
Work History
Data Analytics Project
University of Kansas
Lawrence, Kansas
08.2023 - 12.2023
- Designed a database and data warehouse schema to store influencer and sales data, aiming for enhanced marketing insights
- Automated data extraction processes using APIs and web scraping techniques for data collection
- Cleaned and loaded collected data into the designed database to ensure accuracy and reliability of analysis
- Applied SQL queries for detailed analysis, deriving actionable insights and optimizing marketing strategies.
Sales Specialist (Part Time)
Nike
Shanghai, Shanghai
12.2020 - 04.2021
Teaching Assistant (Part-time)
YiYuan Internet technology
Shanghai, Shanghai
11.2018 - 01.2019
Education
Master's Degree: Business Analytic -
University of Kansas
05.2024
Bachelor's Degree: Sport Management -
University of Kansas
05.2023
Skills
- R Language
- Python
- SQL
- Tableau and BI
Timeline
Data Analytics Project
University of Kansas
08.2023 - 12.2023
Sales Specialist (Part Time)
Nike
12.2020 - 04.2021
Teaching Assistant (Part-time)
YiYuan Internet technology
11.2018 - 01.2019
Master's Degree: Business Analytic -
University of Kansas
Bachelor's Degree: Sport Management -
University of Kansas
Similar Profiles
Yasmine MarcosYasmine Marcos
Active Member of Delta Sigma Pi, Professional Business Fraternity at University of KansasActive Member of Delta Sigma Pi, Professional Business Fraternity at University of Kansas
Nicole Hodges PersleyNicole Hodges Persley
Vice Provost of Community Impact at University of KansasVice Provost of Community Impact at University of Kansas
Isabella PassantinoIsabella Passantino
Bachelor of Arts in Human Biology at University of KansasBachelor of Arts in Human Biology at University of Kansas
Kirsten WangKirsten Wang
Instructor at University of KansasInstructor at University of Kansas
Halas KoberHalas Kober
Senior Team Lead at Chick-fil-ASenior Team Lead at Chick-fil-A