InnoD Fam Tracker

As Vice President of Internals for Innovative Design at USC, I am responsible for improving the internal systems that keep our 70+ member organization running smoothly. One of our biggest operational bottlenecks was our semester-long "Fam" competition, where members earned points by completing activities and submitting photo proof in Slack. Previously, an internals team member manually reviewed every submission, identified the member and activity, calculated points, and updated an Excel spreadsheet—a process that took hours each week and was prone to error. To streamline this workflow, I approached the problem as a full product development project. I first mapped the existing process to identify inefficiencies and edge cases, then designed user flows, database relationships, and interface wireframes in Figma before moving into development. From there, I built a responsive web application using HTML, CSS, JavaScript, and React, with a custom interface. I designed the platform around semester-based data management, allowing leadership to create new semesters, preserve member histories, manage changing Fam assignments and Fam Head roles, and track permanent member information such as Driver status. To support these workflows, I architected a relational PostgreSQL database using Supabase, separating permanent member records from semester-specific data through normalized tables for members, Fams, semesters, tasks, and point completions. This enabled historical tracking while allowing leadership positions, Fam assignments, and point totals to reset each semester without duplicating member records. I integrated the frontend directly with Supabase using the JavaScript client library, replacing browser-based local storage with a shared backend cloud database that supports concurrent use by multiple board members. Beyond the internal dashboard, I developed an AI-powered Slack bot in JavaScript that integrates with the Slack API to automate the point submission process. Rather than requiring an officer to manually review every submission, the bot analyzes uploaded images, identifies the corresponding member and completed activity, matches the submission to predefined point-earning tasks, and records the completion in Supabase automatically. The tracker immediately updates individual member profiles, Fam standings, activity logs, and leaderboard rankings without requiring additional administrative work. Throughout development, I iteratively tested features with fellow board members, refined the interface based on usability feedback, and deployed the frontend through GitHub Pages while hosting backend services on Railway. The resulting platform transformed a repetitive administrative workflow into a centralized operations system that significantly reduced manual effort, improved accuracy, preserved historical participation data across semesters, and created a scalable foundation that can be adapted for other student organizations with similar team-based engagement systems.