Back to Developers
SHIVAM KUMAR  VISHWAKARMA

SHIVAM KUMAR VISHWAKARMA

Data Analyst

85 · Excellent

About

Results-oriented Data Analyst with hands-on expertise in SQL, Power BI, Python, and Excel. Built end-to-end analytics pipelines uncovering actionable insights from 9,800+ transaction records. Skilled at translating complex datasets into business-ready KPIs, trend reports, and executive dashboards.

Skills & Expertise (32)

SQL Advanced
8.3/10
4
Years Exp
MySql Advanced
8.0/10
4
Years Exp
Data Cleaning Advanced
8.0/10
4
Years Exp
Power BI Advanced
8.0/10
4
Years Exp
Python Intermediate
7.5/10
3
Years Exp
DAX Intermediate
7.0/10
2
Years Exp
Business Analysis Intermediate
7.0/10
3
Years Exp
Git Intermediate
6.5/10
2
Years Exp
OOP DBMS MySQL WorkBench Data Modelling VS Code GitHub KPI Reporting Dashboard Design EDA reporting pipelines Matplotlib NumPy Pandas Power Query Pivot Tables Excel Drill-throughs Slicers KPI Cards Stored Procedures Window Functions Subqueries CTEs Joins

Work Experience

E-Commerce Sales Analytics Dashboard

Personal Portfolio Project

Present - Present

Cleaned and analyzed 9,800+ retail transactions in MySQL, resolving quality issues across 15+ fields with 100% import integrity. Revealed that the top 20% of customers drove ~48% of revenue; Technology/Machine lines had 23% higher AOV — surfaced via CTEs and window functions. Detected 30%+ seasonal revenue spikes in Q4 across 3 regions through time-series SQL analysis, enabling forecasting and inventory planning recommendations. Delivered a 5-page interactive Power BI dashboard (KPI cards, regional heat maps, product treemaps) and documented 20+ SQL queries on GitHub.

SQL Business Case Studies — Real-World Analytics

Self-Directed Portfolio

Present - Present

Solved 15+ business-oriented SQL problems spanning customer churn, revenue cohorts, and operational KPIs using Joins, CTEs, and Window Functions (RANK/DENSE_RANK). Refactored nested subqueries into CTEs; published structured solutions with business context and findings on GitHub.

Education

B.Tech – Computer Science & Engineering - Tula's Institute, Dehradun

- 2025 · Afghanistan

Diploma – Computer Science & Engineering - Government Polytechnic, Latehar

- 2022 · Afghanistan

Certifications

Cloud Computing

NPTEL / IIT Kharagpur · 2025

Artificial Intelligence Program

Infosys Foundation & ICT Academy · 2024

Python with Machine Learning

Briztech Infosystems · 2021

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceJul 2026

Availability Details

Relocation

Depends on Offer

Skills (32)

Click a skill to find developers with the same skill