Context & Change Environment
"These initiatives were executed during the early phase of a newly restructured procurement operating model. There was a clear need to support adoption through system-led enablement, rather than relying on manual coordination."
The strategic objective was to stabilize operations quickly, reduce friction, and allow teams to focus on value-adding work by embedding the new procurement structure directly into system logic.
Business Challenges Identified
Procurement Intake Issues
- • PRs frequently mis-routed during transition.
- • Buyers spending hours manually triaging.
- • Increased PR-to-PO cycle time due to rework.
Manual Approval Workflows
- • Leave requests handled via informal emails.
- • No standardized approval trail.
- • Lack of transparency and auditability.
PR Assignment Automation (Coupa + VBA)
Technical Architecture
Coupa Report Extraction
Automated custom report extracting new PRs, including Category, Supplier, Spend Type, and Geography.
Excel VBA Logic Engine
Macro triggered every 3 hours applying routing logic based on Buyer Responsibility + Spend Thresholds.
Automated Email Routing
PR assignment emails sent automatically to the correct buyer with deep links and priority indicators.
Slack Leave Approval Workflow
In parallel, I built a Slack-based workflow to streamline internal approvals and remove reliance on spreadsheets and email chains.
-
One-Click Approvals:
Managers approve/reject directly within Slack.
-
Centralized Audit Trail:
All requests and decisions automatically logged.
-
Reduced Admin Overhead:
Eliminated manual follow-ups and lost emails.
Technical Skills Demonstrated
Strategic Impact
"These automations demonstrate my ability to support teams during transformation, not just operate in stable environments. By embedding governance into systems, I reduced operational friction and enabled the procurement team to focus on strategic work."