Luis Eduardo Carrera Bernal

2024 – Present · approx.

Technical Operations Lead — Architecture, QA, Releases & Data Migrations

Mecánica MX (rejoined) — B2B SaaS for auto-repair shops

• Designed the architecture and 6-VPS production (TypeScript, Node.js, tRPC, Prisma, MySQL/PostgreSQL, Redis) with per-server observability dashboards and a dedicated enterprise-client environment.
• Directed the build of a CRM (6,000+ contacts, health score, churn risk), a Customer Success system (KYC scoring, 14-day SLAs, 3-level protocol; 300+ active accounts) and WhatsApp automation (Evolution API, 4 scoring strategies) that removed ~60 h/month of manual work; integrated LLMs (Claude, Gemini, OpenAI) for ticket triage and summaries.
• Led research and QA for the CFDI 4.0 e-invoicing integration; led 10+ on-site implementations and 100+ remote deployments.
• Gate every release: test each sprint ticket in QA, approve or return it, and re-validate in production (76 approved, 18 returned, 30 production validations); E2E matrices of 13–45 test cases during the AngularJS → React migration. Found a session token in plain text in server logs; validated a search fix on a ~30,000-customer account (6 searches in < 0.9 s).
• Migrated 8,339 historical orders from 3 branches' Excel exports to production with 0 errors via an auditable ETL pipeline (Excel → JSON → database; dry-run → QA → production, reconciled against source); later 2 more branches.
• Data correctness: loaded a 5,908-part catalog into 24 fleet-client accounts, caught 3 defects in the first purchase load and rebuilt it with supplier deduplication (tax ID (RFC) → name → alias); root-caused a bulk correction counting ~3,400 packages instead of 11,934 (pagination without ORDER BY) and validated ~21,539 labor concepts and ~11,934 packages in production.
• Own L2/L3 escalations, collections and renewals (SQL diagnosis, authorized data fixes): one campaign regularized 11 of 22 overdue accounts. Redesigned CS scorecards into 4 automatic KPIs.
• Mentor new team members and review the support team's work; built N1–N3 playbooks, role-based training and tutorials.

QA release gate →Data migration →Pagination root cause →

2022 – 2024 · approx. · full-time

Head of School Records & Supervision Department, Registrar's Office (DAE), IPN

Instituto Politécnico Nacional, one of Mexico's largest public universities

• Led teams of up to 40 people (developers, QA, support, analysts).
• Led operations of the critical student-information systems (SAES/SICOES): 490+ modules across 52 campuses.

2022 – 2023 · approx. · project-based, in parallel

Head of Implementations

Vengala Company

• Led customer implementations end to end: planning, resourcing, process design with clients, user training and pre-delivery testing.
• Built web interfaces (HTML5, CSS3, JavaScript, AngularJS) and WordPress/Shopify e-commerce stores.

2020 – 2022 · approx.

Software Developer

Mecánica MX — B2B SaaS for auto-repair shops

• Front-end development of the web app in AngularJS: invoice validation, role-based filters, tax and diagnostics fixes, English localization of the UI and cost and sales dashboard charts.

Sep 2026 – Present

Architecture Lead (side project)

REYBER — multi-tenant insurance platform for carriers and insurance agencies

• Defined Phase 1: 25 research and requirements documents, 71 business rules, 36-package build plan.
• Chose the dynamic-attribute data model with a falsifiable benchmark on 10,000,000 synthetic policies under RLS (6× less index: 492 vs 3,030 MB; 1.2 ms vs 118 ms on a two-attribute filter); CI/CD on GitHub Actions with RLS and tenant-isolation tests on every push.

Case study →

Aug 2026 – Present · maintenance mode

Product & Software Architect (independent project)

VetNova — multi-tenant B2B SaaS for veterinary clinics · vetnova.mx

• Took a multi-tenant SaaS from zero to production-ready as sole technical owner, with Claude Code as the implementer: I wrote the specs and architecture rules, did code review on every change and owned QA. Pre-revenue; live at vetnova.mx.
• Tenant isolation in PostgreSQL via Row-Level Security rather than application filters (137 tables, 125 tenant-scoped, permission-based RBAC); 722 REST routes (NestJS), 117 Next.js/React screens, Stripe and SPEI bank-transfer payments, Mexican tax e-invoicing (CFDI 4.0) and a WhatsApp appointment assistant.
• Quality gates as infrastructure: 107 end-to-end smoke tests against the real API, 96 hand-written versioned migrations, mandatory 2FA and encrypted backups with tested restore; every decision documented with its trade-offs.

Case study →

2018 – 2019 · approx.

Web Developer

PTREE

• JavaScript, AngularJS, Firebase, Google APIs; approval-workflow and HR apps.

Oct 2015 – Dec 2016

Implementation & Integration Consultant (automotive software)

All Software – IT Group

• Remote installs, SQL Server configuration, IIS servers, client support and training.