E-commerce ERP
- Built PostgreSQL audit triggers that roll every 100 audit records into a checkpoint, keeping logs small on high-volume sales and product tables.
- Built ETL workflows that pull eBay XML, clean it with JavaScript and load it into PostgreSQL, with retries and concurrency limits.
- Rewrote CTEs/JOINs and tuned indexes across 1M+ product and 200K+ sales rows: 20s → 5s (−75%). Precomputed KPI aggregates with triggers and cron jobs.