Juan Pablo Herrera Email and Phone Number

+ Pricing optimization. Determine optimal sell prices for a diverse inventory of over 15,000 used cars as well as optimal purchase price for over 19,000 different car models listed in the catalog. + Inventory mix optimization. Build an optimization model that generates a suggestion for the optimal mix of cars given a total inventory target. + Registers forecast. Developed a forecasting model for car registers in the web page using random forest and top down time series decomposition. Tools:AWS Sagemaker, S3, python, SQL, Glue.

+ Designed and developed a user-centric web-based tool and scenario simulator for The Coca Cola Company. This tool served the team to interact with a forecasting demand forecasting model for their products and the competitors and enabled the analytics team to analyze and evaluate the performance of products in the market.Tools: Python, dash, plotly, SQL, postrgres.

+ Developed a demand forecast model at product category granularity using the Bayesian structural time series algorithm for five different countries.+ Contributed to the development of ETL (Extract, Transform, Load) processes using AWS services such as Athena, Glue, S3, and SageMaker.+ Designed and developed a user-centered web-based tool using Dash, enabling users to create, store, and manage scenarios while interacting with trained models.

Develop NLP models with neural networks for text classification. Deploy conversational agents using Dialogflow.

In charge of business development

Standarize all operations across the company and document them in an operations manual including design, implementation and track of KPI´s for all operations team members.

Applied different frequency analysis methods to several time series datasets in order to find systems with fractal behaviors

Coded front end, responsive design web pages using HTML 5, CSS 3 and JavaScript