📈 Project 2: PowerBI Transformation for Global Performance Management
Situation:
At IPA, legacy systems hindered real-time performance tracking for 1,000+ users across multiple countries.
Task:
Lead the end-to-end development of Project CASPER – a dashboard-driven automation solution for performance monitoring.
Actions:
- Built cloud-hosted dashboards on Azure in collaboration with Microsoft.
- Created interactive Power BI visuals tailored to KPIs (TAT, grant utilization, shortfalls).
- Conducted biweekly feedback sessions with global teams.
- Automated reporting pipelines using Python and SQL.
Result:
✅ Saved 15 mins/user daily → ~$5,000/day
✅ Estimated annual cost savings of ~$1M
✅ Improved user experience and operational efficiency