Summary
Overview
Work History
Education
Skills
Awards In Sports And Team Events
Achievements And Results
Project Highlights
Timeline
Generic

RANJITH KUMAR A

Bangalore

Summary

Results-driven Supply Chain Planning Engineer at Caterpillar Inc., skilled in SAS programming and logistics management. Successfully led analytics projects that enhanced inventory management and real-time reporting for global dealers. Proven problem solver with strong project management abilities, delivering impactful solutions that streamline operations and improve efficiency.

Overview

12
12
years of professional experience

Work History

Supply Chain Planning Engineer

Caterpillar Inc.
02.2017 - Current
  • Leading analytics and automation projects in supply chain planning and inventory management.
  • Created SAS programs for packaging quantity recommendations, parts availability dashboards, and forecasting tools for NPI parts with no historical data.
  • Designed solutions that enable real-time reporting and alerting for 132 global dealers by transitioning 43 SAS jobs and 1014 job schedules from the U.S.
  • Collaborated with IT to develop and implement new tools for NPI operations, including requirement gathering, testing, and user acceptance.

Junior Engineer

Flex
Chennai
10.2013 - 02.2017
  • Involved in operational planning, procurement tracking, and supporting supply chain functions for electronics manufacturing.
  • Created Bill of Materials (BOMs) and Manufacturing Change Orders in Agile for the engineering team.
  • Received raw BOMs from customer portals, transformed them into a user-friendly format, and prepared them for efficient loading into the ERP system.
  • Developed a validation tool to compare converted BOMs with the original to detect discrepancies and prevent loading errors.
  • Used Agile and BAAN systems for creating, reviewing, routing, tracking, releasing, and distributing documentation and engineering changes.

Education

Bachelor of Engineering (B.E.) - Electrical And Electronics Engineering

Thangavelu Engineering College
Chennai
05-2013

Higher Secondary (12th Standard) -

Thiru. Vi. Ka Higher Secondary School
Chennai

Secondary School (10th Standard) -

Thiru. Vi. Ka Higher Secondary School
Chennai

Skills

  • SAS programming
  • Basic R
  • Logistics management
  • Inventory planning
  • Forecasting
  • Problem solving
  • Decision making
  • Project management

Awards In Sports And Team Events

  • Carrom Winner, Q2 2024
  • Cricket Tournament Winner, Q2 2023
  • Cricket Tournament Winner, Q1 2018
  • ECL Cricket Tournament Winner, Q4 2019
  • Badminton Mixed Doubles (Runner-Up), Q3 2024
  • Badminton Men’s Doubles (1st Runner-Up), Q3 2024
  • Badminton Men’s Singles (2nd Runner-Up), Q3 2023
  • Badminton Men’s Doubles (2nd Runner-Up), Q3 2023

Achievements And Results

  • Received 4 promotions in 8 years: Started as a Material Availability Analyst in 2017, and currently serve as a Supply Chain Planning Engineer.
  • Awarded 'Partnering for Success' for developing the Packaging Quantity (PQ) program.
  • Received multiple 'Customer Experience' awards

for the parts availability tracking for NPI parts and NPI programs management

dashboard

for a SAS tool enabling PARS FD audit

  • Honored with 'Star performer'

for leading the new tool development for NPI operations project

for achieving key metrics and initiating seven continuous improvement ideas

  • Performance Rankings

Ranked in top 10 multiple times for continuous improvement:

9th in Q3 2021

8th in Q1 2022

6th in Q2 2022

8th in overall 2023

  • Impactful initiatives

Designed and implemented the Unsold Inventory Program, avoiding approximately $771K worth of excess inventory

  • Improved parts stocking KPIs

Achieved 98.6% serviceability of A and B class parts at facing DCs by GW6, year to date until October 2023

NPI parts stocking by GW6 reached 97.3% YTD till Oct 2023

Delivered 92.07% NPI service level year to date until October 2021, sustaining over 92% consistentlyly

Project Highlights

  • Global SAS Job Transition, Migrated 43 critical SAS jobs and over 1000 schedules impacting 132 global dealers. Enabled uninterrupted reporting, alerts, and process automations.
  • Packaging Quantity Recommendation Tool, Designed SAS-based program that recommends PQ for parts under specific criteria (≤2.5 lbs, ≤$5). Excludes 17 categories like CPI programs. Delivered ~5000 part recommendations.
  • Parts Availability Dashboard for NPI, Built a robust SAS system and dashboard to monitor >50 NPI programs daily. Supports >95% availability at launch.
  • Forecasting for NPI Parts, Developed algorithm to forecast demand for new parts by mapping them to similar historical hierarchies from 10 years of data.
  • New Tool Development for NPI Operations, Led requirement gathering, documentation, testing, and deployment in partnership with IT over 4 months.

Timeline

Supply Chain Planning Engineer

Caterpillar Inc.
02.2017 - Current

Junior Engineer

Flex
10.2013 - 02.2017

Bachelor of Engineering (B.E.) - Electrical And Electronics Engineering

Thangavelu Engineering College

Higher Secondary (12th Standard) -

Thiru. Vi. Ka Higher Secondary School

Secondary School (10th Standard) -

Thiru. Vi. Ka Higher Secondary School
RANJITH KUMAR A