Soumik Santra

About

Aspiring data analyst pursuing an MBA in Business Analytics, with project-based experience across data cleaning, transformation, modeling, and dashboard development. Skilled in SQL, Power BI, Python, Tableau, and Excel, with an engineering background in structured problem-solving.

Experience

• Vocational Trainee, Signal & Telecom
  South Eastern Railway, Multi-Disciplinary Zonal Training Institute (MDZTI)
  Dec 2024 – Dec 2024
• Vocational Trainee, AM/FM Engineering
  Prasar Bharati — Akashvani (All India Radio)
  Aug 2024 – Aug 2024

Education

• B.Tech (Bachelor of Technology)
  Meghnad Saha Institute of Technology
  Electronics & Communication Engineering · 2025
• 12th Standard
  Sri Ramkrishna Sikshalaya, Howrah
  2021
• 10th Standard
  Sri Ramkrishna Sikshalaya, Howrah
  2019
• PGDM/MBA (Master of Business Administration)
  Bengal Institute of Business Studies
  Business Analytics & Data Analytics · 2025

Skills

• SQL
• Business Analysis
• Data Analysis
• Data Visualization
• Python
• Data Cleaning
• DAX
• Root Cause Analysis
• Trend analysis
• Business Intelligence
• Data Modeling
• Dashboard Development
• Data Storytelling
• KPI reporting
• Data Wrangling

Projects

• Education Analytics Dashboard
  Power BI, Excel, Power Query

  Cleaned and transformed a school education dataset spanning all 28 Indian states to build an analysis-ready data model. Designed an interactive dashboard with geospatial maps, KPI cards, donut charts, and drill-down views, and conducted trend, comparative, and root-cause analysis.

• Airline Operations Dashboard
  SQL, Excel

  Led end-to-end analysis of a 10,000+ record dataset covering customer behavior, service performance, and operational data. Built interactive dashboards tracking service ratings, delay metrics, and class-wise performance for self-service KPI tracking.

Courses & certifications

• Machine Learning with Python · IIT Kanpur
• Advanced Power BI · IIT Kanpur