Pavan Kolla

Data Analyst

India 85 · Excellent

About

Results-driven Data Analyst with a strong foundation in data analysis, business intelligence, and analytics. Proficient in SQL, Python, Power BI, and Excel with proven expertise in extracting actionable insights from complex datasets. Skilled at creating compelling visualizations, designing efficient reports, and supporting data-driven decision-making. Experienced in managing diverse datasets and transforming raw data into meaningful business intelligence solutions.

Skills & Expertise (47)

Excel Advanced

8.0/10

Years Exp

MS Excel Advanced

8.0/10

Years Exp

Power BI dashboards Intermediate

7.5/10

Years Exp

Pivot Tables Advanced

7.5/10

Years Exp

Advanced Formulas Advanced

7.5/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

SQL Intermediate

7.1/10

Years Exp

KPI Tracking Intermediate

7.0/10

Years Exp

Data Manipulation Intermediate

7.0/10

Years Exp

Quality Checks Intermediate

7.0/10

Years Exp

Excel Charts Advanced

7.0/10

Years Exp

Graphs Advanced

7.0/10

Years Exp

Interactive Reports Advanced

7.0/10

Years Exp

Data Validation Intermediate

7.0/10

Years Exp

Data Interpretation Intermediate

7.0/10

Years Exp

Stakeholder Management Intermediate

7.0/10

Years Exp

Problem-solving Intermediate

7.0/10

Years Exp

Team Collaboration Intermediate

7.0/10

Years Exp

Communication Intermediate

7.0/10

Years Exp

Leadership Intermediate

7.0/10

Years Exp

Report Writing Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Index-match Advanced

7.0/10

Years Exp

VLOOKUP Advanced

7.0/10

Years Exp

Interactive Dashboards Intermediate

7.0/10

Years Exp

Descriptive Statistics Intermediate

6.5/10

Years Exp

Trend Analysis Intermediate

6.5/10

Years Exp

Comparative Analysis Intermediate

6.5/10

Years Exp

Subqueries Intermediate

6.5/10

Years Exp

Complex Joins Intermediate

6.5/10

Years Exp

Database Optimization Intermediate

6.5/10

Years Exp

Data Modeling Intermediate

6.5/10

Years Exp

DAX Intermediate

6.5/10

Years Exp

Measures Intermediate

6.5/10

Years Exp

Relationships Intermediate

6.5/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Window Functions Intermediate

6.0/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

Git Intermediate

6.0/10

Years Exp

Jupyter Notebook Intermediate

6.0/10

Years Exp

database design Intermediate

6.0/10

Years Exp

ETL Concepts Intermediate

6.0/10

Years Exp

Data Architecture Intermediate

6.0/10

Years Exp

NumPy Intermediate

6.0/10

Years Exp

MySql SQL Server Postgresql

Work Experience

Data Analyst

GRK IT Technologies

Present - Present

Gained hands-on experience in Excel, SQL, Power BI, and advanced data visualization techniques. Analyzed sample datasets and created insightful reports for business decision support. Developed queries to extract and manipulate data from databases. Created dashboards and visualizations to communicate key metrics and trends. Learned best practices in data cleaning, validation, and quality assurance.

Class Representative & Student Leader

Santhiram Engineering College

Present - Present

Represented class members and coordinated effectively with faculty for academic activities. Managed communication channels between students and department, improving information flow. Organized class schedules, event coordination, and administrative updates. Developed strong leadership, teamwork, and problem-solving capabilities. Built rapport and stakeholder management skills through diverse interactions.