| CPC G06Q 20/4016 (2013.01) [G06F 16/245 (2019.01); G06Q 10/06313 (2013.01); G06Q 30/0605 (2013.01)] | 10 Claims |
|
1. A computer-implemented method executed using an e-procurement server computer that is communicatively coupled to a project database, a transaction database, a plurality of buyer computers and a plurality of seller supplier computers via a network, the e-procurement server computer comprising one or more processors and one or more non-transitory computer-readable storage media storing one or more sequences of instructions organized as a risk assessment layer that is configured for evaluating during a plurality of e-procurement transactions between buyer accounts and supplier accounts in real-time, identifying and evaluating violations of project parameters, and determining a scale of violation of the project parameters or executing precautionary or remedial measures for the scale of a violation of the project parameters, the method comprising:
programmatically accessing the project database by querying using structured query language (SQL) queries, the project database having been loaded with a plurality of records, each of the records comprising a project identifier configured as a key value and specifying a plurality of project parameters associated with a particular project, the project parameters specifying use of or access to customer data or other private information, spend parameters related to authorized monetary amounts or authorized quantities of goods or services, timing requirements for delivery of goods or performance of services associated with the particular project;
obtaining, from the transaction database, transaction data for the plurality of e-procurement transactions in real time as the transaction data is entered in the transaction database during transactions between the buyer computers and the supplier computers;
identifying, from the transaction data for a particular transaction of the plurality of transactions, a particular project identifier of the particular project of the particular transaction;
querying the project database using the particular project identifier and retrieving, from a particular record among the plurality of records of the project database having a database key value matching the key value of the particular project identifier, a plurality of particular project parameters of the associated particular project;
performing by periodically executing a cron job, based on the transaction data for the particular transaction and the plurality of project parameters of the associated particular project, a risk assessment of the associated particular project of the particular transaction by updating a cumulative spend amount of the associated particular project based on a particular spend amount of the particular transaction and comparing the updated cumulative spend amount with an authorized spend amount for the associated particular project to determine whether the cumulative spend amount exceeds a threshold spend amount associated with the plurality of particular project parameters by a predetermined percentage of the authorized spend amount;
determining the scale of violation of the particular project parameters of the associated particular project when the cumulative spend amount exceeds the threshold spend amount by the predetermined percentage of the authorized spend amount, wherein an actionable flag is created for the associated particular project;
determining, from the actionable flag, a particular action corresponding to the scale of the violation;
performing, based on the scale of the violation, the particular action in response to the risk assessment, the particular action comprising entering the particular transaction in a new approval chain for individual accounts associated with the particular project to change state of the particular transaction.
|