Financial Analyst Audit Consultant

Rudy H. Sellan

**** **** ***. ********, ** ****0 626-***-****

WORK EXPERIENCE

Accountant Southern California Association of Governments (temporary position) May ‘24 – Jun ‘24

*Audit consultant invoices for completion, accuracy, compliance with contract terms, and obtain all necessary approvals

*Prepare spending summary and analysis reports of consultant invoices and process through booking of journal entries

Accountant Metropolitan Water District of Southern California (temporary position) Jul ‘21 – Jan ‘23

*Apply receipts to open invoices, create debit memos, re-apply posted receipts, and prepare journal entries

*Process Daily Cash/Investments/Adjustments Report through journal entries to record financial transactions

*Prepare monthly reconciliations of Reimbursements, Other Collections, Employee Cash Advancements, and Unclaimed Checks

*Research and provide information for external auditors

Accountant Stanley Pest Control (temporary position) Nov ’20 – Jul ‘21

*Reconcile General Ledger accounts for Fixed Assets, Prepaid Advertising, Inventories, Payroll, and Vendor/Customer accounts

Accountant Metropolitan Water District of Southern California (temporary position) Mar ’19 – Sep ‘20

*Process Daily Cash, Investments, and Adjustments Report through unposted journal entries to record the transactions

*Process check requests for progress payments of Escrow Contracts, and EFT payment requests for Electricity and Water Purchases

*Reconcile Perpetual Fuel Inventories of 13 satellite locations to allocate costs through unposted journal entries

*Prepare Electrical Energy Surcharge Tax Return, mail to CA Dept. of Tax Admin., and submit approved payment request to A/P dept.

*Research and journalize cost transfer requests through unposted journal entries

*Assist with the monthly billing of water sales

Financial Analyst Los Angeles Homeless Services Authority (temporary position) Apr ’18 – Mar ’19

*Analyze and reconcile contract transactions, enter correcting journal vouchers, and prepare cash requests for funding of operations

Accountant Torrid Inc. (temporary position) Mar ’17 - Aug ’17

*Register Torrid Inc. with 34 state taxation entities to enable online filing & payments, tax inquiries, and company status updates

*Address imbalances regarding nonpayment, underpayment, and overpayment of states sales taxes

*Investigate, analyze, and resolve issues of penalty assessments, interest charges, and other related fees levied against the company

Accountant Metropolitan Water District of Southern California (temporary position) Feb ’16 - Jul ’16

*Conduct audit of accounting internal controls for A/R, A/P, P/R, Journal entries, Bank Reconciliations, and Cash accounts

*Process Daily Cash, Investments, and Adjustments Report and ensure that it balances to Treasury Sympro Reports

*Prepare chargeback journal entries for Meals & Lodging, Telephone usage, and reprographics consumption to allocate costs

*Process check requests for progress payments of Escrow Contracts, and EFT payment requests for Electricity and Water Purchases

*Reconcile Perpetual Fuel Inventories of 13 satellite locations to allocate costs

*Research and journalize cost transfer requests

*Complete or assist with various special projects for Finance, Treasury, Legal, and Information Technology departments

Accountant QuinnCat (temporary position) Oct ’14 - Feb ’15

*Assist with sales and use tax project by conducting research and creating reports using pivot tables, v-look ups, filters, and formulas

*Analyze customers’ transactions from January 1, 2011 through December 31, 2014 and calculate all applicable taxes

Auditor University of Southern California (temporary position) Aug ’13 – Nov ’13

*Analyze outstanding tuitions reports, computer records, and source documents to reconcile and calculate accurate A/R balance

*Collection of over $750,000.00 from past due tuition fees dating back four years from July 1, 2009 through June 30, 2013

Staff Accountant City of Upland (temporary position) Jan ’13 – Mar ’13

*Prepare and key journal entries for gov’t funding and revenues collected from various taxes, licenses, utilities, & other services

*Prepare and key journal entries recording expenses for, purchases, contract payments, depreciation, and month end adjustments

*Collect data from all departments and perform various detailed calculations to assist with the preparation of the city budget

Staff Accountant City of Montebello (temporary position) Feb ’11 – Nov ’11, Mar ’12 –Aug ’12

*Reconcile bank statements backlog starting from July 1, 2010

*Complete update of municipality fees for all city businesses, licenses, property developments, public property usage, and functions

*Comply with requests from the state auditors concerning procurement of back-up documents and explanations of transactions

*Prepare journal entries for monthly property taxes collected

*Assist with the preparation of the Cities Financial Transactions Report for the State of California

Staff Accountant BP Clothing Oct ‘05 – Jul ‘10

*Compile and process Payroll data from ADP reports and post journal entries

*Prepare results from factored sales reports, non-factored in house sales, internet sales, sales discounts, returns, and enter into G/L

*Allocate prepaid rent amounts to all appropriate expense accounts

*Audit and verify miscellaneous in-house collections, code to appropriate accounts, and post to the G/L

*Verify and record bank deposits, funding from factor, intercompany transfers, bank fees, cleared checks, and wired payments

*Prepare and post journal entries for manual payroll checks, 401K deposits, lease fees, and interest income

*Reconcile 6 bank statements

*Analyze Chargebacks, Accounts Receivables, and Credit Memo reports, and write off delinquent amounts

*Calculate factored sales commissions, corporate royalties & advertisement expenses, vendor promotions entries and post to G/L

*Prepare and post journal entries for health insurance allocation, accrued vacation, and payroll accruals

*Implement and maintain fixed asset depreciation software and balance to the G/L

*Create Analyses of Accounts Receivables-Others, Accrued Expenses, Deposits, Employee Advances/Payback, Prepaid Accounts

*Provide detailed schedules of Accounting Fees, Bad Debt Expense, Freight Out, Legal Fees, Rent Expense, Repair & Maintenance,

Taxes & Licenses, Leases, Construction in Process

*Audit domestic and international expense reports to verify legitimacy and accuracy

*Complete various special projects for management of finance and other departments

Staff Accountant Lighting Technologies International Sep ’01-Dec ’04

*Audit general ledger accounts and reconcile with appropriate journal entries

*Create and maintain warranty report for defective items

*Full cycle A/P: Verify legitimacy of documents, obtain approvals, voucher, match invoice with P.O. & receiver, print checks

General Accountant Various Temporary Agencies in Los Angeles County, CA Feb ’98-Sep ‘01

*Audit Payroll records and calculate vacation/sick time balances

*Full cycle A/R: process sales billing, apply payments to open invoices, prepare bank deposits of daily receipts

*Collect on past due amounts

*Apply labor and materials used to calculate job costs

Inventory Manager Lilly Industries Feb ’97-Feb ‘98

*Process production batch tickets, investigate and correct inventory imbalances, and enter daily production of Finished Goods

*Prepare job costing and profit margin analysis report for management

*Assist with A/R collections, A/P matching, and Payroll processing

Accountant Gaylord Containers Jul ’93 – Sep ‘96

*Supervise Payroll, Billing, and Accounts Payables

*Calculate, audit, input, and distribute 3 daily production reports

*Consolidate management daily statistical analysis report

*Complete month-end closing for: R.M., W.I.P., and F.G. inventory valuation, and operating supplies consumption

*Assist controller with preparation of account reconciliations, journal entries, and financial statements

*Create manufacturing cost centers and rates analysis report and identify major product cost variances

*Prepare and transmit production, financial, and environmental reports to corporate headquarters and government agencies

*Complete various ad hoc reports and projects required by management

Bachelor of Science in Accounting

DeVry Institute of Technology, City of Industry, California

GPA 4.00

Proficient with: Excel, Oracle, MIP, Great Plains, MAS90, AS400, Platinum, Reflections, Harry Rhodes MIS, Access, QuickBooks

Bilingual English/Spanish

Contact this candidate