Enterprise Automation for India's National Airline
Air India, the flagship carrier of India, manages daily crew assignments and layovers across multiple domestic and international destinations. Traditionally, hotel accommodations for crew members were booked manually, leading to inefficiencies, delays, and coordination issues between crew, hotels, and the operations team.
Geelani Consultancy & Solutions partnered with Air India to build a fully automated, scalable hotel booking ecosystem that integrates directly with Air India’s internal crew management platform (CAE System). The result was a robust, responsive, and data-driven system that drastically improved speed, reliability, and user experience for both crew and hotel partners.
Goals
Eliminate manual hotel booking processes
Integrate directly with Air India’s CAE crew management system
Automate communication with hotels for booking confirmations
Provide fallback mechanisms if hotel capacity is limited
Deliver real-time alerts and notifications to crew members
Implement a feedback loop for service quality improvement
Build a responsive portal for hotel partners and service staff
Key Features & Functionalities
CAE System Integration
Direct access to Air India’s internal CAE crew management platform
Scheduled login and data extraction for upcoming crew assignments
Automated parsing of crew location, date, and group size
Automated Hotel Booking Workflow
System auto-fetches crew schedule
Sends structured email booking requests to designated hotels
Hotels confirm number of rooms they can allocate (e.g., 10 out of 20)
Remaining unconfirmed bookings are automatically routed to the next hotel in the queue
Hotel Partner Portal
Custom dashboard for each hotel with:
View of upcoming bookings
Room allocation panel
Booking acceptance or rejection option
Confirmation logs
Audit trail of all booking communications and responses
Alerts & Notifications System
Success, failure, and fallback alerts are auto-generated
Crew members receive alerts via:
WhatsApp
Email
Notification types include:
Booking success or rejection
Hotel allocation status
Escalations if bookings are delayed
Feedback Module
After each stay, crew members are prompted to:
Rate their hotel experience
Leave specific comments or complaints
Feedback is logged and visualized in admin dashboards for quality control
Port Service Staff Dashboard
Internal interface for Air India’s Port Service Team
Receive and respond to calls from crew members
Confirm booking status manually if needed
Override bookings and manually trigger communications in edge cases
Business Impact
Time Saved: Booking turnaround reduced from several hours to minutes
Improved Booking Accuracy: 95%+ automated accuracy in hotel allocations
Lower Support Overhead: Fewer manual calls to port staff
Real-Time Communication: WhatsApp and email updates reduced confusion
Better Feedback Visibility: Service quality now measurable and actionable
Fallback Automation: Room limits at hotels handled without delay or manual rerouting
🚀 Summary
This project stands as a flagship enterprise deployment by Geelani Consultancy & Solutions, combining intelligent automation, seamless integration, real-time communication, and user-centric interfaces to solve a high-impact operational challenge for one of India’s largest aviation brands.
Technologies Used
Backend
Odoo ERP (v16) – customized for automation, communication, and record-keeping
Python – backend logic, API integration, fallback algorithms
PostgreSQL – robust relational database for crew schedules and bookings
Scheduled Jobs – cron-based scripts to periodically sync with CAE system
Frontend
Figma – complete UI/UX design for:
Hotel Partner Portal
Port Service Staff Dashboard
Feedback Interface
HTML5, CSS3, Bootstrap – responsive implementation based on Figma designs
Communication Tools
Email SMTP Integration – for structured booking messages to hotels
WhatsApp Business API – for real-time alerts to crew
Logging & Alerting Engine – for automated escalation and follow-up tracking