Fraud Dedection Data Warehouse and information system

Description: Client provides financial infrastructure to over 1000 Credit Union branches in Canada and was looking to enhance and  automate processes within its Fraud & Data Management solutions.

Goal: Implement a self-serve solution which would serve as an all-in-one real-time ATM and POS transaction, fraud and customer demographic data look-up tool for clients.  Generate the Automated Fraud Reporting (AFR) as per Interac Association requirements and the Investigative report EVSCT012 for Credit Union Central of Canada (CUCC).

Solution:  We identified three main development areas: 1) GUI, 2) Interface to the Bank host, 3) Data storage.  GUI was constructed using standard .NET components hosted using IIS with high emphasis on security.  Its web environment allows users access to data through the standard web browser without the need to install additional, local applications.  Interface to the host was constructed using the ISO8583 protocol with flexibility and intent to re-use the construct for future developments requiring communication with the banking environment.  The interface runs as a service on a Windows Server and utilizes multiple communication channels to securely and reliably process over 500 financial transactions per second.  Data storage was designed with multiple summary tables and indexes in order to direct queries to specifically optimized data sets rather than main transaction tables, resulting in lower server load and higher response times.