Vineet Madaan
Business Intelligence| Data Analytics| Pricing| Revenue Mgmt.
Gurgaon
Summary
Professional with over 9 years of successful experience in Pricing, Business Intelligence, Analytical Reporting, and ETL management. Recognized consistently for performance excellence and contributions to success. Offering broad understanding of statistical concepts and models such as Forecasting, Regression, Clustering with proficiency in Tools such as Excel, VBA, SQL, Tableau(Certified), Python.
Overview
9
9
years of professional experience
6
6
years of post-secondary education
6
6
Certifications
Work History
Manager Growth- Business Intelligence
Tata 1MG
Gurgaon
07.2021 - Current
- Managing team of 5 people who looks after Analytical requirement for E-Pharmacy business.
- Accurately and timely Facilitating all kinds of business reporting and dashboarding requirement.
- Responsible for maintaining and improving ETL for more than 100 transforms.
- Monitoring trend of key metrics and generating insights with respect to movement of important metrics and advising course correction accordingly.
- Designed a cold calling campaign to generate business of 50lac per month with 2pp better profitability than overall platform.
- Helps in reducing active customer remarketing cost by ~12 lac per month by excluding customer set who tends to have more than 50% cost to GMV ratio.
- Designed recurring dormant customer acquisition campaign in collaboration with CRM which generated more than 3cr at mere 1% cost to GMV ratio.
- Enabled customer support to reduce their monthly cost by 18 lac by giving them visibility around agent utilization and performance
- Generated incremental GMV of 50 lac by procuring long out of stock SKUs.
Manager-Pricing
Shuttl
Gurgaon
12.2020 - 06.2021
- Developing pricing strategies to maximize Revenue.
- Identify travel demand trend for rolling 30 days respective to routes and get pricing done accordingly
- Prepare Daily, Weekly, and Monthly level Gross Margin and Contribution Margin reports.
- Developing new Online and Offline demand channel to increase occupancy.
- Responsible for Revenue Maximization for 30 services per day which accounts for up to 3 crore in month.
- Developing Management Information Report using Tableau server and Tableau Desktop.
- Developed Service level and Sector level booking profile for Online and Offline market separately.
Deputy Manager-Revenue Management and Analytics
Spicejet Airline
Gurgaon
01.2018 - 11.2020
- Analyze overall Monthly Route performance and provide summary report with recommendations to improve long term strategies.
- Developed data driven RM Strategy for pricing and Inventory optimization for allocated routes to increase unit revenue by 20%.
- Developed price level forecasting model using additive pickup which is fully developed on SQL server and same is being utilized for Network level Revenue Projections with accuracy of 95%.
- Developed Python and SQL-Server based application for scrapping of competition flights fares from multiple travel agencies websites. Main libraries which were used are Selenium, Beautiful Soup, Pandas etc which reduce competition tracking time by 50%.
- Developed yield management model for optimum allocation of inventory which helped in increasing booking number by 25%.
Assistant Manager-Revenue Management & Analytics
Indigo Airlines
Gurgaon
02.2015 - 12.2017
- To achieve monthly revenue, Load Factor and Yield targets for allocated 30 flights on different routes through dynamic pricing .
- Built forward looking proprietary tools based on Excel VBA, SQL that enable revenue forecasting, revenue warnings, and course corrections.
- Developed Revenue Management System for effective pricing of network which helps in Revenue Optimization of flights in efficient way and eliminate chances of human error by 100%.
- Advanced, improved and implemented new pricing strategies across network for increasing revenue by reducing spoilage helped in increasing load factor by 8%.
- Comfortable in utilizing Oracle Business Intelligence tools for creation of reports which provides deeper insights of market requirements.
Associate Analyst-Catalog
Globallogic Technologies
Gurgaon
12.2013 - 01.2015
- Create Product Catalog for US E-Market .
- Designing and correction in Title and Description of all type of products.
- Mentoring team and providing training to new resources.
- Do quality check of team member's work.
- Developed Microsoft Excel based reports to create visibility around daily number of transaction done by each resource in team which helped in overall goal achievement.
Education
Post Graduation Diploma in Applied Statistics - Statistics
01.2016 - 12.2017
Bachelor of Science - Mechanical Engineering
08.2008 - 07.2012
Skills
Data Intelligence
undefinedCertification
Certificate in Financial Mathematics from IFOA, UK
Accomplishments
- Got in-depth knowledge of travel Industry.
- Rewarded with Out-Of-Box Thinker award at Indigo(2016-17) by the President of the Organization for Management of Network level fares in effective and efficient manner.
- Rewarded with Star of the quarter at Spicejet(Q1-2018) for developing a tool which made the Group quotation process data driven and easier.
Timeline
Manager Growth- Business Intelligence - Tata 1MG
07.2021 - Current
Manager-Pricing - Shuttl
12.2020 - 06.2021
Tableau Desktop Specialist
10-2020
Deputy Manager-Revenue Management and Analytics - Spicejet Airline
01.2018 - 11.2020
IGNOU - Post Graduation Diploma in Applied Statistics, Statistics
01.2016 - 12.2017
Assistant Manager-Revenue Management & Analytics - Indigo Airlines
02.2015 - 12.2017
Associate Analyst-Catalog - Globallogic Technologies
12.2013 - 01.2015
Life Insurance and Health Contingency from IFOA, UK
09-2013
Statistics Modeling from IFOA, UK
09-2013
Economics from IAI
05-2013
Probabilities and Statistics from IFOA, UK
04-2013
Certificate in Financial Mathematics from IFOA, UK
09-2012
Maharishi Dayanand University - Bachelor of Science, Mechanical Engineering
08.2008 - 07.2012
Similar Profiles
Neha JainNeha Jain
Mobile Lead at Tata 1Mg (Group Transition from Tata Health)Mobile Lead at Tata 1Mg (Group Transition from Tata Health)
Vineet MadaanVineet Madaan
Senior Manager - Data Innovations and Strategy at Tata 1mgSenior Manager - Data Innovations and Strategy at Tata 1mg
Bishu MukherjeeBishu Mukherjee
Pharma Business Patient Support Program at Tata 1mgPharma Business Patient Support Program at Tata 1mg
Gaurav KumarGaurav Kumar
Assistant Team Leader at Tata 1mgAssistant Team Leader at Tata 1mg
Samiksha SinghSamiksha Singh
Assistant Manager - Recruitment at Baazi Games ( Poker Baazi)Assistant Manager - Recruitment at Baazi Games ( Poker Baazi)