The Problem: In a remote startup environment (Running Health App), manual permission tracking often leads to “security debt,” where former employees or cross-departmental staff retain access they no longer need.
The Solution: Developed a dynamic Google Sheets-based Access Matrix that automates the lifecycle of a user from onboarding to permission rotation.
Key Features:
- Logical Mapping: Concatenated Dept/Tier strings to auto-populate job functions.
- Predictive Auditing: A 60-day expiry cycle with a 72-hour “Pre-Expiry” warning system.
- UX Optimization: Implemented Calendar Pickers and Data Validation to ensure 100% data integrity for non-technical managers.