Arpit Bansal

Experience

• 

  TechCiti Technologies Private Limited

  Aug 2020 - Sept 2020

  Software Developer Intern
• 

  MedTourEasy

  Oct 2020 - Nov 2020

  Data Analyst

  Blood Donations Prediction: Leveraged TPOT, an Automated Machine Learning tool, to predict blood donation likelihood based on Recency, Frequency, and Monetary (RFM) factors, using Python.

• 

  The Design Cart

  Feb 2021 - May 2021

  Data Analytics & Operations Intern

  - Utilized Python for data cleaning to thoroughly analyze sales performance across categories, areas, and vendors.- Leveraged Tableau for Cohort Analysis, evaluating customer loyalty and retention trends to guide strategic decision-making.

• 

  The Smart Cube

  Aug 2021 - now

  Market Mix Modelling for a CPG company based out of Europe• Proposed Media Spend Reallocation, driving €39.4K Revenue Growth and Achieving 8% ROI Increase.• Constructed Market mix models and evaluated the performance of various media channels, price, and promotion, as well as the influence of COVID-19 utilizing Python libraries like scikit-learn, pandas, numpy, etc.• Crafted multivariate regression models to gauge the impact of levers on volume sales, evaluating the effectiveness of media execution, and determining returns for a global beverages and snacks company.• Formulated secondary models for thorough examination of media executions, computing ROI, guiding client decisions, and shaping media investment strategies.• Created an MS Excel MMM simulator for brand managers to optimize investments and realize targeted volume growth objectives.A/B Testing for a Retail company based out of US• Developed a model aimed at evaluating potential changes in sales resulting from adjustments in key performance indicators (KPIs).• Identified target stores and corresponding control stores for each target, allowing us to assess the difference in sales over a specified time.• Utilized Similarity Score Matrix, Dynamic Time Warping technique (DTW), to create a control group consisting of 5 stores that exhibit sales patterns similar to the target store.• Illustrated these changes in frequency within each category or segment, alongside the associated sales lift (uplift or downlift).• Sales uplift or downlift was calculated at segment level and then aggregated at national level. Show less Shelf management and optimization analytics for US based computer Vision Company• Optimized product placement resulting in a 15% increase in sales and 20% reduction in shelf space wastage.• Employed Advanced Excel and VBA tools to establish an analytical framework for a CPG retailer's KPI analysis.• Created and managed 3 Scorecards to assess diverse retailer performance based on KPI scores.• Automated manual tasks in PowerPoint using VBA scripting, improving efficiency and accuracy led to reduce the delivery time by 70%.• Conducted exploratory analysis and utilized statistical techniques to develop data review dashboards for client collaboration and oversight of a 3rd party vendor team of 2 members.• Efficiently handled ad-hoc client requests, providing actionable insights to support informed decision-making.Should Cost Analysis for a US based Food Packaging Company• Constructed a dynamic Excel VBA dashboard with six scenarios, enabling cost analysis and report generation.• Offered user-friendly functionality to add or delete scenarios, leading to acquisition of a new client. Show less

  • Senior Data Analyst

    Jan 2023 - now

  • Data Analyst

    Aug 2021 - Dec 2022