Senior Power BI & Data Analytics Specialist
Resume:
Sravani Pabbu
Sr. Data Analyst/Power BI Developer **************@*****.***
Sravani Pabbu Sr.Power BI Developer
210-***-**** **************@*****.***
PROFESSIONAL SUMMARY
6+ years of experience as a Data-Driven Analyst/Developer in designing and implementing applications utilizing Power BI, SQL server, and BI stacks.
Experienced in designing Power BI reports and dashboards from multiple data sources.
Skilled at using various Power Query, Power Pivot, and Power View to efficiently get, change, and show data.
Proficiency in managing workspaces, datasets, dataflows, and gateway configurations for security and performance in PowerBI.
Expertise in using SSIS Packages for transferring data from multiple data sources and integrating the data based on business logic.
Utilized Semantic Modeling tools to guarantee the precision and effectiveness of Business Intelligence semantic models.
Hands-on experience in Azure cloud technologies for data extraction and warehousing.
Experience in writing T-SQL Stored procedures, Triggers, Constraints, and Indexes using various DDL and DML commands.
Demonstrated expertise in providing Text Analytics, Data Modeling, and Data Mining solutions for business problems.
Conducted data analysis using statistical methods, hypothesis testing, and data visualization to extract valuable insights.
Propose architecture principles and models, and data flow required for various projects within the organization.
Generated dashboards with tools including ggplot, Matplotlib, Seaborn, Tableau, R Shiny, Power BI, and Apache Superset.
Strong experience in the Analysis, design, development, testing, and implementation of Business Intelligence solutions using Data Lake/Data Warehouse/Data Mart Design, ETL, ELT, OLAP, BI, Client/Server applications.
Expertise in Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations, teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL/ELT Design, development, System testing, Implementation, and production support.
Experience in importing and exporting data using Sqoop from HDFS to Relational Database systems and vice versa.
Expertise in working with relational databases such as Oracle 18c/11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, Sybase, SQL Server, Teradata, Jupyter notebook and PyCharm.
Worked on Agile methodology by adhering to standards and techniques and prepared code documentation, also documented the problems and provided solutions.
Very good communication skills, interpersonal skills and problem-solving skills, explore/adapt to new technologies with ease, and a good team member and highly motivated as an individual contributor with a strong work ethic contributing to the organization.
TECHNICAL SKILLS
Languages
Python, SQL, Spark
Visualization
Power BI, Tableau, Matplotlib, Seaborn
Libraries/ Frameworks
NumPy, Pandas, SciPy, sci-kit-learn
BI Tools
DAX, M Query, Power View, ETL processes, Microsoft Excel (Power Query, Power Pivot, VBA),
Database
Oracle 19c/18c/11g/10g/9i/8i, Microsoft SQL Server Management Studio 2008/2005, Sybase, HIVE, ORCL SQL Developer, T-SQL, SQL, Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis
Services (SSAS),
Cloud Technology
Azure, Azure Blob Storage, Azure HDInsight, ADF, dedicated SQL Pool, Azure Databricks, Azure Synapse Analytics, Azure Elastic, Azure Monitor, Azure
Purview, Azure Data Lake Storage Gen2, Azure SQL Database, Azure Functions
OLAP Tools
Jupyter notebook, PyCharm, Business Objects XI R2/6.x/5.x, Tableau, VS Code
Tools & Methodologies
Jira, Git, Bitbucket, PUTTY, Toad, Jupyter Notebook, PyCharm
WORK EXPERIENCE
Public Partnerships Limited (PPL), Louisville, KY Feb 2024 – Present Sr. Data Analyst (Power BI)
Responsibilities:
Designed and implemented scalable ETL pipelines using Azure Data Factory and Databricks to extract, cleanse, validate, and transform data from legacy systems into ADLS Gen2 for Salesforce migration.
Utilized PySpark and SQL for data cleaning, enrichment, deduplication, and schema validation to ensure high-quality, migration-ready datasets.
Developed and maintained metadata-driven control tables to parameterize pipeline behavior for both full and incremental loads across bronze, silver, and gold layers.
Created and optimized SSIS packages for intermediate transformation and movement of structured data from SQL Server to ADLS for lakehouse processing.
Leveraged SQL Server Management Studio (SSMS) for stored procedure development, validation query writing, and managing staging/migration environments.
Created Power BI dashboards and DAX measures to validate migrated data, highlight anomalies, and track transformation metrics for audit and compliance reporting.
Built custom audit logs and reconciliation reports to capture row-level transformation status, exceptions, and lineage across data pipelines.
Applied DAX and Power Query to develop reporting layers for operational insights and executive summaries of the data readiness and migration process.
Automated validation and exception tracking tasks using Python and integrated into pipeline checkpoints and reporting dashboards.
Worked closely with Salesforce developers and business analysts to align data mapping, field-level rules, and record validation logic.
Administered Azure services including Azure Data Factory, Azure Databricks, Azure Key Vault, and Azure SQL Database for pipeline orchestration, credential management, and storage optimization.
Performed record count validation, dimensional mapping, and join condition testing across multiple layers of the data lake and target Salesforce schema.
Participated in backlog grooming, story point estimation, and daily stand-ups as part of Agile sprint ceremonies to ensure delivery alignment.
Documented the entire ETL and migration flow with detailed lineage diagrams, transformation logic, and validation
results for audit trails and stakeholder reporting.
Provided cross-team support and mentorship on building reusable Power BI templates, control table configurations, and optimizing Python-based validation utilities.
Environment: Azure (Data Factory, Databricks, SQL Database, Data Lake Storage Gen2, Key Vault), Python (Pandas, NumPy, PySpark), Power BI, SQL Server, SSIS, SSMS, M Query, DAX, Git, Windows Server, MS Office Suite (Excel, Word, PowerPoint), Azure Monitor, Salesforce, Visual Studio Code.
BNP Paribas, Houston, TX Sep 2022 to Feb 2024
Sr. Power BI / Data Analyst Developer
Responsibilities:
Created Power BI data models and semantic business intelligence models for the intelligence reporting project.
Implemented a Star schema structure for the sales data, creating fact tables for transactions and dimension tables for products, customers, and time
Worked on SEC additional requirements for Asset Classes like Equity, Fixed incomes, and rate derivatives to define the requirements for swaps, OTC derivatives, reporting party logics.
Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts and implemented advanced ETL processes using SSIS.
Utilized MQuery for advanced data manipulation and transformation, Star schema structuring and transformations were used to improve the quality of the data.
Applied DAX and M Query for data modeling and transformation, enabling insightful business intelligence reporting.
Expanded Semantic BI models to incorporate data from unstructured sources such as social media, consumer feedback surveys, and other sources, going beyond historical warehouse modeling.
Implemented data processing pipelines and utilized Python libraries like Pandas and NumPy for data analysis, contributing to key insights and decision-making processes.
Performed data quality analysis using advanced SQL skills.
Worked on developing quantitative models using Excel and SQL to analyze Compliance and Regulatory requirements for trade surveillance of Equity products, equity derivatives and swaps, OTC and listed derivatives, fixed income products.
Performed Count Validation, Dimensional Analysis, and Data Quality Validation in Data Migration.
Tuned Spark memory consumption with respect to HDInsight cluster size, thus reducing the cost of processing.
Developed ETL python scripts for ingestion pipelines running on Azure infrastructure setup of HDInsight, Blob Storage, dedicated SQL Pool, and Azure Functions.
Developed SQL scripts and designed a solution to implement using Python.
Manage data coming from different sources including files, and RDBMS such as MSSQL Server, DB2, Oracle, etc.
Implemented PySpark scripts in Python to extract required data from the data sets and store it on HDFS.
Performed data cleansing, enrichment, mapping tasks, and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
Collaborated with DevOps Engineers to develop automated CI/CD and Test-driven development pipeline as per client standards.
Environment: Azure (HDInsight, Blob Storage, SQL Pool), Python (Pandas, NumPy, PySpark), Power BI, SQL Server, Spark, SSIS, M Query, DAX, Git, MS Office Suite (Excel, Word, PowerPoint). VBA), Git, Windows Server, MS Office Suite (Word, Excel, PowerPoint).
Gilead Sciences, Foster City, CA Mar 2020 to Jun 2022
Sr. Data Analytics Developer / Power BI Developer
Responsibilities:
Designed Power BI visualization solutions with documents for creating interactive dashboards.
Used Power View to create interactive scorecards to display the required information for departments.
Used MQuery and Power Query to transform and shape unstructured data into a format compatible with Power BI.
Involved in integrating consumer sentiment scores and sentiment data into the BI semantic model by leveraging Power BI functionalities.
Analyzed the quality of incoming data from several sources using Power BI's data profiling tools.
Used transformations to deal with missing values and duplicate entries while cleaning and improving the sales data.
Created relationships between budget tables, actual data, and supporting dimensions to enable ad hoc analysis.
Implemented various DAX functions for fact calculations and columns for efficient data visualization.
Designed and maintained Tableau reports based on business requirements.
Created mapping documents from source to target to ensure the data flow.
Done on data extraction, Transformation, and loading (ETL) data from various sources like Oracle, SQL Server flat files, and XML files using Informatica Power Center with various transformations like joiner, update strategy, router, SQL Transformation Unstructured data transformation.
Working with Azure Databricks and Azure Synapse Analytics as processing engines, Azure Elastic or Azure Monitor, Azure Purview, Azure Data Lake Storage Gen2, and Power BI as consumption layers.
Integrated Azure Container Instances with other Azure services such as Azure SQL Database and Azure Blob Storage for comprehensive data management and storage solutions.
Designed and implemented multiple Azure Functions for small ETL jobs (orchestrating using Logic Apps or Durable Functions) using Python programming language.
Designed and implemented Azure Logic Apps consisting of multiple Azure Functions, Azure Databricks jobs for data extraction, transformation, aggregation, and data loading to Azure Synapse Analytics.
Designed and implemented multiple data pipelines in Azure Data Factory, Azure HDInsight service using Apache Spark framework.
Created Azure Data Factory pipelines to arrive with data of user's consumption at Channel Level based on Income group, Race, Region etc. Used PySpark in Azure Databricks for defining pipeline functions to perform Data Ingestion, Cleansing, Partitioning, Transformation, Stitching and loading to Azure Synapse Analytics for further analysis and Report generation.
Implemented continuous compliance monitoring using Azure Monitor, Azure Activity Log, and Azure Policy to ensure adherence to financial regulations such as SOX and GDPR.
Environment: Power BI, Tableau, Azure Synapse Analytics, Azure Databricks, Azure Data Factory, PySpark, DAX, MQuery, Power Query, SQL Server, Oracle, Informatica Power Center, Azure Logic Apps, Apache Spark, Azure Monitor, Azure Purview, Azure Data Lake Storage Gen2
Lowe's, Mooresville, NC Mar 2019 to Mar 2020
ETL Analyst / BI Developer Responsibilities:
Utilized Microsoft SQL Server Management Studio 2008 to develop complex SQL queries, stored procedures, and functions for data manipulation and analysis.
Designed and implemented ETL (Extract, Transform, and Load) processes to integrate data from various sources into the central data warehouse.
Created and optimized database schemas, tables, and indexes to improve query performance and data retrieval efficiency.
Developed and maintained SQL Server Integration Services (SSIS) packages for automated data loading and transformation tasks.
Implemented data validation and cleansing procedures to ensure data quality and consistency across the organization.
Collaborated with business analysts and department managers to understand their reporting requirements and translate them into efficient SQL-based solutions.
Designed and developed interactive dashboards and reports using SQL Server Reporting Services (SSRS) to provide actionable insights to stakeholders.
Utilized SQL Server Analysis Services (SSAS) to create OLAP cubes for advanced business intelligence and data mining capabilities.
Implemented database backup and recovery strategies to ensure data integrity and minimize downtime.
Conducted performance tuning of SQL queries and database structures to optimize system performance.
Developed and maintained documentation for database schemas, ETL processes, and reporting solutions.
Collaborated with the IT team to integrate SQL-based solutions with other enterprise systems and data sources.
Leveraged advanced Microsoft Excel features, including Power Query and Power Pivot, to complement SQL-based analysis and reporting.
Created Excel-based interfaces for non-technical users to interact with SQL databases, combining the power of SQL with the familiarity of Excel.
Automated data export processes from SQL Server to Excel for further analysis and distribution to end-users.
Provided training and support to cross-functional teams on SQL querying basics and effective use of Excel for data analysis.
Implemented version control for SQL scripts and database objects using tools like Git to manage changes and collaborate effectively with team members.
Environment: Microsoft SQL Server Management Studio 2008, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL processes, Microsoft Excel (Power Query, Power Pivot, VBA), Git, Windows Server, MS Office Suite (Word, Excel, PowerPoint).
Contact this candidate