CPC G06Q 30/0215 (2013.01) [G06F 9/5038 (2013.01); G06F 16/24553 (2019.01); G06F 16/254 (2019.01); G06Q 20/02 (2013.01); G06Q 20/405 (2013.01); G06Q 30/0235 (2013.01); G06Q 40/02 (2013.01); G06Q 30/0226 (2013.01)] | 5 Claims |
1. A rewards method, comprising
providing a server-side server, the server-side server comprising an extract-transform-load module;
creating, at the server-side server, a campaign and defining rules for the campaign to form a campaign details table;
retrieving, using the extract-transform-load module, accounts and transaction data of a customer from a bank core; and
converting, using the server-side server, the accounts and transaction data into a format that can be analyzed;
inserting, using the server-side server, the accounts and transaction data into a base table comprising a transaction table, an account details table, and a customer details table;
retrieving, using the server-side server, the rules from the campaign details table and the base table and mapping transaction data to form a mapping table;
retrieving, using the server-side server, the rules from the campaign details table and the mapping table to determine rewards of the accounts of the customer and storing the rewards to a rewards table;
retrieving, using the server-side server, the rewards from the rewards table and posting the rewards to the bank core;
posting, using the server-side server, a rewards amount to the account of the customer; and
wherein the campaign details table comprises customer profile information and customer segmentation.
|