Internal Workflow Automation Platform for an Architectural Design Firm
Developed by R. Paulo Delgado.
Informal, unenforced drawing approvals replaced by a mandatory, auditable workflow system.
Client Context
The client was an established architectural design firm with employees producing bespoke architectural drawings for projects.
Each drawing was required to pass through a highly formalized internal review and approval process involving multiple roles before being released to external clients. Prior to the engagement, this process relied on manual coordination, which led to errors and dropped balls.
The Problem
The organization had no formal system to manage the lifecycle of architectural drawings. Approval steps had no built-in enforcement step. Steps could be skipped and approvals delayed indefinitely. Management had no visibility into where work stalled or why.
Key challenges included:
Unenforced approval processes
Drawings could bypass required reviews, creating quality and accountability risks.
Operational opacity
There was no reliable way to determine where projects were blocked or which approvals were pending.
Key-person dependency
Progress relied on individuals manually determining which steps followed rather than on systemized enforcement.
Revenue impact from delays
Project completion directly affected billing, making delays financially significant.
The core issue was the absence of any enforceable operational system.
The Solution
I designed and built a custom internal platform that formalized and enforced the firm's entire drawing approval workflow.
The solution addressed several architectural focus areas:
- 1
Process formalization
Existing informal approval practices were translated into explicit, sequential workflow rules.
- 2
Workflow enforcement
Mandatory state transitions ensured that drawings could not progress without required approvals.
- 3
Visibility and accountability
The system provided clear insight into the status of every drawing and responsible parties.
- 4
Automated notifications
Email-based reminders and escalation warnings were introduced to prevent stalled steps.
- 5
Reporting and auditing
Comprehensive reports enabled management to review workflow adherence and identify bottlenecks.
Architecture & Technology
Core Platform
- Custom-built Windows desktop application
- Centralized local SQL Server database
- Explicit workflow state machine governing drawing progression
Workflow & Enforcement
- Role-based approval permissions
- Mandatory sequential processing
- Hard prevention of skipped steps
Monitoring & Notifications
- Full lifecycle visibility for all drawings
- Automated email reminders
- Escalation warnings for unhandled steps
Execution & Delivery
The engagement covered full responsibility for analysis, architecture, implementation, and rollout.
Key characteristics of delivery:
- Translated manual operational rules into deterministic system logic
- Designed for an environment without existing workflow tooling
- Focused on reliability and enforcement rather than flexibility
- Provided ongoing support as the system became central to operations
The system imposed operational discipline through design rather than policy.
Outcomes & Impact
- Reduced project turnaround time
- Eliminated skipped or forgotten approval steps
- Provided management with complete visibility into workflow bottlenecks
- Improved predictability of project completion and billing
- Established a single system of record for drawing approvals
The platform became a mission-critical part of the firm's daily operations.
Why This Project Matters
This project demonstrates the ability to:
- Build foundational systems where none previously existed
- Translate complex, domain-specific processes into enforceable software
- Reduce operational risk through deterministic workflow design
- Deliver systems that become central to business execution
- Operate as a long-term technical partner
Project Tags
- VB.NET
- SQL Server
- Microsoft Exchange Server
- Team
- Workflow Automation
- Desktop Software
- Architecture
- Process Enforcement