KALPESH PHADKE
Virar
Summary
Results-driven Data Analyst with expertise in Subscription Management and Business Intelligence at In10Media Private Limited. Proven track record in enhancing user engagement through data-driven insights and predictive modeling. Skilled in Google Analytics and MS Access, with a strong ability to collaborate effectively across teams to drive strategic initiatives.
Overview
20
20
years of professional experience
Work History
Data Analyst and Business Intelligence
In10Media Private Limited
Mumbai
09.2023 - 04.2025
- Proficiently managed daily subscriptions flow and renewal tracking for B2B and B2C businesses in domestic and international markets
- Conducted comprehensive usage analysis pre and post subscriptions, providing valuable insights into customer intent and behavior
- Closely working with the Marketing team to enhance user experience and retention through personalized content recommendations
- Developed behavior-based email and notification campaigns to increase user engagement and retention rates
- Conducted detailed churn analysis to identify at-risk users and reduce churn using predictive models to forecast probable churn
- Executed Payment Gateway vs System revenue comparisons, ensuring accurate revenue reporting for the D2C business
- Led deep dives into subscription and renewal drops, addressing key parameters like subscription funnel analysis, app/web journey errors, gateway issues, and pricing/content-related challenges
- Applied LTV/ROI models to assess acquisition quality, facilitating agency acquisition payouts and contributing to future planning
- Conducted detailed analysis and segmentation of B2B partner subscriptions, considering variables like consumption patterns, re-subscription frequency, visit frequency, and preferred content categories
- Collaborated with strategy teams to provide hands-on support in making projections based on purchase trends, customer intent, seasonal effects, and external factors
MIS, Analytics, Acquisition and Revenue Management
Vodafone Idea Limited
Mumbai
07.2015 - 08.2023
- Reported postpaid dashboards like Acquisitions, Plan Upgrades, International Roaming, VI App with the help of BI-SQL/MS-Access/VSV URL
- Highlighted Daily Acquisition-Churn updates MTD vs LMTD
- Daily track of plan upgrades with revenue impact due to upgrade and downgrade of tariff changes
- Regular updates on International roaming pack takers & VI App users
- Shared cloud calling IVR bases to partners for plan upgrades, new acquisitions of various plans, MNP
- Raised an alarm at the necessary time to help support key interventions to be taken to improve the relevant KPIs
MIS Executive – Mobility – Revenue & Market Planning
Bharti Airtel Limited
11.2008 - 06.2015
- Company Overview: Company Overview: (Mumbai & Pune)
- MIS on MOU's (Minutes of Usage) of Incoming & Outgoing Calls
- Created Tertiary Reports on Daily Recharges done by Customers
- Reports on REC (Revenue Earning Customers), Gross Decrement etc
- Mobile internet Data usage analysis
- Handled BTS sites related reports in Zonal & District level
- Detailed MIS on CMS/ICMS and SOGA of Own as well as Competitors (Mobile Operators)
- Having extensive experience in leading analyzing, maintaining reports of HT Subscriber / O.B.D report Mum & ROM Circle
MIS Executive - Material Management
Reliance Communications Limited
04.2005 - 10.2008
- Company Overview: Company Overview: (Mumbai)
- Collaterals / Material Delivery to Warehouse getting done by Vendors
- Co-coordination with the warehouse team for dispatch status of collaterals
- Passes accounting entries into SAP (Software)
- Made monthly Provisions in SAP for Marketing payments
- MIS on COCA Budget (Cost of Customer Acquisition) for marketing collaterals
- MIS on Outdoors rental, mounting & printing cost
- MIS reports given to client on signage's installation & merchandising stock report
- Also reports on audits of various activities
- Coordination with field executives for retail activities
Education
Bachelor of Commerce -
Mumbai University
Higher Secondary School -
Mumbai Board
MumbaiSecondary School Certificate -
Mumbai Board
MumbaiSkills
- Subscription Management
- Acquisition Management
- Data Analysis
- Business Intelligence
- Payment Gateway Optimization
- Google Analytics
- MS Access
- MY SQL
- AWS
- IBM DB2
Languages
English, Hindi, Marathi
PERSONAL DETAILS
- Date of Birth: 12/11/1984
- Nationality: Indian
- Marital Status: Married
- Children: 1 Daughter
Timeline
Data Analyst and Business Intelligence
In10Media Private Limited
09.2023 - 04.2025
MIS, Analytics, Acquisition and Revenue Management
Vodafone Idea Limited
07.2015 - 08.2023
MIS Executive – Mobility – Revenue & Market Planning
Bharti Airtel Limited
11.2008 - 06.2015
MIS Executive - Material Management
Reliance Communications Limited
04.2005 - 10.2008
Bachelor of Commerce -
Mumbai University
Higher Secondary School -
Mumbai Board
Secondary School Certificate -
Mumbai Board
Similar Profiles
Kalpesh PhadkeKalpesh Phadke
Data Analyst and Business Intelligence at In10media Private LimitedData Analyst and Business Intelligence at In10media Private Limited
NILESH V. DUBEYNILESH V. DUBEY
Senior PHP Developer at In10Media Pvt LtdSenior PHP Developer at In10Media Pvt Ltd
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
Sujit ShettySujit Shetty
Branch Manager at PCI Pest Control Pvt LtdBranch Manager at PCI Pest Control Pvt Ltd
Amit LallAmit Lall
Dy Manager- SCM at J.B. Chemical & Pharmaceutical LtdDy Manager- SCM at J.B. Chemical & Pharmaceutical Ltd