Back to Developers
lakshmanan krishnanan

lakshmanan krishnanan

Power BI Developer

Chennai, India 5+ yrs exp 90 · Outstanding

About

Results-driven Data Analyst and Power BI Developer with 5.4 years of experience delivering end-to-end BI solutions on Microsoft Fabric — Lakehouse, Warehouse, OneLake, and Data Factory pipelines. Skilled in building high-performing Power BI semantic models using Star Schema and enterprise DAX measures, connected directly to Fabric architecture for stakeholders across Healthcare, Logistics, and Retail domains. Proficient in data ingestion pipelines, Dataflows Gen2, and data transformations within the Fabric ecosystem, alongside advanced T-SQL, Power Query (M Language), and Power BI Paginated Reports (RDL). Experienced in DAX/Fabric performance tuning, Row-Level Security (RLS), workspace governance, and deployment pipelines across environments. Adept at translating business requirements into technical specifications and interactive visual designs that drive strategic decision-making.

Skills & Expertise (63)

Power BI Desktop Advanced
9.0/10
5
Years Exp
DAX functions Advanced
8.5/10
5
Years Exp
Data Visualization Advanced
8.5/10
5
Years Exp
Power BI Service Advanced
8.5/10
5
Years Exp
SQL Server Advanced
8.0/10
5
Years Exp
ETL Process Advanced
8.0/10
5
Years Exp
Power Query Advanced
8.0/10
5
Years Exp
Data Warehousing Advanced
8.0/10
5
Years Exp
Azure Data Factory Advanced
8.0/10
5
Years Exp
Azure Databricks Intermediate
7.5/10
5
Years Exp
Snowflake Intermediate
7.0/10
5
Years Exp
Views Healthcare Analytics Retail Analytics ELT Data Pipeline Data Cleansing Data Transformation Data Validation Synapse Row-Level Security Deployment Pipelines Scheduled Refresh App Deployment Logistics Analytics Business Intelligence Data Analytics Sales Analytics KPI Dashboards Interactive Reports Drill-through Slicers Bookmarks Tooltips Microsoft Excel Salesforce DAX measures OneLake Lakehouse Warehouse SharePoint Power BI Report Server Power BI Gateway Power BI Mobile Power BI Report Builder Paginated Reports Star Schema Snowflake Schema Fact & Dimension tables OLAP Dynamic SQL DAX Optimization Calculated Columns KPIs T-SQL Joins CTEs Window Functions Stored Procedures Microsoft Fabric Indexing Query Optimization Execution Plan Analysis

Work Experience

Data Analyst / Power BI Developer

Tiger Analytics

Jul 2023 - Present

Designed and implemented BI solutions on Microsoft Fabric — Lakehouse, Warehouse, and Dataflows Gen2 — building enterprise Power BI semantic models using Star Schema (Fact & Dimension tables) with advanced DAX measures and KPIs for Healthcare and Sales domains, driving data-driven decision-making. Developed Power BI Paginated Reports (RDL) using Power BI Report Builder for print-ready healthcare claims and patient statements, complementing interactive dashboards with fixed-layout, exportable reporting. Wrote and optimized complex T-SQL — including CTEs, window functions, and stored procedures — to extract, cleanse, and prepare source data from SQL Server prior to modeling in Power BI, improving data reliability for downstream reporting. Built end-to-end ETL/ELT data pipelines integrating data from SQL Server, Azure Databricks, SharePoint, Excel files, and Azure Data Factory using Power Query (M Language) and Dataflows Gen2 within the Fabric ecosystem. Designed and orchestrated Azure Data Factory and Fabric Data Factory pipelines using Copy Activity and Data Flows, applying parameterization for dynamic, reusable pipelines integrated with Azure SQL and Synapse. Developed advanced DAX measures including Claim Approval Rate, Denial %, Patient Visits, Provider Performance, Cost per Claim, Total Sales, Total Orders, AOV, Sales Growth %, Profit Margin, and Customer Retention Rate. Implemented Row-Level Security (RLS) and workspace governance policies ensuring data confidentiality and role-based access control across all Power BI reports and dashboards. Published reports to Power BI Service, configured On-Premises and Cloud Gateways, and managed scheduled refresh cycles and deployment pipelines to ensure real-time data availability for business stakeholders. Collaborated with data engineering teams, business analysts, and stakeholders to gather business requirements, validate data models, and deliver actionable business intelligence dashboards. Optimized Power BI report and Fabric capacity performance using DAX optimization techniques, data model compression, query folding in Power Query, and the Power BI Performance Analyzer.

Power BI Developer

Bizturn Technologies

Sep 2020 - Jan 2023

Developed interactive Power BI dashboards and analytical reports for Logistics and Healthcare domains, enabling real-time operational KPI monitoring for clients including Tri-Star's Logistics and MediQ. Designed star schema data models with Fact and Dimension tables; integrated data from SQL Server, Salesforce, Transportation Management Systems (TMS), and healthcare operational systems. Wrote complex SQL queries — joins, correlated and non-correlated subqueries, CTEs, window functions, stored procedures, and views — to extract, cleanse, and transform data for BI reporting; tuned queries using execution plan analysis and targeted indexing to reduce report load times. Created DAX measures and KPIs such as On-Time Delivery %, Total Shipments, Warehouse Utilization Rate, patient analytics KPIs, and claims analysis metrics using DAX functions and Power Query. Built dynamic, interactive reports with drill-through, drill-down, slicers, tooltips, bookmarks, and KPI visuals to enhance user experience and business insights. Published and managed reports in Power BI Service with scheduled refresh, Row-Level Security (RLS), workspace security, app deployment, and On-Premises Gateway configuration. Optimized report performance using DAX tuning, data model optimization, and Power BI Performance Analyzer, reducing report load times and improving end-user experience.

Education

Bachelor of Computer Applications (BCA) - Hindustan College of Arts & Science

2009 - 2012 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 90/100

Profile Overview

Member sinceSep 2026