Post Job Free
Sign in

Excellent: Data Entry, Microsoft Word, Outlook, Excel and Power Point

Location:
Wethersfield, CT, 06109
Posted:
June 18, 2010

Contact this candidate

Resume:

Patricia A. Mokrycki

*** ****** **** *****, ************, CT 06109

Cell: 860-***-**** Email: ********@*********.***

SUMMARY OF ACCOMPLISHMENTS

Maintain accounts payable and receivable data

Enter financial transactions into computer database

Publish monthly reports and reconcile financials

Prepare Year End Financial Report

Maintain and balance general ledger

Perform general office duties: Proof read documents, Maintain Spreadsheets, Filing, Faxing, Basic Reports, Sorting/Routing Mail and Internal Documents as well as Operating Fax Machines and Copiers.

SKILLS and ABILITIES

Strong analytical and problem solving skills

Excellent written and oral communication skills

Strong Proficiency with Excel, Microsoft Word and other computer desktop tools

Familiarity with Accounting Software such as Peachtree and QuickBooks.

PROFESSIONAL EXPERIENCE

12/09 – 04/10 CONVERGENZ (TRAVELERS), Hartford, CT

Business Insurance Analyst (contract position termed)

Load data from Travelers System to Excel.

Pull information from excel file to create reports using Macro’s, V-Look ups, Pivot tables and formula’s to combine and present data in excel format.

Assess, compile and merge data from multiple excel sheets in order to generate single master data list.

Identify gaps in spread sheet and contact analyst for additional info.

Extract data to excel file of input by analysts of counts for each specific duty performed using pivot table, macro’s and formula’s to track productivity of analyst.

Perform general office duties.

08/06 – 07/09 COMPUTER SCIENCE CORPORATION, East Hartford, CT

Accountant (lost position due to recession)

Complete Investment Accounting functions for small, middle and large clients with moderately complex securities.

Review Trade processing to core systems.

Variance research and analysis on Variable Annuities and Hedge Funds.

Cash and holding reconciliation to custodian bank and asset managers.

Produce Monthly, Quarterly and Year End Statements including analytical review, research and resolving discrepancies.

Daily NAV’s are received via fax and email. Email NAV’s must be printed.

Daily NAV’s are keyed into Win funds (Access).

NAV’s worksheet is printed, reviewed and approved.

Approval is given to Operations Department to produce and print Controls Report.

Controls are reviewed and approved by Accountant.

Fund Companies as well send files to Operations and Controls are produced and printed for Accountant to review and approve.

Any discrepancies that accounting must resolve need to be processed that evening.

At the conclusion of each evening email is sent to Accounting and other Departments notifying then of status for evening processes.

Assist with managing client relationships.

PATRICIA MOKRYCKI

(2)

02/05 – 03/06 PRIORITY ELECTRIC, INC, New Britain, CT

Bookkeeper (medical surgery)

Enter Billing data for taxable and non-taxable customers, print and send invoices.

Enter Accounts Payable and Receivable data into QuickBooks.

Pay Vendor and Monthly Bills.

Reconcile Accounts.

Monthly Bank Reconciliation.

Enter Payroll Data to QuickBooks.

Resolve any questions on insurance issues.

Maintain vendor Certificate of Insurance and W-9

Prepare Sales and Use Tax via paper and now automated on DRS website.

Verify accuracy computerized and manual record systems to perform audit.

Prepare reports as needed for employer.

09/04 – 12/04 HALLMARK TOTAL TECHNOLOGIES (STATE OF CONNECTICUT), Hartford, CT

Financial Analyst (temp position)

Reconcile accounts.

Prepare excel spreadsheets.

Enter banking transactions for different State departments into Core System.

Prepare Month end balance sheets.

Assist in Cash Management general office duties.

07/00 – 08/04 CENTRAL VALLEY INSURANCE ASSOCIATES, Windsor Locks, CT

Bookkeeper (left to care for terminally ill parent)

AP/AR/Bookkeeping

Manage financial reporting activities including preparation of monthly reconciliation.

Process commission payments.

Input daily accounts payable/receivable.

Reconcile accounts and monthly bank reconciliation

Prepare invoice/billing statements for clients.

Prepare weekly & monthly detailed financial activity analysis and reports for agent.

Ensure expenditures are in accordance with established budget.

Monitor and evaluate day-to-day controls.

Review and maintain accrual and prepaid accounts.

Perform general office duties.

EDUCATION

Bachelor Degree Central Connecticut State University, New Britain, CT

References Available Upon Request



Contact this candidate