Ahmed Atiyab

Freelance Database Designer & Database Programmer

1477
Location:Abu Dhabi, Abu Dhabi, United Arab Emirates
Phone: +971503198117
Profile:https://www.freelanced.com/ahmedatiyab
0
Kudos
5.0
2 Skills
Ask
Rate/Hr
Ahmed Atiyab
? Abu Dhabi, UAE
? Mobile No +971503198117

? Email: a.atiyab@gmail.com


OBJECTIVE
To obtain employment in an IT environment where my experience as an Oracle Developer and System Analyst with expertise in the full systems development life cycle methodology can be fully utilized.
SUMMARY

? Highly skilled in software engineering methods and data modeling
? Extensive knowledge of SQL and PL/SQL
? 11 years experience in development, implementation and customization of client-server and web based applications.
? Proficient in Oracle and front-end tool Oracle Developer 2000 (forms and reports)
? 3 years data migration (ETL) experience (plus functional exposure) in IBM Maximo.
? Functional exposure in Financial Accounting, Inventory, Enterprise Asset Management System
?


TECHNICAL SKILLS

? OPERATING SYSTEM : Windows NT, Windows , UNIX

? RDBMS : ORACLE (10g,9i,8i,8,7,6), MS SQL Server 2005/2000, MS ACCESS

? PROGRAMMING LANGUAGES: SQL, PL/SQL, Transact-SQL

? DEVELOPMENT TOOLS : Oracle Developer Suite (Oracle Developer2000)

? OTHER TOOLS/ UTILITIES : TOAD, SQL DEVELOPER, Erwin, Kettle , SQL*LOADER

? APPLICATIONS : IBM Maximo (Version 7,6,5,4), MS OFFICE

? GENERAL SKILLS: System Analysis, Logical/physical database designing, Oracle installation, Database Backup/ Recovery handling, Database / Query tuning and optimization, Coding, testing and debugging the application.

PROFESSIONAL EXPERIENCE AND SIGNIFICANT ACHIEVEMENTS
Esolution Maximo-Abu Dhabi May 2008 – Present
Technical consultant
As technical consultant, ETL expert for IBM Maximo (Enterprise Asset Management System), my core responsibilities are
? Gap Analysis
? Prepare maping Documents
? Database Configuration
? Data Migration (using programming language like PL/SQL)
? Maximo Up gradation
? Integrity Testing of Maximo DB
? Data Validations
? Onsite Implementation and post go live support
? Database Administration
? Performance and fine tuning of database and queries
? Data loading in maximo database from excel sheets / text files
? Training for the clients.


MAJOR PROJECTS OF MAXIMO UPGARDE in UAE and OMAN

MAXIMO UPGRADE FOR ABUDHABI TERMINAL (ADT)

ROLE: Data migration from maximo4 to maximo7 of maintenance Application

RESPONSIBILITIES: Creation of databases, Prepare mapping documents, prepare
Scripts for data migration,
Perform data configuration for customized field, perform data
Integrity / validation test.

TOOLS/TECHNOLOGIES: Oracle 10G, PL/SQL, TOAD, SQL LOADER,

Maximo Upgrade for Oman Oil Refinery, Oman (Orc) And Merging Of Sohar Refinery Company (Src)

ROLE: Merging data of maximo 5 (SRC) and maximo 6 (ORPC) into maximo 6 (ORC)

RESPONSIBILITIES: Creation of databases, DBA tasks, prepared mapping documents for data migration.
Gathering missing field data Perform Chart of Accounts mapping, person IDs mapping, department mapping, data integrity test. Testing of the System. Monitoring the performance of the system Support for remote systems, handling of post golive issues

TOOLS/TECHNOLOGIES: Oracle 9i, 10G, PL/SQL, TOAD, Maximo 5 and 6

Maximo Implementation for Fapco

ROLE: Modify the Scripts for data loading from excel sheets.

RESPONSIBILITIES: Load the data provided in excel sheets, Check the data integrity, modify the scripts as new requirements.

TOOLS/TECHNOLOGIES: SQL SERVER 2005, Maximo7

Maximo Upgrade for Takreer

ROLE: Post golive support

RESPONSIBILITIES: Rectify the issues, write and apply hot fixes on production DB , Migrate the missing data from maximo 4 database

TOOLS/TECHNOLOGIES: SQLSERVER2005, TOAD, Maximo7

Maximo Upgrade for Zadco

ROLE: ADMA Drilling data migration / Post golive support

RESPONSIBILITIES: Prepare mapping documents, write scripts and perform data migration, data integrity test, testing of the system.

TOOLS/TECHNOLOGIES: Oracle 9i, 10G, PL/SQL, TOAD, Maximo4 and 6

Other Maximo Upgrade Projects:

? Gasco (oracle10g)
? Maximo7 implementation at TAMDEED Projects LLC (oracle10g)
? Maximo 4 to 6 upgrade at SHUWEIHAT (Power Generation Plant At SHUWEIHAT) (SQLSERVER2005)
? Loading/Rectifying Data (Assets and Locations) from Excel sheets to maximo5 databse (SQLSERVER2000) for client GTTP

ORACLE DEVELOPER2000 PROJECTS

Inventory Management System/ Accounting System for a Publishing Organization Jan-2006 to Dec-2007

ROLE: System Analyst/Software Engineer

RESPONSIBILITIES: Functional analysis of the system, Solution design and implementation of a comprehensive compliance inventory data tracking and reporting database
Forms and reports designing, Testing, debugging and implementing of the system.

TOOLS/TECHNOLOGIES: Oracle 8i, Developer2000 (forms6i, Report 6i), Erwin for data modeling

Students Management System (Developed/Implemented as Product for Various Schools) Jan-2000 to Dec-2005

ROLE: System Analyst/Software Engineer

RESPONSIBILITIES: Analysis of the system, Solution design for the system ,
Forms and reports designing, Testing, debugging and implementing of the system,
Reports customization

TOOLS/TECHNOLOGIES: Oracle 8i, Developer2000 (forms6i, Report 6i), Erwin for data modeling

Payroll System (ICI Pakistan [PTA Plant] from Jul-1998 to Jun-1999, U&I Garment Factory from Jul-1999 to Dec-1999 )

ROLE: Software Engineer

RESPONSIBILITIES: Design, development and testing of payroll software. Collect Data from attendance system and load into database. Overtime calculation, Income Tax calculations, Debugging and testing of the software. Users training and Post implement support.

TOOLS/TECHNOLOGIES: Oracle 7, Developer2000 (forms4.5, Report), Erwin for data modeling.

Shares Management System – (Electric Power Plant Hubco) Oct-1997 to Jun-1998

ROLE: Software Engineer

RESPONSIBILITIES: Data migration from legacy system, Analysis and implementation of Forms,
Development of Forms & Reports, Coding , testing & debugging of the system

TOOLS/TECHNOLOGIES: Oracle 7, Developer2000 (forms4.5, Report), Erwin for data modeling

Production Management System – (Heavy Vehicle - Hino Pak) Jan-1997 to Sep-1997
ROLE: Programmer
RESPONSIBILITIES: Analysis and implementation of Forms Coding & Developing of reports.
Testing and debugging the system
TOOLS/TECHNOLOGIES: Oracle 8i, Developer2000 (forms6i, Report 6i), Erwin for data modeling

Others Oracle Developer2000 Short Terms Projects

? Member’s Management System (Renowned Clubs, MLM Company)
? Results Management System (Renowned Schools, Government of Pakistan)
? Library Management System (Renowned School)

Certification & Training

Hardware: Advance Computer Maintenance

LANGUAGE
English, Urdu, (Written - Spoken)

HIGHEST EDUCATION & QUALIFICATION

Master of Science (M.Sc. Physics)
Karachi university, Karachi, Pakistan

PERSONAL

Date of Birth : 05-May - 1970
Nationality : Pakistani
Civil Status : Married
Gender : Male
Religion : Islam
Visa Status : Employment Visa
Passport No : AA1448831