Harsh Agarwal

I'm passionate about

Sept 2024 – Nov 2024

Analyzed production and quality data from sensor systems in battery manufacturing, performed statistical tests such as ANOVA and regression to identify trends and optimize processes.
Developed a control chart dashboard to monitor production, enabling data-driven decision-making that improved product quality and operational efficiency.
Developed automated daily reports for Key Production Indicators (KPIs) covering Quality and Production, enhancing data granularity for management and enabling actionable insights through real-time monitoring.

May 2024 – Aug 2024

Developed a predictive model for forecasting defect appearances with 77% accuracy using intermittent demand forecasting methods (TSB) after traditional time series models (ARIMA, SARIMA, Prophet, LSTM) proved less effective.
Automated the categorization of defect types and root causes by building a Generative AI workflow using Retrieval-Augmented Generation (RAG) on Llama 3, addressing the challenge of undefined categories in the data.
Created an interactive Streamlit webpage for visualizing the predictive model, ensuring easy access and interpretation for stakeholders, and implemented hierarchical reconciliation for consistent results across different data levels.

Dec 2021 – July 2023

Built data and reporting infrastructure using Oracle Analytics Cloud, empowering data-driven product decision-making with real-time insights.
Designed and developed impactful data visualizations using SQL and Tableau, enabling the monitoring and optimization of key performance indicators (KPIs)

Aug 2021 – Nov 2021

Developed a functional Airline Reservation System using SQL & OAC as a part of internship project, demonstrating proficiency in leveraging technology for product development and optimization.
Conducted Tableau training sessions for over 75 team members, elevating the data visualisation competency within the organization and fostering a culture of continuous learning and improvement.

Aug 2020 – July 2021

Engaged with Founders and CXOs of prominent startups, including Makers of Milkshake, Donate Kart, MyGate, Wehouse, gaining valuable insights into products and strategies.
Conceptualized and designed Minimum Viable Products (MVPs) in alignment with coherent business strategies, emphasizing the importance of product viability and user-centric design.

May 2019 – June 2019

Collaborated with cross-functional teams to streamline warehouse management processes, resulting in a 20% reduction in carrying costs while maintaining optimal stock levels.
Participated in the planning and execution of demand forecasting activities, contributing to improved accuracy and efficiency in procurement processes.