Data Front Office

John Kesh

Address:

**** ******** **

#***

Waterford, MI

48327

*******@*********.***

*******@*****.***

*** – 935 – 1486

Objective

Seeking challenge in various technical jobs such as Sr. DBA/Data Architect or CTO.

Client List

GM, FORD, Chrysler, American Express, Wachovia Bank, First Union Bank, Cigna, Kmart

Summary

Information technology professional with over 28 years of IT and Engineering experience. As a professional DBA and Developer, I have worked for many well respected firms including General Motors, American Express, IBM, and others. I have been hired as a DB2 consultant by IBM on six DB2 projects. Author of technical eBook ‘Introduction to DB2 UDB Client/Server’ copyright John Kesh. Subject Matter Expert SME for DB2, Oracle, SQL Server, and SAP applications for large firms.

Software

DB2 UDB LUW 10.5, IMS DB/DC, UDB ESE Database 9.7, CA-RC Tools, VSAM, XPEDITER, VM/CMS, VMS, File-aid, SDF II, Focus, BTS, QMF, MQ Series, BMS, Clist, REXX, RDO, LU6.2, BMC Tools, FrontPage, PowerDesigner, Bachman, MetaData model, Star-Schema Model, Cube Model, Snow-Flake Model, Fact Table, ETL Process, Inmon Methods, Kimball Methods, Referential Integrity Model, ERWin, SPUFI, SQL EXPLAIN, JDBC, Xpediter, Knowledgecraft, ODBC, DB2 Connect, IDCAMS, Changeman, CA-7, CA-AllFusion, CA-11, JCL, ERStudio, MySQL, UML, RUP, Quest, DB2 Data Sudio,

SAP, TSM Tivoli, MySQL, PureScale, ACCESS, SQL Server, Oracle, Sysbase

Languages

JAVA, C++, PYTHON, SQL, PERL, KORN SHELL, BASH SHELL, LISP, PROLOG, C, HTML, JCL,

DB2/SQL, UDB, COBOL, COBOL II, COBOL/400, PL/1, JCL, C, AIX script, Unix script, Korn shell, LISP, Prolog, Visual Basic, HTML, CICS, SQL, CL, Java, Java Script, VB Script, IMS DB/DC, CSP, Perl, SDF,

JAVA ECLIPSE NETBEANS, BMS, MFS, CLIST, DDL, REXX, UDB Stored Procedures, APL, BASH Shell

CICS, SAS, C/C++, Python, Fortran, OPS5, SQL

Project Management

Responsible for coordinating USA Front office and India Back office operations to provide 24X7 DBA Services for a multi-national company. Project scheduling and project reporting for several projects. Applications project lead for health care system development. Leadership and mentoring of junior level DBA and junior level programmer/analysts. ITIL, Agile, waterfall, scrum, critical-path

Method, youdon methods, SDLC life cycle, etc..

Education

Bachelor of Science Mechanical Engineering, BSME, Michigan State University

Project Management for Computer Projects, SSP Corporation.

Object-Oriented Programming and Artificial Intelligence, The Carnegie Group

Graduate Research Project in Artificial Intelligence and Robotics, University of Michigan

Graduate Research in Engineering & Advanced Engineering Methods, WayneStateU.

Graduate Research in Engineering and computer graphics, University of Detroit

DB2/SQL/VSAM/JCL Programming, Compuware Corporation

CICS Command Level Programming, AGS Corporation

DB2/SQL Programming, AGS Corporation

Structured System Design, Yourdon Corporation

Structured System Design, James Martin Corporation

LISP Programming, LTV Aerospace

OPS5/OPS83 Programming, LTV Aerospace

Oracle Training, SQL Server Training

JAVA Training(Netbeans, Eclipse) – JAVA Design

Prolog Training, Python Training

Z/OS Version Upgrade – IBM

CAD/CAM VISI – TST Corp

Commendations and Testing

Letter of Excellence from EDS Corporation

Letter of Excellence from Department of Defense, US Government

Scored top 10% on Prove-IT DB2 DBA test, 02/2001

Consulting Projects – Large Firms Only Listed- Consulting Firm 2012 – Present

Sr. DBA/Data Architect

Large Public Firm

As a member of the dba/data center team, provided performance improvement solutions

To various DB2 database problems and unix/aix file system problems. Sterling File Gateway

Product support, Adjustments Express, and other DB2 vendor product support. Creation of

Korn/BASH/Perl shell scripts for system maintenance.

Creation of runstat/reorg jcl streams for Zseries ZOS IBM parallel sysplex mainframe system. Insertion

of jcl jobs into zeke scheduler. Production problem solving with omegamon-db2 and

CA tools. Data administration for several UDB AIX Unix LUW systems from FISERV and IBM

SFG Sterling File Gateway. Korn Shell scripting and scheduling with CRONTAB scheduler.

Creation of new database backup and restore strategy for a large UDB LINUX financial system.

Provided IT management consulting, risk management, leadership consulting for special projects.

Korn shell script writing for AIX and LINUX UDB LUW database infrastructure systems.

TSM Tivoli Storage Manager Disk backup and TSM database archival methods. Perl Scripting.

Performance tuning for a large DB2 LUW/AIX data warehouse system. Evaluation of swap memory,

System cache, real memory, DB2 configuration parameters, registry variables and other parameters.

Performed LUW UDB work on version 10.5 and AIX 6.1, Linux, Windows, and Solaris.

Assisted in the development of a PureScale DB2 application and OPM Optum Performance Manager.

Created a DB2 Q replication system for bi-directional q replication between two LPARS.

Created MQ Queues, subscriptions, and Q rep tasks for a large financial application.

Created Capture and apply started tasks for a DB2 q replication system.

Created DB2 databases including STOGROUPS, TABLESPACES, TABLES, INDEXES, JCL streams, LOAD, UNLOAD, IMAGE COPY, RECOVER, and other items for a large financial application.

DB2 Z/OS Reorg, Runstats, jcl, Image Copy, Check, Load, Unload, CA Tools, IBM tools

Created several JCL jobs for DB2 Maintenance to run on Zeke scheduler.

Perform maintenance on 8 node PDF UDB DB2 LUW AIX system. Eight Logical and physical nodes.

Performed data migration and data replication using DB2LOOK and DB2MOVE utilities.

Installed fix packs/patches for UDB LUW version 8 upgrades. Installed UDB thin-client configuration.

SME for multi-platform system including SQL Server, Oracle, DB2, and SAP systems.

Creation of logical and physical codd data models for oltp and data warehouse systems.

Created software for DB2 purescale group buffer pool projects.

Other projects

Project: AT&T June 2011 – Feb. 2012

Created a b-directional Q replication system for data transfer between two lpars

For a Z/OS DB2 system.

Created DB2 databases for a VSAM to DB2 conversion project using IBM VT Tool.

Performed data migration for data transfer between a two lpar systems.

Resolved various issues for a DB2 application developer group.

Creation of project plans and estimates for milestone delivery.

Trained staff in the IBM Q replication technology and its applications.

Other projects

Project: Wachovia Bank September 2008 – February 2009

Development of AIX SQL scripts for banking financial applications.

Used the Import, Export, and Load utilities.

Executed the DB2 unload utility.

Created AIX Korn shell scripts for running SQL scripts and migrating data with the NDM utility.

Created temporary work tables for data migration

Installation of DB2 UDB version 8.1 run-time client. Utilized stored procedures and DB2 Connect. Data

migration from UDB to Oracle 9i.

Other projects

State of Tennessee

Computer Horizons

Tech tip of the day:

Create a Hadoop Archive

hadoop archive -archiveName name -p <parent> [-r <replication factor>] <src>*<dest>

SPARK RDD:

Create simple RDD

scala> val inputfile = sc.textFile(“input.txt”)

The output for the above command is

inputfile: org.apache.spark.rdd.RDD[String] = input.txt MappedRDD[1] at textFile

Cloud Basics:

Contact this candidate