CSI Student Chapter

Overview

The CSI Student Chapter project encompasses the official public-facing platform and a comprehensive internal admin dashboard for the university's technical society. The problem it solves is the administrative chaos of managing large-scale student events, recruitments, and participant data. Previously, the chapter relied on fragmented Google Forms and spreadsheets, leading to data loss, miscommunication, and inability to track historical participation metrics effectively. The platform was built entirely with Next.js, utilizing PostgreSQL and Prisma for the database layer. The core architectural feature is a highly dynamic form builder engine. Instead of hardcoding registration forms for each event, I engineered a system where administrators can create custom forms with conditional logic, diverse input types, and team-size constraints directly from the dashboard. The backend intelligently serializes these dynamic schemas into a flexible relational database structure. Chart.js was integrated into the admin panel to provide real-time visual analytics of registration trends and event-wise participation breakdowns. A significant technical hurdle was allowing administrators to edit live registration forms without compromising or corrupting the data of users who had already registered. I solved this by implementing a versioning system for form schemas; when a form is altered, the underlying schema version increments, and the application layer maps legacy responses to the updated schema dynamically. Additionally, handling concurrent registrations when an event reaches its capacity limit required strict database transactions. The outcome is a professional, robust internal tool that has completely modernized the chapter's operations, saving hundreds of administrative hours per semester.