Custom AMS (OOHNA)

FinTech & SDLC Modernization

Led the full SDLC, payment modernization, and regulatory compliance delivery for a custom web-based association management system handling sensitive financial workflows.

Challenge

A professional association relied on manual, paper-heavy processes that delayed cash flow and created data silos. They required a secure, custom-built platform to manage member data, automate renewals, and process payments while meeting rigorous financial security standards.

Technical Highlights

Full-Cycle SDLC Management: Directed the end-to-end development of a custom Association Management System (AMS), bridging the gap between member needs and technical execution.
PCI Compliance & Security: Navigated the complex PCI-DSS certification process, implementing mandatory security controls and networking protocols to ensure safe handling of credit card data.
FinTech Integration: Orchestrated the transition from manual batching to a real-time payment gateway integration with Moneris, enabling instantaneous transaction processing.
Data Integrity & Automation: Replaced legacy manual entry with an Oracle-backed relational architecture, ensuring a "single source of truth" for all provincial member records.

Result

Delivered a secure, compliant ecosystem that reduced manual data entry by 50%, lowered labor costs by 25%, and significantly improved cash flow through real-time payment processing.

Project Technology Stack

Platform & Database: Oracle APEX (Application Express), Oracle Database.
Payment Integration: Moneris Gateway API, Real-time Payment Processing.
Compliance: PCI-DSS (Payment Card Industry Data Security Standard).
Development: SQL, PL/SQL, Java-based web components.
Networking: Secure VPNs, Firewall Hardening for Financial Transactions.