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:

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

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

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.

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.