Summary
Overview
Work History
Education
Skills
Certification
ADDITIONAL INFORMATION
Timeline
Generic

SHIVAM SHARMA

Anuppur

Summary

Analytical professional prepared for this role with extensive experience in data analysis and interpretation. Known for delivering actionable insights and driving process improvements that align with business goals. Highly collaborative team player with focus on achieving results and adapting to changing needs. Skilled in statistical analysis, data visualization, and project management.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Reporting & Insight Analyst

Annalect India
11.2024 - Current
  • Built channel-specific & Executive dashboards in Marketing Cloud Intelligence to track weekly, monthly, and annual KPIs like CPM, media cost, impressions, view rate, and engagement across campaigns for various media channels.
  • Designed a Taxonomy Governance dashboard in MCI Datorama to automate QA of taxonomy compliance, resulting in an 80% reduction in manual QA effort and overall time spent.
  • Implemented rigorous comparative data QA across several platforms to maintain data accuracy and reliability.
  • Streamlined and managed data modeling and cleansing for multi-source data—including DV360, CM360, Google AdWords, Amazon Ads, Snapchat Ads, TikTok, and Meta—within Marketing Cloud Intelligence.

Sr. Analyst

IPG Media Brands
11.2023 - 11.2024
  • Executed thorough data ingestion into Datorama and ensured accuracy in site serve data.
  • Addressed various ad hoc requests from onshore teams regarding Tableau, including MMM and VCR QA.
  • Developed comprehensive Tableau reports for Modelo Beer brand, emphasizing key media metrics and KPIs.
  • Utilized Python to automate manual site serve QA processes, enhancing efficiency in data analysis resulting in reduction in the total time for the QA process by 90%.

Sr. Customer Success Analyst

Jio Haptik Technologies Ltd.
06.2022 - 10.2023
  • Managed diverse high-touch accounts, achieving average annual recurring revenue of 1.5 crore.
  • Developed dynamic dashboards for JioFiber, JioMart, and Jio All accounts using Looker Studio and Power BI.
  • Consulted clients on user behavior and cart abandonment, reducing agent handover tickets by 8%.
  • Analyzed conversations and user intent, increasing chatbot conversation accuracy by 15%.

SEO Analyst

Turing
12.2021 - 06.2022
  • Designed and developed dynamic Looker Studio dashboards for end-to-end KPI tracking, leveraging data from Google Analytics, Google Search Console, and SEMrush to drive actionable insights.
  • Built a dashboard on Looker leveraging SEMrush data to conduct regional comparative analysis of website pages target across various regions for performance insights.
  • Created an integrated social media performance dashboard combining YouTube Analytics and Google Analytics data to monitor key engagement and reach metrics.
  • Produced in-depth monthly health metric reports to support the technical SEO team with data-driven recommendations and performance diagnostics.

Education

MBA - Marketing

Prestige Institute of Management & Research
Indore
10.2020

Bachelor of Science - Computer Science

IPS Academy
Indore
12.2016

Skills

  • Microsoft Excel
  • SQL
  • Tableau
  • Looker
  • Power BI
  • Python
  • Data modeling
  • Marketing Cloud Intelligence (Datorama)

Certification

Data Analytics bootcamp by Coding Ninjas, Marketing Analytics course certificate by Udemy

ADDITIONAL INFORMATION

Languages: English, Hindi

Timeline

Reporting & Insight Analyst

Annalect India
11.2024 - Current

Sr. Analyst

IPG Media Brands
11.2023 - 11.2024

Sr. Customer Success Analyst

Jio Haptik Technologies Ltd.
06.2022 - 10.2023

SEO Analyst

Turing
12.2021 - 06.2022

MBA - Marketing

Prestige Institute of Management & Research

Bachelor of Science - Computer Science

IPS Academy
SHIVAM SHARMA