SUMMARY:

• With over 30 years of Information Technology experience, the majority as a contract consultant, I am capable of bridging the gap between analysis, design, development and implementation with the ability to provide production support as well.
• I possess strong verbal and written communication skills and have developed excellent leadership qualities to spearhead initiative teams to successes.
• With a strong combination of technical and interpersonal skills I am a good candidate for analysis, design, development and architecture.
• I have worked on Banking, Manufacturing, Hospitality, Health Care, WMS, Data Warehousing and call center projects in Informix, Oracle and MS SQL Server. In order to keep up with new technology, I am a currently educating myself in Android mobile apps and iOS apps development.
• I have over 30 years of Commercial Business Applications Development using C, C++, Informix 4GL, Genero 4Js, COBOL.
• I have over 20 years of Systems design and administration using tools such as UNIX Shell scripting (Korn, Bash, C and Bourne), CICS, PHP, AWK scripting and Perl
• I have over 27 years of Database Development with all of the major Relational Database Management Systems, Including Oracle, Microsoft SQL Server, Informix and DB2
• I have 5 years of UNIX System Administration using all major ports of UNIX/Linux (Including AT&T S4RV, Sun OS4 and Solaris, Linux, HP/UX, Dynix and Redhat).

TECHNICAL SKILLS:

Languages: C, C++,COBOL, RPG, Perl, Java. Informix 4GL, ESQL/C, Genero 4Js, Pro*C, Visual Basic, Visual C++, HTML, CSS

RDBMS: Informix, Oracle, DB2, Microsoft SQL Server, MySQL

Platforms: Sun Solaris, AIX, HP - UX, AT&T UNIX S4R3.4 S4R4, Dynix Linux, Windows

Tools: KSH, Bash, Bourne Scripting, AWK, SED, PERL, TCP/IP, Crystal Reports, html, xml, ASP, SCCS, PVCS, Subversion, Git, Remedy, Jira, Java, Java Script, PL/SQL, Complete MS Office Suite (Word, Excel, Power Point, Visio...etc.), Go2Meeting

Software Systems: Warehouse Management Systems (Proprietary and EXE WMS2000), CAESAR Investment Management System and Streetscape, ETL, Data Warehousing

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Developer/DBA/Technical Support

Responsibilities:

• I perform analysis, design, development and support of Relational Database systems for multiple clients. This includes, but is not limited to; Database conversions, ETL support, translating flat files, csv files and outside database tables to new databases.
• I also provide ongoing technical and on-site support for systems.
• Recent examples: Created a data mining system for a medical sales and marketing firm coded with Perl and C++.
• Provided analysis, design and development for conversion from MS SQL Server 2008 to Oracle 11. Provided analysis and development for warehouse management system written using Pro*C.
• Provided analysis, design and development for conversion from Informix 11.x to MS SQL Server 2012.
• Provide ongoing off-hours and substitute Database Administration for MS SQL Server Databases.

Environment: Use Informix, Oracle PL/SQL, Pro*C, Perl, RM COBOL, C, UNIX shell scripts and Windows Powershell, SSIS and SSRS.

Confidential, Phoenix, AZ

Developer/Production Support/Tech Writer

Responsibilities:

• Completely investigated, reverse engineered and documented legacy reservation/ETL system written in C, Informix 4GL UNIX shell scripts and sftp scripts. Creating documents for Java developers to rewrite system in Java.
• I also provided production support for legacy reservation/ETL system as needed.

Environment: Use Informix 4GL, ETL, UNIX shell scripts, JIRA, Git and Windows.

Confidential

Sr. Database Administrator

Responsibilities:

• I redesigned and rewrote a data masking/obfuscating system used to mask data according to HIPPA regulations so the data may be used in lower development environments.
• Necessary to comply with data usage agreements with the federal government clients using Informix 4GL and UNIX shell and SQL scripts.

Environment: Use Informix 4GL, ETL, SQL, JIRA, Git and UNIX shell scripts.

Confidential, Nashville, TN

Developer/Technical Support

Responsibilities:

• I performed analysis, design, development and support of Relational Database systems for multiple clients. This includes, but is not limited to; Database conversions, ETL support, translating flat files, csv files and outside database tables to new databases.
• I also provided ongoing technical and on-site support for systems.

Environment: Use Informix 4GL, COBOL, Oracle PL/SQL, Pro*C, C, Crystal Reports, HTML, CSS, UNIX shell scripts and Windows Powershell, SSIS and SSRS.

Confidential, MO

Sr. Software Developer/Sr Analyst

Responsibilities:

• I redesigned and modified modules of a complex legacy shell script/Informix 4GL/Genero 4Js ETL system.
• I maintained ETL connections with multiple Database including; Informix, Oracle, MS SQL server and DB2.
• I write UNIX shell scripts and awk scripts to provide functionality for the back-end of the system.
• My duties also included analysis, design, quality assurance testing, creating test plans and post development analysis.

Environment: Use C, Informix 4GL, Genero 4Js, SQL, ETL, DB2, UNIX Korn shell and awk/nawk scripts, subversion for version control.

Confidential, Philadelphia, PA

Sr. Software Developer/Sr Analyst

Responsibilities:

• I designed and created Informix stored procedures to provide information to .NET interfaces of the web based Streetscape system for a major insurance/stock/bond/equity trading partner.
• I performed maintenance and redesign on legacy Informix 4GL programs. These duties included maintaining and enhancing Broker/Dealer system known as CAESAR for a major securities firm.
• I develop SFTP, ETL, UNIX Korn shell and awk scripts need to provide business solutions for business users.
• Developed manual and automated ETL solutions from multiple data sources to varied Database platforms.

Environment: Use CAESAR Broker Dealer compliance software, C, Informix 4GL, ETL, UNIX Korn shell and awk scripts, subversion for version control.

Confidential, Nashville, TN

Developer/DBA/Technical Support

Responsibilities:

• Developer, Analyst, technical support agent for Windows based software, developed with Java, C# and Java script and Microsoft SQL Server 2008 R2 Database.

Environment: Use Oracle, Pro*C, C, PHP, HTML, Crystal Reports, UNIX shell scripts and Windows Powershell, SSIS and SSRS, Java, HTML, CSS

Confidential, Nashville, TN

Sr Programmer/Analyst III, Database Administrator

Responsibilities:

• I performed analysis, design, development and Beta testing of a new seamless ETL process to integrate external data sources into the systems Informix Databases.
• I performed production support development for Fleettracker an Informix 4GL, ESQL/C legacy system and functioned as Informix DBA.
• I designed and developed new Informix 4GL and C software programs, for the Fleetracker system includes; Analysis, Design, development, alpha and beta testing, user acceptance and implementation.

Environment: Use C, Informix 4GL, Genero 4Js, Informix ESQL/C, Java J2EE, C#, ETL, Microsoft SQL Server 2005, UNIX Korn shell and awk/nawk scripts, Perl, Remedy, SSIS, SSRS and Crystal Reports.