Pratyush Kailkhura
Bangalore
Summary
Dynamic and results-driven Senior Business Analyst with extensive expertise in extracting and transforming data to deliver strategic insights.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Business Analyst
TREEBO HOSPITALITY VENTURES
Bengaluru
03.2023 - Current
- Developed tracking dashboards to monitor and analyze negative feedback trends, leading to a 41% reduction in guest-related issues and enhancing guest satisfaction.
- Contributed to revenue optimization by analyzing room occupancy and booking patterns, supporting more accurate forecasting and revenue strategies.
- Analyzed operational data across 800+ active hotels, identifying process improvements that streamlined workflows, reduced costs, and upheld brand standards.
- Acted as a bridge between logistics and hotel partners in procurement, optimizing the supply chain and achieving a 10% increase in profit margins.
- Created visually compelling, interactive dashboards that provided senior management and stakeholders with clear, actionable insights, facilitating timely decision-making.
- Developed data-backed procurement strategies that optimized vendor relationships, reduced costs, and supported uninterrupted service delivery for enhanced guest satisfaction.
- Established data-driven systems for preemptive issue identification, using trend analysis to mitigate potential risks early, which boosted operational reliability and guest retention.
Analyst
SQUADSTACK
Noida
06.2022 - 03.2023
- Provided insights using SQL for data-driven decisions increasing the revenue of the current brokerage business by ~10%.
- Developed automated reports using PostgreSQL improving the business reach by ~15%.
- Created multiple dashboards on Metabase by extracting and analyzing data in SQL; providing better insight into the business of different stakeholders.
- Created a centralized tableau dashboard for customers to easily access data/metrics in one place, reducing their time and aiding faster decision-making.
- Identified bottlenecks of the Customer success and the operation team by extracting and analyzing user data; helping in achieving new milestones and targets.
- Maintained and planned the supply chain for the clients by identifying degraded metrics using SQL on performance data.
- Provided insight to the quality team for monitoring and coaching agents according to the defined SOPs by analyzing the low performer's data using PostgreSQL.
Team Manager
FIRSTCRY.COM
Dehradun
07.2021 - 06.2022
- Utilized SQL and Excel to extract and analyze performance data, enabling actionable insights, and driving process optimization.
- Designed visually engaging performance dashboards to present team data to stakeholders, helping to identify operational pain points and areas of improvement.
- Forecasted and analyzed call volume trends to ensure optimal staffing and adherence to daily, weekly, and monthly SLA targets.
Team Leader
TECOMELLA PVT LTD
Dehradun
05.2018 - 06.2021
- Tracked and optimized team KPIs (AHT, CSAT, Attrition, Shrinkage) using Excel dashboards and pivot analysis to identify trends, reduce inefficiencies, and drive weekly performance reviews.
- Led end-to-end team operations, including interviewing, onboarding, training, performance evaluation, promotions, and exits.
- Monitored daily, weekly, and monthly performance metrics to identify trends and drive continuous improvement.
Executive
INDIAMART INTERMESH
Dehradun
09.2017 - 06.2018
- Single-handedly handled 2,000+ customers monthly.
- Involved in improving the buyer-supplier matchmaking system of IndiaMart
Education
BBA -
Doon University
06.2017
Skills
- SQL
- Python (intermediate)
- MS Excel
- Dashboard creation
- Data visualization/Tableau
- Data management
- Data analysis
- Team management
- Operations management
- Quality management
Certification
- Advanced Excel
- NSE's Certification in Financial Markets
Timeline
Senior Business Analyst
TREEBO HOSPITALITY VENTURES
03.2023 - Current
Analyst
SQUADSTACK
06.2022 - 03.2023
Team Manager
FIRSTCRY.COM
07.2021 - 06.2022
Team Leader
TECOMELLA PVT LTD
05.2018 - 06.2021
Executive
INDIAMART INTERMESH
09.2017 - 06.2018
BBA -
Doon University
Similar Profiles
Abhishek GautamAbhishek Gautam
Senior Manager at Treebo Hospitality VenturesSenior Manager at Treebo Hospitality Ventures
Krishna MohantyKrishna Mohanty
Manager - National Sales at Treebo Hospitality VenturesManager - National Sales at Treebo Hospitality Ventures
Aneesha SasidharanAneesha Sasidharan
Associate Director - Talent Acquisition at Treebo Hospitality Ventures Pvt LtdAssociate Director - Talent Acquisition at Treebo Hospitality Ventures Pvt Ltd
Madhushree N SMadhushree N S
Customer Support Representative at ELEMENT14 INDIA PRIVATE LIMITEDCustomer Support Representative at ELEMENT14 INDIA PRIVATE LIMITED
SHREYA DESHREYA DE
DIRECTOR OF ENGINEERING at VISADIRECTOR OF ENGINEERING at VISA