Yifan Yang
About Me
Passionate about data processing with strong skills in cross-team functions, business analysis, and data analysis.
Location
New York City, NY
China, MI
Education
C
Columbia University in the City of New York
August 2024 - May 2026
degree
Master's
major
Learning Sciences
minor
Data Analytics
coursework
Data Mining
Programming for Data Science
Linear Regression
Statistical Inference
Data Management
U
University of Wisconsin at Madison
September 2021 - August 2024
Work Experience
I
InnovaAI TECH LLC
Data Analyst Intern
San Francisco, CA, United States, 94199
September 2025 - December 2025
company
InnovaAI TECH LLC
title
Data Analyst Intern
overview
• Designed an A/B testing framework using Python and SQL, analyzing 50K+ sessions and ensuring balanced treatment assignment
• Conducted EDA on bounce rate, session duration, and CTR to identify engagement gaps, informing subsequent UX refinement
• Applied hypothesis testing and CI estimation to quantify uplift, delivering recommendations increasing lead conversion by 18 %
• Automated tracking and reporting workflows using Tableau, reducing analysis time 40% and improving marketing efficiency
• Cleaned visit and conversion data, removing 1.2K duplicates and fixing time errors to ensure accurate experiment evaluation
A
Apple
Business Analyst Intern
San Francisco, CA, United States, 94199
May 2025 - August 2025
M
McKinsey & Company
Management Consulting Intern
Singako, MC, Chad
July 2024 - September 2024
Skills
Languages
ChineseEnglish
Skills
AutomationBusiness AnalysisBusiness ConsultingCommunication SkillsCompetition AnalysisCultural ActivitiesDashboardsData AnalysisData VisualizationDemonstration SkillsGoogle Data StudioInfrastructure ManagementKey Performance IndicatorsKnowledge of MathematicsLeadershipLookup TableMarket ResearchMatplotlibMetricsMicrosoft ExcelMoney InvestmentsNumPyPandasPerformance ManagementPivot TablesPower BIProject ManagementPython (Programming Language)R (Programming Language)SalesScikit LearnSQL DatabasesStataStorytellingSWOT AnalysisTableau (Software)Team WorkingTechnical DocumentationVba Programming Language
Volunteer
I
International Sibling Society
January 2026 - May 2026
Hobbies
Badminton
Ping pang