Fintech Ledger Databases Success Story

ERP & Payroll Platform

Migrating a Legacy Monolithic Desktop App to a Modern Web ERP with Mobile-Money Disbursals.

Client VisionONE Suite
Duration 7 Months
Sector Fintech Ledger Databases

The Challenge

VisionONE’s legacy Windows desktop ERP client was difficult to update, lacked real-time database syncs, and could not scale to handle dense payroll calculations for enterprise organizations. The client needed to migrate the system to a modern web stack, optimize heavy payroll run query speeds, and support automated mobile-money payouts to employees.

The Solution

Through our custom software engineering services, we successfully migrated the platform to a modern web architecture. The backend is built on ASP.NET Core (.NET 8) with a dual-ORM approach: EF Core 9 maps the domain model, and Dapper handles heavy accounting ledger queries. The frontend uses Angular 20 with NgRx state management and AG Grid Enterprise for data-dense ledger grids. We integrated the M-Pesa STK Push API to support instant mobile-money payouts, utilizing webhooks to sync transaction states.

The Process & Implementation

We offloaded heavy payroll processes and PDF payslip generation to Hangfire background jobs, keeping the web API responsive. We integrated the Microsoft Graph API to sync documents with SharePoint libraries. To secure the ERP, we implemented JWT, TOTP two-factor authentication, and ASP.NET Core Identity controls across three SQL Server databases. We wrote xUnit suites to test accounting and tax logic.

The Results Delivered

The VisionONE Web ERP launched successfully, allowing HR managers to run payroll in minutes instead of days. Ledgers sync instantly, and payments disburse autonomously to mobile devices.

Business & System Impact

  • 6x Fast Ledger Queries: Dapper SQL execution maps complex balance sheets and payroll tables under 2 seconds.
  • Automated Salary Disbursement: M-Pesa payouts disburse funds instantly with automated webhook status checks.
  • Secure Enterprise Access: TOTP 2FA and JWT tokens secure financial ledgers against unauthorized access.

Technology Integration Stack

C#.NET 8ASP.NET CoreEF Core 9DapperAngular 20NgRxAG Grid EnterpriseSQL ServerHangfireJWTTOTP 2FAM-Pesa APIMS Graph API

Partner with Our Senior Engineering Squads

Discuss your specific architecture requirements, database scaling targets, and project budgets with a chief engineer.

Talk to an Expert
Talk to an Expert