CSE498, Collaborative Design, Spring 2020
Computer Science and Engineering
Michigan State University

United Airlines is a major international air-carrier operating 4,900 flights per day from 362 airports. Operating an airline requires diligence in all logistical and technical aspects to ensure the proper flight experience for “Every customer. Every flight. Every day.”

Within United Airlines, the TechOps training division is responsible for the operations of aircraft and their important maintenance. The TechOps team leverages a sub-team of 45 instructors to teach a catalog of 100+ courses for around 700 classes per year to their skilled team of 7,000 technical staff members. Currently, the orchestration of scheduling these courses is the responsibility of a single individual.

Our Training Scheduling and Optimization System III provides a production-ready web app to facilitate United’s maintenance training schedulers to schedule instructors, students, classrooms and courses across the country.

A scheduler uses our mobile compatible website to add classes to the schedule manually or make use of the schedule optimizer. The schedule optimizer automates the scheduling of multiple classes at a time. Our optimizer can schedule months of classes in a few minutes, compared to the many hours it currently takes to schedule these courses.

An automatic email system alerts the scheduler of important changes, including when new training requests or employee availability changes arrive.

Our platform streamlines the scheduling process for United Airlines’ TechOps division, allowing their employees to spend their time on more important tasks.

Our software is built using ASP.NET Core 3.1, Angular 8, Node.js, an Entity Framework, and an Azure SQL Database. The web app is hosted on Azure Cloud Platform.