DIEGO MELENDEZ
Back to Projects

Relance Client

2025
Context

For a company's sales-administration team.

Problem

Generating an overdue/unpaid invoice statement client by client and preparing the email was long, repetitive, and error-prone.

Solution

An automation that filters the client's data, highlights overdue invoices, computes key totals with auditable formulas, generates the final file, and prepares the reminder email in Outlook. Strict per-client data isolation.

Result

Turns a tedious manual task into an instant, reliable process.

Role

Data & AI Project Manager / end-to-end development.

Tech stack
  • Power Automate Desktop
  • Excel
  • Outlook
  • PowerShell