Data Analyst Power Bi
Resume:
Bhavana Parvataneni
Mobile: +1-469-***-****
Email : *************@*****.***
Summary
• Over 4 + years of experience as a Data Analyst, specializing in data analysis, visualization, and interpretation.
• Proficient in extracting, cleaning, transforming, and analyzing complex datasets to derive actionable insights.
• Skilled in using SQL for querying databases, data manipulation, and generating reports.
• Experienced in data visualization tools such as Tableau and Power BI for creating interactive dashboards and reports.
• Familiar with programming languages like Python and R for data analysis and statistical modeling.
• Experienced in working with large datasets and databases, including Microsoft SQL Server, MySQL, PostgreSQL, and Oracle.
• Good knowledge in SQL joins, sub queries.
• Proficient in designing and creating database structures, including tables, views, triggers, partitions, complex stored procedures, functions, indexes, and other objects using SQL/T-SQL
• Developed various SSIS Packages using Stored Procedures and Complex SQL Queries.
• Proven track record of effectively communicating analytical findings and recommendations to stakeholders through presentations and reports.
• Collaborative team player with excellent problem-solving skills and a passion for leveraging data to drive business decisions and outcomes.
• Continuously learning and adapting to new technologies and methodologies in the rapidly evolving field of data analytics.
TECHNICAL SKILLS
Category Technology/Tool
Databases Microsoft SQL Server,
MySQL, Oracle, SQLite
Data Extraction & Loading SQL, Python, Microsoft SSIS Data Transformation Python, Spark
Data Analysis Python, Excel, SAS
Data Visualization Tableau, Power BI
Data Storage Azure Blob, Hadoop
Collaboration & version control Git, GitHub, Bitbucket Monitoring & Logging ELK Stack
Cloud Azure
EDUCATION
Loyola University, Chicago
Masters in information systems
CRR College of Engineering, Andhra Pradesh, India. Bachelors in computer science & engineering
PROFESSIONAL EXPERIENCE
Senior Data Analyst
TEKPROS LLC (February 2024 – Present)
Project Overview:
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 into customer data patterns, trends, and key performance indicators (KPIs). This project enables the organization to gain deep insights into customer data patterns, improve decision-making processes, and drive business growth through data-driven strategies. The interactive Power BI dashboards will provide stakeholders with easy access to key metrics and trends, facilitating informed decisions and strategic planning. Responsibilities:
• Served as a technical expert within the development team, actively contributing to the analysis, design, and implementation of business intelligence solutions, ETL processes, and databases essential for supporting diverse systems.
• 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 and ensure data extraction processes are efficient and reliable, capturing all necessary data for analysis.
• Transform raw data into structured formats suitable for analysis using Python libraries like Pandas and SQL. Clean and preprocess data to handle missing values, duplicates, and inconsistencies.
• Design, develop, and maintain ETL pipelines to automate data extraction, transformation, and loading processes using tools such as Apache Airflow and custom Python scripts. Monitor and optimize ETL pipelines for performance, reliability, and scalability.
• Responsible for designing and maintaining database schemas, tables, indexes, and views to support data storage and retrieval using SQL.
• Optimize database performance by tuning SQL queries and indexing strategies.
• Implemented data quality checks and validation procedures to ensure the accuracy and completeness of data.
• Proficient in identifying and resolving database performance issues, specializing in query optimization, index tuning, and resource utilization as part of Performance Tuning and Optimization initiatives.
• Clean and preprocess raw data using Python's Pandas library & SAS data manipulation tools. Handle missing values, outliers, and inconsistencies in the data.
• Performed data mining tasks such as association rule mining, clustering, or text mining using Python's NLTK (Natural Language Toolkit).
• Developed intricate SQL statements for data fixes, modifications, and reporting, ensuring data validity within target tables.
• Created Power BI reports and dashboards to efficiently visualize 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.
• Conduct exploratory data analysis using Python's Pandas, Matplotlib and SAS to gain insights into the dataset.
• Proficiently communicate and present data-driven insights and recommendations to both internal and external stakeholders, actively seeking and integrating feedback as necessary.
• Document analysis workflows, methodologies, and results using version control systems like Git and project management tools like Jira.
Technologies: Microsoft SQL Server, Azure, Microsoft Blob Storage, SQL, Python, Pandas, Power BI
Data Analyst
Infosys (June 2018 – May 2022)
Responsibilities:
• Design and implement database schemas, tables, views, and indexes using Microsoft SQL Server Management Studio (SSMS) or MySQL Workbench.
• Ensure data integrity and consistency by enforcing constraints, such as primary keys, foreign keys, and unique constraints. Monitor database performance and optimize database structures for efficiency.
• Write and optimize SQL queries to extract data from Microsoft SQL Server and MySQL databases. Retrieve and manipulate data using SQL functions, joins, subqueries, and aggregation techniques.
• Transform and clean raw data into usable formats using SQL queries, stored procedures, and user-defined functions. Handle data cleansing tasks, such as removing duplicates, correcting errors, and standardizing formats.
• Identify and resolve database performance issues by optimizing SQL queries, indexing strategies, and database configurations. Monitor database performance metrics, such as CPU usage, memory usage, and query execution times, and implement optimizations to enhance performance.
• Implement and manage security measures to protect sensitive data stored in Microsoft SQL Server and MySQL databases. Define and enforce user roles, permissions, and access controls to ensure data confidentiality and integrity.
• Integrate data from multiple sources into Microsoft SQL Server and MySQL databases using ETL processes. Develop and maintain data pipelines and workflows to automate data extraction, transformation, and loading tasks.
• Extract and manipulate data from relational databases using Python's SQLAlchemy library.
• Create interactive and visually appealing dashboards and reports using Tableau and Python's Jupyter Notebooks & SAS reports to present insights and trends derived from data.
• Designed intuitive user interfaces with interactive features such as filters, drilldowns, and tooltips to facilitate data exploration.
• Optimize Tableau dashboards and reports for performance by improving data loading times, reducing query complexity, and optimizing visualizations.
• Monitor dashboard performance metrics and address performance bottlenecks to ensure a smooth user experience.
Technologies: Microsoft SQL Server, MySQL, SQL Queries, Python, Pandas, SQLAlchemy, Tableau.
Achievements:
• 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.
Contact this candidate