Employee Utilization Reports
Web API solution that collects and processes employee worklogs from different company departments via Atlassian Tempo API, generating weekly reports and supporting multiple output formats.
Problem
Organizations struggle to track employee utilization across multiple departments. Manual collection and processing of worklogs from various sources is time-consuming and error-prone. Management needs automated insights and flexible reporting formats.
Approach
Built a modular Web API solution using C#, ASP.NET Web API, Azure Cloud Platform, Azure Functions, In-Memory Caching, REST, JSON, XML, CSV, xUnit for testing, NLog for logging, and Handlebars.NET for templating. Integrated with the Atlassian Tempo API to collect employee worklogs from different company departments. Developed Azure Functions for automated weekly email reporting. Implemented support for multiple output formats (JSON, XML, CSV) for individual or team-based reporting across custom date periods. Used Polly for resilience patterns.
Outcome
Streamlined employee utilization tracking and enabled automated insights for management. The modular API can be integrated into various company systems, reducing manual effort and improving reporting accuracy. Generates weekly reports and sends worklogs to employees by email.