FeaturedMay 2, 2024

FlowLenz Ticket Management System

A comprehensive ticket management system that integrates Jira and Azure DevOps API scrapers with a React frontend and .NET backend. Utilises the Postgresql to store the tickets.

The Problem

The engineering team was context-switching between Jira and Azure DevOps constantly, duplicating tickets across both systems and losing visibility into cross-platform work.

The Outcome

Built a unified dashboard that scrapes both platforms every 30 seconds, deduplicates tickets with AI similarity scoring, and surfaces assignee recommendations — reducing context-switching overhead for the team.

Timeline

8 weeks

from kickoff to delivery

Screenshot of FlowLenz Ticket Management System

Key Features

  • Unified dashboard for Jira and Azure DevOps tickets . This was scraping each all tickets based on project name and inserting it into one table in a PostgreSQL database.
  • Real-time synchronization with external systems , the system scrapes the tickets after every 30 seconds based off the API .
  • Frontend design utilized the interface to showcase each tickets with further details shown when clicked on. The details included the project name, assignee , creator , ticket name , ticket details as well as date issued .
  • Pagination of the tickets on the frontend design allowed a custom number of tickets to be shown per page. The options were 10 , 20 , or 30 tickets per page
  • Incorporates an AI tool to suggest the best assignee based on the ticket data.
  • Ability to choose which project to scrape based on the project code
  • The frontend design adapted to device screen sizes as needed. Whether mobile , desktop or tablet

Challenges & Solutions

Integrating with different API structures (Jira and Azure DevOps) required creating a unified data model while preserving platform-specific features. I implemented adapter patterns and a robust caching system to ensure seamless operations.At first the Jira and Azure API were working as intended. After some time the Jira API was deprecated and could only scrape 100 tickets instead of the full ticket amount.

Technologies

ReactTypeScript.NETPostgreSQLJavascriptDockerC#Azure DevOps APIJira API
Status:Completed
Tech Stack:9 technologies
Features:7 key features
Timeline:8 weeks

Need something similar built?

Hire Me for This