Data Analyst Power Bi

GOWTHAMI KONDA

*****************@*****.***\phone: +1-516-***-****\NY

DATA ANALYST

OBJECTIVE

Dedicated and detail-oriented Data Analyst with years of experience in collecting, analyzing, and interpreting large datasets to drive business decisions. Proficient in SQL, Python, and data visualization tools like Tableau and Power BI, with a strong background in identifying trends, optimizing processes, and delivering actionable insights. Seeking a challenging position to leverage analytical expertise and contribute to data-driven strategies for organizational growth.

PROFESSIONAL EXPERIENCE

Client: Vertafore - Hyderabad, India June 2020 - august 2022

Data Analyst

Conducted detailed data analysis to identify trends, anomalies, and opportunities, leading to a 15% improvement in operational efficiency.

Automated recurring reports and dashboards, reducing manual effort by 30% and improving reporting accuracy.

Performed ETL processes to extract, clean, and transform data into centralized data warehouses, ensuring data quality and consistency.

Designed Power BI reports and data models, integrating data from SQL Server, CSV Files, Access, and Excel, Flat files and oracle

Built and optimized SQL queries, stored procedures, and triggers, reducing query execution time by 20%.

Created complex DAX measures, calculated columns, and interactive visualizations in Power BI to enhance data insights.

Automated data refresh schedules in Power BI Service, ensuring timely updates and reliability for business-critical reports.

Partnered with teams to create dashboards for operational performance, staffing forecasts, and financial reporting.

EDUCATION

Master of Science in Information systems September 2022- May 2024

Pace university, New York, USA GPA: 3.11

Technical Skillset

Business Intelligence Tools: Excel (Pivot tables, VLOOKUP), Power BI, SSRS

Data Processing: Expertise in Data Collection, Data management, data mining, Quantitative & Qualitative Analysis data wrangling, transformations, and statistical analysis

Programming Languages: Python (NumPy, Pandas)

Querying and Scripting: T-SQL, DAX

Data Modeling: Dimensional Modeling, Star Schema, Snowflake Schema

Data Integration: Migrating data from text files, Excel, Access to SQL Server; Creating pipelines for data transformation and movement

Reporting: Design and development of operational, financial, and capacity planning reports using Power BI and SSRS, MOE, TANF

Automation: Automated workflows and billing processes using Python and VB Scripts

Collaboration Tools: Centralized workspaces and content packs in Power BI for team collaboration

Performance Optimization: Query optimization, performance tuning, and troubleshooting

Soft skill: Adaptability, Analytical Thinking, Critical Thinking, Data Collection and Entry, Data Quality Management, Collaboration, Decision Making, Interpret Relevant Laws, Rules, and Regulations, Problem Solving, Research Analysis, Customer and Client Focus, Innovative Thinking, Oral Communications, Prioritization, Quality Assurance

Extra-Curricular & Certifications

Tata Data Visualization: Empowering Business with Effective Insights Job Simulation on Forage November 2023

Completed a simulation involving creating data visualizations for Tata Consultancy Services

Prepared questions for a meeting with client senior leadership

Created visuals for data analysis to help executives with effective decision making

Skills: Analysis & Presentation, Charts & Graphs, Dashboard, Data Analysis, Data Cleanup, Data Interpretation, Data Visualization, Effective Communication.

PwC Power BI Job Simulation on Forage November 2024

Completed a job simulation where I strengthened my Power BI skills to better understand clients and their data visualization needs.

Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, showcasing the ability to respond to client requests with well-designed solutions.

Strong communication skills reflected in the concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.

Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision making.

Skills: Calculating Measures, Defining KPIs, Insight and Actions, Insights and Actions, Power BI, Power BI Dashboard Self-Reflection

Data analytics portfolio project January 2025

Zep Analytics

Conducted exploratory data analysis (EDA) on historical cryptocurrency datasets using Python (Pandas) for data cleaning, wrangling, and aggregation.

Designed interactive dashboards in Power BI to visualize price trends, volatility, and performance metrics across multiple cryptocurrencies.

Developed and presented time-series analysis to identify patterns and actionable insights, enhancing data-driven decision-making.

Integrated Python and Power BI workflows to optimize data processing and visualization efficiency.

Strengthened proficiency in data storytelling, transforming complex data into accessible insights for stakeholders.

Skills: Data Analysis, Data Cleaning & Wrangling, Data Visualization, Time-Series Analysis, Business Intelligence Python (Pandas, Matplotlib) Power BI Dashboard Design, Technical Integration (Python with Power BI), Blockchain Fundamentals.

Certifications:

Coursera: Introduction to Data Analysis using Microsoft Excel

Coursera project network: Data cleaning in SQL, preparing data for analysis

LinkedIn: preparation for the power bi data analyst associate certification

Alison: introduction to data analytics with python

Simplilearn: SQL completion of certification

Contact this candidate