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