A K SK

About

Penultimate-year B.Tech Mechanical Engineering student at NIT Jamshedpur with hands-on experience in Python, SQL, Power BI, ETL workflows, and exploratory data analysis. Built end-to-end data projects and dashboards using relational data modeling, statistical analysis, and query optimization.

Experience

• Technical Member
  NIT Jamshedpur
  — – Present
• Online Subject Matter Expert & Mentor

Education

• Bachelor of Technology
  National Institute of Technology (NIT), Jamshedpur
  Mechanical Engineering · 2026

Skills

• SQL
• Python
• Statistics
• Feature Engineering
• Matplotlib
• NumPy
• Pandas
• DAX
• Hypothesis Testing
• Seaborn
• Data Modeling
• ETL
• KPI Tracking
• Query Optimization
• Window functions
• Subqueries
• Common Table Expressions (CTEs)

Projects

• Swiggy Sales Performance
  Excel Power Query, Excel Dashboard

  BI and market cohort analysis project using 100,000+ food delivery transaction logs to identify revenue-driving cities and underperforming segments.

• AIIMS Health Analytics
  Python, SQL, Power BI

  End-to-end ETL pipeline and BI dashboard built on a synthetic relational dataset of 3,000,000+ rows across 5 normalized operational tables.

Courses & certifications

• Generative AI Job Simulation · Forage
• Python for Data Analysis (NumPy & Pandas)
• SQL for Data Science · HackerRank

⚽ Extracurricular activities

• Team Phoenix, NIT Jamshedpur

  Technical member in a student engineering team designing high-payload RC aircraft systems and analyzing telemetry and component load data.