We provide IT Staff Augmentation Services!

Oracle Developer Resume

SUMMARY:

  • More than 20 years of experience in design and programming in various computer languages.
  • More than eleven years of experience with Oracle database Server.
  • Extensive experience with SQL*Forms, SQL*Reports, SQL*Plus, PL/SQL, SQL and Oracle DDL.
  • Extensive experience with system analysis, development and troubleshooting, as well as, with IBM PC and compatibles.
  • In addition he has been involved in numerous software conversion efforts during his career.

SKILLS:

  • Oracle / earlier versions
  • HTML
  • Cobol
  • Fortran
  • PL/SQL

SOFTWARE/LANGUAGES:

  • Application Express 2.1.0., PL/SQL Release 11.2.0.1.0 , Oracle SQL Developer Version 3.0, Oracle 6, 7, 8, 10, Oracle HR 10.7, Developer/2000, PL/SQL, SQL*Forms versions 2.3, 3.0, 4.0 4.5, 6 & Developer 9i, SQL*Menu, SQL*Plus: Release 10.2.0.1.0 , SQL*Report 9.0,2.5, Assembly (For CDC6400), Basic, CDC CYBER Control Language CLIST, Cobol2, Cobol PCC, DEC TOPS 10/20, Fortran, IBM JCL, IBM MVS/JES2, ISPF/PDF, MVS/TSO, Perkin - Elmer OS/32, QMF, REXX, SIR DBMS, S2K DBMS, SQL/DS, Unisys Exec 1100, #LF UNIX, VM/CMS, DBase II/III/IV, Excel, Fastback, Freelance, Lotus 123, MS/PC DOS, Norton Desktop and Utilities, OS/2, Paradox, Quattro Pro, Reflection X, Windows, WordPerfect, XDB.
  • SUN Solaris SparcServer, 10 PC/XT/AT and Compatibles, IBM 4381, DEC 20, IBM 3090., HP 3000, PERKIN-ELMER 3220/3240, UNISYS #LF (UNIVAC) 1190, CDC-6400.

PROFESSIONAL EXPERIENCE:

Oracle Developer

Confidential

Responsibilities:

  • While in Confidential I developed PL/SQL packages, procedures and functions on an Oracle database and SQL*Plus scripts on an database. and object types on an Oracle database. and. database triggers, directory objects, queries, sequences, indexes, etc.

Tools: Oracle SQL Developer, Oracle SQL*PlusDatabase: Oracle Express Edition. 10g release 2, Oracle Express Edition. 11g release 2

Oracle Developer

Confidential, Germantown, MD

Responsibilities:

  • Participated in the conversion of Pro-COBOL programs (Oracle 4) to PL/SQL (Oracle 10)..The effort involved a conversion of a Confidential (DOE) Funds Distribution System (FDS) in ORACLE Pro-COBOL programs and ORACLE SQL*Forms from MVS hardware in ORACLE 4 to UNIX hardware on Oracle 10, ORACLE SQL*Forms and ORACLE SQL*Reports.

Tools: Oracle SQL*Plus, Oracle 10 release 2, SQL*Forms, PUTTY, WinSCP. UNIX, Reflection X, Microsoft Visual Source Safe, Microsoft Outlook, TOAD V19, ORACLE Sql Developer. Oracle PL/SQL.

Database: Oracle 10g Release 2

Oracle Developer

Confidential

Responsibilities:

  • While in Confidential I developed PL/SQL packages, procedures and functions on an Oracle 10g release 2 database and SQL*Plus scripts on an Oracle 10g release 2 database. and object types on an Oracle 10g release 2 database. and. Database triggers, directory objects, queries, sequences, indexes, etc.

Tools: Oracle PL/SQL,.Oracle SQL Developer, Oracle SQL*Plus

Database: Oracle 10g release 2 Express Edition.

Database Specialist

Confidential

Responsibilities:

  • Wrote Oracle PL/SQL packages from legacy report programs( Cobol programs, QMF scripts, IBM JCL and sample outputs ).
  • Developed tables, table triggers, SQL Loader scripts.
  • Transferred to Confidential on 04/03/08.

Tools: Oracle SQL*Plus, Oracle SQL Loader

Database: Oracle 10g release 2.

Oracle Developer

Confidential

Responsibilities:

  • I developed PL/SQL packages, procedures and functions on an Oracle 10g release 2 database and SQL*Plus scripts on an Oracle 10g release 2 database. and object types on an Oracle 10g release 2 database. and. Database triggers, directory objects, queries, sequences, indexes, etc.

Tools: Oracle SQL Developer, Oracle SQL*PlusDatabase: Oracle 10g release 2 Express Edition.

Oracle Programmer

Confidential

Responsibilities:

  • Wrote 15 reports in Oracle Reports 6i to replace PL/SQL procedures that generated HTML.
  • All reports were published on the WEB. The reports ranged from overviews of equipment (mainly airplanes) to detailed listings of equipment.
  • All reports retrieved the information from an Oracle database and accessible via the Internet.

Tools: Oracle SQL Report Writer 6

Oracle Developer/Sr. Oracle Programmer

Confidential

Responsibilities:

  • Responsibilities include Data Conversion Move all data from legacy systems such as PIRS to Human Resources/ Confidential system and Data Availability Moving data from Confidential system (on a periodic basis) to tables (based on person) in order to simplify data access from the Confidential System for reporting problems, etc.
  • The environment is IBM RISC 6000/AIX, Oracle 7.3 and 8, Oracle HR 10.7, Developer/2000 (PL/SQL, Oracle Forms and Oracle Reports).

Tools: TOAD(Quest), Oracle SQL Report Writer, Oracle SQL*Plus,, Oracle SQL Loader.

Database: Oracle Database 7.3

Confidential

Oracle Developer

Responsibilities:

  • Participate in the re-design of the Department of the Confidential Component Tracking System ( Confidential ) which tracks over 5,000 types of mission critical aircraft and engine components worldwide.
  • Responsible for the development of the PL/SQL procedures, triggers, load routines, and Oracle forms of the new system.
  • Portions of the Confidential application are Web-enabled using Oracle Webserver 2.0.

Tools: Oracle PL/SQL, Oracle SQL*Plus, Oracle SQL Loader.

Database: Oracle 7.3

Oracle Developer

Confidential

Responsibilities:

  • Involved the migration of data from the legacy system to the AIRR. The effort involved the use of PL/SQL 2.3, SQL Plus 3.3, Procedure Builder 1.5, Oracle 7.3, Windows 95, and RISC 6000 AIX UNIX.
  • Picked up the mapping and the deriving of the new data from the legacy systems to the AIRRS system from a previous programmer
  • Acted as lead Oracle Programmer and assisted other team members in solving any Oracle problems related to their processes.
  • Troubleshooter for any hardware/software issues.

Tools: Oracle SQL*Plus 2.3, Oracle PL/SQL 2.3, Oracle Procedure Builder 1.5, Oracle SQL Loader

Oracle Developer

Confidential

Responsibilities:

  • Worked on the Defense Clearance and Investigative Index ( Confidential ) System for the Defense Investigative Service(DIS), an agency of the Department of Defense.
  • Involved in the migration of Confidential from the mainframe to a client server environment using ORACLE Developer 2000 (Form 4.5, Reports 2.5, Terminal 2.1, SQL Plus 3.1, PL/SQL 2.1, and ORACLE 7).
  • Modified the user error message reporting to appear in an alert box rather then the bottom of the screen for improved user awareness of these occurrences.
  • Also, user to eliminate General Protection Faults ( Confidential ) errors in forms developed prior to arrival on project.
  • Additionally modified many forms to correct problems with functionality and performance.

Tools: Oracle SQL Forms 4.5, Oracle SQL Reports 2.5, Oracle Terminal 2.1, Oracle GraphicsOracle SQL*Plus 3.1, PL/SQL 2.1, Oracle Database 7, Oracle SQL Loader.

Hire Now