Akash Kumar

Experience

1. Data Analyst

   Tripxl

   Jul 2025 — Present · Siliguri, IN

   Analyzed large-scale travel booking, pricing, and customer data using Python (Pandas, NumPy) and BigQuery, delivering actionable insights to boost sales conversion and operational efficiency.Designed interactive dashboards in Power BI and Looker Studio to track KPIs such as booking trends, revenue per route, customer satisfaction, and cancellation rates.Collaborated with Sales, Operations, and FCD teams to identify key business challenges and convert them into data-driven solutions and visual insights.Automated weekly and monthly sales performance and route efficiency reports using Python scripts and BigQuery SQL queries, reducing manual reporting time by 40%.Performed data cleaning, transformation, and validation across multiple sources (CRM, booking systems, and Excel files) to ensure report accuracy and consistency.Leveraged Excel (VLOOKUP, HLOOKUP, Pivot Tables, Power Query) for quick data reconciliation and ad-hoc analysis for cross-functional stakeholders.Developed forecasting and trend analysis models to predict demand by region and travel season, helping the Sales team optimize offers and pricing.Integrated BigQuery datasets with Power BI dashboards for real-time visualization of travel metrics and performance KPIs.Conducted customer segmentation and retention analysis using Python and SQL to identify repeat traveler behavior and high-value customer profiles.Presented insights and business recommendations through data storytelling, enabling senior management to make data-backed decisions on sales strategy, destination planning, and cost optimization.

Education

• Babasaheb Bhimrao Ambedkar University Lucknow

  Bachelor of Technology - BTech, Computer Engineering