Jhan Carlos Orozco Mercado has a diverse background in the field of data engineering and analysis. Their most recent experience includes working as a Data Engineer at Blue Orange Digital starting in 2022. Prior to that, they worked at Option as a Data Engineer for the Falabella team, where they worked on a GCP environment using BigQuery, SQL, and Gitlab.
Before joining Option, Jhan worked at Apex Systems as a Data Engineer for the Walmart/Sam's Club US team. In this role, they focused on queries and jobs related to ETL and ELT processes in an Azure Databricks environment. Jhan Carlos also designed and implemented notebooks using Python.
Jhan also has experience as a Data Scientist at Pabis Retail, where they deployed neural network models for sales forecasting using Amazon Sagemaker and ML Pipelines. Jhan Carlos automated CPFR processes using Amazon Lambda and S3 buckets.
Prior to their work as a data scientist, Jhan gained experience as a Sales Data Analyst at AF SUMINISTROS E.U. During this time, they analyzed sales data and created dashboards using Tableau. Jhan Carlos also designed and implemented an ETL process for a local database using MySQL.
Jhan's career also includes roles as a Data Analyst and Business Intelligence Developer at Infotec, Centro de Investigación e Innovación en TIC. In these roles, they were responsible for extracting and deploying dashboards for a web page using QlikView and Pentaho. Jhan Carlos also worked on web page design using Python, Dash, Plotly, Numpy, and Pandas. Jhan demonstrated expertise in ETL processes and working with databases like Oracle and DB2.
In addition to their professional experience, Jhan worked as a Specialized Tutor in Math at Universidad del Norte from 2015 to 2017.
Jhan Carlos Orozco Mercado has a strong educational background in Mathematics. Jhan Carlos obtained a Bachelor of Science (BS) degree in Mathematics from the Universidad del Norte, where they studied from 2014 to 2017. Following that, they pursued a Master of Science (MS) degree in Mathematics at the Centro de Investigación y de Estudios Avanzados del IPN from 2018 to 2020.
In addition to their formal education, Jhan Carlos Orozco Mercado has also obtained several certifications. These certifications include an Astronomer Certification DAG Authoring for Apache Airflow and an Astronomer Certification for Apache Airflow Fundamentals, both obtained in 2022. Jhan Carlos also holds a SQL (Advanced) Certificate from HackerRank obtained in 2022.
Other certifications acquired by Jhan Carlos Orozco Mercado include Applied AI with DeepLearning, AWS Fundamentals: Building Serverless Applications, Python (Basic), Introduction to Deep Learning & Neural Networks with Keras, Scalable Machine Learning on Big Data using Apache Spark, and Programa Especializado - IBM Data Science, all gained in 2020. Additionally, they have an AWS Certified Solutions Architect – Associate and an AWS Certified Cloud Practitioner certification from Amazon Web Services (AWS), obtained in 2021. Furthermore, they have obtained a dbt Fundamentals certification from dbt Labs in 2022.
Jhan Carlos Orozco Mercado also holds an EF SET English Certificate with a proficiency level of C2 (Proficient), although the specific date of obtaining this certification is not provided.
January, 2022 - present