Amit Kumar

Senior Power BI Developer and BI Team Leader with around 10 years of business intelligence experience, including 7+ years specialized in Power BI development. Leads a 4-analyst team delivering 40+ production dashboards for enterprise clients Bright speed and Virgin Media, with expertise spanning DAX optimization, semantic modelling, Row-Level Security (RLS), incremental refresh, on-premises gateway management, and Azure-integrated Microsoft Fabric capacity administration. Uses Claude AI to accelerate report development, DAX generation, and BI documentation — reducing delivery cycles and enabling AI-driven analytics across the team.

Team Leader, Business Intelligence & Reporting at Bill Gosling Outsourcing (BGO) (2022-03 – 2026-07)

• Lead a team of 4 Power BI analysts delivering end-to-end BI reporting for enterprise clients Bright speed and Virgin Media, owning the full pipeline from requirements gathering through dashboard publishing and stakeholder sign-off.
• Migrated legacy Power Query ETL workflows to Microsoft Fabric Dataflows Gen2 pipelines, cutting data refresh time by 40% and eliminating on-premises gateway bottlenecks across the production dashboard suite.
• Administered the team's Power BI workspace under Fabric F-SKU capacity (Azure-provisioned compute), reducing capacity costs by 30% through auto-scale scheduling and pause/resume controls while maintaining RLS and semantic model governance across 40+ dashboards.
• Established Azure DevOps-style deployment pipelines for Fabric artifact promotion across Dev/Test/Production environments.
• Applied Azure Data Factory concepts to orchestrate multi-source ETL workflows into the Fabric Lakehouse's
• Cut report load time from 8 seconds to 2 seconds (75% faster) by rebuilding DAX measures and restructuring the underlying semantic models.
• Implemented dynamic and static Row-Level Security (RLS) with role mapping tables and configured incremental refresh on high-volume datasets, eliminating full dataset refreshes and improving refresh reliability.
• Designed composite model dashboards using star and snowflake schema architecture, cutting manual reporting effort by 25% for operations and executive stakeholders.
• Built Power Automate workflows to eliminate recurring manual processes, reducing process execution time by 30% and freeing analysts to focus on BI development and data quality work.
• Managed access controls, semantic model versioning, and deployment pipelines across 40+ production reports; translated complex business requirements directly into scalable BI solutions.

Senior Analyst, Business Intelligence at R1 RCM Global India Pvt Ltd (2020-05 – 2022-03)

• Built Power BI dashboards for Healthcare Revenue Cycle Management (RCM) analytics using advanced DAX and semantic models, cutting executive reporting turnaround by 20% by replacing static Excel decks with live dashboards.
• Migrated 15+ legacy Excel-based reports to Power BI using Incremental Refresh and Direct Query, reducing reporting turnaround by 30% and providing real-time data visibility to senior stakeholders.
• Caught a 15% data discrepancy during the Power BI migration by auditing the ETL logic end-to-end and rebuilding the transformation layer in Power Query from scratch, stopping bad data before it reached executive reports.
• Configured Row-Level Security (RLS) in Power BI Service using Azure AD group assignments to enforce department-level data access controls, eliminating manual report slicing and improving data governance compliance.
• Automated recurring incentive calculation and cost reporting workflows in Power Query, eliminating 8+ hours of weekly manual processing and improving data accuracy by 15%.

MIS Analyst at DocPrime.com Pvt Ltd (2018-06 – 2020-02)

• Managed MIS reporting using Power Query and Advanced Excel for 5+ department heads, reducing data entry errors by 15% through enhanced validation logic and standardized data entry workflows.
• Replaced manual Excel reports with Power BI dashboards tracking key sales metrics, cutting monthly reporting preparation time by 20%.
• Analyzed weekly and monthly sales data using INDEX-MATCH, PivotTables, and VLOOKUP to deliver 10+ recurring business reports on time to senior management.

Professional Development & Family Business Operations at Family Retail Business (2017-04 – 2018-05)

• Managed day-to-day retail operations while pursuing Company Secretary (CS) qualification through structured professional exams and coursework.
• Completed multiple CS exam attempts and professional development coursework; determined that the exam-based credential path was not the optimal fit after thorough testing.
• This period of exploration clarified actual strengths and passion: data analytics and technology. Returned to corporate BI with renewed focus and commitment as a long-term career path.

Back-Office Executive, Insurance Domain at Absolute Surveyors & Loss Assessors Pvt Ltd (2015-08 – 2017-03)

• Processed 100+ insurance claims per month across multiple regions, consistently meeting SLA targets for accuracy and turnaround time.
• Built an Excel VBA claims tracking solution that improved data retrieval time by 20% and reduced manual record-search effort across the operations team.
• Collaborated with clients and insurers to validate claims accuracy, reducing processing discrepancies by 15%.

Bachelor of Commerce in B. Com – Delhi University (2014)