yashishukla

Consultant In Customer Analytics

Previous Experience
  • Platform Integration: 
    • Data handling during the merger of 2 OTT platforms(Merger of 200k subscribers, 3M subscribers) and expansions (addition of ~110K subscribers across 5 regions) and streamlining in the amazon redshift. 
    • Created EDAs for deriving conversion ratio in newly launched regions which got converted to conversion tracker. 
  • Ad-hoc & Automation: 
    • Led Automation of weekly, monthly excel reports to dashboards in Apache Preset to standardize, reduce time and manual intervention required for reports by more than 50%. 
    • Gained a deep understanding of Cohort Analysis, Customer Acquisition & Retention, Churn Metrics, Customer Life Time Value, Customer Engagements, Customer Segmentation, etc. 
    • Collaborated with front end team for major upgrades in UAT and production dashboards. 
  • Predictive Analysis: 
    • Integrated active customer base from multiple platforms and identified users pertaining to different buckets. 
    • Performed behavioral segmentation using K-Means clustering with Model accuracy of 91% on the test set. 
    • Created multiple EDAs to analyze the top performers across segments based on viewership KPI’s.
    • Segmentation and Profiling of users to analyse behavioural insights for predicting consumption. 

Experience: 1 year

Yearly salary: $25,000

Hourly rate: $0

Nationality: 🇮🇳 India

Residency: 🇮🇳 India

Experience:

Period Title Company
2021 - 2022 Consultant Kantar Analytics Practice

Skills:

analyst
blockchain
dapp
data-science
sql
web3
english
hindi