I developed two Python-based automation bots to streamline document handling and booking processes for a high-volume reservation department, significantly reducing manual workload and increasing operational efficiency.

1. Email Monitoring and Attachment Processing Bot:
   • Objective: Automate the printing of reservation-related documents received via email for internal processing.
   • Functionality: The bot continuously monitors a specific mailbox. Upon receiving an email with an attachment, the bot automatically prints the document on a designated printer for the reservation department's use.
   • Impact: This automation eliminates the need for staff to manually download and print each document, ensuring faster processing and less human intervention.
2. PDF Monitoring and Booking Indexing Bot:
   • Objective: Automate the processing of scanned booking documents to save time and ensure accurate file management.
   • Functionality:
     • The bot monitors a local server folder where scanned booking documents (PDFs) are saved.
     • When a new PDF appears, the bot reads the file to extract a unique booking number.
     • The file is then renamed based on the booking number and saved in the appropriate location.
     • Finally, the bot sends the renamed PDF to a specified email address, with the booking number as the subject line, allowing another web system to index the file automatically.
   • Impact:
     • This solution addresses the challenge of managing 800 to 1,200 bookings per day during peak season.
     • It automates tasks that were previously performed manually by the reservation department, saving approximately 90% of the time spent on these repetitive processes.

Problem Solved:

The implemented bots drastically cut down the manual workload of the reservation team, particularly during high season, when up to 1,200 bookings were processed daily. By automating the printing, renaming, and indexing of booking documents, the bots ensured faster turnaround times, reduced errors, and allowed staff to focus on more critical tasks, ultimately improving overall productivity.