Ronit Sawant Email & Phone Number

London, Gb

London, England, United Kingdom

• Data Analysis and Reporting: Performed comprehensive data analysis using SQL, Looker, and BigQuery, developing data models that supported deeper insights and data-driven strategies, enhancing client engagement, conversion rates, and ROI.• Strategic Planning and Forecasting: Created a Python-based forecasting model to predict campaignperformance, accounting for seasonality and trends, which improved campaign planning and resourceallocation.• Automation and Efficiency: Spearheaded the development of a JavaScript automation script for budget pacing, ensuring zero overspends and saving significant time. Implemented automated data collection and cleaning workflows, streamlining data integration and increasing analytical efficiency.• Dashboard Development and Visualization: Built and maintained Looker and Tableau dashboards for internal and client reporting, creating real-time visualizations that improved client satisfaction and drove campaign optimizations.• Client Presentations: Led client presentations of paid media reports, working with cross-functional teams to showcase the full impact of campaigns through accessible storytelling, ensuring alignment on strategic recommendations.• Team Growth and Training: Trained team members on using dashboards, APIs, BigQuery, and automation tools, fostering a data-centric culture and boosting the team's analytical proficiency.

Bristol, England, United Kingdom

• Campaign Efficiency Assessment: Collaborated in evaluating the impact of GGC's Bristol 17 campaign, using data-driven methodologies to assess efficiency and drive insights.• Competitor Analysis: Conducted data scraping of competitor information, delivering actionable insights that informed strategic decisions and strengthened competitive positioning.• Project Leadership and Coordination: Demonstrated leadership in a collaborative project by initiating and organizing weekly meetings, coordinating directly with the client, and contributing to comprehensive project documentation for streamlined progress.• Advanced Data Visualization: Developed sophisticated Tableau visualizations, translating data insights into impactful visuals that provided managerial insights for the client.• Presentation of Key Findings: Delivered a clear and concise presentation, effectively communicating key findings and actionable recommendations to support client decision-making.

Mumbai, Maharashtra, India

• Website Development and Data Integration: Developed an interactive WordPress website and configured Google Analytics, enabling robust data collection that informed user engagement strategies and SEO initiatives.• Data Analysis for SEO Optimization: Analysed website performance data to identify trends and opportunities for SEO enhancement, resulting in improved online visibility and increased traffic.• Centralized Booking Management: Implemented a channel manager system that streamlined bookingprocesses from multiple online portals, facilitating efficient data tracking and analysis for reservation trends.• Revenue Optimization Analysis: Conducted in-depth analysis of billing system reports, utilizing data to refine pricing strategies and maximize revenue, contributing to overall profitability for the property.

Mumbai, Maharashtra, India

• Comprehensive Reporting and Analysis: Prepared detailed reports on past projects, performance data, and market trends, delivering valuable insights that supported strategic decision-making.• Consumer Behaviour Insights: Analysed media content from executed campaigns to gain a deep understanding of consumer buying behaviour, informing future product marketing strategies.• Data Visualization with Excel: Leveraged Excel to create insightful graphs and visualizations using pivottables, uncovering key performance insights that enhanced the effectiveness of marketing campaigns.

Master'S Degree, Business Analytics, Distinction

Bachelor Of Engineering - Be, Information Technology

Activities and Societies: Team Member - Artificial Intelligence ClubInformation Technology - Don Bosco Institute of Technology

Diploma, Information Technology