ELMER A. BACERRA
#**Duhat Street,Ipil Village BF Homes, Parañaque City, Philippines
Contact Number:093********/094********
Email add: *****************@*****.*** /******************@*****.***.**
Skype Id:kolotski_0819 / IMO#:7100-8898
Desired Position: Financial Analyst/Cost Analyst
CARRER OBJECTIVE
To develop my broad background in financial management and cost accounting along with decisive thinking skills in order to endow with the company the highest level of strategic services.
EDUCATIONAL BACKGROUND:
TERTIARY
Laguna College of Business and Arts
Burgos St. Calamba, City
Bachelor of Science in Accountancy
2006-2010
SECONDARY
Banate National High School
Banate,Iloilo City
2002-2006
PRIMARY
Banate Central Elementary School
Banate,Iloilo City
1997-2002
PERSONAL DATA:
Age 29 years old
Height 5’3”
Weight 78 kgs.
Gender Male
Birthday August 21, 1989
Birthplace Banate, Iloilo City
Nationality Filipino
Civil Status Single
Religion Roman Catholic
Language Spoken Filipino/English/Hiligaynon
COMPUTER SKILLS:
SAP-AP Catalyst ECC,SUNS System(Financial Recording),IEfastrak System,Vision Executive, Fixed Assets Tracker, Hermes(Inventory System),ERP (Enterprise Resource Planning, Advanced Excel Formulas)
AFFILIATION:
Member of Junior Philippine Institute of Accountants (JPIA)
Member National Federation of Junior Philippine Institute of Accountants (NFJPIA)
WORKING EXPERIENCE:
Raumai 18 Limited
PO Box 275, LAE 411
Papua New Guinea
23 January 2018-Present
Audit Manager:
Conduct a StockTake schedule on a quarterly based shop/warehouses/manufacturing and investigate the reason for short and over variances of items.
Checking and validating of check voucher for the supporting invoices before payment to supplier and posting and updating in books.
Preparing the daily banking’s for all shops sales and credit sales customers.
Posting and recording the AR for daily takings and updating the SOA per customers.
Preparing the Payroll cut-off per fortnight, validating the leave of absences based on supporting’s medicate certificate and Tax computation of employees.
Costing the Sundries category items and analyze the SRP if it’s competent with other competitors.
Daily checking and updates the price change items in all shops.
Monitors and summarized the Gift Vouchers per customers that we released and unredeemed voucher series in a weekly manner.
Monitor the accountable forms such as Official receipts, Cash Tally sheet and Delivery receipt for preparing the schedules when would be the ordering dates before stock would be depleted.
Filing the Insurance claims for the Insurer with company’s car incident, local’s employees and expatriate managers PO's medical check-ups.
Monitoring the Closed User Group (CUG) for the updates and transfer of user for proper charging of expense, securing all of the CUG lines were registered to network provider.
Checking the updates PO's in system against with the invoices if prices and item codes were captured correctly.
Summarized the Monthly Sales Report per shop performances compare last year report which factor contributes a big increased/decreased in overall sales.
Developed excel templates to automate the reports as continuous improvement to submit reports in a timely manner.
Global Restaurant Concepts, Inc.
7th Floor, W/Global bldg. 30th St, Corner 9th Ave
Fort Bonifacio Global City, Taguig
June15, 2016- December 29, 2016
General Accountant:
Maintains and controls the General Ledger accounts and business transactions of the organization
Manage the processing of cash receipts, recording of revenue and receivable and ensure that revenues and receivables are properly recorded in the system.
Monthly preparation of financial reports such like balance sheet, profit and loss statement, and Costing, bank reconciliation, and budget performance.
Maintains accounting controls by preparing and recommending policies and procedures.
Perform the processing of functional and benefits expense allocations, monthly accruals, amortization of prepaid expenses, update lapsing of fixed assets depreciation, and recording of adjusting and reclassification journal entries, if necessary.
Perform the processing and recording of accounts payable transactions and ensure that all invoices and staff reimbursements are paid accurately.
Review all entries in the system, and check all vouchers prepared by AP staff to ensure the correctness and completeness of the attachment.
Monitor all Accounts Payable and un-liquidated cash advances by employees and suppliers.
Supervise AP Staff and ensure that all documents are properly filled and organize.
Rebel Alliance Food Supply Inc.
2314 Don Chino Roces Ave,Exit
Magallanes,Makati City
March 23,2015-June 8,2016
Account Receivable Accountant
Review the Daily Sales Remittance per branches for the POS recordsversus actualdeposited in the bank for Cash & Credit Cardtransactions and submits the Summary of shortages and overages.
Entries all transactions of Daily Sales Remittance in ERP system for the Cash Clearing reconciliations.
Checking of Cash/Card deposits that shall be reflected in the Bank statement to ensure all transactions are deposited(Pop –Up Sales Event,Cinema Bundle Billing,etc).
Summarized and submit the daily Sales transactions per branches.
Assisting the Treasury Analyst for the Daily Cash Positioning by identifying the dailysales allocations per branches.
Perform daily sales reconciliations of ERP system versus with the POS sales captured per branches and compute the %COGS per item category.
Summarized the Product Mixed based on branches monthly Sales transactions to recognize the topmost saleable items.
Perform Month-End bank reconciliations.
Monthly Account Receivable Aging Reports.
Monthly Consolidation of Sales Report per branches and Output VAT Summary that basis of E-Sales Filing.
Assisting Head of Chefs for the Monthly Food Costing % and Gross Margin % for the Kitchen Menu Items
Month-End Inventory per branches and Variance Report Physical count versus with ERP records.
Initiates Excel Templates for Store level and Finance functions for efficiently timely submissions of reports
International Family Food Services,Inc.(Shakey’s Philippines)
AFP RSBS Industrial Park Km. 12
East Service Road C5 Junction
South Superhighway, Taguig City
July 9,2014-March 6,2015
Cost & Financial Analysis Officer
Job Description:
Review and Analysis for Trading Income(MMD)-Profit and Loss Statement.
Preparing Product-Mix Analyses to recommend new bundles which would primarily minimize food cost or increase gross profit
Calculate inventory value of all inventory items such as food both local & imported, non-food.Identify the non-moving, obsolete, & spoiled items.
Reviewing and updating the latest data on Theoretical Food Cost to establish the ideal/standard food cost of each product
Reviewing the monthly store’s Cost of Sales (COS), capturing and analyzing the variance or the difference between the Actual and the Theoretical Food Cost.
Prepare comparative analysis of standard costs vs. actual costs with justifications on the items with discrepancies or those with PO price variances
Provide accurate & complete standard cost & transfer prices of MMD items such as local & imported items.
Costing for the newly products/bulk order request by the guest and providing FoodCost % and Gross Profit %.
Creating newly recipe/bulk order request in the Recipe Management System as basis of Theoretical Food Cost
Mondelēz Philippines, Inc.(formerly Kraft Foods Philippines)
8378 Dr. A Santos Ave.ParañaqueCity,Philippines
December 19,2013-June 19,2014
http://www.mondelezinternational.com/
Finance-Inter Supply Chain
Job Description:
Monthly Volume Report Analyst for the Actual Period vs. with the Forecasted Volume
Responsible for maintaining the cost accounting system, analysis of manufacturing cost against company standards, gathering data on overhead, labor and other direct cost and maintenance of product standard cost.
Perform Inventory analysis and prepares schedules as required.
Monthly uploading of Inter Billing Rates(IBR) in SAP system
Extracting of cost in SAP system which basis of uploading of Raw Material and Finished Goods
Consolidating of monthly basis report for Fixed Manufacturing Expense(FME) per cost center, the over and under budget of each Dept’s.
Monthly closing reports submission for: Manhours of Manufacturing Plant,DVL,DVE and Purchase Order calculation
Linking of KPI’s for Manufacturing Plant in Scorecard as basis of review in per region.
Adhoc reports which give from time to time basis.
BOIE Drug Incorporated
6/F Sycamore Prime Building Cor. Buencamino Street, AlabangZapote Road, Muntinlupa City
October 22 2012-November 18,2013
http://www.boie.com.ph/
Senior Inventory Analyst
Job Description:
Analysis the top WH items based on the average sales level of all branches (3 months comparison level).
Analysis of the Top 1-1500 branches Items ranking according to Sales to normalized the Ideal Stocks that branches needed based on the demand of Items.
Monthly report for the Stock Transfer Slip (STS) for branches transactions/deliveries to summarize the Monthly Inventory Stocks transferred from Warehouse to record in our QuickBooks during month-end closing.
Weekly reports of items Qty. Sold per branches as basis of replenishment of Stocks in Warehouse Items only the top saleable items ranking (Top 1-1500) only.
Weekly Analysis for out of stock items (OS) reported by the respective branches as basis for replenishment to right sized the beginning Inventory based on the Ideal Stocks.
Weekly Monitoring for the Warehouse Out of Stocks Items as basis of reordering of Items to Supplier.
Monitoring of Monthly Consolidated Sales per branches as basis of Top WH items or basis of ranking for top Saleable Items according to Peso amount.
Adjustment of entries in system if deprepancies were determined by checker or branch pharmacist to record the corrected balance of items as stated in the Branch returned Slip(BRS).
FASTCARGO Logistics Corporation
FMW Bldg. Tierra Nueva Subd. 235 Alabang-Zapote Rd.
Muntinlupa City, Metro Manila
May 11,2010-October 25,2012
http://www.fastlogistics.com.ph/contact.html
Accounting Staff/Assistant
Job Description:
Prepare proper journal entries in the SUNS system to record the expenses & forwarded all approved vouchers to treasury for payment/s together with related transmittal
Prepare journal entries for ODA charges/POD sharing(all revenues streams)& mailing expenses(inhouse expenses)
Prepare monthly summary of advances for the truckers
Prepare journal entries of advances(GPS monthly fee) for the truckers
Handling HAS Destination charges(charging to branches)
Supplies monitoring(inventory in & inventory out).
Assets Management Staff
Complete monitoring of movement status for company’s fixed Assets.
Prepare monthly depreciation for Fixed Assets/Lapsing Schedule
Prepare reorder point for Accountable forms(utilization &leadtime process).
Ensure application of Asset Management internal control for proper documentation (Insurance policies,OR/CR,Assets tagging.
Encoding of ending balance for Warehouse Items during month-end closing to identify the level of stock in Warehouse Items that can be support for weekly replenishment for branches deliveries.
Reconciliation of Stock card for Warehouse Items versus with the Physical Count of Ending Qty. balance.
Compilation of documents both STS & DRR per branches deliveries and Warehouse transaction served as copy or future references
On the Job Training - NATIONAL LABOR RELATION COMMISSION (NLRC)
2nd floor Hectan Commercial Center, HalangCalamba, Laguna
.
SEMINAR ATTENDED:
LEGS- Labor Education for Graduating Students
March 5, 2010
Laguna College of Business and Arts
Calamba City, Laguna
7th JPIA Fair Celebrations
Topics:
“The Best Way to Prepare for the CPA Board Exam”
By: Dr. Nelson S. Abeleda
“The Updates on Accounting and Auditing Standards”
By: Ma. Jamillah S. Punay”
“The Response of Accounting Profession to Global Financial Crisis”
By: Nimpa M. Magnaye
August 14, 2009
Faith Asia Institute of Technology and Humanities
Tanauan City, Batangas
RCJPIA IV General Assembly
July 26, 2009
PamantasanngCabuyao,
Cabuyao, Laguna.
CHARACTER REFERENCES:
Ms.Rowena Trinidad
Accounting Manager
Rebel Alliance Food Supply Inc.
******.********@*************.**
Mobile #:092********
Ms.Cecilia M.Suba
Financial Planning Analysis Manager
International Family Food Services,Inc
******@************.**
Mobile #:092********
Ms. Loida L. Cardenas CPA, MBA
Dean-College of Accountancy
Laguna College of Business and Arts
Tel #:545-1968 local 119
I hereby certify that the information above is true and correct to the best of my knowledge and have been made in good faith.
ELMER A. BACERRA
Applicant