Ishan Kumar

Aspiring Data Scientist / Data Analyst

Phagwara, Punjab, India 85 · Excellent

About

Data-focused Computer Science undergraduate with hands-on experience in data analysis, visualization, and reporting using Python, SQL, Microsoft Excel, and Power BI. Skilled at cleaning and exploring large datasets, building interactive dashboards, and translating raw data into actionable business insights. Strong foundation in statistics, data wrangling, and end-to-end analytics workflows, seeking a Data Analyst / Data Science internship or entry-level role.

Skills & Expertise (37)

Pandas Advanced

8.0/10

Years Exp

NumPy Advanced

8.0/10

Years Exp

Python Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Data Wrangling Advanced

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

Exploratory data analysis Advanced

8.0/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

Adaptability Intermediate

7.0/10

Years Exp

Team Collaboration Intermediate

7.0/10

Years Exp

Communication Intermediate

7.0/10

Years Exp

Analytical Thinking Intermediate

7.0/10

Years Exp

Problem-solving Intermediate

7.0/10

Years Exp

Statistical Analysis Intermediate

7.0/10

Years Exp

Matplotlib Intermediate

7.0/10

Years Exp

Microsoft Excel Intermediate

7.0/10

Years Exp

Seaborn Intermediate

7.0/10

Years Exp

scikit-learn Intermediate

7.0/10

Years Exp

Tableau Intermediate

6.0/10

Years Exp

GitHub Intermediate

6.0/10

Years Exp

Git Intermediate

6.0/10

Years Exp

ETL Intermediate

6.0/10

Years Exp

Business Intelligence Intermediate

6.0/10

Years Exp

KPI Reporting Intermediate

6.0/10

Years Exp

Predictive Modeling Intermediate

6.0/10

Years Exp

A/B testing Intermediate

6.0/10

Years Exp

MongoDb Intermediate

6.0/10

Years Exp

HTML Intermediate

5.0/10

Years Exp

CSS Intermediate

5.0/10

Years Exp

React Intermediate

5.0/10

Years Exp

Node.js Intermediate

5.0/10

Years Exp

Express.js Intermediate

5.0/10

Years Exp

Rest API Intermediate

5.0/10

Years Exp

JavaScript Intermediate

5.0/10

Years Exp

C++ Beginner

4.0/10

MySql MS SQL Server

Work Experience

Data Scientist

Student Performance Analysis & Grade Prediction

Oct 2025 - Oct 2025

Cleaned and merged multi-source academic datasets (attendance, assignment scores, demographics) using Python (Pandas) and SQL queries, resolving missing values and inconsistent formatting. Engineered features and trained a linear/logistic regression model in Scikit-learn to predict final exam performance, evaluating results with accuracy, precision, and RMSE metrics. Visualized correlations between study habits, attendance, and performance using Matplotlib/Seaborn, identifying the top 3 factors most predictive of outcomes.

Data Analyst

Retail Sales & Demand Analytics Dashboard

Aug 2025 - Aug 2025

Performed end-to-end exploratory data analysis (EDA) on 50,000+ retail transaction records using Python (Pandas, NumPy) and SQL to uncover best-selling categories, order patterns, and seasonal demand trends. Designed and published an interactive Power BI dashboard with DAX-based KPI measures (revenue, order volume, average order value) that enabled stakeholders to make faster, data-driven promotional decisions. Built an Excel-based demand forecasting model (Power Query, pivot tables, moving averages) that improved inventory accuracy and cut stock wastage by an estimated 30%.

Full Stack Developer

Healthcare Appointment & Patient Data Management System (Medicoz)

May 2025 - May 2025

Built a full-stack healthcare appointment platform with MongoDB Atlas as the backend data store, structuring patient, doctor, and appointment records for efficient querying. Wrote optimized SQL/NoSQL aggregation queries to generate admin-facing reports on appointment volume, doctor utilization, and no-show rates. Implemented secure REST APIs (Node.js, Express.js) for data access and role-based authentication, ensuring data integrity across patient records.