Data Analyst &
Problem Solver

Transforming raw data into actionable insights using Python, SQL, Power BI, Excel, and Tableau

Passionate about data analysis, visualization, and building efficient solutions. With expertise in Python, SQL, and business intelligence tools, I help organizations make data-driven decisions.

Rohit Kumar

About Me

Data Analysis

Proficient in Python, SQL, and MySQL for comprehensive data analysis and database management

Visualization

Expert in Power BI, Excel, and Python visualization libraries for creating impactful dashboards

ETL & Automation

Experienced with Power Query, data transformation, and process automation

Skills & Expertise

Programming

Data Analysis

BI Tools

Databases

Version Control

Certifications

Big Data Foundations - Level 1

Big Data Foundations - Level 1

IBM (Credly)

Issued: February 19, 2026

Badge earner has a basic understanding of Big Data concepts and their applications. Understands Big Data processing platforms and data governance principles.

Skills:

Big DataHadoopData Architecture+1
View
Markets Quantitative Analysis (MQA) Job Simulation

Markets Quantitative Analysis (MQA) Job Simulation

Forage & Citi

Issued: December 9, 2025

Completed practical job simulation for Markets Quantitative Analysis role at Citi. Covered financial math, pricing commodities, and risk management.

Skills:

Quantitative AnalysisFinancial MathematicsRisk Management+1
View
Data Analytics Job Simulation

Data Analytics Job Simulation

Deloitte & Forage

Issued: November 20, 2025

Completed practical job simulation for Data Analytics role at Deloitte. Covered data analysis and forensic technology applications.

Skills:

Data AnalysisForensic TechnologyBusiness Analytics+1
View

Data Cleaning Process

Step-by-step data cleaning methodology used in my analysis projects

1

📊Data Understanding

Check dataset size and structure, understand columns and objective

2

🔧Fix Data Types

Convert to correct formats (numeric, datetime, categorical)

3

⚠️Handle Missing Values

Identify missing data, remove or impute (mean/median/mode)

4

🗑️Remove Duplicates

Delete duplicate rows, validate unique identifiers

5

Standardize Data

Make values consistent (e.g., Male/M/male → Male)

6

📝Fix Formatting Issues

Remove extra spaces, clean text formatting

7

🎯Handle Outliers

Detect extreme values, remove or cap if needed

8

Validate Data

Recheck missing values, confirm data types, ensure no duplicates

Featured Projects

Featured Project

🌦️ Weather Analytics ETL Pipeline

Real-time weather data analytics pipeline with automated ETL workflow. Fetches live weather data using OpenWeather API, processes it through Python, stores in MySQL database, and visualizes with Power BI dashboards. Fully automated using Windows Task Scheduler with continuous version control via Git/GitHub.

Tech Stack

PythonMySQLPower BIOpenWeather APIWindows Task SchedulerGit/GitHub

Key Features

  • Real-time weather data extraction from OpenWeather API
  • Automated Python ETL pipeline with data cleaning & validation
  • MySQL database with structured data storage
  • Interactive Power BI dashboard with live refresh
  • Windows Task Scheduler automation (runs every 15 minutes)
  • Complete version control with Git/GitHub
  • Historical trend analysis and comparisons
  • DAX-based calculations and KPIs
ETL Pipeline Architecture - Git/GitHub Version Control Layer

Get In Touch

Interested in collaborating or have a question? Feel free to reach out through any of these channels.