Sql Developer Oracle

HUDA ABDO

Oracle Developer

Centreville, Virginia 20121

Mobile: 703-***-****

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

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

Professional Summary

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

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

-Oracle Business Intelligance (BI) - Hand on experience in development, maintaining & supporting Oracle Business Intelligance System with weblogic server.

-Oracle Forms & Reports, Hand on experience Developing Oracle Systems using Oracle Forms & Reports, Oracle ADF (JDeveloper).

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

-SQL*Loader, Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

-Transformation and Loading (ETL), Involved in Extraction of the data in the table for Oracle database. Also, creating PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package

-Tunning Oracle system and DBs, Hand on experience in Production support monitoring and tunning Oracle DBs.

-Unix, knowledge in Unix shell scripting.

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

-Development Life Cycle (SDLC), 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 Modules HRMS (HR & Payroll), Financial (GL&AP)

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

Operating Systems : Windows, Unix

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

Database Tools: TOAD, SQL Developer and Data Loader

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

Professional Experience

Tata Consultancy Services (TCS) - Full time (04/2021 - Present) - Oracle Software Developer

Worked as a Part of Production Supporting Team for Global Shared Data System (GSD) in APTIV Company.

Domain:

Manufacturing Modules (Board Family BF, Grouping Label GL, BILL of Material BOM, MBOM & EBOM concepts).

Business Consulting Experience:

Well conversant with all phases of Software Development.

Process Life Cycle (SDLC) in line with industrial standard.

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

Experience in SNOW-NOW and Ticketing System.

Experience in working with Client Location.

Responsibilities:

Developed Oracle Forms and Reports to create user-friendly front-end applications for data entry and reporting.

Created and optimized database objects, including queries, tables, views, triggers, indexes, packages and functions. tailored to client specifications.

Developed database objects using Oracle tools like SQL Developer and Toad.

Working with PL/SQL development via Oracle database 19c using TOAD Tool.

Good knowledge of Unix shell scripting for improved efficiency and schedule through Cron in Unix Environement and working with Shell scripting via Putty and BeyondTrust tools.

Implemented exception handling mechanisms in PL/SQL to manage complex data processing tasks.

Enhanced SQL performance by analyzing execution plans and refining queries and PL/SQL blocks.

Conducted performance tuning to optimize existing database applications and queries.

Working with System enhancement and development such as Business Development Representative (BDR).

Supporting Production Oracle System by solving issues throught Reverse Engineering for packages and procedures.

Working in serveral environment with Oracle System such as Production, Model Office and Test Environments.

Envolved in System Transformation such as change the system URL.

Working on Test Cases at Pre & Post activity done for the GSD Application or Servers.

Envolved with Technical and Functional Support for Customer's unsers using Service-now system by creating and folow up Incidents (INC), SCTSKS, Change Requsets (CHG)...etc.

CACI Company - USA - Contract (06/2019 - 01/2020) - Oracle DataBase 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)Oracle RDBMS, 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, Analatical Functions.

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:

Creating new applications with Oracle Forms & Reports and hand-on experience in (create Data Block, Canvas, Alert, LOV, Record Groups, Program Units and Triggers ...etc).

PL/SQL scripts for data manipulation and validation and materialized views, Extensively used features like Cursors.

Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes, partitions and Collections to implement business logic. Generated server side

Perform SQL and PL/SQL tuning.

Perform Unix Shell Scripting using bash shell script.

Used PLSQL to Extract Transform and Load (ETL) the data into Database and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.

Involved in ETL (EXTRACT, TRANSFORM and LOAD) in database to transfer data from source tables into the database tables using PL/SQL.

Configure the Oracle EBS ystem for End Users Pc's and solve all issues with Java, Networking, PC setting ... etc.

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

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

Design and develop conversion programs, Inbound and Outbound Interfaces APIs to import data from legacy systems into Oracle ERP using staging, interfaces tables and building customized procedures with validation.

Developed and customized Reports in Oracle E-Business Suite 11i, 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 and SQL Loader.

GL Module working with 4C's (Chart of account key flexfield, Calendar, Currencies and accounting method), sequences and categories.

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 Technical 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 Intelligence (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.

Manage User Catalogue.

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

Create 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:

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

Budget System

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

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 & PL/SQL

-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

Overview of Performance Improvement - 1/2023

Environment Sustainability - 4/2023

Occupational Health and Safety - 4/2023

Information Secuirty Awarness - 10/2023

Enabler of Business Continuity - 1/2024

Deployment of Business Continuity - 1/2024

Anti Bribery and corruption Training - 2/2024

Cybersecurity - Priviledged Access Awarness - 3/2024

Practical Cybersecurity for IT Projessionals - 1/2025

Programming Foundations Secure Coding - 2/2025

Contact this candidate