Juan Pablo Cadena Aguilar

Data Master Analyst

Vitapro Ecuador•  April 2023 - Present•  Business Intelligence Department

Master data management through the ERP SAP system and MySQL data hub, which has improved the efficiency of the processes and the performance of data queries. Refactoring and continuous improvement of the automation scripts for ETL processes in Python, to increase operational efficiency and decrease processing times. Developed and maintained a Full-Stack solution using FastAPI and Streamlit for an MVP of a platform focused on technological solutions for Pricing Analytics.

Data Scientist

Kin Analytics•  July 2022 - January 2023•  Sports Analytics Department

Reduced metrics calculation and report generation time by 20% by cleaning the data pipeline and segmenting various classes and models. Implemented a website with Dash as a back-office to manage the KPIs of the football teams using AWS EC2 for scalable computing and S3 for multimedia data storage. Improved 10 HTML and CSS templates that identify key information from rivals in different customer competencies, to highlight their strongest and weakest metrics in reports.

Data Science Analyst

Corporacion Fernandez•  April 2021 - July 2022•  Digital Transformation Department

Increased store sales by 30% and reduced meat overproduction by approximately 25%, through the development and implementation of an automatic learning model for demand planning forecasting. Automated 100% of more than 3 manual ETL processes between multiple sources, achieving up to 90%-time reduction through daemons, validation, and data cleansing. Led the development of data science solutions in a portal implemented in FastAPI and React, improving the integration and automations of ETL processes and data analysis.