José Carlos Soto Monterrubio
Data Analyst Sr Specialist at Merama- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Español Native or bilingual proficiency
-
English Professional working proficiency
-
French Elementary proficiency
Topline Score
Bio
Credentials
-
BigQuery for Marketing Analysts
QwiklabsMar, 2022- Nov, 2024 -
Dataiku DSS L2 - Advanced DSS design
DataikuDec, 2020- Nov, 2024 -
Dataiku DSS Level 1 Certification
DataikuApr, 2020- Nov, 2024 -
Applied Data Science with Python - Level 2
IBMJun, 2019- Nov, 2024 -
Data Analysis with Python
Cognitive ClassJun, 2019- Nov, 2024 -
Data Science Foundations - Level 2 (V2)
IBMJun, 2019- Nov, 2024 -
Data Science Methodology
Cognitive ClassJun, 2019- Nov, 2024 -
Data Science for Business - Level 2
IBMJun, 2019- Nov, 2024 -
Digital Analytics & Regression
Cognitive ClassJun, 2019- Nov, 2024 -
Machine Learning, Data Science and Deep Learning with Python
UdemyJun, 2019- Nov, 2024 -
Un Nuevo Algoritmo de Ramificación y Acotamiento para el Problema de la Bisección de Vértices
Sociedad Mexicana de Inteligencia ArtificialJun, 2019- Nov, 2024 -
AMOSA with Analytical Tuning Parameters and Fuzzy Logic Controller for Hetergeneous Computing Scheduling Problem
IEEE Computational Intelligence Society Mexico ChapterJan, 2019- Nov, 2024 -
CPLEX: Herramienta para la solución de problemas en las empresas
Instituto Tecnológico de Ciudad MaderoJun, 2018- Nov, 2024 -
jMetal: Herramientas de optimización inteligente
Instituto Tecnológico de Ciudad MaderoJun, 2018- Nov, 2024 -
AMOSA with Analytical Tuning Parameters for Heterogeneous Computing Scheduling Problem
IEEE Computational Intelligence Society Mexico ChapterJan, 2016- Nov, 2024 -
A Comparison Between Memetic Algorithm and Seeded Genetic Algorithm for Multi-objective Independent Task Scheduling on Heterogeneous Machines
IEEE Computational Intelligence Society Mexico ChapterOct, 2014- Nov, 2024 -
dbt Fundamentals
dbt LabsMar, 2022- Nov, 2024 -
Tableau Certified Associate Consultant
Tableau SoftwareJan, 2021- Nov, 2024 -
TOEFL ITP
CELLAP TampicoMay, 2015- Nov, 2024
Experience
-
Merama
-
Manufacturing
-
300 - 400 Employee
-
Data Analyst Sr Specialist
-
Apr 2023 - Present
-
-
Data Analyst
-
Sep 2021 - Mar 2023
Relevant activities:- Building pipelines to transform the raw data from diverse marketplace as (Amazon, Mercado Libre, Manual sources, APIs) to generate the necessary datasets to be consumed by dashboards and internal tools.- Building actionable dashboards to track KPI for Sales and Demand Planning.- Data Analyses to find relevant insights.Technologies:- BI tools: DataStudio/Looker, Tableau.- ETL: DBT- DWH: Snowflake/AWS-S3, BigQuery/CloudStorage
-
-
-
Closter
-
Mexico
-
E-learning
-
Senior Data Scientist
-
Mar 2021 - Present
General activities: - Formalize the requirements with customers and users to be aligned under business process. - Project planning for the development of the data science project. - Develop data science projects: problem analysis, proposal approach, data analysis, machine learning model development. Relevant projects developed: - Customer segmentation for a financial institution in Panama. We performa statistical analysis for customers and products to identify the relevant features. The customers were segmented with a clustering algorithm (K-means). Also, we build a dashboard in Power BI to track the most relevant KPIs in each cluster. - Sustainable Debt model for a financial institution. We modeled the problem as a linear programming model. This problems optimize the sustainable debt of a company considering diverse inputs as EBITDA, Interest rate, and debt duration by keeping the financial metrics (Debt Service, Indebtedness, interest coverage) in a specific range. The model was implemented in Pyomo and solved with IPOPT. Technologies: - BI: PowerBI - Ecosystem: Azure - Development: Jupyternotebooks, Python (CLI). Show less
-
-
-
Universidad Anáhuac
-
Mexico
-
Higher Education
-
700 & Above Employee
-
Professor
-
Oct 2020 - Present
Graduated courses with topics related to: - Business Intelligence (BI) - Business Analytics (BA) - Data Science - Big Data - Machine Learning - Advanced Analytics platforms - Introduction to python programming Graduated courses with topics related to: - Business Intelligence (BI) - Business Analytics (BA) - Data Science - Big Data - Machine Learning - Advanced Analytics platforms - Introduction to python programming
-
-
-
Raken Data Group
-
Chile
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Data Scientist
-
Sep 2019 - Aug 2021
I develop mathematical programming models and intelligent optimization algorithms for industrial production processes. - Mathematical programming: linear, no-linear, mixed, quadratic. - Metaheuristics: Genetic algorithms, NSGA-II, MOEA/D, and others flavors. - Results visualizations in Tableau and PowerBi. Relevant projects: - Quadratic programming model to optimize the price and demand of raw material. - Optimization of TV advertising campaigns under audience and budget constraints combining intelligent optimization and forecasting algorithms for a pharmaceutical company. - Products campaign design with analysis of customer segmentation for a consumer packaged goods company. Other activities: - Participation in the recruitment process for technical interviews. - Presentation of demos and PoCs. Technologies: - BI: Power BI, Tableau - ML: Dataiku, Python, R - DWH: Snowflake, Datameer Show less
-
-
-
Technology Jobs Careers
-
Higher Education
-
1 - 100 Employee
-
Ph-D. Candidate
-
Aug 2015 - Dec 2020
I developed intelligent optimization algorithms for multi-objective optimization problems applying strategies from linear programming models, branch-and-bound algorithms, and metaheuristics algorithms. I developed intelligent optimization algorithms for multi-objective optimization problems applying strategies from linear programming models, branch-and-bound algorithms, and metaheuristics algorithms.
-
-
-
Universidad de Cádiz
-
Spain
-
Higher Education
-
700 & Above Employee
-
Researcher Internship
-
Oct 2016 - Jun 2017
I performed research on parallel hybrid exact algorithms for solving multi-objective combinatorial problems. Developed for high-performance computing centers in distributed memory and shared memory architectures. I performed research on parallel hybrid exact algorithms for solving multi-objective combinatorial problems. Developed for high-performance computing centers in distributed memory and shared memory architectures.
-
-
Education
-
Universidad de Cádiz
Doctor of Philosophy - PhD, Computer Engineering -
Instituto Tecnológico de Ciudad Madero
Doctor of Philosophy - PhD, Computer Science -
Universidad de Cádiz
Estancia de Investigación, Ingeniería informática -
Instituto Tecnológico de Ciudad Madero
Master of Science - MS, Computer Science -
Instituto Tecnológico de Ciudad Madero
Engineer's degree, Computer Software Engineering -
Centro de Bachillerato Tecnológico Industrial y de Servicios 103
Técnico, Computación