Ritesh Malakar
indore
Summary
Mechanical Engineering graduate with hands-on experience in heat treatment operations and industrial production processes. Skilled in process monitoring, quality control, and documentation. Additionally proficient in Advanced Excel, SQL, and dashboard reporting to support data-driven decision-making in manufacturing environments. Seeking a challenging role in production, maintenance, or plant operations
Overview
5
5
years of professional experience
1
1
Certification
Work History
Mis analyst
Mis Executive
indore
08.2024 - 09.2025
- Executed projects in sales management and HR dashboards using Power BI and Advanced Excel to enhance data visibility.
- Applied Python (NumPy, Pandas, Matplotlib) for machine learning and data analysis projects.
- Translated technical insights into actionable, data-driven decisions for stakeholders.
- Generated detailed reports utilizing advanced Excel functions and data visualization tools to support decision-making.
- Collaborated with cross-functional teams to gather reporting requirements and insights.
- Designed dashboards to track key performance indicators for management reviews, facilitating strategic discussions.
- Maintained documentation of reporting procedures and updates for process improvements.
Mechanical Junior Engineer - Heat Treatment Department
Indo Chains
Raipur
08.2020 - 05.2022
- Operated and supervised heat treatment furnaces for industrial chains, ensuring material strength and quality.
- Monitored process parameters like temperature, hardness, and quenching cycles to maintain production standards.
- Coordinated with quality and production teams to optimize efficiency and reduce downtime.
- Ensured adherence to safety protocols and maintained process documentation.
Education
B.TECH - Mechanical
01.2020
Skills
🛠Technical Skills
Mechanical Skills
Heat Treatment Process
Production Monitoring
Quality Inspection
Process Documentation
AutoCAD
MIS / Analytical Skills
Advanced Excel (Pivot Table, XLOOKUP, Dashboard)
SQL (Basic Queries, Data Extraction)
Power BI (Dashboard Creation)
MS Office
Certification
• Autodesk Bhilai (AutoCAD)
• Data analysis certification, Cognitive Class (IBM SKILLS NETWORK)
• Programs Point Indore
• Data analysis certification, Cognitive Class (IBM SKILLS NETWORK)
• Programs Point Indore
Projects
- Sales Report Dashboard, Collaborated with clients to gather requirements and define business KPIs for sales analysis., Ensured data integrity and accuracy using Excel tools such as Data Validation, Conditional Formatting, and PivotTables., Designed dynamic dashboards using PivotTables, Pivot Charts, and Slicers to visualize key sales metrics., Used formulas like VLOOKUP, INDEX-MATCH, SUMIFS, IF, and COUNTIFS to transform raw data into actionable insights., Delivered an interactive dashboard with clearly formatted visuals and summaries to support business decision-making.
Hobbies and Interests
- Fitness and strenght training
- Swimming
- Reading technical articles
- Exploring new industial technologies
Personal Information
- Date of Birth: 10/24/1997
- Nationality: Indian
- Marital Status: unmarried
Timeline
Mis analyst
Mis Executive
08.2024 - 09.2025
Mechanical Junior Engineer - Heat Treatment Department
Indo Chains
08.2020 - 05.2022