Financial Analyst (Quality Claims) - Coral Gables, FL

Purpose of Position:
To research and identify Miscellaneous Deductions taken by customers by obtaining backup from customer and ascertaining if it belongs to DMFP. Dispute immediately with customer items deemed to be invalid and copy collector on all communications for their follow up. Scan and save each Miscellaneous Debit to appropriate folder on NADATA: Expo Clip drive. Update transaction details in Oracle to reflect correct sales person responsible to clear deduction for the weekly reports generated in Oracle Discoverer. Create and/or approve requests for application of Credits or Credits on account to deductions taken.

Accountabilities:

Measured via Aging of Open Deductions & number of unidentified items.
Research and identify Miscellaneous Debits on the Open Deduction Report by reviewing backup provided & use of internal reports for claims processed.
Create & maintain Excel workbook with various tabs to reflect items by Miscellaneous Debit #, by Customer, by unidentified items and by Invalid/Disputed/Litigation. Provide this weekly to the Collection Department and Claims Coordinators.
Follow up and provide weekly updates on the progress of identified Miscellaneous Debits’ clearance off the Aging Report by maintaining an Excel workbook showing weekly/monthly changes in Miscellaneous Debits reflecting items cleared on a weekly basis and pay backs received.
Create & maintain address book of customer contacts, e-mail address, telephone & fax numbers.
Communicate as required with customer contacts in order to obtain invoice information and backup documents to validate deductions made via Miscellaneous Debits not included as backup with their payment.
Obtain access to customer on-line systems to resolve to deductions taken.
Update/add identified Miscellaneous Debits with the proper invoice # and salesperson’s name to the appropriate regions Open Deduction Report once the research and identification process has been completed by updating transaction fields in Oracle that have been created to reflect identification of Miscellaneous Debits with invoice #, salesperson’s name and/or reason for deduction if not invoice/order or PO driven.
Communicate as necessary with sales force in order to ensure they understand the responsibilities pertaining to the newly identified miscellaneous debits that are allocated under the names and/or respective regions.
Work with rebate department on approved rebate programs to ensure that the customer does not deduct more than the earned rebate amount. Provide backup to sales staff & collectors when there is a discrepancy for disputing.
Scan the acquired backup documents with copy of Clip Report/cover sheet & check copy, saving to the appropriate NADATA: Expo Clip folder for retrieval by the sales department.
Recode items (invoices and/or Miscellaneous Debits) deemed invalid/disputed by sales after their review of backup scanned & sent and after they have provided detailed backup to collector to dispute.
Monitor credit approval on Miscellaneous Debits with order # assigned. Prepare & send offset request to Accounts Receivable for all approved Credits in order to clear off the aging report.
If credit is approved but not updated in Oracle, review Oracle Staging table to see if it needs to be FORCE MATCHED & prepare offset request to clear.
Approve requests sent from field personal for application of credit balances to customer deductions for Clips off the invoice & Miscellaneous Debits.
Assist A/R Cash Posting Clerks to ascertain which invoice a deduction belongs to by reviewing open expos and/or running reports in Profits Discoverer when asked for help so that a deduction taken becomes a clip thus avoiding the creation of a Miscellaneous Debit that will have to be offset.
Special projects as requested by management.

Minimum Skills Required:

College Degree and/or 2 years’ experience in Accounts receivable or 2 years’ experience in a credit related field. (i.e. Claims, working with Miscellaneous Debits/Charge backs, etc.)
Knowledge of Microsoft Office programs (i.e. Word, Excel, PowerPoint and Outlook, etc.).
Excellent organizational, interpersonal and communication skills (i.e. oral and written).
Detail oriented, ability to multi-task and work independently.

Preferred but not Essential: