Work Experience
Department Chief | BI Analyst at Verificación Responsable
Sector: Public, Environmental Protection (SEMADET). Mexico
01/06/2020 - 15/08/2024
As Department Chief, led technical staff in vehicle and equipment testing, process improvement, and data analysis for the vehicle inspection program.
- Led data analysis on various operational phenomena within the vehicle inspection program, from operational performance to identification of exploided system vulnerabilities.
- Performed internal audits of operational data to ensure compliance with state and federal vehicle inspection standards across data sources such as ODS and APIs.
- Spearheaded a data-driven culture across the organization to support and enhance business processes and decisions.
- Wrote SQL and Python scripts to automate data processing, quality checks, report generation, and data distribution.
Project Engineer at Vectro Rastreo Vehicular
Sector: Private, B2B and B2C. Mexico
01/06/2019 - 01/05/2020
Configured and tested GPS, RFID, Sigfox, and MDVR devices for different type of transportation vehicles and industries.
- Configured and tested GPS tracking devices for passenger vehicles, semi-trucks and stock trucks.
- Tested different technologies like RFID, MDVR, and Sigfox for later integration in the portfolio.
- Built small prototypes with Arduino Uno and ESP32 for sensors and actuators integration with GPS devices.
Projects
BI Framework
Organization: SEMADET
Took initiative to safeguard, document, and enhance data assets across the organization to enhance business processes and to mitigate bad data practices. All of this with the support of the IT Department Chief and the Operations Department.
- Conducted gap analysis across data sources to assess feasibility and viability to implement the BI framework.
- Drafted project documentation such as scope, objectives, benefits, actions to be taken, budget, risks, and success criteria.
- Integrated 2 Software Jr. Engineers to increase IT's team size.
- Defined BI Technical Architecture alongside the IT Department Chief.
- Deployed and configured Airflow and Airbyte on a single Ubuntu server to orchestrate ETL/EL pipelines, integrating AWS and GCP services.
Comparative Analysis: Federal Standard Vs Japanese Automobile Manufacturer
Organization: SEMADET
Led analysis comparing federal diesel inspection standards with a Japanese manufacturer's alternative to uphold regulatory integrity.
- Defined scope, methodology for vehicle testing, quality assurance controls, and structure of the final report
- Defined alongside a multi-disciplinary engineering team the data processing steps to deliver key insights
- Leveraging descriptive statistics, graph we demonstrated a favorable and biased outcome for the manufacturer if applied its proposed method.
- Set a precedent for continuous monitoring to enforce the compliance of the NOM-045-SEMARNAT-2017
School Projects
Data Science and Data Engineering projects
School: EPITA
These are some of the projects that I've worked on during my MSc.
- Conducted in-depth analysis of France Travail data-related job offers for their classification; cleaned and prepared datasets for ML models. Built BiLSTM from scratch with PyTorch, and built Grounded LLM + RAG LangChain Chatbot to share insights.
- Using Pandas, Numpy, Sklearn, and Seaborn. Preprocessed, modeled, trained, tested, validated, predicted house prices with a linear regression model, finally industrialized the code in alignment with best practices.
- Social Network Clustering: Airflow deployment in docker containers, wrote data ingestion and prediction dags, and automated data quality checks with Great Expectations Core.
- Conducted data analysis on Mexico's air quality data from monitoring stations to show how particulate matter concentration changes each season, enriched dataset with Mexican government's data of monthly precipitation figures.
Rubber-Tracked Solar Panel Cleaning Robot
School: CETI Colomos
Designed and built prototype of solar panel cleaning rubber track robot with IR edge detection
- As a team of two, we developed a prototype of a rubber-track robot for cleaning solar panels.
- Conducted market research and defined technical specifications with guidance from a faculty advisor, keeping costs low.
- Designed the chassis and electromechanical components in SolidWorks; fabricated key parts using school machinery.
- Integrated sensors, microcontroller (CIKU PIC18F4550), DC motors, batteries, and additional electronics.
- Despite halting the project due to COVID and scope creep, I gained hands-on experience in design, prototyping, and project management.
- This project played a key role in securing job interviews and my last two professional experiences.
Learning Recommendations
Books
This is a non-exhaustive list of books that I recommend to have solid bases as a data professional
Youtube Channels
These are the youtube channels that I frequently watch to learn something new.
