PD

Pratham Dhir

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

Work style

on-site

Availability

Available in 30 days

Contact details — on requestProof of Work — on request

Experience

P

Data Analyst

Publicis Groupe · Aug 2025 – Present

Not yet confirmed
  • 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.
A

Data Specialist

Anaqua · Apr 2024 – Aug 2025

Not yet confirmed
  • 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

Not yet confirmed
  • 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.
O

Senior Associate – Analytics

Online Apes Media · Oct 2020 – Mar 2022

Not yet confirmed
  • 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.

Skills 0 proven through work

Also works with

Dashboard PublishingParameter CreationContent Taxonomy StructuringSoftware Quality AssuranceData MonitoringDatabricks UsageData ValidationReceiving and Incorporating FeedbackDefect TrackingMeeting FacilitationWork Planning and PrioritizationRequirements AnalysisJira UsageGenerative AI ApplicationTime ManagementRequirements Definition for SourcingCustomer Relationship BuildingData Integrity ManagementProcess ImprovementReal-Time Dashboard DevelopmentData PreprocessingTabular Data Cleaning & Validationpandas UsageUI Implementation from DesignStar Schema DesignData ModelingData TransformationData-Driven RecommendationsInformation DisseminationProblem SolvingExploratory Data Analysis (EDA)Data StorytellingAnalytical Report CreationKPI AnalysisDashboard UI DesignAgile MethodologyUser Story WritingUAT Sign-offStakeholder ManagementETL Pipeline DevelopmentAlteryx UsagePython DevelopmentData VisualizationTableauPower BIData ExtractionQuery Writing

Proof of Work

Proof of Work

Pratham shares this with people who ask. You'll hear back either way.

Education

B.Sc. (Hons), Mathematics

UNIVERSITY OF DELHI · 2017 — 2020

Contact details

Contact details

Pratham shares this with people who ask. You'll hear back either way.

Ask about this candidate

AI responses may contain errors. Proof status and source information are provided by Proof of Skill.

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