Jonathan Xu

ERPNext / Frappe lead. Backend, integrations, BI. Five-person team.

• Lead engineer for the ERPNext platform processing $356M trailing-12-month revenue, 186k+ B2B/DTC orders, and 1,100+ wholesale accounts across 12+ sales channels (Shopify, Amazon, Target Plus, EDI to Walmart / GameStop / Dollar General / Kroger, and others).
• Scaled platform throughput from 131k orders / $134M (2023) to 190k orders / $294M (2025): 119% revenue growth on the same Frappe/ERPNext stack with no engineering headcount increase.
• Selected to lead the multi-year Standard Costing rollout after prior attempts stalled. The work consolidates costing across 7 facilities on 3 continents and pulls in manufacturing, warehousing, finance, and accounting. I own the monthly architecture review, the internal engineering newsletter, and the operations demos for warehouse + logistics simplification.
• Designed and shipped the Cleo EDI bridge as the primary retail-partner channel, ingesting POs from 6 partners (Walmart, GameStop, Dollar General, Fred Meyer, Kroger, Pure Hockey). Killed the per-transaction SPS Commerce model that was eating margin on Walmart volume: mid-six-figure annual savings.
• Built Target Plus direct API integration end-to-end (items, orders, fulfillment, reporting); drove 30-day certification to 60/60 passing scenarios.
• Drove company-side recovery of an 8-month Amazon SP-API degradation, leading migration to Amazon's Solution Provider Portal and unblocking ~$500k/month in stalled marketplace throughput.
• Owned production reliability: chunked unbounded IN-clause queries to eliminate 25-minute worker timeouts on the SKU sales-register report against a 6 TB MariaDB; resolved a 50-deadlock-in-2-weeks gap-lock cycle (peak 15/day) with retry-on-rebuild plus removal of 6 redundant mid-hook commits; authored root-cause analysis on tabSeries lock contention (32.6% of lock time across 860k UPDATEs) with a sharding proposal projecting 80–90% lock-wait reduction.
• Designed the automated ERP Health Check: Lambda + EventBridge + Amazon Bedrock (Claude Sonnet 4.6) pipeline parallelizing 6 data collectors into narrative production analysis. Runs daily/weekly at ~$4.40/mo, ~90s runtime, 70+ unit tests.
• Drove infrastructure & security posture in partnership with Caylent: production VPC migration toward PCI-DSS 4.0 / SOC 2 (dual-AZ, ALB + WAF, SSM-only bastion), Terraform for all production security-group changes, Azure Entra ID SAML SSO rollout, and a role-gated SQL surface (BI Query Desk) replacing per-analyst tooling.
• On the Azure side: Microsoft Graph automation for Teams notifications and M365 access provisioning, plus Azure DevOps Pipelines for the non-AWS deploy paths.