Romil Sureshkumar Jethava
Duisburg
Summary
Results-driven supply chain and data analyst with extensive experience in logistics, inventory management, and process optimization. Proficient in leveraging advanced tools such as Locker Studio, Power BI, SQL, and SAP to enhance operational efficiency and improve supply chain visibility. Committed to fostering continuous improvement and automation initiatives that streamline decision-making processes while effectively reducing costs. Recognized for a strategic approach that aligns data analysis with business objectives to drive impactful results.
Overview
5
5
years of professional experience
Work History
Intern in field of Supply Chain Data Analyst: Load Carriers
Mercedes Benz AG
09.2023 - 10.2024
- Inventory analysis with multiple data set and software (save 30 % time to manage inventory space)
- Managed purchase orders of Load carrier and supplier coordination.
- Oversaw warehouse, stock, and delivery operations.
- Supply chain communication with inventory managers suppliers, warehouse teams, logistics partners, and internal stakeholders
- Data cleansing & analysis for performance optimization
- Prepared supply chain documents and performance reports, KPI and dashboards
- Clean, prepare structure, and analyze datasets for Supply Optimizations teams
- Monitored supplier performance and escalated issues in case of delivery issue of Load carrier
- Drive continuous improvement of data quality for reliable delivery of load carrier
- Optimization of load carrier utilization (improve 6-8% utilization than earlier)
- KPI tracking, Reporting and analyze regional supply chain processes focused on delivery (18-20% improvement on past due )
- Collect and communicate data requirements from Supply Optimization departments
- Advocate for data quality and consistency, ensuring models and reporting are accurate, well documented, and easily understood, Data pipelines & database maintenance
Business analyst
NIEC Immigration & Visa Consultants
08.2019 - 06.2021
- Market monitoring & revenue/margin reporting (Google Sheets, Looker Studio)
- Building and refining systems to improve efficiency across the business.
- Conversion tracking with Google Tag Manager (Google Ads, Meta, LinkedIn)
- Prepare reports, simulations, and presentations for stakeholders, including result tracking
- Support integration of solutions into global reporting, data analytics, and IT architecture
- Campaign analysis & A/B testing (Google Analytics) to save 27% unnecessary investment on marketing
- Enable data-driven decision-making with high-quality insights and strategic advice
- Align data and analytics strategy with business and optimization goals
- Real-time dashboards & automated reports (Looker Studio) (save 70% time to make same report each time)
- Risk assessment, predictive analytics & performance marketing
- Profitability analysis with KPIs & dashboards (Looker Studio) (save 50-60% time on statistics number)
- Interactive KPI dashboards (products, leads, performance)
- Industry, competitor & macroeconomic research
- Statistical analysis for revenue growth & cost reduction
Education
Master of Engineering - Technical Logistics
University of Duisburg-Essen
Duisburg, Germany09.2025
Bachelor of Engineering - Mechanical engineering
Gujarat Technical University
India12.2018
Skills
- SAP S/4HANA
- Ms Office,Power BI, Tableau, Excel VBA, Microsoft Project
- Outlook, SharePoint, Teams
- MySQL, Python, Power Automate
- AutoCAD, SolidWorks, Tecnomatix Simulation, NX-Siemens, Dosimis-3
LANGUAGES
English
Native or Bilingual
German
Professional Working
Gujarati (native language)
Native or Bilingual
Hindi
Native or Bilingual
Timeline
Intern in field of Supply Chain Data Analyst: Load Carriers
Mercedes Benz AG
09.2023 - 10.2024
Business analyst
NIEC Immigration & Visa Consultants
08.2019 - 06.2021
Bachelor of Engineering - Mechanical engineering
Gujarat Technical University
Master of Engineering - Technical Logistics
University of Duisburg-Essen
PROJECTS
04/2024 - 10/2024 master's thesis in field of Supply Chain planning: Dynamic Delivery Schedule Using Power BI, Power Automate, and Advanced Excel VBA at Mercedes- Benz AG Bremen, Germany ,
- Creating a dynamic Excel sheet regarding delivery delays considering the calendar week., Connecting Excel data to Power BI and creating a dashboard.
- Send email automatically notification via Excel VBA to delivery partner in form of HTML table via Outlook
09/2023 - 03/2024 Case study: Data analysis of Marine Time transport,
- Optimization of transport costs and delivery times in maritime transport while taking environmental concerns into account by reducing fuel consumption and emissions,
- Use of real-time data and advanced analytics with the help of Python.
07/2017 - 10/2017 bachelor's thesis on Hydrogen Engine,
- Create one hydrogen cell and combine it with IC Engine and run on blend of hydrogen Fuel and petrol
HOBBIES
- Data analysis using various software, Cricket, Yoga