GitHub license management
Optimizing GitHub License Usage for Pfizer
By integrating GitHub, HR, and SSO data into a unified Tableau dashboard, a Fortune 100 Enterprise uncovered inactive users and streamlined license management. Two reviews so far have saved over $1.1M a year.
- Engineering ops
- Cost control
- $1.1M a year saved
Challenge
Managing over 9,000 GitHub licenses across 20 GitHub organizations became costly. At $21 per user per month, there was no easy way to see who was active, and what “activity” means. From commits to reviews to occasional logins, there was no simple way to determine it.
Solution
We integrated GitHub REST and GraphQL data with internal SSO and HR sources and brought it to Snowflake. This data is also used for other use cases. We built a Tableau dashboard that shows user activity and enriched it with HR data. Managers could filter, review, and trigger license revocation requests directly from the insights.
Results
The dashboard immediately identified ~1,100 inactive accounts. Their licenses were revoked, saving Pfizer over $270,000 per year while improving visibility and governance across all development teams. Pfizer has since run the same dashboard again and freed another 2,000 licenses at $35 per user per month, about $840,000 a year. Together that is over $1.1M a year, from a dashboard that took a few days to build once the data was in place.
What the people we worked with say
Igor's impact went far beyond aesthetics - he took full ownership of the entire data lifecycle within a highly regulated environment, building robust pipelines, integrating complex data sources, and modeling underlying data to ensure absolute accuracy, compliance, and scalability.
Igor consistently delivered high-impact dashboards that translated intricate metrics into intuitive, actionable insights for everyone from daily users to C-suite enterprise stakeholders. His work … directly informed strategic decisions while adhering strictly to rigorous compliance standards.
Lefteris Paraskevas
Director of Source Code Platforms & Developer Experience, Pfizer
I can’t say enough about the impact he made. The Tableau dashboards he built completely transformed how our team understands and manages DevSecOps.
What once felt complex is now clear, efficient, and truly insightful. He’s exceptionally skilled, responsive, and always focused on finding solutions. No matter how detailed or challenging our requests were, he consistently delivered exactly what we needed.
Christopher Condello
Sr. Manager, DevSecOps, Pfizer
He has contributed above expectations to the service area he works in.
Not only has he demonstrated deep domain knowledge around Tableau, data visualization and integration, but he also provides frequent input on how the team can improve service delivery and increase value for internal customers.
Dick Olsson
Director, Principal Engineering Lead, Pfizer
Next step
Recognise this pattern?
It is rarely the report. It is usually what feeds it. That is a fixable problem.
Thirty minutes, straight to the problem. No deck, no pitch, and a written summary afterwards either way.