Data Analyst Power Bi

Spandana

Email: ad81v4@r.postjobfree.com Mobile: 469-***-**** https://www.linkedin.com/in/skonduru97/

Summary

More than 5 years of experience as Senior Data Analyst using Python, SQL, Tableau, Power BI, AWS, Azure, Snowflake and EXCEL.

Experience object-oriented programming (OOP) concepts using Python.

Extensive experience in writing and optimizing complex SQL queries, creating stored procedures, and developing functions to manage and manipulate data efficiently.

Experience in Enhancing query performance in Snowflake by optimizing SQL scripts, using clustering keys, and leveraging Snowflake’s performance features.

Created complex SQL queries in Amazon Redshift for analysis, enriching Tableau reports with actionable insights.

Developed detailed and interactive Tableau and Power BI reports to track and analyze key business metrics, driving informed decision-making across departments.

Leveraged advanced Excel functions such as VLOOKUP, HLOOKUP, and INDEX-MATCH to analyze and retrieve data from large datasets.

Utilized SDLC methodologies to manage data analysis projects, covering requirement gathering, design, implementation, and testing.

Utilized Jira for project management, tracking tasks, and maintaining workflows.

Excellent communication and interpersonal skills, ability to work independently as well as part of an integrated team

Education

Bachelor of Technology in Computer Sciences, JNTU Hyderabad - India - GPA: 3.68 May 2019

Skills

Programming Languages

Python, SQL

Databases

MS SQL Server, PostgreSQL

Data Warehouse

Snowflake, RedShift

Version Control

GitHub, GitLab

Cloud Platform

Azure, AWS

Business Intelligence Tools

Power BI, Tableau

Productivity Suites

MS Office, Google Workspace

Work Experience

Verizon – Richardson, TX, USA /Sr. Data Analyst. Jan 2023 – Present

Designed and optimized data applications and processes for financial risk management within Verizon’s Global Markets sector, integrating various technology platforms to enhance data analysis and reporting capabilities.

Connected to various data sources such as SQL databases, Excel files, and cloud services, ensuring seamless data integration and real-time data updates in Power BI.

Used Python libraries like SQL Alchemy and psycopg2 for connecting different databases like SQL server, PostgreSQL.

Employed Azure Data Lake Storage to handle and store significant amounts of structured and unstructured data, facilitating scalable data processing.

Implemented ETL pipelines in Azure Data Factory to automate data ingestion and transformation, and connected them to Snowflake for real-time processing and aggregation of large datasets to support dynamic business intelligence.

Leveraged Azure SQL Database for schema design, complex query development, and performance tuning to enhance data analysis.

Developed and optimized complex SQL queries, including joins, subqueries, and window functions, and created stored procedures, functions, and triggers to automate data processing and enhance performance.

Utilized Snowflake's cloud data warehouse to manage and analyze large datasets, performed data loading and transformation, and optimize storage and compute resources for cost efficiency and high performance.

Created interactive dashboards and reports in Power BI from Snowflake data, enabling stakeholders to interpret complex insights and make data-driven decisions for strategic planning.

Engaged with cross-functional teams through clear communication and collaboration, ensuring alignment and successful project outcomes.

Adopted Agile methodologies for the project, facilitating frequent updates, feedback incorporation, and adaptive planning.

Skills Utilized: PYTHON, SQL, Snowflake, Power BI, Pandas, Azure Services, ETL, GIT, EXCEL, AGILE.

RMSI – Hyderabad, India /Data Analyst. Jun 2019 – Sep 2022

Collaborated with Business Analysts to gather and document requirements, translating them into precise technical specifications and detailed data models for system integration.

Executed complex SQL queries and optimized multi-table joins in Amazon Redshift, performing data cleansing and advanced analytics to identify and validate relationships between variables.

Implemented cluster analysis to segment customers based on key attributes, leveraging unsupervised learning techniques to interpret interest rate patterns and customer classifications.

Applied advanced Excel functions and Tableau to extract actionable insights from loan market data, generating trend reports and strategic recommendations for market forecasting.

Designed and optimized advanced SQL queries using nested subqueries, window functions, recursive CTEs, multiple joins, and pivoting techniques to support detailed data analysis and reporting on large datasets.

Created and maintained interactive Tableau dashboards to visualize complex data, enabling stakeholders to easily interpret insights and make informed decisions.

Integrated AWS S3 with Tableau by setting up secure data connections using AWS Athena, enabling direct querying of data stored in S3 and creating dynamic, interactive dashboards.

Optimized Tableau data extracts to ensure efficient performance of KPI calculations and faster dashboard load times.

Adopted Agile methodologies for the project, facilitating frequent updates, feedback incorporation, and adaptive planning.

Skills Utilized: PYTHON, SQL, AWS, Tableau, GIT, EXCEL.

Contact this candidate