Software Engineer Management System

Ahmed Atiyab

Karachi, PAKISTAN

Mobile No +923*********

Email: a .******@*****.***

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

Over 3 years’ experience in customization, Personalization and Implementation of Oracle EBS R12 (OPM, INVENTORY, ORDER MANAGEMENT, AR, AP, GL, SYSTEM ADMINISTRATION)

Highly skilled in software engineering methods and data modeling

Extensive knowledge of SQL and PL/SQL

Over 14 years of experience in development, implementation and customization of client-server and web based applications.

Proficient in Oracle (SQL, PL/SQL) and front-end tool Oracle Developer (forms and reports)

3 years data migration (ETL) experience (using programming languages like PL/SQL) in IBM Maximo.

Functional exposure in Financial Accounting, Inventory, Enterprise Asset Management System (Maximo) TECHNICAL SKILLS

OPERATING SYSTEM : Windows NT, Windows, UNIX

RDBMS : ORACLE (11g, 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 [forms and reports ])

OTHER TOOLS/ UTILITIES : TOAD, SQL DEVELOPER, Erwin, Kettle, SQL*LOADER,BIRT, A CUTATE

APPLICATIONS : IBM Maximo (Version 7,6,5,4) [System Application configuration,troubleshooting, Maintenance, Purchasing, Inventory, Contracts], MS OFFICE, PeopleSoft ERP.

GENERAL SKILLS: System Analysis, Logical/physical database designing, Analysis and t ranslating business requirements to a technology solution. Oracle installation, Database Backup/ Recovery handling, Database / Query tuning and optimization, Coding, testing and debugging the application.

PROFESSIONAL EXPERIENCE AND SIGNIFICANT ACHIEVEMENTS Dr. Zia-Uddin Hospital & Medical University

Jan 2016 – Present

Technical Consultant EBS R12

Development and Customization of Forms, Reports as per User requirement Defining Concurrent Programs, Executables and Value sets Creation/Modification of PL/SQL Packages, Procedures, Functions for DML operations as per requirements Usage of Oracle builtin API's in Customized forms (customers creation, agreements, sales order generation, invoice and receipts API etc)

Uploading attendance data from biomatric machines through text files Developing customized reports as per requirement in various output formats Perform User Acceptance Testing (UAT)

Page 1 of 4

Al-Rahim Textile Industries Jan2014–Dec-2015

Oracle Consultant

As Oracle Technical consultant (software), my core responsibilities are to design reports in EBS R12, form personalization, system administration, provide functional support/training to end user for daily task(specailly in OPM), design/develop customize application/forms (packing system), upload data using oracle API’s (for items) or using DataLoader

Interacted with end users and functional architects for mapping the legacy data to the oracle tables. Sapphire Consulting Services

Oracle Consultant.

Jan-2013 – Dec-2013

As Oracle T echnical consultant (software), my core responsibility is to analysis, design and debug interfaces / reports in PeopleSoft ERP as well as data migration is also my part of job. Child Development Institute of Pakistan (CDIP)

Technical consultant (software) OCT-2011-Dec-2012

As T echnical consultant (software), my core responsibility is to design applications as an integrated product. Other than product development, my responsibilities are

System Analysis, design and development.

System presentations.

Integration of the developed/existing systems as an integrated product.

Troubleshoot and maintain existing applications / databases.

Modify existing applications with enhancements.

Data Migration.

Database performance monitoring and tuning

Database backup and recovery plans.

Esolution Maximo-Abu Dhabi May 2008 – May

2011

Technical consultant

As technical consultant, ETL expert for IBM Maximo (Enterprise Asset Management System), my core responsibilities were

System Analysis for customize interfaces/applications

Gap Analysis

Prepare mapping 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.

Data mapping.

MAJOR PROJECTS OF MAXIMO UPGARDE in UAE and OMAN

MAXIMO UPGRADE FOR ABUDHABI TERMINAL (ADT)

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

Maximo Upgrade for Takreer

Page 2 of 4

Maximo Upgrade for Zadco

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 database (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 Page 3 of 4

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

Passport No : AA1448831 (VALID)

Page 4 of 4

Contact this candidate