Karan Kathrani

Power BI Developer

Ahmedabad, Gujarat 2+ yrs exp 86 · Excellent

About

Results-driven Power BI Developer and Data Engineer with 2.5+ years of experience delivering end-to-end analytics solutions, interactive dashboards, and cloud-based data pipelines on Azure. Deep expertise in Power BI report and dashboard development (DAX, Power Query, Semantic Models), Microsoft Fabric Lakehouse architecture, and large-scale data transformation using Databricks and PySpark. Holds four Microsoft certifications (PL-300, DP-600, DP-700, AZ-900) and hands-on experience optimising Azure resource costs and automating API-driven data workflows across client environments.

Skills & Expertise (26)

Power BI Service Intermediate

7.5/10

2.5

Years Exp

DAX Intermediate

7.5/10

2.5

Years Exp

Power Query Intermediate

7.5/10

2.5

Years Exp

Power BI Desktop Intermediate

7.5/10

2.5

Years Exp

Semantic Models Intermediate

7.0/10

2.5

Years Exp

SQL Intermediate

7.0/10

2.5

Years Exp

ETL Intermediate

6.5/10

2.5

Years Exp

Python Intermediate

6.5/10

2.5

Years Exp

GitHub Actions Intermediate

5.5/10

2.5

Years Exp

Synapse Analytics Data Storytelling SCD Type 1 & 2 Star Schema ELT Lakehouse OneLake Medallion Architecture Azure Resource Management Databricks ADLS Gen2 Azure Data Factory ADF Spark Structured Streaming Delta Live Tables Apache Spark PySpark

Work Experience

Software Engineer – Power BI, Fabric & Databricks

atQor

Nov 2024 - Present

Developed Power BI reports and dashboards using DAX, Power Query, and optimised semantic models across 5+ client projects, replacing legacy Excel reporting with self-serve, real-time BI solutions. Built ADF pipelines to ingest data from REST APIs into ADLS Gen2; applied PySpark transformations in Databricks (Bronze-to-Silver cleansing via date functions, regex, aggregations) and loaded Parquet files into Gold warehouse – optimising Azure compute and resource costs end-to-end. Led Power BI to Microsoft Fabric migrations, transitioning datasets and dataflows into Fabric Lakehouses with DirectLake semantic models and Dataflows Gen2 using medallion architecture (Bronze/Silver/Gold) on OneLake. Designed star schema dimensional models in Fabric Warehouses, ensuring consistent KPIs, clean relationships, and report performance trusted and used independently by business stakeholders.

Data Analyst (Intern → Associate)

MagnusMinds IT Solution

Oct 2023 - Oct 2024

Built and published 10+ Power BI Desktop and Service reports translating raw SQL Server data into clear visual insights for sales, operations, and finance teams, reducing report turnaround time by 30%. Wrote advanced SQL queries (joins, CTEs, subqueries, stored procedures) and integrated Azure Data Factory to automate data ingestion workflows feeding BI pipelines. Applied Power Query (M) transformations and DAX to build reusable semantic models, improving report accuracy and enabling self-serve analytics without analyst intervention.