Audit Analytics

This repository contains projects related to risk management:

• IT Audit Scripts
• Continuous Audit / Continuous Monitoring (IT, Operational, and Financial Audits)
• Risk Analytics & Metrics

IT Audit Scripts - Data Gathering

Technologies:

Databases

• DB2
• Oracle
• SQL Server

Servers

• Unix / Linux (AIX, Solaris, RHEL)
• Windows

Enterprise Resource Planning (ERP) Systems

• Microsoft Dynamics Great Plans
• Microsoft Dynamics Navision
• PeopleSoft Financials (NOT STARTED)

Continuous Audit / Continuous Monitoring

IT Audit: Incident Management

Purpose:

IT Audit: Change Management

Purpose:

Attributes A - Change Ticket Submitted B - Change Testing C - Change Approval D - SOD: Developer vs. Migrator

Financial Audit: Unusual Journal Entries

Purpose:

• Data Storage: S3
• Glue
• Spectrum
• CloudFormation Template

Risk Analytics & Metrics

Benford's Law / Law of Anomalous Numbers / First-Digit Law

• Numeral 1 will be the leading digit in a genuine data set of numbers 30.1% of the time.
• Numeral 2 will be the leading digit 17.6% of the time.
• Each subsequent numeral, 3 through 9, will be the leading digit with decreasing frequency.

Issues

• Trends in Issue Identification
• Trends in Issue Closure by Severity
• Trends in Management Self-Identified Issues
• Repeat Issues

Operational Risk Events

• Timeliness of Recording Operational Risk Events
• Timeliness of Verifying Operational Risk Events
• Trends in Operational Risk Events
• Trends in Impact of Operational Risk Events