Glad to see you here. As a Data Professional, I distill down Data for ACTIONABLE Takeaways. Here you can browse through my Data Diary! 👇🏻
➡️ Product Recommendation System for E-commerce, Github Repository
Goal: To build a recommendation system for e-commerce that enhances customer experience by suggesting relevant products, driving sales, and optimizing marketing strategies.
Description:
- Architected a SQL-based Superstore Data Warehouse, analyzing 10K customer behaviors to identify regions with the highest sales and profit across all categories.
- Built a Quarterly Sales Forecasting Dashboard using Tableau to track trends by region, category, and sub-category, achieving a 12.5% profit-to-sales ratio.
- Deployed Collaborative Recommendation Systems using Gradio on HuggingFace Space, resulting in a 35% increase in customer retention.
Skills: Data Cleaning, Exploratory Data Analysis (EDA), Recommendation Systems, SQL — Data Warehousing, Dashboard Building
Languages/Libraries/Frameworks: Python (Pandas, NumPy, Scikit-learn, Seaborn, Matplotlib, NLP), SQL (MySQL), Tableau, Gradio
➡️ Credit Risk Segmentation for Bank, Github Repository
Goal: To develop a machine learning model that accurately predicts the risk level associated with a customer, which can help the bank make informed decisions regarding credit limit, interest rates, and other credit-related policies.
Description:
- Integrated datasets of Internal bank system with CIBIL National data, conducted extensive pre-processing to handle missing values.
- Performed feature engineering using Chi-squared and ANOVA tests, to reduce features from 79 to 39, reduced multicollinearity to ensure model accuracy.
- Trained & fine-tuned Multi-Class XGBoost model using Grid Search CV, achieving 78.01% accuracy & 0.76 F1-score, improving risk appetite.
Skills: Data Cleaning, Exploratory Data Analysis (EDA), Data Pre-Processing, Chi-Square Testing, ANOVA Testing, Model Building and Fine-Tuning
Languages/Libraries/Frameworks: Python (Pandas, NumPy, Scikit-learn, Matplotlib, Scipy, Stats-Models)
➡️ Inventory Management System for Lifestyle Retailer, Github Repository
Goal: To implement a reliable inventory management system that reduces holding costs, prevents stockouts, and maximizes revenue without losing customers.
Description:
- Utilized MySQL Workbench to conduct detailed inventory analysis, including sales forecasting and profitability assessment.
- Applied Joins, Aggregate Functions, CTEs, and Window Functions to compute critical metrics such as average daily sales and running totals.
- Optimized inventory management and pricing strategy for Posh Palette, resulting in reduced holding costs and minimized stockouts.
Skills: Data Manipulation, Data Analysis
Tools: Excel, SQL (MySQL)
➡️ 360° Video Feature A/B Test Analysis for E-commerce, Github Repository
Goal: To evaluate the impact of adding 360-degree product videos on product pages to assess whether this feature increases conversion rates and revenue.
Description:
- Executed A/B test on 1 lakh users to assess the impact of 360° Product Video Feature on E-Commerce sales, achieving 64.77% increase in user interaction.
- Utilized hypothesis testing using Chi-Square Test to validate results with 95% confidence level, leading to a 2.87% rise in overallrevenue
Skills: Exploratory Data Analysis (EDA), A/B Testing, Chi-Square Test
Languages/Libraries/Frameworks: Python (Pandas, NumPy, Seaborn, Matplotlib, Scipy, Stats-Models)
➡️ Marketing Campaign Dashboard for E-commerce, Github Repository
Goal: To identify which customer segments are most likely to purchase this offer, by predicting the most responsive customers, the store aims to reduce campaign costs and maximize sales through a targeted marketing approach.
Description:
- Built Power BI dashboard to analyze weekly customer complaints and tracking YOY revenue growth across various purchase channels.
- Introduced a targeted Gold Membership discount during Year-End Sales, resulting in increased customer retention and reduced churn.
- Provided actionable recommendations to identify potential buyers, which enabled a more efficient and targeted campaign approach, increasing revenue for the next quarter.
Skills: Data Cleaning, Dashboard Building
Tools: Excel, Power BI
➡️ Weather Forecasting App, Github Repository
Goal:To provide real-time weather information for any location worldwide using data sourced from the Open Weather Map API, enhancing user convenience by providing accurate weather forecasts for informed planning and decision-making.
Description:
- Developed user-friendly GUI Weather Forecasting App using Python using OpenWeatherMap API and Tkinter library.
- Used Requests library to fetch data, integrated with API key configuration file.
Skills: Graphical User Interface (GUI) and App Development, Fetching Data using API
Languages/Libraries/Frameworks: Python (ttkbootstrap, Tkinter, Requests), PIL (Python Imaging Library)
- What are the Transformers?
- Self-Attention Networks : Beginners Friendly In-Depth Understanding
- Step-by-Step Walkthrough to A/B Testing Fundamentals
- SQL Queries to Transform Your Data into Insights
- 10 Ways to Write Better Python Codes
- Stop Struggling with Namespaces and Scopes in Python
As a data professional, my GitHub Repos mirrors my Analytics and Data Science journey. Explore the range of projects showcasing my proficiency in Python, SQL, and data visualization tools like Tableau and PowerBI.
From Machine Learning Models to Data Insights and Business Recommendations, each repository narrates my skills.
As a beginner, I'm eager to gain a deeper understanding of the data lifecycle with a range of tools and techniques, distilling down data for actionable takeaways using Data Analytics, ETL, Machine Learning, NLP, Sentence Transformers, Time-series Forecasting and Attention to Details to make recommendations across different business groups while contributing and growing in the field of Data Analysis, Data Science, or Product Analytics.
If my experience intrigues you and you believe I could be a valuable addition to your team, let's connect and explore the exciting possibilities at the intersection of data and innovation!
