Mohit Yadav
Dubai,Dubai
Summary
Accomplished professional with expertise in advanced Excel formulas, Power Query in Excel, and Google Sheet automation. Proficient in Google Apps Script, Google App Sheet, and Power BI dashboards. Skilled in Looker Studio, basic SQL, and JavaScript for data analysis and ERP development. Adept at process automation, project management, and sales analysis. Demonstrated ability in workflow optimisation, team leadership, problem-solving, business development, presentation skills, business analysis, solution implementation, strategic development, planning and execution. Experienced in debugging techniques and proficient in database design. Committed to leveraging technical skills to drive business growth and operational efficiency.
Overview
8
8
years of professional experience
4029
4029
years of post-secondary education
Work history
Data/Production Analyst & BA Manager
Italent India Management Consultant Pvt. Ltd
Nagpur, India
2023.02 - 2026.01
- Developed ERP system using Google Sheets.
- Created automated production system process in Google Sheets or Excel, from orders to dispatch.
- Analyzed sales data and identified trends using Excel PivotTables and Power Query.
- Developed Logistics Payment And Vehicle Tracking System
- Automated scorecards and MRM reports in Google Sheets.
- Developed a procurement system in Google Sheets for requisition, purchase orders, and inventory management.
- Created appraisal form in Google Sheets for over 400 employees, and conducted appraisals through the system.
- Developed order tracking system and dashboards in Looker Data Studio.
- Created a task management system for assigned employees, with auto-email notifications and dashboards in Google Sheets and Looker Studio for management.
- Used Google Apps Script and HTML for the automation of workflows.
- Automated KRA and KPI scorecards.
- Implemented attendance system using Google Forms, with a barcode scanner.
- Developed a project management Gantt chart system.
- Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
- Enhanced business operations by developing custom data models.
- Identified trends in data to help inform decision-making processes.
- Analysed patterns in large volumes of data, provided key insights.
- Created interactive dashboards using Power BI for easy data interpretation and presentation.
- Collaborated cross-functionally to meet project deadlines, delivered consistent results.
- Optimised data systems efficiency through regular system audits and updates.
- Utilised SQL to extract relevant information for reporting purposes.
- Improved data quality by implementing structured validation checks.
- Collected and analysed complex datasets for business strategy enhancement.
- Developed comprehensive spreadsheets for easy tracking of payments received and outstanding balances.
- Used innovative technologies to drive process improvement.
- Developed advanced automation solutions by analysing and understanding client needs.
- Streamlined tasks, resulting in significant time savings.
Lab Technician/MIS Reporter
John Deere India Pvt.Ltd
Pune
2022.02 - 2023.01
- Daily MIS reporting.
- Shift scheduling.
- Manpower Handling
- 5s Development
- Developed and validated new analytical techniques to support research projects.
- Developed standard operating procedures (SOPs) for laboratory experiments.
- Conducted quality control tests and troubleshooting to ensure accuracy and reliability of test results.
- Generating reports for new models.
- Working on Kaizen and safety initiatives.
Trainee Supervisor & Transmission Tester & MIS Reporter
Mahindra & Mahindra Pvt. Ltd
Nagpur
2018.03 - 2021.11
- Handling manpower in testing, rework, and dispatch areas.
- Taking stock reports at the end of the shift.
- Performing final functional testing of transmissions.
- Maintaining line production.
- Conducting daily audits of transmission losses, as per plan.
- Conducting daily audits of transmission rejections from testing.
- Updating daily manpower absenteeism records.
- Identifying and reporting defective parts or components to the supervisor to ensure quality products.
- Ensuring adherence to Standard Operating Procedures (SOPs).
- Working on PQCDSM (Productivity, Quality, Cost, Delivery, Safety, Morale).
- Maintaining Daily Production Report (DPR) and RPH card.
- Analyzing rejections using seven QC tools.
- Assisted with training new employees on company policies and procedures.
- Worked alongside senior team members to learn related job tasks and roles.
- Attended training sessions and meetings to learn new information and develop personal skills.
Education
Diploma - Maharashtra State Board Of Technical Education
SMPP
NagpurHigh School - 10th
Maharashtra State Board
NagpurMS-CIT - Maharashtra State Certificate In Information Technology
S.R Computers
Nagpur 2012.03 - 2012.06
Diploma - Advance Diploma In Computer Science
Maharashtra
India 2011.03 - 2011.06
Skills
- Advanced Excel formulas
- Power Query In Excel
- Google Sheet automation
- Google Apps Script
- Google App Sheet
- Power BI dashboards
- Looker Studio
- Basic SQL
- Basic JavaScript
- Process automation
- Project management
- Looker Data Studio
- Workflow optimization
- Team leadership
- Problem solving
- Presentation skills
- Planning and execution
- Debugging technique
- Proficient in database design
Languages
English
Upper intermediate
Hindi
Native
Training
- Basic to Advanced Excel Formula
- Power BI
- Google Mastery Course
- ChatGPT To Improve Productivity
- Basic SQL
- Six Sigma Yellow Belt
- Data Visualisation In Looker Studio
Disclaimer
I Mohit Yadav, hereby declare that the information provided here by me is true to the best of my knowledge.
Timeline
Data/Production Analyst & BA Manager
Italent India Management Consultant Pvt. Ltd
2023.02 - 2026.01
Lab Technician/MIS Reporter
John Deere India Pvt.Ltd
2022.02 - 2023.01
Trainee Supervisor & Transmission Tester & MIS Reporter
Mahindra & Mahindra Pvt. Ltd
2018.03 - 2021.11
MS-CIT - Maharashtra State Certificate In Information Technology
S.R Computers
2012.03 - 2012.06
Diploma - Advance Diploma In Computer Science
Maharashtra
2011.03 - 2011.06
Diploma - Maharashtra State Board Of Technical Education
SMPP
High School - 10th
Maharashtra State Board