Finance & Accounting & Specialist & Database administrator
General Authority for Investment and Free zones (GAFI) -Suez Public free Zone
Total years of experience :17 years, 6 Months
Financial statement to clients, solving their financial problems.
Presentation the initiatives and reports to authorities and my superiors.
- Bookkeeping Ledger, registration (credit, debit and adjusting) Paper & computerized constraints.
- Oracle key user ERP system for accounts, training our members in department how to use oracle tabs such as (payable/receivables - receipts - voucher - for all fees ...) and solve any problem facing them as local help desk, take advice's and instructions from central help desk for applying it in our department.
- Database administrator & Create of the following databases by (MS Access):
- Guarantee Letter, official claims for annual renewal, discount, raise guarantee, cancel guarantee, comparing guarantee value and investment cost.
- Quarterly Rent, official quarterly claims, update rented areas like (increase areas, decrease areas and dates of submitting areas), computerized constraints.
- Annual Services Fees, official annual claims, updates investment costs and adding new activities, computerized constraints.
- GAFI Fees 1 % For Export & Import Products, official fees claims for export and import goods, fees statement, computerized constraints, daybook for constraints.
- Ensures Goods Fees (%0.1), grouping monthly fees, computerized constraints, daybook for constraints.
- Interest, official claims, computerized constraints, fees statement.
- Asset Insurance Policies, official claims for annual renewal, official claims to commitment with the law and submitting insurance Policies.
- Checks & Bank Reconciliation, divided checks to pay debts, computerized constraints, Bank Reconciliation, receivables statement.
- Budgets, registration submitting Budgets, calculate authority's fees.
Installing and upgrading the database server and application tools
Allocating system storage and planning future storage requirements for the database system
creating purchase order for products
creating manufacturing orders
Monitoring and optimizing production process
Contacting and follow up suppliers for material shipments
creating shipping and Sales orders for final products
Generating various reports by querying from database as per need.
Monitoring and optimizing the performance of the database
Planning for backup and recovery of database information
Maintaining archived data
Backing up and restoring databases
Contacting database vendor for technical support