Lingyi Zhou
Portfolio Website
 All My Works

Ex. AR Engineer @ Snap Inc.
Ex. Unity Engineer @ Unity

MFA Design and Technology @ Parsons
MA Game Design & Development @ Columbia XR Developer
AR Development in Lens Studio & Effect House.
VR Development in Unity for Oculus Quest and Apple Vision Pro Game Developer
Unity Development for desktop and mobile games
Shader knowledge and development experience 3D Designer
Blender and Maya for stylized and realistic modeling and rendering  
Cinema4D for animation and procedural modelling  
 Full Stack Engineer
React front end + FastAPI Backend + Postgre database Graphic Designer
Adobe Indesign, Adobe Illustrator

03 Drag Task In - Time Management App

      Built in under 4 hours, this full-stack web app demonstrates rapid prototyping, clean design, and backend planning. It features intuitive drag-and-drop scheduling with real-time sync via Supabase and works offline with seamless sync on reconnect.      

      Key features include:      

  • Drag & Drop Scheduling using @dnd-kit
  • Real-Time Sync across devices (Supabase)
  • Offline Support with automatic sync
  • Print-Ready Layout & Responsive UI
  • User Authentication with email verification
  • Data Backup & Restore via JSON

      This project showcases my ability to quickly turn ideas into polished tools, and is a stepping stone in my journey toward building robust backends using FastAPI and PostgreSQL.      

🔗 Live App  |  💻 GitHub Repo

Next Step: I’m currently expanding this into a production-ready system with FastAPI. The roadmap includes JWT-based authentication, PostgreSQL integration, user-specific data protection, and secure RESTful API design. This will be a fully scalable backend powering personalized task management.    
Query Searching with Location Keyword

This demo shows how users can search hardware stores by entering a city name. The system sends a request to the Google Maps API and returns a list of nearby stores along with key business info. If the city has already been searched, the tool bypasses the API and pulls cached results from the database—cutting the response time from 10 seconds down to just 1 second.

Tech Stack: React, FastAPI, Railway

Language: JavaScript, Python

Client: James Hardware


INDEX  NEXT