Selected work

Projects

Data Extraction Tool
๐Ÿ”’ Government / Internal

Data Extraction Tool

An R Shiny application built for Fisheries and Oceans Canada that connects to an Oracle database. Users upload a Microsoft Access database and the tool performs ETL โ€” extracting, transforming, and outputting data in the correct format required for scientific workflows.

OracleRR-Shiny
Salmon Population Summary Repository (SPSR)
๐Ÿ”’ Government / Internal

Salmon Population Summary Repository (SPSR)

A Django application for browsing, exporting, and uploading salmon population summary data and metadata. Supports six public data routes (Population, CU, SMU, Indicator, PFMA, Status/Composite), Salmon Data Package uploads and exports, a read-only REST API with OpenAPI/Swagger docs, and assessment-aware versioning.

DjangoPostgreSQLPython
Genetic Results Database
๐Ÿ”’ Government / Internalโš™ In Progress

Genetic Results Database

In progress โ€” a PostgreSQL database schema redesigned to handle both historical and new genetic data across different formats for Fisheries and Oceans Canada. A Next.js frontend will allow users to query and export data in the format they need.

Next.jsPostgreSQLTypeScript
Receipt Tracker

Receipt Tracker

A mobile app that scans receipts using OCR and AI to automatically extract the merchant, total, and category โ€” then organizes, analyzes, and exports your spending with charts and reports. Built with React Native; available on the App Store.

AIOCRReact Native
Inventory App

Inventory App

A business inventory management app that tracks stock levels and automatically generates shopping lists from low-stock items. Built with Next.js and TypeScript, backed by a Supabase Postgres database with real-time sync.

Next.jsSupabaseTypeScript
Brazen Poppy Bakery

Brazen Poppy Bakery

A marketing website for Brazen Poppy, a cafรฉ and bakery in Parksville, BC โ€” featuring their menu, hours, location, and story. Built with Next.js and TailwindCSS, deployed on Vercel.

Next.jsTailwindCSSWeb Design
Notes.ai V3.0

Notes.ai V3.0

A mac OS application that uses OpenAI whisper model to generate notes from the user's voice. The app is built with React, Python, Node.js, and Electron. Version 2.0 is available on the App Store.

ElectronNode.jsPythonReact
Wu's Portfolio V2.0

Wu's Portfolio V2.0

A personal portfolio website built with React and TypeScript. Responsive and mobile-friendly.

ReactTypeScript
Hands On

Hands On

A mobile application that connects busy people with reliable helpers in their local area. Built with React Native and Expo; backend with Node.js, Express.js, and Firebase.

Express.jsFirebaseNode.jsReact Native
Chatbot

Chatbot

A personal ChatGPT interface using the OpenAI API and Vercel Edge functions with streaming. Users bring their own API key and can switch between models without a ChatGPT Plus subscription. Built with Next.js and TypeScript.

Next.jsOpenAITypeScript
VFriend

VFriend

A mobile application that lets users create and interact with virtual characters. Built with React Native and Expo, integrated with the OpenAI API.

FirebaseOpenAIReact Native
Fever Scanner

Fever Scanner

A Raspberry Pi project that uses a thermal imaging camera to monitor users' body temperature. Users scan their NFC tags to identify themselves, which triggers the camera to capture and record their temperature.

Python
Dream House

Dream House

A responsive real-estate showcase website built with HTML, CSS, Bootstrap, and JavaScript.

BootstrapCSSHTMLJavaScript
Wu's Portfolio

Wu's Portfolio

Version 1 of my portfolio website, built with HTML, CSS, and JavaScript. Responsive and mobile-friendly.

BootstrapCSSHTMLJavaScript
Canada Market

Canada Market

A house-hunting website built with WordPress. Responsive and mobile-friendly.

CSSHTMLPHPWordPress