Financial Analyst Sales
Resume:
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:
EMAIL:
**********@*****.***.**
**********@*****.***
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