Ayush Upadhyay
Gurgaon
Summary
Senior Media & Data Analyst with 4+ years of experience in media analytics,
campaign performance analysis, and data-driven reporting. Strong in SQL,
Power BI, Google Analytics, and Tableau to analyze large datasets, build
dashboards, and deliver actionable insights for business and marketing teams.
Experienced in working with global stakeholders and supporting decision-making
through clear data storytelling.recommendations. Adept at driving engagement and improving performance through strategic content and media analysis.
Overview
6
6
years of professional experience
Work History
Senior Media Analyst
WIPRO Limited
Gurgaon, Haryana
09.2021 - Current
- Client-facing analytics role supporting global automotive accounts, focused on media performance analysis and data-driven reporting.
- Built and maintained Power BI dashboards using SQL and Google Analytics to track media campaign KPIs for global stakeholders.
- Collaborated effectively with Onshore Managers to support the creation of reports for high-profile global automotive clients, ensuring accuracy and timely delivery of insights. Used SQL (PostgreSQL) to extract, transform, and analyze large datasets from multiple sources to support media performance analysis.
- Analyzed campaign and media performance data to identify trends and optimization opportunities, supporting strategic recommendations for clients.
- Conducted in-depth quantitative and qualitative research to identify key trends, providing clients with valuable insights and improving overall media strategies.
- Utilized Cision Software to track media mentions and campaign effectiveness, streamlining the process of performance reporting and insights generation.
- Led the enhancement and continuous monitoring of team KPIs, coaching and supporting new team members to improve their analytical and reporting capabilities.
- Extracted and processed large datasets from multiple sources using SQL to facilitate informed business decisions, optimizing marketing strategies and campaign outcomes.
- Presented data insights and performance summaries to onshore managers and stakeholders, translating complex data into clear business insights.
Content & Media Strategist
EGSS
New Delhi
01.2020 - 08.2021
- Analyzed content and media performance using Google Analytics and business intelligence tools to identify traffic trends and improve audience engagement. Built reports and interactive dashboards using Tableau and Power BI to support media and campaign performance analysis for stakeholders. Used SQL and PostgreSQL to extract, transform, and analyze datasets, enabling accurate reporting and data-driven decision-making.
Education
B.Tech. - Electrical
University of Petroleum and Energy Studies
Dehradun, India01.2018
12th -
Maa Durga International School
Varanasi, Uttar Pradesh, India01.2014
10th -
W.H Smith Memorial School
Varanasi, Uttar Pradesh, India01.2012
Skills
- SQL: PostgreSQL, MySQL; advanced SQL including CTEs, window functions, ranking, trend analysis
- Business Intelligence & Visualization: Power BI, Tableau, Google Data Studio
- Analytics & Tracking: Google Analytics, media and campaign performance analysis, KPI reporting
- Data Analysis: Data extraction, transformation, reporting, and dashboarding
- Programming: Python (basic)
- Tools & Utilities: Excel, Cision Software, Git
Timeline
Senior Media Analyst
WIPRO Limited
09.2021 - Current
Content & Media Strategist
EGSS
01.2020 - 08.2021
B.Tech. - Electrical
University of Petroleum and Energy Studies
12th -
Maa Durga International School
10th -
W.H Smith Memorial School