Data Analytics Engineering

Jiaqi Zhuo

Phone Number: 857-***-**** Email: ******@*****.*** LinkedIn

EDUCATION

Northeastern University Boston, MA

Master of Science in Data Analytics Engineering Sept. 2022 - May 2024

• Coursework: Data Mining, Economic Decision Making, Operation Research, Computation and Visualization Ningbo Insitute of Technology, Zhejiang Univeristy. Ningbo, China Bachelor of Engineering in Electrical and Engineering and Automation. Sept.2018 - May 2022

• Coursework: C Programming, APP Development, Computing Method

• Award: Zhejiang Provincial Government Scholarship in 2019&2020&2021, Academic first-class Scholarship in 2019&2021

• Leadership: Director of Career Development Department of College Student Union SKILLS

Programming Skills: C, C++, ArcGIS PRO

Technical Tools: Excel (Vlookup, Index, Date, logical function, financial function PV, FV, DDB,PMT, ANOVA), SQL, Python

(NumPy, Pandas, Sklearn, Matplotlib, Seaborn, Pyplot), NoSQL (MangoDB), PowerPoint, Tableau, Visio, Power BI Language: Chinese(Mandarin), English

PROJECTS

Car Price Prediction and Sales Price Strategy Setting Project, Northeastern University Jan. 2023 - Apr. 2023

• Data Processing: Collected and processed data of car prices with different brands and attributes from Kaggle, cleaned the data, and outputted a CSV file without outliers and invalid values, which has 5 categorical, 15 numerical predictors, and 17238 rows.

• Statistical exploration: Conducted hypothesis testing and ANOVA to determine the confidence interval of price fluctuation.

• PCA: Conducted PCA including getting dummies, normalization, and standardization, to reduce 2 dimensions and redundancy of the price data.

• Forcasting Model: Developed 5 numerical prediction models, including Linear Regression, KNN, Random Forest tree, Decision Tree, and Neural Nets to predict price based on 4 error metrics and gains and lift charts to select the best-fitting model.

• Customer Analysis: Explored popular brand and customer’s preference regarding customer’s age, period and area by Matplotlib and Seaborn packages.

• Pricing Strategy: Created a report to present how different attributes determined the car price, provided a trend of pricing interval depending on cars’ mileage and brands and suggestions. Delivery Chain Relationship Study and Management Project, Northeastern University Jan. 2023 – Apr. 2023

• Modeling: Built EER and UML model, owning 12 entities, to display the relationship of delivery time and methods between the deliver company, customer, order, merchant company, and supervision department by diagrams.

• Data Management: Managed the data by creating the schema and catalog, and importing 16 tables and schema into MySQL workbench to save platforms’ time in retrieving order details from different tables and improved shipping quality.

• EDA: Analyzed distribution and the delivery pattern based on the order number and preference by a pie chart and histogram in the different regions by Python, which helped with dividing the delivery region to reduce the delivery time by 23%. Relationship Between Forest Coverage Rate & Greenhouse Gas Project, Northeastern University Sept. 2022 – Dec. 2022

• Data Cleaning: Cleaned the multiple gas emission data by years from “Our World in Data” by detecting unique cardinalities, handling outliers, duplicates, and null values with Python, reducing incomplete and irrelevant data entities by 50%.

• Data Visualization: Visualized different gas emission pattern in time and geographical dimensions in Tableau.

• Dashboard Development: Developed an interactive dashboard, joined tables, and utilized dimension and measure filters to select data lying in time dimension, filtered countries to zoom from world map into the country map, visualized multiple data layers simultaneously with Tableau, and uploaded the dashboard to the cloud and link with database to update simultaneously. EXPERIENCE

Zhejiang Dahua Technology Co., LTD. Zhejiang, China Product Manager Intern Jun. 2021 - Sept. 2021

• Consulting: Cooperated with sales team to consult with 7 customers from 6 department of the government bureau, complete the technical list configuration, program output, and product introduction according to customer’s demand, and requirement, and achieved a 75% customer retention rate.

• Cross-Functional Teamwork: Collaborated with sales and representatives, transforming customers’ verbal demands into a list of product parameters and prices corresponding to products and systems. Jiangsu Chenwu Energy Saving Technology Co., Ltd. Zhejiang, China Electrical Engineer Intern Jul. 2020 - Sept. 2020

• Product Management: Investigated and decomposed product specifications and requirements, wrote code, debugged and output overall hardware schemes, detailed hardware designs, and delivered to back-end engineer.

• SOP: Streamlined operation procedures by writing product manuals for 2 large controlling products, which increase the efficiency by 50%.

• Project Management: Aligned goals, updated, and documented the product functions and ideas, set weekly progress and connect with patent experts, implemented planning and technical support with the team, and designing 5 utility model patents.

Contact this candidate