CustomerClassification

Statement:

NCB (New Central Bank, Europe) having presence all across the world. They are basically into Core & Retail Banking Features. They have thousands of Customers, and most of the Customers are widely using NCB's Credit Card (Master and Visa).

On a Daily Basis Millions of Credit Card Transactions are taking place. The main intent of NCB is to identify the fraudulent Transactions and keep close eye on Suspicious Transactions on daily basis

Goal:Generate excel file having 3 sheets which contains following information

Sheet1:

Name: UnsupportedCurrency

Column: Transaction_ID,Customer_ID,Amount,Currency,Customer_LastName,Customer_FirstName

Sheet2:

Name: RiskyCustomer

Column: Transaction_ID,Customer_ID,Amount,Currency,Customer_LastName,Customer_FirstName

Sheet3:

Name: TransactionsWithBadCustomerID

Column: Transaction_ID,Customer_ID,Amount,Currency Customer_LastName,Customer_FirstName

Note: This process should be automatic and daily job needs to be executed on a given stipulated time and final copy of Excel Should be sent over a mail to given customers email id.

Transformation Logic

Usage

TO-DO

• Processed csv into db and generated output to be mailed.
• Added option to mail file.
• Add config file for input parameters such as folderpaths,db details,scheduled_time .
• Add to system scheduler for automatic execution.