The client is a leading India-based group of highly expert consultants who provide financial and managerial guidance to Aviation companies focused on Passenger Airline business. Client helps Airline companies to turn around business from loss making operations to stable profitable business operations, comprising following activities:
To procure, lease and hire Aircrafts
Airline company acquisitions and mergers
New Airline company formation
Manage the fleet and network
Budget, plan and forecast for coming years
Client wanted to build a forecasting application for coming five years based on multiple scenarios that will generate a What IF analysis on-the-fly with enormous calculations for high volume of data. All the calculations were expected to be precise up to four decimal places.
Build a SOX compliant application for North America and Europe region. GAAP principles needed to be followed in order to make the application so that it would be acceptable globally.
Additionally, the application needed to be IATA compliant to make it acceptable to all Airlines. To cover compliance, all the elements of the Airline industry like Network, Route, Sector, Airport, Flight, Aircraft Specification, Travel and Booking Classes, Fare Calculation, Seasonality and Seasonality Modulators etc. needed to be standardized.
Microsoft .NET Windows Presentation Foundation
Microsoft SQL Express Database
Eternus Solutions reviewed the client’s business objectives for end application and worked with the client’s team to implement a new application based on Microsoft Technologies.
The modulation of various business cases was classified as per the Aviation industry, and the entire application was designed to adopt scalability and flexibility to generate forecasting reports.
Role based security for ensuring authorized access to reports.
Application business logic was shifted from application to database level owing to huge data volume and calculations involved.
Eternus Solutions team built this application as a Desktop application using Microsoft .NET Windows Presentation Foundation owing to its sensitive and confidential nature.
Additionally, MS SQL Express database was selected for ease of installation as this was a standalone application.
Custom developed UI components
UI Themes, look and feel developed using Windows Presentation Foundation
MVVM architecture for entire implementation
Core business logic in the database for easy updates
Data analytics using business dashboards and reports
Forecasting and budgeting reports for coming five years
SRS and design documents to start building any new components
Designing and developing business workflows for budgeting
Extensive usage of stored procedures, Functions and Views
600+ parameters for reporting
Development using Microsoft standards and best practices