KERRY MENNE
108 Lincoln
Schertz, TX 78154
(210) 658-7879
Summary Several years of data processing experience
involved in the development of various
business systems. Extensive experience with
relational databases.
Technical Skills
Operating Systems: IBM AIX, HP UNIX, Sun Solaris, Windows 95, Windows 98,
Windows NT, DEC/VAX, Linux
Software: Ingres, Sybase X, Informix, Delphi, Visual Basic,
Vermont Views, Oracle – Designer/2000, Developer/2000,
Discoverer/2000, Toad, Oracle Versions 7.2.3,
7.3.4, 8i, 9i, 10g, 11g, SQL Server
Languages: C/C++, Pascal, TCL/TK, Java, Pro *C, SQL, PL/SQL
Perl, Unix Scripting – C Shell, Korn Shell, bash shell
Experience:
November 2007 to Vista International – Consultant – San Antonio, Texas
Present
• Providing database support in the upgrade of an environmental resource system.
Duties included database design, database creation, creating database procedures
in both Oracle and SQL Server, data migration.
June 2007 to Lockheed-Martin – Consultant – San Antonio, Texas
November 2007
• Developed/Maintained software for the Government
Civilian Personnel System using Oracle HR.
May 2007 to South Texas Blood and Tissue Center - Consultant – San
Present Antonio, Texas
• Wrote PL/SQL code and Unix scripts to automate Oracle backup processes and
report on database processes.
• Continuing to provide support on an as required basis.
February 2007 to Blackfoot Inc. – Consultant – San Antonio, Texas
May 2007
• Developed PL/SQL code and Linux script to create database objects based on
baseline objects.
• Developed ETL processes with Oracle Warehouse Builder (OWB) to populate
database from ascii files.
• Developed SQL script to correct production data.
November 2006 to Lockheed-Martin – Consultant – San Antonio, Texas
December 2006
• Developed/Maintained software for the Government
Civilian Personnel System using Oracle HR.
January 2006 to Dell Computer Corporation – Consultant – Austin, Texas
October 2006
• Rewrote Summary End of Day process to enable running for multiple days and
added restart capabilities. Process consists of Oracle packages and Linux
scripts.
• Worked on Archive/Purge application consisting of several Oracle packages and
Linux scripts. Application archives data from several tables – then purges this
data at a later time.
• Worked on a data transfer application consisting of Oracle packages and Linux
scripts. Application transfers data to another instance via a dblink, massages
the data and loads into new tables.
• Worked on production defects and enhancements.
January 2005 to Randolph Air Force Base – Consultant – San Antonio, Texas
January 2006
• Developed/Maintained software for the Air
Force Personnel System using Oracle HR. Majority of work was done in PL/SQL
with some minor forms and reports work.
May 2004 to Dallas Morning News – Consultant – Dallas, Texas
December 2004
• Created Oracle views and PL/SQL packages for customizing a third party
software product.
March 2001 to Verizon – Consultant – Dallas, Texas
February 2004
• Wrote Oracle PL/SQL code and shell scripts for a data conversion project.
Also merged data from a Bell Atlantc system with the current Verizon using a
combination of Unix scripts, SQL*Loader, ‘C’ programs and PL/SQL.
• Wrote/modified ‘C’ programs, Pro *C programs, PL/SQL packages and Java
programs for the new system.
• Tuned queries using TKPROF and DBMS_PROFILER.
• Created/Modified PL/SQL packages to adhere to the new business rules.
• Developed several ah-hoc processes to update production
data.
March 1999 to Chase Bank – Consultant – Arlington, Texas
May 2001
• Designed Oracle databases and wrote shell scripts and
PL/SQL procedures to import data into the databases.
• Created Microsoft Access application to access Oracle
database via ODBC connection.
• Wrote 'C' program on a Unix machine to interface with
a IBM mainframe machine via socket connection.
• Worked on a check archiving system – done in ‘C’ using
Oracle OCI database calls and Visual Basic.
October 1998 to Kaiser Permenente/Sierra Health Choice – Consultant –
Dallas, Texas
April 1999
• Performed Sybase DBA functions, Oracle DBA functions
and SYS ADMIN functions.
• Administered and maintained HCI Database engine – TCL/TK
and PERL. Later wrote Sybase ‘C’ programs with embedded
SQL to eliminate use of HCI engine.
• Wrote shell scripts and CTL files to import data into
a Oracle database via SQL Loader for data retention.
October 1997 to GTE – Consultant – Dallas, Texas
August 1998
• Developed PL/SQL code and shell scripts for a data conversion project.
• Modified PL/SQL code for the new system.
• Did SQL tuning using TKPROF.
October 1995 to Southwestern Bell – Consultant – Dallas, Texas
September 1997
• Worked with a Oracle team to convert a existing
Unix based SYBASE application to a Oracle
forms application – maintained and enhanced after
application put into production.
• Developed Oracle 'Pro C' programs to load and extract
data from the Oracle database.
May 1995 to Anderson Consulting – Consultant – Dallas, Texas
October 1995
• Developed/Modified 'C/C++' programs with embedded
SQL to import data into SYBASE databases.
• Developed SYBASE stored procedures to interface
with a Powerbuilder application.
July 1994 to Mobil Oil – Consultant – Dallas, Texas
April 1995
• Worked in a team environment in the development of a
Global Geology application using C/UNIX/INGRES.
• Developed a automated GUI testing system using
XRunner from Mercury.
May 1994 to Neiman Marcus – Consultant – Dallas, Texas
July 1994
• Developed a Database Conversion program.
• Developed a screen interface program using curses.
• Completed a PC to mainframe upload/backup program.
April 1989 to Southwestern Bell – Consultant – Dallas, Texas
April 1994
• Developed and maintained various database application
using 'C', Vermont Views, Informix and Sybase.
• Served as a backup to the Sybase DBA.
July 1985 to McDons Inc – Programmer – San Antonio, Texas
April 1989
• Served as a programmer in the development of a triple
option Medical Claims Insurance system. Software was
UNIX/C and INGRES.
• System Administrator and Database Administrator.
|
