Posted by on August 07, 19102 at 07:05:04:

Muhammad Ajmal Chishti - Oracle8i DBA
( Ajman )

ajmal_chishti@hotmail.com
Mobile # 97150-5862911
( Permanent Address: 17 - C Shah Rukn-e-Alam Colony Multan, Pakistan. Tel: 92-61-563374 )

SUMMARY

" Over one and half year of extensive experience in Oracle RDBMS ( Oracle Database Administration ).
" In-depth experience in application/database tuning, environment setups, security, backup and restore procedures.
" Extensive knowledge of Database Application Design using RDBMS concepts. Knowledge of client-server application, developing product software which includes development of standard procedures and templates.
" Good communication skills coupled with good team spirit.
" OCP in Oracle 8i - ( DBA Track )

OBECTIVE

To acquire a position where in I can utilize my skills as a Oracle Database Professional to contribute in the growth of the organization as an energetic & responsible team member.

DATABASE ADMINSTRATION SKILLS

" Installation, maintenance and upgrades of Oracle RDBMS.
" Design, implementation and support of backup and recovery procedures.
" Support of multiple production, development and test environments.
" Security, audits and change-control practice, procedures and implementation.
" Performance tuning and maintenance.
" Creating and maintaining concurrent managers
" Defining, scheduling and maintaining concurrent processing.
" Managing Oracle Applications System Administration activities.
" Managing Oracle Applications Object Library activities.
" Customizing existing Forms and Reports.
" Importing data into Applications database from external subsystems.
" Exporting data between database to database.
" Database administration, backup and recovery and performance tuning.
" Installation of Oracle and their upgrades.
" Designing and planning of database, which involves deciding about logical storage structures and forecasting future expansions.
" Creating and managing Schema Objects/Security of Database.
" Security Administration by creating Users with appropriate ROLES and PRIVILEGES.
" Creating Stored Procedures, Functions and Database Triggers.
" De-fragmentation of database.
" SQL Net configurations.
" Optimizing the SGA and Shared Pool Size.
" Optimized INIT.ORA parameters to best utilize the new system's resources.
" Knowledge of Oracle Failsafe, Parallel Server implementation.

TECHNICAL SKILLS

Software & Languages
O/S - Windows NT 4, Windows for work Groups,
Windows 95/98/2000, DOS
Windows XP
- Unix
- Linux

Languages - Java, Visual C++, C++,
GWBASIC

RDBMS - Oracle 8i, Oracle 8, MS Access

RDBMS Tools - Forms 4.5, Report writer 2.5,
PL SQL 1.1, SQL PLUS, Oracle Enterprise
Manager

GUI - Dev/2000, Visual Basic (5.0/6.0)

ERP - Oracle Applications

Other Utilities - Lotus Notes, MS Word, MS Excel, MS Power
Point, Lotus 123

Hardware

HP - HP3000, HP9000

IBM - RS-6000/S70

ACCOMPLISHMENTS

" As a DBA in Jintex Readymade Garments Industry LLC Ajman UAE, set up the production environment, development and test environments for Oracle based applications. Responsible for database administration of these applications.

EDUCATION BACKGROUND

" Bachelor of Science in Information Technology, Preston University USA ( Ajman Campus 2002 )
" Bachelor in Commerce, Bahauddin Zakariya University Multan, Pakistan ( 1994 )

TECHINICAL BACKROUND

" Advance Diploma in Software Engineering ( ADSE ), Aptech Computer Education, Sharjah, UAE
" Oracle 8i Database Administration course instructed by Oracle University, Raffles Informatics Dubai, UAE ( Oracle Education Partner )
" Oracle 8i Certified Professional ( OCP ) DBA track , Oracle University

PROFESSIONAL EXPERIENCE

" Working in M/s. Jintex as Oracle8i Database Administrator & Developer , since Feb 2001

PROJECT DETAILS

Project#1
Title : Database Structure
Organization : JINTEX READYMADE GARMENTS INDUSTRY LLC. AJMAN ( U.A.E )
Team Size : 2
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 95/2000
Role : Creating & Maintenance of Database, Performance Tuning and planning Backup Strategy
Duration : October' 2001 to December' 2001

Project#2
Title : General Ledger System
Organization : JINTEX READYMADE GARMENTS INDUSTRY LLC. AJMAN ( U.A.E )
Team Size : 2
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 95/2000
Role : Development, Coding, Debugging, Testing and Implementation.
Duration : September' 2001 to December' 2001
Description
The system designed & developed to automate the process of Trial Balance , Profit & Loss A/C and Balance sheet of JINTEX. It has several enquiries to know the expenses details, income details, profit & loss A/c & MIS reports.

Project#3
Title : Journal Voucher System
Organization : JINTEX READYMADE GARMENTS INDUSTRY LLC. AJMAN ( U.A.E )
Team Size : 2
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 95/2000
Role : Development, Coding, Debugging, Testing and Implementation.
Duration : August' 2001 to December' 2001
Description
This system is designed & developed to maintain the general entries like assets depreciation monthly rents, monthly sponsorship fee, monthly industrial and trade license fees. It also provides the various enquiries to find out the monthly End, Daily Summary. All the enquiries have got the associated reports.

Project#4
Title : Purchase System
Organization : JINTEX READYMADE GARMENTS INDUSTRY LLC. AJMAN ( U.A.E )
Team Size : 2
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 95/2000
Role : Development, Coding, Debugging, Testing and Implementation.
Duration : July' 2001 to December' 2001
Description
This system is designed & developed to maintain the purchase of fabrics and garments accessories from Creditors . It also provides the various enquiries to find out the total Purchase, monthly End, Daily Summary. All the enquiries have got the associated reports.

Project#5
Title : Database Structure
Organization : Raffles Informatics Dubai, UAE ( Oracle Education Partner )
Team Size : 5
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 98/2000
Role : Creation & Maintenance of Database, Performance Tuning and Backup & recovery
Duration : June' 2001 to Novemberr' 2001

Project#6
Title : Sale System
Organization : JINTEX READYMADE GARMENTS INDUSTRY LLC. AJMAN ( U.A.E )
Team Size : 2
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 95/2000
Role : Development, Coding, Debugging, Testing and Implementation.
Duration : June' 2001 to December' 2001
Description
This system is designed & developed to maintain the sale of garments and its accessories to Customers/Debtors . It also provides the various enquiries to find out the total Sale, monthly End, Daily Summary. All the enquiries have got the associated reports.

Project#7
Title : Account Receivables
Organization : JINTEX READYMADE GARMENTS INDUSTRY LLC. AJMAN ( U.A.E )
Team Size : 2
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 95/2000
Role : Development, Coding, Debugging, Testing and Implementation.

Duration : May' 2001 to December' 2001
Description
This system is designed & developed to receive the money from the Debtors/Customers against whom JINTEX raises the invoices. The Debtors/Customers will pay the payment through Cheques, Bank Transfers and Direct Cash. It also provides the various enquiries to find out the O/S, Full, Credit Allocation, Ledger, Month End, Daily Summary. All the enquiries have got the associated reports.

Project#8
Title : Account Payables
Organization : JINTEX READYMADE GARMENTS INDUSTRY LLC. AJMAN ( U.A.E )
Team Size : 2
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 95/2000
Role : Development, Coding, Debugging, Testing and Implementation.
Duration : April' 2001 to December' 2001
Description
This system is designed & developed to automate the payments process of JINTEX. It involves payments to the creditors. This gets initiates by defining the creditors. It creates the payment invoice for the creditors. Based on the invoice the payment will be generated. It has several modes of payments. The creditors can be paid through bank transfers or cheques. The payments are classified into different into different types such as PDR ( Direct ), PBT ( Bank Transfer ). PPC ( Petty Cash ). It has several enquires to cater the payment flow to the creditors & MIS reports.

Project#9
Tile : Payroll System
Organization : JINTEX READYMADE GARMENTS INDUSTRY LLC. AJMAN ( U.A.E )
Team Size : 2
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 95/2000
Role : Development, Coding, Debugging, Testing and Implementation.
Duration : March' 2001 to December' 2001
Description
This system is designed & developed to automate the payments process of JINTEX . It involves calculation of employees over time and allowance and their payments . This get initiates by defining the employees ID No. It creates the payment advice for the employees. Based on the advice the payment will be generated. It has several enquires to cater the payment flow to the employees & MIS reports.

Project#10
Title : Inventory System
Organization : JINTEX READYMAD GARMENTS INDUSTRY LLC. AJMAN ( U.A.E )
Team Size : 2
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 95/2000
Role : Development, Coding, Debugging, Testing and Implementation.
Duration : February' 2001 to December' 2001
Description
This system is designed & developed to automate the inventory process of JINTEX. It involves incoming and outgoing garment , garment accessories and machines. It has several enquiries low order level of accessories & MIS reports.

Project#11
Title : Inventory System for Markets
Organization : Aptech Computer Education, Sharjah, UAE
Team Size : 5
Software Used : VISUAL C++, WINDOWS 98/2000
Role : Development, Coding, Debugging and Testing
Duration : July' 2000 to December' 2000

Project#12
Title : Inventory System for Markets
Organization : Aptech Computer Education, Sharjah, UAE
Team Size : 5
Software Used : ORACLE 8/8i, DEV/2K, WINDOWS 98/2000
Role : Development, Coding, Debugging and Testing .
Duration : January' 2000 to May' 2000
Description
This system is designed & developed to automate the inventory process for medium size market. It involves incoming and outgoing consumable foods & others items. It has several enquiries low order level of accessories & MIS reports.

Project#13
Title : Video Library
Organization : Aptech Computer Education, Sharjah, UAE
Team Size : 5
Software Used : VISUAL BASIC, MS-ACCESS, WINDOWS 95
Role : Development, Coding, Debugging and Testing .
Duration : June' 1999 to November' 1999
Description
This system is designed & developed to automate the records of incoming and outgoing video films. It has several enquiry functions & rental record.

Project#14
Title : Student Enroll System
Organization : Aptech Computer Education, Sharjah, UAE
Team Size : 3
Software Used : MS-ACCESS, WINDOWS 95
Role : Development, Coding, Debugging and Testing
Duration : January' 1999 to April' 1999

Personal Traits

Myself an enthusiastic and energetic individual strengthened to take up full responsibility of the task assigned and complete it with the quality expected within the target constraints.
Ability to work as a team member, co-operating and co-ordinating with the colleagues and reporting to the higher officials coupled with excellent communication and interpersonal skills.

Personal Profile

Father's Name : Dr. Nazir Ahmmed Chishti
Date of Birth : 11th March, 1976
Sex : Male
Marital Status : Single
Nationality : Pakistani
Passport No : E 343974
Date of Issue : July 22nd 1997
Date of Expiry : July 21st 2002
Place of Issue : Dubai

Spoken Languages : English, Urdu

Holding UAE Driving License

References

#1
Mr. Faiz Mustafa
Jintex R/m Garments Industry LLC
Tel: 06-7435870
Mob:5979984

#2
Mr. Samson
Aptech Institute Sharjah, UAE
Tel: 06-5551191

#3
Mr.Saqqaf
Raffles Informatics Dubai, UAE
Tel: 04-9517444
Mob: 7942374

#4
Mr.Raja
Aptech Institute Sharjah, UAE
Tel: 06-5551191

#5
Mr.Sankat
Raffles Informatics Dubai, UAE
Tel: 04-9517444

( Muhammad Ajmal Chishti )