Zetao Huang

CSCI 3081W – Visual Transit Simulator

• Brief : Re‑engineered a full‑stack simulator that animates campus buses / trains in real time, added Factory‑Observer‑Decorator patterns, upgraded JSON/WebSocket messaging, and drove > 90 % unit‑test coverage—all while keeping browser graphics perfectly synced.
• Tech : Java 17 (Gradle + JUnit), JavaScript/HTML

CSCI 4211 – Real‑Time Publish/Subscribe Messaging System

• Brief : Led a TCP pub/sub service that pushes live WEATHER and NEWS feeds to online users and safely queues messages for offline subscribers with strict topic validation.
• Tech : Python 3 (socket, threading)

CSCI 5801 – Voting System

• Brief : Delivered an election platform that supports Plurality, STV, and new Municipal Voting; transitioned from Waterfall to a two‑week Agile/Scrum sprint, enabling multi‑file input and auto results reporting.
• Tech : C++17 (STL, Google Make/CLI)

• Manufacturing Process Visualization (KPI Dashboard) – Aggregated production logs (SQL + Excel) from an automotive‑parts client, cleaned & normalized 30 k + rows, and built a Power BI dashboard that surfaced cycle‑time bottlenecks and scrap‑rate trends for weekly ops reviews.
• Smart‑Park Digital Transformation Study – Bench‑marked 20 + domestic “smart park” cases, quantified energy‑use, asset‑tracking and safety KPIs, and delivered a gap‑analysis dataset that mapped directly to the park’s construction targets.
• Data‑driven proposal drafting – Co‑authored the preliminary roadmap covering project, energy and materials management modules; aligned recommendations with China’s national green‑transformation guidelines and secured client go‑ahead for the next phase.

• Data classification & lifecycle tagging – Catalogued sensitive business data for the SaaS OA platform, designed a metadata‑tag schema and traceability workflow that streamlined security audits.
• Database performance & hardening – Optimized SQL queries and indexes in MySQL/PostgreSQL and structured MongoDB collections, improving read/write efficiency while applying least‑privilege access rules.
• Encryption & key management – Integrated AES (symmetric) and RSA (asymmetric) utilities for data‑at‑rest / in‑transit protection and drafted a lightweight key‑management workflow for secure key generation, storage, and rotation.