Open to opportunities

Swapna Perumalla

@swapnaperumalla

Senior Power BI Developer at Frost National Bank who designed enterprise semantic models and optimized Power BI report performance.

United States

Message

At Frost National Bank, I architected Power BI semantic models using star-schema design and developed advanced DAX measures for complex analytical requirements. I also optimized models and reports using Power BI Performance Analyzer.

Across my work with Focus1 Insurance, Molina Healthcare, Office Depot, and First Horizon Bank, I developed Power BI reporting, SQL Server queries, and SSIS data flows. My experience includes Power Query transformations, data validation, and publishing and administering solutions in Power BI Service.

Experience

Work history, roles, and key accomplishments

Current

Sr. Power BI Developer

Current

Frost National Bank

Sep 2025 - Present (1 year 1 month)

Architected enterprise-level Power BI semantic models and developed advanced DAX measures for complex analytical requirements. Implemented time-intelligence calculations, optimized model performance, and administered Power BI Service solutions.

Power BI Desktop Power BI Service DAX Power Query Power Query M Language Data Modeling Star Schemas DataGateway Row level security Incremental Refresh Performance Analyzer Microsoft SQL Server T SQL Git

Power BI Developer

Focus1 Insurance

Jun 2024 - Aug 2025 (1 year 2 months)

Developed Power Query solutions to consolidate data from multiple sources and created reusable M functions for data transformation. Built interactive Power BI reports and configured scheduled refreshes and gateway connections.

Power BI Desktop Power BI Service Power Query Power Query M Language DAX Microsoft SQL Server T SQL DataGateway Data Modeling data transformation Data Profiling Data Validation Excel CSV

Power BI Developer

Molina Healthcare

Feb 2023 - May 2024 (1 year 3 months)

Developed SSIS packages for ETL processes and created SQL Server staging and reporting structures. Built Power BI data models and DAX measures, and performed end-to-end testing across processing layers.

Power BI Desktop Power BI Service DAX Power Query Microsoft SQL Server T SQL SSIS ETL OLEDB Dataflow Staging Tables Reporting Tables Data Validation Data Modeling

BI/SQL Developer

Office Depot

Mar 2021 - Jan 2023 (1 year 10 months)

Developed complex T-SQL queries and stored procedures for enterprise reporting, and created SQL-based ETL processes. Optimized query performance and assisted in migrating reports to Power BI.

Microsoft SQL Server T SQL SSRS Power Query Excel Pivot Tables Power Pivot Power BI Desktop DAX Power BI Service Data Reporting Data Validation

SQL Developer

First Horizon Bank

Aug 2018 - Feb 2021 (2 years 6 months)

Developed complex SQL Server/T-SQL queries and maintained stored procedures, views, and functions for reporting. Performed data validation and prepared analytical reports using Excel and SQL datasets.