Back to Portfolio
Project Details

Four Points Roster System

Next.jsReactTypeScriptGoogle OR-ToolsNode.jsPostgreSQLTailwind CSSZodVercelRadix UITanStack QueryAxiomPosthog

Company: Four Points by Sheraton Singapore, Riverview - Marriott, 2024

Role: Full Stack Developer

  • Developed an advanced Roster System using Google OR-Tools for automated workforce scheduling
  • Implemented complex scheduling algorithms considering multiple constraints and business rules
  • Built intuitive interfaces for shift management and time-off requests
  • Created a manager dashboard for oversight and schedule optimization
  • Integrated real-time conflict resolution and error handling

Product: Intelligent Roster Management System

Shift Management

Empty Shift Schedule View Initial view of the shift schedule before assignment.

Filled Shift Schedule Optimized shift assignments considering employee availability and skills.

Schedule Conflict Detection Intelligent conflict detection and resolution system.

Complete Shift Assignment Successfully assigned shifts with balanced workload distribution.

Optimized Schedule View Comprehensive view of the optimized schedule.

Time Off Management

![Time Off Request Interface](/roster-four-points/6-Time-off request.png) Streamlined time-off request management system.

Schedule Views

Schedule View 1 Different schedule visualization options.

Schedule View 2 Alternative schedule layout for better oversight.

Schedule View 3 Weekly schedule overview with status indicators.

Management Dashboard

Manager Overview Comprehensive manager dashboard for schedule oversight and optimization.

Key Features:

  • Automated shift assignment using Google OR-Tools optimization
  • Intelligent conflict detection and resolution
  • Employee availability and skills matching
  • Time-off request management
  • Multiple schedule visualization options
  • Real-time updates and notifications
  • Manager oversight dashboard
  • Constraint-based scheduling optimization
  • Workload balancing algorithms
  • Schedule export and reporting

The Roster System revolutionizes workforce scheduling by leveraging Google OR-Tools' powerful optimization algorithms to automatically generate efficient schedules while considering multiple constraints such as employee availability, skills, workload balance, and business rules. The system significantly reduces scheduling time and improves resource utilization through intelligent automation.