Software Development
ElevatEd School
Manager and Employee Dashboard
-
Automatically generated essay prompts based on the current year's supplemental essay prompts
-
Word count and warnings for any submissions under 150 words
-
Toggle for selecting a specific editor for an additional 20%, leading to increased revenue and use of the service
Presentation to Company Executives on the progress of the project along with the intended results and contribution to the company as a whole
Screenshots of the Company at a Glance and Revenue Breakdown pages of the dashboard
ElevatEd School
Season of Ink Database
-
Built full-stack cross-platform application integrating Airtable, Cognito Forms, and Pabbly Automations for 100+ competition participants, automating 60% of data transfer processes and eliminating 15 hours of weekly manual work
Screenshot of the database in Airtable, also featuring automations that auto-assign submissions to judges based on hours available that week.
Screenshot of the Pabbly Automations, which process entries in Cognito Forms -> Upload submissions to Google Drive -> Send relevant information to the Airtable Database.
Tunefoolery Music
Automated Schedule-to-Payroll System
-
Built a Google Spreadsheet utilizing Apps Script that takes the current schedule for performing musicians, adds the events to a Google Calendar, and updates a Payroll Google Sheet with the musician's projected payment, reducing time spent logging payroll by 75% (from 4 hours to 1 hour per month) and eliminating data entry errors
Snippet of code in Google Apps Script taking schedule entries and sending them to the payroll spreadsheet