Case Study
Operational System Design
Replacing fragmented spreadsheets with a centralized, automated project management system.
Asana Core Tool
Spreadsheets → System Shift
Problem
- Departments operated independently using separate, unshared spreadsheets
- No standardized workflows or intake process
- Limited visibility across teams and leadership
- Execution depended on individuals rather than systems
This caused misalignment between sales and fulfillment, inconsistent execution, and no accountability or tracking.
Approach
Designed and implemented a centralized project management system to standardize workflows and create organization-wide visibility.
Key Product & System Decisions
Centralize All Work in a Single Platform
- Migrated all project management into Asana
- Eliminated siloed spreadsheets and disconnected workflows
Standardize Intake from Sales to Fulfillment
- Built a structured intake form capturing all required project details at the point of sale
- Ensured fulfillment teams received complete, consistent information
This reduced ambiguity and rework across the handoff process.
Automate Project Creation
- Configured Asana to automatically generate projects from intake submissions
- Standardized project structures, tasks, and ownership
This created consistency and eliminated manual setup.
Create Visibility Through Portfolio Dashboards
- Designed portfolio-level dashboards for each department
- Enabled leadership to track project status, workload, and delivery timelines
This introduced real-time operational visibility across the organization.
Execution
- Partnered with department heads to define workflows and requirements
- Built and iterated on system design within Asana
- Rolled out processes across teams and trained users
- Refined system based on real-world usage and feedback
Outcome
- Created real-time visibility into project status and team capacity
- Reduced operational friction between sales and fulfillment
- Enabled scalable execution across departments without increasing complexity
- Established consistent execution standards organization-wide