2023 Senior Projects

Grail parses a Python AST into executable GemStone Smalltalk code, providing Smalltalk's relational database integration to Python developers. Contributions include a scoped variable system, three-quarters of Python's built-in functions, complex number support via Euler's formula, and a string-injection formatter matching Python's output precision.

Integrated a user interface with the Open Acidification Alkalinity Titrator, a Raspberry Pi device for ocean-acidification research. Rewired hardware, updated deprecated CircuitPython libraries, created device mocks for each peripheral, and built a tkinter GUI to allow development without the physical device.

Developed a dynamic range map function for interval join algorithms in Apache AsterixDB, eliminating the need for manual SQL++ hint queries. Implemented the IntervalRangeMapDescriptor to compute split points and percentages automatically, and wired it into a sort-merge interval plan with replicate, forward, and partitioning exchange operators.

Redesigned the PointCheck browser application for HTS Ontario to support mobile devices. Implemented three responsive layout breakpoints using Flutter Flex widgets, a collapsible drawer for the equipment tree on mobile, and a proportional logo scaling function. Submitted as a pull request to the company's repository.

Developed MxHub Web, a React web application for Alaska Airlines aircraft line technicians to view flight lists, maintenance items, and aircraft status. Built data-mapper functions to parse large API responses into typed class instances, and implemented a dashboard, filters, persistent navbar, and aircraft search component.

Extended the Open Acidification Tank Controller Manager web application with new features and developer tooling: a remove-tank button, async IP address validation, a custom Dart linter, UI shortcuts for editing tank settings, file upload support, improved README documentation, and an updated Open Acidification project website section.

Built a new JumpStart freshman-orientation scheduler for Walla Walla University using PeopleCode and T-SQL within PeopleSoft. The scheduler supports general and group sessions with conflict detection, automated schedule generation, and manual adjustments via four components: Session Keys, General Schedules, Group Schedules, and Student Schedules.

Built a nursing administration simulation application in Flutter and Dart with a Shelf backend, allowing nursing students to practice medication administration safely. Features include patient management, a MAR calendar, inventory tracking, activity logs, Azure AD single sign-on, and barcode scanning support.