Abdul Rahim Logo
Abdul Rahim

Senior Software Engineer specializing in NestJS & PostgreSQL, building secure enterprise applications.

[email protected]

Site map

HomeProjectsBlogAboutExperienceEducationContact

Legal

Privacy PolicyTerms

Connect

© Abdul Rahim. All rights reserved.

FINTECH

Enterprise Budget Management

Web-based CapEx/OpEx planning with a spreadsheet-like grid, versioned budgets, and approval workflows for finance teams.

2023
FinTech

Representative interface preview

01

The Challenge

Very large spreadsheets prone to performance and stability issues

Long budget cycles with many draft versions in circulation

No reliable version history when several editors worked in parallel

Macros that broke across Excel versions

Limited audit trail for who changed which figures

Primary Tool (Before)
Excel
Collaboration
File-based
Backend
Django
Data Store
PostgreSQL
Enterprise Budget Management - Feature 1
02

The Approach

1

Captured calculation rules and dependencies from existing workbooks

2

Prototyped a high-density grid for finance reviewers

3

Modeled approval stages to match the current sign-off chain

4

Planned migration of historical budget rows with validation checks

5

Added Excel import/export for stakeholders who still needed files

Enterprise Budget Management - Feature 2
03

The Solution

Spreadsheet-style editing with validation before submit

Version history and compare views for budget drafts

Concurrent editing with locking on contested cells

Configurable approval routes and notifications

Audit log of structural and value changes

Excel export for offline review

Technical Implementation

Vue.js for the interactive grid
Python Django with NumPy for calculation logic
PostgreSQL with JSONB for flexible budget shapes
Celery for background recalculation
Redis for hot data
WebSockets for collaboration sync
Enterprise Budget Management - Feature 3
04

Implementation

Migrated prior-year budget data with reconciliation checks

Workshops for finance staff on the new workflow

Import/export path aligned with legacy Excel templates

Audit logging for compliance reviews

Enterprise Budget Management - Feature 4
05

The Results

Hosting
Web app
Version Control
Built-in
Approvals
Configurable
Audit Trail
Full
GALLERY

Project Showcase

A visual journey through the development process

Technologies Used

Built with modern, scalable technologies

Vue.js
Python
Django
PostgreSQL
Celery
Redis
NumPy

Explore More Projects

Discover other solutions from my portfolio