Cloud & Backend2025completed

MicroBanking System

A collaborative university team project delivering an end-to-end microbanking platform — secure backend data layer plus a modern web client.

Backend (Team-SMDRS/MicroBankingSystem-Backend): financial operations centered on PostgreSQL and PLpgSQL stored procedures for accounts, transfers, and audit trails, with a Node.js/Express REST API for authentication, account management, and transaction handling under ACID constraints. Emphasis on concurrent-safe money movement, JWT auth, indexing, and compliance-oriented logging.

Frontend (Team-SMDRS/MicroBankingSystem-DB-Frontend): a React + TypeScript SPA with Tailwind, Redux state, and Axios against the REST API — dashboards, filtered transaction history, validated transfers, profile/session handling, loading/error states, and real-time balance updates. Together the stack covers the full path from database procedure to teller-style UI.

PostgreSQLPLpgSQLReactTypeScriptNode.jsREST
2017

Year

0

Features

0

Technologies

Problem
  • Guaranteeing ACID behavior under concurrent transfers
  • Securing auth consistently across API and browser client
  • Keeping banking flows intuitive while syncing rich client state
  • Optimizing SQL and procedures under realistic load
  • Aligning frontend and backend contracts across a team
Solution
  • Transaction locks, isolation levels, and indexed stored procedures
  • JWT auth with environment-based API configuration
  • Redux for centralized UI state and clear user feedback
  • Query/index tuning for hot banking paths
  • Shared REST contracts between Express services and the React SPA

Key Features

User authentication and authorization (JWT)

Account management with transaction history

ACID-compliant money transfers via stored procedures

RESTful API for all frontend–backend communication

Audit logging for compliance visibility

Responsive dashboard with account overview

Transfer UI with client-side validation

Transaction history filtering and sorting

Real-time balance updates

Secure session management and error/loading states

Technologies

PostgreSQLPLpgSQLNode.jsExpress.jsREST APIJWTReactTypeScriptTailwind CSSReduxAxiosWebSocket (live balances)

Learnings

  • Designed relational schemas and PLpgSQL procedures for financial correctness

  • Implemented concurrent-safe transfers with locks and isolation levels

  • Exposed banking operations through a JWT-secured Express REST API

  • Built a type-safe React client with Redux for complex banking UI state

  • Coordinated backend contracts and frontend UX as a multi-person team

Highlights

Full-Stack Team Build

ACID Transfers

React + Redux SPA

Next Project

NanoProcessor

14-bit custom processor in VHDL/Vivado with logical, arithmetic, shift, and rotate ops, plus LED-based FPGA debugging.