TECHNICAL SKILLS:

• Advanced Microsoft Office skills
• Microsoft Excel, vlookups, pivot tables
• Microsoft Word, Outlook, Power Point, Access
• Oracle PeopleSoft, SAP
• Microsoft Navision, QuickBooks
• Peachtree, FileMaker Pro, RetailLink
• Accounts Payable Support System (APSS)
• HOST, APEX FirstStrike
• Adobe Acrobat, Adobe Photoshop
• ImageReady, Adobe Illustrator

PROFESSIONAL EXPERIENCE:

Confidential, Simsbury, CT

External Reporting Accountant

Responsibilities:

• Assisting with Separate Accounts Funds Financial statements preparation and other SEC filings, including preparing and filing NSAR - U and 24f-2 forms for separate accounts and hedge funds.
• Financial statements filing included balance sheet, income statement, statements of changes in net assets, financial notations and other reports for separate accounts.
• Preparing month end reporting, accruals and settle up entries and general ledger reconciliations.
• Working with databases, statements and reports in Excel by creating, manipulating and merging data and pivot tables and using functions such vlookups/hlookups, ifs, and, concatenate, index, match, conditional formatting, macros, etc.
• Uploading journal entries to PeopleSoft, creating and running queries and reports in PeopleSoft
• Record retention and procedure documentation.

Software Skills: Oracle PeopleSoft, Excel (pivot tables, vlookups, if(s), index, match, conditional formatting, macros) Outlook, Word, Adobe Acrobat

Confidential, Boston, MA

Finance coordinator

Responsibilities:

• Receiving, scanning, managing and storing the physical AP vendor invoices, notices, statements, reminders and sharing them with the Shared Services team on a regular
• Managing the checks printed and matching and dispatching them to the vendors
• Creating vouchers for invoices and wire payments in PeopleSoft
• Getting an approval and back-up, and obtaining the second signature on checks exceeding the limits defined in Control Matrix
• Proving General Ledger (GL) coding for invoices when asked and reviewing and reassigning employee expense reports
• Handling all calls and vendor queries and questions related to Accounts Payable function
• Working on abandoned property project

Software Skills: SAP, Oracle PeopleSoft, Excel, Outlook, Epicor, Word

Confidential, New York, NY

Staff Accountant

Responsibilities:

• Reconciled bank statements and G/L accounts
• Prepared and recorded journal entries, recurring entries
• Analyzed jobs’ profitability and calculated sales commissions
• Created Accounts Payable and Accounts Receivable aging reports, trial balance reports
• Helped with the preparation for the audit
• Compared and evaluated job costs from Peachtree and FileMaker Pro

Software Skills: Peachtree, FileMaker Pro, Excel, Outlook, Word

Confidential — Astoria, NY

Accountant

Responsibilities:

• Processed Accounts Payable and Accounts Receivable invoices, payments, deposits
• Processed invoices and bills, made collection calls
• Reconciled bank statements and G/L accounts at the end of the month
• Prepared and recorded journal entries, including recurring entries, expense accruals, loan and mortgage payments, and transfers
• Prepared monthly account reconciliations including cash, expenses, fixed assets and inventory
• Prepared Accounts Payable and Accounts Receivable aging reports, inventory reports, Profit and Loss reports, trial balance reports
• Worked with external auditors at the end of the year
• Handled payroll each week and filed taxes for payroll each week

Software Skills: Microsoft Navision, Excel, Outlook, Word, RetailLink, Adobe Acrobat

Confidential — Bentonville, AR

Auditor

Responsibilities:

• Reviewed accounts payable invoices and payments made to suppliers for the previous year to ensure proper amounts were collected for offered allowances, cash discounts, and pricing discrepancies
• Reviewed accounts receivable customer returns’ claims for the previous year to ensure all merchandise, freight and handling fees were collected from suppliers accounts reviewed paid history for potential duplicate payments or other over payments to suppliers; processed invoices reconciliation of supplier agreements to paid history accounts receivables collections
• This position required contact with suppliers and buyers to resolve issues and collect discrepancies.
• Above average work performance, above average recoveries for Wal-Mart
• Testing and making recommendations prior to start of each audit

Software Skills: RetailLink, Accounts Payable Support System (APSS), HOST, APEX FirstStrike, Excel, Access, Outlook, Word, Adobe Acrobat

Confidential — West Springfield, MA

Staff Accountant

Responsibilities:

• Filed Sales/Use Tax Returns
• Processed invoices
• Reconciled bank statements and G/L accounts
• Reviewed budgeting and actual figures and reported finding to immediate manager

Confidential — Chicopee, MA

Staff Support Rep

Responsibilities:

• Mailing operations tasks
• Daily processing of all files sent to the server: this consisted of importing files, printing labels and reports
• Shipping/Receiving; monthly processing of Classroom Edition of Wall Street Journal
• Fulfilling office supply orders & maintaining and monitoring inventory