Rohit Sharma

Results-driven Data Analyst with 3 years of experience in data analysis, client reporting and market research operations in the FMCG and Travel sectors. Skilled in SQL, Advanced Excel and Power BI for data extraction, transformation and dashboard development. Experienced in delivering KPI-driven insights, improving reporting efficiency and ensuring data accuracy while managing multiple projects in dynamic environments.

Data Analyst – Travel Operations & Sales Analytics at REDSAND (2024-01 – Present)

• Analyzed travel booking and sales data using SQL and Excel, identifying revenue and improving overall sales performance by 16% through data-driven insights.
• Designed and implemented an internal CRM tracking system in Google Sheet to manage client and lead information, improving data accessibility and reducing data retrieval time by 35%.
• Automated alert mechanisms for key metrics such as booking delays, cancellations and SLA breaches, reducing manual monitoring effort by 40%.
• Monitored and ensured SLA and issue resolution, achieving 95% SLA adherence.
• Conducted Root Cause Analysis (RCA) on recurring issues (booking failures, delays and cancellations), reducing repeat issues by 20% and improving operational efficiency.
• Used Jira to coordinate with cross-functional teams (operations and support), improving issue resolution turnaround time by 25%.
• Developed and maintained interactive dashboards in Power BI to track KPIs such as sales targets, agent performance and booking trends, increasing reporting visibility by 22%.
• Tracked and analyzed sales team performance (targets vs achievement), enabling performance optimization.

Data Associate – FMCG at NUMERATOR (2022-07 – 2023-11)

• Analyzed and Extract FMCG retail Images using company tools to generate actionable business insights.
• Developed and automated Excel-based reports (Pivot Tables, advanced formulas), reducing manual reporting effort by 35%.
• Ensured high data quality standards by maintaining 98%+ accuracy in data validation and reporting processes.
• Processed and validated 2,000+ consumer receipts daily, supporting accurate and timely FMCG analytics.
• Collaborated with cross-functional teams to deliver insights on top-performing.
• Maintained strict adherence to SLA timelines, ensuring timely and accurate data delivery for client reporting.
• Managed multiple high-volume tasks in a fast-paced, deadline-driven environment while maintaining data integrity.

B.Sc. in Hospitality & Business Management