JUVY APOLINARIO

PROFILE

Has knowledge and with strong background in the following:

SAP business system, Sales and Inventory Tracking System (SAINTS), Material Management Module (MM), Sales and Distribution (SD), Finance Module (FI), PPC Loading and Deactivation on PO Module (Oracle),

Executive Information System (EIS).

Customer Solutions Platform (CSP).

Computer educated especially on Windows Applications (Word/Excel/Power point).

With basic scripting skill on Audit

Command Language (ACL).

CONTACT

PHONE:

094******** /

097********

EMAIL:

adpctc@r.postjobfree.com

adpctc@r.postjobfree.com

PROFESSIONAL EXPERIENCE

Smart Communications Inc.

August 2001 – December 2019

Senior Officer/Financial Analyst III

June 2016 to December 2019

Analyze and summarize nationwide inventory for management report

Checking of inventory analysis done by teammates nationwide as a team leader

Monthly preparation of SAP vs CSP data from ACL script for analyzation of group per store

Prepare summary reconciliation of inventory on assigned stores

Check and Analyze inventory of retail store if properly recorded in SAP

Investigate variance encountered and coordinate concerned group for proper adjustment

Coordination with retail store on inventory movements in CSP

Making sure of preparing and sending memo variance to store for adjustment

Perform delivery variance adjustment in CSP upon request

Attend inventory related concerns of stores and other group

Perform physical count of inventories on retail stores and warehouse

Prepare SOX testing on inventories as part of group’s task

Senior Operations Support Officer

October 2012 to June 2016

Prepare Inventory Variance Report of assigned Retail Stores (RS)

Compare and analyze inventory of RS if tallied with SAP

Adjust any discrepancies on inventory

Analyze and prepare RS replenishment on their SARI (eload) and U2 transactions

Monthly reports of SARI and U2 transaction making sure funds are intact

Tagging of replenishment in CSP and ensures tallied with SAP

Reclassification of RS stocks to CSP and SAP

Approved serial adjustments and delivery variance adjustment of RS

Attend other problems encountered by RS

Compare and analyze inventory per serials and adjust the correct status

Regional Accountant

September 2010 to October 2012

Analyze inventory stock movements of Retail Store

Prepare month end inventory variance report and stock movements

Make sure that the sales and collections of RS are encoded and correct

Attend all retail store’s concern and queries

Replenishment for Sari and U2 balances of RS

Analyze GL accounts and reclassification to proper accounts

Commission checking and creation of AP voucher

Conduct yearly inventory of cash, funds and stocks of Retail Store

Sales Operations Accounting

August 2007 to September 2010

Analyze sales and receivables if properly recorded in SAP and in Bank deposit

Monitor and reconcile sales and collections of wireless center/branch (WC)

Coordinates to WC personnel for their concerns

Monitor and reconcile intercompany accounts (PLDT and PLDT Global)

Analyze and reconcile output vat payable

Process daily sales operations like confirmation of payment and AR approval

Checking computations, recording of entries and preparation of voucher for commissions paid to sales agents.

Analyze commission given to sales personnel as part of expense

Preparation of Sales Order for replenishment of U2, CSO and loyalty replenishment and SO blocking.

Blocking of sales order on cancelled transactions

Uploading of top up cards releases to all dealers

Preparation and collecting documents needed in Sarbanes and Oxely (SARBOX/SOX)

Marketing Accounting

June 2004 to August 2007

Process Account Payables Due to Marketing Supplier.

Prepare accounts payable voucher for check preparation

Reconcile accounts with supplier on all matters.

Create internal order for Marketing Budget

Analyze Marketing Budget and their expenses and see to it they will not exceed.

Coordinate with marketing people on their budget and expenses

Comparing marketing expenses versus budget before budget approval.

Create and blocked asset code for fixed assets like satellite phones

Inventory Accounting

August 2001 to June 2004

Creation of monthly Cost of Sales analysis report and Allowance for Inventory obsolescence for Smart and Piltel.

Proper valuation and costing of Inventory stocks

Computation and adjustment of Inventory cost arising from forward and embedded derivatives.

Handles WC’s adjustments, reversal and process request and return of their stocks same with the allocation of Smart money cards in SAINTS

Checking and ensuring of GL account assignment of newly created material codes and extension in SAINTS for user’s guidance.

See to it that top up cards are loaded in Oracle PPC module before warehouse activation and deactivated before destruction.

Also deal with different departments concerning inventory related transactions such as Request for Non-Sales Stocks.

Handles the inter-company account Due To/From Smart and Piltel with relation to Inventory transfers.

Have the duty to post cash payments by Piltel to Smart.

Responsible in monitoring Marketing Cooperative and it respective cash entries.

See to it that Materials Management conversion clearing General Ledger account is always balance.

Process requests of Wireless Centers and its necessary adjustments on stocks.

Isuzu Manila Inc.

Bookkeeper II

June1997 to August 2001

Work Description:

Handles Sales and Cash receipts.

Monitors Vehicle, parts and accessories inventory.

Reconcile accounts with Suppliers.

Analyze Accounts Payables and Receivables.

Reconcile Purchases and Sales.

Have the duty to prepare Statement of Account to clients and collect Receivables from them.

Kenstar Travel Corp.

Refunds In-Charge

Jan. 1996 to June 1997

Work Description:

Monitor refunds receipts form Airlines.

Process receipts and monitor ticket for refund.

Monitor and reconcile payables to foreign agents.

Follow-up Airline Credit Memo/Airline Debit Memo from different airlines.

Handles Petty Cash Funds.

SEMINARS

SAP Sales Distribution and Materials Management module training

Sales and Inventory Tracking System (SAINTS) training

Customer Solutions Platform (CSP) Training

Basic Scripting on Audit Command Language (ACL) training

Finance Strategic Planning 2004

Smart Caravan

Tax Academy

Accomplished Project - CSP Inventory Movement Dashboard (Project Emerald)

EDUCATION

Polytechnic University of the Philippines

Bachelor of Science in Accountancy

Sta. Mesa, Manila

1991-1995

Contact this candidate