Qing (Poppy) Liu
**** ****** ***** *****, ******, VA 20190
(573) 554 - 6426 email@example.com
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
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
Network for Good, Washington, D.C.
Data Specialist November 2017 – Present
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
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
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