Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Abhishek Chatterjee

Jamshedpur

Summary

Data Analyst in Supply Chain Operation with 5+ years of experience in using SAP S/4 Hana (ERP System), MS-Excel, Tableau for data analysis. Skilled in forecasting, inventory management, and process improvement. Strong communication and problem-solving abilities with a track record of delivering results.

Overview

7
7
years of professional experience

Work History

Associate II- Data Analyst

TATA Steel Limited
01.2023 - Current
  • Conducted data analysis using MS Excel ,SAP S/4 Hana and Tableau to identify process inefficiencies and propose solutions to improve order fulfillment time.
  • Maintained accurate inventory records using SAP ERP system and performed regular cycle counts to ensure inventory accuracy of Mills Maintenance Department of Flat Product Division
  • Collaborated with cross-functional Procurement teams to identify and resolve supplier quality issues, reducing lead times and improving product quality.
  • Involved in making of SAP PM & MM report Highlighting the Major Trend In Material Consumption and Service Delivery of TSCR Mill Operation in Tata Steel .This Helped to Analyse the Major area to Target for Cost Reduction

Associate I -Data Analyst

TATA Steel Limited
Jamshedpur
07.2017 - 12.2022
  • Developed inventory forecasting models to optimize stock levels and reduce stock-outs, resulting in a 10% increase in on-time delivery performance Using SAP ERP System and Excel
  • Involved in the Generating of Purchase Requisition,Request for Quotation, Budgetary Quotation, Purchase Orders along with B2B Local & Global OEM's for Maintenance & Services of Plants
  • Coordinated logistics and transportation activities for the company's inbound and outbound shipments.
  • Involved in the Making of a Zero Based Budget Plan,which was strictly made to Restrict cost Overcharge for the Maintenance And Service Purpose

Education

Internship - Data Science

Learnbay
Bengaluru,Karnataka
03-2023

B.Tech in Electronics & Communication Engineering -

Haldia Institute of Technology
06-2017

X And XII - CBSE

St.Mary's English High School
01-2013

Skills

    Language Python,SQL(MSSQL)

    Tools Jupyter,MSExcel,MSSQL,Google Collab

    Visualization Tools PowerBI ,Tableau

    PowerBI ,Tableau

Projects

Project 1 : US House Prediction Using Regression Algorithms (Machine Learning)

  • Machine Learning Project implemented from scratch which involves exploratory data analysis,Data Processing & machine learning to predict housing prices in New York Tri-State Area.
  • Used Regression Algorithm Models Like Linear Regression & Gradient Descent Regression methods to Gain 91% Accuracy in both Train & Test Data

Project 2 : Diabetes Prediction using ML Algorithms 

  • comprehensive EDA, feature selection, and precision-driven model training – all finely tuned using GridSearchCV and standardized with StandardScaler.
  • Gained 78% Accuracy in both Train and Test Data

Project 3 : MakeMyTrip Case Study  Using SQL 

  • Gained Insights about Hotels and Flights Booking from User database Using Joins ,Windows Function and CTE in MS-SQL Server studio

Project 4 : Spotify App Case Study  Using SQL 

  • Gained Insights about App Installed and App Purchase Using CTE ,Joins ,Datefunctions

Project 5 : Visualization Using Tableau of Different Trending Datasets

Tableau Public Profile Link : https://public.tableau.com/app/profile/abhishek.chatterjee8396/vizzes

Timeline

Associate II- Data Analyst

TATA Steel Limited
01.2023 - Current

Associate I -Data Analyst

TATA Steel Limited
07.2017 - 12.2022

Internship - Data Science

Learnbay

B.Tech in Electronics & Communication Engineering -

Haldia Institute of Technology

X And XII - CBSE

St.Mary's English High School
Abhishek Chatterjee