Jerry Han

Personal portfolio

Jerry Han

Projects

Selected projects from academic team work and open-source contribution, covering web applications, database internals, and systems programming.

Filter projects

5 projects in total

Softoom — Interactive 3D Web Application

Built a full-stack interactive application with a small team that combined a 3D user experience with account state, room interactions, ordering workflows, inventory management, and external service integrations.

  • Frontend
  • Backend
  • Full stack
  • Angular
  • JavaScript
  • Node.js
  • Express.js
View details

Technology stack

  • Angular
  • JavaScript
  • Node.js
  • Express.js
  • REST APIs
  • Three.js
  • Stripe
  • SendGrid
  • HTML
  • CSS
  • Full-Stack Development

Contributions and technical decisions

  • Developed application workflows connecting an Angular frontend with Node.js backend services through REST APIs.
  • Built interactive 3D room experiences using Three.js alongside user state, food ordering, inventory storage, and application data flows.
  • Integrated Stripe to support payment checkout and connected SendGrid for post-order email confirmations.
  • Connected frontend interactions with backend application state and third-party services to support end-to-end user workflows.

Momentie — Social Job-Seeking Platform

Built a social job-seeking platform with a small team for applicants and recruiters, combining professional profiles with social-media-style interaction.

  • Frontend
  • Backend
  • Full stack
  • React
  • TypeScript
  • Redux Toolkit
  • Node.js
View details

Technology stack

  • React
  • TypeScript
  • Redux Toolkit
  • Node.js
  • Express.js
  • MongoDB
  • Mongoose
  • React Router
  • REST APIs
  • Full-Stack Development

Contributions and technical decisions

  • Enabled users to create and edit profiles, maintain experience timelines, publish posts, and interact with other members of the platform.
  • Implemented login and sign-up workflows together with a profile-rating system supporting interactions between recruiters and applicants.
  • Developed reusable React and TypeScript components for application pages and interactive features.
  • Used Redux Toolkit to manage shared state across user accounts, profiles, posts, authentication flows, and ratings.

PostgreSQL — Database Internals

Worked directly with PostgreSQL source code to explore how buffer management, query execution, and query planning operate beneath the SQL interface.

  • Backend
  • C
  • PostgreSQL 17.2
  • SQL
  • Buffer Management
View details

Technology stack

  • C
  • PostgreSQL 17.2
  • SQL
  • Buffer Management
  • Query Processing
  • Query Optimization
  • Bloom Filters
  • Database Internals

Contributions and technical decisions

  • Implemented and evaluated LRU, LFU, and MRU buffer-replacement policies alongside PostgreSQL's Clock policy.
  • Compared replacement behaviour using different query patterns and buffer-cache configurations.
  • Extended hash-join execution with Bloom-filter runtime filtering to eliminate probe tuples that could not match the build relation before further processing and disk I/O.
  • Investigated how catalog statistics, cardinality estimates, indexes, histograms, and most-common-value statistics influence query plans and join selection.

Secure Network Protocol & Distributed Database

Designed and implemented an academic distributed data system combining encrypted client-server communication, certificate-based authentication, database sharding, and tamper-detection mechanisms.

  • Backend
  • Python
  • Diffie–Hellman
  • HKDF
  • AES-GCM
View details

Technology stack

  • Python
  • Diffie–Hellman
  • HKDF
  • AES-GCM
  • SHA-256
  • Certificates
  • Distributed Systems
  • Database Sharding
  • Networking
  • Mininet
  • OpenSSL

Contributions and technical decisions

  • Built a TLS-inspired communication protocol using Diffie–Hellman key exchange, HKDF session-key derivation, and AES-GCM authenticated encryption.
  • Developed a distributed database architecture with a routing layer and three sharded storage servers for directing requests to the appropriate data node.
  • Integrated certificate-based authentication through a custom certificate authority to validate communicating parties.
  • Added blockchain-style integrity protection using SHA-256 hashes and linked blocks to make stored-data modifications detectable.

LangChain — Open-Source Contribution

Investigated schema-generation behaviour in LangChain involving injected tool arguments and worked on improving how runtime-only parameters are represented and filtered from user-facing tool schemas.

  • Python
  • LangChain
  • Pydantic
  • JSON Schema
View details

Technology stack

  • Python
  • LangChain
  • Pydantic
  • JSON Schema
  • Python Typing
  • Annotated
  • WithJsonSchema
  • Open Source
  • Testing

Contributions and technical decisions

  • Traced the interaction between Python type annotations, injected arguments, Pydantic models, and generated JSON schemas.
  • Developed type-detection and filtering logic to distinguish runtime-injected parameters from arguments intended to be supplied by users.
  • Created Pydantic-compatible schema representations using `Annotated` and `WithJsonSchema` to preserve runtime behaviour while producing appropriate tool schemas.
  • Prepared runnable examples and tests to validate the proposed implementation and support review by project maintainers.