Dec 2010 – Oct 2011
Clinica Medica San Miguel
Oversee the accounting of three business units: clinic; dental; spa; and salon & spa. Analyzed and reconciled multiple bank statements from Wells Fargo; credit cards and electronic checks statements from Cornerstone and American Express; general ledger accounts and prepared journal entries and post approved journal entry to Quickbooks. Reviewed balance sheets and income statements for proper accruals and adjustments for month end close. Prepared financial statements to file to DMHC and for management. Resolved problems and prevented utilities disconnection and got sales rep to release pending orders to stay in business. Researched and resolved issues with debt collectors by asking copy of contracts and proof of service and arranged payments; successfully renegotiated and discounted old payables for full payment. Prepare cash deposits when needed. Prepared and filed sales tax payable to the state and renewed business licenses for city and county. Calculated and paid commissions to contractors. Reviewed and recalculated time sheets and paid contracted health providers. Taught others how to use Excel.
Jul 2009 – Jul 2009
Analyzed and reconciled bank statements that were not reconciled for over a year to balance sheet cash balance, prepared journal entries; entered and post approved journal entry into MAS90: reviewed general ledger balance after posting; record and post bank deposits and cash transfers that were miscoded to other general ledger cash account; discussed with controller how to fix MAS90 bank reconciliation module to reflect actual cash balance on a daily basis. Software used: MAS90, Excel, Word, Outlook and Adobe Reader. Utilized Excel's Data functions especially data download of check register from MAS90 to Excel using special functions and VLook Ups to reconcile issued checks to bank statements.
San Miguel Healthplan,
Aug 2008 – Oct 2008
Analyzed and reconciled balance sheet and income statements and prepared journal entries; month end close; managed the accounts payable functions of trade and medical claims, acquired approval and entered new vendors to the vendor ledger; prepared cash deposits; reconcile bank activities daily; record and post bank deposits and transfers to cash account; prepared ad hoc reports to provide the information needed by the controller, CFO or COO's for immediate decisions. Software used: Quickbooks, Excel, Word, Outlook and Adobe Reader. Utilized Excel's Data functions especially VLook Up to reconcile medical claims from MS Access download to Quickbooks entries.
Oct 2007 – Mar 2008
Utilized excel advanced functions in reconciling general ledger accounts for revenue and cash activities. Converted bank statements saved in Adobe6.0 to excel. Audited merchant and customer credit cards analysis; audited bank reconciliation to bank statements and general ledger and prepared and post adjustments; reviewed and posted daily cash receipts and prepared bank deposits; reconcile credit cards sales to Authorized.net settlement report and prepared and post adjusting entry; reviewed and traced credit memos for cash or credit card refund or adjustment to customer account only; adjusted customer's account and refunded credit card thru Authorized.net; audited storage contracts and tied timing to earned and deferred revenue; assisted controller in providing by client (PBC) documents to external auditor. Software used Navision, AS400 Real World, Citrix/Authorized.net, Excel and Word; used scanner to copy customer checks and save to Adobe.Reader6.0. Taught others to convert Adobe reports to excel.
CB Richard Ellis, Inc,
Sep 2007 – Sep 2007
Filed multi state monthly, quarterly and yearly sales and use tax; filed multi city business license renewals, researched online and monitor communications with the taxing authorities in resolving tax issues to validate and process payments of annual secured and unsecured personal property tax bills on leased equipments and other business personal properties. CBRE recently acquired Trammel Crow Co. and I have to liaise with its tax consultant and other staffs in resolving unpaid tax issues and also in creating and organizing new files; acquired copies of lease agreements from lessor for support. Software used Peoplesoft, Excel and Word; scanned and saved property tax payments to Adobe6.0.
ECI, Inc, Torrance, CA
Feb 2007 – May 2007
Prepared analysis, audited, reconciled and updated 2006 general ledger for year end close, analyzed and created spreadsheet based on factored accounts receivable contract; reconciled cash, inter-company accounts, shareholder's account; generated financial statements and other ad hoc reports as needed and
compiled audit work papers. Trained senior accountant to maintain and update my created spreadsheets and accounts payable clerk to download AP aging using print to file and export command and to properly code invoices. Software used: MAS 200, Excel, Word and Access.
Adlink, LA, CA, Los Angeles, CA
Jan 2007 – Feb 2007
Assisted accounting team in closing the month and year end cycle. Reviewed accounts reconciliation and tie to the general ledger. Reviewed budget variances explanation. Reconciled 2006 ADP payroll register to the general ledger. Software used: MAS500, Excel and Word.
Storm Management, Inc,
Aug 2006 – Dec 2006
Assisted Tax Manager to compile schedule K-1 and suspended losses. Filed CA and out of state quarterly sales and use tax, secured and unsecured property tax return, business license tax returns, research, resolved, filed and requested waivers on penalty fees or a statement of Satisfaction of Judgment from the Tax Collector's office to file release of liens to the County Registrar-Recorder/County Clerk for the court to clear the accounts; reconciled payroll bank account and created excel audit work papers for audit. Software used: Great Plains, Excel and Word.
Feb 2006 – Aug 2006
Facilitated audit work papers. Prepared consolidated balance sheet, income statement and cash flow and other ad hoc reports and updated the notes to the financial statements.
Software used: Oracle, Excel and Word.
EDCO, Torrance, CA
Jan 2006 – Feb 2006
Cash account reconciliation and accounts receivable analysis and reconciliations, journal entries and month end close. Implemented use of Bankbook module. Filed sales and use tax for the last quarter. Company converted from Quickbooks to MACOLA in 2005. Wrote policies and procedures to utilize Macola software. Supervised one AR clerk. Trained new hired bookkeeper to update my created spreadsheets and Bankbook module to reconcile bank activities on a daily basis. Software used: Excel, Access and Macola.
Financial Analyst Asset Management
AIG Sun America, Century City, CA
Oct 2005 – Dec 2005
System conversion mapping analysis and reconciliation between Regional monthly operating reports and Integratec system reports.
Staff Auditor Martin & Coy
CPA's A Professional Corporation, Valencia, CA
May 2005 – Sep 2005
Senior Accountant Alternative Investments
AIG Sun America,
Jan 2005 – Apr 2005
Assisted Director in analysis of financial performance of 100+ investment funds, reconciled investment accounts to investor's statements of accounts. Performed administrative and secretarial functions when needed. Software used Excel and Word.
Financial Analyst Walt Disney Internet Group- Contract
Ryan Miller & Assoc,
Mar 2004 – Nov 2004
Assisted Finance Manager in consolidation of Walt Disney Internet Group business unit's 5-year Strategic Plan, 2005 Annual Operating Plan and current 2004 Forecasts and variance analysis. Devised new Excel templates for 2005 Forecasts using the new implemented SAP BW reports. Software used: SAP, Powerpoint, Excel and Word.
Mattel, Inc, El Segundo, CA
Oct 2003 – Jan 2004
Payroll (temporary project)
Projects management, project accounting for non-media to the general ledger, updating approved forecasts, Balance Sheet analysis and reconciliation for projects, adjusting journal entries for month end closing, devised spreadsheets for analysis and reconciliation, and special projects. Software used: Oracle, Cognos, Access, Excel, Word
Walt Disney Internet Group, Torrance, CA
Mar 2003 – Sep 2003
Balance Sheet analysis and reconciliation for Auctions, journal entries for month end closing, devised credit cards reconciliation worksheets, inventory analysis and reconciliation, and special projects. Trained financial analyst to update created credit cards reconciliation from general ledger to Paymentech statement and bank deposits and maintaining the inventory reconciliation using MS Access, Mozart, V-Lookup and Pivot tables. Software used: SAP, Mozart, AS400, Access, Excel, Word
Mattel Inc, El Segundo, CA
Aug 2002 – Feb 2003
Balance sheet analysis and reconciliation for international, manufacturing and export, journal entries for month end closing, special projects for Oracle conversion. Software used: JD Edwards, Legacy, Oracle, Hyperion, Excel, Word
Mattel Inc., El Segundo, CA
2003 – 2003
2003 workpapers to prepare 2004 Audit package, added or replaced audit programs, replaced 2003 data with 2004 information's, example: analytical types: preliminary, subsequent events, contribution and distribution. Updated bond requirements by DOL. Selected a sample of participants for contribution, census, distribution, and rollovers for audit testing using either haphazard, random or systematic system. Traced a sample of investments to BigChart.com for reasonableness. Traced a sample of participant's contributions and segregated employer match to determine deposit timeliness and if prohibited transactions occurred. Vouched workpapers data to source documents and tick marked data noting any exceptions. Performed other administration and secretarial functions necessary to complete the audit. Software used PPC, Excel, Word, Time & Billing, and GO.
General Accountant National Stores, Gardena, CA
Dec 2000 – Jul 2002
in month end closing. bank and credit cards reconciliation, journal entries, balance sheet and income statement analysis. Software used: Word, Excel and MAS90
Senior Accountant Orthalliance, Torrance, CA- (temporary project)
Updated and maintained 21 individual orthodontist's practices; 21 monthly working capital analysis, bank reconciliation; journal entries; special projects and problem resolution. Software used: Excel, Word, AMSI,
Senior Accountant Vivendi Universal Interactive Publishing Torrance, CA - (temporary project)
Performed special projects, analysis, credit card, and payroll taxes and payroll bank reconciliation against ADP confirmations. Created pictorial flow charts of procedures for all accrued liabilities, direct sales, payroll and its related payroll taxes general ledger accounts. Software used: Excel, Word, Oracle, E-mail.
Senior Accountant, Honda Federal Credit Union, Torrance, CA - (temporary project)
Performed special projects, analysis, reconciliation and compilation of certifications, asset liability and historical rates.