Wendor Innovations Pvt. Ltd.

Vending-machine inventory and stock-management SaaS: React/Next.js dashboard, NestJS backend, PostgreSQL on AWS RDS. Focus was API performance, dashboard performance, read-replica routing, and inventory modules.

What I did

  • Optimized machine-status and order APIs (getAllMachineStatusV4, getAllOrdersServiceV2) by restructuring SQL — window functions, parameterized filters, and parallelized lookups — reducing response time from about 15 seconds to about 3 seconds on large datasets.
  • Improved dashboard load time by 40–60% by rewriting analytical SQL queries, migrating the frontend data layer to React Query, removing unused queries, and separating operational vs analytical data onto dedicated pages.
  • Routed client-facing read APIs to PostgreSQL read replicas on AWS RDS, including a separate critical-read tier for high-priority endpoints. Base replica configuration existed; rollout and the critical tier were my work.
  • Built purchase-order receiving (PO-v2/GRN), warehouse product-ledger tracking, and snapshot-inventory workflows with PostgreSQL indexing.
  • Led React Query adoption in the dashboard frontend and wrote team engineering guidelines for data-fetching patterns.

Notes

  • Cloudflare was not used at Wendor.
  • Materialized-view work on weekly_machine_stat was team work from before my tenure — not mine.
  • Mobile app authorship on stock-app-production is not evidenced.