Pratham Dhir

+•• ••••• •••••••••••@•••••.com

Data Analyst · Publicis Groupe · 6 yrs

As a Data Analyst, I am driven by an insatiable curiosity to uncover profound insights from complex data, always striving for mastery in my craft. With four years of experience, I approach every challenge with ambition and a strong sense of accountability, ensuring my analytical solutions are not only impactful but also thoughtfully presented and practically applicable.

  • Open to Bangalore · Mumbai · Delhi · Gurgaon · Noida
  • On-site
  • In 30 days

Ask about Pratham

Skills

Claimed

Dashboard PublishingParameter CreationContent Taxonomy StructuringSoftware Quality AssuranceData MonitoringDatabricks UsageData ValidationReceiving and Incorporating FeedbackDefect TrackingMeeting FacilitationWork Planning and PrioritizationRequirements Analysis

Proof of Experience

Publicis Groupe

Data Analyst

Publicis Groupe · Aug 2025 – Present

  • Managed and enhanced media performance dashboards using Power BI and Tableau, improving reporting efficiency by 60% across 40+ countries for 20+ stakeholders.
  • Managed Databricks ETL pipelines processing 1.6M+ rows, reducing manual data processing effort by 80% and accelerating data availability across reporting systems.
  • Optimized DAX queries and data models, reducing dashboard load time by 70% through targeted performance improvements.
  • Resolved 20+ JIRA tickets for dashboard updates, issue resolution, and new KPI integrations, maintaining 100% SLA compliance for global teams.
  • Managed funnel processes for data transformation and validation, ensuring high data integrity across all reporting pipelines.
  • Delivered actionable campaign performance insights (ROI, CPM, VCPM) to support strategic business decisions for senior stakeholders.
  • Collaborated with cross-functional teams to ensure accurate, timely, and automated reporting aligned with business goals.

Data Specialist

Anaqua · Apr 2024 – Aug 2025

  • Built dynamic dashboards and reports using Excel and Power BI, improving data accuracy by 80% to support business strategy and client reporting.
  • Conducted in-depth portfolio analysis of 30+ patents and trademarks, enabling clients to optimize IP assets and increase asset utilization by 70%.
  • Standardized and cleansed 1M+ record datasets, ensuring accuracy and efficiency across reporting systems.
  • Automated reporting processes with pivot tables, charts, and Excel VBA macros, reducing manual effort by 60% and enabling leadership to make quicker, more informed decisions.
  • Collaborated cross-functionally to gather reporting requirements and tailor analytics solutions for diverse client needs.
Capgemini

Senior Associate – Data Analytics

Capgemini · May 2022 – Apr 2024

  • Designed and developed interactive BI dashboards using Power BI and Tableau, enhancing visibility of key business KPIs for 50+ stakeholders across departments.
  • Analyzed and tested predictive models using Python (Scikit-learn) on healthcare datasets, achieving 85-90% accuracy in forecasting patient outcomes and improving service delivery.
  • Automated monthly and ad-hoc reports to support business units in strategic planning, reducing reporting turnaround time by 30%.
  • Gathered stakeholder requirements, translated complex business problems into analytical solutions, and delivered actionable recommendations.
  • Improved data processes and reporting pipelines, significantly increasing data accuracy and reducing manual effort across the team.

Senior Associate – Analytics

Online Apes Media · Oct 2020 – Mar 2022

  • Produced monthly digital marketing campaign performance reports, contributing to a 20% improvement in average client ROI through data-driven recommendations.
  • Developed client-facing dashboards and websites to visualize campaign performance, improving transparency and delivering actionable insights to US-based clients.
  • Strengthened client relationships by communicating analytical findings directly, improving client satisfaction and retention.
  • Acted as a bridge between technical teams and business stakeholders to ensure analytics solutions aligned with client expectations and business objectives.

Proof-of-Work

No completed sessions yet. Anything Pratham finishes shows up here with the evidence behind it.

Proof of Education

B.Sc. (Hons), Mathematics

UNIVERSITY OF DELHI · 2017 — 2020

A Proof CV — one profile, kept current, with the proof attached. Back to the portal