
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.

