Close Close Preview

Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

Hedan Zeng

Hedan Zeng

Associate Consultant

Rosetta

Associate Consultant at Rosetta

Message
MENU ☰

Rosetta

Associate Consultant

Columbia University

Student

Columbia University Office of Residential Programs

Resident Advisor

• Act as liaison between Columbia student residents and administration
• Serve on the Resident Advisor Recruitment and Selection Committee
• Use extensive knowledge of all campus resources to counsel a floor of 57 students and respond to all needs of area of 1556 students in emergencies
• Establish and promote community standards in residence hall

Career medium 02
Career
Career medium 03

Ogilvy & Mather

Account Management Intern, SAP

• Conducted competitive analysis for SAP’s Analytics, Cloud, Database, HANA, & Mobile offerings; information from analysis used to adjust brand communications across 5 SAP product lines
• Spearheaded a creative onboarding presentation for SAP global brand; presentation used by Worldwide Group Planning Director in briefing all new creative teams
• Generated 20+ CRM strategies to create a Demand Generation Social Media Best Practices deck for local SAP marketers; resulted in more consistent messaging across 40+ SAP social media channels
• Collaborated with intern team to develop and pitch a $7 million integrated marketing campaign for Castrol EDGE client; sparked new Castrol EDGE digital tactic to utilize NFL Partnership

Career

Columbia University Psychology Department

Research Assistant

• Organized and analyzed data from 600+ experimental participants on Excel
• Recruited 200 research participants using social media and campus-wide promotions; led to a 100% increase in experimental participation in one month

Career medium 03
Career
Career medium 01

Kopali Organics

Marketing & Sales Intern

• Directed branding team in 3 discussions of Kopali brand; led to integration of 20+ proposals on youthful product personality and more chic target consumer into internal branding presentation
• Aggressively strengthened relationships with 8 key accounts (Whole Foods Market-Upper West Side; Bed, Bath, & Beyond-Chelsea; Bean & Bean) by organizing 25+ product demonstrations and negotiating better shelf placement; resulted in a 20% increase in account sales
• Pitched to and gained 4 new accounts and negotiated excellent product placement in stores; led to 5% increase in sales in all New York City accounts

Career

Columbia University in the City of New York

B.A., Psychology, Economics

Grand Forks Red River High School