Financial Analytics Platform 💹

A High-Performance Full-Stack Ecosystem for Financial Data Management and Real-Time Insights.

---

🚀 Overview

This platform functions as a robust financial engine, orchestrating complex data flows between a React-driven interface and a high-concurrency Node.js backend. By structuring a relational database with strategic indexing, the system ensures sub-second query execution for massive datasets involving multi-category expenses and monthly financial summaries.

🛠 Technical Core

1. High-Performance API Layer

• Orchestrated a RESTful API ecosystem using Express.js to facilitate high-frequency CRUD operations for complex budget management.
• Unified frontend-backend communication through asynchronous logic, ensuring a non-blocking user experience during heavy data fetching.

2. Database Schema & Query Performance

• Structured a PostgreSQL relational model utilizing strategic indexing on category and date fields to streamline reporting throughput.
• Formulated complex SQL queries to aggregate financial data, providing instantaneous monthly and category-wise spending analysis.

3. Security & Access Control

• Hardened the application perimeter by executing a JWT-based authentication layer with Bcrypt password hashing.
• Enforced strict role-based access controls (RBAC) to protect sensitive user financial records and prevent unauthorized API access.

4. Data Visualization & UI

• Visualized multi-dimensional spending trends using Chart.js, translating raw financial records into actionable real-time insights.
• Crafted a responsive React interface that maintains 100% data consistency across diverse financial modules.

5. Infrastructure & Containerization

• Containerized the entire full-stack application layer using individual Dockerfiles for complete service isolation.
• Networked the microservices via Docker Compose, placing the PostgreSQL data layer inside a private, secure bridge network completely inaccessible from the public internet.

---

📊 Performance Benchmarks

• Query Latency: Reduced data retrieval times for complex reports through B-Tree indexing on primary PostgreSQL entities.
• Security Standards: Applied industry-standard salt rounds for Bcrypt hashing to ensure high resistance against brute-force attacks.

⚙️ Deployment & Setup Guide

Prerequisites

Ensure you have Docker Desktop installed and running on your system. You do not need Node.js or PostgreSQL installed locally on your host machine.

1. Clone the repository

git clone https://github.com/pavni006/Financial-Analytics-Platform.git
cd Financial-Analytics-Platform

2. Configuration

Create a .env file inside the root /backend directory to configure your token secrets:

JWT_SECRET=your_super_secure_jwt_secret_key

3. Execution via Docker

Ensure Docker Desktop is running, then execute the single orchestration command from the root project folder:

docker compose up --build

Backend runs on http://localhost:5000

Frontend runs on http://localhost:5173

Isolated Database Engine: running internally on port 5432

---

📌 API Overview

• POST /users/signup – Register user
• POST /users/login – Login user
• POST /expenses – Add expense
• GET /expenses – List expenses
• POST /budgets – Set monthly budget