Protect the entry point.
Match the sender to the authorized addresses for that fiduciary business. Log unauthorized attempts and route notifications to the sender, intake team and fiduciary business coordinator.
I redesigned and developed a system used by 19 areas to receive, validate, route and track fiduciary payment instructions against agreed service levels.
Explore & try the tool ↓19 areasCoordinated around one ticket
ParallelReview lanes with a shared approval gate
TraceableRole, timestamp and decision at every handoff
Manual handling made it difficult to follow instructions across teams and meet client service-level agreements (SLAs). I reengineered the process and developed the workflow, from authorized email intake to post-payment tracking.
Outlook and Power Automate handle intake and notifications; Power Apps provides role-specific queues; Python calculates deadlines. The technology stack also includes SharePoint, Azure, SQL queries, JSON, Excel and Power BI with DAX and Python.
Illustrative screens recreated to protect business confidentiality. All records, notifications and transactions are fictional. No emails are sent and no funds move.
I redesigned the payment process and built the functionality for intake, routing, deadline calculation, approval queues, notifications and operational analytics.
Match the sender to the authorized addresses for that fiduciary business. Log unauthorized attempts and route notifications to the sender, intake team and fiduciary business coordinator.
Launch the applicable review lanes together. Hold payment management until all required lanes finish, with an additional manager approval above COP 500 million.
Require a reason for every rejection or return. Keep a shared trail of who acted, their role and when they acted.