Skip to content
View iamhuitron's full-sized avatar
🎯
Focusing
🎯
Focusing

Highlights

  • Pro

Block or report iamhuitron

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
iamhuitron/README.md

Ian Miguel Delgado Huitrón

Software & Data Engineer · Co-Founder & Technical Lead at @Xaol-Studio
Informatics at UNAM (FES Cuautitlán) · Google Student Ambassador 2026 · Mexico City / State of Mexico

Portfolio XAOL Studio LinkedIn Email


01 · Architectural Focus

I design and build deterministic, zero-drift software systems and analytical data pipelines. My work focuses on high-throughput Mexican fiscal auditing (SAT CFDI 4.0 / Anexo 20 / Art. 69-B), vectorized columnar storage (Apache Parquet + DuckDB), macroeconomic econometric engines (Banxico SIE), and sub-second client-side web and mobile applications.

%%{init: {'theme': 'base', 'themeVariables': { 'primaryColor': '#141210', 'primaryTextColor': '#FAF8F5', 'primaryBorderColor': '#B89758', 'lineColor': '#B89758', 'secondaryColor': '#1D1A16', 'tertiaryColor': '#0D0C0A', 'mainBkg': '#141210', 'nodeBorder': '#B89758', 'clusterBkg': '#0D0C0A', 'clusterBorder': '#262420', 'titleColor': '#D4B87A', 'edgeLabelBackground': '#141210', 'fontFamily': 'JetBrains Mono, Plus Jakarta Sans, sans-serif' }}}%%
flowchart LR
    subgraph Sources["01 · Data & Fiscal Sources"]
        A1["CFDI 4.0 / 3.3 XML Streams"]
        A2["Banxico SIE Macro Series"]
        A3["POS & Retail Transactions"]
    end

    subgraph Core["02 · Deterministic Core & Lakehouse"]
        B1["Zero-Copy PyArrow & Parquet"]
        B2["Embedded DuckDB Vector SQL"]
        B3["Integer-Cents & Anexo 20 Math"]
    end

    subgraph Delivery["03 · Client & Edge Delivery"]
        C1["Next.js 16 / React 19 Web Apps"]
        C2["React Native + MMKV Mobile"]
        C3["Executive Audit & DIOT Exports"]
    end

    Sources --> Core --> Delivery
Loading

02 · Production Systems & Open-Source Registry

I. Data Engineering, ETL & Quantitative Analytics

Repository Architectural Scope Stack & Verification
sat-data-pipeline CFDI XML to Parquet ETL & DuckDB Engine
Streams raw CFDI 4.0/3.3 XML batches into Hive-partitioned Apache Parquet (año/mes) with vectorized SQL KPIs and $O(1)$ Art. 69-B EFOS screening.
Python DuckDB Tests
banxico-series-pipeline Macroeconomic Time-Series ETL (Banxico SIE)
Harmonizes USD/MXN FIX, 28-day TIIE, UDIS, and INPC series. Computes YoY inflation, Fisher real interest rates ($r_t \approx i_t - \pi_t$), and Pearson correlation matrices.
Python Arrow Tests
pyme-data-analytics Retail Data Science & Inventory Optimization
RFM customer quintile segmentation, ABC Pareto (80/20) revenue classification, Apriori market-basket lift rules, and Reorder Point (ROP) forecasting.
Python Models Tests
Statix Visual Fiscal Audit & Anomaly Detection Suite
Interactive Streamlit & Plotly analytics suite with exact Decimal reconciliation, z-score ($\sigma > 2.5$) outlier detection, and multi-sheet .xlsx ledger exports.
Streamlit Tests

II. Fiscal Engineering, FinTech & Transactional Cores

Repository Architectural Scope Stack & Verification
cfdi-sat-engine Zero-Dependency Python CFDI 4.0 Auditor & CLI
100% Python stdlib fiscal engine. Validates Anexo 20 tax equations, RFC syntax, UUID format, and screens SAT Art. 69-B blacklists in $O(1)$ time.
Python SAT CI
cfdi-sentinel In-Memory Client-Side CFDI Auditor & DIOT Generator
Zero-knowledge browser auditing for .xml and .zip invoice batches. Computes VAT/ISR balances, flags 72h PAC delays, and exports .xlsx workbooks.
Next.js Demo
nomina-matrix Net-to-Gross Payroll Solver & IMSS 2026 Matrix
Binary search solver converging to exact gross salary ($\pm $0.005\text{ MXN}$) in $< 25$ iterations, 5-branch IMSS employer burden, and LFT Art. 48/50 severance.
TypeScript Vitest
pyme-manager-core Deterministic POS, Inventory & Tax Core (@Xaol-Studio)
Integer-cents financial engine preventing IEEE 754 float drift, multi-tier pricing (RETAIL/WHOLESALE/MECHANIC), and PostgreSQL/SQLite schemas.
TypeScript CI

III. Cross-Platform Applications, SaaS & Combinatorial Solvers

Repository Architectural Scope Stack & Verification
Flowday Offline-First Productivity Suite & Native Android Widgets
Built with React Native 0.76 + Expo SDK 52 (New Architecture), sub-millisecond react-native-mmkv persistence, custom Kotlin AppWidgets, and CI APK releases.
Expo Web
UniSched-Optimizer Combinatorial University Schedule Solver & Local OCR
Backtracking CSP solver with geometric table reconstruction (pdfjs-dist + WebAssembly tesseract.js) and verified UNAM / IPN / UAM datasets.
TypeScript Tests
mj-cafe Specialty Coffee Pre-Order SaaS & Barista KDS (@Xaol-Studio)
3NF relational database (MySQL/SQLite), PHP PDO transactional API, digital loyalty stamp engine, and real-time Kitchen Display System.
PHP Live
whatsapp-networking-hub Zero-Server WhatsApp Community Parser & Directory
100% in-memory FileReader & IndexedDB parser that converts exported .txt community chats into a searchable professional directory.
Next.js Tests
rutina-optima Biological Performance & Time-Allocation Command Center
Sartorial Dark Editorial telemetry dashboard for circadian HGH optimization, V-Taper hypertrophy, and high-output academic/engineering scheduling.
Web LifeOS

03 · Technical Stack & Tooling

Python TypeScript DuckDB Apache Arrow PostgreSQL Next.js React PHP GitHub Actions


04 · Institutional & Executive Profile

  • Co-Founder & Technical Lead at XAOL Software Studio — Delivering bespoke transactional systems, POS/inventory engines, and fiscal auditing platforms for Mexican enterprises.
  • Google Student Ambassador (2026 Cohort) — Leading technical workshops on AI workflows, modern software engineering, and developer productivity at UNAM.
  • B.Sc. in Informatics — Universidad Nacional Autónoma de México (UNAM — FES Cuautitlán).

Pinned Loading

  1. sat-data-pipeline sat-data-pipeline Public

    ⚡ High-performance XML-to-Parquet ETL & embedded DuckDB OLAP engine for Mexican SAT CFDI 4.0 data lakes.

    Python

  2. pyme-data-analytics pyme-data-analytics Public

    📊 Retail Data Science & Inventory Analytics Engine for Mexican SMEs (RFM segmentation, ABC Pareto, Apriori basket).

    Python

  3. cfdi-sentinel cfdi-sentinel Public

    🛡️ 100% Client-side in-browser CFDI 4.0 fiscal auditor & SAT Art. 69-B blacklist sentinel with zero server costs.

    TypeScript

  4. nomina-matrix nomina-matrix Public

    💼 Mexican Payroll, Net-to-Gross Reverse Engineering & Labor Law (LFT / IMSS 2026) reverse calculator.

    TypeScript

  5. UniSched-Optimizer UniSched-Optimizer Public

    🗓️ Combinatorial university schedule solver using backtracking & constraint satisfaction with client-side OCR.

    TypeScript

  6. Flowday Flowday Public

    📱 Offline-first mobile productivity app with MMKV synchronous persistence, time-blocking and automated APK CI/CD.

    TypeScript 2