About this project
it-programming / web-development
Open
We are seeking an experienced Microsoft 365 developer to create a secure employee self-scheduling request system. This application will serve approximately 120 Emergency Department EMTs and Paramedics, replacing our current manual paper forms and email-based scheduling requests with a centralized digital solution. The system will allow employees to submit their scheduling preferences before each 8-week schedule is finalized.
Key functionalities include:
Employee Interface:
* Employees must be able to securely access and edit only their own scheduling submissions.
* The system should collect comprehensive employee information, including name, FTE (Full-Time Equivalent), role, and seniority.
* Employees will submit up to eight 'X Days' (days they are absolutely unavailable to work) per 8-week scheduling block.
* The system must allow for vacation requests.
* Employees will indicate preferred shift start times from a predefined list (0700, 1000, 1200, 1600, and 1900).
* Preferred workdays can be indicated as a preference, not a guarantee.
* A field for additional scheduling comments will be necessary.
Scheduler and Manager Dashboard:
* Schedulers and managers require full access to a master dashboard that automatically populates with all employee submissions.
* The dashboard must support robust filtering and reporting capabilities.
* Essential features include conflict detection and the ability to export data to Excel.
Scheduling Rules and Logic:
* The scheduling block is defined as eight weeks, with work weeks running from Saturday through Friday.
* Employees are limited to a maximum of eight X Days per 8-week scheduling block.
* No more than four consecutive X Days can be requested within a single work week to prevent extended absences.
* Holidays must be excluded from selection as X Days.
Conflict Detection and Highlighting:
* The scheduler dashboard should prominently highlight potential conflicts, including vacation overlaps, conflicting or overlapping X Day requests, and instances where employees have not submitted their requests.
* The system should also identify other general staffing conflicts based on the collected data.
Technical Requirements:
* The ideal solution will leverage Microsoft 365 tools, such as Power Apps, Microsoft Lists, SharePoint, or similar components within the M365 ecosystem.
* The application must feature a clean, professional, and mobile-friendly user interface to ensure ease of use for both employees and schedulers.
Category IT & Programming
Subcategory Web development
What is the scope of the project? Create a new custom site
Delivery term: Not specified
Skills needed