Siyi Zhou
***********@*****.*** 848-***-**** linkedin.com/in/siyi-zhou-110856225
EDUCATION
Columbia University New York City, NY
Master of Arts in Quantitative Methods in the Social Sciences Sep 2025 – Dec 2026
• Coursework: Data Visualization, Machine Learning, Natural Language Processing, Time Series & Panel Data Forecasting
• Columbia Graduate Consulting Club Member
Rutgers University New Brunswick, NJ
Bachelor of Arts in Communication, Minor in Business Administration & Education as a Social Science Sep 2021 – May 2025
• Dean’s List: Fall 2021 - Spring 2025 GPA: 3.67/4.0
• Coursework: Public Speaking, Communication Research, Business Analytics, Finance, Marketing, Educational Psychology
• Lambda Pi Eta Member, the National Communication Association’s honor society (Fall 2022 - Spring 2025) WORK EXPERIENCES
EY-Parthenon Shanghai, China
Management Consulting Intern – Digital Transformation May 2025 – Aug 2025
• Delivered 100+ slides and 180 pages of due diligence briefings and competitive analyses; outputs guided partner discussions and informed executive decisions at China Everbright Bank and SAIC Volkswagen.
• Stepped up as interim team lead after the team leader's exit; restructured workflows into parallel tracks, introduced daily stand-ups, and standardized reporting data dashboards; built a Python automation pipeline to reduce key task data processing time by ~40%; coordinated multi-team dependencies to deliver the final strategy deck ahead of the accelerated deadline.
• For Volkswagen, increased EV market share by 5% (~USD 17M annual uplift) through managing product lines by designing lifecycle frameworks, defining micro-service modules (20+), and prioritizing features into a roadmap aligned with the client.
• For CEB, developed forecasting models with85% accuracy and incentive/anti-fraud strategies to boost activation (15%), retention (8%), and reduce misuse (3%). Raise rewards conversion (20%) by diagnosing bottlenecks, analyzing KPIs, and benchmarking competitors. China Daily USA New York City, NY
Marketing & Circulation Data Analyst Intern May 2024 – Sep 2024
• Utilized SQL to standardize metrics reporting and created the source-of-truth definition for subscription and revenue metrics for 6 U.S. offices. Created SQL procedures to cleanse, transform, and store datasets, cross-validated with the financial department for both internal and external auditing purposes.
• Led the 2024 Global Youth Writing Competition (ESG) campaign by launching a dedicated website and executing paid ads; produced weekly video content that increased website traffic by 30% and generated 80,000+ engagements across TikTok, X, and Instagram.
• Secured long-term subscriptions from 6 university libraries and 3 political science departments (e.g., NYU) through weekly content curation and targeted outreach to academic stakeholders. Ben-Amun New York City, NY
Marketing Analyst & PR Intern May 2023 – Aug 2023
• Boosted product visibility on Shopify by applying SEO techniques (e.g., using Plug in SEO) and automating metadata updates with Python; tracked performance via Google Analytics and Shopify dashboard, achieving a 25% increase in organic impressions, 15% higher click-through rates, and a 10% uplift in search-driven conversions over 8 weeks.
• Curated and scheduled digital campaigns for 2023–2024, including two trend-driven initiatives; analyzed historical ROI data across channels to inform budget allocation and optimize influencer partnerships.
• Managed press communications and seasonal product launches; organized a pop-up event with strategic KOL engagement that attracted 100+ visitors and generated $2K+ in sales within four hours. 9owls Rhythm Unique DJ Booking & DJ Incubation Agency (online platform) New York City, NY Founder/CEO Sep 2022 – Present
• Founded and scaled a unique DJ booking & DJ incubation agency operating across New York and Shanghai, generating $10K+ annual revenue through long-term partnerships with venues and planners, including Cornell University alumni association and Den Social NYC.
• Built the official website and grew TikTok and Instagram accounts to 100K+ followers; incubated and promoted 3 emerging DJs into trending performers, enhancing brand visibility and service capacity. SKILLS
● Skills: R, Python, SQL, Tableau, A/B Testing, Microsoft Office Suites, Media Content Creation, Photoshop, Canva Design.
● Languages: English (Proficient), Chinese (Native)