Student Analyst
Jan 2024 - May 2024
AeroLeads people directory · profile
Yichen (Ruby) Pan Email & Phone Number
Strategic Analyst Intern @ ByteDance | MS in Marketing Science @ Columbia Business School
LinkedIn matched
✓ Verified Jul 2026
3 data sources
Profile completeness 71%
Role
Strategic Analyst Intern @ ByteDance | MS in Marketing Science @ Columbia Business School
Location
United States
Who is Yichen (Ruby) Pan? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Yichen (Ruby) Pan is listed as Strategic Analyst Intern @ ByteDance | MS in Marketing Science @ Columbia Business School based in United States. AeroLeads shows a matched LinkedIn profile for Yichen (Ruby) Pan.
Yichen (Ruby) Pan previously worked as Student Analyst at Audible and Student Analyst at Habu. Yichen (Ruby) Pan holds Master Of Science - Ms, Marketing Science from Columbia Business School.
Profile bio
About Yichen (Ruby) Pan
Hello, I am a graduate student at Columbia Business School, pursuing an MS in Marketing Science. During my academic journey, I have immersed myself in a diverse array of financial and technological topics, honing my ability to analyze complex data sets and extract meaningful insights. My coursework at Columbia has equipped me with a solid foundation in marketing analytics, statistical modeling, and data-driven decision-making, making me adept at leveraging data to drive strategic business outcomes.Outside of the academic and professional field, I enjoy doing Pilates, making music in my home studio, and creating long Spotify playlists. I look forward to contributing my unique perspective to a forward-thinking team and leveraging my skills to drive impactful outcomes in the data science and business domains.I am eager to build my professional network so feel free to connect with me and reach out to me at YiPan24@gsb.columbia.edu.
9 roles
Yichen (Ruby) Pan work experience
A career timeline built from the work history available for this profile.
Student Analyst
Aug 2023 - Dec 2023
Strategic Analyst - Data Science
• Conducted research and analysis of income fluctuations for 10+ products, built data visualization with analytical tools per week to support follow-up business landing actions• Calculated target income, tracked monthly KPI values, compiling performance reports and aligning with relevant departments • Initiated a project for improving prediction accuracy of advertising budgets, generated user portraits for three products, and identified different user groups using SQL and R
May 2023 - Aug 2023
Undergraduate Research Assistant
• Collected and processed over 1739 publications’ Google Scholar information to analyze the impact of academic research on financial market policy with Python through Scholarly API• Inspected comment letter sentiment regarding proposed SEC regulations, enhanced the understanding of corporate opinion, intentions and reasoning about new policy objectives by adopting natural language processing methods
Jan 2021 - May 2023
Strategy Intern
• Investigate rising Asian markets for skin care, hair care, and cosmetics brand expansion; conduct data collection and research on the premium skincare market in the context of e-commerce penetration• Analyze Dermalogica business opportunities from growth strategy and channel strategy perspectives; develop methodologies for performing risk analysis, competitive analysis, and estimating market capacity
May 2022 - Feb 2023
Dell Rack Integration - Student Analyst
• Develop technical solutions with NetSuite Inventory Management to optimize Dell’s Rack Integration Inbound Material Process by minimizing manual work, lessening unnecessary storage costs, and improving communication efficiency
Aug 2022 - Dec 2022
Undergraduate Teaching Assistant
• Guided 500+ students in STA 371G and STA 235 through statistics problems and concepts during office hours to enhance their mastery of lectures• Instructed students to build multiple regression models and selectively apply transformations by RStudio for their group projects
Aug 2021 - Dec 2022
Heb Internship Web Portal - Student Analyst
• Applied project delivery methodologies and Agile principles; initiated the project by investigating the current system and identifying objectives, constraints, and risk-reducing strategies; proposed a one-stop shop summer internship portal• Provided a robust solution and deployed the HEB Summer Internship Portal to the client with a comprehensive report for future maintenance; accumulated 300+ users within three months
Jan 2022 - May 2022
Undergraudate Research Assistant
Information Retrieval Crowdsourcing Lab
• Summarized data selection methods and annotation categories applied on datasets for hate speech detection models• Created an individual literature review comparing hate-speech detection guidelines in 12 different research to observe potential biases in the classification process and identified the importance of improving user experience
Dec 2020 - May 2021
4 education records
Yichen (Ruby) Pan education
Master Of Science - Ms, Marketing Science
Bachelor Of Business Administration - Bba, Management Information Systems, General, 3.93
Bachelor Of Science And Arts - Bsa, Mathematics, 3.93
Asia In The 21St Century
FAQ
Frequently asked questions about Yichen (Ruby) Pan
Quick answers generated from the profile data available on this page.
What is Yichen (Ruby) Pan's role at their current company?
Yichen (Ruby) Pan is listed as Strategic Analyst Intern @ ByteDance | MS in Marketing Science @ Columbia Business School.
Where is Yichen (Ruby) Pan based?
Yichen (Ruby) Pan is based in United States.
What companies has Yichen (Ruby) Pan worked for?
Yichen (Ruby) Pan has worked for Audible, Habu, Bytedance, Salem Center For Policy, and Unilever Prestige.
How can I contact Yichen (Ruby) Pan?
You can use AeroLeads to view verified contact signals for Yichen (Ruby) Pan, including work email, phone, and LinkedIn data when available.
What schools did Yichen (Ruby) Pan attend?
Yichen (Ruby) Pan holds Master Of Science - Ms, Marketing Science from Columbia Business School.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial