Featured projects

Project archive

I've created a variety of web apps, cloud services, and enterprise data integrations. Here are some additional projects I have worked on.

Door controller status monitor

PowerShellOracle PL/SQL

Script that collects status information from IP door controller devices and aggregates results for reporting

SMS forwarding service

Node.jsCloud Functions for FirebaseFirebase Realtime Database

Service that forwards SMS messages sent to an old phone number, and auto-replies to notify senders of the new phone number

PC hibernate service

Node.jsCloud Functions for Firebase

Cloud function that relays hibernate requests to a PC, used with Flic buttons

Event RSVP app

Node.jsVue.jsVuexNuxt.jsFirebase Cloud FirestoreCloud Functions for Firebase

Website that shares event information and collects RSVPs from authenticated guests

LDAP authentication integration

PHPLDAPMySQL

Authentication infrastructure shared by a suite of web apps, integrated with an Active Directory instance, and extended with magic link authentication for guest accounts

Pull-from-pool performance optimization

Oracle PL/SQL

Stored procedures to randomly allocate pool numbers into smaller cache tables to reduce pull time in vendor software

Card production management

PHPMySQLOracle PL/SQLjQuery

Web app that integrates custom fields, tracking/reporting, and keyword-based search tools into a vendor ID card printing system

Visuari

PHPSymfonyMySQL

Photo album publishing platform, featuring an upload manager, captions, and granular sharing

Access plan management

PHPMySQLOracle PL/SQLjQuery

Web-based access plan management tool that enables complex access plan structures to be efficiently defined using a SQL-based adjacency list model and synchronizes access plans with an enterprise campus card system

ID photo management

PHPMySQLOracle PL/SQLjQueryAWS S3Apache modules

App that manages ID photos for an enterprise campus card system, including uploads, review and approval, editing, and synchronization with external systems

Emergency lockout code utility

PHPMySQLjQuery

Web app that provides lockout codes for occupants of residential spaces, including an integration of encrypted security question answers and an interface to import and encrypt lockout codes

Housing check-in client

PHPcURLMySQL

Web app that automates administrative steps in an enterprise housing management system to save staff time and ensure data entry consistency

Housing availability visualization

PHPMySQLjQuery

Web app that displays an interactive, searchable list of available college housing spaces in real time, based on data from an enterprise campus housing system

Student payroll entry system

PHPMySQLJavaScript

Payroll time entry and reporting system for student employees