Vineet Madaan
Business Intelligence| Data Analytics| Airlines Pricing| Revenue Mgmt.
Gurgaon
Summary
Results-driven professional with 10+ years in Pricing, Business Intelligence, Data Strategy, and ETL management. Recognized for performance excellence and impactful contributions. Proficient in statistical concepts (Forecasting, Regression, Clustering) and tools (Excel/Spreadsheet, VBA, SQL, Tableau, Python). Excelled in strategy building and skilled at planning, implementing and overseeing key improvements to drive business growth and efficiency. Skilled in automation and Stakeholder support. Pursuing new professional challenges with a growth-oriented company.
Overview
10
10
years of professional experience
6
6
years of post-secondary education
6
6
Certifications
Work History
Senior Manager- Business Intelligence
Tata 1MG
07.2021 - Current
- Spearheaded the adoption of self-service analytics tools, empowering employees at all levels to access critical business information on demand led to drop in 60% ad-hoc data requests.
- Responsible for maintaining and improving ETL for more than 100 transforms.
- Designed a cold calling campaign to generate business of 50lac per month with 2pp better profitability than overall platform.
- Developed a customer periodicity model which helped to rationalize the cashback campaigns resulted to 45 lac monthly savings.
- Designed recurring dormant customer acquisition campaign in collaboration with CRM which generated more than ~30 lac per month at mere 5% cost to GMV ratio.
- Enabled customer experience 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.
- Developed a robust regression model to create a segment of User Scoring. This model takes into account 8 independent variables. Application of user scoring in performance marketing resulted in 25% better ROAS.
Manager-Pricing
Shuttl
12.2020 - 06.2021
- Developing pricing strategies for intercity Bus service to maximize Revenue.
- Identify travel demand trend for rolling 30 days respective to routes and get pricing done accordingly
- 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.
- Drive growth through data-driven decision-making processes, leveraging analytics tools for informed strategy development.
Deputy Manager-Revenue Management and Analytics
Spicejet Airline
01.2018 - 11.2020
- Analyzed monthly route performance and provided strategic recommendations for long-term optimization.
- Developed data-driven Revenue Management (RM) strategies to optimize pricing and inventory for allocated routes, resulting in a 20% increase in unit revenue and a 25% rise in daily bookings.
- Designed and implemented a price level forecasting model using additive pickup on SQL Server, achieving 95% accuracy in network-level revenue projections.
- Engineered a Python and SQL Server-based application to efficiently scrape competition flight fares from multiple travel agency websites, reducing competition tracking time by 50%.
Assistant Manager-Revenue Management & Analytics
Indigo Airlines
02.2015 - 12.2017
- Met monthly revenue, load factor, and yield targets for 50 flights across diverse routes through dynamic pricing strategies.
- Engineered forward-looking proprietary tools using Excel VBA and SQL, enabling precise revenue forecasting, warnings, and proactive adjustments.
- Spearheaded the development of a cutting-edge Revenue Management System, ensuring 100% elimination of human errors in pricing across the network.
- Pioneered innovative pricing strategies, resulting in an impressive 8% increase in load factor and substantial revenue growth through reduced spoilage.
Associate Analyst-Catalog
Globallogic Technologies
12.2013 - 01.2015
- Managed US E-Market product catalog, ensuring accuracy and relevance.
- Designed and corrected product titles and descriptions for improved customer engagement.
- Mentored team members and provided training for new resources.
- Conducted quality checks and provided feedback, resulting in an increase in overall catalog acceptance from 50% to 90%.
- Automated reports using spreadsheet software to track daily transaction metrics, facilitating goal achievement.
Education
Post Graduation Diploma in Applied Statistics - Statistics
IGNOU
Delhi 01.2016 - 12.2017
Bachelor of Science - Mechanical Engineering
Maharishi Dayanand University
Rohtak 08.2008 - 07.2012
Skills
Data Strategy and Innovations
Project planning and development
Predictive Analytics
BI Tool Proficiency
Team Management
Statistical modeling
Problem Solving abilities
Certification
Certificate in Financial Mathematics from IFOA, UK
Accomplishments
- 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.
- Collaborated with Inside Sales team at Tata 1mg to optimize their calling operations which led them to improve CM from -10% to +2% in six months timeframe.
Timeline
Senior Manager- 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
Post Graduation Diploma in Applied Statistics - Statistics
IGNOU
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
Bachelor of Science - Mechanical Engineering
Maharishi Dayanand University
08.2008 - 07.2012