Zhicheng (Perry) Liu

Texas, United States 626-***-****

www.linkedin.com/in/perry-liu adjdmc@r.postjobfree.com Data Analyst

Data Analyst with a strong passion for solving challenging problems and exploring data insights. A hard worker with a continuous learning mindset and a positive attitude. A good listener with excellent written and verbal communication skills. A team player experienced working in a fast-paced, diverse environment. Technical Skills

• Programming Languages: Python, SQL, R, C/C++

• Databases: Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite

• Developer Tools: Anaconda, PyCharm, Visual Studio, Jupyter Notebook, SSMS, MySQL Workbench, EViews

• Business Intelligence Suites: SSIS, SSAS, SSRS

• Visualization and Reporting: Power BI, Tableau, Looker, Fine BI, IBM Cognos

• Statistical Analysis: Linear Regression, Logistic Regression, Hypothesis Testing, ANOVA, A/B testing

• Office Software Suite: Word, Excel, PowerPoint

• Languages: English, Chinese Mandarin

Education

• Master of Science, Business Analytics - GPA 4.00/4.00, Top 1% Texas A&M University-Commerce, Texas Jan 2019 - Dec 2020

• Bachelor of Science, Electrical Engineering - GPA 3.80/5.00 Chengdu University of Information Technology, China Sep 2013 - July 2017

• Exchange Student

National University of Singapore, Singapore Jul 2016 - Dec 2016 Experience

TEXAS A&M UNIVERSITY- COMMERCE, TEXAS Jan 2019 - Dec 2020 Graduate Research Assistant

• Managed econometric data by writing SQL queries to retrieve requested data from Databases (International Financial Statistics and Econometric Policy Uncertainty).

• Developed automated Python (Pandas, Numpy) scripts in Jupyter Notebook to clean raw data.

• Applied statistics analysis ARDL Regression Analysis using Eviews, selecting the most significant contributors for further research.

• Converted data into actionable insights by creating data visualizations using Tableau Desktop and publishing them on Tableau Server.

• Presented on “Monetary economic uncertainties in 19 Asia countries” at Texas A&M University Symposium in 2020, and received an Outstanding Researcher Award.

• Contributed to the A-Level Journal “US-Africa trade balance and the J-curve: An asymmetry analysis” published by Dr. Chuck Arize, Regents Professor in the Texas A&M System. Graduate Teaching Assistant

• Tutored students in Statistics Methods and enhanced students’ understanding of the course material.

• Graded homework, quizzes, and exams for >200 students; ensured all coursework was finished in a timely manner.

• Managed virtual learning, from initial set up to real-time classroom monitoring, throughout the COVID-19 pandemic. Contact: adjdmc@r.postjobfree.com, adjdmc@r.postjobfree.com Zhicheng (Perry) Liu adjdmc@r.postjobfree.com 626-***-**** PERKINELMER, INC, CHENGDU, CHINA Jul 2017 - Dec 2018 Data Analyst

• Developed ETL Pipeline in SSIS to extract sales data from heterogeneous sources and loaded them into Data Mart.

• Maintained the Data Mapping processes in SSIS, maximizing data integration efficiency and productivity.

• Conducted A/B Testing experiments for the product sales website, reducing the bounce rate by 11%.

• Applied Predictive Time Series Analysis and built Power BI Dashboards to discover regions of improvement; improved new customers identification process in Southwestern China. Projects

COVID-19 Pandemic’s Impact on Consumers’ Intention toward Online Grocery Shopping Led a team of 4 Graduate Research Assistants in developing Statistics Analysis based on customer survey data.

• Obtained raw data using the Qualtrics Survey platform to collect feedback from 776 consumers residing in Texas.

• Developed a Multi-Linear Regression Model using Python to discover the relationship between the response of Consumer’s Intention and 7 potential regressors.

• Ran 19 different regression models in Jupyter Notebook and selected the statistically best model, identifying two significant contributors.

Project Link: https://github.com/perryisbusy/Team-2/blob/main/Team%202.ipynb Predictive Analysis on the Volume of Air Passengers Built out a Time Series Analysis on air passengers in DFW airport to forecast future air volume based on the predictive model.

• Developed a data collection tool using Python to obtain air travelers’ daily volume from 2010-01-01 to 2019-09-30.

• Identified the changes of volume with a date index and conducted a Time Series Analysis based on a Seasonal Pattern in the Jupyter Notebook.

• Designed a data visualization report using Tableau and forecasted Q4, 2019 air passengers’ volume around 17M. Project Link: https://github.com/perryisbusy/Time-Series-Analysis-for-Air-Travelers Active Data Viz Community Member in Tableau’s “Makeover Monday”

• Participate in weekly data visualization challenges.

• Created 27 unique visualizations and published them on the community webpage. Examples: o A heat map showing Bob Ross’s usage of various art elements in his work o A stacked bar chart illustrating global Nintendo Switch sales o A time series depicting the number and percent change of visitors into the UK over time o A tree map presenting people’s views of remote work benefits o A butterfly chart exhibiting the distribution of mental disorder by sex and age group

• Won best visualization project for demonstrating exceptional data visualization ability in one of the weekly challenges.

Project Link: https://public.tableau.com/profile/perry.liu#!/ Certificates

• Tableau Desktop Specialist, Tableau, 2019

• Tableau Desktop Certified Associate, Tableau, 2020 Certificates Link: https://www.youracclaim.com/badges/3829dd07-3137-4b31-8074-d24368af3793 https://www.youracclaim.com/earner/earned/badge/b0972d52-1b5d-48bc-ae19-77b389d84c3d Portfolio

• Tableau: https://public.tableau.com/profile/perry.liu#!/

• GitHub: https://github.com/perryisbusy?tab=repositories

Contact this candidate