←All casesKHARI THOMASKT
Workflow Automation

Status Report Builder

The Status Report Builder command-line tool building a report from Jira, beside the finished spreadsheet
Client
Multinational (confidential)
Date
2024
Sector
Enterprise
Platform
Internal tool
01 · The Challenge

Creating status reports was a slow, repetitive process. Each report took around 2.5 hours to prepare, creating a significant time cost for the team throughout the year.

02 · My Solution

I built a simple command-line tool that automated the process from start to finish. The team can now generate a status report in under two minutes.

  1. 01Mapped the process: I broke down the existing reporting workflow and identified the steps that could be automated.
  2. 02Built the tool: I created a command-line tool that handled the repetitive work involved in preparing each status report.
  3. 03Simplified the workflow: I turned a multi-hour manual task into a quick, repeatable process.
  4. 04Measured the impact: I compared the new process with the old one to quantify the time saved.
03 · The Result

Status report creation dropped from 2.5 hours to under 2 minutes, a 75x improvement. The new process saves an estimated 500 hours of work each year.

75xFaster report creation
<2 minTime to create a report
500Hours saved annually
The Status Report Builder finishing in under two minutes, with the generated status report spreadsheet