JOAN E. COLLINS, MBA

**** ****** ***** ****, #*** • Richmond Heights, OH 44143 • 440-***-****• ac5pbk@r.postjobfree.com Accounting Manager excellent analytical and balanced 5500 ERISA Tax forms, SAP, QuickBooks, Financial Reporting, Microsoft Excel, ADP payroll, general ledgers, and accounting reconciliation. Recognized for strong commitment to team environment dynamics with the ability to contribute expertise and follow leadership.

MEMBERSHIP

National Society Accountant – 2018

National Association of Certified Public Bookkeeper – 2018 PROFESSIONAL EXPERIENCES

Accounting/Finance

• Performed trades to buy and sell stock and mutual funds over $142 million at NCB.

• Analyzed and reconciled daily assets of 1 Billion NCB 401(K) and 11 Million NCB Pension.

• Calculated earnings allocations and resolved financial earnings problems and client communicated daily and attended monthly issues meetings at LZ.

• Managed and processed daily distributions and calculated Federal and State tax withholdings 1099Rs at CBIZ.

• Calculated investment trust fees and import/export data through Access and Excel software at NCB.

• Managed stock gifting received assets into account and adjust cost basis.

• Analyzed and calculated the financial data for 401(k) trust statements asset approximate 1 billion.

• Obtained and calculated financial data for the Summary Annual Reports various Retirement, Health, Pension Plans.

• Evaluated and calculated accounts payable for legal fees and miscellaneous fees at NCB.

• Managed the accounts receivable for loans repayments on OMNI Bus system at NCB.

• Prepared annual ERISA 5500 statements and quarterly and semi-annual statements at KEY Corp Bank.

• Managed and evaluated the contributions, loan repayments, loan defaults and asset transfers.

• Opening asset liquidations and closed accounts on computer systems.

• Maintained and communicated with external auditors in balancing, created audit checklist and research documentations for audit field testing at LZ.

• Analyzed the settled insurance premiums daily for investment trust at NCB. Administrative/Supervised

• Trained new employees on processed asset receipts, asset transfers, asset withdrawals at NCB.

• Trained new employee on financial spreadsheets for 401(k) plans.

• Trained new administrators and developed department procedures manual at NCB.

• Researched and balanced internal/external Auditor’s requests investment transactions.

• Communicated with internal and external clients, and investment brokers and health insurance plan administrator providers, Plan Sponsors, Directors, Managers, Finance Department, Key Bank investment brokers, ING Plan Investment Management, ING Plan Administration, Legal Department, Auditor Management and Auditor Attorney at LZ.

• Evaluated and updated legal Plan document folders for internal/external auditors at NCB. JOAN E. COLLINS, MBA Page 2

• Created various audit check lists for the qualified.

• Handled health plans requested for Auditors.

• Handled internal/external clients request for documentation research.

• Participated on conversion system testing team on investment accounts setup and closing.

• Processed 401(k) distributions, loan repayment, contributions on CSS system.

• Mailed Forms 8955-SSA various qualified and Health plans to IRS and Corporate Tax Manager.

• Maintained and updated legal documents for auditors and asset statements mapping at NCB.

• Processed pension in Excel and Pension Path system and attended clients’ meetings. Projects/Conversion Testing

• Project Management the pension ACH direct payments, and increased returned addresses by 70% to update SAP, Pension Path, Third-Party Administrators and Key Bank Trust Pension.

• Total Rewards project evaluated and test data verification.

• Employee statement communication project verification and mailing financial prospective.

• Payroll Department project annually verified pay tax codes, payroll amount.

• W2 verification project verified annual 401k totals.

• ADP EV5 system conversion verification and testing project.

• Trust 401K Statement project verified carry value amount at Key Bank.

• Investment asset transactions project verification balances for new Key Bank trust system.

• OMNI system project conversion testing financial asset data converted correctly at NCB.

• Financial system project conversion opened and closed trust accounts.

• Liquidated investment assets and participated in converting the system testing and WEB testing at NCB.

10/06 - 11/07 Associate Client Administrator NATIONAL CITY BANK

(acquired by PNC Bank)

11/99 – 9/06 Fulfillment Analyst II Allegiant Institutional Services 5/99 – 11/99 Account Associate II Cleveland, OH

10/98 – 4/99 Plan Analyst THE BENEFIT GROUP/CBIZ

Cleveland, OH

11/92 - 10/98 Account Analyst KEY CORP BANK

EDUCATION

Cleveland State University, graduate level accounting courses, Cleveland., OH Keller Graduate School, Becker CPA Review 2015-2016 American Public University, Master Business Administration - Accounting, Charles Town, WV Universal Accounting Center, Professional Bookkeeping-Business Certificate, Salt Lake City, Myers University, Professional Accountant Certificate, Cleveland, Ohio Bachelor of Science - Business Management, David Myers University), Cleveland, Ohio Kent State University, Associate of Science - Computer Management, Kent, Ohio

Contact this candidate