Sign in

Social Media Data Analyst

Dublin, California, United States
March 26, 2019

Contact this candidate








**** * ******** **, ******, CA 94568 925-***-**** Motivated and results-driven analyst with 3+ year of experience in marketing data analytics. Passionate about machine learning and improving problem-solving abilities to grow business. Seeking to leverage data analytical skills to benefit corporate performance as a data analyst or data scientist. Data Modeling, Visualization, Wrangling, Mining

Statistics Modeling, Machine Learning

R, Python, SQL, Excel, PySpark, Spark, Tableau, SPSS, Google Analytics

Jun 2018 - Dec 2018

Pleasanton, CA

Data Analyst Intern Through SCU

Pet Supplies Plus

Structured 4 different sources data by applying data wrangling skills with Python pandas, SQL; reduced 10B data computing in data processing.

Leveraged Market Basket analysis to get cross-selling probability between products; conducted clustering analysis to filter valuable customers through recency, frequency, monetary metrics; generated 26+ visualized reports to discover users' behaviors and cross-selling opportunities through Python seaborn, matplotlib, Tableau. Feb 2017 - Aug 2017

Tapei, Taiwan

Marketing Data Analyst


Created and maintained KPI dashboards in Excel and Tableau for online traffic data reporting to support marketing decision-making; decreased 50% reports generating time. Extracted, interpreted and analyzed product data to identify key metrics in digital marketing funnel with customized SQL queries.

Implemented A/B testing for media buying strategies resulting in 150% improvement in click-through rate, 20% growth in revenue.

Feb 2015 - Jul 2016

Taipei, Taiwan

Social Media Planner, Key Role - Data Analyzing & Planning Neo@Ogilvy

Performed ad-hoc requests and weekly reports for 20+ clients using Excel and customized SQL queries to extract and format requested information of social media performance. Utilized statistical methods and Excel Pivot Table to execute preference-based segmentation for social content marketing; raised engagement rate by 60% for Taiwan Excellence account. 2018

Santa Clara, CA

Master of Science: Business Analytics

Santa Clara University

Prediction of Terrorist Attacks Project: conducted casualty predictive analysis of terrorist attacks in the U.S. through combining features selection process in random forest to zero-inflated poisson; improved 2X RMSE performance compare to XGBoost.

Spam filter Project: engineered PySpark program to extract, transform, load text data through big data processing method and classified spam emails by using Naive Bayes and logistic regression; achieved 92% prediction accuracy. Amazon Jobs Project: examined important characteristics for landing jobs at Amazon through Natural Language Processing analysis and LDA analysis; visualized trend, skill set, personality insights using Python seaborn. Brew Beer Project: modeled SQL and NoSQL databases to design business application for brew beer industry; customized SQL and NoSQL queries to report business performance. 2013


Master of Arts: Public Administration

National ChengChi University

Analyzed legislators' facebook strategies in Taiwan through T-test using SPSS. Published a qualitative research paper titled 'A Comparative Study of Campaign and Non-Campaign Facebook Strategies: The Case of Taiwan's Legislators' at 13th European Conference on e-Government.

Yahoo Big Idea Chair Awards 2015

Contact this candidate