Hisaab

Hisaab is a full-stack personal finance application designed for performance, scalability, and security. The platform enables users to track income, expenses, and financial trends with real-time analytics and high-speed dashboard rendering even with large datasets.

Key Technical Achievements:

Performance Optimization

• Identified and resolved a 5-minute dashboard latency issue caused by sequential database queries.

• Designed and implemented an asynchronous RPC-based data layer to execute multiple database calls concurrently.

• Reduced dashboard load time from ~5 minutes to under 2 seconds.

Advanced Caching Architecture

• Integrated Redis (Upstash) caching for heavy RPC operations.

• Designed an intelligent auto-invalidation strategy to ensure data consistency.

• Achieved sub-10ms cache response times for frequently accessed analytics data.

• Supported seamless server-side filtering across datasets exceeding 100,000+ records.

Security Hardening

• Implemented IP-based rate limiting using Upstash Redis.

• Added CSRF validation for state-changing operations.

• Enforced strict input sanitization and validation across API routes.

• Structured Row-Level Security (RLS) policies in Supabase to prevent unauthorized data access.

Insights & Analytics Engine

• Built a financial insights engine using advanced SQL aggregations.

• Implemented calculations for:

  • Saving rates

  • Recurring transaction detection

  • Category-based spending trends

  • Monthly and weekly financial summaries

Architecture Highlights

• Server-side rendering with Next.js App Router

• Optimized database schema with indexed queries

• Concurrency-focused backend design

• Clean separation of service layer and API layer

• Scalable caching strategy for future growth