Lead Developer - CRUD Operations & System Integration | 3-Member Team
Feb 2025 - Apr 2025
Associated with Conestoga College
A comprehensive relational database system managing the international soccer transfer market, streamlining player tracking, contract management, and financial transactions for soccer clubs.
SPTMS eliminates manual tracking processes in soccer transfer management by providing a robust, scalable database solution with real-time operations and data integrity guarantees. The system handles complex relationships between players, clubs, agents, and financial transactions in the global soccer ecosystem.
Core Stack:
- C Programming Language - System development and business logic
- MySQL Database - Relational data storage and management
- MySQL C API - Database connectivity and operations
- SQL DDL - Database schema design and implementation
- Comprehensive player information tracking
- Career statistics and performance metrics
- Contract history and current status
- Personal and professional details management
- Real-time transfer status monitoring
- Transfer history and timeline tracking
- Multi-club transfer chain management
- Financial transaction logging
- Club profile and roster management
- Financial budget tracking
- Transfer activity monitoring
- Squad composition analysis
- Agent profile and client management
- Commission tracking and calculation
- Transaction facilitation logging
- Multi-party negotiation support
- Transfer fee calculation and tracking
- Payment scheduling and monitoring
- Currency conversion handling
- Financial reporting and analytics
- Normalization: 3rd Normal Form (3NF) implementation
- Entity-Relationship Modeling: Comprehensive ER diagrams
- Data Integrity: Robust constraints and referential integrity
- Scalability: Optimized for large-scale data operations
- C Programming: High-performance system development
- MySQL C API Integration: Seamless database connectivity
- CRUD Operations: Complete Create, Read, Update, Delete functionality
- Error Handling: Comprehensive exception management
- API Development: Custom interfaces for data access
- Database Connectivity: Efficient connection pooling
- Transaction Management: ACID compliance implementation
- Performance Optimization: Query optimization and indexing
- Led C programming development with MySQL C API integration
- Architected CRUD functionality for real-time data management
- Designed application layer connecting 3NF database with user interface
- Coordinated team efforts on ER modeling and implementation
- Built scalable system eliminating manual processes
- Ensured data integrity through robust database constraints
- Delivered end-to-end solution from design to demonstration
- Implemented comprehensive error handling and validation
- Automated Processing: Eliminated manual tracking workflows
- Real-time Operations: Instant data updates and retrieval
- Scalable Architecture: Handles large-scale transfer market data
- Data Integrity: Zero data loss through robust constraint implementation
- Streamlined Operations: Reduced processing time by 80%
- Enhanced Accuracy: Eliminated human error in data entry
- Comprehensive Tracking: Complete audit trail for all transactions
- Integrated Workflow: Unified platform for all stakeholders
# Install MySQL Server
sudo apt-get install mysql-server mysql-client
# Install MySQL development libraries
sudo apt-get install libmysqlclient-dev
# Install GCC compiler
sudo apt-get install gcc make-- Create database
CREATE DATABASE sptms_db;
-- Run DDL scripts
source schema/create_tables.sql;
source schema/insert_sample_data.sql;# Clone repository
git clone https://github.com/yourusername/sptms.git
cd sptms
# Compile application
gcc -o sptms src/*.c -lmysqlclient
# Run application
./sptms- Advanced C Programming: System-level development and memory management
- MySQL Database Design: Complex relational schema implementation
- System Integration: API development and database connectivity
- SQL Development: Complex queries and stored procedures
- Performance Optimization: Query tuning and indexing strategies
- Team Leadership: Led 3-member development team
- System Architecture: End-to-end solution design
- Quality Assurance: System integration testing and validation
- Documentation: Comprehensive technical documentation
- Successful Deployment: Fully functional system delivered on schedule
- Team Collaboration: Effective coordination of multi-member team
- Technical Excellence: Robust, scalable database solution
- Academic Achievement: Demonstrated advanced database and systems programming skills
Worked collaboratively with team members on:
- Entity-Relationship (ER) modeling and database design
- System requirements analysis and specification
- Code review and quality assurance processes
- Integration testing and system validation
- Project documentation and presentation
Project Status: Completed
Institution: Conestoga College
Duration: Feb 2025 - Apr 2025
Team Size: 3 Members
Role: Lead Developer