Vaishnavi Rohatgi

Experience

• 

  The Sparks Foundation

  Jun 2021 - Jul 2021

  Data Science and Business Analytics
• 

  DevTown

  Jun 2021 - Aug 2021

  Data Analyst

  Utilized Jupyter notebook and Google Colab to examine the given datasets.Cleaned, prepared, visualized as well as modelled the data using different machine learning algorithms.

• 

  SidekickEDGE Management Consulting Services

  Dec 2021 - Jan 2022

  Data Analyst
• 

  ZIGRAM

  Jan 2022 - Jul 2022

  Data Science Intern

  Redeveloped a news clustering model utilizing the cosine similarity and FAISS model to classify similar news based on semantic meaning. Achieved a 53% improvement in news categorization accuracy, enhancing the model's ability to group articles with similar contextual meaningCreated a Flask API framework for data drift detection and EDA, providing users with quick insights on their datasets, resulting in a significant reduction in analysis timeAutomated weekly statistical data analysis by creating a Python script, extracting data from a database using SQL queries.Pre-processed and cleaned the data using NLP and carried out Sentiment Analysis.. Show less

• 

  BCG X

  Aug 2022 - now

  Data Analyst - Data Science

  Implemented a promo effectiveness framework for a leading CPG company, evaluating ROI and Uplift for individual promotional events using Linear Regression model.- Implemented customer segmentation using K-Means algorithm & RFM Analysis. • Conducted Diagnostic Analysis for a client to assess customer churn, product performance and optimizing omnichannel strategies based on online and offline consumer behavior and achieved a ~10% increase in sales and boosted conversions by 12.5%, while minimizing costs.• Performed RFM Analysis to implement customer segmentation• ​Developed a chatbot on Streamlit using OpenAI API and further refined the model through fine-tuning on healthcare dataset, creating an advanced and tailored chatbot solution.• Designed a cascading Power BI dashboard for a HVAC company to showcase critical sales and operations metrics, offering leadership a high level summary. Translated insights into actionable details at the micro level for comprehensive views. Integration with PowerApps facilitated sales rep to manipulate real-time data, resulting in a 20% increase in operational efficiency.• Developed a dynamic PowerBI dashboard for a healthcare firm, automating real-time data extraction from Amazon S3 using Python. Enabled the identification of stages with higher unprocessed messages or prolonged processing times, enabling them to address the issues and reducing processing time by 17%.• Automated an HR critical tool using Excel-VBA, decreasing manual efforts by 80% and reducing processing time by 70%.• Implemented a digital operating model using Tableau for a wine and spirits distributor, featuring skill discovery dashboards that offered insights into average weighted skill gaps across job families, roles, and important domain, improving decision-making capabilities for the distributor. Show less