Skip to interactive case
LoriTechFROM DATA TO RESULTS← Back to portfolioLet's connect ↗
FEATURED CASE / PROCESS TRANSFORMATION

Every report.
The right documents.
A traceable delivery.

I redesigned and developed an end-to-end contractual financial reporting workflow: from contract-based deadlines to multi-level authorization and delivery evidence.

Power AppsPower AutomateSharePointExcel OnlineOutlookPower BI · DAXJSON
Explore the interactive case ↓

100+fiduciary reports sent daily
in the original operation

5contractual reporting
frequencies

End to endProcess reengineering,
architecture & development

THE CHALLENGE

A contractual obligation.
A fragmented process.

Manual distribution and scattered business information made it difficult to track contractual deadlines and required attachments. Reports could be late or incomplete, while several business roles needed to review them.

The solution brought business setup, date calculation, preparation, cascading authorization, delivery and monitoring into one connected workflow.

FOLLOW ONE REPORT THROUGH THE SYSTEM

Four views.
One connected story.

Start with business setup, or use the sample batch. Your actions carry across all four views.

Illustrative screens recreated to protect business confidentiality. Based on a solution I designed and developed; all data shown is fictional.

CONTRACTUAL REPORTING / LORITECH DEMO
Next: explore the setup form or prepare a sample report.Local simulation · No messages or files are sent
THE ENGINEERING BEHIND THE EXPERIENCE

Controls that make
the workflow useful.

01 / CONTRACT LOGIC

Dates anchored to the contract.

Each reporting period is derived from the signature date. The configured delivery window then counts calendar days or business days, consulting a Colombian holiday calendar.

02 / VALIDATION

Missing information blocks progress.

Required fields, duplicate setup rules and mandatory attachments are checked before the workflow moves forward. There is no rejection state in this reporting process.

03 / ACCOUNTABILITY

Authorization leaves a trail.

Preparers assemble the reports. Coordinators, directors and managers review in sequence. Delivery evidence records when the message was sent, who initiated it and which filenames were included.

MY CONTRIBUTION

From process reengineering
to the working solution.

I redesigned the process, built the canvas-app screens and functional workflows, structured SharePoint storage, implemented the Excel calculations and holiday data, connected the Outlook delivery, and developed reporting and analytics with Power BI and DAX.

LET'S BUILD SOMETHING USEFUL

Business understanding.
Hands-on delivery.

Looking for someone who connects process design, Microsoft Power Platform and practical software engineering?

Start a conversation ↗Explore more solutions →