John D. Gunkle

*** ******* ***** ● Hendersonville, NC 28739 ● 828-***-**** ●

adctp6@r.postjobfree.com

TECHNICAL SKILLS

Operating Systems: Windows (Multiple Versions), VM, CMS, MVS, DOSVSE, OS-VS1, OS-VS2, DOS, MSDOS, OpenVMS, UNIX (SCO, HP, AIX), Linux, TSO

Software: Microsoft (Outlook, Access, Excel, Word, PowerPoint, FrontPage, Project, Publisher, Web Expressions), Lotus Smart Suite (123, Word Pro, Approach, Notes), CVS, Cyber Query, TOAD, SAP (SD, PP, PO, FI, WAP, MM modules), EDI, WebSphere, Rational, Clear Case, MS Studio, QMF for Windows, Visio, Open Office, HP Performance Center, LoadRunner, WordPress, Drupal, JavaMail, Dbeaver, Hyperion Programming Languages: Visual Basic, COBOL (Micro Focus and Standard), PERL, HTML, FOTRAN, XML, XHTML, CSS, ADO, C/C++, Java, J2EE, JavaScript, JSP, Servlets, XSLT, VBScript, COM, DCOM, SOAP, REXX, JCL, ADA, ASP, DHTML, .Net., JDBC, ODBC, Bootstrap, SOA, PYTHON Network Administration: Ethernet, Token Ring, TCP/IP, DNS, NIS, SMTP, Active Directory, Windows (NT, 2000), AIX, Linux, UNIX, Sun, USB, and Modems (Cable, DSL, Analog) Hardware Platform: Sun, PC, Tablets, and MAC

Positions Held: Programmer Analyst, Systems Analyst, Systems Programmer, Computer Instructor/Course Developer, Team Lead, Project Manager, UNIX/PERL/Web Developer, IT Developer, DBA. Project Management Methodologies: Waterfall, Agile, Scrum, RAD Code Repositories: SVN, Team Foundation Server, Team Forge, Clear Case, Power, Artifactory, GIT Relational Databases: PostgreSQL, Informix, Oracle 7 and 8i, MySQL, DB2, MS Access, Informix, MS SQL, Teradata, PostgreSQL.

EXPERIENCE

DynPro at Lenovo RTP, NC

Senior DBA Developer 1/2017 -Present

Database administration of two large DB2 databases (version10.5).

Linux, PERL, and Python scripting.

DB2 performance tuning.

ETL processes against DB2 and SQL Server databases.

Use tools like Hyperion, DBeaver to test queries.

Build load and translation programs to load DB2 databases automatically.

DB2 to PostgreSQL conversion.

NTCA: The Rural Broadband Association Asheville, NC IT Development 3/2013 – 9/2016

J2EE Web application development in Rational 7.0, creating JSP applications connecting to DB2, MS SQL, Oracle, and PostgreSQL databases. Incorporation of HTML 5, JavaScript/JQuery, CSS, and Bootstrap.

Relational database design and development with PostgreSQL and MS SQL.

Started developing applications in Spring with AngularJS.

Support .Net applications and act as back up for .Net developer.

Design system architecture for the purposes of integration into multiple platforms.

Data Analyst on database design process on DB2, MSSQL, and PostgreSQL databases.

Systems Administration of MS 2012 Servers and setup of IIS and Apache Tomcat web servers.

Organization uses Scrum and Agile Methodologies.

Performs duties of SharePoint Developer and Administrator.

Team Foundation Server (TFS) as code repository and to document Scrum meetings.

Production support of Java, .Net, and databases to include issue resolution. Wal-Mart, Inc. Bentonville, AR

UNIX/PERL/Web Developer 8/2003 – 2/2013

Java/J2EE Web application development in Rational 7.0, creating JSP applications connecting to DB2, Informix, and Teradata databases. Incorporation of HTML, JavaScript, and CSS.

SOAP/SOA with high volume Money Transfer System to MoneyGram.

PERL/UNIX/Linux scripting and application development creating DBI applications connecting to DB2, Informix, and Teradata databases for reporting, as well as system utilities.

Design system architecture for the purposes of integration into multiple platforms.

Created Patriot Act system to monitor cash transactions that could trigger Patriot Act and or Cash Transaction Report.

Setup WebSphere tester servers for pre-production testing as well as local servers for development.

Production support of high availability applications.

Assist Data Analyst on database design process.

System Load Testing with HP Performance Center using VuGen scripting.

Support and code fix Java based third party integration software using ANT builds.

Coding support of ASP NET applications for reconciliation.

Occasional COBOL and JCL development.

Mentor, training, and provide guidance to junior developers on the team. Universal Leaf North America, U.S., Inc Rocky Mount, NC Programmer/Analyst/Developer 8/2002 - 4/2003

Performed technical work on a tobacco plant management system.

Translated Micro Focus COBOL in PERL, Scripting (UNIX), and Cyber Query applications. Managed Bartender labeling software with Visual Basic, Warehouse Bill Balancing system (MF COBOL, Unix Scripts, and PERL).

Created and maintained the auction load transmission system using PERL and Unix Scripting feeding data to Oracle 7 and 8i databases.

Maintained systems on HP UNIX, Linux (Suse, Red Hat), and Windows 2000 servers. City of Raleigh Raleigh, NC

Senior Systems Analyst 11/2000 - 5/2002

Managed a software development projects and supported a 5-member team.

Worked on RFP specifications for Hansen implementation.

Worked with Oracle 7 and 8i, Developer 2000, MS SQL, Visual Basic 6, MF COBOL, PERL, HTML, Pro C on a Compaq Alpha Server client/server network.

Extracted data from various sources for conversion and loading (ETL) into Oracle databases for Hansen implementation.

Worked with end users and management to configure Hansen modules to meet user requirements.

Worked on wireless solution for running Hansen from Water Maintenance vehicles. CDI Managed Information Systems at IBM RTP, NC

SAP L2 Operations Team Lead 1/1999 - 11/2000

Lead a team of sixteen members to support SAP Level 2 Operations at IBM. SAP L2 Operations.

Provided direct customer support in: SAP GUI support; printers; Finance, World Wide Accounts Payable, Sales and Distribution, Purchasing, Materials Maintenance, Parts Planning, Product Management, Engineering Changes Modules.

Performed Workflow, DB2 Queries; MVS Batch JCL, ISPF, TSO, Security Separation of Duties, and AIX scripting on AS 400 for testing.

Scheduled SAP Batch and ABAP/4 Queries.

Personnel Support Command Fort Knox, KY

Assistant Automation Specialist 12/1997-12/1998

Performed consultative service to the site's Chief Information Officer in the areas of networks, PC installation, software maintenance, equipment purchase and contracts.

Created several databases using MS Access and performed database analysis for future projects.

Repaired Novell Network servers.

Assisted with staff computer training, including using e-mail, Microsoft software, and general computer use. Headquarters Command Fort Stewart, GA

Unit Automation Specialist 5/1997 - 12/1997

Advised command staff on computer training, purchases, and networking issues.

Repaired several PCs and related equipment for the command and Fort Stewart.

Created databases, spreadsheets, and presentations using Microsoft software for the Commander, unit, and Fort Stewart.

Trained unit and command personnel on the use of computers, LANs, and software. US Special Operations Command MacDill Air Force Base, FL Senior Systems Administrator 1/1995 - 5/1997

Systems Administrator for a UNIX based system on SUN hardware.

Manager of several subordinate personnel. And as lead webmaster, web servers (HTTP, CERN, and Netscape) and created web pages using HTML.

Used PERL and JAVA to make web pages interactive. Used Unix Shell scripting.

Managed Domain Name Server (DNS), Network File Server (NFS), Oracle Enterprise Server, and Executive Manager.

Evaluated MF COBOL, MS Visual Studio, and other development software for the command. Defense Information Systems Agency Wheeler Army Air Field, HI Systems Developer 1/1991 – 1/1995

Created software systems in COBOL, REXX, and JCL on an IBM 4381.

Performed maintenance and repair, to include deployment of new workstations for over 500 employees.

Installed and maintained an IBM Token Ring LAN.

Computer Science School Fort Gordon, GA

Computer Science Instructor 3/1988 – 1/1991

Computer Science Instructor in COBOL, MVS JCL, Dumb Debug, Lotus 123, Word Perfect, DBASE IV, and mainframe operating systems for up to 50 students per cycle.

Developed course material for Dump Debug and COBOL training courses. US Army Field Station Augsburg, Germany

Systems Programmer Analyst 3/1986 – 3/1988

Programmed systems in COBOL, PL/I, REXX, and various other languages on an IBM 4381 Mainframe.

Used IMS, CMS, and JCL.

US Army Systems Engineering Command Fort Monmouth, NJ Programmer Analyst 11/1984 – 3/1986

Developed software systems in FORTRAN, C, and various other languages on a HP 1000.

Also acted as a systems administrator for the HP 1000. EDUCATION

Bachelor of Information Systems 8/2002

American Intercontinental University Atlanta, GA

Summa Cum Laude, 4.0 GPA

Associate of Science in Computer Science 5/1992

Honolulu Community College Honolulu, HI

Honors, 4.0 GPA

US Army Computer Science School 11/1984

Fort Benjamin Harrison, IN

Contact this candidate