SAGAR DHALL
Mumbai
Summary
Detail-oriented Sr. business analysis professional and certified product owner with several years of experience as subject matter expert in Airline Crew Rostering/planning and Irregular operations conducting analysis and research to come up with solutions to common business problems for 2nd biggest cost to Airlines. Polished in formulating business improvement strategies and overseeing new technology and system implementation. Commercially-aware professional with in-depth knowledge of computing systems and project/product management techniques.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Sr. Functional Business Analyst
Zest IOT Technologies
Hyderabad
05.2024 - Current
- Aircraft Turnarounds, camera AI, and IoT timestamping-based tracking of aircraft turnaround, 60+ activities, and equipment, Mobility and Resource Management.
- Integrations of PSS and DCS, along with other systems (APIS and PNR), with Ground Radar AI and IoT platform for accurate time stamping and aircraft turn around optimization.
- Leading the requirement gathering by collecting and understanding the business requirements, and translating those into functional requirements.
- Translated operational needs into effective UI/UX designs.
- Evaluated interdependencies between various requirements.
- Conduct gap analysis and propose solutions to reduce development efforts.
Senior Business Analyst - B-SME
CAE Flight Services
Bengaluru
08.2022 - 05.2024
- Subject Matter Expert, Trainer, CAE Crew Manager, and CAE Crew Access.
- Planning, conducting, and directing the analysis of highly complex business problems to be solved with automated systems, cross-functions, and cross-business domain.
- Analyzed existing systems and processes, identified gaps and recommended improvements.
- Developed business process models to identify and document customer requirements. Recorded the same in the form of RUD, FRD, BRD, SRS, and User guides.
- Effectively working, Requirement Gathering, Gap Analysis, and Use Cases for one of the biggest airlines in India.
- Data Migration using SQL, CSV, XMLs, and SoapUI/Postman API-based internal tools.
- Conducted onsite system and user trainings for both CM and CA modules for Asia's largest airline merger.
- Set up the advance passenger information system by effectively communicating with countries and border control.
- Assist testing team in Functional and Integration testing.
Business Analyst - SITA API/PNR Gateway
Coforge Ltd
Greater Noida
06.2021 - 08.2022
- Led requirement gathering sessions for business analysis projects by effectively communicating with countries and border agencies for any updates, incidents, or bugs in the flow of IATA UN/US - APIS/PNR Edifact messages.
- Streamlined processes in PSS and DCS implementation with SITA - Data Acquisition system.
- L3 support team member for SITA GSL API PNR Gateway.
- IATA Guidelines - PNRGOV, APIS, PNR, DCS, PSS
- Incident Management - Utilized ServiceNow gateway to optimize incident resolution processes.
- User acceptance test, functional, and integration testing, Definition of done (SDLC).
- Team grooming and incident/backlog tracking using ServiceNow, ADO. Daily Scrum and product management
Dy. Business Analyst - SME - Crew Roster Optimization
Laminaar Aviation India Pvt Ltd
Bengaluru
02.2019 - 06.2021
- Subject Matter Expert - Airline Crew Management
- Worked alongside business analysts, airline personnel, and experts to update the crew rostering and trip system.
- Developed and implemented next-gen, parameters-based optimized crew rostering and trip system.
- Initial testing and KPIs proved that CRO roster coverage was increased from 80% to 98%.
- Requirement Gathering and product management.
- Documentation and backlog management using tools like TFS, Salesforce
- Client handling and product demonstration and product ownership.
Supervisor - In Flight Ops – Crew Scheduling/Rostering
Jet Airways India Ltd.
Mumbai
10.2017 - 02.2019
- Scheduling and Monitoring Crew Rosters, Live systems update and validate all required data using the IBS Software - Avient Crew Management for crew management.
- Optimum utilization of crew, meeting all legalities, and ensuring stability of planned crew roster, and the on-time departure of the flight.
- Maintain all data records as per requirement and as per Company policy.
- Ensure all coordinators are scheduling with DGCA guidelines and following the CAR-FDTL. Directed and supervised a team of 15 Crew Coordinators in daily operations.
Senior Executive – In Flight Ops – Crew Scheduling/Planning
Go Air India Ltd (Go First Airlines)
Mumbai
04.2016 - 10.2017
- Guarantee uninterrupted cabin crew rosters and schedules for 24, 48, and 72 hours window.
- Ensured timely release of crew rosters per operational requirements
- Coordination for the aircraft movement with OCC on a daily basis. Ensuring smooth daily operations without any scope of delay or lag. Well versed with Laminaar India's Aviation Resource Management Software (ARMS).
- Handling cockpit and cabin crew queries and solving them, avoiding escalations.
- Expertise in FDT/FDTL/Rest period of cabin and cockpit crew (as per DGCA CAR sec 7, Series J, Part 1 and Part 3)
- Also assisting and supervising the planning team for planned rosters.
Coordinator – In Flight Ops –Crew Scheduling/Rostering
Jet Airways India Ltd.
Mumbai
05.2015 - 04.2016
- Scheduling and Monitoring Cabin Crew Rosters
- Validated required operating system data for live systems (IBS Software- Avient Crew Management)
- Facilitated communication with cabin crew to meet daily requirements
- Coordinated with base managers for urgent last-minute schedule changes
- Ensured accurate coordination of crew assignments and irregular operations due to last-minute updates.
- Ensured optimal use of cabin crew within legal frameworks
- Maintain stability in scheduled Cabin Crew roster
Executive - Projects and Logistics
Tspace Planning and Services Pvt Ltd
Mumbai
03.2013 - 08.2014
- Managed all company import operations
- Coordinated continuously with CHA on documentation requirements
- Identified and fulfilled client requirements
- Coordinating project timelines and logistics
Education
Post Graduate Degree (PSM) - Logistics and Supply Chain Management
Welingkar Institute of Management
Mumbai04.2014
BBA - Business Management
University of Mumbai
Mumbai04.2012
Skills
Functional Skills
- Airline crew scheduling, planning, and disruption management (IROPS)
- Business analysis, requirement gathering
- Product and project management
- Business planning and consulting
- IATA EDIFACT, APIS and PNR (Border Control)
- Customer handling, product demos, and training
Technical skills
- Documentation (FRD, BRD, SRS, UAT)
- Microsoft Office
- JIRA
- SQL
- ServiceNow
- Salesforce
- ADO
- TFS
- Power BI
Crew Management System Expertise
- IBS Software, Avient iFlight
- Laminaar Aviation - ARMS
- CAE - Crew Manager, Crew Access, TNQ
- AIMS (Basic)
Certification
- Certified Data Analyst - IABAC and NASSCOM, 08/01/24
- Certified Scrum Product Owner - CSPO
- SAFe 5.1 - Agilist
Accomplishments
- Coforge - Pat on the back award - For excellent customer support, Incident Management and on time delivery.
- CAE Champions award - For handling one of the biggest customer, gathering requirement and data migration.
Personal Information
- Date of Birth: 08/10/91
- Nationality: Indian
Timeline
Sr. Functional Business Analyst
Zest IOT Technologies
05.2024 - Current
Senior Business Analyst - B-SME
CAE Flight Services
08.2022 - 05.2024
Business Analyst - SITA API/PNR Gateway
Coforge Ltd
06.2021 - 08.2022
Dy. Business Analyst - SME - Crew Roster Optimization
Laminaar Aviation India Pvt Ltd
02.2019 - 06.2021
Supervisor - In Flight Ops – Crew Scheduling/Rostering
Jet Airways India Ltd.
10.2017 - 02.2019
Senior Executive – In Flight Ops – Crew Scheduling/Planning
Go Air India Ltd (Go First Airlines)
04.2016 - 10.2017
Coordinator – In Flight Ops –Crew Scheduling/Rostering
Jet Airways India Ltd.
05.2015 - 04.2016
Executive - Projects and Logistics
Tspace Planning and Services Pvt Ltd
03.2013 - 08.2014
Post Graduate Degree (PSM) - Logistics and Supply Chain Management
Welingkar Institute of Management
BBA - Business Management
University of Mumbai
Similar Profiles
Umrah ZamirUmrah Zamir
Finance Executive Officer at IOT TechnologiesFinance Executive Officer at IOT Technologies
Danesa ColladoDanesa Collado
Waitress/Hostess/Cashier at Zest loungeWaitress/Hostess/Cashier at Zest lounge
Hayley HillsHayley Hills
Reception and Floor Hostess at Zest HospitalityReception and Floor Hostess at Zest Hospitality