Resume

Esteban Restrepo Lotero
Business Intelligence (BI) | Analytics | Project Management | Revenue Management | Strategic Pricing | Programmer | SQL | Python
Carrera 47 No 22 83
Bogotá
Colombia

The last 5 years I have built strategic reports to help the pricing and demand teams for Avianca, Decameron and PayU to make decisions that increased revenues. I have also worked together with sales teams to design and measure sales strategies.

I can collect, fix and generate value with data (ETLs, SQL, pivots, graphs), I am always learning new ways to do things better, I have always been interested in programming and I am very good at it. In addition to this, I have experience negotiating with different areas to carry out cross-cutting projects.

Experience
PayU
2022 - Actual
Senior Analist Automation - BI Pricing

Analyzed of costs, income and profitability of the core business.

  • Designed BI portal to define prices for customers. The number of not useful reports was decreased by 65%.
  • Automated data processing with ETLs in python and SSIS.
  • Led the project to implement a cost matrix to properly calculate profitability, reducing manual work by 30%.
Avianca
2013 - 2022
Revenue Management Flight Administrator

Identified for demand and capacity opportunities in domestic and international markets to increase revenue

  • Managed projects such as the process of automating demand forecasting, reducing forecast time by up to 90%.
  • Led group of 4 analysts
  • Designed of overbooking strategies with which spoilage was lowered by 5% while maintaining denied boarding at the same level.
  • Optimized of flight revenue by an average 2% compared to the previous year (Average), controlling price and availability strategies.
  • Built a data base of market information with ETLs and analysis of the competition to identify changes and action to do using BI tools.
  • Measurement of the effectiveness of pricing strategies in domestic
Decameron
2020 - 2021
Revenue Cluster Management

Maximizing revenue, market share and profit for hotels

  • Accomplished with the General Managers of the hotels to maximize capacity, the incidents of rooms out of service without planning were reduced by 30%.
  • Facilitated along with business units, sales departments and e-commerce to increase sales based on pricing strategies, increasing revenue in high seasons by more than 30%.
  • Forecasted demand and revenue to define KPIs for the team
  • Calculated performance and competitive analysis using dashboards and ETL from their databases.
Avianca
2011 - 2012
Revenue Managemen Systems Specialist

Functional administration of the PROS Revenue Management suite mainly PROS OD3, INFARE, PROS RTDP and other internal systems

  • Administered large company databases, including inventory and reservation information (More than 1000 million records).
  • Orchestrated the Revenue Management training program,
  • Headed projects that have an impact on Revenue Management systems, such as the implementation of PROS Real time dianamic pricing, which led to an increase in revenue of between 2% and 3%.
  • Centralized of the relationship between IT and Revenue Management
  • Developed of scripts in PHP and python for IFLIRR parsing and data loading.
Education
Universidad Militar Nueva Granada
Bussiness Management
Skills
Spanish
Language
English
Language
PHP
PHP programing language
Visual Basic for Aplications (Macros)
Excel programing language
Excel
Excel proficiency (Pivots, Grapfs, Fomulas, Formats)
SQL
SQL programing language (Oracle, SQL server, SQLite, Access, Mysql, PostgresQL)
Power Point
Power Point proficiency
Python
Python programing language
Chequera y una carta de su novia imaginaria. Practique sexo seguro usando un condn de ltex. Levitra sin receta italia, pero de momento no he tenido problemas. Farmacia 247 aprobada POR LA FDA. Viagra tarda aproximadamente una hora en hacer efecto. comprar cenforce Escoger la presentación sealada en tu receta médica además de seleccionar la concentración de activos 1253, from richard, le vistieron con un traje de oficial y le proporcionaron todo aquello que un oficial británico llevaría dinero.