WILLIAM CHENG

Irvine, CA ***** 714-***-****

adngrn@r.postjobfree.com

FINANCIAL ACCOUNTING SOLUTION PROFESSIONAL

Accomplished in financial report, accounting (General Ledger/Accounts Receivable/Accounts Payable/Purchasing, Budget), Bookkeeping, Tax and budgeting knowledge and experience of day-to-day accounting operations, support and management using various financial and accounting software, such as PeopleSoft, SAP, Hyperion, MS Excel/Power Query, QuickBooks and ProSeries

PROFESSIONAL EXPERIENCE

Independent Financial Solution Consultant

WA CONSULTING CORP, IRVINE, CA 2016-CURRENT

Compiled annual financial statements including balance sheets and income statements for corporate clients

Administered corporate clients in preparing investments/assets portfolios for tax filings

Managed bookkeeping, bank reconciliations, final journal adjustment entries and tax filings using ProSeries for both individual and corporation.

Assisted accountant in designing individual corporate and personal chart accounts for manual Excel transaction entry and QuickBook registry entry.

Developed QuickBooks business financial analysis report, online banking transactions and check register import, and bank reconciliation, external client check register entry form, and ProSeries tax line mapping import process.

Assisted corporate clients in QuickBooks (cash and accrual) Chart Accounts, Accounts Payable and Accounts Receivable setup, and configurations

Administered Billing and Invoicing for an Online Store using Amazon, Shopify/Unify (QuickBooks plug-ins), Compusource, and CommerceHub

Senior Financial Solution Engineer

ALLIANZ GLOBAL, NOVATO, CA 2007-2016

Provided day-to-day functional support to financial/accounting and controller departments in administrations of Human Resource, General Ledger, Accounts Payable and Purchasing and Budget using PeopleSoft, SAP, Hyperion and Excel VB, which includes maintaining accuracy of book keeping and the integrality of financial and operational accounting data across different internal insurance financial entities and external partners

Developed and maintained annual/quarterly Hyperion Budget processes, and cross-platform integrations with PeopleSoft and SAP General Ledger, using MS SQL and EXCEL/VB

Created and maintained corporate quarterly and annual budget reports (GAAP, IFRA)

Managed viable financial data integration processes throughout corporation.

Developed and administered SAP General Ledger data archive processes using SAP archiving tools in according with the government mandate.

Participated in various corporate financial software functional upgrades, such as Hyperion, SAP, Peoplesoft, Time and Attendance upgrade project.

Senior Financial Solution Engineer

IBM GLOBAL FINANCIAL SERVICE, NEW YORK, NY 2004-2007

Planned and scoped PeopleSoft General Ledger, Accounts Payable and eProcument/Direct Connect upgrade plan by providing technical and functional gap analysis results, software and hardware requirements, resources allocations, and budgeting information to the executive body.

Provided day-to-day technical/function support and financial data analysis for PeopleSoft GL/AP/ePro/HR running on Windows and UNIX/IBM DB2 servers and developed/maintained cross-platform integrations with IBM mainframe legacy and third-party vendor systems.

Worked closely with controller for General Ledger/Budgeting chart fields mapping with SAP.

Developed/maintained annual Hyperion/Essbase financial budget planning processes, and cross-platform integrations with PeopleSoft Accounts Payable and SAP General Ledger and worked on Hyperion 4x upgrade project.

EDUCATION

Master of Art, Computer Science University of Detroit Mercy, Detroit, MI

Bachelor of Science, Computer Science Chung-Yung Christian University, Chung-Yung, Taiwan

Accounting I & II – Online Self-Pace Training

ADDITIONAL SKILLS

PeopleSoft SAP Hyperion MS Office Excel/Word/PowerPoint QuickBooks PS/ORQCLE SQL

ProSeries Tax UNIX Excel VBA JAVA Photoshop HTML/CSS XML PHP WordPress

Contact this candidate