Customer Profile
Sector: Airlines
Industry: Consumer Travel
The flight attendant scheduling company is a Chicagoland based leader in assisting flight attendants with schedule changes. They specialize in coordinating schedule changes between flight attendants by assisting them to drop, pick up and/or trade flights with other crew memebers who are also interested in making schedule changes
Business Situation
A paper based system was being used to track daily business operations. The company’s business clientele was growing and the paper based system became very inefficient very quickly. To handle this growth, a more effective and organized system was needed that would allow their employees to have access to the system across the globe.
A future goal of the company is to have a website that will accept schedule change requests online. Therefore, it was critical that the solution would be able to seamlessly integrate with the future development of a website.
Solution
Scheduling Change Bid Tracking System
The web based solution developed enables the company to efficiently manage their clientele along with their schedule change bids. Employees can now access the system anywhere in the world at any time, thus increasing employee productivity.
The company was able to make their scheduling change operations paperless, centralized and global. The SQL Server 2005 database used is robust and can efficiently handle the large quantity of scheduling requests. The company now has the infrastructure in place to handle considerable growth while maintaining exceptional customer service.
Integration With Future Business Expansion
The system built will be able to integrate in the future with an online bid request website for flight attendants. The system was designed to be flexible so that online bid requests can come directly into the bid tracking system. The expandable solution provided by SQL Server Programmers will enable the company to continue to grow while keeping their operational costs down.