Bhavana Parvataneni Email & Phone Number

Cincinnati, Ohio, United States

The objective of this project is to design and implement an ETL pipeline that extracts data from various sources, transforms it into a unified format, and loads it into a central data warehouse. The processed data will then be visualized using Power BI to provide actionable insights, trends, and key performance indicators (KPIs).• Extract data from various sources such as on premises SQL server database, APIs, flat files, and cloud-based MySQL database and csv files stored in Azure Blob… Show more The objective of this project is to design and implement an ETL pipeline that extracts data from various sources, transforms it into a unified format, and loads it into a central data warehouse. The processed data will then be visualized using Power BI to provide actionable insights, trends, and key performance indicators (KPIs).• Extract data from various sources such as on premises SQL server database, APIs, flat files, and cloud-based MySQL database and csv files stored in Azure Blob Storage using SQL queries and Python scripts• Monitor and optimize ETL pipelines for performance, reliability, and scalability.• Clean and preprocess raw data using Python's Pandas library & SAS data manipulation tools. Handle missing values, outliers, and inconsistencies in the data.• Responsible for converting intricate data sets into visual representations, such as charts, graphs, and interactive dashboards, utilizing Power BI, Microsoft Power Apps & Python's Matplotlib. Show less

• Design and implement database schemas, tables, views, and indexes using Microsoft SQL Server Management Studio (SSMS).• Retrieve and manipulate data using SQL functions, joins, subqueries, and aggregation techniques.• Monitor database performance metrics, such as CPU usage, memory usage, and query execution times, and implement optimizations to enhance performance. • Optimize Tableau dashboards and reports for performance by improving data loading times, reducing query complexity,… Show more • Design and implement database schemas, tables, views, and indexes using Microsoft SQL Server Management Studio (SSMS).• Retrieve and manipulate data using SQL functions, joins, subqueries, and aggregation techniques.• Monitor database performance metrics, such as CPU usage, memory usage, and query execution times, and implement optimizations to enhance performance. • Optimize Tableau dashboards and reports for performance by improving data loading times, reducing query complexity, and optimizing visualizations. • Successfully reduced ETL processing time by 30% through optimized pipeline design.• Improved data accuracy and consistency across integrated systems, resulting in enhanced data-driven decision-making. Show less

Masters, Information Systems And Analytics

Bachelor'S Degree, Computer Science

Activities and Societies: Educating unprivileged women about personal hygiene, Throwball