Sandeep Devra

I am a Data Analyst with expertise in data collection, data analysis, cost estimation, and project reporting using Excel, SQL and Power BI. I have completed an Advanced Certification in Data Science from UpGrad Offline Centre, gaining proficiency in Python, SQL, Power BI, and Tableau, and actively leveraging data analytics to enhance project insights and decision-making.

Data Analyst at Electro-Tech Transmission Pvt. Ltd. (2026-03 – Present)

• Manage and analyze production data through IMS, PMS, and FMS using Excel, Power BI, and Google Sheets.
• Develop automated MIS reports and dashboards to track production, inventory, material flow, and operational KPIs.
• Monitor production processes, identify bottlenecks, and provide data-driven insights to improve efficiency.
• Maintain and validate master data, inventory records, and production reports for accurate decision-making.
• Collaborate with Production, Stores, Quality, and Planning teams to streamline workflows and optimize operational performance.

MIS Analyst at Swastik Coal and Logistics Pvt. Ltd. (2025-03 – 2026-02)

• Maintain and manage large datasets related to fleet operations using Excel, SQL, and Power BI.
• Prepare and circulate automated daily trip reports covering dispatch, delivery status, and fuel consumption.
• Track and analyze real-time GPS data to monitor truck locations, route adherence, and idle times.
• Record and monitor expenses including diesel, AdBlue, toll tax, driver allowances, and maintenance costs.
• Design and maintain Power BI dashboards to visualize KPIs like fuel efficiency and trip performance.
• Maintain a detailed vehicle master with EMI schedules, RTO details, insurance, and service history.
• Analyze operational data to identify cost-saving opportunities and optimize route planning.
• Evaluate driver performance using trip data and calculate monthly salaries and incentives.
• Coordinate with over 10 camps across India to collect, verify, and validate operational data.
• Recommend and implement data-driven process improvements to reduce costs and improve efficiency.

Junior Data Analyst at Versatile Prime Infosoft Pvt. Ltd (2024-01 – 2025-02)

• Analyze and manage large datasets using Advanced Excel (Pivot Tables, VLOOKUP).
• Write complex SQL queries for data extraction, manipulation, and reporting.
• Design and maintain Power BI dashboards for real-time data visualization.
• Create interactive reports and charts in Tableau for business insights.
• Optimize database performance and ensure data accuracy using SQL indexing and joins.
• Develop KPI dashboards in Power BI and Tableau for data-driven decision-making.
• Generate ad-hoc reports using Excel, SQL, and Power BI for management insights.
• Integrate and blend data from multiple sources in Power BI and Tableau for advanced analytics.

Data Analyst Intern at MentorMind (2024-07 – 2024-12)

Internship Provided by Upgrad from CIE at IIIT Hyderabad in collaboration with MentorMind

Post Graduate Diploma in Management in Management – Sapphire Institute of Business Management (2016-07 – 2018-06)

Bachelor of Engineering in Engineering – Rajiv Gandhi Prodoyogiki Vishwavidyalaya (2011-07 – 2015-06)