Bhagya Sree Vanaganti

Bhagya.vanaganti@gmail.com
Contact: 4437902528
Data Analyst

Professional Summary:
 Around 7 years of experience in Information technology, specializing in Data Analysis, Software Quality
Assurance, Testing and Development experience in developing Business Intelligence Solutions using Power BI,
SQL Server.
 Experience with data analysis, data modeling and data presentation and importing data from SQL Server,
Snowflake, Oracle DB, and API to Power BI to generate reports.
 Well-versed in agile methodology, with extensive experience in Microsoft tools such as Power BI, Sharepoint,
Power Apps, Power Automate, and Visual Studio Services.
 Strong Background in Business Intelligence tools, particularly Snowflake and Power BI, for creating reports,
dashboards, and visualizations across various Power BI platforms.
 Proficient in Power BI Desktop for connecting with diverse data sources, importing, and modeling data for
Business Intelligence purposes.
 Strong knowledge of Power BI administration and installation of Gateways in Power BI and experience in
automatic schedule refresh, and deployment pipelines in Power BI service.
 A practical grasp of relational and dimensional data modeling concepts, such as fact and dimension tables, star
and snowflake schema modeling, and dimensional modeling.
 Proficiency in optimizing data warehouse databases and analytics dashboards and reports, as well as in debugging
and performance tuning.
 Capable of developing custom visualizations in Power BI using Python libraries to represent data in unique and
informative ways.
 Good knowledge on python-based environment, along with data analytics, data wrangling, and excel data extracts
and familiar with NumPy, Pandas, Matplotlib, SciPy, and ggplot2.
 Experience in Power BI to design Interactive Reports using Power Query, Power Pivot and Power View.
 Excellent knowledge on Power Query Parameters, Query Lists, Tables, Records and having expertise in
Cleansing and Transforming data with Power Query Editor.
 Used Power BI, power pivot to develop data analysis prototype, and used Power View and power map to
visualize reports.
 Developed dashboard visualizations and complex reports, which involves custom controls and custom expressions
using bars, lines and pies, maps, scatter plots.
 Hands-on experience in utilizing DAX functions and measures and implemented several DAX functions, which
includes Aggregation, Counting, Logical and date functions for efficient data visualization.
 Published Power BI reports from Power BI desktop to Power BI service in the required organizations and made
Power BI dashboards available in web clients and scheduled automatic refresh in Power BI Service.
 Excellent understanding of Business workflow processes, Software Development Life Cycle (SDLC)
methodologies (Agile/Scrum, Waterfall, and V-Model) and industry standard Quality Assurance practices.
 Proficient in Agile Scrum responsibilities include - Sprint tracking, Planning, Grooming user stories, Feature
delivery, and Product demo.
 Responsibilities handled include Status reporting, systems study, analysis, test design, manual and automated
testing, defect tracking, analysis of defects, interaction with business and system owners and post implementation
maintenance.
 Extensively worked in Manual Testing. Performed different types of Testing like Black Box, White Box,
Integration, System, Compatibility, UAT, Ad-Hoc, and Regression testing.
 Expertise in Manual and automated testing using HP ALM/ Quality Center, Quick Test Professional (QTP),
Selenium Web Driver.
 Performed backend testing and has very good knowledge of writing and executing SQL queries to verify the data.
 Possess excellent oral, written communication skills and pleasing interpersonal skills. Experience in Power BI to
design Interactive Reports using Power Query, Power Pivot and Power View.
 Ability to Quickly Master new concepts and applications and to support multiple projects under Tight Deadlines
 often with competing priorities and complexities.

Certifications:
 Microsoft Certified Power BI Data Analyst

Technical Skills:
Business Intelligence Tools: Power BI, Tableau
Languages: XML, SQL, PL/SQL, Python (Basic), DAX
Databases: RDBMS- Oracle, MySQL, SQL Server, NoSQL- MongoDB
Data Analytical Tools: Excel, SSAS, DAX, SQL Server, Snowflake
Other Skills: Data Cleaning, Data Wrangling, Alteryx, Critical Thinking, Data Mining, Presentation
Skills, Communication Skills, Problem- Solving, Requirement Gathering, Backlog
Grooming, Sprint Planning, Business Data Warehousing, Data Validation, Data Modeling
Other: Visual Studio Code, PyCharm, MS Office, WinSCP and Putty
Operating System: RedHat Linux, Solaris Unix, Windows

Professional Experience:

Client: T-Mobile, Bellevue, WA December 2023 to Present

Role: Sr. Power BI Data Analyst
Responsibilities:
 Performed testing activities on both the customer application (CB), and customer management application (SAM),
Tested the reports, and audits in CB and SAM. Analyzed the test results and raised defects if required.
 Assisted in data collection, cleansing, and validation for business system data. Build Reusable Data Ingestion and
Data Transformation frameworks using python.
 Responsible for creating design documents, establish specific solutions, creating test cases. Conducted A/B testing
and statistical analysis to optimize marketing campaigns, resulting in a 10 % revenue increase over the quarter.
 Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
 Worked on all type of transformations those are available in power bi query editor.
 Wrote DAX expressions to create new measures, calculations per business requirements.
 Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
 Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
 Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and
dashboards.
 Performed Data wrangling (missing values, Null, formats) on raw datasets to convert them into meaningful datasets
for analysis. Act as liaison between business and development teams communicating project status and issues
regarding development and implementation.
 Used advanced SQL queries for analysis and research for specific requirements and solutions. Documented functional
requirements as outlined by business in Jira as Epic and user stories.
 Extensively used Python in-built libraries Sckit-Learn, seaborn, matplotlib, numpy, and pandas’ libraries for data-
preprocessing. Presented data and analysis in a clear and concise manner for making informed decisions on accurate
information, effective communication, user-centric design, and alignment with business Objective goals.
 Used various sources to pull data into Power BI such as SQL Server, excel, cloud, SQL Azure, etc.
 Created Power BI Visualizations and Dashboards as per the requirements.
 Wrote DAX Expressions, Power Query, Functions in Power BI.
 Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
 Extensively worked with reusable and multiple actions and created manual test scripts and maintained these scripts
through QC. Tested the payments module which handles the payments processed through the system and verified the
import/export files to follow the industry standards (NACHA).
 Generated Traceability Matrices to ensure that all the requirements are covered by the test cases. Involved in User
Acceptance Testing (UAT) and end to end testing. Created and executed test cases for UAT.
 Coordinated with the offshore development team on defect status on regular basis to track the defects for closure.
Performed Regression testing on Front End GUI screens by using Selenium Web Driver and generated reports using
 TestNG. Wrote different SQL queries to access data from different database tables and used for data verification.
 Generated Traceability Matrices to ensure that all the requirements are covered by the test cases. Involved in testing
the database for batch jobs, interactions with external systems, and data processing. Evaluate business requirements
and involved in resource management.

Environment: Selenium, Quality Center 10.0, DB2, SQL, VBScript, Load Runner, XML, HTML, DHTML, Windows,
Power BI Desktop, Power BI Service, Power BI Data Gateway, MS Office Tools, Swift, Trading Systems, iMarks, DWH,
GPP.

Client: Lab Corp, Atlanta, GA. December 2022 to November 2023

Role: Power BI Analyst
Responsibilities:
 Development and Creation of Complex Stored Procedures, Triggers and Functions.
 Fine-tuning Stored Procedures to improve the performance by removing the unnecessary cursors.
 Management of T-SQL Views, Cursors, Index statistics, Tables and query optimization using execution plan for
tuning the database.
 Always ensured to eliminate NULL and Blank values on the Dashboards/Reports for the best end user experience
 Conducted complicated calculation to develop KPI reports/dashboards according to clients' requirement.
 Scheduled the Dashboard’s at regular intervals to make sure data refresh is up to date.
 Generated periodic reports based on the statistical analysis of the data from various time frames and
division using Power Pivot, Power Query, Power View and Power BI.
 Continued maintenance and development of bug fixes for the existing and new power Bi reports.
 Developed calculated columns and measures using DAX in Power BI.
 Created and customized simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes
and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.
 Managed project insights through Azure DevOps to track the list of assignments and provided daily updates.
 Worked on-premises gateway to refresh the data sources & creating a live connection with tabular /Multi-
dimensional Model SSAS.
 Loaded Data from SFTP/on Prim Data through Azure Data factory to Azure SQL Database and automize
the pipeline schedules using Event based Scheduling in Azure Data Factory (ADF).
 Implemented Row-level security (RLS) with Power BI Reports.
 Published Power BI Reports in the required originations and Made Power BI Dashboards available in
Web clients.
 Used Power BI Gateways to keep the dashboards and reports up to date.
 Developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last
year.
 Designed SSIS packages to import and transform data between databases and external data sources using various
transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination,
OLE DB Command, Merge Join, Look up, Sort, Data flow task.

Environment: MS SQL Server 2016/17, Visual Studio, SSIS, SSRS, Power BI, ADF, Data Flow, Python, SQL Server
Management Studio (SSMS), T-SQL, SQL profiler.

Client: Integrity Spirit, Bangalore, India. August 2019 to November 2021

Role: Data Analyst
Responsibilities:
 Implemented Agile Methodology for building an internal application, ensuring efficient project management
and iterative development.
 Conducted exploratory data analysis, quick analytic prototyping, and creative concept presentation to exploit
data and produce deeper insights.
 Worked on ETL processes by extracting large volumes of data from various sources using Alteryx.
 Expert in generating on-demand and scheduled reports in Alteryx for business analysis and management
decision- making.
  Utilized Pandas, NumPy, Matplotlib, and ggplot2 in Python for developing data pipelines and various
machine learning algorithms.
 Generated graphs and reports using ggplot2 package in R-Studio for analytical models.
 Developed and maintained Tableau dashboards to significantly reduce monitoring and reporting time.
 Improved efficiency and accuracy by evaluating models in Python and R.
 Designed and developed a Tableau accelerator using REST APIs and Python.
 Built Tableau dashboards to visualize core business KPIs, saving considerable manual reporting work.
 Assisted with automating reporting functionality using Power BI.
 Used Python and SQL to manipulate data, construct data models, and validate them.
 Performed data validation and reconciliation post-mapping to ensure data integrity and identify discrepancies.
 Implemented row-level security in Power BI using DAX to ensure data privacy and compliance
with organizational security policies.
 Worked on Power BI extraction, transformation, and loading (ETL) data for report generation.
 Performed data cleansing and preparation by slicing and dicing data using SQL and Excel.
 Created database objects (tables, views, procedures) using MySQL to provide structure and maintain
data efficiently.
 Redesigned data models through iterations, improving predictions by 12%.
 Built machine learning models on datasets using both R and Python.
 Performed data analysis and data profiling using complex SQL queries on various source systems, including
SQL Server.
 Used Python to graphically critique datasets and obtain insights.
 Performed data cleaning, feature scaling, and feature engineering using pandas and NumPy packages in Python.
 Built models using deep learning frameworks.
 Understand the data visualization requirements from business users.
 Wrote SQL queries to extract data from sales data marts as per requirements.
 Created source-to-target data mappings for individual reports.
 Created pivot tables in Excel to analyze data across several dimensions.
Environment: MS SQL Server 2016/17, Visual Studio, SSIS, SSRS, Power BI, Tableau, ADF, Data Flow, Python, SQL
Server Management Studio (SSMS), T-SQL, SQL profiler.

Client: Integrity Spirit, Hyderabad, India August 2016 to July 2019

Role - BI Reporting Consultant/Data Analyst
Responsibilities:
 Created and modified various complex Stored Procedures used in the application using T-SQL.
 Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous
and heterogeneous information sources (Flat files, Excel, Oracle DB2, and SQL Server).
 Worked on Azure Cloud involving migration from On-Premises to Azure.
 Responsible for programming, testing, debugging, and documenting simple to moderately complex
ETL applications (SSIS) under direct supervision.
 Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
 Performed Loading operation of historical data using full load and incremental load into Enterprise
Data Warehouse.
 Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup,
Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension,
Merge Join and Union all.
 Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular
reports, Matrix reports and linked reports using SSRS.
 Created different Parameterized Reports like standard parameter reports, Cascading Parameterized reports.
  Wrote complex Expressions for SSRS with Conditional Formatting. Responsible for Deployment of the
report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
Environment: Power BI, ADF, Data Flow, Python, SQL Server Management Studio 2016, MySQL, PL/SQL, SSRS,
SSIS, Oracle DB2, SQL Server.

Education:

 Bachelor of Information and technology, Osmania University in 2016

 Master’s in computer science, Towson University in 2022