Learn Data Skills
Beta
Alejandro Ruiz Olivares

Alejandro Ruiz Olivares

Data Scientist

Amazon | Mexico

Technologies

My Portfolio Highlights

My New Workbook

Competition - Dance Party Songs

My New Course

Introduction to Python

Insightful puzzle solver, piecing together data fragments to reveal the big picture.

My Work

Take a look at my latest work.

DataLab

Competition - Dance Party Songs

course

Introduction to R

course

Introduction to Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Mexico City Environmental Agency | Nov 2021 - Feb 2023

Data Analyst

● Created a system to gather and analyze data on more than 12k workers training nationwide. ● Developed a SQL database in PostgreSQL and conducted ETL processes using R with more than 10 validation processes. ● Generated 2 national online informs in Looker Studio and Power BI used by Planning, Training, and Administration departments every day. ● Converted a month-long manual workflow into a three-hour automated sequence, delivering 30x more detailed regional data and drastically improving quality while saving 99% of the processing time. ● Created a System in R and SQL to validate current valid workers in 57 cities for weekly operation
Show More

UNAM | Oct 2021 - Dec 2021

Data Scientist

● Implemented the statistical analysis for the project "Geolocation Algorithms for Spatial Clusters Management" for 2 years. ● Analyzed more than 100,000 data points through statistical models such as GAMMs and GAM in R to model the influence of air pollutants like ozone and PM2.5 on respiratory diseases in Mexico City. ● Assessed a thesis related to geostatistics, which included two statistical approaches: the first using Kriging modeling and the second using multidimensional autocorrelation.

Mexico City Environmental Agency | Mar 2017 - Dec 2018

Data Analyst

●Analyzed air quality data of 7 pollutants in Mexico City using R. ● Automated the creation of plots for the website https://www.aire.cdmx.gob.mx/ incrementing the creation speed by more than 10 times and improving quality. ● Compiled three R libraries to automate data processing, including indicator analysis, descriptive statistics, and SQL queries. These libraries are still in use by the Air Pollution Statistical Team. ● Performed network analysis of PM2.5 mobile sensors for one month experiment in Cuernavaca, Morelos.

My Education

Take a look at my formal education

PhD in Machine Learning Optimization ModelsColegio de Postgraduados | 2023

About Me

Alejandro Ruiz Olivares

Data Scientist with 10 years of experience analyzing multi-sector data, leveraging statistical methods, Machine Learning and AI to deliver solutions. Experienced in spatial statistics, time series forecasting, and automating reports on BI platformsl

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free