Client Challenge
The client struggled with manual User Access Reviews that required hours sometimes days of work in spreadsheets. This repetitive process was inefficient, error-prone, and drained valuable time that could have been spent on strategic tasks.

Solution Overview
I developed an automated User Access Review workflow using n8n. The system consolidates data from HR, application accounts, and system logins, then applies custom logic to flag risks and produce audit-ready reports in minutes.

Detailed Steps

• Data Consolidation: The workflow merges employee data from HR systems with application and system login records.
• Risk Detection:
  • Flags orphaned accounts (e.g., terminated employees with active access).
  • Detects dormant accounts with 90+ days of inactivity.
  • Identifies excessive privileges that violate Segregation of Duties (SoD) rules.
• Custom Logic: A JavaScript component handles all analytical checks to ensure accurate detection.
• Audit-Ready Reports: The system generates clean CSV outputs for each finding, ready for compliance reviews.

Result
The client now completes User Access Reviews in minutes instead of days. The automation reduces compliance risk, eliminates manual spreadsheet errors, and frees up significant time for more valuable, strategic security initiatives.