Juan José Murillo Celi

• Forecasting and Optimization: Implemented an analysis model to predict course demand and optimize resource allocation.
  Software Implementation: Led the implementation of comprehensive planning software, enhancing efficiency and collaboration among coordinators.
  Automation and Analysis: Developed automated processes using Python and Excel macros for schedule creation, improving time efficiency and accuracy.
  Process Improvement: Applied Lean methodology to eliminate inefficiencies and streamline planning processes.
• Mass Schedule Creation: Designed and implemented an optimization tool to generate first-semester schedules, managing parameters such as gap hours, equitable distribution of class times, and daily class duration. This achievement ensured student satisfaction for the first time in the university's history.

University Professor for the exercise component of 4 introductory classes in C++ and Python for polytechnic students.

• Calculation, Extraction, and Visualization: Used Python, Tableau Prep, and SQL to calculate, extract, and visualize over 40 KPIs for a renowned Japanese pharmaceutical company, enabling strategic decision-making for senior management.
• Time Reduction: Reduced data extraction time from a full workday to just 2 hours by integrating Python and SQL code.
• Trading Bot Implementation: Developed a trading bot in C++ based on client-provided trading logic.

• Cost Estimation Model: Developed a supervised Machine Learning model to estimate transportation costs, involving extensive data cleaning and preprocessing to ensure accuracy and reliability.
• Supply Chain Optimization: Developed a mathematical model to optimize the supply chain across 3 plants, 7 distribution centers, and 100 distribution zones.
• KPI Development and Monitoring: Designed and tracked key performance indicators for 7 distribution centers.

• Inventory Management System Implementation: Deployed an online inventory management system for over 300 SKUs, providing real-time accessibility to information for all clients.
• Data Collection and Process Integration: Gathered key data from each distribution center to develop integrated processes across the entire company.
• Data Collection Application: Implemented an application to collect information for a national-level POP implementation project, covering over 15,000 locations.