Moumita Chowdhury
Business Analyst
bangalore
Summary
Analytical and detail-driven Business Analyst with over 3 years of experience in inventory and supply chain analytics, process optimization, and data visualization. Skilled in SQL, Power BI, and Advanced Excel to analyze supply chain KPIs, forecast demand, and optimize inventory. Proven track record of improving customer retention, reducing overstock, and enabling data-driven decisions.
Overview
4
4
years of professional experience
Work History
Business Analyst
The House of Rare (Rare Rabbit)
08.2022 - Current
- Independently led inventory optimization initiatives, achieving 20% reduction in overstock and 12% improvement in seasonal sell-through.
- Performed root cause analysis on stock-outs and replenishment gaps; implemented corrective measures that improved product availability by 15%.
- Monitored and reported on inventory and supply chain KPIs, using SQL and Power BI to drive data-based decision-making.
- Designed and automated Power BI dashboards tracking SKU performance, reducing manual reporting time by 2 hours daily.
- Partnered with cross-functional teams (merchandising, IT, and logistics) to streamline stock flow and replenishment cycles.
Tools: SQL, Power BI, Excel, GCP, Statistical Analysis
Data Analyst
Bonito Designs
01.2022 - 07.2022
- Conducted root cause and variance analysis (RCA) for operational inefficiencies, directly improving project delivery timelines.
- Built Tableau dashboards to track key operational metrics, snag reports, and BOQ analysis, ensuring proactive issue resolution.
- Collaborated with project managers and finance to enhance visibility on material utilization and reduce unnecessary procurement costs.
Tools: Tableau, Excel, RCA, Project Cost Analytics
Education
Master of Science - Mathematics
Burdwan University
West BengalBachelor of Science - Mathematics
Vidyasagar University
West BengalSkills
Inventory Optimization & Replenishment
Supply Chain KPI Monitoring (Availability %, Lost Sales %, Cost per Carton)
Root Cause & Impact Analysis (Stockouts / Overstocks)
Statistical Modelling & Forecasting
Advanced Excel (Pivot, Power Query, VBA)
Dashboarding & Data Visualization (Power BI, Tableau, Looker Studio)
SQL Data Extraction & Automation
Business Process Improvement
Cross-Functional Collaboration with Merchandising & IT
Data Tools: SQL, MySQL, SQL Server, GCP
Visualization: Power BI, Tableau, Looker Studio
Programming: Python (Pandas, NumPy)
Analytics: RCA, Statistical Analysis, Forecasting, Dashboard Design
Other: Requirement Gathering, Data-Driven Decision Making
KEY ACHIEVEMENTS
- Enhanced customer retention by 15% through segmentation and LTV analysis.
- Supported business growth from ₹200 Cr to ₹1000 Cr through inventory and sales optimization strategies.
- Improved supply chain visibility, ensuring right product availability through automation and KPI tracking.
Timeline
Business Analyst
The House of Rare (Rare Rabbit)
08.2022 - Current
Data Analyst
Bonito Designs
01.2022 - 07.2022
Bachelor of Science - Mathematics
Vidyasagar University
Master of Science - Mathematics
Burdwan University