Kalpesh Phadke
Nalasopara east
Summary
Experienced and Results-Driven Professional: Proven track record in business analytics and strategy. Specializes in subscription-based models for B2B and B2C businesses, both domestically (India) and internationally. Expertise and Skills in Subscription and acquisition Management: Identifying and addressing subscription drop issues through detailed analysis. Managing subscription and acquisition flow. Conducting renewal and retention analysis based on user profiles. Focusing on past user behavior and interest areas. Successful project execution in data analytics and business intelligence. Optimizing payment gateways to improve user experience and retention. LTV/ROI Calculations Assessing acquisition quality, Planning agency acquisition payouts.
Overview
20
20
years of professional experience
Work History
Data Analyst and Business Intelligence
In10media Private Limited
09.2023 - Current
- 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
Data Analyst - MIS
Tata Play Fiber Limited
05.2023 - 08.2023
- Created Reports and track of new and existing gross adds analysis on daily basis
- Making dashboards on various fiber plans i.e., 50Mbps, 100Mbps upto higher plans of 1000Mpbs
- Track of Fiber acquisitions with another product i.e., Binge OTT
MIS, Analytics, Acquisition and Revenue Management
Vodafone Idea Limited
07.2015 - 04.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: (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: (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 - Appeared
Mumbai University
Higher Secondary School -
Mumbai Board
Secondary School Certificate -
Mumbai Board
Skills
- Subscription Management
- Acquisition Management
- Data Analysis
- Business Intelligence
- Payment Gateway Optimization
- LTV Calculations
- ROI Calculations
- Google Analytics
- MS Access
- MY SQL
- AWS
- IBM DB2
Languages
English
Hindi
Marathi
Timeline
Data Analyst and Business Intelligence
In10media Private Limited
09.2023 - Current
Data Analyst - MIS
Tata Play Fiber Limited
05.2023 - 08.2023
MIS, Analytics, Acquisition and Revenue Management
Vodafone Idea Limited
07.2015 - 04.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
Higher Secondary School -
Mumbai Board
Secondary School Certificate -
Mumbai Board
Bachelor of Commerce - Appeared
Mumbai University
Similar Profiles
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
RAKESH JRAKESH J
Network Engineer at EQL FINANCIAL TECHNOLOGIES PRIVATE LIMITED (Formerly name of INDIAFILINGS PRIVATE LIMITED)Network Engineer at EQL FINANCIAL TECHNOLOGIES PRIVATE LIMITED (Formerly name of INDIAFILINGS PRIVATE LIMITED)