Ajay Rawat

Senior Data Analyst @Degree 360 Solutions Pvt. Ltd

Delhi, IN

Monitored social media daily using Meltwater, identifying trending tweets, breaking news, and public sentiment shifts. Tracked audience behavior and engagement patterns to inform content strategy.Managed and queried large-scale datasets in Google BigQuery, ensuring optimized, scalable data infrastructure for advanced analysis of digital trends and campaign performance.Performed data cleaning and transformation using Google Sheets, leveraging formulas, pivot tables, and conditional formatting to create quick, insightful summaries and visualizations.Designed dynamic dashboards and performance reports in Looker Studio, visualizing key content metrics (e.g, reach, engagement, impressions) to communicate insights clearly to stakeholders.Analyzed performance data across YouTube, Instagram, and X (Twitter), uncovering audience demographics, behavior patterns, and content preferences to refine outreach and posting strategies.Generated actionable insights from real-time public online data, contributing to data-driven decision-making in communication strategies, campaign design, and stakeholder reporting. Identified KPIs, benchmarked performance, and tracked campaign ROI, translating complex analytics into recommendations that improved targeting and audience engagement. Collaborated cross-functionally with content, PR, and digital teams, ensuring insights from social listening and platform data were integrated into broader communication plans.

Delhi University

Bachelor of Commerce - BCom