ROGER CROISIER, CPA
Seattle, WA 98199
*************@*****.***
PROFILE
Analyst with a range of experience in Accounting & Analytics, Financial &
Managerial Reporting. Highly proficient in analyzing data and creating
customized reports with MS Access, Business Objects, and Excel.
. Financial Analysis
. GL Reconciliation
. Report Development
. Database Management
. Financial Reporting
. Data Analysis
. Management Reporting
. Data Mining
. Customer Service
PROFESSIONAL EXPERIENCE
Washington Mutual (now JP Morgan Chase): Senior Accounting Analyst
2007 to 2009
Utilized Business Objects and Access databases to create financial and
managerial reports of loan activity. Reviewed portfolio to classify loans
as accrual or nonaccrual. Tracked negative amortization for the
portfolio, prepared month end adjusting entries for loans in process and
system rejected loans. Reconciled loan servicing system balances to
general ledger and servicing system reports, investigating out of balance
variances; researched system errors to determine cause. Wrote Accounting
Plans and Desktop Procedures.
(Home Loans Analytics)
. Converted a monthly four day multi-spreadsheet process to a one day
database driven process that reviewed and classified over 400,000
loans with superior results and created needed documentation for audit
of the process.
. Created a database that reviewed loan characteristics and created
summary reports to categorize 1.2 million loans into Chase product
lines.
. Established a process to reconcile Held For Sale hedged portfolio to
the General Ledger, uncovering a billion dollar mapping discrepancy
that exposed the bank to significant risk.
. Assisted external auditors with a review of the portfolio that
determined the leading loan servicing system was erroneously
calculating fee amortization for a class of loans.
. Replaced a static Hyperion based report with a custom Business Objects
query that reduced preparation time by 90%.
Washington Mutual: Senior Accountant
2002 to 2007
Maintained MS Access database for Subprime loans, uploaded daily
originations, created accounting entries for wire transfers and cancelled
loans; prepared monthend adjusting entries and reports - provided
troubleshooting for out of balance origination journal entries. Researched
and validated Originations, Sales, and Loan Transfers; investigated
variances and made recommendations for improvements. Streamlined and
automated existing processes to enhance efficiency and facilitate more
detailed analysis. Wrote detailed procedures for Sarbanes-Oxley
compliance. (Home Loans Accounting)
. Created a loan level rollforward portfolio activity report that
resolved large gaps in activity, detecting transfers, repurchases,
cancelled loans and other previously unknown events.
. Streamlined a database upload process by creating macros to properly
format database uploads - reducing process time by 25%.
ADDITIONAL EXPERIENCE
Washington Mutual Bank: Financial Analyst II/III
Washington Mutual Bank: Foreclosure-Bankruptcy Specialist.
Washington Mutual Bank: Mortgage Loan Collector.
Sears Credit Department: Credit Card Collector.
H & R Block: Tax Return Reviewer for two tax seasons.
EDUCATION
Bachelor of Science, Accounting / Finance, Central Washington University.
Bachelor of Arts, Economics / Political Science, University of Washington.
Completed employer sponsored classes in:
. Operational Excellence
. Ethics
. Risk Management
. Yearly FASB Updates
. Workplace Diversity
. Fair Lending Standards
. Business Segments
. Funds Transfer Pricing
. Financial Derivatives
AFFILIATIONS
Washington State Society of Certified Public Accountants.
Association for Financial Professionals - pursuing Certified Treasury
Professional designation.
Institute of Management Accountants.
COMPUTER SKILLS
Proficient with Access, Excel, and Business Objects. Experience also
includes Hyperion Essbase, SQL, and numerous Banking software applications.