Database Marketing analyst

YINI FENG

312-***-**** *******@**.*** Boston, MA (Relocation Open)

EDUCATION

BOSTON UNIVERSITY 9/2018 – 1/2020

Master of Science in Applied Business Analytics Boston, MA

• Relevant Courses: Business Analytics, Marketing Analytics, Data Mining, Web Analytics for Business, SQL Databese Design, Project Management, Qualitative and Quantitative Decision Making LOYOLA UNIVERSITY CHICAGO 8/2013 – 8/2017

Bachelor of Business Administration in Marketing Chicago, IL

• Achievement: Dean’s List (2015-2016)

RELEVANT PROJECTS

Taobao (Alibaba) User Behavior Data Analyst (Python) 2/2020 – 4/2020

• Analyzed 15000+ Taobao user behavior data on purchase frequency and buying preference time to increasing sales revenue by pandas/numpy in Python;

• Visualized the reasons affecting loss customers and suggestions on aim to targeted audience in Matplotlib and Seaborn. Database Design Management (SQL) 9/2019 – 12/2019

• Created stored procedures, triggers, indexes, constraints, and modified existing ones on various database;

• Defined and wrote script queries for useful questions of established application in implementing into business strategy;

• Provided report to run on the Dashboard for managerial purpose. Airbnb in SanFrancisco Data Visualization Analytics (R) 2/2019 – 5/2019

• Conducted 50k+ Airbnb (SF) customer book descriptions, room information, and prices by using R.

• Used ggplot2 presented variable graphs to describe the Airbnb data relationship: accommodates & price, price & room_type, cleaning_fee & price, etc;

• Developed multiple regression model by developing formula to identify the price range for each categorical variables;

• Built the clustering model, KMeans model, naïve Bayes model, and classification tree model to analyze price-related factors.

Sales Performance Analytics & Evaluation (Excel) 9/2018 – 12/2018

• Applied descriptive, prescriptive, and predictive approaches to analyze the company’s sales market over 3 fiscal years by using Excel Pivot Table;

• Aggregated data and defined KPIs, and forecasted the future trends for several products and distributors;

• Optimized the model by using different analytics methods and solver to found the optimal solution of quantity and price. WORK EXPERIENCES

PulsePoint – Marketing Analyst Intern 6/2020 – Present

• Managed and generated weekly email campaigns (with 13k+ audiences) by using Marketo; provided campaign performance report;

• Optimized company’s website with 3% SEO score increase by implementing links building, developing content strategy;

• Cleaned up and processed over 150k+ clients/prospects data by using Excel and Python, and established automated rules for the higher quality database.

3:5 Creatives Agency – Digital Marketing Intern 4/2020 – 6/2020

• Performed market research and analysis for internal and external marketing collaterals;

• Tracked and analyzed social media statistics, and produced weekly social report with strategic recommendation on Facebook, YouTube, Instagram, and Twitter;

• Planned and executed for brand activations and marketing campaigns. BraunWeiss – Business Analyst Intern 9/2019 – 12/2019

• Worked closely with team on business case development by applying waterfall development;

• Collected business requirements from clients and created business and functional required documentation;

• Designed business workflow by using MS Visio;

• Effectively migrated, configured, and maintained the good quality data record and troubleshooting campaigns in Salesforce.

Wuhoo Digital Group – Digital Marketing Associate 11/2017 – 7/2018

• Performed Coordinated content schedule and analyzing users’ engagement data from multiple client’s social media platforms (Facebook, Instagram, Twitter, Yelp);

• Collected and analyzed 100+ survey data points by using Excel to pinpoint key insights; created and visualized data models by using Tableau to offer strategic recommendations to the clients;

• Managed marketing campaigns (Email, paid search) and conducted analysis to meet media requirements/plans to increase followers by 30%.

SKILLS

Technical: Excel, R, SQL, Python, Tableau, Salesforce Marketing Cloud, Marketo, Google Analaytics

Contact this candidate