Sign in

Engineer Developer

Denver, CO
August 11, 2012

Contact this candidate


Thomas Hansford

**** *. ******* **.

Aurora, CO *0014



Informix 5.X, 6.0, 7.X, 8 XPS, 9.X, 10.X Oracle 8i, 9i, 10G

Solaris C-ISAM



Performance tuning SPL


Shell scripting SED, AWK, etc

I-4GL Data Analysis

Oracle Designer Power Designer

C Language Data Modeling Database Design OnBar

PL/SQL Data Flow Analysis


OEM Grid Control Capacity Planning

RMAN Linux


Oracle Designer Backup/Recovery

I-SPL Software Development

CAREER OBJECTIVE: A position as an Informix Developer where good technical and people skills would be assets.


2011-Present. Independent database consultant. Acts as an independent contractor in the area of database design and development. Currently working on an enterprise data management solution for a small behavioral health company.

2010-2011.Neways International. Informix 4GL developer. Acted as a Sr. software engineer. Duties included developing new forms, reports, and programs, applications, and software maintenance for a Multi-Level Marketing Company. Used Informix 11.5 on HPUX. Coded in, I-4GL, ESQL/C, and UNIX shell scripts. Used the Interactive debugger, and other tools as required.

2009-2010. Diversified Software Resources. Worked as an Informix Consultant. Duties included software development using Informix 4GL, UNIX SHELL SCRIPTS, and ESQL/C for Insurance applications. Data modeling using tools like power designer and Erwin for new table design and creation. Query tuning and optimization. Wrote stored procedures and triggers. Performed data flow analysis and data migration from multiple legacy systems.

2009-2009. CIBER, Inc. Worked as an Informix Database Consultant. Developed new tables, performed data analysis and conversion. Performed normalization processes on a State of Wyoming minerals management system. Designed databases, performed, capacity planning, and application enhancement and tuning. Used 4-GL, Unix shell scripting, ESQL/C. Power designer, and converted MS-SQL tables to Informix.

2008-2009 Allied Solutions Group. Worked as a contract Informix Developer. Duties included database modeling and design. Data and database analysis, monitoring, tuning, coding in I-4GL, ESQL/C, and UNIX shell, data archiving, production system support, and day to management of several large databases. Responsible for Object creation, backup and recovery, Performance tuning and analysis (over 6 Terabytes)(Informix 9.X & 10.X).

2007-2008 Colorado Secretary of State’s Office. (Informix Developer) Worked an Informix Developer with light DBA duties. Duties included data definition, schema management, database design, data and database management and analysis using PowerBuilder 9.X. Responsible for client support on all data/database issues. Reporting and SQL tuning support for other programmers. Coded in SPL, I4-GL, and ESQL/C.

2007-2007 Robert Half Technology. Worked on an Informix Project to re-engineer and re-write the inventory reporting system. Used Informix 4GL, SQL, ESQL/C, Unix Shell, stored procedures and triggers. Used DDL for table and index creation.

2005-2006 ExtraQuest. Informix Developer. Worked as an Informix Developer for a large Insurance Company. Duties included application Software Development, database analysis and design, monitoring and tuning, backup and recovery. Used shell scripting, SQL, I-4GL, SPL, and ESQL/C for application support for several large production database applications.(Informix 7, 9,8 XPS and 11.X).

2003-2005 CONSULTNET. Worked on a Bureau Of land management project as a Sr. software engineer. Acted as project lead on several small projects. Used C language, I-4GL, SPL, triggers, stored procedures, packages, etc., on mineral management applications. Performed light DBA tasks, application development, support, and application enhancements in an Informix/HPUX client server environment.

2002-2003 Sherwood Foods. Worked as an Informix Developer for a food distribution company. Duties included the design of screen forms, reports, and application software design duties. Responsibility for application maintenance and enhancements. Programmed in shell script, I-4GL, and SPL and C language in an SOLARIS/INFORMIX database environment. Worked on inventory and supply chain application.

2001-2002 Manpower Professional Services. (Contractor) Worked as the INFORMIX Developer for a trucking company. Duties included systems analysis of old and design of new software. Wrote triggers and stored procedures for the Informix database. Wrote UNIX shell scripts (Korn shell) and SQL queries against the database. Created forms, reports, and utilities using Informix tools. . Full life cycle development.

1999-2000 Analysts International. (Contractor) Worked as a Software Engineer for Lucent Technologies. Duties included C-language, Shell, pearl, C++, coding, and database management (backup, recovery, analysis and design using Erwin for schema design and management) for the Lucent Billing Invoice Oracle database. (Oracle 8i)

1999-1999 Princeton Information. (Contractor) Informix DBA/Developer Worked as an Informix software developer. Duties included day-to-day production database application support, logical and physical design of database schemas using tools such as Erwin, database configuration and management.

1996-1998 Computer Sciences Corporation. Senior Member Technical staff (Informix DBA). Acted as Lead DBA. Managed and administered multiple databases in an Informix/ UNIX (AIX/HPUX) client/server environment. Duties included disk and memory management, backup and recovery and general Informix applications development support. Assisted with query optimization. Developed UNIX shell scripts to perform routine tasks. Software development using C, ESQL/C, and UNIX shell scripts. Documented user requirements and workflows. Also managed SQL-SERVER databases for the Nature conservancy project. Performed administration on GIS (ARCINFO) databases for the ALMRS project.

1994-1996 TRW Systems. Engineering scientist (Informix DBA). Provided Informix database support to the Bureau of Land Management in support of several Unix (AIX)/Informix modernization projects. Acted as an on-sight consultant to provide support to users, developers and Bureau database administrators. Developed Informix 4GL, UNIX shell, ACE, PERFORM, and ESQL/C code for various applications. Performed requirements analysis and authored the user and technical documentation for the WFIS. (Wildlife and fisheries Information system)

1992-1994 Computer Horizons Corporation. (Contractor) Software Engineering Consultant. Worked as a programmer/analyst. Developed applications software using C, PRO-C, SQL, SQL-PLUS, and other Oracle tools in an Oracle/Unix environment for various telecommunications industry applications for Bell Labs such as switching systems (5ES), Call Detail record processing, Provisioning and Usage, and voice messaging applications.

1988-1992 National Center for Atmospheric Research. Scientific Applications Programmer. Designed and developed scientific applications using FORTRAN and C language. Used an interactive display language to display and analyze solar data. Designed and developed Informix databases to manage large data sets.


University of Colorado: MS Degree (Information Systems)

Park College: BS Degree (Information Systems)

Park College: AS Degree (Computer Sciences)

University of Maryland: AS Degree (Computer Sciences)

Regis University: Completed Graduate Certificate in Oracle Database Development.

Northcentral University: Currently working on Doctor of Business Administration (Information Systems).

Contact this candidate