Sanjay Ranawat
West Delhi
Summary
Working as Business System Analyst & Travel Technology Consultant with 15+ years of experience in Tours & Travel Industry (Aviation) with proven expertise in Functional Consulting, Requirement Analysis, PSS (Passenger Sales and Service). Managed end to end life cycle of product development from business perspective & handled integrations with multiple Consolidators/ Vendors & GDS Systems. Experienced in Product development management, conversions, migrations and defining specifications for integrating product platform with different GDS, Consolidator & Direct Connects (API to API). Good consultation, Airfare Pricing, Baggage, OSF, ancillary products, EMD, IATA/ATPCO Pricing Rules, Air Fare Shopping and Re-Shopping functions, Reservations, Ticketing, Reissuance of tickets, Pricing and Fare loading knowledge and IATA /ATPCO mandates, RFP, Implementation of new Airline customer in PSS System. Worked for some top airlines including United, Ethiopian, Srilankan, Ukraine International etc good knowledge on Air Charter operations too. Sound knowledge of Project Analysis, Travel application support for all market(APAC, EGENCIA & North America/Canada), Concur, Compleat, Change Request, Troubleshooting, UAT/SIT, Implementation etc. Knowledge of all major GDSs like Amadeus, Galileo, Apollo, Sabre etc.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Business System Analyst
American Express Global Business Travel
Gurugram
05.2022 - Current
- Responsible for providing 2nd level product support.
- Maintain a good understanding of all AEGBT OBT/Approval products to ensure world-class support to AEGBT’s OBT product.
- Provide Issue triage, escalation and resolution to include: Troubleshoot issues thoroughly by understanding the impact of solution before providing the resolution.
- Provide complete case research conducted prior to escalating the case to 3rd Level, Internal Partner Team or Vendor/ technology partner.
- Test the solution or any new release of product functionality and provide information/awareness of any shortfalls before these are available to clients.
- Ensure SLA agreements are adhered to for problem resolution.
- Provide disruption communications to clients/internal teams on outages along with workaround, if any.
- Provide subject matter expertise on travel industry practices and underlying industry technologies.
- Working on Datadog for different prospective including error log, service impacted, validating issue and finding bug etc.
- Provide status reports as directed on progress and accomplishments to management.
- Maintain Product Support Documentation.
- Support on all global travel application of AMEX GBT including APAC, EGENCIA, NA, Canada etc.
- Working on Postman for new certification issuance as per end client requirement, finding inputs in Metadata file shared by client.
- Having call discussion in case of any bug or technical issue post certification update.
- Working on Compleat related issues raised by end user, sharing our findings, fixing an issue and raising a case with Concur in case of any latency issue or Compleat not processing ticketing for both online and offline bookings.
- Interact with Product Manager, L1 Team and Client Management team.
- Define requirements and document accordingly.
- Provide requirements to other teams as necessary.
- Resolve or escalate challenges.
- Understanding of web technologies.
- Conversant in Web-based technology with technical and non-technical audience.
- Experience in product testing and quality assurance.
- Co-ordination with global operations teams/depts./offices to ensure data accuracy.
- Maintain high level of quality and compliance scores.
ASSTT. MANAGER- RESERVATION & TICKETING
STIC Travel Group
New Delhi
09.2012 - 05.2022
- Managing Operation for Ukraine International Airlines.
- Day Close and making DSR.
- Day to day operation issues.
- Supporting other staff for Ticket Issuance, Re-Issue/exchange, Refund, Void, EMD, GDS Queue.
- Conducting staff training as per requirement.
- Negotiating with HO for special fares for agents.
- Both FIT & Group booking supervision and ensure entire operation process runs smoothly.
- Entertaining capping request from agents, checking their bank guarantee and past records.
- Monitor a regular flow of collection from clients.
- Follow-up with staff and sales to collect payment on time.
- Coordination with HO for any special waiver approval, wait list confirmation etc.
- Account Management(end to end coordination with unit and HO accounts for complete payment records).
- Conducting Periodic Workshops/road show on Products, updating agents on product enhancement and other updates.
- Preparing Periodic reports on monthly activities.
- Selling Ancillary services including(excess baggage, seat, meals, pet bookings) thus ensuring extra profit to airline.
- Preparing manifesto for Charter flights and sharing same with airport team and HO prior to flight departure.
- Preparing OAL/OTA fare comparison sheets on weekly basis.
- Preparing post flight departure report and doing analysis of point to point and beyond hub sales comparisons.
- Combined report and doing analysis of top selling agents in market.
- Increasing the network of top selling student consultant and providing best services all the time.
- Pitching existing passengers booked under Economy for flight upgrade and other ancillary services.
- Quoting group/series fares to agents, creating PNR's, getting fares and seats confirmation from HO, issuing advance payment EMD in PNR's and ensuring final ticketing as per dead line given by HO.
- Tapping top agents, film shooting, event companies, student consultants.
- Preparing and updating network chart on weekly basis or in case of any schedule change updates.
Team Leader
Fareportal
07.2007 - 08.2012
Education
MBA - Operations Management and Supervision
Indira Gandhi National Open University
01.2013
Bachelor's degree - Tourism and Travel Services Management
Indira Gandhi National Open University
01.2007
Skills
- Tourism
- Product support
- Issue resolution
- Technical troubleshooting
- Systems analysis
- Multitasking Abilities
- Airlines
- Business Analyst
Certification
- The International Air Transport Association (IATA)
- GDS-Galileo (YMCA)
Personal Information
Title: Business System Analyst- American Express GBT I Aviation I Manager-Reservation/Ticketing I Fitness Enthusiast
Timeline
Business System Analyst
American Express Global Business Travel
05.2022 - Current
ASSTT. MANAGER- RESERVATION & TICKETING
STIC Travel Group
09.2012 - 05.2022
Team Leader
Fareportal
07.2007 - 08.2012
MBA - Operations Management and Supervision
Indira Gandhi National Open University
Bachelor's degree - Tourism and Travel Services Management
Indira Gandhi National Open University
Similar Profiles
Joanne UphillJoanne Uphill
Senior business travel consultant at American Express Global Business TravelSenior business travel consultant at American Express Global Business Travel
Andres SanchezAndres Sanchez
Regional Manager, Business Development at American Express Global Business TravelRegional Manager, Business Development at American Express Global Business Travel
Christiana Palma-CaphartChristiana Palma-Caphart
Travel Counselor at American Express Global Business TravelTravel Counselor at American Express Global Business Travel
Sunii WrightSunii Wright
Travel Agent at American Express Global Business TravelTravel Agent at American Express Global Business Travel
AVTAR SINGHAVTAR SINGH
Relationship Manager, Banking Operations at RBL Bank Ltd .Relationship Manager, Banking Operations at RBL Bank Ltd .