Data Analyst

Kelly (Yisi) Liu

**********@*****.*** (***) *** – 8880

EDUCATION

Loyola University of Chicago, Chicago, IL

Master of Science in Business Analytics November 2020 GPA: 3.80/4.00

Course Highlights: Python Programming, Forecasting Methods, Database Management, Data Visualization, Data-Driven Decision-Making, Statistics, Financial Modeling, Data Mining Master of Science in Human Resources Management August 2019 GPA 3.65/4.00

East China Normal University, Shanghai, China

Bachelor of Arts in Education Management June 2017 INTERNSHIP EXPERIENCE

McKlein Company LLC, Chicago, IL May 2020 – December 2020 Data Analytics Intern

● Utilize Python web scraping techniques to acquire product data from Amazon, producing an increase in sales by 40%

● Support the company’s business needs by running SQL queries against their internal database

● Optimized the existing reporting procedure and increased reporting efficiency by 50%

● Aggregated data from multiple data sources to build a dashboard and reports

● Utilized SAP and DTW to manage the company’s client and product data

● Established a database diagram to increase the efficiency of employees by 40%

● Contributed to the company’s new product launch by managing project efforts and migration of product data to a different portal

Mandarin Consulting, Los Angeles December 2018 – February 2019 Analytics Intern

● Developed an employee compensation calculation system using Python to increase accuracy by 40%

● Analyzed the company's projected four-year expenditure plan using stepwise regression and data visualizations in Tableau to identify strategies for reducing expenses by 30%

● Streamlined the weekly reporting process using SQL and data visualizations in Tableau to automate the report

● Analyzed employee retention data by using Python and decision tree models to identify ways to increase retention by 45%

● Performed analyses on websites utilizing Google Analytics by tracking landing pages via configuration, through which site traffic improved by 34%

● Predicted the company's revenue using time-series forecasting models, based on historical data PROJECT

Labor Market Intelligence, Greenwich HR Inc., Location November 2019 – January 2020

● Performed data cleansing, including format correction, name normalization, and data categorization, on 10G of data

● Calculated hiring-demand metrics, including inventory count and salaries, on a three-year rolling basis

● Predicted future hiring demand and costs using the ARIMA model to show trends in the labor market

● Developed interactive data visualizations to exhibit business insights for client presentations SKILLS

Technology: SQL, Python, R, SAP, Google Analytics, Tableau, SPSS, Power BI, Microsoft Office Suite Language: Mandarin (Native), English (Fluent)

Contact this candidate