Hi everyone 
Just published an open-source project I built for automating SLA reporting from JIRA data:
GitHub: SLA Report Automation
What It Does:
This tool extracts ticket metadata from JIRA (via API) and generates:
- SLA breach statistics
- Department-wise resolution time reports
- Custom Excel reports with filters and charts
- Optional Slack/Email alerts
Built using:
- Python (Pandas, JIRA API)
- Scheduling via CRON or Task Scheduler
- Excel output with dynamic pivot tables
Why I Made This:
Most JIRA users rely on clunky manual exports or plugins for SLA reports. I wanted a lightweight, open-source alternative for:
- Support managers to monitor SLA KPIs
- Engineers to trigger alerts based on trends
- Integration into MLOps or workflow dashboards
Open Questions:
- How would you improve JIRA data extraction for NLP tagging?
- Should this be adapted into a Streamlit or Hugging Face Space for frontend access?
- Anyone using transformer models to predict future SLA risks from historical logs?
Looking forward to thoughts, feedback, and ideas for evolution!
— Arooj Javed