Sagar Panwar

1. Insurance website development/maintenance

Worked on the internal Merchants Insurance Group website to manage their new quote creation website flow. I implemented form validation and state management based on various business logic like claim amount based on locations and pincode. Rendered new UI element based on the pre-defined business logic.

Languages used: JavaScript, HTML/CSS, TypeScript, SQL

Tech stack: React, Tailwind CSS, Tanstack Query, Vite, React Hook Forms, Zod (form validation), Redux

Key solutions applied:

• Frontend- The frontend part is minimal - a clean chat interface along with Pdf viewing panel. It complies with all the accessibility guidelines. Tailwind CSS handles the clean Ui. React Pdf, renders the Pdf viewing part.
• State management - Context API, provides a minimal state management for this SPA.
• Backend and Storage - The backend is powered by a Vector database(pg vector extension) on Superbness. Storage is handled by Supabase storage.
• Ai- The Pdf parsing is powered by Llama Parse. Embedding and vectorization is powered by Jina Ai. Retrieval through RAG and chat Responses are powered by Google gemini.
• Hosting- Netlify.

Key solutions applied:

• Approach: React + TypeScript with Shadcn/ui for consistent UI patterns, Tailwind for styling speed, and Vite for fast builds. Forms follow a typed, validation-first pattern using React Hook Form and Zod to prevent bad data at the edge.
• Database & Auth: Supabase (PostgreSQL) handles authentication and persistence. The app uses the Supabase client to: Create, read, update, and delete user-scoped expense records after login; Store category assignments alongside transactions to support analytics; Keep network logic simple while relying on Postgres reliability.
• Data Handling: React Query manages fetching/caching and error states so the UI stays responsive even on slow networks. Validation happens before any write to the database, preventing inconsistent records.
• Analytics: Visual reports summarize spending by category and timeframe to surface patterns and help decision-making without overwhelming the user, based on the Recharts chart library.
• A pragmatic, type-safe frontend + hosted Postgres stack that prioritizes clarity over complexity—clean UI primitives, strict typing, and validation-first forms make it easy to maintain and extend without vendor lock-in or heavy backend code.

Key solutions applied:

• Data and database: persists boards, lists, tasks, and chat in a relational backend; subscribes to realtime change streams so UI updates instantly when any user edits; writes occur on drag, reorder, status change, and messaging.
• Collaboration: multi‑cursor presence shows who’s active and where; in‑app chat includes connection status and auto‑reconnect for reliability.
• Routing: file‑based routing organizes board views and task details for clear navigation and deep links.
• Authentication and access: supports user identity for presence, chat attribution, and per‑user task colors; access control can be enforced via database policies to scope data to owners/teams.
• UX: mobile‑friendly drag‑and‑drop with touch optimizations; polished dark/light themes for readability.
• State and performance: client state is kept snappy with lightweight local state and server state caching; real-time subscriptions minimize network round‑trips.
• Live multi‑cursor overlays, instant cross‑client DnD, and per‑user color coding create a collaborative ‘see it as it happens’ experience that feels like a shared canvas rather than a traditional Kanban.