Skip to content
@iamhuitron

Software & Data Engineer · Co-Founder @ XAOL Studio · UNAM

Co-Founder @Xaol-Studio · Google Student Ambassador 2026 · Open to Select Roles

Ian Miguel Delgado Huitron

I build production-grade software end to end: cross-platform mobile apps with React Native & Expo, performant web platforms with Next.js & TypeScript, and algorithmic data tools with Python. Backed by public accounting and municipal audit experience, I write code that handles business logic, edge cases, and data integrity with extreme care.

View CV / RésuméLinkedInGitHubAll projects
Core Engineering Stack (ATS Snapshot)
🎓 UNAM FES Cuautitlán📍 CDMX / Estado de México🌐 English (B2)
Data Engineering:Python (DuckDB & PyArrow)Language:TypeScriptWeb:Next.js & ReactMobile:React Native / ExpoDatabases:PostgreSQL & SQLiteData Analytics:Analytical SQL & ParquetSystems:Go & JavaDevOps:GitHub Actions (CI/CD)
Differentiator:Hybrid profile combining UNAM Informatics with public accounting & fiscal audit background. Strong grasp of financial reconciliation, data consistency, and production constraints.

Selected projects

Software built around real constraints.

Explore all projects
UniSched Optimizer product screenshot
Product preview2025–2026

Featured product · 2025–2026

UniSched Optimizer

Conflict-free class schedules, solved automatically with backtracking

Problem
UNAM students face conflicting schedules across hundreds of course sections published only in PDF catalogs or photos.
Solution
A client-side optimizer that parses catalogs in the browser, searches conflict-free combinations via backtracking, and detects time clashes in real time.
Technical highlights
  • Optimization: Backtracking & constraint satisfaction across section combinations
  • Data processing: In-browser PDF parsing and client-side OCR without backend latency
  • Validation: Instant clash detection with verified university course catalog
  • Client-side architecture: Zero server dependencies — 100% private in-browser computation
Next.jsTypeScriptReactpdf.jsTesseract.js
Live Demo GitHub
TypeScript0 stars

More selected work

13 builds

Data Engineering · FinTech

SAT Data Pipeline

XML-to-Parquet lakehouse & DuckDB analytics engine for Mexican SAT CFDI 4.0 invoices

A high-performance Python fiscal data lakehouse that extracts raw CFDI 4.0 XMLs, batches records via Apache Arrow, generates Hive-partitioned Parquet datasets, screens against SAT EFOS blacklists in O(1) time, and runs sub-second analytical SQL via DuckDB.

Key Architecture & Impact

  • Streaming XML ETL: Memory-constant chunked parsing via lxml with Anexo 20 namespace handling
  • Columnar storage: Zero-copy Apache Arrow batching into Hive-partitioned Parquet (year/month)
  • Embedded OLAP: Sub-second analytical SQL queries over hundreds of thousands of invoices via DuckDB
PythonDuckDBApache ArrowParquet
GitHub
Python0updated 2d ago

Data Engineering · Econometrics

Banxico Series Pipeline

Automated econometric ETL & time-series analytics engine for Mexican central bank data

An automated time-series ETL pipeline and econometric engine that ingests Mexican central bank (Banxico SIE) indicators, stores them in an embedded DuckDB lake with Apache Arrow, and calculates real-time financial metrics like YoY inflation, real interest rates (Fisher equation), and asset correlations.

Key Architecture & Impact

  • Macroeconomic data ingestion: Robust HTTP ETL for Banxico SIE series with token authentication & fallback caching
  • Econometric modeling: Automated Fisher equation computation (nominal TIIE vs. YoY INPC) and cross-series Pearson correlation matrices
  • Zero-copy analytics: Fast bulk ingestion and Parquet partitioning using Apache Arrow and DuckDB OLAP
PythonDuckDBApache ArrowParquet
GitHub
Python0updated 2d ago

Data Analytics · Data Science

PyME Data Analytics

Transactional retail data science & inventory intelligence engine for Mexican PyMEs

A zero-cost transactional data analytics engine that ingests retail sales and customer histories to produce automated RFM customer segmentation, ABC Pareto (80/20) inventory categorization, Market Basket association rules (Support, Confidence, Lift), and Reorder Point (ROP) inventory safety stock calculations.

Key Architecture & Impact

  • Customer segmentation: Quantile-based RFM (Recency, Frequency, Monetary) scoring with automated cohort categorization (Champions, At Risk, Hibernating)
  • Inventory optimization: ABC Pareto classification and statistical Reorder Point (ROP + Daily Consumption) forecasting
  • Market Basket analysis: Apriori association rule mining computing Confidence and Lift to identify cross-selling item pairs
PythonDuckDBApache ArrowData Science
GitHub
Python0updated 2d ago

FinTech · Data Analytics

CFDI Sentinel

In-browser CFDI 4.0 fiscal auditor & SAT Art. 69-B blacklist sentinel

A 100% client-side web application that audits bulk CFDI 4.0 XMLs and ZIPs directly in browser memory, cross-checking RFCs against the official SAT Article 69-B blacklist, validating Anexo 20 math, calculating DIOT obligations, and exporting multi-sheet Excel workbooks with zero server exposure.

Key Architecture & Impact

  • Privacy-first architecture: In-memory XML parsing and ZIP decompression via Web Workers with zero server dependencies
  • Regulatory intelligence: Instant offline O(1) cross-reference against SAT Article 69-B EFOS blacklist (Definitivo, Presunto)
  • Audit engine: Algorithmic validation for Anexo 20 tax formulas, RFC regex compliance, and duplicate UUID detection
Next.jsTypeScriptReactTailwind CSS
Live Demo GitHub
TypeScript0updated 2w ago

FinTech · Algorithms

Nomina-Matrix

Mexican payroll reverse-engineering (Net-to-Gross) & IMSS 2026 labor suite

A high-precision client-side payroll engine that inverts progressive income tax curves (ISR Art. 96) using binary search, computes granular 5-branch IMSS employer/employee quotas with 2026 progressive pension reforms, and simulates constitutional severance packages with statutory tax exemptions.

Key Architecture & Impact

  • Algorithmic optimization: Sub-cent binary search convergence resolving Net-to-Gross salaries in < 25 iterations
  • Regulatory intelligence: Full compliance with 2026 Mexican social security reforms (IMSS RCV progressive employer tier)
  • Labor law compliance: Statutory LFT termination simulator (Constitutional 3-month indemnity, 20 days/yr, and 90-UMA tax exemptions)
Next.jsTypeScriptReactTailwind CSS
GitHub
TypeScript0updated 2w ago

Software Engineering · FinTech

PyME Manager Core

Deterministic TypeScript & SQL retail engine with SAT Anexo 20 compliance

A lightweight, deterministic core engine built on integer-cents financial arithmetic, ACID-compliant relational schemas (PostgreSQL / SQLite), atomic stock checks, and Mexican SAT Anexo 20 tax formulas.

Key Architecture & Impact

  • Integer-cents precision: Complete elimination of IEEE 754 float drift across lines and discounts
  • Relational DDL: Complete PostgreSQL and SQLite schemas with CHECK constraints and POS indexes
  • Tax reconciliation: Multi-rate VAT aggregator (16%, 8% border, 0%, exempt) conforming to SAT rules
TypeScriptPostgreSQLSQLiteSAT Anexo 20
Live Demo GitHub

FinTech · Automation

CFDI SAT Engine

High-performance Python fiscal auditor & SAT Art. 69-B (EFOS) sentinel

A pure standard-library Python package and CLI that validates Anexo 20 math, checks RFC validity, screens against the official SAT Article 69-B EFOS blacklist in O(1) time, and generates automated audit reports.

Key Architecture & Impact

  • Zero-dependency architecture: Built strictly on Python 3.10+ standard library (xml.etree, decimal, csv, re)
  • High-throughput screening: O(1) in-memory hash verification against official Mexican tax fraud blacklists
  • Rigorous Anexo 20 compliance: High-precision decimal arithmetic validation for tax withholding and VAT transfers
PythonXMLSAT CFDI 4.0GitHub Actions
GitHub
Python0updated 2d ago

Web Development · Privacy

WhatsApp Networking Hub

Client-side networking directory from WhatsApp group chats

A 100% client-side web application that parses exported chat logs locally in browser memory, building a searchable directory with one-click social profiles without storing data on any server.

Key Architecture & Impact

  • Privacy-first architecture: Zero backend and zero telemetry — processed entirely in-browser via File API
  • Local persistence: Client-side storage using IndexedDB and localStorage
  • Performance: High-speed in-memory text parsing and normalization without external API latency
Next.jsTypeScriptReactIndexedDB
Live Demo GitHub
TypeScript0updated 2w ago

Mobile · Productivity

Flowday

Offline-first mobile productivity with automated CI/CD pipeline

A cross-platform React Native / Expo application built on the New Architecture with high-performance local storage (MMKV + Zustand) and automated APK releases via GitHub Actions.

Key Architecture & Impact

  • Mobile architecture: React Native & Expo SDK 52 with Expo Router and NativeWind
  • Offline-first state: High-performance Zustand store persisted with MMKV
  • DevOps / CI/CD: Automated GitHub Actions pipeline building and signing Android APKs
React NativeExpoTypeScriptZustand
Live Demo GitHub
TypeScript2updated 2w ago

Data Analytics · FinTech

Statix

Municipal fiscal audit analytics & invoice reconciliation engine

A Python analytics and automated auditing engine born directly out of municipal government accounting experience that digests raw fiscal XMLs, reconciles ledger discrepancies, cross-checks tax retentions, and generates audit-ready PDF compliance reports.

Key Architecture & Impact

  • Municipal accounting domain logic: Codified Mexican municipal public finance rules and audit checklists
  • Automated fiscal reconciliation: Multi-way reconciliation algorithm matching bank movements against SAT CFDI XMLs
  • Executive PDF reporting: Automated generation of structured audit reports with ReportLab
PythonStreamlitReportLabPandas
GitHub
Python0updated 2w ago

Software Engineering · Systems & Networking

NetNaval

Battleship meets real-time chat, built for LAN play

A Wails desktop app combines a Go system layer with a React interface for LAN multiplayer, peer-to-peer play, chat, and AI opponents.

Key Architecture & Impact

  • Architecture: Go and React connected through Wails
  • Networking: LAN and peer-to-peer multiplayer
  • Real-time features: chat alongside game state
GoReactWails
GitHub
Go0updated 2w ago

Web Development · Education

AI Insights

AI and machine learning, explained through interaction

An interactive, responsive educational site uses visual presentation to explain AI, machine learning, and emerging technology.

Key Architecture & Impact

  • Information architecture: concepts organized as a learning experience
  • Front-end delivery: responsive web interface
  • Visual communication: interaction supports explanation
JavaScriptSCSS
Live Demo GitHub
SCSS1updated 2mo ago

Web Development · AI/Automation

Titulación AI

Streamlining graduation paperwork with AI-assisted tracking

A hackathon platform organizes document verification, application tracking, and academic completion workflows in one place.

Key Architecture & Impact

  • Workflow architecture: verification, tracking, and completion
  • Automation: AI-assisted tracking for paperwork-heavy processes
  • Product scope: academic completion workflow
PHPHTML
Live Demo GitHub
HTML1updated 2mo ago

Differentiator

Engineering with fiscal & operational rigor.

I am Ian Miguel Delgado Huitron, an Informatics student at UNAM — FES Cuautitlán. Before focusing on full-stack and mobile software, I worked in municipal government accounting and financial auditing.

That experience fundamentally shapes my engineering philosophy: I don't just build interfaces—I build software that respects strict business rules, guarantees data integrity, automates tedious manual processes, and stays rock-solid under edge cases.

01

Mobile & Web

React Native, Expo & Next.js architectures

02

Automation & Data

Python & ReportLab automating fiscal workflows

03

Systems & Logic

Backtracking algorithms, OOP Java & Go

Read full backgroundView full CV / Résumé
Immediate Availability

Ready to build, scale, and deliver.

I am actively seeking Software Engineering roles and I am open to taking on freelance projects through my agency, XAOL Studio. Whether you need to scale your engineering team or build a digital product from scratch, I deliver clean, reliable, and scalable software.

📍 CDMX / Estado de México · Open to Remote, Hybrid & On-Site

View CV / Résumé
LinkedInGitHubContact Form