2021 Senior Projects

Contributed to AsterixDB, an Apache open-source NoSQL database, by implementing six remaining Allen's relations for interval sort merge join and building interval time sweep join from the ground up. All thirteen Allen's relations now pass runtime tests. The time sweep join framework — physical operator, operator descriptor, active sweep manager unit test, and join algorithm — is complete and passing all interval join tests, advancing the goal of improving interval query performance in AsterixDB.

Built a React web application for Goldstream Engineering, a civil and structural firm based in Fairbanks, Alaska, to replace a costly third-party site-visit documentation tool. The app works fully offline using a service worker and local storage, captures all required site-condition inputs, and exports the recorded data as a downloadable text file — meeting the three core requirements of offline operation, complete data capture, and portable output.

Created CourseControl, a free and open-source WordPress plugin that adds web course management to any WordPress site. The plugin supports a three-level hierarchy of Courses, Modules, and Lessons stored as custom post types with bidirectional metadata links, a unified admin submenu, filtering by parent object, and proper cleanup on deactivation. Built in PHP following WordPress coding and GPLv2 licensing guidelines and tested with PHPUnit and WP-CLI on a Raspberry Pi LAMP stack.

Designed and built a full-stack patient rewards system for Oasis Physical Therapy to increase plan-of-care completion rates. The React application runs as both a mobile web app (deployable via Apache Cordova to iOS) and an admin web portal, backed by Firebase authentication, Firestore, and Firebase Hosting. Key features include QR code scanning for achievement verification, a leaderboard with HIPAA-compliant pseudonymous usernames, achievement management for admins, and a continuous integration pipeline using GitHub Actions and the Firebase Emulator.

Refactored the TankController firmware for Dr. Kirt Onthank's ocean-acidification research tanks at Walla Walla University. Replaced a monolithic switch-statement loop with a state machine architecture that eliminates blocking on user input, improves maintainability, and simplifies future feature additions. Contributions include wrapping all hardware devices in testable classes, implementing a reusable NumberCollector state for numeric input, and adding comprehensive unit tests — work that has since been merged as the new trunk of the open-source TankController project and deployed on physical research tanks.