Open to opportunities

Andres Treviño

@andrestrevio

I build supply chain optimization platforms, data pipelines, and analytics that reduce scrap, inventory, and manual work.

Mexico

Message

What I'm looking for

I'm looking to keep building data, optimization, and analytics solutions that improve supply chain and operational decisions, automate manual processes, and deliver measurable business results.

At Ternium, I own a mill allocation platform that uses Python optimization models to balance demand, production, and inventory across plants. The platform has reduced measured scrap by 20% year over year and maintained warehouse stock 63% below baseline for seven months.

I've rebuilt planning workflows with FastAPI, React, TypeScript, Node.js, and direct database writes, reducing an end-to-end cycle from 6–8 hours to 15–20 minutes. I also maintain 30 recurring pipelines and middleware that eliminate 45–70 hours of manual work each month.

My work spans foreign-trade ETL, large-scale datasets, automated Board-level reporting, and production optimization. I bring an Industrial & Systems Engineering background and enjoy turning complex operational data into practical decisions.

Experience

Work history, roles, and key accomplishments

Current

Supply Chain Planning Analyst

Current

Ternium

Mar 2026 - Present (6 months)

Owns the mill allocation platform with 8 optimization projects and 12 solvers, cutting scrap generation 20% year over year and holding warehouse stock 63% below baseline. Rebuilt the platform on FastAPI and React, reducing cycle time from 6-8 hours to 15-20 minutes.

Python fastAPI React TypeScript NodeJS Optimization OR Tools CP SAT Solver NSGA II SQL Server Snowflake Power BI ETL Data Pipelines

Global Trainee, Planning USA

Ternium

Jul 2025 - Mar 2026 (8 months)

Designed ETL pipelines in Python and SQL Server over foreign-trade data up to 1 billion records, replacing manual Excel processes. Built an eight-module app integrating U.S. Census Bureau trade data with end-to-end orchestration and automated reporting.

Python SQL Server ETL Data Engineering Snowflake Web Scraping Data Quality Automation Power BI Reporting

Industrial Engineering Internship, Order Management

Ternium

Dec 2024 - Jun 2025 (6 months)

Developed a multi-objective optimization model (NSGA-II) for allocation of customized products, cutting scrap at a bounded and quantified safety-stock cost. Published and presented the model at the 10th IEOM North American Conference.

Optimization NSGA II Multi Objective Optimization Python Data Analysis

Collaborating Researcher, SURE Program

University of Michigan / NASA

Jun 2024 - Jan 2025 (7 months)

Conducted predictive analysis for the University of Michigan-NASA project on operator manual takeover during simulated autonomous docking maneuvers.

Predictive Analysis Data Analysis Machine Learning Python

Systems Engineering Internship

Alen Group

Dec 2023 - May 2024 (5 months)

Developed a strategic plan to implement Power BI in Logistics and improve KPI retrieval processes through Lean tools.

Power BI Lean Tools KPIs Process Improvement

Internship Ternium Steel Challenge, Commercial Area

Ternium

Jun 2023 - Aug 2023 (2 months)

Benchmarked with competitors' websites to improve business performance.

Benchmarking Competitive Analysis Web Research

Member of the Student Chapter

American Society for Quality (ASQ)

Aug 2022 - May 2023 (9 months)

Served as Treasurer and Sponsorships for the XXII Quality Day International Conference.

Event Planning Sponsorship Leadership

Education

Degrees, certifications, and relevant coursework

Tecnológico de Monterrey

Certificate, Data Science and AI

2026 - 2026

Completed a Data Science and AI certificate (120 hours) and an Autonomous Domain Integrative Project (160 hours) applied to a Big Data project at Ternium.