Responsibilities:• Preparation and posting of all payable documents.• Code and then Reconcile AMEX purchases to A/P sub-ledger• Prepare the sales commission reports• Prepare import landed cost worksheets, and then submit the duty drawback claims on a quarterly basis • Prepare customer rebate reports on a quarterly basis• Consolidate sales by product ID in order to generate the quarterly reports for the college and university licensing bodies• Reconcile the year-end physical inventory counts to the Sage Business Vision records• Reconcile our website product counts to our Sage Business Vision records• Work with our partners in India to resolve technical issues with our website• Work with our partners in India to set-up the API modules for PromoStandards Accomplishments: • Wrote VBA programs in Excel to automate the generation of upload files for the PromoStandards API• Generated VBA program in Excel that generated sales commission reports from the monthly sales data

I took some time off to day trade.

Responsibilities:• Oversee a staff of 2.• Test and assisted in the implementation of Compass, the new ERP program.• Train staff on the most efficient use of the new program.Accomplishments: • Wrote the complete instructions on how to use the Accounts Payable module within Compass.• Developed a number of scripts using the Auto Hotkeys program that enable us to work more efficiently in the Compass program.• Trained staff on the basic controls and best practices for the A/P department

Responsibilities:• Oversee a staff of 11.• Motivate, train, and guide staff on A/P procedures with emphasis on controls.• Review all payments prior to distribution.Accomplishments: • Trained staff on the advanced features of Excel and the basics of database design using Access.• Wrote Access program that automated the balancing of UPS shipment costs to amounts billed out to the Customers.• Created Access program for the Inventory department that reconciled the inventory numbers between two systems.• Wrote Access program for the Production department that tracked heat seal production jobs.• Designed a presentation Excel workbook for the Design department that imported images based on the style number entered.

Responsibilities:• Oversee staff of 3.• Control the distribution of payments during severe cash shortage.• Approve all A/P input prior to posting and approved all cheques prior to signing.

Responsibilities:• Match invoices to purchase orders and posted into system.• Maintain the Vendor Master table.• Reconcile A/P control and vendor accounts.• Review cheques under $10,000.Accomplishments: • Recovered approx. $110,000.00 in duplicate payments.• Developed a number of Oracle queries that enabled me to perform my functions more efficiently.• Tightened controls in adherence to the Sarbanes-Oxley rules,