Richard H. Allen Jr.

Snowflake Row-Level Security Governance Tool Problem: Access rules for analytics data were hard to manage and audit. Approach: Built a tool to manage and review row-level security policies. Stack: Snowflake · SQL · Python Healthcare Operations Reporting (de-identified) Problem: Leadership needed governed visibility into patient-program operations in a HIPAA environment. Approach: Power BI semantic models with row-level security over Snowflake. Stack: Power BI · DAX · Snowflake · RLS Order Document Intake Automation Problem: Inbound order documents were triaged manually. Approach: Designed an automated intake pipeline connecting the help desk, document AI, and the billing system. Stack: APIs · Power Automate · Python Microsoft Entra Tenant Baseline Problem: New tenants start with permissive defaults. Approach: PowerShell / Microsoft Graph script enabling MFA defaults, hardening user and guest permissions, and creating break-glass admins. Stack: PowerShell · Microsoft Graph · Entra ID JobSynk — Career Pipeline Platform Problem: Job searching is scattered across sites and spreadsheets. Approach: Built a web app that aggregates job sources, matches resumes to job descriptions, and tracks the pipeline. Stack: JavaScript · APIs · AI Visit JobSynk