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.

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.

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.