Overview
Built a secure enterprise-grade financial management platform for a Dubai-based client, replacing a complex manual Excel workflow with a unified web and mobile solution. The platform handles multi-entity accounting, real-time asset tracking, and comprehensive financial reporting.
Problem Statement
The client managed finances for multiple business entities using spreadsheets — a process that was error-prone, not auditable, and offered no real-time visibility. Switching between companies required separate Excel files, making consolidated reporting nearly impossible.
Solution
Designed a Node.js backend with PostgreSQL, exposing a REST API consumed by both the web dashboard and a mobile app. A signature "Multiple Company Switch" feature lets authorized users toggle between distinct business entities without logging out.
AWS Infrastructure
- ▹VPC & Security Groups: Isolated sensitive financial data within a private VPC, enforcing strict access controls and compliance requirements
- ▹CloudWatch: Configured monitoring and alarms to detect transaction anomalies and track system health in real-time
- ▹RDS Backup Strategy: Automated snapshotting and cross-region replication to prevent data loss on critical financial records
Key Features
- ▹Multiple Company Switch — manage distinct entities from one session
- ▹Real-time asset tracking and balance sheets
- ▹Cash flow forecasting with historical trend analysis
- ▹Automated report generation (PDF/Excel export)
- ▹Role-based permissions with full audit logging
- ▹Mobile app for on-the-go approvals and reporting
Outcome
Eliminated manual spreadsheet dependency entirely. The finance team gained real-time visibility across all entities and reduced monthly close time significantly.