Human Resources Project

Sharon Hua

** ******** ******, ** *****

Cell: 714-***-****

Email:

********@*****.***

A results-driven, action-oriented professional with proven record of saving

90% of company's general accounting data processing time.

A self-motivated, team player with strong analytical and problem-solving

skills is looking for a stable company with a positive office environment.

SOFTWARE SKILLS:

Experience with QuickBooks and Peachtree accounting software. Advanced

computer skills including

MS Office, Excel Macro, Access, Transaction Pro Importer, Transact SQL,

DB2, COBOL, CICS, VSAM, and Visual Basic programming languages.

EMPLOYMENT:

Best Life and Health Insurance Company - Irvine, CA Feb. 2 - Mar. 4

2011

Temp Accountant

. Work with senior Accountants and CFO to prepare and file annual

premium tax return using Premium Pro software to calculate Life,

Health (vision, dental, medical) and retaliatory taxes for each state.

. Prepare and submit the annual statements that comply with all NAIC

regulatory requirements (e.g. annual statement state business page #24

and Schedule T) using BestESP system.

. Analyze annual Life, Accident and Health claim data and allocate G/L

balance variance using Excel Pivot Table.

. Perform bank reconciliation, maintain fixed assets depreciation,

prepaid expenses amortization schedules and intercompany billing.

.

Quest Capital Strategies, Inc - Lake Forest, CA Oct. 2005 -

Nov. 2010

Accountant

. Follow generally accepted accounting principles (GAAP) and company's

policy to perform a wide range of duties in direct support of the

monthly, quarterly and year-end financial close processes.

. Process average 30 invoices daily, 25 A/R daily and 400 A/P monthly.

. Administer all aspects of Human Resources tasks, such as payroll,

payroll taxes, 940/941 and EDD quarterly tax returns, W2 and 1099

yearly tax returns, and medical insurance benefit.

. Prepare broker commission summary report and paychecks for about 500

brokers nationwide on a bi-weekly basis.

. Prepare documentation and provide support for the annual audit.

. Develop Excel macros and ad hoc reports for applications to handle

high volume data.

. Evaluate and implement third party software (TPI) to import vendor

bill/credit entries from the company's proprietary systems into

QuickBooks. This project saved the commission data processing time

from 4 hours to 10 minutes.

. Coordinate with outside data providers to download raw data, use Excel

Macro to reformat and upload to an internal system. This project saved

90% of the data import time.

. Act as a liaison between application users and technical personnel.

Identify all system issues and perform system beta acceptance testing.

AmerisourceBergen Corporation - Orange, CA Nov. 1988 - Oct.

2005

Application System Specialist

Senior Programmer Analyst

EDP Auditor

. Key members to develop and implement mainframe modules and SQL server

Views and Stored Procedures for Web based application.

. Project/Technical lead to develop and implement Customer Reporting

systems.

. Primary member to enhance, maintain and support CICS based on-line and

Batch Customer Order Entry system.

. Project lead for Y2K renovations.

. Provide technical assistance and support for production problems.

. Participate in EDP audit of computer operations in each division

nationwide.

Sterling Software Dylakor Division - Chatsworth, CA Jan. 1984 - Nov.

1988

Programmer Analyst

. Develop and implement DYL utilities routine modules using Assembly and

Dbase programming languages.

. Provide production support and training for end users.

EDUCATION:

. MBA candidate in Accounting - University of Southern California - Los

Angeles, California

Completed 40 units out of 64 required units

. Computer Systems and Programming Diploma - Computer Learning Center -

Los Angeles, California

. BS in Accounting - Soochow University -Taipei, Taiwan

Contact this candidate