Esteban Restrepo
Revenue Management | Strategic Pricing | Business Intelligence (BI) | Analytics | Project Management | Programmer | SQL | Python
In the last 7 years, I have built strategic reports to assist the pricing and demand teams at Avianca, Decameron, and PayU in making decisions that increased revenues. Additionally, I have collaborated with sales teams to design and evaluate sales strategies. I possess the ability to gather, analyze, and extract value from data through techniques such as ETLs, SQL, pivots, and graphs. I am continuously learning new approaches to improve my skills and have always had a keen interest in programming, in which I excel. Moreover, I have experience in negotiating with different departments to execute cross-functional projects. If you believe that my skill set aligns with your organization's requirements, please feel free to contact me
Work Experiences
Head of Revenue Management
- Achieved a revenue increase of 15% in the second quarter of 2024
- Implemented automation for pickup reports, resulting in a time saving of 40 hours per week
- Developed a comprehensive commission model for the company based on key performance indicators (KPIs)
- Constructed a detailed management database in G-cloud for the company's operational efficiency
Revenue Manager
- Successfully implemented automated report generation, resulting in a time saving of over 20 hours per month.
- Strategically increased occupancy levels by more than 15 percentage points through effective pricing strategies.
- Enhanced market share by 12% by optimizing the overall pricing strategy.
- Achieved a significant reduction in price disparity by over 30% among Online Travel Agencies (OTAs).
Senior Analyst Automation, BI and Pricing
- Analyzed costs, income, and profitability of the core business.
- Designed a BI portal to define prices for customers, resulting in a 65% decrease in non-useful reports.
- Automated data processing through ETLs in Python and SSIS.
- Led the implementation of a cost matrix for accurate profitability calculations, reducing manual work by 30%.
- Conducted in-depth measurement and analysis of 'pricing strategies' effectiveness in LATAM region
Revenue Management Flight Administrator
- Optimized flight revenue by an average of 2% compared to the previous year through strategic price and availability control.
- Successfully managed projects, including the automation of demand forecasting, resulting in up to 90% reduction in forecast time.
- Developed a comprehensive market information database using ETLs and competitive analysis, supporting data-driven decision-making.
- Provided leadership to a team of 4 analysts, ensuring effective collaboration.
Revenue cluster manager
- Collaborated with General Managers to maximize hotel capacity, resulting in a 30% reduction in incidents of unplanned rooms out of service.
- Worked closely with business units, sales departments, and e-commerce to implement effective pricing strategies, leading to a revenue increase of over 30% during high seasons.
- Conducted demand and revenue forecasting to define key performance indicators (KPIs) for the team.
- Utilized dashboards and ETL (Extract, Transform, Load) processes to calculate performance metrics and conduct competitive analysis using data from various databases.
Freelance full stack developer
- Developed a web portal for the management and collection of delayed containers for South America at Maersk (https://www.maersk-wsa.com/).
- Frontend: Utilized Bootstrap to create an intuitive user interface.
- Backend: Implemented PHP and CodeIgniter to ensure seamless functionality.
- Database Management: Oversaw administration of the database, reports, and dashboard within the application.
- Email Automation: Developed a module with customizable templates to send emails with attached PDFs.