JUAN IDROVO

Markatzy, Trademark Protection Platform (markatzy.com)

• Designed, built and launched independently a trademark protection platform for the Ecuadorian intellectual property market, in production with a free tier. For a firm with 100 brands, it replaces more than 170,000 manual comparisons per month and narrows results to the conflicts that warrant attorney review.
• Architected the full stack: Next.js, tRPC, Prisma and PostgreSQL with pgvector; two-tier search (Double Metaphone and trigram prefilter, then phonetic, typographic, semantic and visual scoring); pg-boss background workers; an OCR pipeline converting scanned gazette pages into registry records; Claude and Cohere embeddings on AWS Bedrock; Paddle and PayPhone payments. 3,000+ commits and 800+ automated tests in twelve months; SonarQube in CI.

Grace Nelson Attorneys at Law, Cuenca, Ecuador (Remote)

• Designed, built and operate an AI paralegal for the firm's shared mailbox: each client email triggers a sandboxed Claude agent that updates the client file, files attachments, consults a cited knowledge base and drafts an unsigned reply in Outlook for attorney approval. Median 2.2 minutes from email to draft (November 2026); 2.8% failure rate across 1,379 runs.
• Developed the pipeline specification-first in Python (~38,000 lines, 2,869 automated tests): Microsoft Graph polling, a SQLite event queue, sandboxed systemd services and timers, retries, usage limits and health alerting; every deployment gated by the full test suite.
• Built the firm's immigration site, myecuadorvisa.com, from scratch in February 2026: from about 200 Google search impressions a month to 847,000 impressions and 9,270 clicks by November 2026. Also rebuilt the firm's main website in one day, with redirects for every legacy URL.

Kriptos Inc., Miami, FL, USA (Remote)

• Developed the frontend of the Update Manager platform, used by enterprise clients including Latin American banks to deploy and monitor Windows security agents across thousands of endpoints: 37,000+ lines of production TypeScript and React as the main contributor to the core repository, including real-time agent status, automated deployment workflows and role-based access control (RBAC).
• Supported SOC 2 Type II certification by triaging findings from SonarCloud, Amazon Inspector and Hexstrike across 220+ repositories and coordinating remediation with development teams; implemented security fixes in the main frontend (authentication flows, dependency updates, input validation) without delaying feature delivery.
• Reduced pre-commit hook runtime by 50% by testing only changed files (full suite on merge), and restructured the Mock Service Worker (MSW) setup into a schema-defined mock backend, allowing frontend development to proceed ahead of the APIs.

Grace Nelson Attorneys at Law, Cuenca, Ecuador

• Led the firm's digital transformation: first CRM, automated workflows, and a bilingual website with online payments and appointment booking.

IMBAIP Cia. Ltda., Quito, Ecuador

• Developed scripts comparing the ~1,700 publications in each monthly gazette against client portfolios to compensate for the firm's tooling; this work became Markatzy.

Tilburg University, Netherlands

Privacy and data protection law, cybersecurity law and the regulation of AI.

University of Texas at Austin, McCombs School of Business, USA

Executive education, certificate of completion; GPA 4.13/4.33. Network security, modern cyber attacks, security controls, governance, risk and compliance (GRC).

BrainStation (Konrad Group), London, United Kingdom

Winner of the Lloyds Banking Group partnership hackathon (fraud detection prototype) and of a scholarship for cybersecurity training.

Universidad San Francisco de Quito, Ecuador

Thesis on central bank digital currencies in dollarized economies. Coursework in intellectual property, technology law and international commercial law.

Python data pipeline with 20 collectors (SEC filings, memory prices, Taiwanese and Korean trade data, grid interconnection queues, earnings-call keywords) loading SQLite; weekly scoring of a written investment thesis, reviewed by a sandboxed Claude agent and delivered as an email report; backtest of trading rules against SMH and a fixed control portfolio; Datasette site on a private network; nightly backups to Amazon S3.

Next.js storefront and Medusa.js v2 headless commerce backend for an Ecuadorian food producer: catalog, cart, checkout with card and mobile payments, S3 storage and administration dashboard; deployed on Railway with PostgreSQL and Redis.