Vaishnavi Deshmukh | Business Analyst at Kelp

Vaishnavi Deshmukh

Business Analyst at Kelp

Based in Mumbai, IND

About

A Master of Technology graduate from DA-IICT, specializing in Software Systems, with a Bachelor of Technology in Computer Science from JNTUH College of Engineering Hyderabad. Currently contributing as a Business Analyst at Kelp, leveraging IT Business Analysis and Product Analysis skills to enhance user experience and optimize financial products through data-driven insights. At Kelp, collaborated with teams to analyze customer insights using tools like Excel, SQL, and Python, while automating repetitive tasks to improve efficiency and enable strategic decision-making. Passionate about data visualization and analytics, aiming to drive impactful solutions in a collaborative and innovative work environment.

Skills

Projects

Query Execution Optimization using Cloud and Big Data

Analyzed a 1.8GB dataset using ETL with PostgreSQL and Apache Hive on Hadoop, boosting efficiency by 25% with map-reduce techniques. Showcased that distributed execution is 92% faster. Utilized Advanced Excel & VBA, including pivot tables, for a 20% increase in data analysis efficiency.

A Static Analysis Approach for Ethereum Smart Contracts(M. Tech Thesis)

Developed 5 Python algorithms to detect 5 smart contract vulnerabilities, achieving 48% accuracy vs. open-source tools. Analyzed 47K contracts with Tableau, reducing processing time by 35% and enhancing detection rate by 25%. Secured approval for research proposal and methodology from examiners.

Insightful HR-Data-Driven Retention Recommendation

Performed advanced HR data analysis, leveraging Python ML models with pandas, NumPy, Matplotlib, Seaborn, and sci-kit-learn to predict attrition factors, enhancing HR strategy. Developed tree-based ML models surpassing Logistic Regression, boosting AUC by 10.8% and accuracy by 13.2%.

Washington House Distribution Report

The Washington Housing Dashboard on Tableau offers insights into real estate, detailing house prices, sales data, and property features. Buyers make informed decisions on affordability, while sellers maximize property appeal. This dataset of 21k+ rows underwent thorough cleaning before analysis.

British Airways Reviews Dashboard

Using Tableau, I developed the British Airways Reviews Dashboard from a Kaggle dataset with 10k+ rows. It offers insights into customer sentiment, flight ratings, and popular destinations, aiding data-driven decisions for enhanced customer experience.

Coffee Sales Report

This project analyzes a Kaggle dataset with 1000+ rows, leveraging Excel for data cleaning and pivot tables for insights. A dynamic dashboard showcases key metrics, empowering data-driven decisions. Excel's functionality enables interactive visualizations, enhancing business intelligence.

Experience

2021-2023

Teaching Assistant

I provided academic support and mentorship to 150 students, leveraging Tableau and Power BI to create interactive dashboards and reports that effectively communicated insights. Utilizing SQL and Python, I extracted, transformed, and analyzed large datasets to support informed decision-making. Additionally, I organized 30 tutorial sessions for 120 students, covering advanced SQL topics and hands-on experience with MySQL and PostgreSQL. Through engaging tutorials, I equipped students with skills in A/B testing and hypothesis testing, fostering their ability to derive actionable insights in real-world scenarios. My proficiency in MS Office tools, including Excel VBA, contributed to a 12% increase in performance through data visualization and reporting.

Education

2021-2023

M. Tech(ICT) at Dhirubhai Ambani Institiute of Information and Communication Technology

During my M. Tech program, I undertook a range of courses that enriched my knowledge and skills. These included Programming Lab for MATLAB and Python, Advanced Algorithms, Probability and Statistics, Distributed Databases, Advanced Software Engineering, Distributed Systems, Blockchain and Cryptocurrencies, and Software Project Management.