ANKIT TRIPATHI
Senior Manager- Data Analytics
Gurgaon
Summary
Analytically driven and ambitious professional having 9+ years of diverse experience in Customer Insights, Data Analytics and Business Intelligence across RMG, O2O & E-Commerce.
Overview
9
9
years of professional experience
Work History
Senior Manager Data Analytics
Omnibay Pvt. Ltd. (spartanpoker.com)
9 2021 - Current
- Leading a team of 4 Senior & Junior Data Analysts
- Created & Managed Hevo data pipelines for data migration from Mongo DB & AWS RDS to Snowflake
- Created executive facing dashboards to drive decision making (Power BI & Streamlit)
- Key Stakeholder in Migration of Data from Old App to New App
- Finalized the 5 Year Business Plan till FY29, collaborating with Business, Finance & HR
- Drive Rake Slabs Revision across Blinds & Variants before IOPC January & June 2022 Edition (India's biggest Online Poker Tournament Championship) 18% Effective Revenue Jump
- Owning Cross Functional Project RAISE to take our D0-D7 & M0-M1 retention % from 9% to 12% & 33% to 40% respectively in Q3&Q4 FY2223.
Deputy Manager Product Marketing
Adda52.com
02.2020 - 09.2021
- Lead report migration to Power BI & Holistics and successfully moved 15+ reports, transformed & consolidated dashboards resulted to be more efficient
- Worked end to end on creating RFM Model for better segmented targeting of Offers through Communications as well as direct calling
- Call connectivity to churned users (>30 Days Inactive) increased from 22% to 28% in just one month
- Designed & performed A/B tests to optimize customer experience & analyzed results to provide insightful recommendations to the Marketing team
- Coupled data from Databases (MySQL & Vertica) with data available in spreadsheets in Power BI to create informative dashboards
- Automated contest reports & user payouts using python
- Modelled Retention Cohorts - 30/60/90 Days & ROI/LTV/Payback Period reports.
Business Analyst
Paytm
12.2015 - 01.2020
- Developed 30+ automated/ad-hoc reports for 20+ Key Account Managers & Business Development Managers, leveraging platforms like Hive, Oozie, Excel, Python etc
- Formulated Pricing Strategies for Paytm Entertainment (Events, Amusement Parks & Movies Ticketing) business and promoted Upselling & Cross-selling techniques for users from different verticals
- Used customer segmentation to help Campaign Managers with better & effective marketing
- Analysed booking patterns of Amusement Parks, shared results to decrease the Cut-off time increasing our weekend business & 7% overall growth in monthly revenue
- Drove product improvement features to enhance the user experience, traffic and conversion in coordination with multiple teams
- Applied ETL process, export & import data from MySQL DB to Hive & vice versa using Amazon S3
- Key member of P&L management and Data Reconciliation
- Created custom reports on Salesforce to monitor Agents Day on day performance to be used by various team leaders.
Education
Bachelor's in Power System Engineering -
University of Petroleum & Energy Studies
Skills
SQL
Timeline
Deputy Manager Product Marketing
Adda52.com
02.2020 - 09.2021
Business Analyst
Paytm
12.2015 - 01.2020
Senior Manager Data Analytics
Omnibay Pvt. Ltd. (spartanpoker.com)
9 2021 - Current
Bachelor's in Power System Engineering -
University of Petroleum & Energy Studies
Similar Profiles
ANKITA NIMBALKARANKITA NIMBALKAR
Senior Executive at Omnibay Pvt LtdSenior Executive at Omnibay Pvt Ltd
Kedar GadreKedar Gadre
Principal Architect at Omnibay Private LimitedPrincipal Architect at Omnibay Private Limited
Aniket LaleAniket Lale
Account Executive at Omnibay Private LimitedAccount Executive at Omnibay Private Limited
KARISHMA RAWATKARISHMA RAWAT
Senior AML/KYC Analyst at KPMG Global Services Pvt LtdSenior AML/KYC Analyst at KPMG Global Services Pvt Ltd
Rohit SharmaRohit Sharma
Assistent Consultent at Tata Consultancy ServiceAssistent Consultent at Tata Consultancy Service