Uniform Carry and Acquire Permit Printing System (UCAPPS)

Role:		Lead Developer
Scope:		Web Application with 100+ pages. Used by 150+ active users with over 20,000 page views per week.
Technologies:		Oracle APEX, Oracle Database, PL/SQL, SQL
Description:		A change in the law in 2017 required a system to be built to allow the centralized printing of weapon permits in the state of Iowa. UCAPPS is a web application that allows for sherriff office clerks in all 99 counties in Iowa to upload and maintain their county's weapons permit data in a centralized database, for the purpose of printing uniform permit cards. The application features custom-built Multi-Factor Authentication, custom pdf reporting, and automated file processing of weapons permit data. As the Lead Developer on this project, I guided the development of this project from inception through go-live to production, and have been maintaining and implementing enhancements to the application for 3+ years.

Sex Offender Registry Application (SORA)

Role:		Technical Lead
Scope:		Web Application with 100+ pages. Used by 200+ active users with over 100,000 page views per week.
Technologies:		Oracle APEX, Oracle Database, PL/SQL, SQL, RESTful Web Services, Javascript
Description:		The Iowa Sex Offender Registry is a database maintained by the state of Iowa and used for the storage, maintenance, and sharing of sex offender data. Starting in 2019, I was the technical lead on a project to re-write the database and accompanying web application from the ground up. This project had a lot of depth, with development done in cycles while working with subject matter experts from the client. The application also required the use of extensive RESTful and SOAP web services to integrate with a number of other government institutions. After go-live in December 2020, I have continued to support the application and implement additional enhancements.

Iowa State University Supplemental Instruction Attendence Management

Role:		Team Lead
Scope:		Web application with background automation. Used by 50+ student leaders each semester.
Technologies:		PHP, Shibboleth, Python
Description:		This was a project to create a time and money-saving tool for the ISU Supplemental Instruction Team. Supplemental Instruction (SI) is a program where student leaders tutor other undergrad students in certain difficult classes. The SI leaders' task of tracking attendance at their sessions included tedious, time-consuming data migration between a database and various spreadsheets stored online. This project created a web application that gave SI leaders an easier way to track attendance, and automated the data migration tasks they were doing before, saving the users hours of time each week, and saving the university money. The project was an overwhelming success and received 2nd place among the ISU ECpE Senior design projects in May 2017.
Link:		Iowa State SI Attendance Management

D&D Discord Bot

Role:		Contributor
Scope:		A fun discord bot, with potential plans to publish as open source
Technologies:		Python, Git
Description:		While playing D&D online with my friends, we came up with the idea to build a discord bot that would allow us to do a number of things, such as play background music for everyone to enjoy, or generate all sorts of things, from fantasy drinks to insults spoken by the bard, using stored tables we had created. The bot is integrated with Google Drive's API to give us a central storage location for audio files and lookup tables, and we have plans to eventually run the bot in the cloud,expand its capabilities, and publish it a an open source project for other online D&D players to use and enjoy
Link:		D&D Discord Bot