BI Analyst PL300 Certified

Ekta Shah

Power BI Developer Data Analyst PL-*** Certified Microsoft Fabric

***********@*****.*** 704-***-**** linkedin.com/in/ekta-bharat-087895429 https://github.com/ektashahDataAnalysis Charlotte, NC (Remote / Hybrid / On-Site) P R O F E S S I ONAL S UMMARY

BI Analyst with 3.5+ years of experience delivering end-to-end BI and analytics solutions using Excel, SQL, DAX, Power Query, Power BI, and dimensional data modeling. Experienced in building enterprise and executive-facing dashboards, developing advanced DAX calculations, optimizing semantic models and report performance, and translating complex business requirements into scalable BI solutions that support KPI tracking and operational decision-making. Strong in writing complex T-SQL queries using CTEs, window functions, joins, aggregations, views, and subqueries to extract, transform, and analyze data from multiple enterprise sources. Experienced in collaborating with team members to integrate data from Excel, SQL Server, Azure SQL, Snowflake, APIs, and flat files into well-structured semantic models. Strong focus on performance optimization, data modeling best practices, and Power BI Service, including deployment across Dev/Test/Prod environments, security, refresh, and dataset management.

Recently Microsoft Certified: Power BI Data Analyst (PL-300), demonstrating current proficiency in Power BI, DAX, data modeling, Power Query, and modern BI reporting practices, with hands-on knowledge of Microsoft Fabric and enterprise BI architectures.

C O R E C OMPETENCIES

Power BI Desktop & Service Advanced DAX & Time

Intelligence

Semantic & Dimensional

Modeling

Stakeholder & Requirements

Management

Power Query (M Language) Row-Level Security &

Governance

Excel, T-SQL & Advanced SQL

Querying

Dev/Test/Prod Deployment &

Refresh

Microsoft Fabric — OneLake &

Direct Lake

Power BI Performance

Optimization

Data Validation &

Reconciliation

Tabular Editor & Calculation

Groups

T E C H N I C A L S K I L L S

BI & Reporting Power BI Desktop, Power BI Service, Power BI Report Server, Power BI Gateway, Paginated Reports, DAX Studio, Tabular Editor Databases MS SQL Server 2016/2018, Oracle, MySQL, PostgreSQL, Snowflake Cloud & ETL Azure SQL Database, Snowflake, Microsoft Fabric (One Lake, Direct Lake, Lakehouse, Medallion Architecture)

Languages DAX, T-SQL, PL/SQL, Azure SQL Power Query (M) DevOps & Tools Git, MS Excel, FTP

C E R T I F I C A T I ON

• Microsoft Certified: Power BI Data Analyst Associate (PL-300)

• Foundations in Generative AI [IBM] 2026

WORK E X P E R I E N C E

BI Analyst

Company: Brain Payroll

Jan 2019 – Jun 2022

Remote / Hybrid

Brain Payroll

Brain Payroll specializes in payroll automation, payroll processing, payroll reporting, advanced payroll solutions, pension management, and other financial services. Initially, I was part of the Professional Services team, where I delivered tailored BI analytics and reporting solutions for clients across the UK, Middle East, and India, translating business requirements into actionable insights and customized reporting solutions. Later I also worked as part of the Product Development team, where I developed intuitive dashboards and reporting solutions that provided stakeholders with real-time visibility into key business and operational metrics. These solutions supported data-driven decision-making and reporting requirements across different stakeholder groups within the organization.

• Partnered with business stakeholders to gather requirements, translate business needs into technical solutions, validate results, and deliver BI reports aligned with operational and management requirements.

• Delivered end-to-end BI solutions, including SQL and Excel data extraction, data transformation, data modeling, DAX development, dashboard/report design, testing, deployment, and ongoing support using Power BI, SQL Server, and Power Query.

• Applied analytical techniques to identify trends, patterns, anomalies, and key business drivers, translating findings into actionable insights and recommendations for stakeholders.

• Wrote T-SQL queries to extract, analyze, and transform relational data using CTEs, subqueries, joins, aggregations, CASE statements, views, and temporary tables for reporting and business analysis.

• Applied SQL window functions, including ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG, and SUM/COUNT OVER, for ranking, sequencing, period-over-period analysis, and running totals.

• Developed and maintained SQL views and reusable query logic to create reporting-ready datasets for Power BI dashboards and business reporting.

• Designed dimensional and semantic data models using star-schema principles, establishing appropriate relationships, granularity, and reusable datasets to support accurate reporting.

• Developed DAX measures for KPIs, time intelligence, year-over-year analysis, running totals, variance analysis, and dynamic calculations.

• Built interactive Power BI dashboards and reports using drill-downs, slicers, filters, KPI cards, charts, and detailed views to communicate business insights effectively.

• Developed Power BI dashboards and analytical reports for a Payroll & Accounting SaaS platform, covering SaaS revenue and customer metrics, payroll processing, customer retention and churn, product adoption, accounting performance, and support operations.

• Validated Power BI reports and dashboards against source data by reconciling totals, record counts, KPIs, and calculated values, identifying discrepancies and ensuring data accuracy and consistency.

• Improved Power BI report and semantic model performance by optimizing relationships, model structure, Power Query transformations, DAX calculations, and query performance. Used DAX Studio and Tabular Editor to analyze performance bottlenecks, optimize measures, and create calculation groups for reusable time-intelligence logic.

• Managed Power BI Service activities including report publishing, workspace and user access, On- premises Data Gateway configuration, scheduled and incremental refresh, dataset management, Row- Level Security (RLS), and deployment across Dev, Test, and Production environments.. Tech: Power BI Desktop & Service, Azure SQL, SQL Server, Snowflake, DAX, Power Query. E D U C A T I ON

Bachelor of Commerce with major in Accounting, Economics and Taxation Bombay University, INDIA

A D D I T I ONAL

• Investing time in Microsoft Fabric through formal training and self-driven project work — One Lake, Direct Lake, Lakehouse, and medallion architecture — to build a well-rounded Microsoft BI stack profile that goes beyond Power BI alone.

• Currently focused on enhancing my Claude AI skills for automation

• Green card holder

• Open to On-Site, Hybrid, and Remote opportunities

Contact this candidate