Ashish Solanki Email & Phone Number

Gurugram, Haryana, India

1. Analyzed data from different production sources and provided data analysis to improve the current process by identifying and eliminating the pitfalls in existing systems.2. Spearheaded complex structured and unstructured data analysis initiatives using SQL and Python to define and document key performance indicators (KPIs),driving business insights resulting in a $1.4 million impact.3. Implemented defect detection in manufacturing parts using Convolutional Neural Networks (CNN) and computer vision techniques to automatically identify defects, leading to reduction in defects in manufactured parts by 14%.4. Created optimization and predictive models using Python to forecast equipment failure and optimized maintenance schedule leading to reduction in downtime by 12 % and maintenance cost by $ 1.1 million. 5. Incorporated Internet of things (IOT) in production facility for data collection and management from shop floors using SQL and provided data insights of production process using Tableau. 6. Project in-charge for production of new engine models in assembly line including end to end strategy planning, scheduling, process engineering and execution of new mass production capacity worth more than $65 million.7. Developed and implemented machine learning models, including Random Forest, to analyze process variables to diagnose faults and identify root causes in systems, leading to accurate issue diagnosis and implementation of corrective actions.8. Conducted in-depth analysis of business systems for potential process development and recommended business processes re-engineering to senior leaderships and stakeholders to drive end to end process optimization.

Gurugram, Haryana, India

1. Led cross-departmental communication with production, global suppliers, and Operations to make business decisions of material planning, process optimization, and project execution for improvement in production quality and capacity.2. Studied daily production trends of engine plants to identify production variation and pitfalls, identifying the scope in production improvement . Analysis helped to plan numerous preventive maintenances to reduce defects and rework. 3. Developed culture of using dynamic and real time dashboards to track production volumes, production efficiency, energy consumption and machine performance.4. Designed robust data pipelines for ETL processes, extracting data from diverse sources into Azure SQL and Azure Data Lake Storage & Integrated PowerBI with Azure Data factory for data wrangling and visualization.5. Developed and implemented data collection infrastructure for 3+ manufacturing facilities and developed product tracking system to ensure monitoring at every stage of process to eliminate defects by 14%.6. Led cross-functional collaboration of data science, global suppliers, and operations for improvement in production quality and capacity, leveraging data-driven insights to minimize production loss by 12%.7. Design, plan and document the processes and requirement for the development and implementation of system enhancements and the introduction of new systems and standards.

Gurugram, Haryana, India

1.Worked with clients to understand the business needs and transverse those needs into actionable reports in Tableau, saving 20+ hours of manual work in each week.2. Attended trainings in different verticals to get overview of goals, challenges, working methodology of logistics, supply chain, quality and research & development and understood the operating standards and working of cross functional team.

Master'S Degree, Business Analytics

Bachelor Of Technology - Btech, Mechanical Engineering, 8.83/10

Activities and Societies: Automotive club