Developer Oracle

HUDA ABDO

ORACLE DEVELOPER

Centreville, Virginia 20121

Mobile: 703-***-****, Tel : 703-***-****

E-mail: ************@*****.***

Linkedin: https://www.linkedin.com/in/huda-abdo

Professional Summary

Over 10 years of IT experience working as Oracle Developer with the following:

-Oracle E Business Suite, Techno Specialist, Support Oracle HRMS Module (HR & Payroll), Financials module (GL & AP).

-SQL and PL/SQL Experience, Develop Oracle database Objects like Packages, Stored Procedures, Functions, Views, Materialized View, Database Triggers and cursors etc...

-Hand on experience in support & maintain Oracle Business Intelligance (BI) System with weblogic server.

-Hand on experience Develop Oracle Systems with Oracle Forms, Oracle Reports, Oracle ADF (JDeveloper).

-Knowledge of Unix shell scripting, JAVA, JavaScript, HTML, CSS, Bootstrap and Support Project build in Java.

-Well conversant with all phases of Software Development Life Cycle (SDLC) and AIM Methodology.

Skills

Proficient in System Requirement Study, System Design, Database Design, Programming Testing and Implementation.

Excellent process orientation with analytical thinking, problem solving and good communication skills

Prioritize and execute tasks in a high-pressure environment

Learn new skills and take on greater responsibilities.

Work in a team, worked effectively in a multi-cultural environment and good at learning and teaching others.

Technical Skills

ERP : Oracle EBS 11i, Modules HRMS (HR & Payroll), Financial (GL&AP)

Oracle Forms & Reports, Oracle ADF, Oracle BI and Weblogic server.

Operating Systems : Windows

Office Applications: MS Outlook, Visio, MS Office, MS Project

Database Tools: TOAD, SQL Developer and Data Loader

Languages: SQL, PL/SQ, Java, Javascript.

Professional Experience

CACI Company - USA - Contract (06/2019 - 01/2020) - Oracle Developer

Worked as part of an agile team as Oracle Developer on a Project of Health Solutions - Tracking Accountability in Government Grants System (TAGGS) for the Department of Health Human Services (HHS).

Responsibilities:

a)Coordinated with the front end design team to provide them with the necessary Packages, Stored Procedures and the necessary insight into the data.

b)Hands-on experience in SQL and PL/SQL programming, developing complex code units using Oracle SQL Developer and Toad.

c)Created PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling.

d)Prepared Action Plan to Implement and Execute the Solutions.

e)Used Agile software development with Scrum methodology.

Water Authority of Jordan (WAJ) - Jordan - ICTU Dept. (8/2008 - 9/2018) - Oracle Developer

Responsibilities:

a)HRMS(Core HR, Payroll) and Financial (GL, AP):

Worked as Post Production Support of Oracle EBS in various modules HRMS, Payroll, Financial (GL, AP).

Design and develop conversion programs, Inbound and Outbound Interfaces APIs to import data from legacy systems into Oracle ERP.

Developed and customized Reports in Oracle E-Business Suite 11i, Oracle 9i/8i, develop Customized reports using oracle Reports.

Excellent conceptual and working knowledge of Oracle Database Design and Development, Object, writing Packages, Stored Procedures, Functions, Views, Materialized View, Database Triggers and cursors using SQL and PL/SQL in Oracle.

Experience with Oracle development tools and utilities, such as Toad, Data Loader, SQL*Plus, SQL Developer.

HRMS Module Working with Work Structures by creating new Location, Organization, Jobs and Grades.

Setup of Absence management with Accrual Plans to define the Vacation package for the employees and Involved in definition of Absence types and Accrual Plans.

Develop and Maintain Fast formulas in Oracle Payroll

Create Payroll elements, element links and assign the element to it's Fast Formula.

Create new functions to use in Benefit rule’s Fast Formula’s.

System Administration Activities like defining New Users,Creating Responsibilities and assign responsibilities to Users

Define Values Sets,, Lookup types, Key flexfields, registering menus and concurrent programs.

Define Request Groups, assign reports to the groups in order to assign Request Group to Responsibility.

Develop and Define Additional Screens requested by users.

Work with Custom.pll library for customization.

Work with oracle Techncial Support (Metalinks) to solve any issue may occur.

Provide support to apps users to resolve any issues in both Technical and Functional aspects.

b)Oracle Business Intellegance (BI):

Excellent knoowledge of Oracle Business Intelligence (BI), working with Oracle BI Administration Tool and Weblogic Server.

Create materialized view to be used via Oracle BI System.

Import data from database (tables, views) via Administrative tool, work with physical and Business Model to enable data to be viewed by users.

Creat Reports, Analysis, Dashboard, Filters to be used by end user.

Create users and assign subject area to them via Weblogic Server.

Install the BI system in End Users PC's.

Provide support to BI users for any technical issues

Train BI users to develop custom analysis, reports and dashboards.

c)Local Oracle Systems:

Build Projects using Oracle Forms and Reports, Jdeveloper (Oracle ADF).

Support and Maintain JAVA Project.

Create database object such as packages, procedures, functions, synonyms, tables, views, cursors, indexes, triggers, database links etc.

Performance tuning and creation of materialized views

Support and Maintain Oracle systems built in Oracle Forms & Reports.

Projects

I was involved in developing and implementing the following Systems:

Budget System

Cars Transportation System to regester cars inoformation, fuels coupons …etc.

Customer Information System (CIS), I was involved in building Security Module of water billing system.

Education

Bachelor’s Degress in Computer Science – Al Isra University – Graduate Year 2005

Training Courses

Record Management Training - USA

Oracle Fusion Middleware 11g : Build Application with ADF 1 ED 2 PRV – Oracle University

JAVA SE 8 Programming ED 1 PRV – Oracle University

Oracle Weblogic Server 12c: Administration I – Oracle University

Oracle Weblogic Server 12c: Administration II – Oracle University

Oracle Courses - Institute: Savvytek Academy

-R12 Oracle HRMS Implement and Use Fast Formula

-R12 Oracle HRMS System Administration Fundamentals

-R12 Oracle General Ledger Management Fundamentals

-R12 Oracle E-Business Suite Essentials for Implementers

Oracle 6i – This course include the following tutorials - Institute: Falcon Training Center

-SQL & PLSQL

-Oracle Developer 2000 – Full Track

-Oracle Forms and Reports

Java Courses – Institute: Final Solution

-JAVA Enterprise Edition (JEE)

-Java Standard Edition (JSE)

SharePoing Courses: Institute:Esense

-PerformancePoint 2010 Designing and Implementing Scorecards and Dashboards

-SharePoint 2010 Business Intelligence

-Configuring and Administering Microsoft SharePoint 2010

-Microsoft SQL Server 2008 Analysis Services

-Microsoft SQL Server 2008 Reporting Services

-SharePoint 2010 Maintenance, Administration & Development - Institute: Microsoft Jordan

Kaspersky lab hands on for Kaspersky Endpoint Security 8 for Windows

Investment Plan Financial Model Training Session - Institute: USAID (Institutional Support Strengthening Program (ISSP)

Managerial and Behavioral Competencies Training - Institute: SCOPI Strategic Center for Organizational Performance Improvement

Internal Memo System Administration - Institute: E-tech systems

Certificate of Achievement for completing the following courses - Institute: USAID:

-Leadership, Teams Building & Diversity

-How to Organize and Conduct Successful Meeting

-Motivation Persuasion Creativity

-The 7 Cs of Communication

Attending X7 Training Sessions – Billing System

ISO 9000:2000 Introduction and Awareness Training Course - Institute: SGS System & Services Certification

Contact this candidate