Players Roster
An automated roster generation platform that replaces manual design workflows for sports team roster printing. The system allows coaches to upload Excel files containing player data, automatically processes the information, and generates both a digital preview and high-resolution print-ready roster files.
Project Overview
Understanding the Project
The Goal
Build a system capable of automating the creation of sports team rosters by importing structured Excel data, storing it in a database, and generating dynamic, high-resolution print-ready files without relying on external design software.
The Challenge
Eliminating the manual design process that required paid graphic software while ensuring accurate data parsing from Excel files. The platform needed to correctly map uploaded spreadsheet data to database records and dynamically generate consistent, high-resolution layouts suitable for professional printing.
My Role
Full-Stack Developer responsible for Excel data parsing, database modeling, dynamic layout generation, and automated high-resolution file rendering for print production.
Role
Full-Stack Developer
Timeline
2017
Platform
Web
Team
Team (2)
Screenshots
Visual Showcase
Administrative dashboard for managing teams and players
What I Built
- Developed an administrative web interface using React and Redux.
- Designed the UI following Material Design guidelines for a clean and consistent user experience.
- Implemented team, player, and coach management features.
- Designed and implemented REST APIs for data operations.
- Built backend services using PHP with Yii Framework.
- Designed and maintained a MySQL database schema.
- Implemented logic to select active players and coaches per team.
- Generated high-definition PDF player rosters ready for printing.
- Deployed and hosted the application on AWS infrastructure.
Tech Stack
Frontend
Backend
Database
Cloud & Infrastructure
Architecture Design Decisions
These decisions were intentional to ensure the site feels professional, calm, and easy to navigate:
- Administrative dashboard focused on clarity and ease of use
- User interface built following Material Design principles for consistency and usability
- Structured data relationships between teams, players, and coaches
- High-definition PDF generation optimized for printing
- Clear separation between frontend and backend responsibilities
- Scalable architecture to support multiple teams and seasons
Results & Learnings
The platform significantly simplified roster production by automating data ingestion and file generation. Coaches could upload Excel spreadsheets directly, eliminating manual design work and reducing dependency on paid design tools. The system automatically generated preview versions and final high-resolution print-ready files, accelerating turnaround times and reducing production effort.