Yanjun Wan
Decatur,GA
Summary
Driven Data Analyst Intern with background in identifying data discrepancies and developing solutions. Possess strong analytical skills, knowledge of statistical software and ability to interpret complex datasets. Have successfully organized and cleaned data sets for optimized use, demonstrating keen understanding of diverse data analysis methodologies. Made significant impact by providing insightful, actionable reports based on thorough research and examination of organizational data trends.
Overview
4
4
years of professional experience
Work History
Data Analyst Intern
Capital Gateway Realty LLC
Lilburn , GA
2024.06 - Current
- Evaluated interface optimization through conducting and analyzing 2 A/B testing experiments. Utilized T-tests for establishing statistical significance. Outcome: Achieved a 7% increase in customer satisfaction.
- Constructed and tested data pipeline and fully automated & interactive Tableau dashboards for internal stakeholders to inform marketing and product strategies.
Student Researcher
Emory University QTM Department and Microsoft
Atlanta , United States
2022.06 - 2022.08
- Wrote a web scraping algorithm to complement the rental house datasets with socio-demographic information from the US Census database, increased the accuracy of prediction
- Created geographic visuals of the Atlanta demographic landscape and the rental price distribution
- Delivered spline model visualizations of the primary predictors as a result of LASSO and random forest permutation importance methods
- Hosted and participated in a Skater cluster model to identify the most unaffordable neighborhoods in Atlanta, which sparked interests among local politicians and nonprofit rental house organizations
Data Analyst Internship
Yafo Capita
Shanghai , China
2021.05 - 2022.07
- Delivered spline model visualizations of the primary predictors as a result of LASSO and random forest permutation importance methods
- Hosted and participated in a Skater cluster model to identify the most unaffordable neighborhoods in Atlanta, which sparked interests among local politicians and nonprofit rental house organizations
- Enhanced the work efficiency of our analyst team by co-establishing a python system that can collect data with relevant keywords from company's database automatically
- Developed 10+ financial statements and 20+ product analyses into company databases in order to facilitate the creation of market return models and improve product recommendations for Party A
Data Analyst Internship
Ali-baba Group 1
Hangzhou , China
2021.01 - 2022.03
- Researched on a data processing software with my team for citizen's welfare named "GanFuTong", which reduced the costs of collecting data of transportation and implementation of residents' benefits
- Explored possible resources of cooperation among the spheres of health sciences, financial securities, transportation, and automobile technologies, and constructing the information into well-designed excel charts
- Spearheaded the construction of stock portfolios to advise clients of lucrative and sustainable financial opportunities
- Visited 20+ local stores and hotels researching potential promotion possibilities for Ali-baba's mobile apps
Education
Bachelor of Science - Quantitative Sciences
Emory University
Atlanta, GA05.2024
Bachelor of Arts - Economics
Emory University
Atlanta, GA2024-05
Skills
- Python
- R language
- Visualization
- Modeling
- Excel
- Graph forming
- Machine Learning
- GitHub
- SQL
Leadership
- Chinese Student Association, Public Relations Chair, 09/2010, 05/2022, Amplified minority voices within the college community to create a safe space for individuals of Chinese descent, Engaged with members of the community to create an awareness of Chinese culture through on-campus events
- Business Club, Chairman, 06/2017, 07/2019, Coordinated the collection of funds in order to donate to local elementary schools in need, Organized business competition in Shanghai with more than 400 participants., Held 10+ lectures sharing knowledge in business fields and books I read with club members
References
References available upon request.
Timeline
Data Analyst Intern
Capital Gateway Realty LLC
2024.06 - Current
Student Researcher
Emory University QTM Department and Microsoft
2022.06 - 2022.08
Data Analyst Internship
Yafo Capita
2021.05 - 2022.07
Data Analyst Internship
Ali-baba Group 1
2021.01 - 2022.03
Bachelor of Science - Quantitative Sciences
Emory University
Bachelor of Arts - Economics
Emory University
Similar Profiles
Edis AdrovicEdis Adrovic
Resident Manager at PH Realty Capital LLCResident Manager at PH Realty Capital LLC
Daisy TapiaDaisy Tapia
Real Estate Agent at Realty One Group GatewayReal Estate Agent at Realty One Group Gateway
Rafael Lopes SchneiderRafael Lopes Schneider
Senior Front-end Engineer at CMG (Capital Markets Gateway)Senior Front-end Engineer at CMG (Capital Markets Gateway)