Ranjan Shivakumar
Mandya
Summary
Detail-oriented master data analyst with 8+ years of experience supporting automotive parts inventory control. Strong database management and SQL skills used for pricing analysis, data validation, and accuracy improvements. Advanced Excel and ERP system experience used to streamline inventory control workflows.
Overview
9
9
years of professional experience
Work History
Product Master Data Analyst
LKQ India Pvt Ltd
Bengaluru
01.2024 - Current
- Expertise and extensive knowledge in aftermarket OEM automotives and RVs marine parts.
- Hands-on experience in cataloging automotive spares.
- Delivered data for B2B customers from the database using SQL, ensuring alignment with customer templates.
- Product feature enrichment and SKU management supported cleaner product records.
- Pricing analysis and building retail description for customers.
- Scrapping data and digital assets rom the supplier website.
- Reviewed data requests and routed approvals through internal workflows
- Coordinated with operations, finance, and procurement teams on data issues
- Created complex SQL queries to identify patterns in master data.
- Developed AI agents to automate processes and support AI implementation where possible.
- Proposed innovative ideas and solutions that improved team collaboration and project results.
Inventory Analyst
LKQ India Pvt Ltd
Bengaluru
01.2024 - 12.2025
- Updated master data for SKUs, locations, and inventory transactions.
- Reviewed data from sales trends and market conditions to guide stocking levels.
- Tracked product usage history to set minimum and maximum inventory levels.
- Monitored inventory based on sales trends and inventory value.
Inventory Manager
JSP Autocore Pvt Ltd
Bengaluru
05.2023 - 12.2023
- Supported inventory control procedures that improved part tracking and reduced location time through part number and location updates.
- Reviewed sales trends using ABC and FSN methods to align workshop activity with customer needs.
- Prepared management reports to support business decisions and planning.
- Maintained product availability by coordinating timely stock replenishment.
- Reviewed inventory trends and sales data to estimate future stock needs and prevent overstock situations.
- Matched physical counts to ERP inventory records.
- Performed stock audits through random checks, periodic checks, 100% counts, and aging and movement analysis.
- Completed cycle counts on regular basis to keep inventory records accurate.
- Took part in annual physical inventories at multiple locations.
- Handled damaged goods claims and back orders to reduce financial impact.
- Trained staff on proper receiving, processing, and stocking procedures.
- Monitored slow-moving and fast-moving auto components in storage.
- Negotiated vendor contracts while maintaining cost control and compliance with company policies.
- Contributed to supply chain optimization projects to lower costs and improve inventory turnover.
Assistant Inventory Manager
PPS Automotive solutions Pvt Ltd
Banglore
06.2021 - 04.2023
- Monitored inventory levels to ensure stock availability and informed purchasing decisions.
- Managed inventory and warehouse activities using 5S methodology.
- Communicated product availability and backorder details to team members to ensure alignment on inventory status.
- Supported order fulfillment and business development initiatives to enhance parts operations.
- Prepared 9-box analysis for improved inventory management.
- Prepared and distributed business reports to provide insights for strategic planning.
- Provided customer service support by addressing inquiries and resolving issues to enhance customer satisfaction.
- Prepared presentation materials and review sheets for team meetings.
- Received incoming materials against invoice records.
Inventory Incharge
JSP Ford Pvt Ltd
Banglore
08.2017 - 02.2023
- Tracked inventory to align stock levels with sales trends.
- Monitored aging spare parts to optimize stock control and reduce excess inventory.
- Reviewed catalogs to identify new market parts and emerging trends.
- Communicated PNA and BO details to the team to ensure alignment.
- Checked shipments against receipts and guided customers on selecting appropriate parts for projects.
- Prepared and shared business reports.
Education
High School Diploma -
Board of Technical Education
ChannapatnaSkills
- Inventory control
- Master data management
- Inventory forecasting
- Vendor coordination
- SQL database management
- Pricing analysis
- Market trend analysis
- Advanced Excel
- Application packager: Auto deal, Incadea, Dealer management system, Citroen DMS, dealer parts operation system (Hyundai & KIA), Parts E-catalogue, microcat, Service box
- Application packager: Auto deal, Incadea, Dealer management system, Citroen DMS, dealer parts operation system (Hyundai & KIA), Parts E-catalogue, microcat, Service box
- ACES and PIES preparation
- Office software proficiency
- Customer relationship management
- Leadership quality
Timeline
Product Master Data Analyst
LKQ India Pvt Ltd
01.2024 - Current
Inventory Analyst
LKQ India Pvt Ltd
01.2024 - 12.2025
Inventory Manager
JSP Autocore Pvt Ltd
05.2023 - 12.2023
Assistant Inventory Manager
PPS Automotive solutions Pvt Ltd
06.2021 - 04.2023
Inventory Incharge
JSP Ford Pvt Ltd
08.2017 - 02.2023
High School Diploma -
Board of Technical Education