Saving Time and Money
The project started with a survey of the data structures of the system and an examination of the overall data quality. To demonstrate to Finnair management that rosters could successfully be created in the system outside of the normal transactional operations performed by the software itself, Type2Solutions built a local version of the system.
While the first priority was to deliver usable live information for the Carmen system to fine-tune its optimization rules on, the transport back into the Finnair system had to be started right away as well. At the same time, the bulk load procedure into the back-end database needed to be perfected in order to fit the entire upload process into the limited time window in which systems at Finnair would be allowed to be down.
The local system proved to be an excellent tool during this project, saving a substantial amount of time and money that would normally have been spent on communicating back and forth with Finnair’s outsourced infrastructure provider concerning database handling (backups, restores, etc.). After about a year, first optimized cabin rosters issued by Carmen Rostering were successfully loaded into the production systems at Finnair.