Security Governance & AutomationG-01April 2024
Automated User Access Management (UAM) Review Engine
Python governance automation tool that compressed quarterly access reviews from 17 days to 13 business hours
17 Days â 13 Hrs
Review Turnaround
$400Kâ$450K est.
Exposure Identified
150+ Internal / 1,000+ Client
Reconciled Scope
PythonRBACAccess GovernanceSIEMAudit AutomationREST APIs
Problem
Quarterly User Access Management (UAM) reviews were a manual bottleneck: security analysts exported user rosters from Active Directory, LDAP, cloud consoles, and internal portals, then cross-referenced each record against HR rosters and client project manifests by hand. This consumed 17 business days per quarter and masked lag between offboarding events and actual privilege revocation.
Constraints
- Heterogeneous Identity Sources: Identity data spanned directory services, cloud IAM tables, and engagement manifests with inconsistent identifier formats.
- Audit Traceability: Every reconciliation decision needed deterministic, timestamped evidence suitable for ISO 27001 and SOC review.
- Zero-Trust Perimeter: Stale contractor and consultant privileges across 50+ environments created unmeasured compliance and operational risk.
My Contribution
I designed and implemented the Python reconciliation engine, defined privilege revocation latency as an executive governance metric, and built the automated PDF/CSV audit register generator in collaboration with security operations stakeholders.
Architecture
- Identity & Manifest Ingestion: Normalizes exports from identity providers, authorization tables, and active HR/client engagement manifests.
- Automated Role Reconciliation: Flags over-privileged accounts, inactive consultants, and mismatched group memberships deterministically.
- Revocation Latency Tracking: Measures elapsed hours between HR/engagement offboarding timestamps and identity-provider deprovisioning.
- Audit-Ready Evidence Bundles: Generates timestamped, cryptographically signed PDF and CSV audit registers.
Verification
- Reconciled 100% of active user records across 150+ internal accounts and 1,000+ client operator accounts in 50+ environments against HR offboarding manifests prior to sign-off.
- Validated generated exception lists against manual spot-check baselines across quarterly audit cycles, achieving 0 unauthorized access or privilege escalation incidents over 18 months.
Results
- Turnaround Compression: Reduced quarterly access review cycles from 17 business days to 13 business hours.
- Exposure & Latency Improvement: Identified an estimated $400Kâ$450K annual business exposure associated with delayed privilege revocation, and helped reduce revocation turnaround from days to under 2 hours through automated access governance.
Evidence
- Source Repository: uam-review-engine on GitHub
- Related Post-Mortem: The $450K Blindspot: Privilege Revocation Latency Gap
Cross-posting & syndication
Canonical URL:
https://tedcraft.dev/works/uam-access-review-engine/Syndicate or reference this case-study with canonical attribution