Problem

The Xatruch airline faced operational difficulties related to the manual management of domestic and international flights. The control of itineraries, destinations, aircraft, passengers, and schedules relied on inefficient and error-prone methods such as spreadsheets and physical records. This limited scalability, increased delays, duplicated information, and reduced traceability across operations.

Solution

A robust and scalable web platform was developed to centralize airline operations. The system allowed the company to manage flights, routes, schedules, passengers, bookings, and aircraft assignments from a single system.

Key features included:

• Registration and management of domestic and international flights
• Route and schedule control
• Monitoring of flight status and operational planning
• Aircraft assignment by route
• Passenger registration and reservation validation
• Role-based access for administrators and flight agents

The system was designed with a modular, secure, and adaptable architecture, making it suitable for real production environments and future integrations such as digital check-in, payment gateways, and baggage management.

Technologies used

• Java for the core backend logic
• Spring Framework for architecture and security
• Hibernate and JPA for data persistence
• PHP and Laravel for auxiliary modules
• MySQL as the relational database
• HTML, CSS, and JavaScript for the user interface

Results

• Reduced operational time in flight management
• Increased accuracy and consistency of data
• Improved traceability of operational processes
• Strong foundation for future system extensions

Project value

This project represents a complete software engineering effort in a realistic environment. In addition to reinforcing technical skills, it demonstrates how process automation can improve efficiency and reliability in highly regulated industries such as air transportation.