Kapil Thakur

Results-driven Data Engineer and Power BI Developer with over 4 years of experience designing scalable Data Warehouses using Data Modeling and Dimensional Modeling (Star & Snowflake Schema), building enterprise ETL pipelines, and delivering interactive Power BI solutions. Experienced in Microsoft Fabric, Azure Data Factory, SSIS, SQL Server, and Power BI, with expertise in Semantic Models, Composite Models, DirectQuery, Import Mode, Live Connection, Power BI Gateway, DAX optimization, Row-Level Security (RLS), Incremental Refresh, and report performance tuning. Skilled in Python, PySpark, Azure OpenAI, and LangChain to build AI-powered analytics solutions and enable natural-language insights.

Strong experience in translating business requirements into scalable, high-performance BI and analytics solutions.

Data Engineer - The Unified Cloud Pvt Ltd

(2022-04)

• Designed and developed 30+ enterprise Power BI dashboards using advanced DAX, KPIs, drill-through, bookmarks, and interactive visualizations for Finance, Retail, and Pharma clients.
• Designed Dimensional Data Models (Star Schema & Snowflake Schema) and Semantic Models to improve report scalability, maintainability, and performance.
• Built and optimized enterprise ETL pipelines using Microsoft Fabric, Azure Data Factory, SSIS, and SQL Server for ingesting data from multiple sources.
• Developed and optimized SQL queries, Stored Procedures, Views, and data transformation logic for high-volume datasets.
• Implemented Composite Models, DirectQuery, Import Mode, and Live Connection based on business and performance requirements.
• Configured and managed Power BI Gateway to enable secure scheduled refreshes for on-premises and cloud data sources.
• Built Fabric Notebooks using Python and PySpark for large-scale data transformation and cleansing.
• Implemented Row-Level Security (RLS), Incremental Refresh, Query Folding, and Performance Optimization to improve dashboard security and reduce refresh time.
• Developed reusable Data Models, DAX measures, calculated tables, and calculated columns to support enterprise reporting.
• Integrated AI-powered analytics using Azure OpenAI and LangChain to enable natural-language interaction with Power BI dashboards.
• Collaborated with business stakeholders to gather requirements, perform data analysis, and deliver scalable BI solutions

Intern - Tanvika Software Pvt Ltd

(2018 - 2018)

• Enhanced client-facing reports to align with user specifications, improving usability of data outputs.
• Leveraged Excel's advanced analytical functions to derive insights from large datasets.
• Developed intuitive Power BI dashboards to track KPIs across 200+ financial accounts.
• Collaborated within the team to champion customer satisfaction and process improvements.

MCA - Computers - Gautam Buddha University, Greater Noida (2022)

B.C.A. - Computer Applications (General) - Global Institute of Information Technology, Noida (2018)