Zi-Qi (Carol) Liu

Data Analyst

551-***-**** adlp22@r.postjobfree.com www.linkedin.com/in/zi-qi-liu Hoboken, NJ

SKILLS

Programming: Python (Pandas, NumPy, SciPy, Scikit-learn), R (RStudio, tidyverse, data.table), SAS, SPSS

Visualization: Python (Seanborn, ggplot, geoplotlib), R (ggplot2, ggmap, wordcloud), VOSviewer, Power Point

BI tools: Tableau, Microsoft Power BI, Google Data Studio

Database: SQL: MySQL, PostgreSQL; Hadoop, AWS (Amazon Web Services), Spark

Analytical Tools: JMP, Microsoft Excel (Simple VBA, PivotTable, Functions: VLOOKUP, XLOOKUP, IF, MATCH, INDEX)

Others: Facebook Ads, Google Analytics, Google Ads, YouTube Analytics, comScore, Nielsen Media Analytics

EXPERIENCE

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

Data Analyst

Combined and analyze traffic analysis based on daily page view, video view, and user demographics by different data sources: Google Analytics and the internal database

Created automated dashboards for different teams and customers through Power BI and Google Data Studio, and constantly communicated and ensured the BI reporting was satisfied their business requirement, planned advertising marketing and social media marketing

Applied branding and marketing analytics with teams and targeted the social media and website readers to increase consumer and membership, enhanced monthly audience readership by 310% since 2017

United Nations, New York City, NY Feb 2020 - Aug 2020

Public Information Intern

Analyzed user data of UN Chinese YouTube Channel and promote list to increase the number of viewers, increased about 12% video views

Imported the Python Selenium Webdriver and Excel to make worksheets, which can be automatically updated, so teams could simplify the work process and saves 30 % of time

Stevens Institute of Technology, Hoboken NJ May 2019-Jan 2020

Graduate Assistant

Applied machine learning and models by Python with the alumni database of Business Intelligence & Analytics to predict the trend of new students finding a job

Operated large-scale alumni events, seminars, and poster exhibitions, communicate with alumni and members

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 and data management with Google Analytics, comScore, internal systems, and Nielson Media Analytics

Designed Google Data Studio reports, in-depth understood the needs of departments, improved efficiency by 50%

Cooperated with the editor teams and IT teams to formulate the content that readers want to see, researched Google Search SEO, and designed referral links and weekly Email; Suggested the sales teams and clients advertising campaign on apps and websites by categories, reader demographics, A/B Testing,

Reported the advanced analytics with advertising, marketing, and branding to COO, and cooperated with Hong Kong teams, reduce communication time by 50%

Directed advertising efficiency (Google Ads & Facebook Ads) and traffic analysis, provided sales strategy and editing suggestions, raised yearly profits by more than 27% in 2015 (by R: Regression, Time-series, K-means)

104 Job Bank Corporation, Taipei Taiwan Oct 2012 - Dec 2013

Marketing Analyst

Wrote SQL queries with the database of 3 million workers seeking jobs in Taiwan and utilized Excel, and SPSS to create models, resulting in an improved process for universities or companies by demographic and experience

Performed feedback analysis and market trend and examined information for product positioning of brands ranging from Shiseido (biggest shampoo brand in Asia) with competitive companies, such as Head & Shoulders, Dove

EDUCATION

Stevens Institute of Technology, Hoboken, NJ, GPA: 3.94 / 4.0 Dec 2020

Master of Science in Business Intelligence & Analytics

Statistics, Data analytics, Data Structure and management, Machine Learning, Business manage, BI Reporting training

Tamkang University, New Taipei City, Taiwan Jun 2009

Bachelor of Business in Statistics

Statistics, Mathematics, Time series, Survival analysis, Regression analysis, Business analysis, Machine Learning

Contact this candidate