PROFESSIONAL SUMMARY:

• Over 25 years of IT consulting with extensive Business Analysis, Programming, and DBA experience supporting enterprise clients in their Unix, Linux and database environments.
• Industries include Automotive, Manufacturing, WMS, Education, Finance/Insurance, Shipping, and Accounting (Payroll, AR, AP, GL, Purchasing, Order Processing, Inventory, etc.)
• 20 years of RDBMS DBA experience working with Informix versions 5, 7, 9, 11, and 12. Also experienced in MS Access (3 years), Oracle (1 year 10g), SQL Server 2010 (2 years), and MySQL (3 years). Support experience includes 24/7 on - call production support, Bug fixing, Tuning, Troubleshooting, Patching, Upgrades, Migrations, Conversions, Replication (HDR, ER), Backup and Recovery, Disaster Recovery Planning and Testing.
• 25 years of Application Development/Support experience using C, C-Isam, ESQL-C, Informix 4GL, PHP, PL/SQL, Pro*C, SQL, Shell (sh, ksh, bsh, zsh, etc.).
• Strong SDLC experience, including interpreting technical specifications, programming from those specifications. Code reviews, unit testing, and QA.
• Over 30 years of Unix platform experience including HPUX, AIX, Solaris, and Linux (Red Hat, CentOS) and extensive experience in Shell scripting and Vi editor.
• 15 years of Business Analysis experience in a variety of client environments. Ability to ask the relevant questions needed to understand business models and technological requirements, and then produce documentation and specifications reflecting that understanding.
• Excellent communication skills - Effective communication between all levels of technical and business professionals.

PROFESSIONAL EXPERIENCE:

Confidential, Westminister, CO

Independent Consultant/DBA/Systems Analyst

Responsibilities:

• Provided application support for Internal 4GL applications, including enhancements, bug fixes, and production support.
• Responsible for analysis, support, and documentation of existing Informix and MySql databases.
• Provided 24/7 support including monitoring, troubleshooting, upgrades (11.7-12.1), backup/recovery, and trouble ticket resolution.
• Worked with 85 databases supporting 75 internal (BLM) applications (4GL), and 60 external applications (Web based

Environment: Solaris, Informix 11.7, 12,1, MySql 5.x, Informix 4GL, SQL, PHP Admin, Remedy, Jira, Shell (sh, ksh, bsh)

Confidential, Philadelphia, PA

Independent Consultant/DBA/Systems Analyst

Responsibilities:

• Responsible for upgrade and migration of Informix 9.4 to 12.1
• Also responsible for analysis and documentation of existing Informix 11.7 data model for Confidential ’s legacy (4GL) chart tracking system.
• Also reverse engineered 4GL software with no source code to allow analysis of existing chart tracking applications.

Environment: AIX, Informix 9.1, 12,1, C, Esql-C, Informix 4GL, ISQL, dbload, Shell (sh, ksh, bsh)

Confidential, Chicago, IL

Independent Consultant/Migration DBA/Systems Analyst

Responsibilities:

• Responsible for discovery, analysis, and technical documentation of Legacy Informix system.
• Completed technical analysis, business analysis, and overall system documentation of Confidential 's Psychological Scoring and Test System.
• Provided analysis, development, testing, and implementation of new government psychological test applications, along with enhancements, and bug fixes.
• Upgraded version 7.3 Informix on HPUX to version 11.7 on RHEL.

Environment: HP 9000, HPUX 11.11, RHEL, Informix 7.3, 11.7, C, Esql-C, Informix 4GL, ISQL, dbload, Shell (sh, ksh, bsh)

Confidential, Miami, FL

Independent Consultant/DBA

Responsibilities:

• Responsible for analysis, design, and programming of IBC's TSA Tracking System.
• Also responsible for upgrading Informix version 5 RDBMS and databases to Informix version 11.7.

Environment: RHEL 6, VMWare, Informix 5, 11.7, Informix 4GL, C, Esql-C, dbload, Shell (sh, ksh, bsh)

Confidential, Chicago, IL

Independent Consultant/Technical Lead/DBA

Responsibilities:

• Responsible for planning and executing database portions of Hyatt’s enterprise data center migration from Confidential .
• Combined replicated (HDR) databases onto one server as Secondary was moved downtown.
• Once Secondary was set up downtown, HDR was re-established until the Secondary could then take over all application processing from the new data center.
• Old Primary was then moved downtown, and applications and databases were again separated between the two servers.
• Also responsible for upgrading Informix 9. to 11.7).
• Also provided 4GL application consulting to Jr. members of application staff.

Environment: IBM, AIX, Informix 9.x, 11.7, Informix 4GL, C, Esql/C, SQL, HPL, Shell (sh, ksh, bsh)

Confidential, Bentonville, AR

Independent Consultant/Systems Analyst/DBA

Responsibilities:

• Responsible for POC (Proof of Concept) effort to ensure that all of Confidential ’s existing Unix, C, Esql-C, Informix 4GL, and .NET applications would function properly utilizing multi-byte character sets (Chinese/Japanese).
• Also responsible for POC to ensure that double byte data (representation of Chinese and Japanese ideographs) could be stored and retrieved successfully by all data tools (BI), and applications.

Environment: HP 9000, HP 3000, HPUX 11.11, Informix 9.x/11.5, WMS, C, Esql/C, Informix 4GL, ISQL, dbload, HPL, Visual Basic, Shell (sh, ksh, bsh)

Confidential, Tallahassee, FL

Owner/Consultant

Responsibilities:

• Owned and operated remote consulting firm specializing in Application Design, Development, Testing, and implementation of various 4GL applications.
• Provided RDBMS Migrations, System Analysis, Business Analysis, Upgrades, Performance Tuning, Troubleshooting, Disaster Recovery Planning, and RDBMS Logical/Physical Design.
• The following listings refer to contracts executed between Confidential and the referenced companies.
• Responsible for support of all production Informix and MySql installations.
• Completed migration of all databases from 11 servers to 2 servers requiring modifications to 50% of supporting software including Informix 4GL, Esql-C, and shell scripts.

Environment: Informix 4GL, C, Esql/C, dbload, HPL, Shell (sh, ksh, bsh), Informix 9.x/7.x, MySql 3.x, Solaris 10.1, HPUX 11.x

Confidential, Austin, TX

DBA - Migration Specialist

Responsibilities:

• Confidential contracted with IBM partner Sector 7 for all Business Analysis, System Design, Informix migrations, upgrades, performance monitoring/tuning, and disaster recoveries.
• Successfully migrated 3 major ERP databases from legacy systems to Informix on IBM pSeries platforms, upgraded from Informix 5 to 7, and 7 to 9.

Environment: Informix 9.x, 7.x, 5.x, Progress 10.x, Oracle 8.x, 7.x, MySql, C, Esql/C, Informix 4GL, ISQL, dbload, HPL, PL/SQL, Pro*C, PHP, Progress 4GL, Shell (sh, ksh, bsh), AIX 3.1, Dynix/Ptx, AIX, HPUX 10.x, Solaris 9.x, Linux (RHEL), IBM RS6000, Sequent, Intel