Bharadwaj Narendra Shinde
Bengaluru
Summary
Detail-focused Data Analyst/consultant with 3.5+ years of experience of data driven business problem solving. Proven to understand customer requirements and translate into actionable insights. Dedicated and hard-working with passion for Big Data.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Consultant- Customer Analytics
KANTAR, KAP
03.2022 - Current
- Collaborated with cross-functional teams to develop comprehensive data-driven solutions for various business challenges.
- Coupon cohort Analysis - LTV based study for Promo and Organic acquisition for marketing resource allocation using GCP-SQL & Tableau
- Conversion rates increase 10% to 12% for loyalty subscription plan - Segment customers buying loyalty program and targeting customers with similar characteristics by K-Means clustering using Tableau
- Pre VS Post consumer behavior Analysis - Track incremental business KPI's for loyalty program using GCP-SQL & Tableau
- A/B Flyer Testing - Managed Test design for pilot marketing campaigns
- Complaints resolution 80% to 85% - Analyzed data to identify root causes of problems using Pareto Analysis (SQL & Excel) and recommend corrective actions.
- Automated reporting (reduced conversion days 45 - 35 days)- Developed customized reports, summarizing and presenting data in visually appealing format using Tableau for customer lifetime metrics.
- Improved conversion from 40% to 55% - Model to classify customers due for maintenance contract by calculating likelihood/probability to renew contract in that month based on Logistic Regression.
Assistant Manager
BLUE DART EXPRESS LTD
11.2020 - 03.2022
- Tableau Dashboard Reporting - Automated routine reporting tasks, saving time and resources while minimizing human error and providing valuable insights on Revenue, Number of shipments, Tonnage, yield & On-time delivery for branch performance resulting indirectly reduced prospect conversion days from 45 to 35 days.
- Service level improvement by 2% - Designed TAT and service level KPI dashboard resulting improvement in on time deliveries
- Incremental revenue +2cr/Year - Identified patterns and trends in large data sets and provided actionable insights SOW and competition analysis based on pricing, TAT, operational attributes to identify accounts to target using Pareto analysis, SQL & Excel.
Project Intern- Market Research & Insights
Reliance Retail Ltd
05.2019 - 07.2019
- Delivered high-quality presentations on project updates and attributes affecting Customer experience to senior management and stakeholders.
- Utilized data analysis skills to identify areas of improvement in retail stores, leading to improved customer satisfaction score.
- Footfall Increase by by 12% YOY (May 2019) -Designed Marketing campaigns to increase footfall for reliance retail stores.
Education
MBA - Information Technology & International Business
Balaji Institute of International Business
Pune, India05.2020
Bachelor of Technology - Chemical Engineering
Shivaji University
Kolhapur05.2017
Skills
- SQL Proficiency
- Tableau Expertise
- Python Programming
- GCP/AWS/Azure
- Machine Learning
- Big Data Analytics
- Alteryx Proficiency
- Statistical Analysis
- A/B Testing
Certification
- Alteryx Foundation Certificate Issued by Alteryx.
- HackerRank SQL (Intermediate) Certificate.
- HackerRank SQL (Basic) Certificate.
- Google Certified in Data Analytics – SQL, R Programming, Tableau.
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Timeline
Consultant- Customer Analytics
KANTAR, KAP
03.2022 - Current
Assistant Manager
BLUE DART EXPRESS LTD
11.2020 - 03.2022
Project Intern- Market Research & Insights
Reliance Retail Ltd
05.2019 - 07.2019
MBA - Information Technology & International Business
Balaji Institute of International Business
Bachelor of Technology - Chemical Engineering
Shivaji University
Similar Profiles
Devashish RanaDevashish Rana
Research Consultant at Kantar (Certainty–Kantar Secondment)Research Consultant at Kantar (Certainty–Kantar Secondment)
ANMOL .ANMOL .
Customer Service Representative at KAP CALL CENTERCustomer Service Representative at KAP CALL CENTER
Suga Priya PeriyakaruppanSuga Priya Periyakaruppan
HR Manager at Kap Call Center Pvt LtdHR Manager at Kap Call Center Pvt Ltd
Hemendu JoshiHemendu Joshi
Lead Technology Manager – Creative Technology & Innovation Management at UnileverLead Technology Manager – Creative Technology & Innovation Management at Unilever
Ayushi SharmaAyushi Sharma
Emerging Architect at Shell India Markets Pvt LtdEmerging Architect at Shell India Markets Pvt Ltd