Customer Service Years Experience

Dennis Guilkey

** ******* ****** 859-***-****

Fort Thomas, KY 41075 ********@*****.***

Profile

More than 20 years of information systems experience including Systems

Analysis and Design, Project management and Development. Skilled with

mainframe TSO/MVS, Client Server and UNIX/AIX platforms. Skilled with

Cobol, Assembler, DB2 Databases, VSAM, Financial Systems and Supporting

Vendor Software. Loves analyzing, programming, troubleshooting, integrating

platforms. Listens and communicates well to provide exceptional internal

customer service. Works well independently or as leader or follower in team

environments. Knowledgeable with batch and real time processing systems.

Dedicated hard worker and excellent trainer / coach.

. More than 20 years experience working with JCL.

. More than 10 years of Cobol Mainframe programming experience.

. More than 10 years of Mainframe Assembler programming experience.

. More than 10 years of SQL Query Development and Database experience

including DB2, ORACLE, SQLServer and Sybase.

. 20 years of IBM Utilities experience.

. 5 years experience supporting Vendor Software.

. More than 10 years of Project Development Methodology experience.

. More than 20 years of project application testing and implementation.

. More than 20 years of System support and application Break/Fix

experience.

. More than 2 years experience with Endevor.

Platforms: UNIX/AIX, Windows XP/NT/98, IBM Mainframe OS/390, VSE

Software: Sybase, DB2; Oracle; MS SQLServer 2005, SQL, SQL

Advantage, SQL Anywhere; Microsoft Access, Excel, PowerPoint,

Word, Visio, SQLPLUS, Advance Query Tool(AQT), Crystal

Reports, Informatica

Languages: PowerBuilder, COBOL, Assembler, SAS, PL1, JCL, SQL, C,

Stored Procedures and Triggers, Visual Basic 6.0, VBScript, ASP, XML

Other Skills: MQUEUE, IBM Utilities, TSO/ISPF, FTP, Endevor Program

Library, File-Aid, ROSCOE, Clear Case/Clear Quest,REXX,

Project Development Methodology

Experience

TEKsystems at CMHA Cincinnati, Ohio

March 2010 - Present

. Temporary Contract position converting Crystal Reports from Version

8.5 to Version 11.

TEKsystems at Wellpoint Cincinnati, Ohio August 2008 -

June 2009

. Analyzed current processes and determine requirements for a new

automated system.

. Design the automation process for the Medicare Part - D

reconciliation process using Mainframe SAS, JCL, COBOL, FTP,

Informatica, PCSAS, Crystal Reports, Advanced Query Tool and ORACLE.

. Technical Project Lead to assure all technical inquiries are answered

and coding can be completed.

SI International Fairborn, Ohio May 2008 - August 2008

Wright-Patterson Airforce Base

. Converted Legacy COBOL Mainframe code to PowerBuilder Client Server

Application for the United States Department of Defense. Creating SQL

Queries on an Oracle database. NAC -Security Clearance.

Fifth Third Bank Cincinnati, Ohio June 2006 -

April 2008

Development, Analysis, Design, Implementations, Upgrades and support of

vendor applications, their interfaces and Reports using Mainframe Cobol,

VSAM, JCL, VBScript, Crystal Reports, Active Server Pages, SQLServer 2005,

Stored Procedures, Triggers, Windows Server.

. Supported the GEAC Accounts Payable, Fixed Assets and Capital

Projects System, wrote interfaces in a Mainframe Cobol environment

using VSAM, PROCS, FTP and JCL.

. Lead Technical Support for the Concur Time and Expense Reporting

Software wrote interfaces in VBScript, coded stored procedures and

Triggers in a SQL Server 2005 Database.

. Wrote and supported Time and Expense Crystal Reports in a SQLServer

2005 Database for the Finance Group and the Chief Finance Officer

using VBScript, JavaScript and some ASP.

. Utilized MS SQLServer 2005 writing SQL queries to retrieve and update

data.

. Created MS Access queries for the Sourcing and Finance Groups.

. Technical Lead for the installation of the Information Technology

Management Software Package and SQLServer 2005 Star Schema Database

used by the IT Finance Department for Budgeting.

TEKsystems at Duke Energy Cincinnati, Ohio December 2004

- June 2006

Production support and development for the PowerPlant application using

Powerbuilder 9.0, some Visual Basic 6.0 on an Oracle database.

. Wrote SQL queries, Stored Procedures and Triggers to retrieve and

update data.

. Wrote PowerBuilder interfaces to feed data into the Powerplant

application.

. Worked with the Powerplant Vendor and users to correct production

problems perform upgrades and support the software.

. Performed Sarbanes Oxley testing to assure compliance.

. Updated the Meter Reader's Time reporting system in a PowerBuilder

Application with a SQLServer 2000 Database.

Duke Energy Cincinnati, Ohio July 2004 - Nov

2004

Worked as a contractor at Duke Energy to make change to coding fields in

their code block for Duke's Fixed Assets System using PowerBuilder in a

windows environment with Oracle as the database.

. Worked with the vendor's software package PowerPlant including

working with the vendors and users.

. Made mainframe COBOL changes to accept the code block changes.

. Created stored procedures through SQLPLUS to convert Oracle tables to

new coding format.

Schneider Electric / Square D Florence, Kentucky 1998 - 2004

Analyst Information Systems

Analysis, design, development and testing of business applications using

PowerBuilder 9.0 in a Windows environment, C coding, COBOL in a mainframe

and UNIX environment, JCL, DB2 and CICS.

. Performed System Analysis and design of the Order Transportation

Management System (OTMS) used by Square D and non-employee

consolidators.

. Wrote documentation for Order Transportation Management System (OTMS)

used by Square D and non-employee consolidators.

. Coded and tested the Order Transportation Management System utilizing

Powerbuilder 9.0, COBOL, UNIX, SQL, DB2, Sybase and MQUEUE.

. Trained employees and non-employees on OTMS via hands-on, live orders

in a Windows environment.

. Provided third-level support for current business applications (Quote

to Cash (Q2C), Shipping, OTMS, Keane / Durham Production Support)

utilizing Powerbuilder, COBOL, UNIX, SQL, DB2, Stored Procedures,

Sybase and MQUEUE.

. Coded the Shipping System of Q2C for Exports and Cross Borders

project utilizing Powerbuilder, COBOL, Stored Procedures, UNIX,

Mainframe, JCL, SQL, DB2, Sybase and MQUEUE.

. Coded the shipping system in Q2C utilizing COBOL Mainframe, CICS,

SQL, DB2, JCL, FTP and XCOM.

. Coded Special Price Determination, Change Order and Order Maintenance

utilizing Powerbuilder, COBOL, UNIX, Stored Procedures, SQL, Sybase,

DB2 and MQUEUE.

. 2003 and 2002 Outstanding Customer Service Awards.

The Kroger Company Cincinnati, Ohio 1997 - 1998

Analyst

Analysis, design, development, and testing of business applications using

Assembler Language, and JCL in a mainframe VSE environment.

. Supported current business and point of sale (POS) applications in

Assembler Mainframe environment.

R.L. Polk and Company Cincinnati, Ohio 1985 - 1997

Systems Analyst

Analysis, design, development, and testing of business applications using

Assembler Language, PL1, and JCL in a mainframe TSO environment.

. Provided Systems Analysis and design of the Vehicle Coding System.

. Coded the Vehicle Coding System utilizing Assembler, JCL and Fileaid

utilities in a mainframe environment

. Wrote documentation and provided support for Vehicle Identification

Number (VIN) Coding System.

. Updated vehicle coding tables and reported via excel spreadsheets.

. Trained ~60 employees on VIN Coding System.

. Coded and maintained state conversion programs utilizing Assembler,

PL1, JCL and file aid utilities.

Continuing Education / Training

Square D In-House/Online Training 2003

Virtual Teams: The Fundamentals

Team Leadership: Conducting Productive Team Meetings

Excellence in Service: Working with Upset Customers

Oracle Developer: Form Fundamentals

Fast Track to PowerBuilder Powersoft Training 1999

Mastering Data Windows Powersoft Training 1999

Diversity / Harassment Kroger, Square D 1997, 1998

UNIX R. L. Polk 1995

Northern Kentucky University Highland Heights, Kentucky 1984

Associate of Applied Science

Community Service

United States Soccer Federation 2002 - Present

Level8 Licensed Soccer Official

Highlands High School Fort Thomas, Kentucky 2008 - Present

Soccer Booster Board, Treasurer

. Reconcile Soccer Board monthly check book, paid bills issued checks and

make deposits.

Woodfill Elementary School Fort Thomas, Kentucky 1999 - 2004

Academic and Athletic Booster Club, President 3 years

. Raise funds and distribute to various programs. Recognize all students

participating in any extracurricular activity whether academic, artistic,

or athletic.

. Manage application process for students participating in county leagues.

Youth Soccer, Baseball, and Basketball Coach 1991 - Present

Teach technique, teamwork, rules, sportsmanship, preparation, and

organization required to succeed.

. Teams have won a total of 4 championships at regional and state

tournaments, plus 3 silver and bronze medals. Four players have advanced

to JV and Varsity teams.

Contact this candidate