Ankit Kumar Email & Phone Number

Gurugram, Hr, In

Gurgaon

Gurugram, Haryana, India

+ Owned all Product & Business metrics for Used Car Referral business (a key segment of Cars24’s Growth vertical)+ Conducted deep-dive and root cause analysis to investigate Product & Business issues.+ Defined key metrics and investigated impact for new product features and experiments.+ Developed complex SQL queries to power Tableau dashboards & Google Sheets reports.+ Developed Python scripts for data processing, transformation & ETL.+ Collaborated with cross-functional teams & stakeholders to understand & fulfil timely data requirements.

Gurugram, Haryana, India

+ Led Product and Growth Analytics charter for Airtel Thanks app leading a team of two Analysts.+ Conducted business reviews with C-Suite stakeholders in collaboration with Product and Growth counterparts.

Gurugram, Haryana, India

+ Enabled data-driven decisions by setting and defining key metrics for the business and taking end-to-end ownership of data-driven insights.+ Developed and maintained advanced SQL queries for data analysis and extraction.+ Leveraged Python & PySpark for data modification, manipulation, and analysis.+ Developed visualizations, storyboards, and reports on Tableau, enabling stakeholders to track daily metrics, perform L1 & L2 deep-dives and make informed decisions.+ Designed and implemented AB testing frameworks to evaluate the performance of new product features and marketing campaigns, analysed the results.

Gurugram, Haryana, India

+ Lead multiple strategic and operational projects and owned all performance metrics for Value & Volume Sales and Drugs Prescription for Latin American (LATAM) market.+ Collaborated with teams in Multi-Channel Marketing and Salesforce Effectiveness verticals to prepare comprehensive analysis and reports for leadership reviews.+ Developed Excel reports & Power Point presentations for business performance tracking and communicating insights to stakeholders.+ Catered to ad-hoc requirements from clients by extracting data, preparing analysis, and generating insights from QlikSense platform.+ Designed SQL queries to extract and consolidate data from multiple databases, providing essential datasets to Power BI developers for dashboard development.+ Developed Time Series Forecasting models for brand sales forecasting and K-Means Clustering models for brand segmentation based on sales and marketing performance indicators.

Gurugram, Haryana, India

Gurugram, Haryana, India

+ Collaborated with onshore partners for Global Sales and Revenue Management analytics for Microsoft Corp.+ Provided comprehensive Analytics & Reporting solutions to clients utilizing tools like MS SQL Server, Advance Excel, and Power BI

Noida, Uttar Pradesh, India

+ Developed sales reports & dashboards, enabling data and insights for Sales & Operations leadership+ Created daily, weekly, and monthly reports in MS Excel for periodic tracking and assessment of key metrics on sales team performance+ Created and maintained databases for existing and new customers using MS SQL Server 2012

New Delhi

Postgraduate Diploma, Business Analytics (Wilp), Sem-1 Cgpa: 9 | Sem-2 Cgpa: 9.25

Bachelor Of Technology (B.Tech.), Electrical And Electronics Engineering