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
HiveQL
Power BI
Python
Steamlit
Excel
Holistics
Salesforce CRM
Snowflake
MongoDB
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