ZULQARNAIN SHAH, Accounts Executive / Administrator / PRO

ZULQARNAIN SHAH

Accounts Executive / Administrator / PRO

Al Arraf Hotel (Group of Hotels & Restaurants)

Location
United Arab Emirates - Dubai
Education
Bachelor's degree, Accounts & Finance
Experience
16 years, 10 Months

Share My Profile

Block User


Work Experience

Total years of experience :16 years, 10 Months

Accounts Executive / Administrator / PRO at Al Arraf Hotel (Group of Hotels & Restaurants)
  • United Arab Emirates - Dubai
  • My current job since January 2011

Finance
1) Negotiated and arranged the banking facilities to cover/manage growing company-working capital/project finance requirements.
2) Improved the company cash flow situation with aggressive and methodical approach towards accounts receivables and payables
3) Prepare cash flow, fund flow, profit & loss account, budgeted balance sheet, budgeted cash flow, balance sheet etc for sanction, renew of credit facility and management purpose
4) LC opening, temporary overdraft and settlement of the same on maturity date
5) Calculating existing outside liabilities and make necessary arrangement of funds for liquidating the same.

Financial Accounting
1) Preparation of cashbook, bankbook, ledger accounts & finalization of books of accounts.
2) Preparing vouchers, debit & credit note, schedule of sundry debtors & creditors.
3) Preparing monthly bank reconciliation statement and collect confirmation from bank periodically.
4) Update books of accounts and conduct internal audit for finding accuracy of books of accounts.
5) Negotiation with branches and consolidation of books of accounts.
6) Handled contract accounts of clients & sub-contractors; managed credit control function.
7) Developed, Implemented Accounting systems, procedures in accordance with international accounting standards
8) Valuation of fixed assets & calculation of depreciation.

Inventory Management
1) Standard product coding according to nature of product and supplier basis
2) Periodical stock taking for controlling loss of stocks.
3) Preparing stock inward & outward register and fixing level of stocks.
4) Valuation of closing stock for finalization purpose.
5) Calculating re order level of stock on the basis of movements and requirement

Reports
1) Prepared Trial Balance, Profit and loss account, Balance sheet etc
2) Prepared various budget and submitted to management and bank for final approval
3) Prepared ageing schedule of debtors & creditors and clearing auditor queries
4) Reporting to customers regarding overdue receivable and realization of outstanding bill
5) Providing the information and data required to the management.

Auditing
1) Handled the finalization of accounts of the company in coordination with auditors
2) Conducting Inventory audit and physical stock taking for finalization and management purpose.

Office Administration
1) Member of Executive committee for profit planning and achieving the financial objectives of the
company.
2) Make necessary arrangement of insurance for vehicle, stock, etc
3) All staff documentation & Renewals like visa, passport, Health cards, Labor ID & National ID, Tourism License, Dubai Municipality Documents, All annual maintenance agreements & contracts.

Accounts & Sales Coordinator at United King Foods (Pvt.) Ltd.
  • Pakistan - Karachi
  • July 2007 to December 2010

1) All coordination and correspondence with buyers/suppliers, inter department and overseas buyers.
2) Responding all enquiries on immediate basis and keep their record in system, and follow up the enquiries for requisition from sales outlets & other buyers.
3) Sales & sales return purchase & purchase return, scrape and other data entry on ERP data base, and oracle data base software as well as monthly sales record keeping on Microsoft excel.
4) Handling petty cash, T.R cash and T.R clearance.
5) Daily all over transaction, vouchers, goods receiving notes, time sheet & other documents send to head office with dispatch voucher & maintain dispatch book with receiver signature on dispatch voucher.
6) Advance Microsoft excel use conditional formula’s, pivot table, link, graph, data filtration system, sorting data and securing data use protection system for partially and whole sheet etc.
7) Double checking of the documents after preparation.
8) Coordination by e-mail, fax, and phone with all buyers and suppliers
9) Attendance record maintain on Microsoft excel by thumb scanning Act-tek machine data.
10) Preparing daily closing sheets of finished goods depart and maintain its record on Microsoft excel.
11) Preparing departmental production sheets with quantity of production to maintain standard of stock of finished goods depart and it’s record keeping on Microsoft excel.
12) Microsoft outlook using for email of daily correspondence of demand & supply.
13) Following shipments and shipping documentation (importer address, manufacturing date, expiry date & batch code of each product packing list & gate pass) by using Microsoft word & excel to record keeping.
14) After promotion my job is to daily production handling & checking demand & supply to achieve business target.

Education

Bachelor's degree, Accounts & Finance
  • at University of Karachi
  • January 2008

Specialties & Skills

Financial Accounting
Account Finalization
Office Administration
MIS Reporting
Inventory Management
Microsoft Office Advance Excel
Computerized Accounting

Languages

English
Expert
Arabic
Expert
Hindi
Expert

Training and Certifications

ERP & Oracle Data Base Software (Training)
Training Institute:
United King Pvt LTD
Date Attended:
July 2007
Duration:
96 hours
Peachtree Accounting (Certificate)
Date Attended:
March 2007
Valid Until:
May 2007
MIcrosoft Office (Certificate)
Date Attended:
April 2006
Valid Until:
May 2006
Tally Accounting ERP 9 (Certificate)
Date Attended:
October 2012
Valid Until:
December 2012

Hobbies

  • Gym, Cricket, Reading Newspaper, Listening Music