15 builds

Projects

A selection of software products, experiments, and systems work. Each one is presented as Problem, Solution, and Technical Highlights, with repository activity pulled live from GitHub.

Data Engineering · FinTech

2026

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 ArrowParquetlxmlSAT CFDI 4.0pytest

GitHub

Python0updated 3m agoView repository

Data Engineering · Econometrics

2026

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 ArrowParquetEconometricspytest

GitHub

Python0updated 2h agoView repository

Data Analytics · Data Science

2026

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 ScienceRFM Analysispytest

GitHub

Python0updated 2h agoView repository

Algorithms · Web Development

2025–2026

UniSched Optimizer

Conflict-free class schedules, solved automatically with backtracking

A client-side optimizer that parses catalogs in the browser, searches conflict-free combinations via backtracking, and detects time clashes in real time.

Key Architecture & Impact

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

Next.jsTypeScriptReactpdf.jsTesseract.js

Live Demo GitHub

TypeScript0updated 1w agoView product

FinTech · Data Analytics

2026

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 CSSFast XML ParserSheetJSVitest

Live Demo GitHub

TypeScript0updated 1w agoView product

FinTech · Algorithms

2026

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 CSSSheetJSVitest

GitHub

TypeScript0updated 1w agoView repository

Software Engineering · FinTech

2026

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 20Node.jsCI/CD

Live Demo GitHub

View product

FinTech · Automation

2026

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 ActionsCLI

GitHub

Python0updated 2h agoView repository

Web Development · Privacy

2026

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.jsTypeScriptReactIndexedDBTailwind CSS

Live Demo GitHub

TypeScript0updated 1w agoView product

Mobile · Productivity

2025

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 NativeExpoTypeScriptZustandMMKVGitHub Actions

Live Demo GitHub

TypeScript2updated 1w agoView product

Data Analytics · FinTech

2025–2026

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

PythonStreamlitReportLabPandaspytest

GitHub

Python0updated 1w agoView repository