Ekta Shah

Power BI Developer / BI Analyst with 3.5+ years of experience delivering end-to-end BI and analytics solutions using Power BI, SQL, DAX, Power Query, 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 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 governance, 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.

Currently preparing for Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) to further strengthen expertise in modern Fabric-based analytics and semantic modeling.

Power BI Developer - Brain Payroll - Remote / Hybrid

(2019-01 - 2022-06)

Brain Payroll specializes in Payroll Automation, payroll processing, payroll reporting, advanced payroll solutions, pension management and other financial services. Initially was part of the professional services team working on providing tailored BI analytics and reporting solutions to clients in UK, Middle East and India. Later worked as part of the Product Development team, where contributed to the BI team developing intuitive dashboards to provide real-time insights for different stakeholder groups within the organization.

• Worked 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 data extraction, transformation, data modeling, DAX development, dashboard/report design, testing, deployment, and ongoing support using Power BI, SQL Server, and Power Query.
• Wrote complex T-SQL queries to extract, analyze, and transform data from relational databases using CTEs, subqueries, joins, aggregations, CASE statements, views, and temporary tables to support reporting and business analysis.
• Applied SQL window functions, including ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG, and SUM/COUNT OVER, to perform ranking, sequencing, period-over-period analysis, running totals, and advanced analytical calculations.
• Developed and maintained SQL views and reusable query logic to create reporting-ready datasets and simplify data consumption for Power BI dashboards and business reporting.
• Designed and developed dimensional and semantic data models using star-schema principles, establishing appropriate relationships, granularity, and reusable datasets to support accurate Power BI reporting.
• Developed DAX measures for KPIs, time intelligence, year-over-year analysis, running totals, variance analysis, dynamic calculations, and complex business requirements.
• Built interactive Power BI dashboards and reports with drill-downs, slicers, filters, KPI cards, charts, and detailed views to translate business requirements into actionable insights.
• 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 to provide actionable insights for business and operational decision-making.
• 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 across reports.
• Improved Power BI report and dataset performance by optimizing data models, calculated logic, Power Query transformations, and DAX calculations.
• Optimized Power BI semantic models by improving relationships, DAX measures, model structure, and query performance; used DAX Studio and Tabular Editor to analyze performance bottlenecks, create calculation groups for reusable time-intelligence and calculation logic, optimize measures, and validate Power BI best practices.
• Managed Power BI Service activities including report publishing, workspace and user access, On-premises Data Gateway installation and configuration, scheduled and incremental refresh, dataset management, and deployment across Dev, Test, and Production environments.

Bachelor of Commerce - Accounting, Economics and Taxation - Bombay University