Digital Marketing Data

WEIHUA FENG

******.******@*****.*** 352-***-****

**** *** ***, *******, ** 98121

SUMMARY

Looking for a full- time Analyst position.

Legally authorized to work in the United States without sponsorship.

M.S degree in Engineering.

3+ years experience in working with databases and SQL in a business environment.

3+ years experience in Advanced Microsoft Office skills, particularly Excel and analytical platforms.

2+ years in building and maintaining recurring metrics, reports, and dashboards.

2+ years experience with scripting languages (Python) and BI tools ( Tableau).

Strong written and verbal communication skills.

DASHBOARD & REPORTING SAMPLES

https://phoebewhfeng.wixsite.com/home

SKILLS

Advanced Excel

SQL / AWS Redshift

Tableau

Python

Reporting

Dashboard

Power BI

R Language

EXPERIENCE

Digital Marketing Specialist

Full Speed Advertising Seattle, WA March 2019 - Current

Conduct analysis across multiple data sources to identify key insights

Develop dashboards and general data visualization for clients

Completed in-depth analyses of competitor ad, keyword, bids and landing page activities

Gathered and organized data to analyze current industry trends

Developed SQL queries to obtain complex data from tables in remote databases

Ad Operations Analyst

Zypmedia.Inc San Francisco, CA July 2017 - December 2018

Monitor advertising impression data to generate impression forecasts and troubleshoot anomalies

Manage and help to build the analytical infrastructure needed to successfully run operations using advanced Excel reporting features

Identify Key Performance Indicators (KPI) in order to present campaign performance in a formal setting with management and external clients Analyze monthly and yearly revenue data of the partners to identify trends and growth opportunities that will improve profit margins

Generate post-campaign reports highlighting delivery and performance data

Wrote MySQL scripts from AWS Redshift and processes for data integration and bug fixes

EDUCATION AND TRAINING

M.S: Electrical and Computer Engineering

University of Florida Gainesville, FL 2012

B.S: Computer Science and Technology

Zhengzhou University China

CERTIFICATIONS

Google Analytics Certification

Google AdWords Certification

Contact this candidate