Alhnsikwe Super Parts
Solo built and shipped a production e-commerce platform for an international automotive parts brand — public store, customer accounts, USD checkout, and a full admin console.
- Architected a modular monolith: storefront, customer account, and admin as separate surfaces over one Postgres domain model, so web and a later mobile client share the same data and access rules.
- Made payment the commit point. Checkout stays provisional until Razorpay confirms capture; only then the order is written and stock moves, so a dropped payment never desyncs inventory.
- Kept the app tier stateless and pushed media to Cloudflare R2 behind a CDN, so image traffic scales apart from checkout and the app can run as more than one instance.
- Put authorization in the database with row-level policies and an admin role check, so store, admin, and any future client hit the same security boundary.
- Modeled inventory as on-hand quantity plus an append-only movement log, and streamed stock to open catalogue pages in realtime so concurrent buyers see one number.
- Designed the domain around the vehicle, not a generic cart: bike/car compatibility, brand–model finder, variants, and an ops lane for leads, custom builds, invoices, and shipping labels the client runs without a deploy.
PLM Freelancer Platform
Shipped a hiring platform for PLM consultants working on Siemens Teamcenter, PTC Windchill, Dassault ENOVIA, and SAP PLM. Clients post work, freelancers apply, admins assign and close delivery. Rebuilt the legacy PHP portal as a typed Next.js app on Postgres.
- Rebuilt the portal on Next.js (App Router), TypeScript, and Supabase (Postgres, Auth, Storage), with row-level security and role-scoped server actions for client, freelancer, and admin.
- Modeled the full engagement lifecycle: project posts with file attachments, applications, admin assignment, delivery acceptance, and a two-way revision thread. Project files are served through short-lived signed URLs so storage stays private.
- Shipped in-app and email notifications (Resend) on every status change, plus registration, password reset, and in-app password change. Locked the app down with CSP, HSTS, and frame-protection headers.
- Ran a technical SEO pass (crawl rules, XML sitemap, route-level titles and meta descriptions) and moved the primary commercial query to position 1 in Google organic results within 30 days, verified in Google Search Console.