Learn Data Skills
Beta
Francisco López Ramos

Francisco López Ramos

Certified

Data Scientist

FPT Software | Monterrey

Technologies

AI aficionado, dancing with algorithms in the realm of possibilities.

My Work

Take a look at my latest work.

github

GitHub - flopez81/MOARP: Multi-Objective Aircraft Routing Problem

PythonGit
github

flopez81/NopalCropPlanning · GitHub

PythonGit
github

GitHub - flopez81/C5_Project_DS_Capstone: Final project for the Data Science Nanodegree of Udacity

PythonGit
github

GitHub - flopez81/MOARP: Multi-Objective Aircraft Routing Problem

PythonGit

My Certifications

These are the industry credentials that I’ve earned.

AI Fundamentals

AI Fundamentals

Data Literacy

Data Literacy

Other Certificates

HuggingFace Agents Course

Neo4j Neo4j Certified Professional

Neo4j Neo4j Graph Data Science Certification

UdaCity SQL

UdaCity Introduction to Machine Learning with TensorFlow

UdaCity Data Scientist

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Understanding Artificial Intelligence
Intermediate Python
Data Manipulation with pandas

My Work Experience

Where I've interned and worked during my career.

FPT Software | Aug 2023 - Present

Senior Operations Research Scientist

Main Tasks - Formulating Mixed-Integer Linear Programming (MILP) models for short to long-term maintenance task planning for Air Canada's aircraft fleets. - Working with FICO XPress solver under the Python language and conducting data retrieval and writing using SQL Server. - Reformulating MILP models for size reduction and linear relaxation tightening. - Developing warm-starts for the FICO XPress solver based on greedy heuristics. Exact & Heuristic approaches for a Single - Pickup Vehicle Routing Problem with multiple-use of vehicles. Integrated approach to Network Design and Frequency Setting Problem in Railway Rapid Transit Sytems A model for setting services on auxiliary bus lines under congestion - Devising decomposition approaches for solving large-scale instances of the models. - Code profiling for speeding up Python scripts and SQL queries. - Applying object-oriented programming to reuse code for implementing and testing different model formulations. - Design of unit tests for ETL processes, models, and algorithm validations. - Visualizing models' output using appropriate charts for presenting results to stakeholders - Collaborating with the Backend team on model deployment in Microsoft Azure. - Training on exploring, cleaning, and transforming data for building ML models to - Determine potential new customer segments to sell company products - Recommend books within IBM Watson Studio’s Platform - Build a disaster response pipeline - Build a deep Neural Network for an Image Classifier - Find potential donors for a charity company Key Accomplishments - Automated the scheduling of preventive and corrective maintenance tasks across short-, medium-, and long-term planning horizons - Developed automation for detecting unmet requirements in unscheduled tasks - Reduced Aircraft on Ground (AOG) time by an order of magnitude by enabling timely planning of part replacements before failures occur - Increased task scheduling capacity by 50% to 200% - Halved the average execution time of revised Python scripts and SQL queries - Reduced the average solving time of reformulated mixed-integer linear programs by 50%
Show More

Vueling Airlines | Jan 2020 - Jul 2023

Operations Research Scientist

Main Tasks • Formulated and implemented optimization models in Python API for CPLEX to optimize aircraft routing, flight scheduling, and tail number registration. • Extracted, transformed, and loaded data using SQL Server, Redshift, and manipulated dataframe structures in Python. • Designed WHAT-IF scenarios to validate optimization models and prioritized objectives under lexicographic goal programming frameworks. • Regression models to predict the minimum turnaround times at airports. • Time series-based models to predict the time buffers that need to be incorporated into aircraft rotations to make them more robust against delays in their assigned flights. • Clustering models to group aircraft with similar characteristics. • Collaborating with the Backend team on model deployment in AWS. • Presented results to stakeholders and at international AGIFORS conferences. Key Accomplishments - Automated decision-making processes for flight scheduling, aircraft routing, and tail assignment - Doubled revenue from the scheduled flights - Halved the number of aircraft required - Reduced flight cancellations caused by delays by an order of magnitude - Developed and deployed the first successful operations research (OR) tools into production - Secured increased investment in OR staffing by persuading the Director of AI - Co-supervised a Ph.D. thesis in operations research

TECNOLÓGICO DE MONTERREY | Jan 2016 - Jul 2023

Research Professor

Main Tasks Teaching innovative and high-quality lectures in the field of Operations Research and Data Science, highlighting especially: - Introduction to Operations Research - Laboratory in Operations Design and Optimization - Inventory Management and Master Planning Production - Optimization algorithms for last-mile delivery problems - Strategic Data Visualization - Development of Data Science projects Conducting linkage-related activities and research impacting the students' education and companies' productivity on: - Nopal Cactus production and harvest scheduling, predicting trends for nopal prices in the forthcoming years, using the Holt-Winters method. - Collecting and analyzing data for the retail system of last-mile delivery in Toluca using regression models to predict the models’ sensitivities to main factors and their correlations - Power network grid expansion with electricity pricing and regeneration - Daily last-mile delivery to convenience stores - Toll pricing, road expansion, and regulation of hazardous material vehicles - Global Investment Strategies with Financial Intermediation - Project portfolio selection in Lean Six Sigma - Territory planning and vehicle routing to deliver to OXXO and 7-Eleven stores - Determining robust aircraft rotation planning considering flight delays and cancellations for airlines. Key accomplishments - Published 7 papers in top-tier operations research journals, 5 as 1rst author - Supervised over 17 student theses, including 3 at the master’s level - Led student collaborations with Daimler, Banco de Alimentos de México, Grupo Moderna, Paquetería TresGuerras - Mentored a student team that reached the final phase of the MIT competition on innovating the traditional retail channel in Latin America - Successfully delivered MVPs for power grid expansion planning in Saudi Arabia and daily last-mile delivery optimization to convenience stores in downtown Querétaro - Achieved an average student grade above 90%

Pontificia Universidad Católica de Valparaíso | Jan 2014 - Dec 2015

Assistant Professor in Operations Research

Main Tasks • Continued personal research in optimization models for public transportation networks. • Conducted research in optimization models for shipping logistics, focusing on perishable fruit transportation. • Collaborated on research projects in optimization and simulation models for electric vehicle impact in distribution networks. • Built research teams for the aforementioned projects Key accomplishments - Supervised over nine student theses, including three at the master’s level - Secured competitive funding from the Fondecyt Initiation into Research program (awarded to only 25% of applicants) - Successfully delivered a minimum viable product for optimizing the shipment of perishable fruit for CoolCarriers from Chilean seaports to North America and Europe - Published two papers in top-tier operations research journals, including one as sole author - Achieved an average student grade above 70%

Universitat Politècnica de Catalunya | Sep 2009 - Dec 2013

PHD Student

Main Tasks • Research on OR models and their solving techniques for urban public transportation networks. • Network construction and line frequency setting in underground systems in Seville. • Network Expansion and global line frequency setting in Santiago de Chile underground. • Planning a bus bridging network for solving the service disruption of Madrid‘s RENFE underground operator from Atocha to Chamartin stations. • Use of probabilistic techniques based on queue models for catching programs' dynamic behavior. • Writing and publication of articles in refereed conferences and ISI journals. • Presentations at international conferences. • Research stays at excellence research centres in the Universidad Politécnica de Madrid and Universidad de Chile. Key accomplishments - Developed the first exact operations research framework for jointly solving network expansion and frequency setting in passenger railway systems - Published a paper in a top-tier operations research journal - Earned a Ph.D. with the distinction excellent cum laude - Secured competitive funding for the development of the Ph.D. thesis and two international research stays (awarded to fewer than 10% of applicants) - Successfully delivered minimum viable products for the metro network expansion and frequency planning in Seville, Spain, and Santiago de Chile, Chile

Universidad Autónoma de Barcelona | Sep 2005 - Aug 2009

Lecturer/Researcher

Main Tasks • Conducted research in optimization techniques and mathematical models for solving complex extensions of vehicle routing problems. • Studied and resolved goods pickup in a multi-product production plant, enhancing efficiency. • Participated in international seminars and conferences to stay updated on industry trends. • Taught practical lectures on Electronics Control Systems, Electrical Signals Analysis, Automatic Control and Industrial Automation, and Robotics. • Supervised final year projects in the fields of Industrial Automation and Control, as well as the modelling and simulation of industrial processes. Key accomplishments - Developed the first thesis at the university focused on an operations research problem - Earned a Research Master’s thesis distinction of excellent cum laude - Successfully delivered a minimum viable product for goods pickup and delivery to the depot in a multi-production plant setting - Presented and published an operations research paper at a prestigious international conference - Supervised three bachelor’s degree theses - Achieved an average student grade above 70%

My Education

Take a look at my formal education

PhD in Operations ResearchUniversitat Politècnica de Catalunya | 2014
Master Thesis in Computer Science. Advanced Production Techniques, Master Thesis, Master ThesisUniversitat Autònoma de Barcelona | 2008
Master Degree in Electronic Engineering. Codesign HW-SW, Master Degree, Master DegreeUniversitat Autònoma de Barcelona | 2005
Bachelor Degree in Technical Industrial Engineering. Industrial Electronics, Bachelor Degree, Bac...EUSS, Fundació Privada Rinaldi | 2003

About Me

Francisco López Ramos

Experienced Operations Research Scientist with 15+ years of expertise in optimizing logistics and processes across diverse industries, including Airlines, Energy, Agriculture, Transportation, Shipping, and Marketing.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free