Capacity & Overbooking Management
Business challenge
Airlines’ profit margins hinge on two tightly coupled levers: how many seats are available and how many of those seats are sold.
Airlines lose millions every quarter when seats sit empty. The legacy workflow relied on manual Excel updates did not arrive in time, creating a significant revenue leak. Decision‑makers needed a single pane of glass that showed what the aircraft could carry and what it actually sold – in real time.
Overbooking variance hovered around 30%, meaning the percentage of seats the system actually overbooked rarely matched the analyst's intent. That gap translated directly into missed revenue, regulatory risk, and a cascade of manual corrections.
Together, these pain points meant that every flight's sellable capacity was a moving target, and the organization lacked a single, trustworthy view to make rapid, data‑driven decisions.
Design challenge
Three capacity layers coexist on every flight: physical, restricted and virtual. The UI had to present all three side‑by‑side, surface the freshness of the data, and let analysts experiment with “what‑if” scenarios without drowning in spreadsheets.
My role
Designed a filter pattern that lets analysts slice by market, cabin, and date in seconds.
Designed a three‑step Overbooking Wizard: type a value, preview the resulting sellable capacity (rounded per business rules), confirm with a mandatory comment.
Analysts now make informed adjustments in seconds, the business recovers hundreds of thousands of dollars each quarter.
”Our Revenue Operating System provides a singular platform to support the entire customer journey while optimizing price and revenue performance throughout”.
Network Origin‑Destination
Business challenge
Pricing‑management teams lose up millions each year when they cannot quickly assess profitability across origin‑destination pairs. The existing reports were generated manually, took 4 days to compile, and were riddled with inconsistencies.
Design challange
The UI had to present a massive table with sortable columns, color‑coded KPI sparklines, and a one‑click CSV export – all while keeping the experience fluid on both desktop and tablet.
My role
Designed the OD pivot‑style table widget and flights origin-destination table flows, embedding tiny sparkline bars for revenue and load factor, and highlighting the most profitable routes.
The newfound speed enabled analysts to act on pricing opportunities, delivering a significant revenue uplift.
”We are helping reshape Cyprus Airways into the leading airline of the Mediterranean, for and by the people of Cyprus”.
Promotion Management
Business challenge
The existing promotions workflow required multiple manual steps, causing launches to miss the optimal market window and resulting in a noticeable dip in incremental revenue.
Design challange
The UI had to present a massive table with sortable columns, color‑coded KPI sparklines, and a one‑click CSV export – all while keeping the experience fluid on both desktop and tablet.
My role
I designed a flexible Promotion Wizard. Users select regions, sub‑regions, or individual markets, add exception rules (dates, cabins, price caps), and edit all parameters. Promotion‑specific metrics are injected as extra columns, letting the same filter panel used for capacity and overbooking slice the data instantly. Real‑time validation against fare‑policy guarantees that every rule complies before the promotion is saved.
“This unique advantage provides valuable insight to help best allocate marketing dollars for high-yielding returns”.
Advanced Filters
Business challenge
Analysts need to slice flight data across dozens of dimensions every day. The legacy filter bar was opaque, sluggish, and offered only a handful of preset options, forcing analysts to spend excessive time fiddling with the UI. While they are comfortable crafting fast, SQL‑style queries, the interface didn’t let them express that expertise, creating a painful bottleneck in their workflow.
Design challange
The new filter system had to support AND / OR / NOT logic, grouping, multi‑select, and instant preview, all while remaining fully accessible (keyboard navigation, focus states, ARIA labels).
My role
Built a Filter‑Panel pattern: collapsible groups, a safe “reset” that only clears selected filters, and validation that prevents contradictory logic.
Worked hand‑in‑hand with developers, creating the documentation while we built each feature together, guiding them step‑by‑step through the process.
Results
“FLYR's platform filters detailed information instantly through the Cirrus dashboard and user interface, enabling airlines to conduct greater analyses and generate reports for informed decision-making”.
