Hello, I'm

Pawan Kumar Yadav

Data Analyst

Transforming raw data into meaningful insights using SQL, Python, Excel, and Power BI. Experienced in cleaning 50,000+ records and building interactive dashboards that drive business decisions.

Turning Data Into Decisions

PY
Noida, U.P, India

Data Analyst with hands-on experience in SQL, Python, Excel, and Power BI, leveraging data from 50,000+ records and creating 5+ interactive dashboards to support business reporting and decision-making.

Skilled in data cleaning, exploration, and visualization using Pandas, NumPy, and Power BI. I transform raw data into meaningful findings, uncover trends, and support business decisions with strong analytical skills.

0+ Data Records Processed
0+ Power BI Dashboards
0 Internship Experiences
0 Certifications Earned

Work Experience

Data Analyst Intern

SO Infotech

Feb 2026 – Present
  • Processed and evaluated 50,000+ data records using SQL, Python, and Excel for business reporting.
  • Built 5+ interactive Power BI dashboards, replacing manual weekly Excel reporting with real-time KPI tracking.
  • Conducted data cleaning and EDA on raw datasets, improving downstream report accuracy.
  • Designed optimized SQL queries to extract, aggregate, and validate data from relational databases.

Data Analyst Intern

IBM

Jan 2025 – Feb 2025
  • Interpreted and validated 10,000+ records using SQL, Python, and Excel for data accuracy.
  • Performed EDA to identify trends, patterns, and anomalies within business datasets.
  • Created data visualizations and summary reports for faster, informed decision-making.

Tools & Technologies

Proficient in the full data analysis pipeline — from extraction to visualization

Data Analysis

Data Cleaning Data Visualization Exploratory Data Analysis Statistical Analysis Hypothesis Testing A/B Testing Report Generation

Tools & Languages

Python (Pandas, NumPy) Matplotlib & Seaborn Excel (Pivot, VLOOKUP) Power BI (DAX, Power Query) Jupyter Notebook

Databases

PostgreSQL SQL Query Optimization Data Aggregation

Technologies

Git & GitHub VS Code Conditional Formatting Data Modeling

Soft Skills

Communication Teamwork Troubleshooting Task Prioritization Productivity Management

Featured Projects

Real-world data analysis projects showcasing end-to-end analytical workflows

COVID-19 Data Analysis
Python Analysis

COVID-19 Analysis

Analyzed global COVID-19 dataset using Python to identify infection trends, peak periods, and country-wise impact through EDA and hypothesis testing.

  • Applied hypothesis testing across regions
  • Identified peak infection periods globally
  • Country-wise impact analysis via EDA
Python Pandas NumPy EDA
View on GitHub
Retail Orders Data Analysis
Data Analysis

Retail Orders Data Analysis

Analyzed retail orders data using Python and SQL to identify sales patterns, customer behavior, and product performance metrics for business insights.

  • Processed 10,000+ order records
  • Identified top-selling products
  • Customer purchase pattern analysis
Python SQL Pandas Excel
View on GitHub
Excel Sales Analysis
Excel Analysis

Excel Sales Analysis

Comprehensive sales data analysis using Excel with pivot tables, VLOOKUP, and conditional formatting to track performance and identify growth opportunities.

  • Created interactive dashboards
  • Automated reporting with formulas
  • Trend analysis and forecasting
Excel Pivot Tables VLOOKUP Conditional Formatting
View on GitHub

Academic Background

My educational journey and qualifications

Master of Computer Applications (MCA)

Dr. A.P.J. Abdul Kalam Technical University

2023 – 2025 · 70.4%

Bachelor of Commerce (B.Com)

Veer Bahadur Singh Purvanchal University

2020 – 2023 · 60%

Let's Work Together

Open to data analyst roles and internship opportunities. Feel free to reach out!