Osman Ege Albayrak

part of a Management Trainee (MT) program.

• Analyze passenger and baggage data using SQL to identify process bottlenecks and improve efficiency.
• Generate destination segmentation reports with advanced queries and window functions to support flight planning.
• Research emerging aviation trends (e.g. Advanced Air Mobility, electric ground handling) and produce concise summaries.
• Develop clear slide decks and presentations on topics such as SAF regulations and AAM use cases.
• Implement data-driven recommendations to enhance on-time performance and elevate customer experience.

• Assisted in managing cash flow for four affiliated companies by executing intercompany fund transfers and arranging Takasbank credit facilities as needed; monitored daily and long-term payment schedules and prepared detailed cash flow forecasts and liquidity plans.
• Prepared weekly and monthly treasury reports (cash position, liquidity analysis, funding requirements) for finance leadership.
• Recorded all treasury activities—including cash flow transactions, intercompany fund transfers, and Takasbank credit drawdowns—in the SAP Treasury module.

• Conducted in-depth competitor analyses and SWOT assessments to map market positioning and uncover growth opportunities.
• Researched alternative providers’ Turkey representation models and evaluated their fit for our portfolio.
• Prepared a comprehensive report and slide presentation proposing the transfer of another firm’s Turkey representation to our company, outlining strategic benefits and implementation steps.
• Delivered the presentation to senior management, using clear visuals and data-driven insights to support recommendations.