Avilekh Chauhan

Experience

• 

  UltraTech Cement

  May 2018 - Jul 2018

  Process Engineer Intern

  - Studied and experimented on different Alterante Fuels and Raw materials used at GCW, Kovaya.- Made conclusions using analysis on the amount of Chloride and Sulphide which should be present in AFR to get the target Thermal Substitution Rate (TSR).

• 

  Capitol Regional Association, BITS Pilani

  Jul 2018 - May 2019

  Vice President

  -- Managed all the events that the association kept including Cultural Night, Grub, Association Farewell, and tours.-- Cultural Night is an event that our association started in my leadership period. The event was successful and led to an increase in over five times active members in our association. The annual grub had a participation of over 1000.

• 

  AlmaConnect

  Aug 2020 - Dec 2020

  Analytics Intern

  - Supported the network management team in delivering actionable insights to our clients, thereby, increasing overall customer satisfaction.- Spearheaded the backend operations of the Account Management Team, designed efficient processes for onboarding and query resolution, thereby, decreasing turnaround time by half.- Worked alongside the Product Management team and handled various client requests, diagnosed system issues and provided efficient solutions for the same to the technical team.- Executed data analysis requests for the entire portfolio of clients. Show less

• 

  Doubtnut

  Jun 2021 - Mar 2022

  Business Analyst

  -- A-B Testing ProjectWorked as an analyst on a A-B testing project which increased the impact metrics (KPIs) by over 50%.Used various analytical tools in the project such as SQL, Excel, Flagr, Apxor etc. Worked alongside the technical team to handle events analysis requirements from the product side.-- Lead Scoring ProjectWorked on a Lead Scoring Project potentially doubling the sales leads coming from BNB to almost double. The technical skills required for this project included Python, SQL and Excel. Used Logistic Regression with Hyperparameter Tuning to get the lead score based on various engagement and geographic factors.-- Member of the Analytics TeamResponsibilities included creation and updation of various tables. Advanced SQL Querying was used to do various retention and behavior analysis which were used as KPIs throughout different departments of the Organization. Show less

• 

  Dunzo

  Apr 2022 - Mar 2023

  Analyst - 2 (Business)

  -- Ownership of Availability Metric for the Procurement TeamStreamlined and Optimized the pre-existing dashboards with a 90% decrease in the TAT of dashboard refresh failures.-- Helped the procurement team for inventory planning and forecasting. Skills: Advanced SQL, Advanced Tableau-- Picker Metrics and Picker Simulation ProjectAnalyzed all the data related to Pickers, defined metrics and worked with the Store Operations team to create the Picker Metrics Dashboard and ran a picker simulation project in Python to optimize the Picker Count in stores saving around 50L per month for the organization. Skills required: SQL, Python(Numpy and Pandas) Show less

• 

  Lokal

  Mar 2023 - Feb 2024

  Business Analyst - Monetisation

  -- LTV/CAC analysis for profitability projectionsWorked on helping the team grow the LTV/CAC to 3 by optimizing costs without affecting the revenue growth. Helped save 60L per month in marketing costs. -- Supply Demand Model for acquisition strategy along with relevance growthWorked with the product and marketing team to redistribute the relevant responses per post so that median is not affected and cost per lead is managed more efficiently. Helped increase the cost per lead from 3 Rs to 8 Rs.-- Spearheaded a new CPM Model for better conversionHelped the sales team by creating a views assurance model due to paid increased conversion in the first pitch, thus helping in revenue growth. Show less

• 

  Juleo

  Feb 2024 - Aug 2024

  Senior Data Analyst (Founding Team)