SUMMARY OF QUALIFICATIONS

Oracle SQL/PLSQL developer with over 10 years of comprehensive experience in Oracle application development and creating solutions for business problems

Experience in Unix shell scripting and batching, Autosys jobs, Control M jobs, Appworx Job

Experience in database development and data models

On-hand experience in Oracle Apex, Forms, and Reports (10g,11g,12c)

Business experience in Enterprise Resource Planning (ERP)

Proven skills in implementation, administration, analysis, design, testing, and maintenance of code and training end user

Proficient problem-solver who envisions business and technical perspectives to develop workable solutions

Motivated achiever who guides organizations in applying technology to business settings, provides added value, and creates project deliverables in a timely manner

Customer-focused performer who is committed to quality in every task – from personal interaction with coworkers and users to a high level of service provided to the company and customers

Valued contributor who performs confidently and effectively under pressure and thrives on challenges

Computer Language included: Java, C#, HTML, CCS, Java Script

PROFESSIONAL EXPERIENCE

Oracle PLSQL Developer 2022/05 – Now Job type: Contract

Home Hardware Canada

Responsibilities:

Enhance and Develop PLSQL DB procedures, functions, and packages for various business units

Enhance custom forms and reports for various business units

Build Appworx jobs from the scratch base on business requirements

Produces and maintains documentation technical design, unit testing, and install list to DBA

Work on Migration project from VMS DCL to Appworx job batches schedule

Work on ASR project for solution customization and support

Environment: Oracle 12c (forms, Reports), PL/SQL, SQL developer, UNIX shell scripting, Appworx, MKS integrity client

Oracle PLSQL Developer June /2021 - April /2022 Job type: Full time

LTIMindtree - Larsen & Toubro Infotech LLC – CitiBank Canada

Responsibilities:

Performance tuning for the complex SQL query and PLSQL tunning

Work on AutoSys Workload Automation Job Schedule and create Autosys JIL (Job Information Language)

Involved in the continuous enhancements and fixing of production and QA problems. designed, implemented

Work on a reconciliation project DB issue and support the DBA team

Environment: SQL Developer, UNIX shell scripting

Oracle PLSQL Developer 2019/05 – June/2021 Job type: Contract

Suncor - Petro Canada Information Technology Operations

Responsibilities:

Developed data models and database design and create advanced PL/SQL packages, procedures, triggers, functions, Indexes, and business logic using Oracle12C

Designs and builds custom forms and reports for various business units

Batch processing, shell scripting

Produces and maintains program code and documentation

Designs and builds data interfaces and extracts

Designs logical and physical data models

Open changes, incidences, and requests, tasks using the service now

Environment: Oracle 12c (forms, Reports), PL/SQL, TOAD, SQL*LOADER, SQL developer, UNIX shell scripting

Oracle PLSQL Developer 2014/10 – 2018/05 Job type: Full time

Abujaber Investment Group (ITD)

Responsibilities:

Custom applications and extensions HR and payroll

SQL development, Queries, SQL Performance Tuning Developing

Developed data models and database structure and create advanced PL/SQL packages, procedures, triggers, functions, Indexes, and business logic using Oracle11g.

Developed applications using Oracle Application Express (APEX) web pages.

Developed procedures, functions, and packages to implement the system's business logic using PL/SQL.

Involved in the full development cycle of planning, validation, analysis, design, development, testing, and Implementation.

Designed and developed Oracle forms & reports generating up to 500 reports.

Performed modifications on existing form as per change request and maintained it

Involved in the continuous enhancements and fixing of production problems. designed, implemented, and tuned interfaces and batch jobs

Use Unix Shell scripting to generate forms and reports, Library, OLB.

Environment: Oracle 10g/11g (forms, Reports), PL/SQL, TOAD, SQL*LOADER, SQL PLUS, Oracle designer, Oracle Apex, HTML, JavaScript, XML, UNIX shell scripting

Oracle PLSQL Developer 2013/01 – 2014/09 Job type: Full time

New Vision LG

Responsibilities:

Develop and implement Enterprise Resource Planning (ERP) specializing in HR and payroll

Gathering system requirements through user interactions.

Involved in the development, and maintenance of Triggers, Joins, Cursors, and Views.

Extensive use of SQL commands with TOAD environment to create target tables.

Involved in maintaining and writing PL/SQL Stored procedures and SQL

queries for populating the daily and historical tables.

Optimized the performance using PL/SQL table types and record types.

Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, join types and operations, and providing hints.

Extensively worked in Performance tuning of PL/SQL programs.

Wrote SQL queries to develop test data for use during test execution.

Oracle Computer Programmer / PLSQL 2010/12 – 2012/12 Job type: Full time

ITAC (Information Technology& Automation Co.)

Responsibilities:

Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements for Human resource and payroll modules.

Wrote PL/SQL packages, procedures, functions, and triggers in Oracle 9i.

Designed logical and physical data models

Wrote sequences for the automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.

Upgraded Oracle 9i to 10g software in different environments for the latest features and also tested databases.

Developed and modified triggers, packages, functions, and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.

Wrote SQL, PL/SQL, and SQL*Plus programs required to retrieve data using cursors and exception handling.

Designed Data Modeling, Design Specifications, and analyzed Dependencies.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 10g (forms, Reports), PL/SQL, TOAD, SQL*LOADER, SQL PLUS, Oracle UNIX shell scripting, Java

EBS Application Developer / PLSQL 2007/01 – 2010/11 Job type: Full time

Intracom – Oracle Partner Company

Responsibilities:

Developed oracle forms and PLSQL packages for Ministry of Finance Greece migration project from object-oriented system to Oracle 10g

Designs and builds custom forms and reports for various business units (E-business suite) such as (AP, AR, GL, HCM, and CRM)

Created reports using XML publisher. Created schedulers to deliver reports automatically.

Extensively worked in performance tuning of PL/SQL programs and data Integration tasks

Work on migration project from an object-oriented environment to an Oracle application environment

Environment: EBS R12, XML publisher, Oracle 10g (forms and reports), Toad

EDUCATION

Bachelor’s Degree in Computer Information Systems 2005/06

University of Al-Zaytoonah

(Equivalent to a Bachelor of Computer Science degree from an Ontario university, as determined by World Education Services (WES) in Toronto, ON)

Contact this candidate