data analytics for fraud detection 10-30-13 presentation · data analytics for fraud detection 2//...
TRANSCRIPT
![Page 1: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/1.jpg)
experience perspective //
CPAs & ADVISORS
STATE INTERNAL AUDIT ADVISORY BOARDPresented by Jeremy Clopton, CPA, CFE, ACDA
![Page 2: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/2.jpg)
experience perspective //
CPAs & ADVISORS
DATA ANALYTICS FOR FRAUD DETECTION
2 // experience perspective
![Page 3: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/3.jpg)
3 CRITICAL MESSAGES1. You should be using data analytics
2. You have the capability to perform data analytics
3. This session will help confirm points 1 & 2
3 // experience perspective
![Page 4: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/4.jpg)
…processes & activities designed to obtain & evaluate data to extract useful information and answer strategic questions...
WHAT IS DATA ANALYTICS
4 // experience perspective
![Page 5: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/5.jpg)
Where is fraud occurring in my company or organization?
TODAY’S STRATEGIC QUESTION
5 // experience perspective
![Page 6: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/6.jpg)
CONSIDER THE FOLLOWING…
6 // experience perspective
Source: Report of Investigation ‐ Office of Tax and Revenue Investigation Special Committee – District of Columbia
![Page 7: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/7.jpg)
experience perspective //
CPAs & ADVISORS
7 REASONS TO USE DATA ANALYTICS
7 // experience perspective
![Page 8: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/8.jpg)
SAMPLING IS NOT EFFECTIVE
Reason #1
8 // experience perspective
![Page 9: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/9.jpg)
You’re not likely to find the needle unless you look at the entire haystack.
KEY TAKEAWAY #1
9 // experience perspective
![Page 10: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/10.jpg)
DATA RESIDES IN MULTIPLE SYSTEMS &
MULTIPLE TABLES
Reason #2
10 // experience perspective
![Page 11: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/11.jpg)
11 // experience perspective
![Page 12: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/12.jpg)
The most powerful feature of data analytics software is the ability to compare data from multiple systems and/or sources.**
KEY TAKEAWAY #2
12 // experience perspective
**My personal opinion; not a proven fact.
![Page 13: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/13.jpg)
SHORTAGE OF THUMBTACKS & YARN
Reason #3
13 // experience perspective
![Page 14: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/14.jpg)
14 // experience perspective
Employer
UPS Store
Employee Home
![Page 15: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/15.jpg)
15 // experience perspective
![Page 16: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/16.jpg)
16 // experience perspective
![Page 17: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/17.jpg)
Analytics can help find relationships based on multiple attributes.
KEY TAKEAWAY #3
17 // experience perspective
![Page 18: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/18.jpg)
NO AUDIT PROGRAM TO IDENTIFY “KICKBACKS”
Reason #4
18 // experience perspective
![Page 19: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/19.jpg)
Relationships, patterns and trends are key areas for fraud detection. These aren’t in the APG.
KEY TAKEAWAY #4
19 // experience perspective
![Page 20: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/20.jpg)
DOUBLES AS A PREVENTATIVE MEASURE
Reason #5
20 // experience perspective
![Page 21: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/21.jpg)
Paper‐based & limited electronic testing
(Sampling)
Data Analytics(100% coverage, ad hoc
electronic testing)
Continuous Auditing(Automated analytics,
100% coverage)
Reactive ProactiveResponsiveness
21 // experience perspective
![Page 22: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/22.jpg)
Continuous auditing is data analytics at the speed of business.
KEY TAKEAWAY #5
22 // experience perspective
![Page 23: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/23.jpg)
INVESTIGATORS USE DATA ANALYTICS
Reason #6
23 // experience perspective
![Page 24: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/24.jpg)
Investigators have developed analytics for years. With development comes resources and a shorter learning curve for you.
KEY TAKEAWAY #6
24 // experience perspective
![Page 25: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/25.jpg)
7% OF FRAUD FOUND BY ACCIDENT
Reason #7
25 // experience perspective
![Page 26: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/26.jpg)
26 // experience perspective
![Page 27: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/27.jpg)
Fraudsters are intentional about fraud; we need to be intentional about finding and preventing it.
KEY TAKEAWAY #7
27 // experience perspective
![Page 28: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/28.jpg)
experience perspective //
CPAs & ADVISORS
DATA ANALYTICS & YOUR COMPANY
28 // experience perspective
![Page 29: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/29.jpg)
A GAME PLAN
29 // experience perspective
![Page 30: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/30.jpg)
experience perspective //
CPAs & ADVISORS
6 STEP PROCESS TO ANALYTICS
30 // experience perspective
![Page 31: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/31.jpg)
Assess Risk
Define Objectives
Obtain Data
Develop & Apply Procedures
Analyze Results
Manage Results
31 // experience perspective
![Page 32: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/32.jpg)
CHALLENGE TO CONSIDER – DATA QUALITY
417-865-8701, (417)865-8701, 8658701, 417-8658701
Missoura, MO, Mis, Miss, MZ, MS, Miz, Mizz
PO Box 34, P.O. Box 34, Box 34, Bx 34, P.O Box 34
Clopton, Clapton, Clompton, Clampton, Cloptin
12345, 12345a, 12345-1, 012345
32 // experience perspective
![Page 33: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/33.jpg)
PROCEDURE DEVELOPMENT
Single‐Purpose (Individual) Tests
Groups of Similar Tests
Repetitive Individual Tests
Automation of Groups of Tests
Groups of Repetitive Similar
Tests
33 // experience perspective
![Page 34: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/34.jpg)
experience perspective //
CPAs & ADVISORS
CLOSING THOUGHTS
34 // experience perspective
![Page 35: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/35.jpg)
3 CRITICAL MESSAGES1. You should be using data analytics
2. You have the capability to perform data analytics
3. You now believe points 1 & 2
35 // experience perspective
![Page 36: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/36.jpg)
RESOURCES• IIA Global Technology Audit Guides Continuous Auditing Fraud Prevention and Detection in an Automated World Data Analysis
• ISACA White PaperData Analytics – A Practical Approach
• http://www.acl.com• http://www.audimation.com
36 // experience perspective
![Page 37: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/37.jpg)
Jeremy Clopton, CPA, CFE, ACDASenior Managing ConsultantBKD, LLP Phone: 417.865.8701Email: [email protected]
Social MediaBlog: bkdforensics.comTwitter: @j313LinkedIn: http://www.linkedin.com/in/jeremyclopton/
37 // experience perspective
![Page 38: Data Analytics for Fraud Detection 10-30-13 presentation · DATA ANALYTICS FOR FRAUD DETECTION 2// experience perspective. 3 CRITICAL MESSAGES 1. You should be using data analytics](https://reader030.vdocuments.us/reader030/viewer/2022040610/5ed38a55df3d633a9b1bf663/html5/thumbnails/38.jpg)
THANK YOU
FOR MORE INFORMATION // For a complete list of our offices and subsidiaries, visit bkd.com or contact:
Jeremy Clopton, CPA, CFE, ACDA// Senior Managing [email protected] // 417.865.8701