ORACLE EBS TECHNICAL CONSULTANT Resume Santa Ana, CA - Hire IT People

PROFILE:

Oracle Database and PL/SQL Developer Professional with experience in Administering, designing, coding, testing and supporting a pplications that use Oracle Database technology.
Proficient in an assortment of technologies and tools including Oracle 10g/11g, PL/SQL, Forms and Reports builders, TOAD,PL/SQL Developer, SQL Developer and Git.

ADDITIONAL SKILLS:

WORK EXPERIENCE:

ORACLE EBS TECHNICAL CONSULTANT

Confidential, Santa Ana, CA

Responsibilities:

Creating and debugging PL/SQL packages, procedures, functions and triggers to meet business needs.
Implementing database structure design for Tables, views, sequences, synonyms and database triggers
Developing custom forms and reports using Oracle Forms builder and Oracle Reports builder and BI Publisher.
Using Oracle EBS R12 APIs and SQL*Loader to interface data between Oracle EBS and external data sources.
Writing of server commands and shell scripting in Windows and Linux/Unix
Building custom interfaces for data conversion between systems.
Integrating customized application with Oracle standard application modules.
Creating and Designing Forms and Reports using Oracle APEX.

Systems Developer

Confidential

Responsibilities:

Oracle Database Administrator

Confidential

Responsibilities:

Administering all Oracle database objects, including tables, indexes, views, sequences, packages and procedures.
Writing complex SQL Queries for ad-hoc reporting from an Oracle Database.
Backing up Oracle Database using Export and Import Data Dumps and RMAN.
Creating reports using Crystal Reports.
Performing ongoing tuning of an Oracle Database.
Troubleshoot issues regarding database, applications and development tools.
Creating and dropping Oracle Database users as required.

Senior Ict Officer

Confidential

Responsibilities:

Developing, debugging, testing and implementing code using Oracle PL/SQL in an Oracle 10g environment.
Creating and modifying Oracle Forms for a browser based application.
Creating and modifying Oracle Reports using Oracle Reports Builder 10g.
Providing technical support in form of a help desk to the application development teams.