BACKGROUND
As a software engineering intern on the FIDO team at LexisNexis Risk Solutions, I built a custom internal reporting system to help engineering leadership understand how time and effort were distributed across Jira tickets and projects.
PROBLEM
Engineering managers had no easy way to see how teams were allocating time or progressing across multiple projects. They relied heavily on static reports, outdated spreadsheets, or manually pulling Jira exports, none of which showed the full picture. The data was messy, fragmented, and hard to trust.
OUTCOME
Using SQL queries, I transformed raw Jira worklog data into a dynamic Power BI dashboard, makign it easier to plan resources, track performance, and spot bottlenecks, improving engineering agility across the organization.
GOALS
USER GOAL
As an engineering manager, I want to easily extract Jira project workflow information from a dashboard
BUSINESS GOAL
We want to improve engineering productivity by gaining insight into performance.
MY ROLE
As a full stack engineer, I was responsible for developing both backend data logic and front end reporting experience to help leadership understand how engineering time was being spent across projects. To accomplish this project, I took the following steps:
IMPACT
IMPROVED DATA INSIGHTS
The tool transformed how leadership viewed productivity, replacing manual tracking with a flexible, real-time dashboard. It surfaced patterns like team overwork, underutilized contributors, or slow-moving tickets early, allowing managers to adjust plans proactively.
By treating data like a product, I helped make operational metrics understandable and actionable for non-technical stakeholders, improving clarity, accountability, and team performance.
REFLECTIONS & TAKEAWAYS
By working with the raw Jira data and transforming them into usable insights, I learned a lot about how to extract useful information to gather key insights when presented with a large amount of data.
✨ Huge thanks to my team and mentors for guiding me through this project!
