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