Post Job Free
Sign in

Accounting Sales

Location:
Vernon Hills, IL, 60061
Posted:
April 02, 2010

Contact this candidate

Resume:

Bruce Tsai

E-MAIL: *******@*******.***

**** ********** ***, ****** *****, IL 60061

TEL: 847-***-****

CELL: 224-***-****

FAX: 847-***-****

CAREER SUMMARY

Solid financial and accounting and accounting aanalysis background,

combined with extensive experience in financial systems and relational

database applications. Self-motivated initiative taker with proven success

in process improvements that shortened the reporting cycle and increased

operation efficiency. Team player with excellent communication skills.

High flexibility in assuming new responsibilities and meeting strict

deadlines in a changing business environment.

PROFESSIONAL EXPERIENCE

Zurich North America, Schaumburg, IL

Reinsurance Accountant II (Accounting Supervisor)

2008-Present

. Analyze Reinsurance Ceded and Assumed Key Performance Indicators to

monitor recoverable, reserve, unearned premium, and premium payable

numbers.

. Create Recoverable Collection Score Card to track recoverable collection

efficiencyCompile Zurich North America Reinsurance Data for IFRS

reporting purpose.

. Conduct Reinsurance Business Unit Allocation Analysis for Pooling

Agreements.

. Manage Zurich North America Letters of Credit, Trust, Funds-s hHeld

activities by coordinating banks, reinsurers, business units, Legal

Departments to minimize credit risk.

. Conduct data interrogation and analysis, and data-set design using SAP,

Business Objects, Access for Reinsurance Accounting Department.

. Integrated Excel, Access, VBA to create Zurich North America's first

Recoverable Collection/Penalty Trend Analysis Model to simulate, analyze,

and present detailed/summarized recoverable data, which helped the

Reinsurance Collection Department to surpassed their 2009 goal by 50%.

. Significantly improved operation efficiency by automating Risk

Allocation, Allowance Allocation, Ceded and Assumed Recoverable Aging

Templates, and several other deliverables.

HSBC North America, Prospect Heights, IL

Senior Financial Analyst

2005-2007

. Created and utilized complex financial models to analyze and evaluate

consumer lending product pricing campaigns and scenarios.

. Developed segment/aggregate Return onf Equity (ROE), Internal Rate of

Return (IRR), Return on Investment (ROI) and Net Present Value (NPV)

metrics to assist product pricing analysis and campaign performance

evaluation.

. Compiled analysis reports and action recommendations to assist management

with strategic pricing and resource allocation decisions.

. Analyzed pricing data in pricing engines for possible pricing logic

discrepancies and errors.

. Coordinated Credit Risk, Marketing, Planning, Branch Operations, and

Financial Reporting/Planning departments to outline, validate, and

incorporate product pricing assumptions.

. Initiated and undertook Visual Basic for Application (VBA) projects to

automate the processing of pricing scenarios analyses and campaign

performance evaluations among hundreds of segments.

. Utilized mainframe Control Language, SAS and Oracle PL/SQL to retrieve

and analyze consumer lending products' data.

Senior Accountant

2004-2005

. Prepared and consolidated financial statements and other financial

reports for Special Purpose Companies (SPC) under Consumer Lending (CL)

and Mortgage Service (MS).

. Planned and recommended necessary accounting treatments regarding initial

deal setups and deal termination for SPCs.

. Worked with Treasury and Financial Planning Departments for the quarterly

and annual SPC budget and plan.

. Conducted variance analysis for delinquency and chargeoff trends

regarding possible loan sales and purchases. Monitored the loan size and

quality to be sure that all conditions weare in conformity with bond

sales and service agreements.

. Redesigned and modified Peoplesoft Nvision layout and Excel macros for

the Asset Securitization Group.

. Maintained and modified Securitization Accounting trees and accounts

under Peoplesoft GL.

. Created queries in Hyperion Essbase for financial statement

reconciliation.

Chicago Mutual Insurance Company, Chicago, IL

1998-2004

IT Manager/Senior Financial System Analyst/Senior Accountant/Staff

Accountant

. Analyzed operation bottlenecks and developed IT recommendations/solutions

to improve process efficiency.

. Coordinated design, implementation, testing, feedback, and modifications

of newly developed applications.

. Compiled reference manuals and technical documents for end users on newly

developed applications and important IT issues.

. Utilized IBM and MS query tools to audit premium, fee and expense data

integrity.

. Administered a MS SQL Server database for Chicago Mutual Insurance

Company's (CMIC) Online Information and Payment portal

. Created the first automatic agent commission report generation system

atin CMIC with an MS Access and IBM AS400 DB2 database that combined

activities from all lines of business into one statement.

. Created policy declaration pages and all other policy package documents

in a sorted manner with Crystal Report 8.5 and an IBM DB2 database.

. Prepared financial statements and other financial reports for CMIC and

Insurance Concept Enterprises.

. Prepared state statutory reports and audit supporting documents.

. Worked with senior management and independent actuariesy to develop

financial plans, forecasts, budgets and loss reserve rates for CMIC

within deadlines to fulfill regulatory requirements.

EDUCATION

University of Illinois, Chicago, IL

Master of Science in Accounting, major in Financial Accounting, 1998

Master of Business Administration, major in Finance, 1998

Tunghai University, Taichung, Taiwan

Bachelor of Art in Economics, 1992

SKILLS

. Proficient in using Visual Basic for Application to develop Excel and

Access macro

. Proficient in using relational database and report development software

to analyze and present data

. SAP F/I, Business Object, Peoplesoft General Ledger and Nvision,

Hyperion Essbase, SAS, Oracle SQL Plus, SQL Server, Excel, Access,

PowerPoint.

. Microsoft Certified Professional



Contact this candidate