LoriTechFROM DATA TO RESULTS← Back to solutionsLet's connect ↗
CASE STUDY / FIDUCIARY OPERATIONS

Centralized
Payment System.

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

THE BUSINESS PROBLEM

From manual handoffs
to one visible process.

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.

INTERACTIVE WALKTHROUGH

Follow a payment instruction.

Illustrative screens recreated to protect business confidentiality. All records, notifications and transactions are fictional. No emails are sent and no funds move.

  1. 01 · Verify sender
  2. 02 · Check documents
  3. 03 · Complete parallel lanes
  4. 04 · Simulate delivery
  5. 05 · Review metrics

MY CONTRIBUTION

Process design, development
and operational visibility.

I redesigned the payment process and built the functionality for intake, routing, deadline calculation, approval queues, notifications and operational analytics.

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.

Coordinate concurrent reviews.

Launch the applicable review lanes together. Hold payment management until all required lanes finish, with an additional manager approval above COP 500 million.

Make exceptions visible.

Require a reason for every rejection or return. Keep a shared trail of who acted, their role and when they acted.