The CU Book Store at the University of Colorado Boulder employs over 70 individuals, many of whom are part-time students, to manage various roles such as register operations, sales floors, and greeter stations. Despite its pivotal role, the store faces significant challenges in manually managing daily employee shift allocations. Balancing employee availability, specialized training, and varying demands makes the process time-consuming and complex for managers.

Our project offers a solution through an automated employee scheduling system designed to streamline this process. Leveraging AWS Cloud services, Apache Airflow, Flask API, and Python, the system reduces scheduling time from over an hour to under five minutes.

This project highlights how cloud-based automation can transform manual processes, enhancing the CU Book Store’s daily operations and productivity. 

The automated scheduling system simplifies and streamlines shift allocation for the CU Book Store, enhancing efficiency and communication. Here are its key features:

• Automates Shift Allocation: Automatically assigns employee shifts based on availability, training, and operational needs.

• Enhances Communication: Sends real-time email notifications to employees with their assigned shifts, ensuring clarity and transparency.

• Provides Manager Insights: Offers managers real-time access to schedules and staffing metrics for better decision-making.

• Delivers Alerts: Triggers alerts for missing shift data, scheduling discrepancies, or unmet staffing requirements ensuring smooth operations.

• Handles Dynamic Demands: Adapts seamlessly to varying needs, such as game-day rushes or unexpected staffing changes.

• Built for Reliability: Utilizes AWS Cloud services and Python-based tools for a scalable and robust solution.