Dewashish Thakare

NPS Analytics:
Spearheaded development and implementation of NPS survey eco-system from scratch for Groww, encompassing transactional NPS for 8 products and Relational NPS.
Achieved remarkable 22% increase in NPS over 10-month period.
Onboarding NPS: Identified and recommended optimisations in onboarding funnel, leading to 10 percentage point increase in NPS.
A/B Testing: Successfully implemented colour scale changes in NPS surveys, resulting in 2x improvement in response rates and ~10% increase in promoters and neutrals.
Withdrawal and GB RCA: Proposed a switch from Batch withdrawals to Real-time, boosting NPS by 6 percentage points within 2 months (A/B Testing).
Engagement Analytics:
First Order experience Analysis: Drove down Groww-driven failures from 25-30% to just 2%, leading to a 12 percentage point increase in NPS. User Journey Analytics and Churn:
Analysed user journeys across product platforms, reducing customer churn by 4% through improved customer retention and engagement. Conducted A/B testing for alternate user journeys, achieving a 10 percentage point increase in NPS.
Management Information Systems (MIS) Analytics:
Implemented an efficient MIS reporting system, transitioning from legacy Google Sheets to an automated dashboard, cutting down man hours to approximately 0 hours
Conducted RCA on MIS numbers monthly,providing valuable insights to product teams, contributing to a combined revenue increase of ~12x for FY 22.
Analysed Help and Support tickets, reducing the percentage of ticket-raising users from 40% to 32%, leading to improved customer satisfaction and operational efficiency.
Supervised a team for all three initiatives mentioned above.

Top of Funnel Analysis (Private Brands Swiggy)

• Search Funnel and Competitor Analysis
• Root Cause Analysis to analysis the loopholes in the search funnel and suggested appropriate business solutions.
• Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement for top of funnel.
• Evaluated trends to understand impact of various marketing strategis and adverts

Customer Churn Prediction Model

• Designed various hypothesis and built Machine Learning models on top of it for accurate predictions.
• Analyzed multiple models and datasets and designed Power BI report.

True Store Score - Simulator and Growth Analysis:

• TSS Simulator was developed to provide list of levers to fix (in terms of investment and prioritization) to increase operational efficiency & to understand impact & ROI of each metric also helpful in goal setting.
• A statistical model was be developed to quantify the impact of different
• Factors and forecasting
• Pre- Post analysis on historical data to understand impact on stores where investment happened recently (Remodel Impact Analysis).
• Identified low growth stores and their operational barriers through TSS model.
• Analyzed key aspects of business to evaluate factors driving results and summarized into TSS Simulator.
• Improved business direction by prioritizing customers and implementing changes based on collected surveys and recommended operational improvements based on tracking and analysis of past data.

Rate Volume Mix Analysis:

• Distribution of dollar delta between two time periods amongst Rate, Volume & Mix impact on overall Supply Chain costs was determined.
• Created detailed multiple PowerBI reports from previous data in manufacturing, sales and supply chain domain.
• Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
• Analyzed SAP transactions to build logical business intelligence model for real-time reporting needs.
• Automated the scripts running through orchestration.

Global Supply Chain Migration:

• Migrating 7 applications to Snowflake by sourcing the data from Azure.
• Migrate existing Analytical datastore from Cloudera to MAP 2.0
• Developed database objects, including tables and views using SQL.
• Part of data modelling and data profiling sessions to understand business needs.
• Downstream applications sync up to Snowflake Cloud Data warehouse and 7 Applications and their data models for migration.

Snowflake Accelerator and Cost Estimator:

• Developed a web-based application that takes the DDLs(DDL Generator) and SQLs (SnowSQL Blizzard) as input to convert into SnowSQL that can be executed in Snowflake Database .
• Automated the process of HIVE queries conversion to Snowflake queries conversion.