Summary
Overview
Work History
Education
Skills
Accomplishments
Software
Certification
Timeline
OperationsManager
Sanjay Basak

Sanjay Basak

Business Analyst
Doha,Qatar

Summary

Experienced Business Analyst with over 10+ years of experience in Travel & Airline Industry. Excellent reputation for resolving problems and improving customer satisfaction.

Overview

3
3
Languages
1
1
Certification
3
3
years of post-secondary education
12
12
years of professional experience

Work History

Business Analyst

Qatar Airways
Doha, Qatar
04.2021 - Current
  • Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
  • Built library of models and reusable knowledge-base assets to produce consistent and streamlined business intelligence results.
  • Met with stakeholders to establish favorable business relationships and support mutually beneficial interests.
  • Documented business processes and analyzed procedures to align with changing business needs.
  • Preparing Daily / Monthly sales report to capture the Gross Sales & Revenue.
  • Created Quarantine packages reports & dashboards for internal and external stakeholders and make sure all reports are delivered on time.
  • Preparing performance reports for Discover Qatar & Qatar Airways Holidays.
  • Built daily, weekly & monthly sales reports through internal data sources to review sales and ensure senior management is updated with Qatar Airways Holidays & Discover Qatar YTD performance vs LY and Targets.
  • Responsible for ad-hoc reporting for Qatar Airways Holidays & Discover Qatar.

Product Development & Quality Control Officer

Qatar Airways
Doha, Qatar
03.2020 - 04.2021
  • Compiled product, market and customer data to forecast accurate sales and profit projections.
  • Worked closely with all product development departments to create and maintain marketing materials for sales presentations and client meetings.
  • Consulted with product development teams to enhance products based on customer data.
  • Developed and implemented favorable pricing structures balancing firm objectives against customer targets.
  • Tracked and reported on marketing campaign responses.
  • Developed innovative and targeted collateral to support overall branding objectives.
  • Developed creative sales tools, including presentations, trend reports, kitted assets, and product data sheets.

Additional Responsibilities

  • Preparing performance reports for Discover Qatar & Qatar Airways Holidays.
  • Built daily, weekly & monthly sales reports through internal data sources to review sales and ensure senior management is updated with Qatar Airways Holidays & Discover Qatar YTD performance vs LY and Targets.
  • Responsible for ad-hoc reporting for Qatar Airways Holidays & Discover Qatar.

Product Coordinator

Qatar Airways
Doha, Qatar
07.2015 - 03.2020
  • To enhance product profitability, executed launch of online packages.
  • Creating Holiday Packages on qatarairwaysholidays.com to enhance unique visitors.
  • Deal with customer queries and discuss them internally with the stakeholders for resolution; support with follow-up activities.
  • Work with key stakeholders to identify and assist in all areas of improvement within the products and operational teams to enhance overall customer experience.
  • Review global supplier agreements on CMS and ensure that all the suppliers performance in-line with Qatar Airways Holidays growth index.
  • Communicate various campaign performances to internal and external stakeholders through interactive excel pivots, MS Power point and one pager reports.
  • Supported Discover Qatar with detailed analysis of Plus Qatar Campaign reports & share data on KPIs like ROI, room nights, number of PAX, look to book ratio & overall sales.
  • Support Global Sales promotion like (QRTF, GTB, etc.) by negotiating added value from Global Suppliers.
  • Maintain Weekly Preferred Hotel Inventory Report.
  • Ensure Qatar Airways expansion strategies in new markets are well supported with New Supplier strategy.
  • Conduct market and competition benchmarking before introducing a Product in market.
  • Facilitating indoor and outdoor sales activities as well as external client meetings and implement strategy for responsible industry or sector.

Additional Responsibility:

  • Built daily, weekly & monthly excel sales reports through internal data warehouses like Galaxy & power BI to review sales and ensure senior management is updated with Qatar Airways Holidays YTD performance vs LY and Targets.
  • Performance reporting of Qatar Airways Holidays Product customers.
  • Responsible for ad-hoc analysis and reporting Qatar Airways Holidays team.

Travel Coordinator

dnata International Pvt. Ltd.
Bangalore, India
07.2014 - 07.2015
  • Key Account Manager for global partner Ernst & Young $56Mio account. Handle travel queries for daily sales over $150,000 & provide one stop shop services like itinerary building, cost management, negotiate special air & hotel package deals and after sales services.
  • Team briefing and training to ensure service delivery of highest standard & enhance customer relationship.
  • Work closely with the management in establishing new policies and procedures for reconciliation of invoice payment with finance and accounts payable.
  • Majorly dealt with Airline reservation, Hotel bookings, Visa, Car rental etc.
  • Updates on monthly basis report on corporate deal and compliance internally. Like – Airline ADM, ACM and Reissue errors. Taking help with the partners on resolution and waivers.
  • Meet and exceed travel sales and revenue targets and department’s call servicing levels while providing exceptional customer service.
  • Work closely with the outsourced suppliers to ensure complete and accurate processing of travel documents, as well as following the processes and procedures in place. This include billing the correct amount to the correct account, claiming of correct commission / documentation fees, accurate quotation/ issuance of Airline Privilege deals and managing daily Galileo queues.
  • Build professional relationships and rapport with EY members in order to deliver personalized customer experience.
  • Conduct monthly client entertainments and incentivization and communicate all sales campaigns to relevant customers and obtain proof of commitment.

Travel Coordinator

Wipro Technologies
Bangalore, India
11.2013 - 07.2014
  • Deliver B2B travel services to Wipro employees in the entire APAC region, with more than 50 travel queries daily.
  • Cost of sales management: Designed regional KPIs and cost of sales index for Wipro APAC and ensure that all the travel itineraries are delivered within these thresholds. Achieved 7% annual reduction in the cost of sales.
  • Worked closely with the Airline corporate offices on new offers and deals to provide best services to our clients.
  • Majorly dealt with Airline reservation, Hotel bookings, Visa, Car rental etc.
  • Updates on monthly basis report on corporate deal and compliance internally. Like – Airline ADM, ACM and Reissue errors. Taking help with the partners on resolution and waivers.
  • Hotel presentations and Sales report on monthly basis.

Assistant Manager

Uniglobe Mod Travels
New Delhi, India
04.2012 - 04.2013
  • Ensure best Negotiated Hotel rates for Corporate Clients with over sales production of 1Mio INR.
  • Introduce new internal booking procedure to enhance productivity.
  • Increase of overall 10% YoY bookings through introduction of new inventory management modules to offer real time inventory.
  • Worked closely with travelers in fulfilling their travel requirements and requests with suitable travel itineraries and associated travel information. Also provide travel advice such as visa requirements, health checks and other travel related information together with complete, accurate and professionally presented travel documentation.
  • Resolves promotional allowance, rebate, and pricing discrepancies by researching promotion details and regular and special prices; forwarding resolution to managers.
  • Performs sales activities on major accounts and negotiates sales price and discounts in consultation with Head of Sales – Corporate

Team Leader

Yatra Online Pvt. Ltd.
Gurugram, India
06.2008 - 01.2012
  • Spearhead all India CRM sales team for hotel and package product with over sales production of 12Mio INR.
  • Executed various country / state level marketing & sales push actions to ensure +32% YoY growth is achieved.
  • Rostering and supervision of 35 executives & ensure smooth daily operation to contribute in overall commercial value for Yatra.
  • Enhance productivity by establishing new SOPs to reduce AHTs for calls by 28%.
  • Day to day external and internal communication with various stakeholders on new products, strategies and SOPs.
  • Loyalty management through after sales services & KYC programme to achieve growth of +37P.P in the retention of existing clientele with over 2Million INR sales.
  • Launch of targeted approach sales push actions to maximize revenue. For example – Rush Hour retargeting campaign during 12.30-14.30 & 19:00-20:30 the high peak booking hours. The campaign resulted in incremental revenue of 1.6Million INR.

Education

Bachelor of Commerce -

EIILM
Sikkim
01.2009 - 12.2011

Skills

Data Analysis

undefined

Accomplishments

  • Awarded the Best Quality Award in 2008 at Yatra Online Pvt. Ltd.
  • Awarded the Best Team Leader Award in 2010 at Yatra Online Pvt. Ltd.
  • Data Organization - Classified, recorded and summarized numerical and financial data to compile and keep financial records.

Software

Power BI

Tableau Creator

Microsoft Excel, Word & Powerpoint

R & Python

Certification

Data Science Certification, ExcelR Solutions - 6 Months

Timeline

Business Analyst

Qatar Airways
04.2021 - Current

Product Development & Quality Control Officer

Qatar Airways
03.2020 - 04.2021

Data Science Certification, ExcelR Solutions - 6 Months

02-2020

Product Coordinator

Qatar Airways
07.2015 - 03.2020

Travel Coordinator

dnata International Pvt. Ltd.
07.2014 - 07.2015

Travel Coordinator

Wipro Technologies
11.2013 - 07.2014

Assistant Manager

Uniglobe Mod Travels
04.2012 - 04.2013

Bachelor of Commerce -

EIILM
01.2009 - 12.2011

Team Leader

Yatra Online Pvt. Ltd.
06.2008 - 01.2012
Sanjay BasakBusiness Analyst