Mihir Kalavatia

Analyze 95K+ booking, finance, collections, and debtor records using SQL, Python, and Advanced Excel to generate insights on revenue, outstanding receivables, collection performance, and venue-level performance. Build complex SQL queries and Python (Pandas) workflows to extract, transform, clean, reconcile, and validate transactional datasets across booking and finance systems to improve reporting accuracy. Automate recurring data preparation and reporting workflows in Python and Excel, including extraction, transformation, validation, reconciliation, and formula-driven KPI reporting to reduce manual effort. Create automated Excel dashboards by integrating database-driven data pulls with KPI calculations and reconciliations for senior stakeholders. Develop debtor ageing and collections frameworks covering 180+ day outstanding receivables, tracking ageing movement, recovery performance, and financial gaps. Analyze booking, revenue, collections, and operational performance across SOB, VM

Analyze workflow processes and task-level performance across multiple operational queues to identify trends, bottlenecks, and data-quality issues. Evaluate data accuracy, output consistency, and adherence to business guidelines while collaborating with cross-functional teams to understand requirements and support process optimization.

Manage campaign analytics and sales performance for 5+ Amazon and Flipkart client accounts, optimizing budget allocation, campaign performance, and bidding strategies to improve ROI by ~15%. Identify product-performance gaps across stock availability, pricing, and delivery timelines, improving product availability to ~95% and contributing to ~15% revenue growth. Support GTM strategy for 2 brand launches via category research, competitor benchmarking, and pricing analysis, driving ~15% first-quarter sales uplift. Build dashboards and standardized reporting frameworks to automate recurring analysis and reduce manual reporting effort by ~40%. Mentor junior analysts to improve reporting efficiency.