Website: www.turnersoft.com

SKILL SETS

Programming:	Visual Basic 6.0, 5.0, 4.0, 3.0, Oracle SQL, SQR, MS SQL Server SQL, MS Access SQL, VBA, VB Script, Clipper, dBase III, DBXL, GW-Basic.

Web Tools:	Dreamweaver, FrontPage, Adobe PhotoShop, Photo Impact, LView Pro, HTML, VBScript, Java Script, Fireworks, Flash, Shockwave, VB.NET.

ODBC etc.:	ADO, RDO, DAO, VBA, COM and 3-Tier apps

Database:	Oracle 9i - 7.3, MS SQL Server 2000 - 6.5, MS Access 2002 - 2.0, DBase II - IV, Clipper 87 – 5.01

3^rd Party Tools:	Stinga Bee Grid Pro, Apex True Bee Grid, Video Soft, Sheridan, Lead Tools

Operating Systems:	Win2K Pro, Win98, WinNT 4.0, Windows 3.x, DOS

Networking:	Windows 2000 Server, Windows NT Server 4.0, 3.5

EXPERIENCE

Computer Sciences Raytheon – Turner Software Consultant – June 2002 to February 2003.

Project Lead in the AIS to Maximo conversion for CSR. The scope involved forty-five customized JSP screens, one custom application, sixty-one custom reports created with Actuate Report Designer, a full data conversion at two different sites, comprehensive documentation, and a complete training guide including on-site training. Training at site 1 was delivered from November 5, 2002 thru November 11, 2002. Site 2 training was delivered January 29, 2003 thru February 4, 2003. All development for the project was accomplished at Turner Software. Turner Software’s FTP site was used to transfer files during the project.

Established and completed a one-year maintenance contract for support of the AIS project. Completed two upgrades to AIS through fixed price agreements.

Network-Resources, Inc. – Senior Systems Integration Engineer – January 2002 to May 2002.

Developed SQR program that parses text for Maximo Job Plans. Provided support to convert a Hazardous Material Management System to Maximo standards. Created full conversion script for Equipment, PM’s and Job Plans from spreadsheets to Maximo.

Yang Enterprises, Inc. – Turner Software Consultant – November 2000 to September 2001.

On-site data conversion of KIMS-to-Maximo and Access 97-to-Maximo. Completed a joint effort, which streamlined the Maximo ordering process for scheduled or unscheduled bench stock replenishment. Initially wrote an SQR program that converted hierarchical text data into Oracle. The program also provided Purchase Order data for the Maximo conversion project. Co-Designed and implemented a Hazardous Materials program comprised of fourteen screens, eleven triggers, and a fifteen-table data conversion using Maximo’s Custom Application features. System was completed, accepted, and implemented in six weeks in an effort to meet an Award Fee deadline.

ExecuSys, Inc. – Software Engineer – May 1997 to August 2000.

Project Lead for AIS (Automated Inventory System). The scope required combining the functionality offered by two different programs into one. The entire project was completed on-site at Patrick AFB and lasted seven months. Implementation was accomplished with a conversion program I wrote. CSR sent a programmer to Ascension Island and Antigua Island while I provided phone support.

Programmer for GEMS (Graphical Enterprise Management System), a commercial product.

§ Wrote a setup utility, Builder, that provided drag and drop design for rapid setup of GEMS GUI interface. Builder filled GEMS system tables with screen and object information from user selections.

§ Updated Chart Tool and StructOrder, also GEMS utilities, to fill system tables and included transaction processing for those programs as well. Updated GEMS interface with dynamic pop-up menus to provide a more user-friendly selection process for users.

Programmer at Patrick AFB.

§ Converted two Oracle Forms applications to Visual Basic 4 then VB 5 a year later.

§ Wrote a Visual Basic 5 application that publishes content to a web site. Run as a service app, it polls a database for updated or new files awaiting publication to the web. When a file is found, it stores the current file in MS Source Safe then publishes the new file and timestamps the event.

DESIGN

AIS – Automated Inventory System

Designed and developed an ODBC compliant inventory system written with Visual Basic 6.0.

§ The interface was designed to run on Windows 95, 98, and NT but also runs on Windows 2000 and XP. Coded in Visual Basic 6.0, AIS is ODBC compliant and can access data on Oracle, SQL Server, or MS Access.

§ The AIS has an extremely small footprint and will run on any 32-bit Windows software with a minimal configuration. No hardware specs are necessary when the operating system is stable.

§ Program provides cradle-to-grave tracking of inventory. Functionality includes Issues and Transfers, Excess Management, Receiving, Maintenance, Purchase Orders, Tool Management, Reports, Value Lists, Companies and Addresses, Barcode integration, and Jet Forms integration. The AIS provides tracking of stock and non-stock items, tools and equipment asset management, user-defined physical inventory, configurable audit trail with archive options, maintenance module using required government standards, value list management, search engine, customizable reporting, printing, and export-to-spreadsheet features, and more.

DbToDb – Database To Database

Designed and developed a tool for converting data from one database to another. The system is designed to speed up database conversion efforts. DbToDb operates from a proprietary scripting language and provides the following options for the SQL Programmer.

§ Eliminates most data type migration requirements using the data dictionary of each database and matching up data types using ODBC standards. Data type migration problems are usually time consuming to find, especially when overlooked.

§ Provides unlimited database connections so data can be pooled from multiple sources.

§ System uses transaction processing allowing the programmer to provide an all-or-nothing update with a group of update statements and be confident of data integrity.

§ Provides variable setting to insure data consistency.

§ The program will halt on all errors. If an SQL error has occurred, user can opt to edit and retry.

§ DbToDb will shell to another program, pass parameters, and wait for the program to finish before it continues. It can also Copy, Delete, Rename, and Backup specified files that will be restored upon failure.

DbRenew – Database Export/Import

Designed and developed an automated database export/import utility. The system was designed initially for MS Access.

§ DbRenew is currently being developed to provide the same functionality for SQL Server and Oracle databases.

§ DbRenew automates database-tuning procedures normally performed by a DBA.

WinPut – Windows Screen Capture

Designed and developed MS Windows screen capture utility that uses MS Windows Hot Keys. WinPut has become a popular documentation tool among colleagues and the commercial version is soon to be released.