Accounts Payable Management
Resume:
Derek Lum
S Bedford St, Apt #*
Los Angeles, CA *0035
*********@*****.***
Summary of Expertise
Bank / Brokerage/ Credit Card Statement Reconciliations
Cash Management
Preparation of Financial Statements
Preparation of Financial Statements
GL Account Maintenance and Audit
Budget and Variance Analysis
Balance Sheet and Fixed Assets
Individual /Corporate Income and Payroll Taxes
Month - End Close
1099/W-2 Form Preparation
Journal Entries
Audit Compilation and Review
Full Cycle AP/AR/Collections/Invoices
Payroll
Work Experience
Red Bull North America, Inc, Santa Monica, CA
8/2010-Present Accounts Payable Specialist for the East
Business Unit
. Perform Full Cycle AP (coding, batching, matching)
. Record Month End Journal Entries, adjustments, and accruals
. Resolve vendor payment issues and addressing urgent needs for Regional
and Headquarters' Managers/Directors by phone and email daily
. Support other AP Specialists with overflow
Sony Pictures Entertainment, Culver City, CA
4/2010-7/2010
Residuals Administrator (Temporary Consulting Position)
. Audited residual payments for actors, writers, and directors
. Constructed cast lists for TV shows and theatrical productions for
residual payment to actors, writers, directors, and musicians
. Manipulated Microsoft Excel and Visual Basic: debugged Macros and
utilized H &V-lookup and pivot tables
. Prepared adjustments, calculations, and research on cast lists based
claims and talent payee information
Wise and Healthy Aging, Santa Monica, CA
3/2010 - 4/2010
Accounting Analyst (Temporary Consulting Position)
. Executed 100-250 weekly accounts payable/account receivable invoices and
allocate to appropriate GL accounts utilizing Kintera Fundware
. Reconciled and allocated ADP payroll information to general ledger
accounts and produce financial bi-weekly payroll reports for CFO and
Board of Directors; monitor employee benefit allocations
. Maintained general ledger and prepared all account reconciliations for
internal monthly reporting
. Prepared journal entries, monthly status reports, and closings
. Maintained and developed external and internal audits, review all
financial documents, resolve any accounting discrepancies, and analysis
for monthly financial reporting on a timely basis
Gursey Schneider LLP, Los Angeles, CA
12/2008-1/2010
Accountant
. Prepared individual and corporate income tax returns (LLC and
LLP)/work papers
. Prepared Quarterly and Year-End state and federal payroll tax returns
and 1099 Forms for 50 clients
. Processed full cycle Accounts Payable, Accounts Receivable,
invoicing/collections processing, and registered yearly
business licenses for clients
. Maintained daily cash management activity and payroll for individual and
corporate accounts
. Prepared and entered month end close with standard, accrual, and
miscellaneous journal entries and reconciled general ledger accounts for
preparation of financial statements
. Provided general ledger and financial statements bi-weekly, monthly/
quarterly budget and forecast reports and analysis
. Performed bank/credit card/ mortgage/investment brokerage/vendors
statement, fixed assets management and intercompany reconciliations and
analyses on a monthly and quarterly basis
. Successfully streamlined clients' business procedures and financial
reporting methods through implementation with MS Excel and accounting
software
. Prepared monthly and annual budget report and variance analysis
. Created various spreadsheets with advanced Excel functions and formulas
. Used Excel pivot tables to develop new reports
. Reviewed and maintain general ledger accounts
. Executed month end/year-end close procedures and prepared depreciating
and fixed asset schedules
Capell Rudolph Business Management Services, Los Angeles, CA,
09/2007-10/2008
Assistant Bookkeeper
. Processed full cycle Accounts Payable, Accounts Receivable, and
Invoicing for 14 high net worth entertainment clients on a weekly basis
. Managed 51 Individual and corporate financial accounts including weekly
and quarterly financial reports
. Recorded and processed client payroll for bi-weekly, weekly, monthly,
and quarterly payment periods
. Executed weekly and monthly Cash Management for 5 clients
. Assisted in preparation of cash flow statements
. Used Microsoft Excel extensively to keep track of financial investment,
tax, and accounts' data through spreadsheet implementation
. Performed over 80 bank/investment brokerage statement reconciliations
for specified clients on a monthly basis
Education
University of California, Santa Barbara, 2007
University of California, Los Angeles Extension
Bachelors of Arts
Certificate in Accounting, In
Progress
Major: Asian American Studies GPA: 3.6
Courses: Principles of Accounting 1A and 1B,
Intermediate Accounting
Sitting for CPA exam in 2011
Computer Skills:
Datafaction/DFImaging/ Quickbooks / Peachtree Accounting Software, JD
Edwards, Microsoft Office - Office, PowerPoint, and Excel (including Macros
and Pivot Tables), Pro System Tax, Pensoft Payroll Software, CFS Payroll,
Kintera Fundware, SAP
Contact this candidate