Siddhesh Dukare

Siddhesh Dukare

Contact details — on requestProof of Work — on request

Experience

Capgemini

Power BI Developer / Data Analyst

Capgemini · Mar 2023 – Present

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

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

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

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

Skills 0 proven through work

Also works with

Problem SolvingRapid LearningBusiness AcumenData ExaminationAdaptabilityWork Planning and PrioritizationETL Pipeline DevelopmentData ExtractionImpact AnalysisRequirements AnalysisCross-Departmental CoordinationKPI AnalysisAutomated Report GenerationBusiness IntelligenceData ModelingDashboard UI DesignMicrosoft Fabric UsageQuery WritingDAX Expression DevelopmentPower BI

Proof of Work

Proof of Work

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

Education

B.E., Computer Engineering

Terna Engineering College, Mumbai University · 2018 — 2022

Contact details

Contact details

Siddhesh 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