Technical Projects

Turn my knowledges to products

Work In Progress – Career Platform for UBC Students

Type Group Project
Location Vancouver, BC
Date April 2024 - Septempber 2024
  • Participated in development using agile methods, ensuring on-time delivery of key features.
  • Developed a responsive website using TypeScript under React.js framework, creating tailored views for different user types (recruiters and students), enhancing user engagement and satisfaction.
  • Implemented an object relational mapping (ORM)-based PostgreSQL database and integrated with Firebase, ensuring secure and reliable management of company, student, and recruiter data.
  • Integrated Google Cloud Platform (GCP) for secure file and photo storage, implementing GCP buckets and key-based file management to enhance data security and retrieval efficiency.
    Technology: React.js, Node.js, TypeScript, HTML/CSS, TailwindCSS, PostgreSQL, GCP, Firebase

Crabber X Volunteer – Platform for Crab Researchers

Type Group Project
Location Vancouver, BC
Date July 2024 - August 2024
  • Participated in developing a platform for the Belcarra Beachkeepers summer program using an agile workflow.
  • Built a minimalist website with JavaScript and React.js, catering to volunteers, supervisors, and the public.
  • Designed a SQL script to create 16 BCNF normalized tables, modeling relationships among Volunteers, Supervisors, Crabbers, Traps, Crabs, and the Calendar.
  • Developed 17 endpoints using JavaScript and Oracle SQL with Node.js, allowing frontend users to perform basic CRUD data queries as well as Joined Selection and Aggregation through API calls.
    Technology: React.js, Node.js, HTML/CSS, Oracle SQL

Mappost - Social Platform App Development

Type Group Project
Location Vancouver, BC
Date September 2023 - November 2023
  • Developed a location-based social platform app for travelers, where users can capture beautiful moments, drop down a pin on the built in map, and share their experiences with many others.
  • Created over 100 REST API endpoints on a Node.js server, enabling smooth communications between MongoDB database and a frontend App built with Android Studio
  • Hosted the server on Azure VM, and protected user security by using Firebase Authentication, and manually setting up HTTPS communication protocol with Certbot https certificates.
  • Utilized ChatGPT 3.5 Turbo for text analysis, postings tag generation, and censorship.
  • Achieved 100% branch coverage on JEST backend testing and 0 Codacy error, while performing test-driven development method and Agile development workflow.
    Technology: Node.js, MongoDB, Azure VM, Firebase, Android Studio, JEST, Codacy

TicketSwift - Automated Ticket Purchaser

Type Personal Project
Location Vancouver, BC
Date June 2023 - July 2023
  • Developed an automated ticket purchaser that helps users to purchase their desired convert tickets the first moment when it is released on Damai.cn.
  • Utilized Selenium with Chrome WebDriver for DOM interactions and dynamic webpage traversal.
  • Programmed a Python script that traverses website with specific keywords and inserts pre-entered JSON info, allowing users to automatically login into Damai.cn, reach the desired concert ticket window and purchase the ticket with script inserted information.
    Technology: Selenium, Python, JavaScript, JSON, Chrome WebDriver

Leyangpan.me - Personal Website Development

Type Personal Project
Location Vancouver, BC
Date June 2023 - July 2023
  • Deployed personal website via Cloudflare using HTML/CSS and JavaScript with the assistance of Hugo
  • Protected personal information through designated DNS records and settings
    Technology: Cloudflare, JavaScript, HTML/CSS, GoLang, Hugo
Menu