SUNIL KUMAR TAK

• Defined enterprise data strategy, architecture roadmap, and scalable cloud platforms on Microsoft Fabric and Azure.
• Designed end-to-end Microsoft Fabric solutions with OneLake, lakehouse, warehouse, pipelines, notebooks, and medallion tiers.
• Architected scalable ETL/ELT frameworks with incremental ingestion and transformations using PySpark, Spark SQL, and T-SQL.
• Designed enterprise semantic models with Power BI using direct lake, DAX tuning, and governed RLS/OLS.
• Led migration from legacy platforms SSIS, SSAS, Tableau, and Qlik to Microsoft Fabric and Power BI.
• Established enterprise data governance with RBAC, lineage, security controls, compliance, and access management frameworks.
• Managed Fabric capacity, workload optimisation, resource utilisation, and platform cost efficiency.
• Enabled Copilot Fabric, IQ, data agents, Databricks Genie, and conversational analytics via AI-ready platforms.
• Established CI/CD with Git integration, deployment pipelines, environment management, and monitoring frameworks.
• Led architecture reviews, mentored engineering teams, and coordinated technical decisions with business stakeholders.

Design scalable enterprise Power BI architecture for reporting and analytics platforms.

Design optimised star schema enterprise semantic models with clear data relationships.

Lead interactive dashboard development, report authoring, paginated reports, advanced visualisations.

Optimise complex DAX and Power Query models to improve report refresh performance.

Integrate data from SQL Server, Azure Data Warehouses, APIs, SSIS, SSAS, and systems.

Implement RLS and OLS with workspace security, access management, and governance standards.

Manage Power BI Service workspaces, gateways, deployment pipelines, capacities, tenant settings.

Lead migrations from Tableau, Qlik, and legacy BI platforms into Power BI.

Define development standards, run architecture reviews, and mentor BI teams.

• Translate business requirements into BI solutions and define technical roadmaps.

• Client: Becton, Dickinson & Company (USA)
• Led offshore BI development team.
• Designed data warehouse and SSIS pipelines.
• Delivered enterprise Power BI dashboards with advanced DAX and security.