• Introduction
  • Customer’s Problem
  • Customer Interaction
  • Solution Offered
  • Technology
  • Final Benefit


Roster Import

The client has the vision to automate the roster generation process for pilots.

Customer’s Problem

Customer’s Problem:

Pilots used to enter their duty roster manually on a daily basis which takes a lot of time.

Customer Interaction

Customer Interaction:

The client came to us to resolve the above mention problems. We then started interaction with the client over chat and call to understand their requirements related to roster management.

Solution Offered

Solution Offered to Client:

We developed a robust roster import that can perform the following functions:

  • Processes the roster and create an online calendar that automatically updates when changes are picked up. The online calendar is an ICS file of all their duties since they first subscribed
  • Converts the roster into a format that allows its import to Outlook, Google Calendar, and Ical helping the users to sync it with their mobile devices
  • Supports people in uploading PDF copies of their roster and entering their roster portal username and password for processing

For companies having online rosters, the system proves useful. When pilots enter their username and password in such a roster, we directly scape them from that place to ensure quick processing.

Gets users employee number and airline from the roster and checks the database to see if they are in the free two-month trial, a current paid user or if their trial / paid subscription has expired and they need to pay before this roster is processed. (Data currently stored in an Access Database)

In case of payment overdue, it directs the system users to a page featuring a PayPal payment button. Once payment is made, the database is automatically updated in real-time using PayPal Instant Payment Notification (IPN) so that the user can upload his or her roster after making the due payment.

If users save their roster portal username and password with roster import, the system logs in automatically every 6 hours, see if there are any changes to their roster and if there are, it emails them details of the change.


Technology We Used:

  • Web server: IIS 8
  • Scripting language: ASP.NET MVC 4, C#
  • Database: MS SQL Server 2008 R2

Final Benefit

Final Benefit:

  • Our solution encourages the client to develop more features and make everything automated.
  • Our client earns revenue by successfully selling the system application to several aviation companies like Air Asia, Malaysian airlines, and more.

On-demand hiring

We worked for them for a period of six months on a dedicated hiring basis.