Keerthana P S P S

Power BI Developer

6+ yrs exp 90 · Outstanding

About

Power BI Developer with 6 years of overall IT experience and 5 years of relevant experience designing, developing, and deploying enterprise Business Intelligence solutions using Power BI Desktop, Power BI Service, SQL, and Azure. Skilled in dashboard development, data modelling (star and snowflake schema), DAX, Power Query, and ETL processes, with hands-on expertise in Power BI Report Builder, paginated reports, and SharePoint integration. Proven experience in performance optimization, query folding, incremental refresh, scheduled refresh, and Power BI Gateway configuration, along with Row-Level Security (RLS) implementation for secure reporting. Experienced in stakeholder management and Agile delivery across Healthcare and Retail domains, consistently translating business requirements into scalable, high-impact reporting solutions.

Skills & Expertise (34)

Power BI Service Advanced

8.5/10

Years Exp

DAX Advanced

8.5/10

Years Exp

Power BI Desktop Advanced

8.5/10

Years Exp

Data Transformation Advanced

8.0/10

Years Exp

Dashboard Development Advanced

8.0/10

Years Exp

Performance Optimization Advanced

8.0/10

Years Exp

Data Modelling Advanced

8.0/10

Years Exp

Power BI Report Builder Advanced

8.0/10

Years Exp

SQL Server Advanced

8.0/10

Years Exp

Power Query Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Paginated Reports Intermediate

7.5/10

Years Exp

Azure Intermediate

7.5/10

Years Exp

Star Schema Intermediate

7.5/10

Years Exp

Snowflake Schema Intermediate

7.5/10

Years Exp

Power BI Gateway Intermediate

7.5/10

Years Exp

ETL Intermediate

7.5/10

Years Exp

Cross-Functional Collaboration Intermediate

7.0/10

Years Exp

Requirements Gathering Intermediate

7.0/10

Years Exp

Stakeholder Management Intermediate

7.0/10

Years Exp

KPI Reporting Intermediate

7.0/10

Years Exp

Data Validation Intermediate

7.0/10

Years Exp

Report Publishing Intermediate

7.0/10

Years Exp

Deployment Intermediate

7.0/10

Years Exp

Agile Methodology Intermediate

7.0/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

Git Intermediate

6.5/10

Years Exp

Azure DevOps Intermediate

6.5/10

Years Exp

Power Automate Intermediate

6.5/10

Years Exp

SharePoint Intermediate

6.5/10

Years Exp

Snowflake Intermediate

6.0/10

Years Exp

Azure Data Factory Intermediate

6.0/10

Years Exp

Microsoft Office Intermediate

6.0/10

Years Exp

Power Apps Intermediate

6.0/10

Years Exp

Work Experience

Power BI Developer

Entrans Technologies Private Limited

Aug 2020 - Present

Designed and developed enterprise Power BI dashboards, KPI scorecards, and paginated reports to support business intelligence across Healthcare and Retail domains. Built optimized data models using star and snowflake schema methodologies to improve report performance and long-term maintainability. Developed complex SQL queries using CTEs, Subqueries, Temporary Tables, and Window Functions such as ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), and LAG() for data transformation and analysis. Created Recursive CTEs, Views, Stored Procedures, User-Defined Functions, and Dynamic SQL to support complex healthcare reporting and data processing requirements. Wrote optimized SQL queries, views, stored procedures, functions, and triggers to support large-scale enterprise reporting requirements. Implemented Row-Level Security (RLS) to enforce secure, role-based access to sensitive business and healthcare data. Configured scheduled refresh, incremental refresh, and Power BI Gateway connections to maintain up-to-date reporting environments. Applied query folding and performance optimization techniques to reduce dashboard load times and improve responsiveness. Built paginated reports using Power BI Report Builder to meet operational and compliance reporting requirements. Collaborated with cross-functional stakeholders in Agile environments, using Git and Azure DevOps for source control and deployment pipelines.