Monisha Reehal

As a pivotal resource, my analytics expertise significantly impacted Xiaomi India's business performance.

Worked on:

Management dashboard | Phones

Drove business KPI like Sellin, sellthru, sellout, activation, second activation and inventory for both online and offline channel distribution.

DWM Project (Festive season project) | Phones

Built and worked day on day tracking and strategy analysis of sales and zones performance during Diwali festive period

TV Category Leadership :

Management dashboard | TV
Drove analytics for Xiaomi India's TV category, contributing to market leadership.
Provided critical insights into market trends, consumer behavior, and competitive positioning.

Online to Offline Scalping Analysis:
Tracked and analyzed online-to-offline scalping trends, identifying key patterns and implementing mitigation measures.
Evaluated the impact on offline channel inventory and proposed strategic solutions.

Sales Performance and Inventory Management:
Engineered intuitive dashboards for day-to-day sales metrics and comprehensive inventory management.
Enhanced decision-making with real-time insights and automated alerts for stock replenishment.

Customer Churn and Acquisition Analysis:
Developed robust dashboards using Facebook Analytics to analyze customer churn and refine acquisition strategies.
Extracted insights to enhance customer retention initiatives and targeted campaigns.

IDC Research Data dashboard and analysis:

Quarterly analysis of research reports of TV markets and competition analysis. To forecast KPI like market size increment, market share of Xiaomi and competition, Annual revenues and business volumes

Key Skills

• Worked effectively in fast-paced environments.
• Organized and detail-oriented with a strong work ethic.
• Facilitated successful cross-functional collaborations for the completion of key projects, fostering strong working relationships among team members.

Technical Skills:

Spark SQL/ Advance SQL, Power BI, Tableau, Advance excel, Microsoft suit, Python

Weekly Business Review: Built weekly business review insights with Leaders across the board and sales Exec for weekly business Trends and action plans of business segments.

Pipeline Forecast Dashboard: To accurately analyze data and forecast pipeline for the upcoming year. Collaborated with Sales Leaders to tackle unstructured challenges and increased opportunity conversion ratios by analyzing historical data trends from Salesforce.

Capacity Planning and Ranking Dashboard: KPI Analysis of Sales executives based on weighted ranking and tenure grading.

Sales funnel average aging and conversion rate Analysis: Conducted Gap Analysis and advised leaders on corrective actions to achieve targets.

Win/loss Analysis: Lead analysis of deals closed or lost, facilitated Business Process Improvement.

Discovery calls Conversions Analysis and Trends: Worked with cross-functional teams to ensure timely project completion.

Pipeline health and data hygiene health dashboard: Created dynamic dashboards using Looker Studio/Tableau to display complex data and enable data-driven decisions.

Entire Mid-Market Sales Adhoc and Analysis: Designed, developed, and deployed practical data, built a comprehensive data strategy roadmap and ensured high-quality deliverables.

FY data packs and Historic trends: Built & managed Quarterly/Annually Sales Business Review Dashboards, and presented insights to Senior Management for effective decision-making for the office of CEO.

Logos and Churn weekly business review: Improved organization efficiency, growth, and profit through accurate data gathering, analysis, and valuable recommendations; assisted top management in strategic planning and implementation.

Training Kit: Documented OPERAs and recommended improvements for QA processes and procedures.

Skills: · Business Case Preparation · Requirements Gathering · Sales Funnel Optimization · Business Process · Conversion Rate · Data Analytics · Attention to Detail · Business Process Management · Financial Analysis · Leadership · Dashboard Building · Business Insights · Project Management

• Skilled at working independently and collaboratively in a team environment.
• Self-motivated, with a strong sense of personal responsibility.
• Proven ability to learn quickly and adapt to new situations.

•Built Weekly Sales Business Review Dashboards and presented insights to market-wise stakeholders.
•Prepared training plans for new joiners.

•Trained 3 Associate Analyst
• Applied problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
•Conducted data cleaning and data wrangling tasks to prepare data for analysis.
•Skilled at working independently and collaboratively in a team environment.
•Worked effectively in fast-paced environments.
•Passionate about learning and committed to continual improvement.
•Proved successful working within tight deadlines and a fast-paced environment.