Ehab W.

Ehab W.

Oracle Application Developer & PL/SQL Developer

Ellicott City , United States

Experience: 9 Years

Ehab

Ellicott City , United States

Oracle Application Developer & PL/SQL Developer

108000 USD / Year

  • Immediate: Available

9 Years

Now you can Instantly Chat with Ehab!

About Me

  • Over 8+ Years of extensive experienced in Oracle databases for development
  • Worked on software engineering at all the stages of SDLC process
  • Worked on complex queries PL/SQL packa...
  • Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views etc.
  • Worked on Oracle Forms 5/6.0/6i/10g/11g,12C, Reports 5/5/6.0/6i/10g.12C , Developer Suite
  • Worked on strong distributed code methods in Oracle cursor management, exception handling problem, databases collections and various logical tools etc
  • Performed on various Oracle databases Architect presentation layers like Oracle forms/ Reports,
  • Solid experienced in vertical segment Banking, Insurance, Telecom billing, Fund Accounting Management, Retail management system, Financial management system
  • Oracle Databases , Oracle9i Release 2: 9.2.0.1 - 9.2.0.8
  • Oracle10g Release 1: 10.1.0.2 - 10.1.0.5
  • Oracle10g Release 2: 10.2.0.1 - 10.2.0.4
  • Oracle11g Release 2: 11.2.0.1–11.2.0.4 , Database 12c Release 1: 12.1.0.2
  • Design and develop extensible/sustainable/quality database solutions based on an understanding of business and customer requirements and needs
  • Design  developing database structures that fit into the overall architecture of the systems under development and has to make trade-offs among data volumes, number of users logical and physical distribution, response times, retention rules, security, and domain controls
  • Code, install, and debug database queries and stored procedures using appropriate tools or editors
  • Solid experienced in vertical segment Banking, Fund Accounting Management, Retail management system, Financial management system
  • Produce Unit Test cases, Integration Test cases and respective test data.
  • Perform Code Review and prepare code review documentation.
  • Perform Unit and Integration testing and deliver Unit/Integration test report.
  • Implement and design complete applications
  • Create reports based on management/business requirements
  • Create/ modify primary database storage structures (table spaces) and primary objects (tables, views and indexes) after application developers have designed an application
  • Analyze and oversee all phases of the system development life cycle
  • Train and coach junior oracle developer and assign tasks according to technical knowledge and abilities
  • Supervise and review junior oracle developer’s code and make amendments as necessary

Show More

Portfolio Projects

Description

Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.

Analyzed data, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form,

Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters, and Program units by using PL/SQL procedures and functions

Show More Show Less

Description

Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.

Show More Show Less

Description

  • Design and oversee the complete software solutions
  • Implement and design complete applications
  • Customize the current solutions to reach integrated and optimized systems
  • Design and develop ERP system to serve and connect 3 branches
  • Data Modeler, Understand and translate business needs into data models supporting long-term solutions.
  • Processed and analyzed product return files; parsed and reformatted to meet customer specifications
  • Update, create and maintain large complex queries with large complex packages using PL/SQL.
  • Update and create Triggers.
  • Work with PL/SQL, Oracle Developer (Forms and Reports) and Workflow Builder

Show More Show Less

Description

  • Design, develop & integrate complete modules.
  • Developed complex SQL queries using Joins, nested queries, in line Views, in built Packages, Functions and clauses
  • Update, create and maintain large complex queries with large complex packages using PL/SQL
  • , Oracle Developer (Forms and Reports) and Workflow Builder, Analyze and oversee all phases of the system development life cycle.
  • Communicate status of testing, including reporting overall test results
  • Sets recommendations/best practices for defining and continually improving testing deliverables and process
  • Assist with analysis of issues reported by end-users during User Acceptance testing and
    determine the best course of action to address the concern.
  • Establish complete library for the company.
  • Provide direction and management and supervision to the Oracle development department
  • Provide consulting service to the client when desired.
  • Test, debugging, documentation standards, file design, interfacing, and change management.
  • Working knowledge of systems analysis, design, and system implementation

Show More Show Less