SQL, Python, Tableau

Ziqi Guan

Elmhurst, NY 347-***-**** ***********@*****.***

EDUCATION

Fordham University, New York, U.S. GPA: 3.8/4.00

M.S. in Business Analytics Spt. 2021– Jan. 2023

Honors: Dean's Scholarship

Relevant Coursework: Data Mining, Python, Database Management, SQL, Web Analytics, Weka, Big Data Analytics, Business Analytics for Manager, Stat Methods and Comp, Text Analytics, Deep Learning Vaughn College of Aeronautics and Technology, New York, U.S. GPA:3.69/4.00 B.S. of Science in Aviation Maintenance Management May. 2019 – Jun. 2021 Honors: Dean’s List

INTERNSHIP

Global AI New York, NY

Data Science Intern Jul. 2022 – Aug. 2022

Scraped rental listings data from Zillow using Python, processed the scraped raw data and plotted suggested rental information in a US heat map using Tableau

Performed statistical analysis on Sustainable Development Goal dataset including visualizing monthly 17 SDG scores and creating heatmap for correlations of each score

Using Autoregressive Integrated Moving Average model and recursive neural networks in Python to process Sustainable Development Goal dataset to predict 30 days' SDG goal with MSE scores comparison of 0.2 improvement, and then formulated business strategies accordingly

Generating risk management guideline and sustainable finance indicators for investment managers and other institutional stakeholders

Hirebeat New York, NY

Business & Data Analyst Intern Nov. 2021 – Dec. 2021

Collected, cleaned, transformed and normalized 10K+ data and categorized customers into different business areas to explore the market potential of ATS

Crawling information about job openings in the U.S. from the website with Python

Analyzed and interpreted the dataset with Potter’s five forces method, identified targeted industry for ATS based on estimated profits

Developed dashboard with Tableau to perform data visualization and business analysis for executive teams Maersk Line Remote

Part-time Data Analyst Dec. 2020 – Jan. 2021

Performed data exploration on sales data of Maersk with Python including reducing white noise

Explored the root cause of the fluctuation in Purchases and identified potential solutions behind data to alleviate the fluctuation by 20%

Visualized the data and business insights with pivot tables and scatter plots and provided data-driven recommendations to senior leadership

Investigated Maersk’s constructions on the block chain and innovative technologies by in-depth research RELEVANT EXPERIENCE

Price Prediction of Used Car Project Sept. 2021 – Dec. 2021

Used Python to crawl important information (Price, Make, Model, Year, Miles) from the website and built a SQL dataset to store these data after data cleaning

Applied linear LASSO model to predict the price of used car and achieved a 10% lift in adjusted R square compared with the linear regression model

Built a visualized dashboard with the best model selection and graphs for showing analytical results New York Airbnb House Price Analysis Apr. 2021 – Jun. 2021

Performed exploratory data analysis between the house price and potential features using Python

Conducted feature engineering by researching the domain of real estate appraisal to create significant features

Predicted house prices trends using different machine learning models such as Random Forests and achieved the highest R-squared score of sale prices with Gradient Boosting Tree with 30%+ prediction improvement SKILLS & INTERESTS

Technical Skills: Python, SQL, Tableau, R, Excel, SAP ERP, Weka Statistics & Machine Learning: A/B Testing, Time Series Analysis, Regression, Decision Tree

Contact this candidate