Sheila
no image
Sheila

SHEILA(ANQI) ZHANG
|| New York, NY || ------------ || ------------ ||
GloryCity Media, New York, NY Jan 2019 - Present Marketing Associate
• Promoting events and sales performance on digital platforms including Facebook, Linkedin and Instagram.
• Generating offline marketing campaigns, tracking materials and campaign performance.
• Managing CRM, creating email campaigns to engage local organizations and government officials
• Maintain quarterly marketing calendar and communication of end-goals and deliverables with relevant clients.
• Promoting events and sales performance on digital platforms including Facebook,Linkedin and Instagram.
• Own relationships with third-party vendors including community, medias and cultural based sites.
Optimal Spaces, New York, NY August 2016-January 2017 Real Estate Marketing Assistant
• Managed SEO audit process for the new website by conducting keywords research, writing SEO friendly content, and
optimizing HTML and CSS on the site.
• Developed and managed Google Paid Search campaigns by optimizing keywords list, bidding strategy, and proposing
landing page testing
• Analyzed and monitored website traffic data by utilizing Google Analytics
and Webmaster tool
• Provided data analysis of company’s performance, using Excel and SPSS, from CoStar database, and created
monthly commercial real estate report containing property pricing forecasts and historical data.
Alzerina Jewelry Company, New York, NY January 2016-May 2016 Digital Marketing Intern
• Increased social media post reaches and followers through keywords mining, formulating improvements to Alzerina’s

branding strategies, expanding client demand.
• Formulated a digital look-book for client marketing purposes, assisting the advertising process.
• Created YouTube videos and edited Facebook pictures through iMovie, Premiere and Photoshop
• Assisted outdoor events
Activities
New York Fashion Show: China Day/AmelieWang Runway Photographer
• Responsible for New York Fashion Show runway photo shooing
Sep 2018 – Feb 2019 2018 Oct
ALI International: Film Production PROJECT
• Manage technical and administrative tasks; Handled errands and confidential matters for cast members • Contributed as a positive member in crew by handling logistics work including managing crew life and helping foreigner crew communicate with local team.
NASA ROCKET CENTER
• Planned activities and events with NASA crew team
• Assisted Non-English-speaking visitors to communicate with NASA crew team during the center tour
PROJECTS
2014-2015
Goldman Sachs, New York, NY
• Create Develop automated solutions for their trade books, develop data models to capture all necessary data
point for trade transactions by MySQL.
• Developed python program for application to access the data programmatically and program to develop an
evaluation model based on the Discounted Cash Flow
Gartner, New York, NY
• Analyzed social media posting and interactions behavior of popular brands on market from 2017-2018.
• Visualized data result then come up with branding strategies based on the analyzing result.
EDUCATION
Goldman Sachs, New York, NY
New York University, New York, NY
Master’s Degree in Management System and Database
GPA: 3.75/4.0 Graduation: May 2019
Stony Brook University, Stony Brook, NY
Bachelor’s Degree in Business Administration and Marketing GPA: 3.67/4.0
SKILLS
May 2019 May 2016
|| Python || HTML || MySQL || CSS || SPSS || SEO || Photoshop || iMovie ||Illustrator || Oracle SQL || Japanese (N3)
|| Google Analytics(certification)|| Word || Excel || PowerPoint || Adobe Premiere || Visio || Qlik || AdWords (certification) || Mandarin || AWS || Tableau