Re: Looking for Oracle Analyst/Oracle DBA jobs in Dubai
|
Re: Looking for Oracle Analyst/Oracle DBA jobs in Dubai |
|
Posted by Masoom Khan Afridi on November 14, 19101 at 02:59:49:
In Reply to: Looking for IT jobs in Dubai posted by Sayed Akoury on August 29, 19101 at 15:22:03:
To :
The Human Resources Manager
Subject : Application for the Post of Analyst Programmer/Database Administrator.
Dear Sir,
At present I am working as a Analyst Programmer and a part of DBA team
in design, developing & implementing of Client-Server & Web based application
systems for our organisation using ORACLE with Developer/2000.
Well versed and competent in Oracle 7.3/8.0 RDBMS and its tools
(Developer/2000, Forms 6i & Reports 6i, Oracle Designer, Oracle Enterprise
Manager, SQL, PL/SQL, SQL*Loader, SQL*Plus and SQL Scripts).
I have passed out my Bachelor's degree (4 years) in Computer Science &
Engineering with 74.1% (First Class with Distinction) from Kuvempu University,
Karnataka, India.
I am looking forward for an opportunity in your esteemed organisation
wherein my skills & abilities can be fully utilized and enhanced. Herewith I
enclose my detailed RESUME for your kind perusal.
Awaiting for an early positive response.
Sincerely,
Masoom Khan Afidi
From :
Masoom Khan Afridi
#455, 1st Main 1st Cross
Gandhinagar
HARIHAR - 577601
Karnataka - State
INDIA
Tel : +91-8192-41661
Mob : 9844284107
-----------------
-: R E S U M E :-
-----------------
MASOOM KHAN AFRIDI
------------------
Summary :
----------
Over 3+ years of professional experience in IT Industry in the area of
Application Software Development including 2 years as a Junior Oracle DBA.
Current Expertise centers on the development of Web and Client-Server based
applications. Actively involved throughout the application software development
life cycle. Well versed and competent in Oracle(7.3 & 8) and its front-end
tools (Developer/2000, Forms & Reports 6i). Experienced in support and
management of Oracle databases. Strong analytical and design skill with in-
depth knowledge of design methodologies.
Education:
----------
Bachelor of Engineering in Computer Science (4 years) with 74.1% (Distinction).
KUVEMPU University, Karnataka, INDIA.
Technical Skill:
----------------
Databases : Oracle 7.x/8.0, Visual FoxPro, Dbase IV Plus, MS-Access.
DBA Tools : Oracle Enterprise Manager (Backup Manager, Data Manager,Instance
Manager, Schema Manager, Security Manager, Storage Manager, Oracle SQL
WorkSheet).
CASE Tools : Designer/2000.
GUI Tools : Developer/2000 Tool sets (Form Builder, Report Builder, Graphics
Builder, Project Builder, Procedure Builder, Query Builder, Schema Builder,
Translation Builder), Forms & Reports 6i.
Prog., Languages : C & C++, PL/SQL, Pro*C, SQL, SQL PLUS, FORTRAN, Shell
Scripting, PASCAL, COBOL.
Op., System : Windows NT/95/98, UNIX.
Assembly Language : 8085 & 8086 Microprocessors.
Hardware : COMPAQ Proliant DL360, Gateway ALR 8200.
Projects:
---------
Client : Al-Jazirah Corporation, Saudi Arabia.
-----------------------------------------------
Period From : Jun 2000 To : Till Date
Role : Analyst Programmer
Project: A Complete Integrated Accounting Package
This project is developed to provide a complete Accounting Package for
the organization. The Accounting package includes the subsystems like Account
Receivable, Account Payable and General Ledger.
It comprises various modules like Receipt Voucher, Payment Voucher, Financial
Transactions, Distributing, Adjustments on Invoices, Posting Customer
Transactions to GL, Customer Balances, Customer Account Statement, Adjustments
List, Cheques on Banks, Freezed Customer Accounts ETC.,
Responsibilities:
* As a Analyst Programmer I was involved with the Study, Design, Develop &
Implementing the various modules of the system.
* Extensively developed and utilized Stored Procedures, Functions and Packages.
* Progressively worked on database and Form Triggers to enhance the performance
of database security and efficiency, redundancy, concurrency and to impose
complex business rules.
* Participated in unit testing plan and system testing for the application.
* Wrote Program Units for the application development by using Oracle Procedure
Builder.
* The application had a modular structure for easy maintenance and upgrading.
Hardware : COMPAQ Proliant DL360, Gateway ALR 8200.
Operating System : Windows NT Ver 4.0
Development tools : Developer/2000 (Forms 5.0, Reports 3.0), Forms 6i, Reports
6i.
Languages : PL/SQL
Databases : ORACLE 8.0
-*-*-*-*-*-*-*-*-*-*-*-
Client : Al-Jazirah Corporation, Saudi Arabia.
-----------------------------------------------
Period From : Feb 2000 To : Jun 2000
Role : Analyst Programmer
Project: Human Resources Management System
The Human Resources Management System incorporates Personnel & Payroll
Modules to manage all employee data in the various branches spread throughout
the country. The various modules includes receiving and processing job
applications, appointments, salary transactions, allowances, deductions, leave
transactions, loan transactions, contract validation and maintenance, end of
service transactions and various other functions of the Personnel and Payroll
department.
Responsibilities:
* Extensively used Designer/2000 and Created tables with Primary and Foreign
Key relationships.
* Extensively developed and utilized Stored Procedures, Functions and Packages
* Progressively worked on database and Form Triggers to enhance the performance
of database security and efficiency, redundancy, concurrency and to impose
complex business rules
* Participated in unit testing plan and system testing for the application
* Wrote Program Units for the application development by using Oracle Procedure
Builder.
Hardware : COMPAQ Proliant DL360, Gateway ALR 8200.
Operating System : Windows NT Ver 4.0
Development tools : Developer/2000 (Forms 5.0, Reports 3.0), Forms 6i, Reports
6i.
Languages : PL/SQL
Databases : ORACLE 8.0
-*-*-*-*-*-*-*-*-*-*-*-
Client : Al-Jazirah Corporation, Saudi Arabia.
-----------------------------------------------
Period From : Sep 1999 To : Feb 2000
Role : Oracle Developer
Project: Advertisement, Subscription & Distribution System
This application is developed for the Advertisement, Subscriptions &
Distribution of the Organisations Daily Newspaper & Internet Users.
Advertisement System automates the process of advertising in a newspaper,
Including Order Entry, advertisement publication work flow, billing and
Invoicing of advertisements, handling of customer complaints, error detection
and responsibility for errors, track customer advertisements in rival
newspaper, scheduling for advertisement space sales staff, allow editorial
staff in managing advertisement space without any conflicts. There are
currently about 6 different advertisement types each with their own unique
characteristics.
Subscription System manages all information for Subscriptions and Subscribers.
By providing timely and accurate information the system guarantees Subscriber
satisfaction and Subscription follow up.
Distribution System is based on a division of sales information according to
regions and routes. It stores, analyzes, produces billing and invoices data. It
provides useful information to the management for sales analysis, marketing and
production planning.
Responsibilities:
* All the systems are developed keeping the end users requirement and ease of
use as the first priority.
* All the systems are modular in design and incorporate all object-based
features available in Developer/2000 Tools.
* The applications allow for easier modifications according to changing
business rules as nearly 90% of the validations are written as Database
Procedures, Triggers, or Implemented through PL/SQL Libraries.
* Participated in unit testing plan and system testing for the application.
* Also Involved in reports generation for the management purposes by using
Oracle Reports 3.0, SQL* Plus Reports, and reports through Discoverer 2000.
* Used Discoverer 2000 as Query Builder, Data Access and Reports Generator tool
also to formulate end user layers (EUL) for grouping the business areas for the
head office.
* Altered database, added more entities and attributes and developed
relationships with the existing database for the application development by
using SQL Navigator
* Oracle Navigator was used for DML and to alter the tables and to view indexes
and triggers
* Created own SQL* Menus in the application to facilitate the users to furnish
easy access in the application and provided user training and documentation to
the concerned staff.
Hardware : COMPAQ Proliant DL360, Gateway ALR 8200.
Operating System : Windows NT Ver 4.0
Development tools : Developer/2000 (Forms 5.0, Reports 3.0), Forms 6i, Reports
6i, Designer 2000 Two-Tier Client/Server environment.
Languages : PL/SQL,SQL
Databases : ORACLE 8.0
-*-*-*-*-*-*-*-*-*-*-*-
Client : Al-Jazirah Corporation, Saudi Arabia.
-----------------------------------------------
Period From : Sep 1999 To : Till Date
Role : Junior DBA
Project: Administrating the Production & Development Databases.
Responsibilities:
* Creation of Database, Instance, Table spaces, Rollback Segments, Users,
Privileges, Roles, Tables, Indexes, Stored Procedures & Functions, Packages,
Database Triggers.
* Creating/Populating data based on the application.
* Backup and Recovery procedures of Oracle Database through Export/Import
utilities.
* Managing table spaces, data files, archiving redo log files and control file.
* Monitoring load on the server, memory usage, disk space etc.,
* Trouble shooting the Software & Oracle Database related problems.
* Performance tuning of Database and Instance.
* Monitoring & Avoiding the Locks of the Resources.
* Oracle client software installation on the workstations.
-*-*-*-*-*-*-*-*-*-*-*-
Client : The Kirloskar Company Ltd., India.
--------------------------------------------
Period From : Mar 1999 To : Sep 1999
Role : Software Engineer
Project: Kirloskar Purchasing Plan System.
The system provides purchase planning, helps in evaluating quotations,
generates purchase return invoices, tracks product delivery and agreement
violation, it also manages international purchase transactions. The system
stores data about suppliers of various products their locations and their
ratings based on different criteria, based on this the system suggests
suppliers for required products on demand.
Responsibilities:
As a programmer in The Kirloskar Company Ltd., India. I was involved
with the study, design and modeling of the business requirement of the Material
Management department. The complete database for the inventory control system
was developed on oracle RDMS following full system development life cycle
methodology. Forms 4.5 and reports 2.5 of Developer 2000 suite were used for
the creation of database applications. Database and application triggers and
stored procedures were created and attached to the various modules to automate
all updating and special report generation. The application had a modular
structure for easy maintenance and upgrading.
Environment:
Operating System : Windows NT/98
Development tools : Developer/2000 (Forms 4.5, Reports 2.5).
Languages : PL/SQL, C.
Databases : ORACLE 7.3
-*-*-*-*-*-*-*-*-*-*-*-
Client : The Kirloskar Company Ltd., India.
--------------------------------------------
Period From : Sep 1998 To : Mar 1999
Role : Software Engineer
Project: Kirloskar Security System.
Security is managed through the use of Oracle Roles and account
validation is done through the database. Application user management is made
easy by developing simple forms that automate all user administration tasks
including user creation, role management, association of applications and roles.
Environment:
Operating System : Windows NT/98
Development tools : Developer/2000 (Forms 4.5, Reports 2.5).
Languages : PL/SQL, C.
Databases : ORACLE 7.3
-*-*-*-*-*-*-*-*-*-*-*-
Client : Bapuji Institute of Engineering & Technology., India.
---------------------------------------------------------------
Period From : Feb 1998 To : AUG 1998
Role : Computer Programmer
Project: Design of Distributed Computing Systems.
Distributed Computing System is designed mainly for overcoming the
problem faced in accessing data concurrently. Record locking concept is used to
lock the database record wise. Client Server architecture is used wherein
server controls & co-ordinate the clients & provide the right amount of
information to right person. Server is responsible to avoid any deadlock
situation.
Responsibilities:
I was involved in the study,design & development of the system, Wrote
various functions & subprogram which were included in the header files.Also
involved in coding, testing & documentation.
Environment:
Operating System : UNIX
Languages : C/UNIX
-*-*-*-*-*-*-*-*-*-*-*-
Personnel Details:
------------------
Date of Birth : 29th Mar 1976.
Passport Number : A7466064
Sex/Martial : Male/Unmarried
Nationality : Indian
Permanent Address:
------------------
Masoom Khan Afridi
#455, 1st Main 1st Cross
Gandhinagar
HARIHAR - 577601
Karnataka - State
INDIA
Tel: 91-8192-41661
Email: masoomkhan@hotmail.com
Present Address:
----------------
Masoom Khan Afridi
Al-Jazirah Corporation
P.O.Box : 354
Riyadh - 11411
Saudi Arabia
Tel : 966-1-4870911 Ext:215
-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-