Ricardo Poblete

***** ******* **

Carson Ca *****

Phone# 310-***-****

Email: ad3q3i@r.postjobfree.com

Summary:

Finance professional offering experience in General Accounting, Sales, Cash Analysis, HR/Payroll, Sales Auditing, and Systems development and Data Analysis. Expert in excel spreadsheet, includes statistical reporting, journal entries, designing and developing new systems to improve productivity, accuracy, and cost savings for the company.

Computer skills:

MS Excel Expert, MS Word, MS PowerPoint, MS Windows, SAP, AS400, Lotus 123, PC Technical Support, Macros, JD Edwards, Citrix Spreadsheet Server, Crystal Report, Quick Books, Warehouse Management, Intuit.

Education:

Bachelor of Science in Accountancy

Far Eastern University, Manila Philippines

Associate of Arts in Business Accounting

South Bay College, Long Beach, CA

Associate of Arts in Electronic Engineering

ITT Technical, Carson, CA

Working Experience:

Wesltlake Financial Services - Los Angeles CA

Accountant II April 22 to Present

Prepare monthly task such as Month-end journal entries from 5 different companies.

Prepare Payroll journals and FX currency conversion journals.

Monthly bank reconciliations for 9 bank accounts including Canada.

Work with auditors for yearly audits.

Prepare the monthly comparative financial analysis reports.

Proficient in running queries in SQL

Reconcile Loans receivable against GL

Use advance MS excel spreadsheet using Pivot table, Vlookup, If statements.

Use MS Great Plain, MS Team, Outlook, OFFSLL, File-net, Dynamic Point.

Excellent communication skill, Detail oriented able to work beyond regular task

Weckerle Cosmetics USA, Inc. – Carson Ca April 17 to March22

Accountant

Prepare daily bank activities include daily bank recon, Incoming Wires from customers and credits, outgoing wires and checks for vendor payments and other debits transactions.

Journalized biweekly payrolls and perform weekly inventory cycle counts.

Prepare month-end close including Monthly Sales analysis, Monthly accruals include Payroll, Sick & Vacation accruals and expenses, Balance Sheet amortization, Inter company.

Prepare various monthly analysis report including Costing, Gross margin, picking list variance analysis, Scrap analysis report, KPI analysis.

Expert in MS Excel using advance formula such as Pivot table, Vlookup and Hlookup, IF and IFS statement, charts and Pivot charts, PMT Principal + interest functions,

and Micros. Downloading and compiling raw data from Trial Balance to Income Statement and Balance sheet.

Oversee A/R and A/P, preparing customer statements, and working with customers and vendors for collecting payments and cutting checks for Vendors, Banks Reconciliation and Sub-ledger accounts.

Prepare Monthly financial report including EBT, Income Statements and Balance Sheets, Fixed Asset, Head counts, Cash Flow.

Prepare monthly prepaid and Quarterly Sales and Use Tax. Rolling forecast.

Assist Auditors for year-end audits. Supervise annual physical Inventory and audits.

Use Microsoft Dynamic AX, Microsoft Office 365, MS excel spreadsheet and ARP Lucanet.

Participate in yearly budget preparations and sales forecast.

DENSO Products and Services, Inc. – (KORE 1 Staffing) Long Beach, CA Aug 16 to Apr 17

Business Planning Analyst

Product cost planning/estimating, cost and profit analysis, profitability management, and profit and loss statement. Prepare, generate, and analyse month income statements by Sales Channels, Product Lines, Divisions, and Sourcing.

Project management, Expert in Microsoft Office Excel, Other management tools such as MS word, PowerPoint, Stratum, AS400, JDE Edwards,

Prepare and maintain DOMO Dashboard for cost analysis presentation.

Responsibilities include performing cost analysis, Stock lift ROI calculation.

Participate in budget preparation (S&PD, RGA, COGS). Plan and coordinate product cost planning activities with the Product Management, Sales, and Supply Chain Management.

American Honda Motor Company Inc. – (Delta Computer Consulting Inc.) - Torrance CA May 15 to Oct 16

IT Metrics Analyst

Compile, analyse, and report on IT operational information related to processes within the HNA Information Security Office.

Perform regular data analysis interval metrics analysis of IT operational process base on the risk and provide report to management for SOX compliance. (APD -2 verification of access and APD-4 Termination and Removal of access)

Conduct regular and ongoing analysis of IT operational processes.

Report on analysis at various frequencies based on management direction.

Interface with other departments to collect data for analysis as required.

Assist the HNA information Security Office with reporting requirement.

Assist in KPI validation processes as required.

CareMore - (Kelly Services) - Cerritos, CA Dec 14 to April 15

Business Data Analyst

Responsible for analysing, reporting and developing recommendations on data related to multiple business metrics.

Creates and maintains databases to track business performance.

Analyses data and summarizes performance using summary statistical procedures.

Develops and analyses business performance reports (e.g. for Member service level data, transportation data, grievances data) and provides notations of performance deviations and anomalies.

Creates and publishes periodic reports, makes necessary recommendations, and develops ad hoc reports as needed.

AT&T - (TEKsystems) - Irvine, CA Nov 13 to Oct 14

Data Analyst

Member of the AT&T audit team responsible in tracking, reviewing and updating all milestone deliverables forecast & actualizing dates in CASPR and Master Tracker for Northern California Region.

Work with the SharePoint tracker on LTE project and utilizing SharePoint excel spreadsheet to keep track of all the civil work being done at the cell site locations.

Responsible in entering Contract and Noncontracted Materials in Norad and tracking down all materials being used in the projects.

Prepare Qbase Vs. Norad report for audit purpose, by Downloading Norad OOM reports and Vortex VWO data using Excel Spreadsheets Sumifs, If, VLOOKUP, Pivot table and other advance excel function to manipulate huge data compilation.

Prepare and analysis of AT&T PO funding report. Downloading data from Isupplier Oracle portal and Norad OOM New Grid report in spreadsheets to create an application that can able to match PO funding base on PTN, OOMID, Rev and Milestone and Pay points.

Prepare ROL (Release of Lien Waiver) documents for close out package upon request.

Prepare credit memo’s for sites that have been over funded or reduced after it was funded and paid.

Access FileNet for search of ROI and other supporting documents that need for COP.

Corpinfo - Los Angeles, CA

Senior Accountant Apr 12 to Nov 13

Using Microsoft Dynamic GP Professional 10.0 Financial, Sales and Purchasing module.

Ensure accurate and timely inventory receiving into the system as reported by various distribution centers and research discrepancies, if any.

Received and processed packing slips and update inventory warehousing tracking systems.

Perform physical inventory of computers on stock or on hand by serial numbers.

Review and analyse daily inventory adjustments and changes

Create inventory movements / adjustments as required.

Prepare and maintain vacation, sick, and personal time off schedule.

Perform Bank and GL reconciliation accounts and prepare supporting schedules

Prepare Commission report for salespersons base on cost of sales.

Prepare Quarterly sales tax schedule and monthly EFT tax form and Annual EEO-1 report.

Post journal entries and process month-end.

Vinculums - (TEKsystems)-Irvine, CA Oct 10 to Mar 12

Data Analyst

Downloading & uploading of AT&T CNR Data to ATT Mobility CNR Tool using MS Excel spreadsheet with heavy data manipulations, analysis, and report distribution to proper PM for resolution.

Using Pivot Table and V-lookup, I prepare ranking forecast for PM’s AT&T CNR T1 civil works and bring them to completion.

Using Sum IF and Sum IFS function to create a daily analysis of AT&T CNR data to CPM tool to make sure both systems are properly updated.

Process all CNR Civil follow up, Commitments, Civil resolved dates using Pivot Table and IF function.

Prepare a Statistical Progress Graph report to PM’s and Directors

Assist PM scheduling meetings, Web conference, and various statistical and analytical reports.

Designed and Prepare analytical spreadsheet to help the team identify problem in database.

Prepare data sanity check to spot potential problem in the tool.

Work with PM’s to manage AT&T CNR T1 to civil work complete and delivery to completion.

Daily analyses of AT&T CNR data to CPM tool to make sure both systems are properly updated.

Assist PM various statistical and analytical reports.

Centinela Pet FOOD Inc. - Torrance, CA May 09 to Oct 10

Senior Accountant / Payroll / Inside Sales

Prepared Sales Invoices, PO’s, SO’s, RVT’s, using Quick Books & Warehouse Management System.

Monitor the accuracy of all inventory levels by performing cycle counts / spot audits, and

resolves all errors as required.

Process received raw products, build materials, perform cost analysis and physical inventory

Setup new customer and Vendor accounts. Invoice customers and pay bills to vendors.

Prepare multiple bank reconciliation, Cash and Credit card reconciliation, AP check, Payroll checks, GL account, Inventory adjustments, Cash over/short report, Accrued and Prepaid acct.

Prepare daily sales reports, Payroll reports, 21 days rolling statistical analysis report.

Process payroll manual checks; enter vacation, sick time, bonus and other earnings and deductions adjustment using ADP and Payroll Smith system.

Connolly Pacific Co. - Long Beach, CA Apr 07 to Apr 09 Senior Accountant HR / Payroll Specialist

Timely processing of weekly payroll for union and non-union employee including:

Processing timecards. review hours and work orders, Job coding

Review checks and payments register using JD Edwards System

Print Payroll checks and processing ACH file to the bank.

Weekly filing of EFT taxes: Federal (FICA, PIT, FUTA) and State tax (SUTA, SDI, BOE)

Quarterly and Annually reporting of taxes: Federal (form 940 & 941, DE6 & DE7, BOE401a,531, EEO-1)

Month end closed Adjusting Entries, Job Cost, and Equipment Cost analysis.

Preparation of monthly benefits and workers compensation and statistic reports for the union (AGC Engineer, Carpenters, Mason, Labourer, Teamster, and Boatman).

401K analysis and true up, Employee benefit plan administrator, SSN Verification.

Process required paperwork on newly hired individuals and layoffs.

Prepare vacations, Pensions, Welfare analysis for union employees.

AQMD, MSHA, EEO, VET100 Reporting.

NBC Universal Studios (VACO) - Universal City, CA Jul 06 to Mar 07

Financial Analyst

Prepared month-end journal entries, Revenue, cost of goods sold, variable and fixed labor accruals using SAP GL and EC module.

Conduct Quarterly and Year End Physical Inventory for 15 retail stores including distribution center warehouse. Developed and designed automated count sheets.

Prepare and designed worksheet template for Sale report comparing Actual, Budget and Last year Sales.

Prepare project analysis to maintain expenditure base on propose budget.

Prepare MTD, QTD to YTD Royalties schedule and pushcart concessions.

Directv - (LEGENT) - El Segundo, CA

Financial Analyst Apr 06 to Jul 06

Create invoices using SMS system and verified Rates and number of subscriptions.

Create Manual Invoices for adjustments using MS Excel and upload JE to SAP system.

Create Analytical report to compare previous year to current and forecast the next five years sales base on network contracts and amendments.

MULTIQUIP INC - Carson, CA Jan 03 to Oct 05

Financial Analyst

Prepare month end journal entries, accruals, TB, IS, & BS with actual vs. budget vs. last year comparison with more than 100 accounts.

Prepare monthly tangible and intangible assets, pre-paid expenses, warranties amortization.

Prepared journal entries for payroll tax, 401k, and medical insurance premium allocation schedule.

Prepared monthly financial report including consolidation of all subsidiaries (BS, IS, Head Counts, Expense Analysis) comparing actual vs. budget vs. last year.

Participated in preparation of annual budget and forecasting.

Developed automated travel expense journals and other AP journals for SAP upload

Assisted tax accountant for annual sales tax preparation.

Developed several Excel spreadsheet macros currently in use for reducing entry time and automatically cross-referencing for errors.

DFS - North America - Torrance, CA Feb 89 to Oct 02

Cash Control Analyst (1989 - 2002)

Maintained accountability of approximately $800k in cash daily, foreign currency and credit card sales proceeds averaging $2M daily for over 100 stores nationwide.

Developed systems that automated the cash reconciliation process thereby improving accuracy and saving thousands of dollars in manual labor and supplies.

Designed a statistical and analytical worksheet that provides information from daily to year to date (YTD) flash sales reports for Board of Directors. This included budget forecasting and last year’s sales comparisons for three regions with sales of $1B.

Prepared and developed step-by-step PowerPoint presentations for managers in Singapore, Hawaii and San Francisco for the smooth transition of new work assignments.

Supervised staff of 10 with responsibility for Sales Auditing for over 100 stores within North America and Hawaii with sales averaging $1B annually.

Prepared daily cash over/short and foreign currency gain/loss summary reports.

Prepared month end cash receipts journal and journal vouchers entries using SAP system.

Created and designed cash receipts journals for over 100 existing stores and approximately 12 new outlets yearly.

Skill

Employer

Years' skill used per employer

Percentage of time skill used at each employer

U.S. Citizen

Yes

NA

NA

Advance Excel skills including pivot tables and V-lookups. Treat as one skill per employer

Weckerle Cosmetics,

DENSO Products and Services

3+ years

09+ months

60%,

20%,

Advance level analysing and compiling compensation data

SAP System

Weckerle Cosmetics

Universal Studio

DIRECTV

MULTIQUIP

03+

50%

Advance experience in payroll management and accounts receivable

CENTINELA PET FOOD INC,

Weckerle Cosmetics

01+

03+

20%,

50%

Excellent communication and problem-solving skills

Vinculums

02+

70%

Contact this candidate