Yuyao Xu
Jersey City,USA
Summary
Proven expertise in data analytics and market research, transforming complex data into actionable insights that drive business decisions. Skilled in utilizing various analytical tools to enhance strategic planning and support sustainable growth initiatives. Demonstrated ability to deliver measurable results through data-driven strategies.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Social Media Marketing Manager
Golden Harbor Capital
New York, New York
04.2025 - Current
- Engineered and executed acomprehensive Rednote（小红书） growth strategy
- Leveraged platform analytics to identify consumer trends, translating data into actionable content pivots
Investment Analyst Intern
Meyer Capital Group Limited
12.2024 - 03.2025
- Conducted investment analysis and research to evaluate business opportunities and investment trends; drafted comprehensive financial reports covering macro data, key ratios, and strategic recommendations.
- Used Excel and Python for data analysis, modeling, and visualization to extract key insights.
- Collaborated with the management team, using data-driven methods to optimize business decisions.
- Performed market research to identify potential investment opportunities and propose recommendations.
- Analyzed financial data to support strategy formulation and execution.
Junior Associate
Research Done LLC
05.2022 - 09.2023
- Researched target companies’ business models and market positioning to support investor roadshow materials.
- Worked cross-functionally to assess companies’ core value and market potential and to generate strategic insights.
- Participated in due-diligence projects, using financial modeling and scenario analysis to evaluate industry/company trends.
- Used Python and Excel to clean and analyze macro data, market capitalization, P/E ratios, and equity transactions, covering 20+ companies.
Education
Master of Science - Apply Business Analytics
Boston University
Boston, MA12.2024
Bachelor of Arts - Economics
University of California, Santa Cruz
Santa Cruz, CA06.2022
Skills
- R
- Excel
- Stata
- Data visualization
- Market research
- Investment analysis
Certification
FINRA Securities Industry Essentials (SIE), Passed
Projects
Airbnb Market Analysis New Orleans, 09/01/23, 12/01/23, Utilized real-world data and R to analyze pricing trends and demand hotspots in the New Orleans short-term rental market. Built multiple regression models to identify key factors affecting rental prices and provided actionable recommendations for landlords, creating visualizations/maps to showcase zoning differences and potential opportunities.
Indore BRT System Optimization, 09/01/23, 12/01/23, Analyzed peak hour passenger flow using Excel and R to propose scheduling optimization ideas, established improved departure and scheduling models to enhance operational efficiency and reduce wait times, and suggested balanced solutions and actionable measures between service quality and operational costs.
Corona Community Real Estate Data Analysis, 09/01/23, 12/01/23, Used R and Excel to analyze community housing price trends and make predictions, assisting brokers in identifying more profitable investment opportunities through visualized results.
Timeline
Social Media Marketing Manager
Golden Harbor Capital
04.2025 - Current
Investment Analyst Intern
Meyer Capital Group Limited
12.2024 - 03.2025
Junior Associate
Research Done LLC
05.2022 - 09.2023
Master of Science - Apply Business Analytics
Boston University
Bachelor of Arts - Economics
University of California, Santa Cruz