Jira Report Automation
JIRA is a software development tool to help plan, track, and deploy work throughout the software development lifecycle (SDLC). During my time at CCC, my team had a need to understand our sprint velocity but were constrained by the functionality of reporting within the JIRA software. I decided to take matters into my own hands and use my Python and Tableau skills to build our own custom reporting solution to support our line of business.
Overview
By building our own reporting solution on JIRA we got visibility into performance improvements and bottlenecks.
Problem
JIRA's reporting solutions were very limited not allowing for customization to fit our use case leading to lack of visibility on team velocity.
Approach
Defined the report I was looking to create and created a quick prototype of the data output before diving into code. Once I received alignment on data fields and structure, I leveraged Python to pull data form Jira REST API and publish directly to our Tableau server. Leveraging Github actions, our script runs daily to keep our reporting always relevant.
Results
Assisted our team with improving worklife balance by finally understanding our true capacity. This has also resulted in a 15% increase in overall velocity.