Prachi Bansal
Bengaluru
Summary
Results-driven Business Analyst with Proficiency in data analysis, trend identification, and translating business needs into effective solutions with broad based background in highly competitive and dynamic organizations. Skilled at process enhancement, decision support, and fostering collaboration across teams to meet organizational objectives.
Overview
2
2
years of professional experience
Work History
Business Analytics
Modenik Lifestyle pvt. Ltd.
Bangalore
2023.05 - Current
- Developed a comprehensive Power BI sales dashboard featuring multiple views: regional warehouse dispatch, channel sales, and comparative analysis of monthly and yearly sales across various brands.
- Developed client engagement strategies by analyzing sales data across major e-commerce platforms like Amazon, Flipkart, and Myntra, leading to increased client retention and brand growth.
- Implemented E-Commerce Warehouse Inventory Planning and Forecasting, achieving operational excellence by reducing stockouts by 10% through the creation of a Lean Process Improvement framework.
- Enhanced process efficiency by analyzing order cancellations and returns, providing actionable insights that optimized operations.
- Boosted sales by 18% through cross-functional collaboration with teams and partners to ensure seamless value delivery and consistent brand representation on platforms such as NYKAA, and TATACLIQ.
- Managed the entire purchase order and acceptance process, ensuring compliance with SAP requirements and optimizing inventory management.
- Implemented and managed MIS systems, enhancing data accuracy and reporting efficiency across departments.
- Monitored competitor activities, such as advertising campaigns, promotions, product launches.
- Collaborated with creative teams to develop effective digital marketing campaigns across multiple channels.
- Analyzed customer data to determine trends in purchasing behavior.
- Identified gaps between current state and desired future state operations.
- Facilitated brainstorming sessions with cross-functional teams for problem solving activities.
- Analyzed customer feedback and complaints to identify trends in returns.
- Developed and implemented return policies, procedures, and processes.
Store Operation and Promotion
Aditya Birla Fashion and Retail
2022.05 - 2022.07
- Engaged in Online Order Operations and VM (Visual Merchandise) Display
- Planned visual merchandise strategies to increase footfall and enhance the store's appearance
- Developed a priority customer list using RFM Analysis
- Handled retail and inventory management, ensuring efficient operations
- Contributed to the store ranking among the top 5 Allen Solly Stores in India
- Appreciated for excellent performance by Vishakh Kumar (CEO of Madhura Fashion)
- Completed a 3-month project manager internship at Youthbaal Foundation in 2020
Education
PGDM - Business Analytics
Jaipuria Institute of Management
04.2023
Skills
- Power BI
- Tableau
- Microsoft Excel
- Data Modelling
- Data Visualization
- DAX & M-Code
- E-commerce Warehouse Planning
- Data Driven Decision Making
- Requirements Gathering
- Structured query language (SQL)
- Business Forecasting
- Business Planning
Enrichments
- Created my own Shopping website using Canva, Logomaker and Shopify.
- Head Co-Ordinator - The National Level Storytelling Competition, JIM (2021-22) Managed content, graphics, and internal affairs, and led a team. Maintained social media presence and handled social media handles.
- Head- Jai Utsav Planning Committee (2022-23)
- Successful Planning in short time with limited Resources
Timeline
Business Analytics
Modenik Lifestyle pvt. Ltd.
2023.05 - Current
Store Operation and Promotion
Aditya Birla Fashion and Retail
2022.05 - 2022.07
PGDM - Business Analytics
Jaipuria Institute of Management
Similar Profiles
GOWTHAM SGOWTHAM S
Senior Executive Sourcing at Modenik Lifestyle pvt ltdSenior Executive Sourcing at Modenik Lifestyle pvt ltd
Amol Vijay BhoyarAmol Vijay Bhoyar
Sr. Brand Marketing Manager at Ample Pvt Ltd (Apple, Bose, Under Armour, Asics)Sr. Brand Marketing Manager at Ample Pvt Ltd (Apple, Bose, Under Armour, Asics)
Pranshi P. PanchalPranshi P. Panchal
Textile Designer at Shrijee lifestyle Pvt LtdTextile Designer at Shrijee lifestyle Pvt Ltd