Siddhesh Dukare

Siddhesh Dukare

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

Power BI Developer / Data Analyst · Capgemini · 3.7 yrs

Ask about Siddhesh

Skills

Claimed

Problem SolvingRapid LearningBusiness AcumenData ExaminationAdaptabilityWork Planning and PrioritizationETL Pipeline DevelopmentData ExtractionImpact AnalysisRequirements AnalysisCross-Departmental CoordinationKPI Analysis

Proof of Experience

Capgemini

Power BI Developer / Data Analyst

Capgemini · Mar 2023 – Present

  • Built a Power BI App (Desktop + Service) with interactive dashboards, drill-through pages, and dynamic Row-Level Security (RLS) serving 200+ business users across procurement, operations, and finance - reducing manual reporting by 50%, saving 120 analyst-hours per month.
  • Designed pixel-perfect Paginated Reports (SSRS/RDL) using Power BI Report Builder for audit-ready, compliance-formatted enterprise documents, replacing a legacy SSRS stack and cutting report delivery time by 35%.
  • Engineered Delivery Excellence Dashboards and Metric Scorecards by building ETL pipelines in Power Query (M Language) and advanced DAX (CALCULATE, SUMX, Time Intelligence) - accelerating KPI turnaround from 2 days to 4 hours, enabling real-time monitoring of 15+ KPIs and improving leadership decision speed by 30%.
  • Optimised reports via DirectQuery and Composite Models (hybrid Import + DirectQuery) with query folding, aggregations, and connector tuning under Power BI Premium P1 - reducing average report load time by 40% and sustaining peak-load performance.
  • Improved semantic model performance by 45% using DAX Studio for query profiling and Tabular Editor for model management; deployed CI/CD pipelines via ALM Toolkit and Azure DevOps with Git version control.
  • Refactored SQL Server ETL views across finance and operations layers, eliminating redundant joins and applying early-stage filters cutting Import Mode refresh from 90 to 45 minutes and reducing refresh failure rate below 1%.
  • Managed and troubleshot On-Premises Data Gateways with incremental refresh strategies across procurement and HR datasets, resolving connectivity and access failures maintaining 99%+ refresh uptime across all enterprise datasets.
  • Led report governance for a 12-report suite spanning supply chain and finance: standardised RLS/OLS policies, naming conventions, and sensitivity labels; presented data stories and actionable insights to C-suite stakeholders driving a 20% improvement in operational decision speed.
  • Prototyped Microsoft Fabric (Dataflows Gen2, Semantic Link) and Power Platform (Power Automate) integrations as part of an internal BI modernisation initiative; produced a comparative findings report adopted by the team lead for the 2024 roadmap.
Capgemini

Associate Consultant

Capgemini · Apr 2026 – Jul 2026

  • • Reduced manual reporting effort by 50%, saving 120 analyst-hours per month, by building a full Power BI App with dynamic RLS, bookmark navigation, and drill-through pages for 200+ business users.
  • • Cut KPI reporting turnaround from 2 days to 4 hours by engineering Delivery Excellence Dashboards using advanced DAX (CALCULATE, SUMX, Time Intelligence) and Power Query, enabling real-time tracking of 15+ KPIs and improving leadership decision speed by 30%.
  • • Achieved a 45% reduction in enterprise dataset load time by optimising semantic models in DAX Studio and Tabular Editor, then deploying via ALM Toolkit CI/CD pipelines.
  • • Cut scheduled Import Mode refresh time from 90 to 45–55 minutes by refactoring SQL Server reporting views, removing redundant joins and applying early-stage date and status filters, reducing refresh failures and improving dataset reliability.
  • • Maintained 99%+ dataset refresh uptime by proactively monitoring and troubleshooting On-Premises Data Gateways - resolving connectivity, timeout, and role-based access failures before they affected business operations.
  • • Drove a 20% improvement in operational efficiency by translating complex C-suite requirements into Power BI dashboards and scorecards via Agile/Scrum sprints managed in Azure DevOps.
Capgemini

Senior Analyst

Capgemini · Oct 2024 – Mar 2026

  • • Eliminated last-minute formatting rework before audits by building pixel-perfect Paginated Reports (RDL) in Power BI Report Builder, meeting every compliance and print formatting requirement without manual intervention.
  • • Maintained 99%+ refresh uptime across enterprise datasets by monitoring and troubleshooting On-Premises Data Gateways, resolving connectivity, timeout, and role-based access failures through targeted incremental refresh strategies.
  • • Delivered audit-ready, pixel-perfect enterprise reports by building Paginated Reports (RDL) in Power BI Report Builder, meeting strict compliance formatting requirements across regulated business units.
  • • Kept report performance consistent under Power BI Premium P1 capacity by tuning DirectQuery connections to on-premises SQL Server, applying query folding, aggregation strategies, and cache settings for peak-load stability.
Capgemini

Analyst

Capgemini · Mar 2023 – Oct 2024

  • • Built the foundational enterprise Power BI reporting layer from scratch, designing dimensional data models (Star/Snowflake Schema), setting up scheduled refresh pipelines, and implementing Row-Level Security across multiple data sources.
  • • Strengthened report governance and compliance by classifying reports, enforcing naming conventions, assigning sensitivity labels, and implementing OLS, reducing security audit risk across the entire BI estate.
  • • Unified SQL Server, Excel, and on-premises gateway-connected systems into clean, trusted semantic models by integrating Power BI across multiple heterogeneous data sources, used daily by stakeholders across functional business areas.

Proof-of-Work

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

Proof of Education

B.E., Computer Engineering

Terna Engineering College, Mumbai University · 2018 — 2022

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