Indian Institute of Information Technology, Pune (IIIT Pune)
Objective: Developed an end-to-end data analysis project to identify and profile core customer segments for a UK e-commerce retailer to guide strategic marketing decisions.
| Detail | Description |
|---|---|
| Methods |
RFM Analysis (Recency, Frequency, Monetary) followed by K-Means Clustering ( |
| Segments | Best Customers, Growing Customers, and Hibernating Customers with defined strategic roadmaps for each. |
| Deliverable | Live, Interactive Streamlit Web Application for executive review, featuring the Segment Size breakdown and the Normalized RFM "Snake Plot." |
| Live Demo | [] |
| Tech Stack | Python, Pandas, Scikit-learn, Streamlit, Plotly (for interactive visualization) |
| Category | Skills & Tools |
|---|---|
| Data Science & Analytics | Python, Pandas, Numpy, Scikit-learn, Streamlit, Plotly, SQL |
| Frontend | React.js, Next.js (Learning), TypeScript, JavaScript (ES6+), Tailwind CSS, HTML5, CSS3 |
| Backend & Databases | Node.js, Express.js, tRPC, Prisma, PostgreSQL, MongoDB |
| DevOps & Tools | Git, GitHub, REST APIs, GraphQL, React/TanStack Query |
These projects demonstrate a proactive approach to turning data insights into business solutions, which is the core function of a Business Analyst.
- Project 1: Customer Campaign ROI Simulation: Developing a model to forecast Return on Investment (ROI) by simulating targeted marketing budgets across the new RFM customer segments. This involves defining Key Performance Indicators (KPIs) and outlining the business case for budget reallocation.
- Project 2: Sales Forecasting & Inventory Optimization: Utilizing time-series techniques to forecast seasonal demand and identify potential bottlenecks. The goal is to produce a Business Requirements Document (BRD) for a new inventory management feature.
- Project 3: User Flow and A/B Testing Strategy: Designing an A/B testing framework for the e-commerce checkout process. This project will involve mapping the current user journey, identifying pain points, and creating mock-ups (wireframes) for proposed user interface (UI) changes.
| Platform | Handle/Link |
|---|---|
| Pritam Reddy M | |
| @that_teen.titan |
⭐ Passionate about data-driven problem-solving and leveraging cutting-edge web technologies to build impactful products.