Candidates About

Terry K. Lawson


SUMMARY:


Terry has over 15 years of IT experience. Terry has worked on a variety of database management systems including ORACLE, INFORMATICA CITRIX, JBOSS, ERWIN, and various operating systems including UNIX and MS WINDOWS. He has an extensive background in various languages which include: SQL, UNIX Shell scripting, Crystal  Report), C, and C++. His applications experience includes Database, Manufacturing, Retail, Insurance, Government, and DoD.


EDUCATION:

Java seminar given by Metro IT Consulting group, 2001.

Oracle DBA class given by Oracle Education group, 1997.

HTML seminar at Sinclair Community College, 1996.

M. S. in Computer Science from Wright State University, 1992.

CONTRIBUTIONS:

Consilium1, June 2006 to Present

·         Administrated IFS 2004 and App 8 (Oracle-based ERP using Oracle 9 and 11g)

·         Performed user access administration including directly communicating with users

·         Worked in development, quality assurance and production environments

·         Configured and ran JBOSS 5.1 middleware software on a number of servers

·         Administrated a number of Windows 2003/2010 server boxes

·         Assisted with application testing including installation of software deliveries

·         Lead project for BSE141 decommission using Informatica 9.6 technology

·         Troubleshoot and fix issues with IFS Client and FS Connect user roles, security, and access

·         Troubleshoot and fix issues with Oracle database availability and correctness

·         Troubleshoot  and fix issues with Informatica workflows

·         Troubleshoot and fix issues with data warehouse

·         Wrote hundreds of PL/SQL routines for data mining, reports, and data repair to the Oracle 11g database

·         Installed and worked with Crystal reports

Internal Revenue Service, January 2002 to May 2006

·         Examined tax returns by individuals.

·         Utilized Windows NT, Microsoft Office products.

·         Performed help on debugging desktop problems.

Metro Information Systems, November 2000 to October 2001

·         Participated in the systems design and implementation of enhancements to programs that handle
proposals/orders, distribution, and invoicing for a manufacturing company.

·         Developed using embedded SQL in COBOL interacting with a SYBASE database that
runs on IBM AIX.

·         Wrote UNIX shell scripts and CRON script to transfer files using ftp utility. Also utilized TSO on IBM mainframe and POWERBUILDER.

Terry K. Lawson
Page 2

Software Synergy, March 1999 to October 2000

·         Implemented stored procedures using Oracle PL/SQL.

·         Loaded tables using SQL*LOADER.

·         Utilized data modeling software ERWIN

·         Worked with Microsoft Visual Sourcesafe

·         Implemented stored procedures using Sybase Transact-SQL for a health insurance company

·         Worked with CLEARCASE versioning software

·         Wrote procedure using Oracle Pro*C (C with embedded PL/SQL).

·         Interfaced Oracle data to PEOPLESOFT modules.

·         Utilized Windows NT, Microsoft Office products.

Data Networks, December 1996 to March 1999

·         Participated in the systems design and implementation of a DoD-wide metadata
repository.

·         Installed ORACLE 8 software on Windows NT server.

·         Worked with various Oracle 8 administrative tools.

·         Loaded tables using SQL*LOADER.

·         Utilized data modeling software ERWIN.

·         Wrote procedure using Oracle Pro*C (C with embedded PL/SQL).

·         Designed and implemented a distributed database for Joint Total Assets Visibility office.

·         Participated in the programming and design of EC/EDI database input
program for DOD-based procurement system

MITI, August 1994 to August 1996

·         Participated in the quality assurance design and testing of the SQL (Brio Reports) language.

·         Programmed in SQR, SQL and C.

·         Wrote stored procedures using Oracle PL/SQL, Sybase Transact-SQL, and Informix SQL, with the majority of work in Oracle.

·         Tested SQR with PowerBuilder which allows users to execute SQR reports remotely.

PCS, December 1993 to July 1994

·         Participated in the program design, programming and testing of a warehouse distribution system.

·         Implemented using ORACLE 7.0, SQL*FORMS, SQLPLUS, PRO*C, and SYSTEMS
ARCHITECT.