Open to opportunities

Juan Sebastian Hernandez

@juansebastianhernand

Message

Bilingual Industrial Engineer specializing in data analysis and finance.

Colombia

Message

What I'm looking for

I am looking for a role that fosters innovation and collaboration, where I can apply my data analysis skills to drive impactful decisions.

I am a bilingual Industrial Engineer with a strong emphasis on data analysis and finance. My experience spans various roles where I have utilized tools such as Python, R, SQL, and Power BI to transform complex data into actionable insights. I am passionate about leveraging technology to drive decision-making, particularly in the fintech sector.

Currently, I work as a Capacity Optimization Analyst at Avianca, where I design and monitor revenue and sales reports, develop analyses for special negotiations, and create tools to enhance operational efficiency. My previous roles include serving as a Teaching Assistant for a Master’s program in Analytical Intelligence and interning as a Data Analyst, where I consolidated databases and tracked KPIs to maximize revenue.

Experience

Work history, roles, and key accomplishments

Current

Capacity Optimization Analyst

Current

Avianca

Feb 2024 - Present (2 years 4 months)

As a Capacity Optimization Analyst, I designed and monitored revenue, sales, and materialization reports for the groups department using Excel, R, and Power BI. I developed analyses for special negotiations in South America and created tools to improve operational efficiency, initiating a project projected to increase revenue by 10%.

Excel R Power BI Data Analysis Revenue Management Process Optimization Reporting Strategic Planning KPI Tracking

Teaching Assistant

Universidad de los Andes

Aug 2021 - Jan 2024 (2 years 5 months)

Supported advanced courses in machine learning, data analysis, and neural networks while organizing academic events and managing administrative tasks for student admissions.

Machine Learning Data Analysis Neural Networks Event Management Administration Course Assistance Team Collaboration Communication

Data Analyst Intern

Printoglass

Jun 2022 - Sep 2022 (3 months)

Consolidated databases in Excel with VBA and created reports while tracking KPIs to develop revenue maximization strategies.

Excel VBA KPI Tracking Reporting Data Analysis Strategic Development Problem Solving Communication

Education

Degrees, certifications, and relevant coursework

Universidad de los Andes

Minor, Business Administration

2021 - 2023

Completed a Minor in Business Administration, focusing on the principles of business management and administration.

Universidad de los Andes

Bachelor of Science, Industrial Engineering

2020 - 2023

Studied Industrial Engineering with relevant courses in Analytics for Decision-Making, Finance, Probabilistic Models, Negotiation for Decision-Making, and Statistical Learning for Data Analytics.