A strategic modernization initiative that converted a mission critical desktop database into a secure, scalable web platform.
Overview
We partnered with the client data team to modernize their platform and resolve data orchestration bottlenecks affecting analytics consistency and delivery speed.
Legacy workflows made it difficult to aggregate information from multiple systems in a single, trusted source.
Daily and weekly update cycles delayed reporting and reduced confidence in time-sensitive decisions.
Inconsistent checks across systems created frequent data mismatches and extra manual validation effort.
Disconnected pipelines increased maintenance effort and made scaling new use cases expensive.
Managing four separate firms across disconnected Microsoft Access databases created operational silos, limited organizational visibility, and made it difficult to manage permissions, reporting, and office operations efficiently.
Reliance on manual payment entries through third-party gateways like Repay introduced friction, constrained scalability, and made it hard to support high-volume loan settlements and scheduled payment processing.
FundingGA needed seamless integration with Payliance APIs for both ACH bank transfers and debit card authorizations, each with different settlement behaviors and response structures, requiring a unified and reliable processing layer.
The legacy environment offered mostly static, retrospective reporting, making reconciliation difficult and delaying the identification of failed or returned ACH and debit transactions.
Core business rules were embedded in an aging Access-based system, so the modernization effort had to preserve and respect established operational logic while rebuilding the platform on a modern web architecture.
Delivery strategy
We partnered with FundingGA to consolidate fragmented legacy databases, embed Payliance’s ACH and debit rails into a unified Backoffice, and stand up a cloud-native platform that operations teams can rely on every day. Our focus was a single operational view of customers, payments, and permissions so multi-location lending could scale without adding manual overhead or risk.
A modern, browser-based Backoffice that centralizes data, automates collections, and gives FundingGA real-time visibility into loan performance across all locations.
Four legacy MS Access databases unified into a single Common Database architecture.
Centralized management of office locations, employee permissions, and payment credentials.
Web-based Backoffice experience that replaces desktop-bound workflows.
UX designed around real-world agent tasks and complex financial data navigation.
Integrated ACH and debit payment rails orchestrated through Payliance APIs.
Automated ACH batch settlements and real-time debit card authorizations.
Cloud-native infrastructure on AWS for scalable, secure operations.
CI/CD pipelines that support frequent, low-risk releases to production.
Legacy databases unified into a single Common Database.
Real-time operational view across all FundingGA lending entities.
Across 3 months of consistent deployments, AptlyLabs drove the platform’s evolution with 200+ Jira-tracked enhancements, fixes, and workflow improvements, enabling the system to continuously adapt to the firm’s changing operational requirements.
Weekly from November 2025 to March 2026
Weekly from November 2025 to March 2026
Additions and deletions per week
Solution
The modernized platform utilizes a modular, high-performance tech stack designed for security and rapid scaling.
React, modern component library, and Tailwind CSS for responsive, accessible UI.
FastAPI (Python) powering high-performance APIs and clearly modeled domain logic.
Centralized Microsoft SQL Server into a unified common database, seamlessly connecting data across all four office locations.
AWS Cognito for authentication and Cloudflare CAPTCHA securing public-facing forms.
AWS ECS for services, S3 + CloudFront for delivery, and SST (CDK) for Infrastructure as Code.
Built with enterprise-grade security, scalability, and observability from day one.
Unified Operations: Single-point management for four distinct financial entities.
Automated Settlements: Eliminated manual entry through automated daily bulk payment submissions.
Real-Time Fidelity: Instant visibility into transaction statuses, replacing static reporting.
Increased Scalability: A robust cloud foundation capable of supporting additional offices and higher loan volumes.
Improved Security: Integrated OTP delivery via AWS SNS and secure credential management.
Phased and seamless
FundingGA rolled out the new platform in a controlled sequence: early adoption focused on validating payments, permissions, and reconciliation with real production traffic, then expanded usage across teams as confidence in the unified data model grew.
The move from desktop Access to a single cloud-backed system eliminated duplicate entry paths, improved traceability for ACH and debit activity, and made it practical to iterate safely with CI/CD and observable infrastructure.
A single web backoffice replaced siloed Access workflows with consistent data and permissions.
ACH and debit flows orchestrated through Payliance reduced manual gateway work and settlement risk.
AWS-hosted services and infrastructure-as-code support safer releases and scaling new entities.
Final thoughts
By partnering with Aptlylabs, Funding Georgia successfully transitioned from legacy systems like MS Access to a centralized cloud platform, powered by seamless Payliance integration. This transformation streamlined payment workflows, improved reliability, and enabled real-time visibility across entities. With a scalable, secure payment ecosystem in place, FundingGA is now positioned to grow its multi-location operations with greater efficiency and reduced risk. Aptlylabs continues to support strategic growth and operational scalability.
Client testimonial
Greg Allen
CEO & Founder
I have greatly enjoyed working with AptlyLabs. They have delivered well thought out software that has improved my business's efficiency. They have been quick to offer assistance when there is an issue. I rest easy thanks to my continued relationship with the AptlyLabs team.
