Institutional AI Financial Architecture

FinWise — Mutual Fund AI & Spending Intelligence

Democratizing institutional-grade financial diagnostics, portfolio auditing, and SEBI regulatory intelligence with zero cloud subscription fees. Built on a deterministic quant engine, serverless vector search, and Google Gemini.

Under The Hood

Core Technology Architecture

💳
Financial Spending Analyzer & Cash Flow Engine
Core Architecture & Foundation • Engineered by Sakshi Singh Tanwar
Spending Subsystem
Data Ingestion
CSV Normalization & Cleaning

Automated multi-bank CSV statement preprocessing pipeline. Cleans debit/credit columns, standardizes date formats, eliminates corrupted rows, and handles varying bank export schemas.

Pandas io.StringIO Data Cleansing
NLP & Classification
Heuristic Category Classifier

Rule-based taxonomy mapping ambiguous bank narrations into 7 distinct financial buckets (Housing & Utilities, Groceries, Shopping, Travel, Entertainment, Healthcare, Investments).

Regex Taxonomy Rule Engine 7-Category Clustering
Statistical Analytics
Gaussian Outlier Engine (Z > 2.0)

Two-tailed Gaussian distribution model ($Z = \frac{x - \mu}{\sigma}$) isolating abnormal transaction spikes from baseline category averages to flag one-off spending shocks.

Z-Score Outliers NumPy Math Gaussian Filter
Frontend Analytics
Spending Visuals & Savings Rate

Interactive visual dashboards delivering monthly income vs outflow comparisons, category expense doughnuts, net savings accumulation, and personal savings rate percentages.

Chart.js D3.js Heatmaps Savings Rate Metric
📈
Mutual Fund Intelligence & Tri-Hybrid RAG Platform
AI Layer, Quant Engine & RAG Architecture • Engineered by Sezar (Jyotishman)
Quant & AI Subsystem
AI Orchestration
Google Gemini 3.7

Structured tool-calling pipeline with a 1M+ token context window. Employs zero-hallucination guardrails, fast-fail 429 quota handling, and SEBI disclaimers modeled after Groww G.1.

Structured Output Pydantic Schemas Zero-Latency Fallback
Tier 1 • Rule Engine
Supabase Postgres

Deterministic SQL rule engine with Row-Level Security (RLS). Houses official exit load schedules, statutory asset allocation mandates, and user audit session persistence.

PostgreSQL RLS Security SID Mandates
Tier 2 • Vector RAG
LanceDB & Cloudflare R2

Serverless embedded vector store reading Parquet indices over Cloudflare R2 with $0 egress fees. Fast approximate nearest neighbors (ANN) across 500+ mutual fund factsheets.

LanceDB Cloudflare R2 $0 Egress Storage
Tier 3 • JIT Parsing
PyMuPDF4LLM Streaming

Zero-disk in-memory PDF parsing via Python io.BytesIO streams. Instantly digests password-protected CAMS/KFintech CAS statements and multi-format bank PDFs.

PyMuPDF4LLM Zero-Disk Storage CAS Parser
Institutional Math
Quant Performance Engine

Newton-Raphson multi-cashflow XIRR solver with SEBI <180d short-vintage guards, pairwise stock overlap Venn matrices, rolling 1Y/3Y alpha, and Section 112A/50AA tax math.

pyxirr quantstats 4-Tier Form
Cloud Architecture
Serverless Vercel & CI/CD

Stateless Python WSGI serverless deployment on Vercel with automated GitHub Actions offline batch indexing pipelines and continuous pytest suites.

Vercel Serverless GitHub Actions 100% CI Testing
Authors & Contributors

Project Leadership & Engineering

ST

Sakshi Singh Tanwar

Original Creator & Core Foundation

Designed and engineered the core Financial Spending Analyzer framework. Built the end-to-end bank statement parsing pipelines, category classification engine, expense trend heuristics, and statistical spending anomaly detection algorithms.

Core Technology Stack:
Python & Flask Pandas & NumPy Gaussian Z-Score Outlier Engine Regex Categorization Taxonomy Chart.js Visualizations D3.js Heatmaps CSV Stream Sanitization
STG

Sezar (Jyotishman)

Mutual Fund AI & Tri-Hybrid RAG Contributor

Architected and implemented the Mutual Fund Intelligence Layer, Tri-Hybrid RAG routing pipeline, Newton-Raphson XIRR quant engine, SEBI short-vintage compounding baseline, Budget 2024 taxation engine, and the interactive Claude/Groww G.1 visual Chatbot advisor.

Core Technology Stack:
Google Gemini 3.7 (Structured Tools) Supabase Postgres & RLS LanceDB & Cloudflare R2 PyMuPDF4LLM In-Memory Parser pyxirr & quantstats Engine KaTeX LaTeX Renderer Vercel Serverless & GitHub Actions
⚠️

Educational & Portfolio Demonstration Disclaimer

FinWise is strictly a software engineering portfolio, educational demonstration, and open-source quantitative research project. None of the features, diagnostic outputs, AI conversational responses, financial health scores, or automated budget categorizations constitute financial, investment, legal, or tax advice.

Mandatory Regulatory Advisory: FinWise and its contributors are not SEBI-registered Investment Advisers (RIA), SEBI-registered Research Analysts (RA), or RBI-regulated financial intermediaries. Mutual fund investments and capital markets are subject to market risks. Past performance and quantitative backtesting simulations do not guarantee future returns. Users must consult certified SEBI-registered Investment Advisers and RBI-regulated financial institutions before executing any real-world investments or financial plans.