Highlights
- Built a Python invoicing tool for the PBGC account that normalizes raw timesheet data into client-ready invoices, reducing a multi-day monthly process to minutes and saving 100+ hours annually across billing teams
Project Narrative
The Pension Benefit Guaranty Corporation (PBGC) account carried a billing requirement that each invoice detail what individuals were doing during the time billed to the client. Turning raw timesheet entries and comments into a properly organized, presentable invoice was demanding and time intensive. Each team had a dedicated person who spent days at the end of every month compiling and formatting it.
I built a Python script that pulled in the raw timesheet information and comments, organized them into the required invoice structure, and produced a clean Excel-to-PDF output ready for a quick human-in-the-loop review before submission. The substance of the work was in the data handling rather than the automation itself. Different teams recorded their notes in different formats, so the tool had to normalize inconsistent inputs into one standard, and it had to handle time zones correctly so billed time was accurate. What had taken a dedicated person several days each month now takes a handful of minutes.
Ownership of the tool deepened over time. What began as a script I built became a process I owned, working directly with the billing team and PBGC leadership to keep it aligned with the account’s evolving business requirements and ensure billing stayed accurate. Across the billing teams it saved hundreds of hours annually.