ZI-QI (Carol) LIU

1-551-***-**** Greater New York C ity Area adjg5k@r.postjobfree.com

LinkedIn: www.linkedin.com/in/zi-qi-liu

SUMMARY

Several-year experienced data analyst with strong statistical background in marketing research field and media industry. Seeking data analyst and marketing analyst full-time job. EXPERIENCE

Hong Kong Citizen News, Hong Kong (Remote) Aug 2017-Dec 2020 Data Analyst

• Managed traffic analysis based on daily page view, video view, and user demographics by Google Analytics

• Increased monthly audience readership by 310% since 2017 utilized topic analysis to target most interested customers United Nations, New York City, NY Feb 2020-Aug 2020 Public Information Intern

• Analyzed user data of UN Chinese YouTube and promote list to increase the number of viewers and videos

• Monitored and edited daily live videos of United Nations meetings and events on UN Web TV and social media Apple Daily Publication Development LTD, Taipei Taiwan & Hong Kong Jun 2014-Jun 2017 Business Analyst & Data Manager

• Supervised projects across digital, graphical, and all publishing departments, by operated databases built with Google Analytics, comScore, and internal systems

• Directed advertising efficiency (Google Ads & Facebook Ads) and traffic analysis, provided sales strategy and editing suggestions, increased yearly profits more than 27% in 2015 (by R: Regression, Time-series, K-means) resulting in Apple Daily becoming the No. 1 web news in Taiwan

• Studied competition in industry and managed social media: Facebook, Facebook Instant Articles, Twitter, YouTube 104 Job Bank Corporation, Taipei Taiwan Oct 2012-Dec 2013 Marketing Analyst

• Organized database of 3 million workers seeking jobs in Taiwan by SQL, Excel and SPSS (K-Nearest Neighbors, Regression), resulting in an improved process for universities or companies by demographic and experience

• Performed feedback analysis and examined information for product positioning of brands ranging from Shiseido

(biggest shampoo brand in Asia) with competitive companies, such as Head & Shoulders, Dove, Pantene China Credit Information Service, Ltd., Taipei Taiwan Jan 2011-Feb 2012 Marketing Analyst

• Managed industrial data analysis for Taiwan’s top 2000 listing companies by SQL.

• Marketed and satisfaction analysis for clients, generate reports, and visualize results through the database and statistical software SAS and SPSS.

SKILLS

Programming: Python (Pandas, NumPy, Scikit-learn), R (tidyverse, data.table), SAS, SPSS Data Visualization: Python (Seanborn, ggplot, geoplotlib), R (ggplot2, ggmap, wordcloud), Tableau Databases: SQL: MySQL, PostgreSQL; Hadoop, AWS, Spark Analytical Tools: JMP, Microsoft Excel

Social Media Tools: Facebook Ads, Google Analytics, Google Ads, YouTube, comScore, Nielsen Media Analytics EDUCATION

Stevens Institute of Technology, Hoboken, NJ, GPA: 3.94 Dec 2020 Master of Science in Business Intelligence & Analytics Courses: Data Analysis, Optimization & Proc. Analytics, Social Network Analysis, Web Mining, Big Data Tamkang University, New Taipei City, Taiwan Jun 2009 Bachelor of Business in Statistics

ACADEMIC PROJECTS

Analyzing the Success of Crowdfunding through Kickstarter Spring 2019

• Analyzed the Kickstarter crowdfunding data, and dug into specific characters lead to best fundraising for a project in order to predict a successful model for the Kickstarter community

• Resulted in some specific categories, such as music, games, and video & firm are easier to reach goal, and successful projects are related with their higher goals

• Used method: data structure analysis, clustering-k means, LDA, and random forests. Visual word cloud Cookbook Consumer Behavior Analysis from Amazon.com Fall 2019

• Scraped over 1200 books metadata and reviews from Amazon.com by Selenium Webdriver

• Retrieved industrial trends and consumer tastes through Clustering and Topic Modeling

• Used method: Text-mining, clustering-k means, Topic Modeling

Contact this candidate