Sandeep Gulati
Gurgaon
Summary
Business Analyst with rich, cross functional exposure of over 17 years of collective experience in Travel industry out of which around 11 years in MIS in Travel domain. Well-honed expertise in the areas of MIS and Travel Operation with the leading Travel organization. Knowledge of Report Designing and Dashboards, providing insights on pre and post analysis of client level business reports. Hands-on experience of working on various tools, applications like Microsoft Excel, Microsoft Access and Power Point. Expertise on end to end travel operations, worked on GDS, and fare filing tool.
Overview
18
18
years of professional experience
Work History
Manager MI Reporting
EXL Services INDIA PVT LTD
07.2018 - Current
- World Bank Reporting: Spearhead data updates and validation through the World Bank E-portal tool. Conduct detailed analyses of transaction fee categories, ensuring data integrity and accuracy. Develop and maintain comprehensive dashboards to facilitate data-driven decision-making and visualization.
- Mobile App User and Product Pipeline Reporting: Lead the analysis of mobile app user data using Salesforce, creating insightful dashboards and scorecards to track user patterns and validate client data. Oversee the Product Pipeline process, analyzing finalized and missed opportunities, and generating ad-hoc snapshot analyses for strategic insights.
- MICC Team: Manage global MI reporting tasks, including data formatting, manipulation, cleansing, and processing using Excel and Access. Consolidate raw data from various databases and tools to produce client-specific dashboards and scorecards. Design visually enriched Business Review and Company Reporting documents for clear client communication.
- Performance Management Team: Conduct critical financial accounting and operational analytics reporting for internal and external stakeholders. Adapt report formats based on evolving client requirements. Lead the migration of reports to new technology platforms such as IBM Lotus and SharePoint.
- Germany Mid Office: Managed the refund process on the Amadeus platform, analyzing and processing refunds and Agency Debit Memos (ADMs) for EMEA markets. Coordinated monthly reports with stakeholders, ensuring timely and accurate communication. Developed monthly SLA scorecards and metrics, and provided cross-training to analysts to handle high-volume situations effectively.
Sr. Associate MI Reporting
EXL Services INDIA PVT LTD
01.2013 - 06.2018
- Responsible for analyzing Mobile app user count and client validation through Salesforce tool
- Creation of dashboard and scorecard for easy analysis and Insights on consumer pattern
- Product Pipeline- Analyze opportunities which are finalized and missed by the company
- Creating ad-hoc snapshot analysis on the missed opportunities.
Sr. Analyst
EXL Services INDIA PVT LTD
09.2010 - 12.2012
- Responsible for Global MI Reporting which includes formatting, manipulating, cleansing and processing of data through Excel and Access platforms
- Worked on the different databases and tools to manage raw data in consolidated format and later used for creating the dashboard and scorecard for clients analysis
- Creating visually enriched Business Review and Company Reporting for easy interpretation by client.
Senior Travel Counselor
CARLSON WAGONLIT TRAVEL
01.2010 - 09.2010
- Processed refunds for Domestic and International itineraries full/partial for all the airlines
- Updating penalties and refunds on ARC (Airlines Reporting Corporation) with manual intervention.
Team member
GATEWAY BPO INDIA PVT. LTD.
11.2006 - 01.2010
- Team member in Fares Distribution Process worked on ATPCO, Agency Private Fares (APF)- Galileo, Offline Hitchhiker and XML Amadeus Conversion
- Loading fares for all International Airlines especially for (European market)
- Worked on Galileo CRS for Fare Pricing, Checking correct display of routing, fares display and rules.
Education
Diploma in Travel Tourism & Airport Handling -
YMCA
Diploma in Amadeus - undefined
BACHELOR OF ARTS (P) - undefined
Delhi University
01.2004
CBSE (10+2) - undefined
Govt. Boys Sr. Sec. School, New Delhi
01.2000
Skills
- Knowledge of all Microsoft Office series
- Verbal and written communication
- Key Performance Indicators
- Team Leadership
- Project Management
- Staff Training and Development
Accomplishments
- Awarded with Grace Differentiator in Q2 2019 for client appreciation in the process.
- Awarded with Shining Star award in Q3 2014 for best performer in the process.
- Awarded star performer in Germany Mid office for Quality in refund process.
Priorexperience
- CARLSON WAGONLIT TRAVEL, Senior Travel Counselor, 01/2010, 09/2010, Processed refunds for Domestic and International itineraries full/partial for all the airlines, Updating penalties and refunds on ARC (Airlines Reporting Corporation) with manual intervention
- GATEWAY BPO INDIA PVT. LTD., Team member, 11/2006, 01/2010, Loading fares for all International Airlines especially for (European market)., Worked on Galileo CRS for Fare Pricing, Checking correct display of routing, fares display and rules.
Personal Information
Date of Birth: 08/12/82
References
Available on request
Hobbies and Interests
Music, Cricket & Travelling.
Timeline
Manager MI Reporting
EXL Services INDIA PVT LTD
07.2018 - Current
Sr. Associate MI Reporting
EXL Services INDIA PVT LTD
01.2013 - 06.2018
Sr. Analyst
EXL Services INDIA PVT LTD
09.2010 - 12.2012
Senior Travel Counselor
CARLSON WAGONLIT TRAVEL
01.2010 - 09.2010
Team member
GATEWAY BPO INDIA PVT. LTD.
11.2006 - 01.2010
Diploma in Travel Tourism & Airport Handling -
YMCA
Diploma in Amadeus - undefined
BACHELOR OF ARTS (P) - undefined
Delhi University
CBSE (10+2) - undefined
Govt. Boys Sr. Sec. School, New Delhi
Similar Profiles
Anand ChavanAnand Chavan
Sr. Executive - P&C Insurance at EXL Services India Pvt LtdSr. Executive - P&C Insurance at EXL Services India Pvt Ltd
Keshoo SharmaKeshoo Sharma
Manager-Strategic Communications and Content at EXL Services (India) Pvt. Ltd.Manager-Strategic Communications and Content at EXL Services (India) Pvt. Ltd.
Tandeep Singh AhluwaliaTandeep Singh Ahluwalia
Team Leader at Cognizant Technologies India Pvt. LtdTeam Leader at Cognizant Technologies India Pvt. Ltd