Juan Cabrera
*** **** *** ****** *** #*F Bronx, NY 10452
****.*********@*****.***
Employment History:
**/****-******* ***/*** Worldwide (Omnicom Media Group) New York, NY
Senior Print/Digital Media Reconciliation Specialist (Client Billing/Accounts Payable/Receivable Specialist)
Researching, processing and invoicing 500-800 invoices weekly
Respond to vendors/clients and internal teams calls and emails, research and resolve vendors/client’s issues, questions, or discrepancies regarding invoices, and statements
Follow through on any discrepancies with vendors/clients
Review and approve coding of accounts payable/receivable invoices within our Media Ocean, Prisma system
Track and reconcile inventory and provide monthly excel clients aging reports to CFO, Investments/Strategist and Accounts Payable & Receivable media managers
Compiled monthly invoices into excel/pivot reports to show CFO, Buyers and Accounts Payable/receivable Media managers
Managed and tracked client budget quarterly for reconciliation purposes
Managed of client billing function and monitoring actual expenditures to budget
Review of all media purchases
Strong customer service and organizational skills
Work closely with internal teams Investments/Strategist to reconcile discrepancies
Responsible to assist and train new and existing employees onshore and offshore (India)
Assist in all internal and external Invoices audits projects
Presentation of the Budget report to clients
2/2006-5/2011 Publicis Groupe (Lion Resources U.S.A) New York, NY
Media Print/Interactive Accounts Payable – Client Financial Analyst
Reviewed perspective clients & vendors
Monitored all clients & vendor activity through writer reports
Prepared reports as requested and also verify purchase orders by confirming specifications and price from teams.
Compiled monthly invoices into Excel/Pivots reports to show CFO, Buyers and Accounts payable media managers
Followed through on any discrepancies with vendors
File folders for completed client records
Responded to vendors call and emails, researching and resolving issues.
Reconciled discrepancies showing on reports
Track and reconciled inventory and provided monthly reports, including work in process reports
Reviewed and analyzed updates in our system
Strong Customer service and organizational skills
5/2001-2/2006 Omnicom Group (BBDO Worldwide Advertising) New York, NY
Media Print Accounting Clerk
Heavy interaction with clients/vendors
Ensured accuracy of check remittances
Maintain records of open accounts
Ensured accuracy of insertion orders and tear-sheet ads
Verified company expenses before processing
Created reports to improve efficiency
Prepared complex reports
Entrusted with distribution of checks from vendors
Data Entry
Educational Background:
1/2015-5/2017 Interboro Institute New York, NY
Business Management
6/1995-1/1999 George Washington High School New York, NY
High School Diploma (Business)
Skills: Bilingual; Spanish/English, Type 70 WPM, Office, MS Word, MS Excel, PowerPoint, Pivot Table, VLOOKUP, Lotus Notes, Adobe Reader, MBOX, AURA, IPS Workflow, ONBASE, DART, Citrix, Replicon, Tax Control, Elite, Access Tracking, HCPLUS, PeopleSoft, SAP, Telescope, Media Bank O/X, Prisma, BrandFX, Matchmaker, Datatech, AdBuyer, Media Ocean & DDS Archive