← Rook.works

Selected work

Operations systems that leave a trail.

Case studies in workflow design, reporting, auditability, and practical automation for complex HR operations. Public examples use anonymized or synthetic data.

Intake and decision support

Transfer Preference System

Structured a high-volume preference process around self-service intake, automated notification, eligibility review, latest-submission logic, and a retrievable audit trail.

Microsoft Forms · Power Automate · Excel · SharePoint
Reporting and process improvement

Training Attendance Architecture

Rebuilt manual attendance tracking into a validated Excel/VBA intake, a Power Query master log, and reporting designed for operational use.

Excel · VBA · Power Query · Dashboard Design
Workflow design pattern

HR Intake and Routing Pattern

An anonymized systems pattern for routing requests, approvals, handoffs, notifications, and audit-ready records across operational teams.

Microsoft 365 · Teams · SharePoint · Process Mapping

Illustrative elements are identified inside each case study. Claims and examples are limited to the documented workflow, anonymized patterns, and synthetic demonstration materials.