COMPUTER SKILLS

• Machines: Sun SPARC 420R, 220R Unix Servers, Dell 2440 and 2450 windows 2003 Servers, AIX RISC 6000 Unix Servers, Sun SPARC 10, COMPAQ Proliant servers, IBM PCs, Digital VAX Mainframes, IBM 360 Mainframes, HP-3000 Mainframes, PDP-11.
• Languages: Structural Query Language SQL , Procedure Language SQL PL/SQL 1x and 2x, Unix Shell Scripting, SQL Forms 2x, 2.3x, 3.0x, SQL Menu, RPT/RPF, SQL Report, SQL Loader, Structural Query Report SQR , Quick, Quiz, QDD, Digital Command Language DCL , Basic.
• Databases: MySql 4.0 and 5.0.2, Oracle Relational Database Management System RDBMS version 10gR2, 10g, 9i.x, 8i.x, 7.x 6.x, 5.x and 4.x, HP-Image database, MS-Access.
• Operation System: AIX 5.1 4.2, Solaris 9, 8 2.5, SCO Unix, VMS, MPE, MPEX, Windows NT 4.0, 2003, 2000, 98, 95, MS-DOS and DOS.
• Internet Software: Oracle App Server 10.1.4, 9.0.4, Oracle 9i Release 2 web server, Apache Http server, Oracle Discoverer 5i, Oracle Application Server 'OAS' version 3.0.1, 4.0.8.0.
• Tools: Oracle Designer 9i, Oracle Case 6. Toad Data Modeler v2.25, DOORS 7.1 and 6.0, SQLyog 6.03

WORK HISTORY

Confidential

• Supporting the Naval Airworthiness 40P program office, maintain MySql 5.0.x Open source databases and Apache Http servers on a Sun Solaris Version 9 operating system. Create, setup and maintain VMware Virtual machines, create, update and maintain SQL scripts using SourceGear Configuration management software product.
• Using the Toad Data Modeler tool, re-engineer the Air40P database, identify and created Foreign Key relationship.

Confidential

DATABASE DESIGN ENGINEER

• Install Oracle's 10g Release 2 software on IBM AIX OS 5.2, upgrade via Patch sets to 10.2.0.2. Migrated NAVAIR 6.8.4's Oracle software and application tables from 9.2.0.6 to 10.2.0.2 databases in preparations to migrate to the Navy Marine Corp Internet 'NMCI' enterprise network.. Installed and configured Oracle's Identity Management 'IdM' software version 10.1.4.0.1. Research Oracle's Advance Security Option and its 'Enterprise User Management' features. The research was done to recommend options on how to migrate NAVAIR's legacy user to an Enterprise user environment.
• Installed, configured, maintained, tuned and assisted in the design of a four Tier Oracle Web base application called 'Virtual Status Accounting Tracking System' VSATS . VSATS was license by all E2 and P3 airframe communities including FMS. Also, managed VSATS life cycle management version control support. Design the VSATS hardware and software architecture specification as well procure the SUN hardware and Oracle software and support licenses.
• As the technical team lead, performed Oracle 10g R2 and R1, 9i, and 8i database, Oracle Web application server software 10g and 9i and SUN Solaris 8 and 9 UNIX operating system installation, configuration, and administration. Also, design and created a dynamic TAR and Export/Import software backup procedures using SQL. Install Oracle, SUN and VSATS application software patches. Also performed some Windows NT and 2000 server administration. Created, debug and modified PL/SQL packages, procedures, functions and triggers as well as anything else that is related in creating applications i.e. 'tables, indices, constraints, roles, etc.'. Created UNIX shell scripts, cron jobs and SQL procedures for batch processing.
• Under a development environment, researched and created a Virtual Private Database 'VPD', by creating database context areas and table policy procedures. Create and setup Materialize Views to run as a nightly process, these views would be used by the
• Discoverer 5 ad hoc reporting tool.
• In support of the Integration Logistic System ILS Competency NAWCAD 3.6, perform IBM AIX 4.2 UNIX Administration, Oracle Database 8.0.4, 7.3.4 and 7.1.3 Configuration, Tuning and Administration. Created and maintained an Optimal Flexible Architecture OFA compliant directory structures for Oracle and application software. Install, setup and monitored Oracle Web Application Server software for use by the E2, P3 and E6 airframe communities.

Confidential

• Worked at Confidential corporate office installed, configured and modified an Oracle distributed environment for the business support center department. Created specialized financial and marketing reports, downloaded corporate data using a server-to-server connection via database links.
• Worked on-board the Naval Air Warfare Center NAWC at the Computer Science Directorate CSD . Main tasking was to identify and to solve bottlenecks between the VAX/VMS and the Oracle database.
• Made recommendations on how to stripe application's data files and Oracle system files across the VAX disk to obtain optimal performance.
• Modified SQL Plus scripts and reports to increase query performance.
• Analyzed, created and modified applications indices to increase query performance.
• Created and debugged SQL Forms forms and DCL programs.
• Headed a three person team in developing an Oracle application on a Sun Sparc Station to track P-3 configuration and maintenance data. A module was also developed to track the configuration of P-3 trainers at various sites throughout the U.S.
• Created the Entity Relational Diagram ERD , data flow diagrams and the functional model using Oracle's case tool.
• Create and debugged SQL Forms forms.

Confidential

SR. SYSTEMS ANALYST

• Designed, developed, modified and maintained modules for the NESEA Life Cycle Information System NLCSIS and the Supply and Support Systems Integration SASSI . Both of these applications were in support of the AEGIS Communications System Division.
• Designed data flow diagrams and relational data models to assist in the design of the Oracle RDBMS databases.
• Created SQL Menu menus, procedures and roles.
• Created SQL Forms forms, triggers, and procedures.
• Created SQL Report reports.
• Created import and exports procedures to backup and recover application databases across nodes.

Confidential

PROGRAMMER II

• Developed databases for the DEC VAX/VMS 11/780 using Oracle version 5.1.17 and 4.1 and Hewlett-Packard IMAGE databases for the HP-3000.
• Working from an ERD and Data Element Definition DED , created SQL Forms forms and RPT/RPF reports.
• Maintained the IMAGE databases by providing modifications to schemes and performing file dumps to maximize disk space usage and to enhance performance.
• Provided training for end users on the operation of data entry screens, query screens and production reports.

Confidential

PROGRAMMER I

• An NATOPS flight crewmember on the Electro Magnetic Performance of Aircraft and Ships System EMPASS Project.
• Operated a UNIVAC and Tektronics data acquisition computer system.
• Conducted analog and digital data gathering and reduction operations to provide analysis of radar systems.
• Created and debugged Basic programs using ISAM files.
• Created forms and reports using the IMAGE database.