Wendor Innovations Pvt. Ltd.

Software Engineer · Full-time · June 2025 – April 2026

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.

Work

  • 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.

Stack

React, Next.js 13, TypeScript, TanStack React Query, NestJS 8, PostgreSQL, TypeORM, AWS RDS, EKS, ECR, S3, Docker

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.

Product story: Wendor