Max Rautenkranz · max_rautenkranz.xls
File
← Projects

Teams timesheet agent Released

A Microsoft Teams AI agent on Azure that drafts consultants’ timesheet entries from their calendars for quick review.

Problem

Finance needed consultants’ hours in on time for its weekly close, and the API the agent writes to had no OAuth.

What I built

Engineered a Microsoft Teams AI agent on Azure that drafts entries from calendars through Microsoft Graph and writes plain-language recaps with an LLM for quick review, plus new finance and manager views. Built a secure write model for the API: one server-side token in Azure Key Vault, Teams SSO identity mapping, and code-enforced create-only writes.

Results

Released firm-wide.

At a glance

TypeInternal tool
RoleSenior Consultant, Optimum CS
Year2025–26
StatusReleased
StackMicrosoft Teams, Azure, Microsoft Graph, Microsoft 365 Agents SDK

Last updated