Audit Analytics
Risk-focused analytics and applications designed to improve audit coverage, identify anomalies, and support data-driven audit decisions.
Power BI Dashboards
Vendor Payments Monitoring
Problem
High-volume vendor payments make it difficult to identify duplicate, split, or unusual transactions.
Approach
Built a risk-focused dashboard highlighting payment patterns, vendor behavior, and anomalies for targeted testing.
Audit value
Enables focused audit testing and continuous monitoring of high-risk transactions.
Internal Audit Issue Tracker
Problem
Tracking open issues and management action plans across audits can be fragmented and manual.
Approach
Centralized issue tracking with status, aging, and ownership views.
Audit value
Improves follow-up discipline and management reporting.
Adventure Works – Sales & Operations Dashboard
Purpose
Demonstrate end-to-end dashboard development using a multi-table operational dataset,
with a focus on metrics commonly reviewed by management and internal audit.
Approach
Modeled sales, product, and operational data into a star schema and built interactive visuals
to analyze revenue trends, product performance, and operational drivers.
Analytical value
Illustrates how transactional data can be transformed into decision-support insights and used to
identify unusual trends, margin pressure, or performance anomalies.
Property Management Dashboard
Purpose
Provide a consolidated view of property-level performance metrics commonly used by property management
and oversight teams.
Approach
Built a dashboard to filter and segment properties based on operational and financial criteria, enabling
targeted review of underperforming or higher-risk locations.
Analytical value
Supports portfolio oversight by highlighting outliers, trends, and performance variances that may warrant
further review or investigation.
Python Audit Apps (Streamlit)
Audit Sampling Tool
Problem
Manual sampling is time-consuming and difficult to reproduce consistently.
Approach
Built an interactive sampling app with filtering, random selection, and exportable results.
Audit value
Reproducible, defensible samples for audit testing.
Benford’s Law Audit Tool
Problem
Large numeric datasets make it difficult to identify potential manipulation or anomalies.
Approach
Implemented Benford’s Law analysis with visual diagnostics and anomaly flagging.
Audit value
Rapid triage of high-risk datasets for further investigation.
Fair Lending Analysis
Problem
Fair lending risk requires testing pricing and underwriting outcomes across borrower groups.
Approach
Built a simulator using synthetic data, interactive controls, and statistical analysis.
Audit value
Demonstrates potential disparate impact and supports compliance testing.
