Data Analysis

Guiyuan Chen

NJ United States

647-***-**** ***************@*****.***

EDUCATION

University of Waterloo Waterloo, Canada

Bachelor of Mathematics in Data Science Sep 2020 – Dec 2024

● Cumulative GPA: 3.83/4.00

SKILLS

● Tools: SQL, Python, C, R, C++, Tableau, Power BI, Excel, Spark, Hadoop, Matlab

● Strengths: Proficient in analyzing complex datasets to deliver actionable insights and data-driven recommendations. Experienced in database management, workflow automation, and leveraging new technologies to develop innovative, optimized data solutions. EXPERIENCE

University of Waterloo Waterloo, Canada

Faculty of Mathematics, Undergraduate Teaching Assistant Sep 2024 - Dec 2024

● Provided one-on-one and group tutoring to enhance students’ understanding of statistics concepts, problem-solving skills, and analytical thinking

● Evaluated assignments and exams, offering constructive feedback to support academic growth PROJECTS

Community Data Analysis Python & SQL

● Conducted data collection and cleaning on community demographic surveys to identify population trends.

● Performed exploratory data analysis (EDA) and generated insights on socioeconomic factors using Python and Pandas.

● Presented findings through interactive visualizations in Tableau to support local policy decision-making.

Real Estate Market Trend Analysis R & Tableau

● Designed an independent housing price analysis project using publicly available real estate data.

● Processed large datasets, performed data cleaning, and applied statistical models to detect pricing trends.

● Developed interactive dashboards in Tableau to visualize market patterns and provide investment insights.

SQL Query Processing & Optimization Spark & SQL

● Designed and implemented SQL queries on TPC-H benchmark data using Spark.

● Processed large-scale datasets and optimized query execution

● Implemented SQL-based solutions for retrieving high-value orders, customer transactions, and supplier statistics.

ADDITIONAL INFO

● Languages: Fluent in English and Chinese

● Certifications & Trainings: Google Data Analytics Professional Certificate

● Citizenship: Canadian Citizen (Eligible to work in the U.S. under TN Visa)

Contact this candidate