PANKAJ MEHRA

Experience

• 

  Sam Aviation Private Limited

  Jan 1995 - Dec 1997

  Traffic Assistant
• 

  Lufthansa Airline Back Office R.D.M India. Pvt. Ltd

  Jan 2000 - Feb 2022

  ** Analyze the hotel's confidential contracts sent by our clients and perform analysis to extract meaningful insights.**Maintain and develop the itinerary to make the booking process smooth.**Update the insights and other relevant data in database of Hotel Industry Tools. These insights includes - Room rates, Promotional Offers such as EBO offers, FNO, meal plans and other seasonal offers.**Work with management and collaborate with clients for sharing insights and further improvement of the project. Show less Rules coding of SITA Airfare Rules & Nego Fare filling in FarExpert:** Handled a team of 28 Fares Analysat as Supervisor.** Information gathering, implementing and analyzing the things.** Conference SITA with SITA for information and new updates report.** Working on airline defects and use cases, analyzing, documenting and on-time delivery to test cases.** Testing and creating test cases, opening defects and documentations.** Analyze the Integrity reports and send report to SITA if required.** Defect distribution, analysis and helping software team in information gathering, documentation and implementation. Show less Airline Revenue Accounting (LRS) & Proration Department:** Handled a team of 35 Prorators as Ast. Supervisor.** Dealing with proration of different Airlines coupons through interlining between Lufthansa and Worldwide international Airlines coupons under Bilateral Agreements.** Well equipped with proration methodologies e.g.: Special Prorate Agreement, Straight Rate Prorate, Provisos, base Amounts etc.** Equipped with manual proration also.** Revenue Accounting of Lufthansa German Airline with the help of Amadeus Computer Reservation System used by different Airlines.** Billing and Settlement Programme BSP.** Passenger Sales Report.** PEV's, PAV's and manual capturing of Lufthansa sales and refund data.** Traffic, FIM's, and difference. Show less

  • Senior Supervisor

    Apr 2014 - Feb 2022

  • Supervisor

    Jan 2010 - Mar 2014

  • Assistant Supervisor

    Mar 2004 - Dec 2010

  • Operations Team Member

    Jan 2000 - Feb 2004
• 

  Coforge

  Mar 2022 - now

  Senior Quality Assurance Tester

  ** Data Migration from Sabre to Amadeus for Etihad Airways.** Manual Testing of ARDWEB.** Find defects while testing in ARDWEB.** Create Airline test scenarios and test cases of ARDWEB.** Execution of test cases.** Conference call with onshore team members and Etihad Airways Employees.