Rohit Dehariya
Data Analyst/Analyst
Pune,MH
Summary
Analytical and results-driven Data Analyst with a background in logistics and supply chain operations. Skilled in extracting, cleaning, and analyzing large datasets using SQL, Python, Excel, and Power BI to support data-driven decision-making. Proven ability to develop dashboards, monitor key performance indicators (KPIs), and deliver actionable insights to improve operational efficiency and reduce costs. Strong collaborator with experience working across teams to transform business requirements into meaningful reports and visualizations. Eager to contribute to data-centric teams and help drive business growth through analytics.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Senior Logistics Officer , Analyst
Lloyds Metals & Energy Ltd
05.2025 - Current
- Extracted, transformed, and analyzed large datasets related to logistics operations using SQL and Excel.
- Built Power BI dashboards to visualize dispatch trends, route efficiency, and vehicle turnaround time.
- Collaborated with dispatch teams and management to monitor key KPIs (dispatch time, truck idle time).
- Automated daily reporting processes, reducing manual work by 60%.
- Identified data anomalies and provided insights that led to a 10% improvement in dispatch efficiency.
Management Trainee
Lloyds Metals & Energy
01.2024 - 05.2025
- Collected, cleaned, and analyzed logistics data related to the transportation of iron ore via road and rail.
- Created Excel and Power BI dashboards to track key metrics, such as delivery times, route efficiency, and cost per shipment.
- Conducted data analysis to identify delays, bottlenecks, and cost-saving opportunities in the supply chain.
- Automated daily and weekly reports for management to support real-time decision-making.
- Collaborated with cross-functional teams to gather business requirements, and convert them into data reports and visualizations.
- Monitored compliance and safety data, ensuring adherence to industry standards through regular reporting and analysis.
- Maintained and updated transportation datasets to ensure accuracy, consistency, and usability for reporting purposes.
- Worked with clients, suppliers, and carriers to collect logistics data, and improve transparency across operations.
Education
MBA -
Ballarpur Institute of Technology
04.2001 -
Bachelors of Commerce -
Gondwana University
04.2001 -
Skills
Technical Skills
Certification
Data Analyst By CoachX
Timeline
Senior Logistics Officer , Analyst
Lloyds Metals & Energy Ltd
05.2025 - Current
Management Trainee
Lloyds Metals & Energy
01.2024 - 05.2025
MBA -
Ballarpur Institute of Technology
04.2001 -
Bachelors of Commerce -
Gondwana University
04.2001 -
Similar Profiles
CHITTARANJAN GIRICHITTARANJAN GIRI
Assistant Manager at Lloyds Metals Energy Limited.Assistant Manager at Lloyds Metals Energy Limited.
Piyush KumarPiyush Kumar
DY. Manager - Process Engineering at Lloyds Metals & Energy LimitedDY. Manager - Process Engineering at Lloyds Metals & Energy Limited
Sagar KararaSagar Karara
Deputy Manager - Accounts and Direct Taxation at Lloyds Metals And Energy LimitedDeputy Manager - Accounts and Direct Taxation at Lloyds Metals And Energy Limited
Milind PatilMilind Patil
Senior Software Engineer at Netcracker Technology SolutionsSenior Software Engineer at Netcracker Technology Solutions
RUBINA JAMADARRUBINA JAMADAR
Senior Software Consultant at CapgeminiSenior Software Consultant at Capgemini