Transforming Raw Data Into Strategic Business Decisions Through Analytics, Visualization & Artificial Intelligence
|
I am a Data Analyst and Content Creator bridging the gap between analytical rigor and business strategy. Coming from a background in Zoology, I apply a unique, organic lens to complex business ecosystems—identifying patterns and growth opportunities where others merely see raw data. Driven by an entrepreneurial mindset, I focus heavily on Direct-to-Consumer (D2C) brand architecture, translating market trends into actionable intelligence. My approach integrates robust data engineering with compelling storytelling, ensuring that every SQL query or Power BI dashboard directly influences key business decisions. Currently, I am expanding my technical arsenal by researching AI innovations and business case studies, striving to build the future of automated, intelligent analytics. |
📍 Location: Mumbai 💼 Role: Data & Business Analyst 🎯 Specialization: Data Visualization, SQL, Python, Excel 🧠 Focus Area: D2C, E-Commerce & Product Base Company 🚀 Currently Learning: Python for Data Science & Automaation 📈 Career Goal: Senior BI Strategist |
1. Business Problem ➔
2. Data Collection ➔
3. Data Cleaning ➔
4. Data Analysis
➔
5. Visualization ➔
6. Business Insights ➔
7. Decision Making
| Project Name | Business Problem | Tools Used | Key Insights | Link | Repository |
|---|---|---|---|---|---|
| Sales RTO Analysis | Tracking return to oringin (RTO) orders of D2C Beauty Brand. | Power BI DAX |
Identified the overall 14% RTO rate. Most RTO orders come from Cash on Delivery (COD) payments.. | 🔗 | 📁 |
| D2C Brand End 2 End Analysis | Understand the overall sales pattern, Segment customers based on RFM and understand traffic & campaign performace and more... | Excel SQL Power Bi |
Find the causes of Revenue and Profit leakage due to Around 50-60% of orders | 🔗 | 📁 |
| Marketing Campaign Analysis | Understand marketing campaign performace track budgets, ROAS of different channels. | SQL My SQL |
Automated report generation, saving 12 hours of manual work per month. | 🔗 | 📁 |
| HR Analytics Dashboard | High employee turnover in logistics department impacting operational efficiency. | SQL Power BI |
Correlated overtime hours with attrition, prompting new shift-scheduling strategies. | 🔗 | 📁 |
| Market Basket Analysis | Finding product correlations to enhance cross-selling and bundling strategies. | Python SQL |
Uncovered 3 primary product pairings that increased AOV (Average Order Value) by 8%. | 🔗 | 📁 |
|
End-to-end interactive reporting using Power BI and DAX for live business metrics. |
Complex querying, database management, and ETL processes for clean data pipelines. |
Integrating modern AI tools and deep research to forecast trends and automate insights. |
|
Demonstrating expertise in complex querying and database optimization. |
|
|
Microsoft Certified: DAX, Data Modeling, and Executive Dashboarding. |
|
|
Comprehensive foundation in data cleaning, visualization, and R/Python. |
|
| Advanced Data Engineering (SQL) |
90% |
||
| Power BI & DAX Mastery |
85% |
||
| AI Prompt Engineering & Automation |
75% |
||
| Python for Data Science |
60% |
|
Available for freelance analytics projects, BI consulting, and full-time opportunities. 
|
Built with ❤️ using Data, Analytics & AI