Avinash Negi Email & Phone Number

India

India

India

Responsible for leading analytics projects with information consumers across multiple cities.Responsible for creating impact for Cars24 by applying diagnostic, predictive, and prescriptive analytics and developing impactful analytical solutions to solve business problems leveraging ML Algorithms with Python. Responsible for identifying opportunities, recommending and implementing analytical strategies to drive business impact (Revenue and margins).Understand the nature, structure, and… Show more Responsible for leading analytics projects with information consumers across multiple cities.Responsible for creating impact for Cars24 by applying diagnostic, predictive, and prescriptive analytics and developing impactful analytical solutions to solve business problems leveraging ML Algorithms with Python. Responsible for identifying opportunities, recommending and implementing analytical strategies to drive business impact (Revenue and margins).Understand the nature, structure, and quality of data,identify data issues, and send solutions.RELEVANT PROJECTS:- Car Health Score: Build XGBoost Classifier model, which gives the probability for the goodness of the inspected car based on the features associated with that car. This helped in reducing the losses by 20-30% as only profitable cars are being procured.- Optimized Assortment List: Build an optimization model which will take a forecast of sales and based on the sensitivity between sales and listing recommends the best-case scenario under constraints for the assortment of cars. This helped impact the margins by 5-12% and still growing.- Optimisation based Job Shop Scheduling: Build an optimisation model which can find the shortest possible ordering of cars for refurbishment which improved the throughput by 8-9%. Show less

India

Responsible to perform exploratory data analysis and hypothesis testing on the data and come up with the business case for the client.Responsible for developing machine learning models or statistical models for predictive analytics. Extraction, transformation, and visualization of data with the help of Python.Development of a dashboard on Excel and Jupyter Notebook for the client's side users to take decisions based on data.Responsible for gathering queries and feedback and… Show more Responsible to perform exploratory data analysis and hypothesis testing on the data and come up with the business case for the client.Responsible for developing machine learning models or statistical models for predictive analytics. Extraction, transformation, and visualization of data with the help of Python.Development of a dashboard on Excel and Jupyter Notebook for the client's side users to take decisions based on data.Responsible for gathering queries and feedback and converting the same into a use case along with delivery adoption.RELEVANT PROJECTS:Price Recommender: Build XGBoost Model for sales volume prediction and Optimization engine using Downhill syndrome leveraging Python resulted in a projected gain of 2% EBDITA gain. Trade Promo - -Optimization: Build a statistical model for identification of distribution for buying pattern at dealer level and allocation of dynamic dealer specific target slabs using Python resulting in a projected gain of 12 Cr. Rationalization of discount: Build a python-based dashboard for providing visibility of ongoing discount and Competitor prices at the SKU level for better negotiation which results in an annual gain of 3 Cr EBIDTA gain. Show less

Chennai, Tamil Nadu, India

Responsible for providing analytical solutions to the manufacturing process. Responsible for hypothesis testing and root cause analysis. Also involved in the identification, development, and implementation of statistical models and techniques that address the business challenge and add value to the organization.Responsible for interaction with clients for queries and delivery adoptionsData extraction, preparation, and transformation with the help of Python.Also responsible for… Show more Responsible for providing analytical solutions to the manufacturing process. Responsible for hypothesis testing and root cause analysis. Also involved in the identification, development, and implementation of statistical models and techniques that address the business challenge and add value to the organization.Responsible for interaction with clients for queries and delivery adoptionsData extraction, preparation, and transformation with the help of Python.Also responsible for developing the deck for sharing an insight to help them improve productivity and reduce energy.RELEVANT PROJECTS:Smart Dispatcher Tool: Developed a data-driven flask-based(Python) web app to recommend the optimized product pairing among the available product in the inventory for the testing machines in a manufacturing setup, as the testing was the bottleneck for the organization which helped the organization in realizing the volume gain of 7% ( 4.3 Million ) per week. Show less

Gurgaon, Haryana, India

Converted refrigeration system data into tangible insights with the help of supervised machine learning algorithms and physics-based modeling to improve the operational efficiency and efficacy of the refrigeration system.Develop, simulate, test, and improve the algorithm for predicting the power consumption and estimated load in the refrigeration system with varying boundary conditions.Effective utilization of MATLAB, Python, and Advanced Excel, VBA for data intelligence, and… Show more Converted refrigeration system data into tangible insights with the help of supervised machine learning algorithms and physics-based modeling to improve the operational efficiency and efficacy of the refrigeration system.Develop, simulate, test, and improve the algorithm for predicting the power consumption and estimated load in the refrigeration system with varying boundary conditions.Effective utilization of MATLAB, Python, and Advanced Excel, VBA for data intelligence, and analysis.Successfully served 100 supermarkets and helped them in achieving 10% energy- saving and reduction of maintenance costs by identification of premature failures through predictive and preventive maintenance.RELEVANT PROJECTS:Smart Refrigeration Solution (SRS) & Smart Building Management System (Smart - BMS): Worked with the team over the globe to develop a product for supermarket refrigeration to improve the efficiency and efficacy of the system which developed a regression and optimization model on Python which resulted in achieving an improvement in energy efficiency by 19% and increased the shelf life of the products in the refrigerated case by 27%.Predictive Maintenance Model for Air Handling UnitPredictive Maintenance Model for Chiller PlantEnergy Forecasting with optimization modeling for supermarkets for optimal operational set points Show less

Mumbai Area, India

Responsible for improving the PQCDSME improvement on the entire production line of the commercial A.C. & split A.C.Analyzing trends in Performance, identifying, and prioritizing areas for continual improvement. Implementing kaizens that can improve any of the PQCDSME.RELEVANT PROJECTS:OEE Improvement 6 Sigma Project: Achieved the improvement of the OEE of the Assembly line from 70% to 82% by identifying bottlenecks and improving their productivity which helped to improve the… Show more Responsible for improving the PQCDSME improvement on the entire production line of the commercial A.C. & split A.C.Analyzing trends in Performance, identifying, and prioritizing areas for continual improvement. Implementing kaizens that can improve any of the PQCDSME.RELEVANT PROJECTS:OEE Improvement 6 Sigma Project: Achieved the improvement of the OEE of the Assembly line from 70% to 82% by identifying bottlenecks and improving their productivity which helped to improve the production norms by employing statistical modeling and exploratory data analysis. Show less

Dehra Dun Area, India

Project: DRILLING RIG EQUIPMENT Project Mentor : R K Rawat , SE ONGC It was related to all the equipment present in "RIG" used for Drilling an oil well.