Sandra Umensetter
Davisville, WV 26142
EXPERIENCE Senior Accountant
Mountain State Blue Cross Blue Shield, Parkersburg, West
Virginia
March 17, 2008 to present
- Analyze enrollment reports from BCBSA and report results
to management.
- Produce pension reports on Excel worksheets for senior
management.
- Generate and file quarterly variance reports to
BCBSA.
- Generate ITS reports including ITS fees, ITS savings, and
ITS home and distribute to senior management.
- Responsible for creating yearly financial statements
for the MSBCBS Employees' Retirement Savings Plan and
Highmark West Virginia Inc. Retiree Welfare Benefit Plan.
- Responsible for preparing and filing 5500 reports for
Plan 522 Retiree Health and Welfare, Plan 521 Bargaining Unit
Health, Plan 520 Non Bargaining Unit Health, Plan 515
Employer Group Life, and Plan 525 Cafeteria Plan to ensure
compliance with government requirements.
- Generate Summary Annual Reports for Benefit Plans
using Relius Government Software.
- Efficiently schedule workflow to ensure that all tasks are
completed on time.
- Prepare and submit Veba reimbursement request to
Mellon Bank.
- Prepare and post journal entries using PeopleSoft; and
reconcile general ledger accounts using GL Recon Database.
- Accrue receivables for BlueCard admin fees and for
Medco rebates.
- Balance banking and 401k Trust Statements.
- Research host manual payments using Insinq, Highmark
Mainframe, Terradata and Cash Management System.
Accounting Supervisor
Union Trades Federal Credit Union, Parkersburg, West Virginia
July 2003 - March 2008
Special Projects
June 2009 to present
- Perform internal audits of accounting and banking
processes to ensure
compliance with federal and state regulations.
- Prepare annual budget, financial statements, and other
reports and analysis for the Board of Directors and
management.
- Compile asset liability management reports and graphs
using Cupro Software.
- Assisted in preparing the merger proposal for the merger
of O.Ames Credit Union with Union Trades Federal Credit
Union. Also, posted all general ledger entries needed for
the merger.
- Prepare and submit personal property tax and real estate
tax forms; analyzed for compliance with governmental
requirements.
- Conducted daily activities including: Paying invoices,
wiring funds, reconciling credit union bank accounts,
recording and posting investment income.
- Responsible for Filing payroll taxes with IRS and state
agencies; Prepared and filed 5300 Call Report for National
Credit Union Association.
- Research and resolve accounting problems.
- Generated monthly depreciation and prepaid expense
schedules and post general ledger entries.
- Processed payroll using QuickBooks Software.
Accounting/Finance Assistant
West Virginia Credit Union League, Parkersburg, West Virginia
May 2001 to present
- Generate financial statements from Model Management.
- Format financial statements on Excel spreadsheets.
- Work with graphs in Excel and Lotus.
- Assist with forecasting financial information for other
credit unions.
- Input financial information into Lotus spreadsheets.
- Assist with financial ratio analysis.
EDUCATION West Virginia University at Parkersburg, Parkersburg WV
Major: Business Administration with specialization in
Accounting
Graduated May 17, 2003 Cumulative GPA 3.38
Parkersburg High School, Parkersburg West Virginia
Courses in accounting and secretarial skills
Graduated 1986
SKILLS AND
CAPABILITIES - Competent in typing, editing and proofreading
reports
- Ability to work independently as well as with a team.
- Ability to use fax machine, copier and postage machine.
- Experience in personal computer use, including the following
Software: Microsoft Word, Excel, PowerPoint, Access and
QuickBooks.
- Proficient in computerized accounting, including accounts
receivable, prepaid accounts, accounts payable and payroll.
- Ability to perform office tasks and interact effectively
using written and oral communication skills.
- Experienced with IRA's, obtained an IRA certification at the
associate level from Cuna Mutual Group.
- Notary Public
ACTIVITIES - Treasurer of the Board of Directors for Union Trades FCU.
- Member of the Pioneer City Riding Club.
- Enjoy hiking, gardening, and horseback riding.