FinTrack - Node.js, Express, PostgreSQL

Year

2026

Tech & Technique

Node.js, Express, PostgreSQL, React

Description

Built FinTrack, a comprehensive personal finance tracking application designed to help users monitor budgets, track multi-currency transactions, and receive AI-powered financial insights.

Key Features:

Core Finance Management - Track income and expenses with date, category, description, and currency
Multi-Currency Support - Manage 10 different currencies with live exchange rate conversion
Budget Monitoring & Alerts - Set category budgets with real-time tracking, UI warnings, and email alerts
AI-Powered Intelligence - Conversational financial advisor powered by Groq (Llama-3) and auto-categorisation for transactions
Dashboard & Visualisation - Summaries of total income/expenses, monthly trends via Recharts, and budget progress bars
Receipt Management - Upload and attach receipt images to transactions
Authentication & Security - Stateless JWT authentication with secure cookies and Google OAuth integration

Technical Highlights:

Node.js backend with Express and raw SQL execution (pg module) for advanced query optimisation
Interactive and responsive frontend dashboard built with modern React features
Migration-first schema management to ensure predictable database evolution
Server-side cross-currency budget aggregation using cached exchange rates
Asynchronous email notifications (SendGrid) and deduplication for budget alerts
Robust AI integration with graceful degradation handling and fallback strategies

My Role

Full-Stack Developer

Database Modeling: Designed a raw SQL-based PostgreSQL schema with explicit migrations and constraints
Backend Architecture: Built robust Node API with comprehensive controllers, middleware, and services
Financial Logic: Implemented complex server-side cross-currency budget calculations using advanced SQL features
AI & Integration: Integrated Groq LLM for a smart financial advisor and auto-categorisation tool
Authentication: Setup Google OAuth and stateless JWT security
Frontend: Designed visually appealing real-time dashboards with Recharts