HEMANTH UPPUTURI
Tableau Developer | Data Analyst
About
Detail-oriented Data Analyst with 2 years of experience at IBS Software in the airline and travel domain. Skilled in SQL, Tableau, and Excel for data analysis, dashboarding, and reporting. Experienced in building customer analytics, loyalty tracking, and financial KPI dashboards to drive decision-making. Adept at translating complex data into actionable insights that improve customer retention, optimize revenue, and reduce reporting time.
Skills & Expertise (12)
Work Experience
Data Analyst
IBS Software Pvt. Ltd.
Sep 2023 - Sep 2025
Designed SQL-based passenger funnel analysis (bookings → payments → tickets), identifying key drop-off points and improving customer onboarding efficiency. Built Tableau dashboards for repeat vs new passenger trends, cancellations by route/class, and marketing experiment (A/B test) tracking, supporting passenger retention strategies. Segmented loyalty program members into Silver/Gold/Platinum tiers, using SQL and Tableau to monitor points balance, redemption rates, and loyalty-driven revenue share. Analyzed and segmented customer groups using SQL and Tableau based on historical transaction behavior and demographic attributes (age, location, etc.), deriving cohort-level metrics to identify trends, retention patterns, and high-value segments for targeted insights. Automated financial KPI dashboards (daily/monthly revenue, rolling 3-month averages, MoM/YoY growth, booking-to-payment conversion) in Tableau, reducing manual reporting time by 30%. Conducted payment method analysis using SQL to identify customer preferences and failure rates, contributing to smoother payment lifecycle management. Validated data accuracy using Excel Pivot Tables and provided ad-hoc insights for business teams. Primarily worked with iFly (passenger services) and iLoyal (loyalty management), while occasionally supporting cross-functional products like iFlight (flight operations) and iCargo (air cargo management) on an ad-hoc basis.
Education
Bachelor of Technology (B.Tech), Computer Science - QIS College of Engineering
2019 - 2023 · Afghanistan
