PK

PATTURI PAVAN KUMAR

Data Analyst · SQL · Power BI · Excel · Python

Bengaluru, Karnataka, India

@pavan_kumar_patturi

0 followers

Bachelor of Technology, Computer Science and Engineering at Sri Venkateswara College of Engineering and Technology · Graduating 2026

About

Data Analyst with hands-on experience in SQL, Excel, Power BI and Python, specializing in reporting, dashboard development, data cleaning and KPI analysis. Known for turning large datasets into actionable business insights through interactive dashboards and accurate reporting.

Experience

  • Data Analyst
    BDreamz Global Solutions Pvt Ltd
    May 2026 – Present

    Developed multi-page Power BI dashboards using SQL Server data to monitor sales KPIs, revenue trends and regional performance. Wrote SQL queries using JOINs, CTEs, window functions and stored procedures to extract, transform, validate and analyze transactional records. Built DAX measures for performance reporting, automated monthly reporting with Power Query ETL workflows, and performed data validation and quality checks.

Education

Skills

<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.

Tools / apps / platforms

6 to 12 months 6 to 12 months Most of a year behind them.
Power Query Microsoft Excel Microsoft Power BI Microsoft SQL Server
<3 months <3 months Just getting started - under three months. This is also what shows when a level has not been set.
S3 Git MySQL GitHub Alteryx Tableau Apache Airflow Microsoft PowerPoint Amazon Web Services AWS

Languages

Native / Bilingual Native / Bilingual Their first language, or as strong as one.
Telugu Speak
Fluent Fluent Comfortable using it for work.
English Speak

Projects

  • IPL Cricket Data Analytics
    Python, Pandas, NumPy, Matplotlib

    Analyzed player and team performance using grouping, filtering, sorting and aggregation; created visual reports and automated CSV reporting.

  • Bank Loan Analysis Dashboard
    Power BI, DAX, Excel

    Developed an interactive Power BI dashboard analyzing loan performance and customer lending data with KPI measures and trend analysis.

  • Swiggy Sales Analysis Dashboard
    Excel, PivotTables, XLOOKUP

    Developed an interactive Excel dashboard analyzing sales, orders, customers, restaurants and category performance.

  • E-commerce Return & Refund Fraud Analytics
    Python, SQL, Machine Learning, Power BI, Flask

    Built a fraud detection system to flag fraudulent return and refund requests, performed data preprocessing and feature engineering, and delivered interactive dashboards and a Flask web application for real-time fraud prediction.

Courses & certifications

  • Fundamentals of Data Analytics · 2024
  • Visualizing Data with R · 2024
  • Analyzing Data with R · 2024
  • Programming for Data Analytics · 2024
  • Data Science Foundations · 2022
  • Data Analyst Course Completion Certificate · Besant Technologies

🏆 Achievements & awards

  • Best Performer

    Recognized for delivering analytical dashboards within project timelines.

  • Management Appreciation

    Received appreciation for accurate data analysis and business insights.

Explore the Broxer community

Online · instant AI help
Broxer