pavan chavan

About

Motivated and detail-oriented BCA student with hands-on knowledge of SQL, Excel, Power BI, Python, and data analysis. Skilled in cleaning data, building dashboards, and generating insights from datasets.

Education

• Bachelor of Computer Applications
  Dr Babasaheb Ambedkar University
  Computer Applications · 2026

Skills

• SQL
• Python
• Data Cleaning
• NumPy
• Pandas
• Google Sheets
• Data validation
• Microsoft Excel
• Exploratory Data Analysis
• Oracle SQL
• Window functions
• Conditional Formatting
• Countif
• pgAdmin
• Subqueries

Projects

• Employee Data Analysis
  Oracle SQL, Excel

  Created and analyzed an employee dataset containing employee, department, salary, and location information. Used SQL queries with JOIN, GROUP BY, HAVING, subqueries, and aggregate functions, and summarized results with Excel Pivot Tables and charts.

• Sales Data Analysis Dashboard
  Excel, SQL, Power BI

  Cleaned and analyzed sales data to identify business trends and performance. Used SQL queries to calculate total sales, average sales, and category-wise performance, then created an interactive Power BI dashboard to analyze sales by product, region, and time period.