ISSS608 2017-18 T3 Assign Aakanksha Kumari Q4

Unraveling the Secrets of Kasios : VAST Mini Challenge 3

Overview

Data Preparation

Question 1

Question 2

Question 3

Question 4

Dropbox

The insider has provided a list of purchases that might indicate illicit activity elsewhere in the company. Using the structure of the first group noted by the insider as a model can you find any other instances of suspicious activities in the company? Are there other groups that have structure and activity similar to this one? Who are they? Each of the suspicious purchases could be a starting point for your search. Provide examples of up to two other groups you find that appear suspicious and compare their structure with the structure of the first group.

Structure of Previous Transactions

To understand the structure of newly provided list, we must decode complete structure of early transaction.

Rosalia Larroque --> meeting --> Meryl Pastuch (2017-09-03 03:18:53) Rosalia Larroque --> email--> Kerstin Belveal (2017-09-18 04:33:43) Rosalia Larroque --> call --> Jenice Savaria, 2017-09-19 22:05:33 Rosalia Larroque --> purchase --> Jenice Savaria, 2017-09-20 14:45:33 Interesting thing to note is suspicious transaction start with meeting with Meryl Pastuch, followed by series of email and call communication between Rosalia and Kerstin. At end Rosalia Larroque purchases.

List of Other Suspicious Transactions

Other Similar Transactions

Case of Trevor Webb call, 2016-11-09 20:01:28, Trevor Webb, Hallie Purchase email, 2016-12-22 01:23:27, Trevor Webb, Lilia Machowski purchase, 2017-01-16 09:35:09, Trevor Webb, Tyree Barreneche email, 2017-07-16 16:00:35 2017, Trevor Webb, Jason Bailey purchase, 2017-07-24 19:49:03, Trevor Webb, Tyree Barreneche email, 2017-07-26 04:57:33, Trevor Webb, Bill Reynolds

Case of Beth Wilensky call,2017-11-15 23:05:20,Beth Wilensky,Ollie Norton email,2017-11-23 02:53:33,Beth Wilensky,Kalyn Bloczynski purchase,2017-12-12 02:26:32,Beth Wilensky,Gregory Russell call,2017-12-12 02:26:32,Beth Wilensky,Stanley Ryan call,2017-05-14 03:51:02,Beth Wilensky,Angelic Graetz purchase,2017-06-03 03:51:02,Beth Wilensky,Gregory Russell enail,2017-06-03 03:51:02,Beth Wilensky,Angelic Graetz