Rachit Agarwal

Experience

• 

  RCS Tech LLP

  Jul 2018 - Jan 2019

  Application Support Analyst

  Roles and Responsibilities• Identity and Access management of cross-platform applications Okta, Zoom, Quip, Zscaler & Box.• Deployed Workspace one, Single Sign-On and Multi-factor authentication• Administering and maintaining the Airwatch Installation and configuration• Delivers client satisfaction through high levels of support and issue resolution• Understood and demonstrated hands-on experience configuring, administering, maintaining, managing, and troubleshooting system applications• Ensure tasks are completed in line with the SLA’s/KPI’s Show less

• 

  Wipro Limited

  Jan 2019 - Sept 2019

  Administrator

  Roles and Responsibilities• Identity and Access management of cross-platform applications Okta, Zoom, Quip, Zscaler & Box.• Deployed Workspace one, Single Sign-On and Multi-factor authentication• Administering and maintaining the Airwatch Installation and configuration• Delivers client satisfaction through high levels of support and issue resolution• Understood and demonstrated hands-on experience configuring, administering, maintaining, managing, and troubleshooting system applications• Ensure tasks are completed in line with the SLAs/KPIs Show less

• 

  The Sparks Foundation

  Dec 2020 - Jan 2021

  Data Science & Business Analyst

  • Performed Tasks on Regression, Classification, Clustering Problems & Visualization of the Decision Tree using Python. • Used Pandas, NumPy, Seaborn, and Scikit-learn (Sklearn) library for building and evaluating the models.• Exploratory Data Analysis on Sample Superstore Data using Tableau.

• 

  Widhya

  Jan 2021 - Feb 2021

  Machine Learning Engineer

  Performed Covid19 Analysis, Bitcoin Price Prediction, Flight Delay Prediction, Instagram Post reach Prediction & Stock Price Prediction using the Pandas, NumPy, Math, Scikit-learn (Sklearn) Libraries.

• 

  MedTourEasy

  Jan 2021 - Feb 2021

  • Completed various Tasks on Analyzing Social Media (Twitter) data in Python using Pandas & Matplotlib libraries.• Extracted the names, hashtags, retweet count, likes and found the frequency of the names and the hashtags used.• Analyzed the used languages, found that most of the tweets were in English, followed by Polish, Italian, Spanish, and so on. • Completed various Tasks on Fitness tracker data such as visualizing the trend in the running pattern, many times did the user reach the goal.• Libraries used were Pandas, Seaborn & Matplotlib. • Completed various Tasks on American Sign Language data to understand.• Used Keras library to build a Convolution Neural Network to classify the data.• Accuracy on the Test data was 93.5%

  • Marketing Analyst

    Feb 2021 - Feb 2021

  • Data Scientist

    Jan 2021 - Jan 2021

  • Machine Learning Engineer

    Jan 2021 - Jan 2021
• 

  Cartesian Consulting

  Apr 2021 - Mar 2023

  Data Analyst

  • Built Time Series Model using SARIMA, ARIMAX to forecast the quarterly sale of different SKUs and territory combinations using Python.• Perform EDA using SQL & Python on the different Apparel brands for customer acquisition, retention & Business Performance.• Deep dive analysis of the data using SQL & R.

• 

  Robosoft Technologies

  Mar 2023 - now

  Senior Data Analyst

  • ChatGPT-Powered Store Insights – Leveraged ChatGPT for sales analysis, improving inventory optimization by 20%, boosting top-product sales by 10%, and reducing unsold inventory by 15%.• Store Exception Reporting – Automated fraud detection, cutting fraudulent transactions by 10%, improving revenue accuracy by ₹1M/month, and enhancing transaction monitoring efficiency by 30%.• Automated SKU Reporting – Built AWS Sage Maker (Python) & Redshift,reducing manual effort and enabling the team to focus on deeper analysis. Improved decision-making for inventory and sales strategies. • Using Sentiment Analysis, identify the segments(Pricing, Product Quality) for different products, which led to a Price cut of 40% (Frames) and growth of 5% in Repeat Customers.• Optimized new product placement strategy by creating clusters with PCA and kmeans+. Identified clusters by assessing assortment group performance (with key metrics: sale per actual store and sales velocity), for each cluster, prioritizing stores within clusters based on the SKU breadth and sales depth of AGs• Implemented logic and automated a Contact Lens replenishment campaign, with incremental revenue ₹ .2 million/month• Advocated and identified the opportunity for conversion of a partial solution (lens-only and frame-only) to a comprehensive full solution (spectacles), resulting in an incremental revenue of ₹ 24 million/month• Led and aided in the decision to eliminate Birthday and Anniversary discounts, saving cost of ₹ 4 million per month Show less