Senior Power BI and BI Developer with 6+ Years Experience

Sravani Pabbu

Sr.Power BI Developer

210-***-**** **************@*****.***

Over 6+ years of extensive experience in database design, development, modeling, testing, deployment, and business intelligence using Microsoft SQL Server (2016/2014/2012/2008), Advanced SQL, SSIS, SSRS, SSAS, MSBI, and Power BI across Finance, Healthcare, Investment Banking, and Retail domains.

Proven expertise in designing and developing enterprise-level data warehouses and reporting solutions by collaborating with cross-functional teams, business users, and stakeholders to deliver accurate, high-performance, and scalable BI solutions.

Deep understanding of functional and technical requirements, data dictionary mapping, and ETL/data transformation logic, ensuring data consistency, reliability, and traceability across systems.

Strong experience interfacing with upstream and downstream systems to manage data extraction, transformation, analytics, and reporting for multiple business functions.

Advanced ETL development skills — hands-on in designing, optimizing, and implementing complex ETL processes and workflows using SSIS and Azure Data Factory.

Expert in designing and developing dynamic SSRS reports leveraging OLAP cubes, with deep experience in building tabular, matrix, drill-down, and distributed reports in multiple output formats (Excel, PDF, CSV, Web).

Skilled in creating visually compelling reports and dashboards by integrating advanced visualizations such as charts, gauges, KPIs, and maps in SSRS and Power BI to enhance decision-making insights.

Strong experience building robust SSIS packages that extract and transform data from multiple data sources (SQL Server, Oracle, Excel, Flat Files), implementing data cleansing, validation, and error-handling techniques.

Hands-on experience with Microsoft Azure ecosystem — proficient in Azure Data Factory, Azure Data Lake (ADL), Azure Data Warehouse (ADW), Azure Databricks, and PowerShell scripting for automating cloud resource management and data movement from on-premises to cloud environments.

Designed PolyBase external tables and T-SQL scripts to efficiently load data from Azure Data Lake into Azure Synapse Analytics (formerly ADW) for high-performance analytics.

Expertise in Azure Databricks for large-scale data transformation, cleansing, and aggregation across multiple file formats, enabling advanced data analytics and ML workflows.

Proven ability to design end-to-end ETL frameworks — from extraction to staging to warehouse loading — ensuring data integrity, scalability, and performance optimization.

Proficient in developing and automating SSIS solutions that include logging, error handling, scheduling (SQL Agent Jobs), email notifications, and audit trail mechanisms.

Advanced experience with SSAS, including cube design, partitioning, deployment, processing, and writing complex MDX queries for analytical reporting.

Skilled in data modeling (normalized and denormalized) and designing efficient database schemas to optimize reporting performance and storage utilization.

Proficient in Power Platform — developing interactive Power BI reports, Power Apps (Canvas and Model-driven), Power Automate flows, and integrating them with Azure, SharePoint, and Dataverse (CDS) for business automation and analytics.

Strong analytical and debugging abilities — experienced in unit testing, troubleshooting, and debugging SSIS packages, SSRS reports, and SSAS cubes.

Hands-on experience in database migration and upgrade projects, including migration from SQL Server 2008 to SQL Server 2012 and later versions.

Strong background in Azure Data Factory triggers, pipelines, and cloud migration strategies, including hybrid and full-cloud data migration scenarios.

Expert in T-SQL development — building complex stored procedures, triggers, UDFs, views, constraints, and indexes; extensive use of DDL/DML operations and performance tuning.

Proficient in SQL Server performance tuning using Query Analyzer, SQL Profiler, Execution Plans, DMVs, Index Tuning Wizard, and Performance Monitor to optimize query execution.

Thorough understanding of Software Development Life Cycle (SDLC) with practical experience in Agile, Scrum, Waterfall, and UML methodologies; skilled at sprint planning, requirement analysis, and project tracking.

Advanced proficiency in Power BI and SSRS — building complex dashboards, implementing drill-downs, hierarchies, parameters, and KPIs for interactive and data-driven insights.

Expertise in report optimization and tuning, including refining T-SQL and MDX queries, optimizing datasets, and improving performance for large-scale deployments.

Hands-on experience in Power Apps development and integration with BI solutions, enabling seamless automation and visualization across Microsoft’s Power Platform.

Adept at designing intuitive, visually rich Power BI and Tableau dashboards, transforming raw data into actionable intelligence and delivering business value.

Technical Skills

Programming Languages

C, C#, ASP.net, VB.net, Java, Python, SQL & PLSQL, Visual basic

Web Technologies

HTML, XML, JavaScript, AJAX, SOAP, Active X.

Database Environments

Oracle 11g/12c/18c, MS SQL Server 2008/2012/2016,MySQL, DB2 11.5.8 and MS Access

ETL Tools

SQL Server Integration Services (SSIS), and Informatica.

Reporting Tools

SSRS, Oracle Forms & Reports 6i/9i/10g, Crystal Reports 8.0, Tableau, Cognos and Power BI, MicroStrategy, Azure DataBricks, Microsoft PowerApps

Other Tools

Microsoft Visual Studio, Oracle 11g/18c/12c,, SSAS, MS SQL, SQL Developer, SQL Server Management Studio, Microsoft Azure, Eclipse IDE, QlikviewAngularJS 2.0, Pycharm, Risk Adjustment, Couchbase, MongoDB, Cassandra, Epic, Team Foundation Services TFS, Microsoft PowerApps

MS-Tools

MS-Visio, Outlook, Advance Excel, Word, and PowerPoint, MS TypeScript

Operating System

Windows NT/XP/Vista/7, Windows 95/98/2000/NT, Windows Server 2003/2008.

Version Control Tools

CVS, TFS, SVN, GIT

CommuniCare Health Services Mar 2023 to present

Sr.Power BI Developer

Gathering and analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.

Import data from different data sources to create Power BI reports and Dashboards.

Developed Reports, Charts, and dashboards using Power BI Desktop and manage security based on requirements.

Transform, define, navigate the data from data source and performed merge and append queries using Power Query.

Developed data capture and navigation desktop and mobile apps in Microsoft PowerApps that connect distribution center solutions design analytics in Power BI.

Developed several workflows with Power App forms and Power Automate workflows to simplify daily business processes.

Implemented complex query techniques of passing multi-Valued parameters and cascading parameters in MDX.

Created different chart types and drill down reports using Power BI Desktop.

Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI.

Published reports and visualizations to Power BI Service and thereby created dashboards.

Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.

Worked with both live and import data into Power BI for creating reports.

Developed data ETL using DAX and generated dashboards & reports for day to day distribution center performance monitoring.

Managed relationship between tables in Power BI using star schema.

Used different type of slicers available in Power BI for creating reports.

Used Power BI Gateways to keep the dashboards and reports up to date.

Developed several Details, Summary reports including line and pie charts, trend analysis reports and sub- reports per business requirements.

Used recently introduced Power BI to create self-service BI capabilities and use tabular models.

Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Shared the Power BI workspaces across the organization using Power BI Apps.

Worked on maintaining Row-Level Security (RLS) to securely deploy reports in Power BI service

Develop and deploy SSIS packages, configuration files, and scheduled jobs to run the packages to generate data in CSV files.

Troubleshooting reports issues, ETL job failures, optimizing query performances.

Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server.

Developed SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.

Developed and maintained complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.

Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment & Tools: Power BI (Desktop, Service, Gateway), Power Query, DAX, Power Automate, PowerApps, SQL Server, T-SQL, SSIS, SSRS, SSAS, SQL Server Agent, Visual Studio, Business Intelligence Development Studio (BIDS), Excel, CSV, Flat Files, MDX, Azure SQL Database, Star Schema Modeling

Banesco USA, Miami, Florida Dec 2021 to Mar 2023

Sr.Power BI Developer

Actively participated in Agile Scrum meetings, collaborating with cross-functional teams to resolve challenges and deliver project milestones on schedule.

Liaised with business users and IT teams to gather, analyze, and translate business requirements into scalable data models and reporting solutions.

Extracted and transformed data from multiple sources including SQL Server, Azure SQL Database, Azure Data Warehouse, Salesforce, and SSAS to support reporting and analytics.

Developed complex SQL queries, stored procedures, and CTEs to optimize report generation and streamline data retrieval from large datasets.

Built interactive Tableau dashboards and visualizations (heatmaps, tree maps, scatter plots, box plots, donut charts, highlight tables, word clouds, etc.) for executive-level insights.

Designed Tableau dashboards with advanced features such as parameters, hierarchies, context filters, and LOD Expressions for in-depth, dynamic analysis.

Published Tableau workbooks to Tableau Server, managing scheduled refreshes and access permissions for enterprise users.

Developed advanced Power BI dashboards using multiple visualizations (line charts, matrices, KPIs, cards, doughnut charts, scatter plots, etc.) to support real-time decision-making.

Applied advanced DAX (Data Analysis Expressions) to create calculated measures, KPIs, and time-intelligence metrics to support complex business logic.

Created and maintained Power BI workspaces, publishing and managing dashboards and datasets in Power BI Service.

Installed and configured Power BI Gateway to automate report refreshes and ensure data consistency between on-premise and cloud sources.

Integrated Power BI with Tableau, SSRS, and Python reports, consolidating analytics under a unified reporting framework.

Implemented data storytelling techniques in Power BI using bookmarks, drill-throughs, and selection panes to enhance interactivity and user experience.

Developed and optimized SSIS packages for ETL workflows, ensuring efficient data loading, transformation, and validation.

Monitored, debugged, and tuned SSIS packages to improve runtime performance and reliability.

Designed PowerPivot models and reports, deploying them to SharePoint and SSAS for enterprise data access and analysis.

Created SQL database maintenance logs, collaborating with database architects to track and address system-level performance issues.

Produced ad-hoc and scheduled financial reports (YTD, YOY, MTD, MOM) for performance analysis of revenue, cash flow, and operational metrics.

Evaluated investment returns and risk profiles across multiple asset classes (stocks, fixed-income, hedge funds, real estate, and commodities), contributing to portfolio optimization.

Developed analytical dashboards that provided real-time visibility into KPIs, operational efficiency, and business performance.

Environment: Microsoft SQL Server 2019/2016/2014, Azure SQL Database, Azure Data Warehouse (Synapse Analytics), Azure Data Factory, Azure Data Lake, SSIS, SSRS, SSAS, Power BI, Tableau Desktop & Tableau Server, Power BI Gateway, Power BI Service, PowerPivot, PowerApps, Power Automate, Python, Visual Studio, T-SQL, DAX

Arizona Department of Child Safety, Phoenix, AZ Nov 2020 to Dec 2021

Power BI Developer

Developed custom visual reports, dashboards, and KPI scorecards using Power BI Desktop, delivering actionable insights to stakeholders.

Designed and maintained interactive Tableau dashboards to visualize EPIC data, enabling leadership to monitor KPIs, performance metrics, and operational trends.

Connected to diverse data sources (SQL Data Warehouse, flat files, APIs) and performed data transformation, modeling, and cleansing using Power Query and Power BI DirectQuery.

Created DAX queries, calculated columns, and measures to implement complex business logic and data relationships.

Set up and administered Power BI environments, including App Workspaces, App Publishing, Power BI Gateway, and scheduled data refreshes for real-time reporting.

Automated identity and infrastructure management by creating Windows PowerShell and PowerCLI scripts, streamlining user provisioning and decommissioning.

Migrated legacy ETL and reporting processes to Azure Databricks and Azure Data Warehouse, leveraging T-SQL, PolyBase, and ADLS for data ingestion and performance optimization.

Developed ETL workflows using SSIS, integrating data from SQL Server, Salesforce, and Intacct to centralized reporting systems.

Implemented error handling and event handlers within SSIS packages to ensure robust data movement and automated process notifications.

Collaborated directly with business stakeholders (AZDCS) to gather, analyze, and translate reporting requirements into Power BI dashboards and proof-of-concepts (POCs).

Built data capture and navigation apps using Microsoft PowerApps, integrating with Power BI and SharePoint for real-time analytics in distribution center operations.

Designed automated approval workflows using Power Automate (Microsoft Flow), enabling dynamic status updates based on predefined business rules.

Optimized T-SQL queries and stored procedures, significantly improving execution performance for high-volume reporting.

Utilized SPARK Hive for data transformation and analysis based on ETL mappings for large-scale datasets.

Implemented version control for BI projects using Team Foundation Server (TFS) to manage and track Microsoft BI artifacts.

Worked on Azure Cloud deployments, provisioning new resources, managing resource groups, and supporting Azure IaaS BI platform migrations.

Participated in process mining initiatives using Celonis to identify automation opportunities and enhance data-driven operations.

Leveraged QlikView Server and Publisher for user access control, data refresh scheduling, and production dashboard support.

Environment & Tools: Power BI (Desktop, Service, Gateway), Tableau, SSIS, SQL Server, T-SQL, DAX, Power Query, Azure (Data Factory, Databricks, Data Warehouse, Data Lake Storage, Synapse), PowerApps, Power Automate, PowerShell, Python, Hive, Spark

VITAS Healthcare, Miramar, Florida Dec 2018 to Nov 2020

Power BI Developer

Migrated 60+ Cognos reports to SSRS and Power BI, improving report performance and visualization capabilities.

Designed a Power BI landing page for enhanced navigation, reducing clicks and allowing users to access multiple reports efficiently.

Developed Power BI dashboards and SSRS reports to track Medicare/Medicaid metrics, compliance, and operational KPIs.

Utilized SQL Server, DBT, and Advanced SQL to optimize pipelines and improve data accuracy and performance.

Created DAX measures and calculated columns in Power BI for advanced analytics and business insights.

Built ETL pipelines using SSIS and Informatica, integrating data from SQL Server, Salesforce, Intacct, and flat files.

Designed and implemented data models and star/snowflake schemas for scalable analytics solutions.

Developed and maintained Snowflake data warehouses and data lakes for enterprise-level analytics.

Set up and administered Power BI environments, including Gateways, App Workspaces, and scheduled refreshes.

Used Power Query for data transformation, cleansing, and modeling in Power BI.

Worked with Azure Data Warehouse (ADW) — used T-SQL and PolyBase for data ingestion from Azure Data Lake Storage (ADLS).

Performed T-SQL query tuning and optimization to improve report performance.

Created SSRS paginated reports and Power BI tabular reports for business stakeholders.

Implemented error handling and event handlers in SSIS packages, automating notifications and process tracking.

Experience with Oracle 11g/12c/18c, Teradata tools, and DB2 for enterprise data management.

Provided data validation and quality checks for EPIC data pipelines feeding Tableau and Power BI dashboards.

Used Alteryx for blending multi-source data, improving data preparation efficiency.

Supported PowerApps and Power Automate integration with SharePoint and Excel for workflow automation.

Worked on Azure cloud deployment, provisioning analytics resources and supporting POC migration from on-prem BI to Azure.

Hands-on experience with Snowflake, Azure, AWS, and modern data architecture for analytics delivery

Environment & Tools: Power BI (Desktop, Service, Gateway), SSRS, SSIS, Informatica, DBT, SQL Server, T-SQL, Advanced SQL, Oracle (11g/12c/18c), Teradata, DB2, Snowflake, Azure Data Warehouse (ADW), Azure Data Lake Storage (ADLS), Azure Synapse, Azure Data Factory, AWS, Alteryx, Power Query, DAX,

Education: Masters in cybersecurity operations from Webster university.

Contact this candidate