Description
Banner Box is an internal enterprise web application developed to streamline and automate staff interactions with Kalamazoo Valley’s Ellucian Banner ERP system. The application provides a secure interface for authorized users to modify and retrieve records across multiple domains, including student records, financial aid, enrollment, and other institutional data.
Rather than requiring staff to submit IT tickets for large-scale updates, Banner Box enables bulk data operations through CSV uploads. The system parses and transforms uploaded data, applies validation rules, and executes structured database operations, significantly reducing manual intervention and improving operational efficiency. The application provides a user-friendly interface for staff to access and manipulate data without needing direct access to the underlying database or command-line tools. It serves as a crucial tool for administrative tasks, data management, and reporting within the institution.
Contributions
I independently designed and developed the Banner Box as a full-stack enterprise application using Golang for the backend and Vue.js for the frontend. I architected and implemented the REST API, defining endpoints, to securely support full CRUD operations across Banner systems while adhering to institutional data governance policies.
The application integrates with Azure for authentication and role-based access control, ensuring that only authorized staff can perform sensitive data operations within the system.
The backend includes CSV parsing, data validation, and data transformation logic to automate large-scale record updates while maintaining data integrity. I built the system to abstract complex database operations into a controlled and user-friendly interface for staff.
In addition to application development, I manage all ongoing deployment and hosting of the system, system updates, and environment configuration for Banner Box.