AI Data Automation and Data Engineer with over 4 years of professional experience supporting Fortune 500 clients (Telcel, Citi Banamex). Hands-on in pipeline operations, multi-environment deployment, data reconciliation, and metadata governance. Currently building AI automation workflows with n8n and Python and Agentic AI.
May 2025 – Present
- AI voice sales agent for hardware distributor — inventory lookup + order tracking 24/7 (n8n, Docker)
- Automated fuel cost optimizer — scrapes 100+ gas stations, delivers top-3 via dashboard (n8n, Python)
May 2024 – Apr 2025
- Operated 150+ ADF pipelines processing 5M+ daily records; ingesting 500-600 .unl files via SFTP into ADLS Gen2 with Get Metadata validation against .verf control files, resolving failures on 24/7 on-call rotation
- Executed daily reconciliation through Databricks notebooks (SQL + PySpark) on Job clusters, applying MERGE on Delta tables and validating control figures via Azure SQL stored procedures
- Maintained CI/CD workflow through Azure DevOps Git integration, promoting pipelines across environments via ARM templates with naming conventions.
Feb 2023 – May 2024
- Maintained naming standards across Raw/Staging/Curated layers in ADLS Gen2; used Unity Catalog for lineage tracking, tagging policies, and naming compliance validation
- Processed metadata change requests via JIRA, running SQL-based validation against DAMA DMBOK conventions; maintained CNBV regulatory documentation in Confluence
Feb 2022 – Feb 2023
- Analyzed banking financial datasets using SQL/Excel for data reconciliation; built 10+ Power BI dashboards (DAX) for executive reporting
- Automated monthly validation of 500+ data attributes with Python (OpenPyXL, pyodbc), reducing processing time from 8 hours to 45 minutes
May 2018 – May 2021
- Cost-saving machining process optimization (+150 units/hour, 5% cost savings) and built Excel dashboards
Automated inventory health pipeline: dead stock detection, overstock alerts, and demand forecasting from raw ERP exports.
- Stack: Python, pandas, SQL Server, Streamlit, n8n Automation
- Live demo: inventory-autopilot.streamlit.app
ETL pipeline and interactive dashboard for fleet fuel consumption and route analysis.
- Stack: Python, pandas, SQLite, Streamlit
B.Eng. in Manufacturing Technologies Universidad Politécnica de Guanajuato, 2015
- IBM Data Warehousing Engineer — Coursera, 2024
- Google Data Analytics — Coursera, 2022
Spanish: Native | English: Intermediate (B1+, technical reading/writing)