Data Analyst

Qing (Poppy) Liu

**** ****** ***** *****, ******, VA 20190

(573) 554 - 6426 ************@*****.***

https://www.linkedin.com/in/qing-liu-9892b6151/

EDUCATION

The University of Missouri, Columbia, MO August 2015 - May 2017

Master of Science, Statistics

The Hubei University of Economics, Wuhan, HB September 2011 - June 2015

Bachelor of Economics, Statistics

SKILLS

Cloud: GCP, AWS, Azure

SQL/ NoSQL: PostgreSQL, HBase, MongoDB, Oracle

Programming Languages: R, Python, SAS, Julia, SPSS, STATA, Matlab

Machine Learning: Supervised, Unsupervised, Semi-supervised and Reinforcement Learning

Visualization/BI: Tableau, Power BI, Google Analytics, SAP Business Objects

WORK EXPERIENCE

Network for Good, Washington, D.C.

Data Specialist November 2017 – Present

Responsibilities:

Coordinated efforts in product team and customer success team to improve the data import process and address inefficiencies, increased the on-time cases delivery rate by 35 percent.

Designed an algorithm to identify the decay effect of advertising spend, built marketing mix model to predict the inquiries by given budget spend, the difference between projected inquiries and actual inquiries is below 10 percent.

Designed and implemented a data migration procedure for clients, created 8 data formatting templates for them to optimize the legacy data quality and help them collect and store data more efficiently, improved client’s satisfaction rate by 18 percent.

Assisted in building statistical models on the integrated data, conducted analysis including marketing attribution and donor behavior.

Worked with the business analysts on projects to analyze data from multiple information systems and create reports that provided insight into business processes, presented complex findings to upper management team enabling data-driven business decisions.

Compiled requests for changes to product design, website content, and website design

Cleaned and transformed the data from various external systems and migrated the data to the NFG Donor Management System using Excel (VBA, pivot tables, functions) and executing SQL scripts.

Environment: Oracle SQL, Excel, R, Tableau

Invexer Technology Inc., Manassas, VA

Data Analyst Intern June 2017 – October 2017

Responsibilities:

Collected raw data of business owners from the U.S. Census Bureau and compiled data with R underlying the proposal of an investigation into women-owned business in the U.S.

Applied data transformation method for rescaling and normalizing variables, performed machine learning (Boosting method) on predictive models to improve/optimize model performance.

Completed preliminary work for discussion and built a web app by shiny in R to deliver project requirements to the team.

Delivered Interactive visualizations and dashboards using Matplotlib, ggplot, Tableau to present analysis outcomes in terms of patterns, anomalies, and predictions.

Created multiple workbooks, dashboards, and charts using calculated fields, quick table calculations to meet business needs.

Prepared comprehensive documented observations, analyses and interpretations of results including technical reports, summaries, protocols, and quantitative analyses.

Environment: Python, R, Tableau, AWS, Excel

China Construction Bank, Wuhan, HB

Research Intern February 2015 – May 2015

Responsibilities:

Established a flexible service scheduling system for adjusting the number of on-site agents

Categorized and graded all funds in China utilizing Excel and R software.

Provided prediction for client company’s stock options price by Greeks Methods which contain five risk measures.

Designed a new Monte Carlo simulation model to investigate the trends of the stock price.

Designed a revenue forecast model using time series to help cash flow management and support leadership’s financial and operational decisions.

Conducted enhanced due diligence on the transactions by identifying customer’s address, ownership structure, business sector, payment purposes, and transaction patterns, to look for potential red flags

Environment: R, MS Office Suite, MS Visio, MS SharePoint

Contact this candidate