In-Flight Sales & Operations Management Platform
An enterprise-grade ASP.NET Core MVC application to automate Tunisair's in-flight sales, crew workflows, and financial operations. It brings sales, flight and crew assignments, commission calculations, cash reconciliation, and reporting together in one secure platform—reducing manual work while improving accuracy.
Role
Full-stack developer • Workflow automation
Stack
ASP.NET Core MVC • SQL Server
Project story
This platform centralizes the day-to-day work behind onboard sales: managing sales and offers, matching transactions with flights and crew rosters, calculating commissions, reconciling cash, and reviewing financial performance. Its responsive ASP.NET Core MVC interface gives administrative and operational teams a shared, real-time view of their workflows.
Automation replaces repetitive checks and calculations with validated workflows. Sales are associated with the right flight, crew, and articles; commissions adapt to crew assignments, including dynamic PNC allocations; and cash overages or shortages are flagged as soon as a discrepancy is detected.
Built with ASP.NET Core MVC and ASP.NET Core Identity, the application protects sensitive operations with role-based access for DGF, Agent Saisie, and administrators. PDF report extraction, in-app notifications, detailed logging, and French-ready validation help make the system practical for real operational use.
Automation at the core
- Automatically calculates crew commissions from sales, with support for dynamic PNC assignments.
- Detects cash-register overages and shortages in real time to surface “trou de caisse” discrepancies.
- Connects sales and offers to flight manifests, crew rosters, and article catalogs with validation and duplicate checks.
- Applies managed exchange rates to transactions and extracts data from PDF reports.
- Provides financial dashboards for revenue, sales, offers, commissions, and operational KPIs.
Highlights
Gallery