Summary
Overview
Work History
Education
Skills
Projects
Certification
Languages
Hobbies and Interests
Timeline
Generic
Subhadip Nayak

Subhadip Nayak

Kolkata

Summary

With experience in data science and the automotive field for 9 months, skilled in data analysis and data science tools, including Excel, Power BI, Tableau, MySQL, Python, Numpy, Pandas, machine learning, and deep learning. Good at quick analysis, quick understanding, and team management.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Data Analyst

WaysAhead Global Private Limited
Kolkata
12.2024 - 05.2025
  • Collection of data by web scraping. Analysing data and preprocessing data.
  • Inserting bulk data into the database using Python.
  • Making APIs can connect to the database and return output in a format.
  • Built a Flask-based API that extracts and analyzes data from PDFs and videos using OCR (pytesseract) and speech recognition. Implemented folder-based user detection to dynamically process documents for individuals. Used LangChain with OpenAI embeddings and Chroma vector store to enable question-answering over extracted content via a Retrieval-Augmented Generation (RAG) pipeline. Technologies: Python, Flask, OpenAI API, LangChain, ChromaDB, PyPDF2, MoviePy, Pydub.

Data Analyst Internship

ExcelR
07.2024 - 01.2025
  • Gained experience across various fields by working with data, understanding workflows, and performing data cleaning and analysis.
  • Used tools like Excel, Power BI, Tableau, MySQL, and Numpy to create reports and dashboards.

Associate Engineer

Ignitarium Technology Solutions Private Limited
Bengaluru
07.2023 - 04.2024
  • Engaged in Android Automotive development using Kotlin and C++ and Python.

Internship

Wireless Internetworking Groups (WINGS Lab)
07.2021 - 09.2021
  • I completed a project analyzing child malnutrition status and potential solutions using machine learning, along with Numpy and Pandas for data processing.
  • A research paper has also been published by IEEE.

Education

B Tech - Computer Science & Engineering

University of Engineering & Management
Jaipur
07.2023

WBBSE & WBCHSE -

Kolaghat Thermal Power Plant High School
KTPP Township
06.2019

Skills

Data Analysis & Visualization

  • Advanced Excel (Power Query, PivotTables, Dashboards)
  • Tableau (Dynamic Dashboards, LOD Calculations)
  • Power BI (DAX, Data Modeling, KPI Visualizations)

Programming & Automation

  • Python (NumPy, Pandas, Matplotlib, Flask)
  • C (Data Structures, OOP, Problem Solving)
  • MySQL (Joins, Subqueries, Query Optimisation)

Machine Learning & Deep Learning

  • Scikit-learn (Classification, Regression, Clustering)
  • TensorFlow/Keras (Neural Networks, CNNs)
  • Model Evaluation, Hyperparameter Tuning, Cross-validation

Web & API Development

  • HTML, CSS, Bootstrap (Responsive UI Design)
  • Flask (API Development, ML Integration)

Other Key Strengths

  • Quick Understanding & Analysis
  • Team Collaboration & Project Execution

Projects

  • Crowdfunding Analysis, 07/2024, 09/2024, Gained an understanding of crowdfunding and its operations. Utilized Python libraries like Numpy and Pandas, along with Excel, for data cleaning and preprocessing. Created KPIs, dashboards, and reports using Power BI, Tableau, and MySQL.
  • Adventure Works, 05/2024, 07/2024, Adventure Works Cycles is a multinational company manufacturing and selling bicycles across North America, Europe, and Asia, with headquarters in Bothell, Washington. Using dashboards in Excel, Power BI, and Tableau, the company analyzes sales, production costs, and profits by year, month, and quarter through various charts, enabling efficient business insights. [https://github.com/Subhadipnayak/Adventure-Works]
  • Healthcare Data Analysis, 10/2024, 01/2025, Collected data from health organizations and analyzed workflow. Cleaned and preprocessed the data using Numpy and Excel, then appended all data into a MySQL database. Created charts, reports, and dashboards in Power BI, Tableau, and MySQL to identify workflow patterns. [https://github.com/Subhadipnayak/Subhadip?tab=readme-ov-file#subhadip]

Certification

  • Programming for everybody (getting started with Python) [12/2020 - 01/2021]
  • Mywbut Online Winter Training Certificate for the course, Machine Learning with Python [12/2020 - 01/2021]
  • Mastering in CPP [07/2023 - 09/2023]

Languages

Bengali
First Language
English
Proficient (C2)
C2
Hindi
Advanced (C1)
C1

Hobbies and Interests

  • Cricket
  • Football
  • Kabbadi
  • Learning new technologies

Timeline

Data Analyst

WaysAhead Global Private Limited
12.2024 - 05.2025

Data Analyst Internship

ExcelR
07.2024 - 01.2025

Associate Engineer

Ignitarium Technology Solutions Private Limited
07.2023 - 04.2024

Internship

Wireless Internetworking Groups (WINGS Lab)
07.2021 - 09.2021

B Tech - Computer Science & Engineering

University of Engineering & Management

WBBSE & WBCHSE -

Kolaghat Thermal Power Plant High School
Subhadip Nayak