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.
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%.
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
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.
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.