Swapna Perumalla

Experience

1. Sr. Power BI Developer

   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 DesktopPower BI ServiceDAXPower QueryPower Query M LanguageData ModelingStar SchemasDataGatewayRow level securityIncremental RefreshPerformance AnalyzerMicrosoft SQL ServerT SQLGit

2. Power BI Developer

   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 DesktopPower BI ServicePower QueryPower Query M LanguageDAXMicrosoft SQL ServerT SQLDataGatewayData Modelingdata transformationData ProfilingData ValidationExcelCSV

3. Power BI Developer

   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 DesktopPower BI ServiceDAXPower QueryMicrosoft SQL ServerT SQLSSISETLOLEDBDataflowStaging TablesReporting TablesData ValidationData Modeling

4. BI/SQL Developer

   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 ServerT SQLSSRSPower QueryExcelPivot TablesPower PivotPower BI DesktopDAXPower BI ServiceData ReportingData Validation

5. SQL Developer

   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.

   Microsoft SQL ServerT SQLStored ProceduresViewsSQL FunctionsCTEsTemporary TablesExcelPivot TablesSQL ReportingData ExtractionData ValidationPower BI