Custom Management – Maintenance & Improvements for Collection Payments Agency

Problem

• The client operates a multi-campaign collections platform. Over time, the custom management system needed continuous maintenance and enhancements to keep up with campaign volume and operational needs.
• Each campaign required its own ETL into SQL Server, plus reliable reconciliation and validation to prevent data drifts and reporting inconsistencies.
• Operations depended on several external integrations (dialers, payment gateways, service desk, email/SMS), which required coordinated changes and robust release practices.

Project Objectives

• Provide ongoing maintenance and iterative improvements to the custom management system without disrupting active collections campaigns.
• Ensure each campaign’s daily ETL remains consistent and validated, with clean reconciliation across sources (CSV/SFTP/APIs).
• Maintain a steady collaboration rhythm with the client while prioritizing and delivering changes via Scrum/Kanban practices.

Solution Applied

• Delivery & governance: 1 Tech Lead and 4 Senior Developers coordinating with the client, organizing backlog, grooming, and sprint planning across recurring releases.
• ETL per campaign: built/maintained campaign-specific pipelines (CSV/SFTP/API sources) loading into SQL Server, with daily runs, automated validations and reconciliation steps, and clear error handling.
• Reporting support: produced ad-hoc and scheduled views focused on recovery performance and dialer/campaign effectiveness (kept high-level by design).
• Integrations: connected with phone dialers, payment gateways, service desk, and email/SMS platforms; changes are planned and communicated to keep services available.
• Practices: tracked work in Confluence/Jira, versioned in Git/GitHub, and used TeamCity for CI; environments deployed on Docker with a Linux/Apache/PHP/MySQL stack and SQL Server for campaign data.

Technologies Applied

Tools: Atlassian Confluence · Jira · Git · GitHub · TeamCity
Stack: Linux · Apache · PHP · MySQL · SQL Server · Docker · Integrations: Phone Dialers · Payment Gateways · Service Desk Platform · Email/SMS Platforms

Results & Benefits

• The platform was kept in stable operation for all active campaigns throughout the engagement, with validated daily loads and coordinated releases across integrations.

Timeline & Team

• Ongoing maintenance with recurring iterations (onboarding → stabilization → improvements/ETL/reporting).
• Team: Tech Lead · 4 Senior Developers.

Compliance & Security

• Aligned with ISO 27001 and PCI practices at a high level (least-privilege roles, change control, encrypted transport, logging discipline), with specifics withheld for security.