Software System

Dennis LeRoy Williamson

Address: *** ***** ******, *********, ** 32507-2839

Home: 850-***-****

abnl27@r.postjobfree.com

SUMMARY

Experienced Web Developer, Database Designer/Programmer experienced in Oracle APEX

2/3 (formerly HTML-DB), ColdFusion MX 6/7/8, PERL 5.8, Active Server Pages (legacy),

Oracle PL/SQL and Microsoft T-SQL stored packages, procedures, functions and data

types. I have experience with Informix, Tandem Non-Stop SQL and MySQL RDBMS. I have

experience with the following operating systems: UNIX, Sun Solaris 8/10, Windows

NT/XP/2003/2005, IBM AIX, and Tandem Guardian OS. I have designed and written an

ASP .NET and Windows Script Host program to handle medical interface to a vendor web

service.

PROFESSIONAL EXPERIENCE

General Dynamics Information Technology, Eglin Medical Clinic, 9/2/2008 - 8/28/2009,

Associate Software Engineer, Supv: Mrs. Vicky Betancur, 850-***-****

Design, write, test and debug PL/SQL stored packages, procedures and functions,

•

Design, write, document, train and implement military training software for capturing and

maintaining medical training records.

Designed and implemented a ColdFusion MX 8 application for searching XML based

•

medical transcriptions using search criteria that returned matched records for data

containing potential cancer patients. Used the Verity K2 search engine against the

medical transcriptions collection. This automated a function that was previously done

manually by looking through printed and digital reports, a lengthy and error prone

process.

Reworked and enhanced an existing APEX 2.0 medical records system. I split the system

•

into two parts to allow more control and reporting capability to the distinct Medical

Release and Medical Disclosure HIPAA data.

Designed and implemented a medical appointment scheduling and tracking system for

•

the Vascular Surgery Center. The system was written using the Oracle APEX language.

Designed and implemented a Bariatric Surgery software to track patient visits for weight

•

loss, body mass index and fluid removal and fluid fill for lap band surgery. The system

was written using the Oracle APEX language.

Designed and implemented Windows Scripting Host program using the SOAP 3.0 toolkit

•

to connect to a vendor Web Service and request medical dictations using various

parameters configurations. Received and processed the dictations into Eglin server.

W rote PERL 5,8 programs to extract, transform and load data from XML format into

•

delimited file format using extensive regular expressions. Designed and implemented

ASP .Net programs to insert medical dictations into an Oracle database using PL/SQL

stored procedures.

Zycron, Inc., TVA, Muscle Shoals, AL Jan 2 2008 - Apr 28,2008,

Oracle 10g PL/SQL Developer, Supv: Mrs. Lisa Bareis, 256-***-****

Design, write, test and debug PL/SQL modifications to the Tennessee Valley Authority,

•

Watts Bar Nuclear Plant Number 2. This is a Java 2EE based system that uses

extensive PL/SQL stored packages, procedures and functions running on Sun Solaris

Unix based OS platform. The back end database system is an Oracle 10g RDBMS.

Platform: Sun Solaris 10 UNIX OS, and Windows XP Professional. Use Toad and SQL

Developer IDE to develop stored procedures and functions. I am interfacing directly to the

Java JSP and Java Servlet code base (MVC), and I am learning the Java side of the

system.

I am working as a contractor on this project. The project is scheduled for six months,

•

from January 2008 through July 2008. I returned to my home in the Pensacola area after

the second phase of the project was postponed in mid April 2008 for six months.

Planned Systems International, Maxwell-Gunter Annex, Montgomery, AL Aug 07 - NOV 07

ColdFusion Programmer, Supv: Mr. Steve Williams, 334-***-****

Design, write, test and debug modifications to the U. S. Air Force Medical Web Omnibus

•

Systems. This is a ColdFusion MX 7 system that uses extensive ColdFusion

components (cfc) and the ORACLE 10g RDBMS. Platform: Sun Solaris 10 UNIX OS,

and Windows XP Professional. Use Dreamweaver 8 and SQL Developer as IDE.

Designed, developed and tested PL/SQL procedure that reduced the previous embedded

•

SQL statement from 38 seconds down to 1.5 seconds. I also designed and implemented

a PL/SQL package that replaces an embedded SQL statement that times out on long

queries (1 hour 20 minutes). The replacement query runs in 5 minutes and 15 seconds

with correct results. I have experimented successfully with BULK LOADS and

VARRAYS. I held an Industry (Contractor) 3RTH3-I, DoD Secret clearance on this job.

I returned to my home in the Pensacola area after the U.S. Air Force converted all of its

•

computer programmers to other career fields. This extended the contract from one year

to a five year contract. I left since five years was to long a period to be away from my

home in Pensacola, Florida.

Global Business Solutions, Inc., Pensacola, FL, Feb 06 - May 07

SR. Integration Specialist, Mrs. Terri Ramos, 850-***-****

Integrate HP Open Source (Peregrine) Connect-It software products for extracting,

•

translating and loading (ETL) of Navy asset data into the Navy Education and Training

Command (CNET) AssetCenter Management System.

Personalize the HP Web Portal software for customized TAMS web forms, to all CNET

•

claimants to have real-time access to asset data in order to manage, procure, determine

Total Cost of Ownership, asset status, warranty status, and support costs.

Design, write and implement Crystal Reports V10 and ColdFusion MX Report Builder for

•

tracking and managing enterprise assets and their changing relationships throughout the

entire asset lifecycle.

Design, write, test and implement web based programs using Coldfusion MX 7,

•

JavaScript, CSS, and T-SQL stored procedures for database applications running on MS

Win 2000/XP and SQL Server 2003 RDBMS, to allow view and limited update capability

against the AssetCenter database.

Ensured that all web pages met Section 508 compliance and presented proper content to

•

government and public users.

Designed and implemented ColdFusion MX 7 programs for data upload to SQL Server

•

RDBMS and searches of AssetCenter collections of related documents and database

queries using the Verity K2 server.

Administer SQL Server 2003 RDBMS tables, stored procedures and user security

•

information. Knowledgeable of Data Transformation Services for ETL of various data

from/to SQL Server RDBMS.

Upgraded to CFMX 8 on my desktop in August 2007 for my own learning experience.

•

Production development was done under the Navy’s production server using CFMX 7.

Escambia Board of County Commissioners., Pensacola, FL, May 04 - Jan 06

SR. Applications Systems Analyst, Supv: Mr. David Musselwhite, 850-***-****

Design, write and implement Web based systems using Coldfusion MX 6/7, JavaScript,

•

SQL, PL/SQL and Oracle rapid development product APEX (HTML DB), for database

applications running on IBM AIX OS and Oracle 9i relational database software.

Design and implement web based software for the county Workfare system, the

•

Escambia Stormwater Pond System, Water Impairment System to track and report

maintenance and warranty information.

Designed and implemented several customer survey programs using ORACLE 9i and the

•

HTML DB Rapid development software.

W rote PL/SQL and CFMX stored procedures and functions. The county GIS team used

•

data from tables I designed and programmatically populated to create layers for data

mapping.

Implemented ColdFusion programs to allow data upload into RDBMS and UNIX file

•

system. Converted ColdFusion 6 to ColdFusion 7.

Tested all new software and enhancements to ensure program correctness and that

•

usability standards were met. Ensured that all web pages met Section 508 compliance.

Designed and implemented reports using ORACLE SQL Plus and ColdFusion

•

ReportBuilder.

USAF Legal Services Agency (AFLSA), Montgomery, AL, Jul 01 - Jan 04, (Retired)

Computer Specialist GS-12, Supv: Mr. Craig Carter, 334-***-****.

W eb Programmer/Webmaster for worldwide websites hosted on (AFLSA) web servers.

•

Maintain web site, provide worldwide customer service, and manage user accounts,

•

UNIX system security and web server security.

Design and write dynamic web pages and applications using PERL 5.6, PHP, MySQL 4.0

•

relational database, JavaScript, DHTML, CSS, and XML.

Designed and implemented the USAF Judge Advocate General main Web Portal page

•

using advanced web design to allow for dynamic web content management to USAF JAG

officers and paralegals at bases worldwide.

Designed and implemented the AFLSA Electronic Publishing Content Management

•

system which allows non-programmers to upload and maintain dynamic web content

without formal training in web programming. This saves the Air Force travel cost,

instructor cost and allows military members to perform other military duties.

Ensured that all software changes/enhancements/ new systems were thoroughly tested

•

and validated in accordance with established JAG and U.S. Air Force testing policies.

Ensured that all web pages met Section 508 compliance.

Routinely tested JAG web sites to ensure proper content was being presented.

•

Designed and developed content management systems for the Office of Professional

•

Responsibility, Cyber Warfare, and other U.S. Air Force JAG web sites. The systems I

created were designed to allow site Webmasters to review the proposed content in real-

time, in a non-production environment. The web monitors were able to enable or reject

the proposed content via this monitoring facility at their discretion.

Manage the Xerox DocuShare electronic web based document retrieval system for

•

local/remote users.

Administer user accounts and file permissions on Sun Solaris 8 OS servers, Red Hat 7.2

•

servers and Windows NT servers for adjunct webmasters of more than ninety Air Force

web sites which are hosted on servers, at Maxwell AFB.

Familiar with Apache Web Server configuration.

•

Taught PHP programming skills for database connectivity to advanced adjunct web-

•

masters at annual formal training classes.

Received a performance awards for two consecutive years for web programming and

•

systems security.

Received USAF Secret Security Clearance in November 2002.

•

US Army 5th Signal Command, Mannheim, Germany CMR 421 APO AE, JAN 97 – Jul 01

Computer Specialist GS-12, Supv: Ms. Michelle Curtis, 011 49 621-***-****.

Team member on high visibility web based relational database system, which matches

•

soldiers with their sponsors for their European tour of duty. This web system is now

successfully used in Europe, Korea, and Alaska and is being considered for use by the

US Air Force.

Designed and implemented web software to allow database maintenance and shopping

•

cart style equipment checkout by customers. This software is used daily to manage

highly sensitive and expense network surveillance and troubleshooting equipment used

in Bosnia and Kosovo. The system was written using DHTML, ASP, JavaScript, VBScript,

and ADO using Access 97 and SQL Server 6.5 database, T-SQL stored procedures and

functions.

Designed and implemented the European Automated Abbreviated Ground Accident

•

Report (DA-285) in ACCESS 97. This software is currently used by throughout

USAREUR, Korea and by the US Army Materiel Command (AMC).

Systems and database administrator for all development and production Win NT 4.0

•

application servers, SQL 6.5/7.0 database servers, and IIS 4.0 web servers.

Configured and installed all security service packs and hot fixes for these servers.

•

Ensured that all software changes/enhancements/ new systems were thoroughly tested

•

and validated in accordance with established division and Army SDLC policies.

Received one Special Act Award, two Sustained Superior Awards and a Performance

•

Award for web database programming while at the 5th Signal Command.

NOTE: This agency consolidated the old U.S. Army ISEC personnel (Feb 89 – Oct 90).

•

Defense Commissary Agency, Einsiederlhof, Germany APO AE, Sep 94 – Jan 97

Computer Systems Programmer, GS-12, Supv: Mr. Ruddy Goulet, DSN: 489-7301

System and Network administrator for the DeCA European Region, spanning 11

•

countries, 5 time zones, 49 stores and over 120 HQ users.

Handled help desk, and responded to problems involving functions related to personal

•

computer usage and Email usage. Installed, configured PC hardware, software and

networking.

Troubleshot and resolved hardware and software work stoppages allowing unfettered

•

access to the DeCA European network.

E-mail administrator for over 200 users of 3 different E-Mail packages, to include MMDF-

•

II on AT-T 3B2 UNIX, Novell GroupWise on SCO UNIX, and Eudora on UNIX platform.

Developed a test bed environment to support online testing and debugging of E-mail and

•

office automation problems across the European theater.

Database administrator for DOD property book system (DPAS), which runs on Informix

•

RDBS. Installed and tuned UNIX OS on three AT&T 3B2 servers.

Installed and maintained Novell Netware and Microsoft 3.11 peer to peer on LAN at HQ

•

buildings and remote Commissary offices across Europe.

UNIX Systems Administrator for three AT&T 3B and two SCO Intel PC based servers

•

My administration skills kept these five UNIX servers operating for over two years without

any unscheduled downtime.

Also installed, configured and maintained all personal computers, networking equipment,

•

Network File System software, Internet Protocol software, and desktop application

software suites for over all HQ users and commissary users at over 65 stores across

Europe.

Established, configured and maintained DeCA web site to allow immediate file upload

•

and download of critical current price list and other important information for DeCA

personnel via the Internet.

Served as the Information Systems Security Officer for DeCA European Theater.

•

Helped trouble-shoot backbone communications infrastructure at HQ and in

•

commissaries.

Defense Commissary Agency, Ft. Lee, VA, Sep 92 – Sep 94

Computer Systems Programmer, GS-12, Supv: Mr. Jim Austin, 804-***-****

UNIX System and Oracle Database Administrator for DeCA's six billion-dollar annual

•

vendor bill paying system named SAVES. SAVES runs on four Sequent SMP mini-

computers, the DYNIX/pTX OS, a UNIX based operating system, using ORACLE V6.0

RDBMS.

Served as the primary Information System Security Officer for DeCA Conus. Handled all

•

UNIX and ORACLE security for 950 plus users.

Served as the alternate Terminal Area Security Officer (TASO), working daily with DeCA

•

regional TASO's to ensure tight security.

Set up security measures that met or exceeded the DOD-IG strict requirements.

•

W rote approximately 6 adhoc SQL-PLUS and PL/SQL queries daily. Tested each query

•

against test database to prove correctness of output. The output from these queries

was used by DeCA’s Commanding General to brief congress on the effectiveness of the

Commissary Agency in its massive bill-paying efforts.

Configured and implemented helpdesk software package for DeCA. Wrote 'C' and PERL

•

and AWK programs to help resolve bill-paying problems.

Designed a password generation and distribution system for password administration at

•

six national regional offices and DeCA HQ every 120 days.

Met every password change requirement without delay and never had a security breach

•

during my watch as security administrator.

Installed dYNIX/pTX (Unix System) and Oracle Database software and upgrades for

•

Sequent SMP mini-computers and ORACLE RDBMS.

Defense Logistics Agency (DOSO), Richmond, VA, Oct 90 – Sep 92 and May 86 – Feb 89

Computer Systems Progr, GS-12, Supv: Mr. Samuel A. Wright 804-***-****

System/Network Administrator for DLA's Integrated Material Complex real-time

•

warehouse control system, using a TANDEM fault-tolerant, SMP, minicomputer system.

Designed and implemented a real-time, transaction processor monitor system using

•

parallel programming techniques using the Tandem Applications Language (TAL).

This software increased the usable communication transaction load by over 220 percent

from the previous TP monitor's transaction rate.

Performed extensive testing of the TP monitor to ensure correct handling of each

•

transaction type. Worked with DLA Analyst in system testing of the Tandem TP monitor’s

connectivity with the IBM TP monitor to ensure all transactions were handled properly

and within the strict time limits required by our real-time warehouse control system.

Installed, configured software for the GUARDIAN 90 OS and SNA communication

•

software. Built and installed RS-232C cable and connectors from Tandem VLX 6100

CSS to cluster controllers,repeaters, workstations and printers thru-out an extremely

large (23 acres) warehouse building. Installed workstations for packing, receiving,

shipping and management. These were Microsoft MS-DOS and SCO Unix WS.

Helped design and write implementation plan for all hardware and software to include

•

communication equipment for the Defense Distribution System (DDS) at Sharpe and

Tracy depots.

Integrated TANDEM mini-computer, IBM mainframe, communication controllers and PC

•

workstations throughout two extremely large and widely separated warehouse complex's,

to provide connectivity between NAVY developed, and DLA developed warehouse

control systems.

Designed and wrote relational database applications using Tandems COBOL and

•

SCOBOL languages against the Tandem Non-Stop SQL database engine.

I worked at this agency before and after tour in Europe with the U.S. Army (ISEC).

•

Army Information Systems Engineer CMD (ISEC), Zweibruecken, GE, Feb 89 – Oct 90

Computer Systems Programmer, GS-13, Supv: Mr. Phillip Evans 901-***-****

Technical team leader of European Community Automation System. Led six civilians, five

•

Army and ten contractors in successful Information Engineering project.

W orked actively in Joint Planning Requirements, Business Area Analysis, and Joint

•

Application Design workshops.

Used IE methodologies and CASE tools to design the relational database.

•

Led UCAS team in all phases of required Army Software Development Lifecycle Testing.

•

This included module testing of each independent program, integration testing of

subsystem module interfaces, system testing of all subsystems working together,

installation testing before baseline was packaged, and finally acceptance testing at the

user work site.

Designed and implemented version control software to manage the source code baseline

•

in 'C' language using CURSES windowing API and ORACLE Forms.

Attended meetings with USAREUR HQ functional proponent.

•

Led meetings to set priorities and timelines for system development.

•

W rote weekly status reports and gave oral presentations at meetings. This system was

•

successfully implemented across Europe and drastically reduces the time each troop

must spend at in-out processing checkpoints. This allows Army military personnel to

begin work very quickly after arrival in country.

All programming was done on UNIX System V OS using 'C' Language, Oracle Version

•

4.0. Received a Special Act Award and a promotion to GS-13

Returned to DLA job in CONUS (USA) during this tour in Europe because of wife’s illness

•

that required stateside treatment.

Army Information Systems Engineer CMD (ISEC), Zweibruecken, GE, Feb 89 – Oct 90

Computer Systems Programmer, GS-13, Supv: Mr. Phillip Evans 901-***-****

Technical team leader of European Community Automation System. Led six civilians, five

•

Army and ten contractors in successful Information Engineering project.

W orked actively in Joint Planning Requirements, Business Area Analysis, and Joint

•

Application Design workshops.

Used IE methodologies and CASE tools to design the relational database.

•

I was promoted from GS-12 to GS-13 for quality of work performed at ISEC Europe.

•

EDUCATION: Approximately 2 years of college ( 70 Semester hours ).

Visual Basic .NET, Pensacola JR. College, Pensacola, FL, GPA 4.0, 3 Sem Hrs

•

JAVA Programming, Pensacola JR. College, Pensacola, FL, GPA 4.0, 3 Sem Hrs

•

CISCO Routing, Trenholm State Tech College, Montgomery, AL, GPA 4.0, 6 Sem Hrs

•

Computer Programming, John Tyler Comm College, Chester, VA, GPA 3.88, 18 Sem Hrs

•

Computer Program, Tallahassee Comm College, Tallahassee, FL, GPA 4.00, 18 Qtr Hrs

•

Basic Studies, Florida State University, Tallahassee, FL, GPA 1.70, 28.5 Sem Hrs

•

Specialized Training:

Peregrine AssetCenter 4.x Scripting

•

Peregrine AssetCenter 4.x Connect-It

•

Peregrine AssetCenter 4.x Essentials

•

Peregrine AssetCenter 4.x Tailoring

•

TOAD V7.0

•

ORACLE 8i SQL Statement Tuning

•

ORACLE 8i ADV PL/SQL

•

ORACLE 8i PL/SQL

•

PERL 5 Programming

•

W eb Programming using PHP/MySQL

•

Basic HTML/CSS Class

•

Java Programming (SAIC)

•

W eb Programming/Advanced Web Programming

•

NT 4 Core Tech/Administer NT

•

SQL Server 6.5 Administration

•

ORACLE DataBase Administration

•

Electrontic Data Interchange Classes (3 classes)

•

DYNIX/pTX System Administration

•

UNIX Bourne Shell Programming

•

UNIX System Administration

•

UNIX Internals

•

Software Systems Testing For Quality Assurance

•

Structured Design Workshop (Ed Yourdan, Inc.)

•

Currently studying the Ruby (RoR) and Python dynamic languages at home.

•

Contact this candidate