Deepak Panhotra

• Aspiring Data Analyst with strong practical experience in data transformation, cleaning, organization, and visualization using Excel, Power BI, and SQL alongside Python.
• Proficient in detecting and resolving data inconsistencies to enhance data accuracy and generate actionable insights.
• Completed multiple data projects, including

Expresso Store dataset analysis

Employee and Department Data Analysis

Sales Data Case Studies

Product Data Analysis

Starbucks Data Analysis

• Skilled in creating visual representations and dashboards in Power BI to support data-driven business decisions.
• Currently developing advanced analytical skills through Internshala’s Data Science program, focusing on hands-on applications with Excel, Power BI, and SQL for industry-relevant scenarios.
• Translated cost and benefits of machine learning technology for non-technical audiences.
• Created data visualization graphics, translating complex data sets into comprehensive visual representations.
• Applied appropriate data science techniques to solve business problems.
• Created data mining architectures and models to identify trends in large data sets.

Projects as a PLC Programmer (Data Analytics Integration)

• E-15 Power Train Optimization at Maruti
  Optimized power train processes using PLC programming and data analytics to monitor performance metrics and production efficiencies, with a focus on machine data integration.
• Production Support at Suzuki Motors
  Provided real-time production support by analyzing machine and system datasets to enhance operational performance, reduce downtime, and support data-driven maintenance decisions.
• YED Door Line Optimization at Suzuki Motors
  Improved door line production processes through data-driven insights derived from machine operation datasets, ensuring consistency and efficiency in the production line.
• YY8 Back Door at Suzuki Motors Gujarat
  Integrated PLC systems with data analytics to oversee back door production, leveraging datasets to monitor quality control, reduce errors, and optimize production workflow.
• YTB RWR Cell Integration at JBM Vithlapur
  Streamlined cell integration processes by utilizing production and machine data, enhancing automation performance, and ensuring smooth data flow across integrated systems.
• Leakage Test Machine SPM Integration
  Implemented and integrated PLC systems in Leakage Test Machines, using collected datasets for quality control analysis and ensuring compliance with operational standards.