AML Integrity Compliance & Inspection Tracker
Challenge
Compliance teams lacked a unified view of hydrotesting, cathodic protection, and coating programs; overdue inspections made audits risky.
Approach
We consolidated SAP and field logs, standardized task statuses, and automated exportable reports for audits with interactive filters.
Architecture
SAP OData → ADF pipelines → SQL Lakehouse → Power BI model with role-based access → Self-service dashboards.
Solution Flow
Illustrative only. Exact topology tailored per engagement.
KPIs
- Overdue tasks by region/asset
- Task aging buckets
- Next due date coverage
- Audit-ready export volume
Outcome
40% reduction in overdue inspection tasks and faster audit cycles with CER/PHMSA reporting.
Tech
Azure Data Factory, SQL, Power BI, Purview