Research Article Open Access

A DATA WAREHOUSE DESIGN FOR THE DETECTION OF FRAUD IN THE SUPPLY CHAIN BY USING THE BENFORD’S LAW

Cornelia Kraus1 and Raul Valverde2
  • 1 , Germany
  • 2 Concordia University, Canada

Abstract

Large data volumes and the inability to analyse them enables fraudulent activities to go unnoticed in supply chain management processes such as procurement, warehouse management and inventory management. This fraud increases the cost of the supply chain management and a fraud detection mechanism is necessary to reduce the risk of fraud in this business area. This study was carried out in order to develop a data warehouse design that supports forensic analytics by using the Benford’s law in order to detect fraud. The approach relies on a generic and re-usable store procedure for data analytics. The data warehouse was tested with two datasets collected from an operational supply chain database from the inventory management and warranty claims processes. The results of the research showed that the supply chain data analyzed obeys to Benford’s theory and that parameterized stored procedures with Dynamic SQL provide an excellent tool to analyze data in the supply chain for possible fraud detection. The implications of the results of the study are that the Benford’s law can be used to detect fraud in the supply chain with the help of parameterized stored procedures and a data ware house, this can ease the workload of the fraud analyst in the supply chain function. Although the research only used data from the inventory management and warranty claim processes, the proposed store procedures can be extended to any process in the supply chain making the results generalizable to the supply chain management process.

American Journal of Applied Sciences
Volume 11 No. 9, 2014, 1507-1518

DOI: https://doi.org/10.3844/ajassp.2014.1507.1518

Submitted On: 20 April 2014 Published On: 7 July 2014

How to Cite: Kraus, C. & Valverde, R. (2014). A DATA WAREHOUSE DESIGN FOR THE DETECTION OF FRAUD IN THE SUPPLY CHAIN BY USING THE BENFORD’S LAW. American Journal of Applied Sciences, 11(9), 1507-1518. https://doi.org/10.3844/ajassp.2014.1507.1518

  • 2,909 Views
  • 3,388 Downloads
  • 20 Citations

Download

Keywords

  • Supply Chain Fraud
  • Supply Chain Management Systems
  • Benford’s law
  • Fraud Detection
  • Data Mining for Fraud
  • Accounting Information Systems