Wellington BarbosaData engineering & software

A central portal for services and automations

Visibility for robots that used to run blind.

The problem

Automations and IT tools ran with no central view: nobody could see what worked, what failed and how much time was saved.

Overview

  1. Who uses it

    • Business areasEach user sees only their department
  2. Central portal

    • DashboardActive robots, errors and hours saved
    • Manual or scheduled triggerWith history and logs
    • Scheduled reportsDelivered by e-mail through an authenticated link
  3. Connection

    • Custom SDKOne token per robot; the database stores only the hash
  4. Automations

    • Robots and routinesRegistered in the database, no code change
    • Formerly manual IT tasksNow done by the business areas

Measured returnThe estimated manual time goes into each robot’s record. On every run, the dashboard calculates the hours saved.

Who uses the portal, what it controls and how each automation connects to it.

What I built

  • A dashboard with active robots, robots in error and hours saved, with an automatic return calculation.
  • Manual or scheduled triggering of each automation, with history and logs.
  • A purpose-built SDK to standardize how each automation talks to the platform.

Under the hood

Each robot with its own key

When a robot is registered it receives an exclusive token, shown only once. The database stores only the hash, and the token is valid only for that robot.

Who can do what, by department

Each user only sees and triggers the robots of their own department. A robot that is inactive, or already running, cannot be triggered again.

Return measured for real

The estimated manual time goes into each robot’s record. On every run, the dashboard calculates the hours saved compared with the manual process.

Reports that arrive on their own

Parameterized reports with scheduling and e-mail delivery through an authenticated link, instead of one-off requests to IT.

The result

  • A single view of what each automation does, where it fails and how much it saves.
  • More than 80% of the routines IT used to run by hand in the database are now done by the business areas themselves.
  • New automations registered through the database, with no code change.

Have a similar problem?

Tell me the scenario and I will say, no strings attached, where I would start.

Get in touch

See also

Back to the projects