Mehrdad Bordbar

• Utilized the RDC web application to extract airport charges data. • Conducted turn-around studies to understand and analyze airport performance. • Gathered data from airlines' annual reports to obtain key financial parameters. • Analyzed the collected data to update and maintain the German Airport Performance (GAP) database. • Identified trends, patterns, and insights from the data to provide actionable recommendations.

• “Continues Airworthiness Management Organization app”: Project manager/Product Owner/Business Analyst, digitized and programmed by MATLAB, also in charge of UI and UX design. • “Ava Cost Data Analysis”: Analyzed operating cost data, categorized it into five different segments and provided subsequent outputs for the data-driven decision-making, Collected and determined KPIs, Offered a new definition of the company's product, Estimated the prime cost, and offered a new pricing method.

* Role: Project manager / Financial analyst * Led and managed diverse teams across multiple companies to execute 6 distinct chapters of the project * Performed "Financial Viability Investigation" by designing a financial model in MS EXCEL, and estimated capital costs, operating costs, revenue, and all the financial metrics. Achievements: * Provided valuable insights to the "Iran Airports and Navigation Company" to support informed decision-making for airport development.

Financial Analyst / Business Analyst” * Executed comprehensive business plans for multiple airlines with different bases and business models. * Conducted extensive analysis of market trends, demand projections, and output optimization. * Analyzed cost structures, revenue streams, and financial data to evaluate the financial performances Achievements: * Provided valuable insights into the intricacies of the air transport industry, allowing the investor to make informed decisions.

“Business Plans - Aviation Related Projects” Developed a financial appraisal technique model in MS Excel for multiple aviation-related projects. Performed financial analysis and evaluations for various projects including Hanger, Maintenance Center, Training Center, Public Parking, Catering, Entertainment complex, etc Achievements: Improved project feasibility assessments through comprehensive financial evaluations. Proposed BOT (Build-Operate-Transfer) contract durations to maximize the company's profit.

• Conducted extensive research and data analysis of domestic and international flights in the last 20 years, regarding the number of flights, passengers, and cargo carried. • Developed an MS Excel model that calculates airline operating costs and revenues, according to the IATA ACMG. Achievements: • Generated comprehensive reports, offering valuable insights for strategic planning and decision-making. • Identified the most financially viable aircraft and determined its optimal age through the model.

• Implemented a digitalized MS Excel application to estimate the prime cost of approximately 900 meals. • Developed a digitalized MS Excel application to support Catering Tender Offers, utilizing raw material costs as inputs and calculating the prime cost for various catering meals. Achievements: • Successfully negotiated a BOT (Build-Operate-Transfer) contract duration that maximized the company's profit • Played a key role in the establishment of "Chashnik Catering," based in Mehrabad airport (THR).

Project Manager/Product Owner Projects: “Aircraft Subsystems' Parts Database”, “Warehouse Stock management system”, and “Aircraft Maintenance Manual” MATLAB for digitization, MS Project for project management Traditional and Agile (Scrum, Kanban, Lean Management) User stories, epics, backlog items, test plans, and functionalities Achievements: Improvements in inventory tracking and control Enhanced maintenance efficiency by reducing downtime and streamlining processes Significant time and cost savings

Master thesis: The impact of prospect theory on airline revenue management; case study: Top 20 busiest US domestic Routes; Robust Regression analysis by R. Conference Presentations: AMEC 2022, Heilbronn, Germany