Summary
Overview
Work history
Education
Skills
Soft Skills
Affiliations
Accomplishments
Projects
Timeline
Generic

Amit Kumar Mohanty

India

Summary

Data Science & Analytics intern with experience in SQL, Python, and Power BI. Applying advanced analytics to optimize business performance. Backed by 6+ years of leadership experience in Supply Chain & Operations (procurement, logistics, distribution), combining domain knowledge with data-driven problem solving.

Overview

7
7
years of professional experience
5
5
years of post-secondary education

Work history

Data Science Intern

DV Analytics
Bhubaneswar
09.2024 - 08.2025
  • Optimized logistic regression and decision tree models, reducing training time and improving forecasting accuracy for supply chain efficiency.
  • Made optimized business models using SQL & Power BI to support business forecasting and decision making.

Supply Chain Management & Logistics Executive

Godrej & Boyce Mfg. Co. Ltd
Bhubaneswar
06.2018 - 08.2024
  • Implemented cost-efficient supply chain strategies, saving ₹58L freight and ₹3L working capital in FY 23-24.
  • Negotiated freight rates with local & national vendors, cutting overcharges in dispatches and reverse logistics.
  • Designed a workforce pool with cross-functional training, improving flexibility and utilization.
  • Monitored dispatches with route planning, transshipments, and cross-docking, enabling faster delivery at minimal cost.
  • Analyzed statistical data to identify profit leakage and implemented corrective measures.

Education

Bachelor of Accountancy & Statistics -

D.A.V. School of Business Management
04.2015 - 03.2018

Intermediate: Science -

D.A.V. Public School Unit-VIII
03.2013 - 03.2015

Skills

  • Excel (Advanced) – pivot tables, dashboards
  • Python (pandas, NumPy, scikit-learn, matplotlib, seaborn)
  • SQL (joins, subqueries, window functions, optimization)
  • Machine Learning (regression, classification, clustering, decision trees, random forests)
  • Data Visualization (Power BI)
  • Statistical Analysis (hypothesis testing, probability, distributions)

Soft Skills

Leadership & Team Management – Led a cross-functional team of 12, implementing workforce pooling for higher efficiency

Adaptability – Handled urgent rerouting of consignments during supply chain disruptions with minimal delays to support Sales Target

Communication – Coordinated between vendors, transporters, and warehouse teams to ensure smooth operations.

  • Problem-Solving – Resolved freight cost leakages by negotiating vendor contracts and optimizing dispatch routes.

Affiliations

  • Playing Chess
  • Graphic Novels

Accomplishments

  • Redesigned warehouse layout to store 52,000+ SKUs in 1,86,000 sq. ft., maximizing space.
  • Awarded “Reward & Recognition” 2020-21 for OSIC project (₹120 Cr dispatch in 35 days).
  • Awarded “Reward & Recognition” 2021-22 for automation & digitization initiatives reducing OPEX & CAPEX.

Projects

Freight Cost Optimization Project Warehouse Inventory Management System Logistics KPI Dashboard Route Optimization Analysis

Tools: Excel (pivot tables, formulas), SQL (queries),Power BI (for visualization)

  • Analysed vendor transportation data, created cost dashboards in Excel, and highlighted routes with above-average costs.
  • Outcome: Suggested route changes reducing freight spend by ~15%.


Tools: SQL (database design), Excel (reports, analysis)

  • Built SQL database for tracking stock levels, reorder points, and supplier lead times.
  • Integrated Excel reports to auto-generate low-stock alerts.
  • Outcome: Improved stock visibility and reduced stock-outs.


Tools: Excel (dashboards, charts), SQL (data extraction)

  • Built dashboard tracking KPIs: on-time performance, freight cost/unit, warehouse utilization.
  • Outcome: Identified that 20% of delayed shipments came from a single vendor.


Tools: Excel (Solver), SQL (distance/cost database),Power BI (for visualization)

  • Used Excel Solver for optimal delivery routing based on shipment distances, vehicle capacity, and fuel costs.
  • Outcome: Demonstrated mileage & fuel savings through optimized scheduling.



Timeline

Data Science Intern

DV Analytics
09.2024 - 08.2025

Supply Chain Management & Logistics Executive

Godrej & Boyce Mfg. Co. Ltd
06.2018 - 08.2024

Bachelor of Accountancy & Statistics -

D.A.V. School of Business Management
04.2015 - 03.2018

Intermediate: Science -

D.A.V. Public School Unit-VIII
03.2013 - 03.2015

Similar Profiles

Create profile
Amit Kumar Mohanty