John Alfred Adrados CPA, Senior Accountant

John Alfred Adrados CPA

Senior Accountant

Excel Trading W.L.L (Excel International Group) – Doha, Qatar

Location
Qatar - Doha
Education
Bachelor's degree, Accountancy
Experience
15 years, 1 Months

Share My Profile

Block User


Work Experience

Total years of experience :15 years, 1 Months

Senior Accountant at Excel Trading W.L.L (Excel International Group) – Doha, Qatar
  • Qatar - Doha
  • My current job since March 2014

PURCHASING AND RELATED
 Prepares, issues and monitors LPOs and follow up any pending items.
 Posts vendor invoices and stock purchases into the system.
 Posts payments, adjustments and debit notes to vendor accounts.
 Handles and analyzes accounts payable reconciliation.
 Prepares and analyzes monthly vendor aging report.
 Prepares and updates payments master status report.

BILLING, RECEIVABLES AND COLLECTIONS
 Manages invoicing of customer LPOs in certain circumstances.
 Scrutinizes invoices, delivery notes and LPO attachment before approval.
 Prepares daily and monthly sales reports and analysis.
 Sends customer SOAs and presses up for collection of overdue bills.
 Posts credit notes and any adjustment to customer account.
 Handles customer account's reconciliation and resolves any customer query.
 Posts collections into the system and prepares daily collection report.
 Prepares sales reports on a salesman wise basis with sales rating.

CASH AND BANKING RELATED
 Facilitates bank transactions like wire transfers, cheque and cash deposits.
 Ensures bank, petty cash and cash accounts are all reconciled and up to date.
 Handles petty cash payments, replenishments and posting into the system.
 Prepares cash flow report to ensure company liquidity and payment priorities.

GENERAL ACCOUNTING AND REPORTING
 Manages month-end entries, accruals and adjustments for timely closing.
 Ensures general ledgers are reconciled with subsidiary ledgers.
 Handles system maintenance of all customers, suppliers and stocks master records.

STOCK AND COSTING RELATED
 Handles stock costing, pricing and analysis of all stock purchases.
 Manages internal stock transfers from store to showroom and vice versa.
 Prepares stock adjustments and analyses for any stock variation.
 Ensures all showroom display items are with a bar codes.
 Prepares physical count variation report and analyzes cause of such variations.

ADMIN AND AD HOCS TASKS
 Liaises and closely monitors clearing agents for all overseas shipments.
 Collaborates with Oracle vendor for system migration project from Tally ERP.
 Facilitates testing and implementation of Oracle based ERP accounting system.
 Ensures all system related query or issues are resolved in a timely manner.
 Facilitates systems integration of Oracle and bar coding system in Showroom.
 Manages tracking of all salesman via GPS system.

FInancial Accountant at AIG Philippines Insurance Inc.
  • Philippines
  • March 2010 to December 2013

FINANCIAL PLANNING AND ANALYSIS
 Collects analyzes data from profit and cost centers for budget preparation.
 Monitors execution of budget by comparing it against actual results.
 Ensures significant budget variations are analyzed and reported.
 Analyzes financial perfomance by comparing current actual results from prior

period results.
 Handles financial position analysis in relation to prior period.
 Prepares expense analysis and ensures significant variances are reported.
GENERAL AND FINANCIAL REPORTING
 Manages finalization and submission of financial statements of assigned units.
 Handles inter-company balance confirmation, reporting and analysis.
 Manages reparation and analysis of balance sheet reconciliation.
 Prepares and analyzes monthly branch performance report.
 Ensures timely submission of all local statutory and regulatory reports.
 Manages month-end entries, accruals and adjustments for timely closing.
 Liaises with the requirements of external and internal auditors.

Accounting Associate at Eastwest Banking Corporation
  • Philippines
  • February 2009 to March 2010

 Significantly reduced reconciling items for local bank deposits accounts including accounts with Central Bank of the Philippines and foreign bank deposits.
 Manages daily reconciliations of all local and foreign currency deposit accounts.

 Builds statements of accounts in easy to excel format from other banks’ raw text data.

 Recommends effective resolutions and procedures in posting of transaction details for easier referencing and better control to statement of accounts.

 Manages coordination with the booking units and monitors action plans for all the reconciling items identified that affect their departments.

Education

Bachelor's degree, Accountancy
  • at Central Luzon State University
  • April 2008

Scholarship recipient of Nueva Ecija Scholarship Development Foundation Inc

Specialties & Skills

Financial Reporting
Budgeting
Financial Analysis
Reconciliation
Microsoft Excel
Time and Project Management
Stress Management
Oracle Agile ERP
Tally ERP
QuickBooks
Advanced Excel
Microsoft Office Applications
Computer/IT Skills

Languages

Filipino
Expert
English
Expert

Memberships

Philippines Institute of Certified Public Accountants
  • Member
  • November 2008

Training and Certifications

CERTIFIED PUBLIC ACCOUNTANT (Certificate)
Date Attended:
November 2008
Valid Until:
December 2020