Skip to content
View Serena-z-hang's full-sized avatar

Block or report Serena-z-hang

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Serena-z-hang/README.md

Hi, I'm Junzhi Zhang 👋

M.S. Business Analytics student at the University of Rochester's Simon Business School.

I'm interested in using data to solve business and operational problems, with a focus on data analytics, business intelligence, and operations analytics.

Currently seeking Summer 2027 internship opportunities in Data Analytics, Business Analytics, Business Intelligence, and related roles.

Skills

  • Programming & Analytics: Python, SQL
  • Python: Pandas, NumPy, Matplotlib, scikit-learn
  • SQL: DuckDB, MySQL
  • Visualization & BI: Tableau, Excel
  • Analytics: Data Cleaning, EDA, KPI Analysis, Regression, Predictive Modeling

Featured Project

SQL · Python · Tableau

Analyzed 3.5M+ NYC Yellow Taxi trips to identify hourly demand patterns, zone-level pickup–dropoff asymmetry, and recurring operational patterns across high-volume NYC taxi zones.

  • Built data-quality checks for trip distance, duration, fare, and implied speed
  • Used SQL joins, CTEs, percentiles, and window functions for zone × hour analysis
  • Developed demand over-index and pickup–dropoff imbalance metrics
  • Validated recurring patterns at the day level rather than relying only on monthly aggregates
  • Built an interactive Tableau dashboard for operational exploration

View GitHub Repository · View Interactive Tableau Dashboard

Education

University of Rochester — Simon Business School
M.S. in Business Analytics, STEM
Expected December 2027

University of Shanghai for Science and Technology
B.A. in English

Connect

Pinned Loading

  1. citibike-station-rebalancing-analytics citibike-station-rebalancing-analytics Public

    Station-hour rebalancing analytics for 5.25M Citi Bike trips using DuckDB, Python, and Tableau.

    Jupyter Notebook

  2. nyc-mobility-demand-analysis nyc-mobility-demand-analysis Public

    SQL and Python analysis of NYC mobility demand, trip patterns, and operational KPIs using official TLC trip data.

    Jupyter Notebook