Siddhesh Dukare
Contact details — on requestProof of Work — on request
Experience
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.
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.
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.
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.
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