June - July 2023
Agridation 2023 - Competition Website
Competition website providing information, registration, and result announcements.
FigmaLaravelTailwindCSSHTML/CSSMySQL
Project Overview
Agridation 2023 is a comprehensive competition management platform built for a major agricultural innovation event. As the Full-Stack Developer, I replaced a chaotic system of spreadsheets and Google Forms with a unified Laravel-based web application. The platform served as the 'single source of truth' for over 500 participants, handling everything from team registration and document submissions to real-time winner announcements. This digital transformation reduced administrative workload by 70% and eliminated data errors caused by manual entry.\n\nI architected the system using Laravel for its robust MVC structure, MySQL for relational data management (handling complex team-to-member relationships), and TailwindCSS for a responsive, modern frontend. Key features included a dynamic registration wizard that adjusted requirements based on the competition track, an admin dashboard for organizers to verify submissions and export data, and an automated status tracking system that allowed participants to check if their files were approved without emailing the committee. The site was optimized for high traffic during the submission deadline windows, ensuring zero downtime.
Role
Full-Stack Developer (Laravel) & UI Designer
Timeline
June - July 2023
Tools
Figma, Laravel, TailwindCSS, HTML/CSS
Links
-
Key Responsibilities
Impact & Results
- ~500+ participants registered through platform
- ~95% event information accuracy
- Reduced registration processing time by 70%
- Improved event visibility by 80%
Challenges
The Challenge
The biggest challenge was handling the complex logic of 'Team' vs 'Individual' registrations, where each track had different file requirement rules, while ensuring the server remained stable during the last-minute rush before the deadline.
Problem
Managing a large-scale competition manually is a nightmare. Organizers were drowning in emails and mismatched spreadsheets, while participants were frustrated by the lack of confirmation and transparency regarding their submission status.
Data fragmentation
Participant details were scattered across Google Sheets, WhatsApp chats, and email inboxes.
Verification bottlenecks
Admins had to manually check files one by one, creating huge backlogs.
Lack of transparency
Teams had to email the committee just to ask 'Did you receive my file?', wasting everyone's time.
High error rate
Manual data entry led to typos in names and certificates, looking unprofessional.
Solution
I built a centralized portal where 'Data' flows automatically. Participants enter their own info, the system validates it, and admins just click 'Approve'. It turned chaos into a predictable pipeline.
Self-service dashboard
Participants can log in to edit their team details and check their verification status anytime.
Automated validation
The system automatically checks for required fields and file types before allowing submission.
Admin command center
A backend panel where organizers can filter teams, bulk-export data, and toggle announcement visibility.
Responsive public site
A marketing-focused landing page that looks great on mobile, converting visitors into registrants.
Process
The Journey
Workflow Analysis
Sat down with the event committee to map out every piece of data they needed to collect from participants.
Database Design
Designed a normalized MySQL schema to handle the many-to-many relationships between Students, Teams, and Competitions.
Laravel Development
Built the registration system using Laravel's Eloquent ORM and Form Requests for robust validation.
Stress Testing
Simulated high traffic to ensure the site wouldn't crash when hundreds of students tried to submit at the deadline.