The challenge
Application account exports and active employee rosters contained mismatches, leave-related exceptions, and unusual non-person accounts. Manual comparisons alone risked inconsistent status definitions from month to month.
My contribution
- Matched AWARDS primary employee email against ADP work email, applying documented normalization and review rules.
- Defined repeatable statuses for active matches, inactivity beyond 15 days, approved leave, and accounts not found in ADP.
- Excluded documented nonstandard, system, and training records so staff follow-up focused on relevant cases.
- Organized a one-sheet Excel output with last login, department, job title, days inactive, and review status for monthly reporting.
Results and scope
A historical August 2026 baseline included 1,314 application records and 132 accounts more than 15 days inactive. A separate roster comparison found 97 unmatched accounts before 16 leave-related cases were recognized, leaving 81 in the unmatched follow-up group. These are a point-in-time review counts, not evidence that access was revoked or risk eliminated.
Why the method mattered
A single “not in HR” label can be misleading when an employee is on approved leave or a system record belongs to a sanctioned service function. Defining and documenting exceptions made the review more useful to its owners.
Public portfolio summary only. Identifying details, clinical content, production screenshots, and confidential employer records are excluded. All diagrams and demo visuals are illustrative.