Emilio Andrés O. Email & Phone Number

Santiago, Santiago Metropolitan Region, Chile

LLM Chatbot:Developed an internal chatbot for Sky Airline deployed on Streamlit and Kubernetes. Utilized Google's pre-trained LLM chat-bison.Payload [kg] Model Improvement:For the payload [kg] estimation model of flights, feature engineering was used to calculate new relevant variables for the forecast. Added moving averages and lag variables for various indicators for each flight, reducing the Mean Absolute Error (MAE) by 4 passengers and 100 [kg], resulting in a substantial… Show more LLM Chatbot:Developed an internal chatbot for Sky Airline deployed on Streamlit and Kubernetes. Utilized Google's pre-trained LLM chat-bison.Payload [kg] Model Improvement:For the payload [kg] estimation model of flights, feature engineering was used to calculate new relevant variables for the forecast. Added moving averages and lag variables for various indicators for each flight, reducing the Mean Absolute Error (MAE) by 4 passengers and 100 [kg], resulting in a substantial decrease in costs associated with cargo and fuel reloading for the aircraft.Connections Analysis:Conducted exploratory data analysis of passenger connection data to identify popular origin-destination routes and describe the demand behavior for these routes. Analysis was deployed using Looker Studio.No Show Prediction:Data collection and analysis in BigQuery to describe passenger no-show behavior. This phenomenon was modeled using historical flight itinerary variables. Show less

Lima, Peru

Sky Airline Payload Model Project:Architecture, development, and deployment of Machine Learning models using Google Cloud Platform's Vertex AI service. The CRISP-DM methodology was used to define business objectives and translate them into data mining objectives. Data was collected and preprocessed from the company's Data Warehouse, then exploited using statistical learning techniques to model the phenomenon under study. Finally, training and prediction pipelines for the models were… Show more Sky Airline Payload Model Project:Architecture, development, and deployment of Machine Learning models using Google Cloud Platform's Vertex AI service. The CRISP-DM methodology was used to define business objectives and translate them into data mining objectives. Data was collected and preprocessed from the company's Data Warehouse, then exploited using statistical learning techniques to model the phenomenon under study. Finally, training and prediction pipelines for the models were automated.With the constructed models, an ETL was created to accurately estimate the total payload of the aircraft.Other Projects at Sky Airline:• Migration and Data Ingestion from Various Sources to GCP, Construction of Scalable and Robust ETL Pipelines. Show less

Santiago, Región Metropolitana De Santiago, Chile

Retail Industry Project with Google Cloud Platform:• Designed, built, deployed, and monitored ETL/ELT processes using Apache Airflow, Cloud Composer, Cloud Functions, Cloud Pub/Sub, Cloud Storage, and BigQuery.• Utilized reporting and analysis tools/environments such as Google Data Studio.• Designed, implemented, and used machine learning models with Vertex AI and BigQuery ML to integrate them into the marketing campaign process.• Achieved business objectives in collaboration… Show more Retail Industry Project with Google Cloud Platform:• Designed, built, deployed, and monitored ETL/ELT processes using Apache Airflow, Cloud Composer, Cloud Functions, Cloud Pub/Sub, Cloud Storage, and BigQuery.• Utilized reporting and analysis tools/environments such as Google Data Studio.• Designed, implemented, and used machine learning models with Vertex AI and BigQuery ML to integrate them into the marketing campaign process.• Achieved business objectives in collaboration with Data Scientists, Data Analysts, Data Engineers, Product Managers, Managers, and other key stakeholders. Show less

La Serena, Coquimbo, Chile

Capstone Project for obtaining the degree of Industrial Civil Engineer:• Designed a master maintenance plan for non-industrial infrastructure.• Conducted activities related to the survey of non-industrial infrastructures.• Diagnosed and updated infrastructures and reported on the condition of assets related to habitability.

Iquique, Tarapacá, Chile

Designed an inventory control system in Access using SQL. Performed logistics management tasks, including food supply and fuel consumption control for the fleet.

Postgraduate Diploma In Business Intelligence, 6,9 / 7,0

In today's era, data is a critical part of how a business operates and differentiates itself in the marketplace. This is why organizations.

Diplomado De Arquitectura Cloud, 7,0 / 7,0

• Recognize the fundamental principles and techniques in building a Cloud architecture. • Understand and implement an application.

Diploma In Data Science

• Develop solid knowledge in the use of Python and its main libraries, as fundamental tools of the discipline. • Analyze data of a diverse.

Diploma In Data Science

The general objective of the Diploma in Data Science is to ensure that graduates are capable of managing advanced data analysis projects.

Industrial Civil Engineering, 5,7 / 7,0

A UCN graduate with a degree in Industrial Civil Engineer is a professional responsible for the sustainability of organizations.

Bachelor'S Degree In Engineering Sciences, 5,7 / 7,0