Football Open Match Platform (React Native Mobile Application)

Developed a mobile application that enables football players to discover, join, and organize open football matches within their local communities. Built a seamless user experience allowing players to create matches, search for available games, manage team participation, and connect with other players through a real-time sports networking platform.

Key Contributions:

• Developed cross-platform mobile application using React Native for Android and iOS platforms.
• Designed and implemented user flows for registration, player profiles, match discovery, and joining open games.
• Built match creation and management features including location, date/time scheduling, player limits, and team participation tracking.
• Integrated REST APIs for user authentication, match data management, and real-time application updates.
• Implemented mobile UI components with responsive layouts and optimized performance across devices.
• Managed application state using modern React Native state management practices.
• Integrated location-based features to help users find nearby football matches.
• Developed push notification workflows for match invitations, updates, and player confirmations.
• Collaborated with backend teams to define API contracts and optimize mobile data handling.
• Improved user experience through intuitive navigation, reusable components, and performance optimization.

Technologies:
React Native, JavaScript/TypeScript, React Navigation, REST APIs, Firebase, Push Notifications, Location Services, PostgreSQL, Git

KoalaByte Recruitment Platform Enhancement (PostgreSQL & Database Migration)

Designed and implemented database enhancements for a recruitment platform to support candidate assessment management, including session tracking, screenshot metadata, activity logging, and administrative review workflows. Developed and optimized PostgreSQL database schemas, created migration scripts for seamless schema evolution, established table relationships, foreign key constraints, indexing strategies, and audit logging to ensure data integrity and high performance. Collaborated with backend developers to support scalable recruitment workflows while maintaining secure and efficient data management practices.

Key Contributions:

• Designed normalized PostgreSQL database schemas for candidate assessments and session management.
• Created and maintained SQL migration scripts for database versioning and schema updates.
• Implemented foreign keys, indexes, and constraints to improve query performance and maintain referential integrity.
• Developed tables for candidate sessions, activity logs, screenshot metadata, and admin review records.
• Optimized SQL queries and database performance for reporting and administrative dashboards.
• Supported backend API integration by designing scalable and maintainable database structures.
• Ensured database consistency through transactional migrations and rollback strategies.
• Participated in database design reviews and performance optimization initiatives.

1. Capture Screenshot
   Automatically captures screenshots of an employee’s screen at configurable intervals (e.g., every 5, 10, or 15 minutes).
   Screenshots are securely stored and associated with the tracked work session.
   Some systems support optional screenshot blurring to protect sensitive information.
   Administrators can review screenshots alongside timestamps and activity data.
2. Admin View

The admin dashboard usually provides:

Employee list with online/offline status.
Real-time and historical time tracking.
Total hours worked per day, week, or month.
Screenshots captured during tracked sessions.
Activity levels (keyboard/mouse usage).
Project and task-wise time reports.
Timesheet approval and editing.
Export reports (CSV, Excel, PDF).
User, team, and project management.
Screenshot retention and privacy settings.