Invoice Reconciliation Analyst L2 public Remote experience
Publicis Global Delivery PGD
Sep 2024 - Nov 2025 (1 year 3 months)
Orchestrated end-to-end invoice reconciliation for digital and linear media campaigns for Eli Lilly, managing quarterly cycles (Q1-Q4) with variance of no more than $1 per invoice.
Utilized Mediaocean OX and Prisma to manage workflows, dispatch RFIs, and resolve discrepancies ensuring vendor compliance.
Drove data analysis efficiency using Advanced Excel (macros, VLOOKUPs, XLOOKUPs, INDEX-MATCH) for high-volume datasets exceeding 10,000 rows.
Resolved billing issues by monitoring automated matching systems, initiating manual reviews, and submitting query tickets. Managed reconciliation across CPM, CPC, CPA, and VOD billing models.
Collaborated with cross-functional teams across US, UK, and Colombia time zones to meet strict monthly close d