Post Job Free

Resume

Sign in

oracle sql pl/sql E-business suite developer

Location:
Tempe, AZ
Posted:
September 29, 2015

Contact this candidate

Original resume on Jobvertise

Resume:

Khaled Ismail

Email: acrv42@r.postjobfree.com . 480-***-****

**** **** **** ****** *****,Arizona 85281

Legal to work in the USA as Permanent Resident (Green Card

Holder)

[pic]

Professional Summary

. Focused, energetic individual with strong background in Information

Systems Management and Database

. Recognized for strong personal interpersonal skills and team based

production approach.

. Self- motivated team player who goes the extra mile beyond assigned

given roles and responsibilities.

. I would envision applying my experience as an Oracle E-Business Suite

R 12 developer and consultant ((Procure to Pay life cycle, Supply

Chain & OPM modules)).

. Implemented an Oracle ERP system project for one of the largest

pharmaceutical companies in the Middle East.

. Proactively tailored solutions for users and organizational needs,

including customization of Oracle workflow to fit the company's needs.

. Basic skills of Oracle Database Administrator.

Core Strengths:

V 7 years practical experience in the development and maintenance of

application programs in an Oracle E-Business suite database and

applications.

V Experience work with Oracle 11g, Oracle 10g, Oracle 11g databases and

Reports and Forms Builder

V Extensive work experience in Oracle SQL

V Basic Knowledge in PL/SQL

V Strong analytical skills and decision-making capabilities.

V Experience with data flow diagrams, Entity relation modeling and design

Techniques, database normalization theory.

V Very good working knowledge in TOAD.

V Experienced to translate reporting and analytical needs into technical

solutions

[pic]

Professional Work Experience:

Oracle E-Business Suite Consultant.

11/2012 till Present

Pharco Corporation Alexandria, Egypt

V Trained more than 2000 Employees of Supply Chain and Production

Departments of the all Corporate on the ERP Functions and Menus of

their equivalent Oracle E - Business Suite Modules.

V Analytical functions and hierarchical queries are used

extensively to solve users

complicated problems.

V Expert in the functional and technical aspects of Oracle E-

Business Suite/

Applications 9i, 10g and 11i deployment Requirements,

Coding/Development,

Customizations, Testing, and Functional User Training.

V Extensive technical and business experience in Procure-

to-pay, OPM Life Cycles.

V Expertise in development tools such as Oracle Forms, Oracle Reports,

PL/SQL,SQL*PLUS, Linux Shell Scripts.

V Interacted with end users and functional architects for mapping the

legacy data to

the Oracle tables.

V Created custom responsibilities to which were attached

specific menus, forms and

reports for restricted user access.

V Involved in providing techno-functional Procure-to-Pay

(P2P) life cycle support.

V Performed routine fixes for P2P issues in setup of

users, responsibilities,

suppliers, requisitioning, purchase orders, receiving,

invoicing, payments etc.

V Converted existing Oracle Reports to XML/BI Publisher Report through

Oracle's

desktop XML Publisher tool.

V Experience in creating Concurrent Programs, Request sets, Flex fields,

lookups,

Profiles, Value sets, Triggers, Packages, Procedures,

Functions, Cursors and Exception

Handlers, Record Groups, LOV's.

V Analyzed and designed staging tables, wrote inbound interface programs

in PO and

Inventory Modules.

V Used the System Administrator responsibility to create users

responsibilities, Value

sets and Request sets.

V Technical and Business experience in Human Resource module

beyond the

Egyptian standards.

Oracle E-Business Suite Developer. 04/2008

till 10/2012

Pharco Corporation Alexandria, Egypt

V Developed Customized Reports and Forms which are used to suite the

users requirements, and this by using Oracle Developer 11g [(Report

Builder), PHP and (Form Builder)] with Oracle SQL and PL/SQL.

V Created Oracle PL/SQL packages and procedures to

implement business requirements.

V Implicit and Explicit cursors are used in Oracle PL/SQL packages

when designing new

forms, functions, routines and packages.

V Involved in comparing Production data with Test data for identifying and

cleaning

corrupted data by using SQL and PL SQL through Toad.

V Implicit and Explicit cursors are used in Oracle PL/SQL

packages when designing new

forms, functions, procedures and packages.

V Analyzed, Implemented, Customized Purchasing, Quality

Control, Quality Assurance,

Inventory, Planning and Production Departments' in order to

meet users'

requirements.

Programmer and Information Systems Specialist. 01/2000 till 03/2008

Safe Pharmaceutical comapny a subsidiary of Pharco Corporation

Alexandria, Egypt

V Built New Visual Basic 6 Applications to other Managements in the

Company.

V Upgraded old Applications (COBOL Applications) to Visual Basic

Applications.

V Trained 5000 employees on efficiently using the newly developed

applications.

V Trained employees for Using MS Office 2000, MS Office 2003, MS

Office 2007 (Word-

Excel-Access-Power Point),Internet, Windows 98, Windows XP,

Windows 2000 server,

Windows 2005 Server and Windows 2008 Server.

Education:

MBA- Master of Management Information System - Arab Academy for

Science & Technology, Alexandria, Egypt 2004

BS - Bachelor of Information Systems Management - Arab Academy for

Science & Technology, Alexandria, Egypt 2000

Accreditation:

V Certified MY SQL +PHP Programming, 2010

V Certified Linux Introduction level, System Administration Level &

Network Level, 2008

V Certified JAVA Programming, 2005

V IELTS, 2013

Computer Skills

V ORACLE DATABASE

V Development: Oracle Database 8i, 9i, 10g,11g, SQL, PL/SQL, SQL

query

tuning, PL/SQL code optimization, data

restructuring.

V Programming languages: SQL, PL/SQL, Java, PHP, HTML & Visual

Basic

V Tools: TOAD, PL/SQL Developer, SQL Navigator, SQL*Plus,

SQL*Loader, SQL

Developer

V Design, Data Modeling: Oracle Designer, Power Builder and

Composer

V General:

V Language/Technologies: PHP, JavaScript, CSS, HTML, Visual Basic

and Java

V Operating Systems: Dos, Windows XP, Windows 7, Windows 8 and

Windows Server till

2012

V Other Data Base: MYSQL, MS Access and SQL Visual Studio

References and additional information upon request



Contact this candidate