Thomas Gerlach

630-***-**** (Cell #)

acws2v@r.postjobfree.com

SKILLS INVENTORY

TECHNICAL SKILL EXPOSURE

Java Experience J2EE (3 years)

JAVA 1.6 / 1.7 (Good Exposure with Eclipse and RAD)

Websphere 7.0 & 8.5 (Good Exposure with Eclipse)

Wildfly 10.0 (Medium Exposure with Eclipse)

JBoss (Some Exposure with Eclipse)

JSF/CSS/JSP/HTML (Medium Exposure)

JSON (Light Exposure)

Hadoop / Big Data (Light Exposure)

JavaScript (Medium Exposure)

Eclipse / RAD / NetBeans (Good Exposure)

Data Studio (4.1) (Good Exposure)

PureXML Z/OS/XML (Good Exposure)

Subversion (Good Exposure)

J2EE Applications (Medium Exposure with Eclipse Environment)

J2EE Architecture (Some Exposure with Eclipse Dev Environment)

Maven (Some Exposure)

JIRA (Good Exposure)

MySQL (Medium Exposure)

DB2/SQL/Some DB2 Utilities (Expert)

TestDirector (Good Exposure)

Windows 7 / 10 (Great Exposure)

Mainframe Experience (26 years)

COBOL/COBOL II (Expert)

TSO/ISPF (Expert)

OS JCL and Utilities (Expert)

DB2/SQL/Some DB2 Utilities (Expert)

IMS(EXEC DLI & CBLTDLI) (Expert)

CICS (Command)/BMS (Expert)

VSAM (Great Exposure)

INSYNC (Good Exposure)

XPEDITER (Good Exposure)

Microsoft Word, Excel (Great Exposure)

Windows 7 / 10 (Great Exposure)

FILE-AID (Some Exposure)

INTERTEST (Some Exposure)

TestDirector (Good Exposure)

Wiki (Confluence) (Great Exposure)

Management: Team Leader / Project Leader of 7 for a 2 year mainframe project. Project was for the company’s location expansion. I was responsible for project management duties, workload meetings, excel spreadsheets to organize releases for over 1,000 CICS and Batch Cobol programs.

I was responsible for the management of a 2 year mainframe project to expand the number of sales, warehouse and corporate locations at Anixter. This project involved identify over 1000 Cobol Batch and Cobol CICS programs fields to convert locations from picture 9(3) to picture X(3) definitions so that the company would have the inclusion of alpha locations, ie: more than the limit of 999 with the picture 9(3) field clause. I lead 7 to 8 consultants and employees to identify programs with location fields and location internal tables that needed changing to accomadate the new field definition. This included identifying the changes, testing the changes, code reviews and implementing the programs into production in a logical way that fit the batch and online systems. We had to be very careful with the financial systems especially. This affected sales, inventory, purchasing, receiving, returns, invoicing, financial credit and all other systems of Anixter. We finished in approximately 2 years.

I was responsible for estimating work loads, overseeing program analysis, code reviews, meetings, and excel spreadsheets to logically organize the release of the batch and online system programs into production.

I also was project lead on the conversion of the IMS Routing Database to the DB2 Routing Database. This project lasted about 10 months and I was in charge of 2 to 3 employees during this conversion. Again, programs were changed and I did code reviews, handled meetings, and the DB2 table design and the logical release of batch and online programs into productions. All management work was handled by Jira and Excel spreadsheets.

Applications: Banking/Financial; Insurance/Claim Refund; Sales;

Accounting; Human Resources; Pricing/Costing;

Parts/Inventory/Purchasing Warehouse/Receiving

Education: Bachelor of Science in Computer Science/Business Minor (U of IOWA)

Employment History

I used native stored procedures that run on the zip engine of the mainframe. These back-end stored procedures went against our DB2 tables which did not have xml defined columns but regularly defined columns such as INTEGER, SMALLINT, CHAR, VARCHAR, BIGINT, ETC. and my native stored procedures created xml doc objects that were marshalled and unmarshalled through JAX2B. I created the TOs "transfer objects" and Data Access Objects interfaces which called my DAOImpl objects which implemented the DAOs I coded. I know how to use collections such as LISTS and MAPs and know how to create classes for backing beans used in Java Server Faces in Expression Language syntax. I also tested my Stored Procedure calls in the Eclipse IDE to make sure the TOs were returning a good object after it was marshalled to a java object. I passed xml parameters to the native stored procedures and these parameters were shredded into Stored Procedure DECLARED variables used in the predicates of the SQL. I am very proficient at DB2 tables and DDL and RI and SQL.

I know WebSphere very well. This was my local server for my Eclipse IDE. I know maven somewhat which is how we built our projects with the dependencies such as maven, spring, java compiler. Web xml was where I handled navigation rules. I coded many I mean many back - end stored procedures and tested in Eclipse IDE. Also was proficient at Data Studio, the IDE I developed the xml stored procedures with.

I am proficient at SVN, our repository for our source code and stored procedures.

I am proficient at JIRA. I am proficient at JAVA language for the most part. Kinda mid-level or higher at Java coding. I know xhtml pages and JSF pretty much, input and output fields and have done data tabling for search queries.

That's all I can think of right now. Did some testing...ie : trouble shooting and some debug fixing. A lot of debug fixing on back - end and changes needed when business logic called for changes.

(Anixter, Inc Stock Market Symbol AXE; October 2007 through April, 2016: Team Lead/Senior Programmer/Analyst Employee)

For 2 years I have been working on the development of Native Stored Procedures and coding JAVA backing beans and xhtml pages accessing our company’s DB2 tables to retrieve and format the XML searches, lists, updates, deletions, and inserts for our Order Entry / Order Management J2EE application.

I used Data Studio and PureXML. Some of the commands I used were XMLELEMENT, XMLAGG, XMLATTRIBUTE, XMLFOREST xsi:type for the Transfer Object “TO” Java XML Objects.

I used Eclipse to build my Maven project and SVN to store and manage the development effort’s on-going coding changes.

Worked with Business Analysts and architects to ensure applications met business requirements and adhered to proposed architecture.

For the past additional year I have worked on the Framed Order architecture and Java J2EE project development.

Used Data Studio for developing the XML native Stored Procedure service interfaces.

Used JAXB for marshaling / unmarshaling Objects in both applications mentioned. Coded DAOs and DAOimpl and TO’s “transfer objects” and tested using Eclipse IDE. Also did debugging.

Developed Backing Bean for JSF, xhtml front-end page, framed order inquiry, update, delete, insert.

Familiar with Spring architecture and annotations and dependency injection.

Responsible for code reviews, work assignments and progress reports to management and organizing program releases during the different phases of the location expansion project.

Coding/Unit Testing CICS/Batch DB2/IMS/COBOL II programs for legacy side for Inventory Systems/Purchasing Systems/Sales Systems/Receiving Systems/Return Authorization System, also known as RA system/AIM system which is a on-line WEB App and Batch to estimate what inventory needs to be bought each day by the buyers of Anixter. Also, coded many programs for the new Order Entry/Order Management project that went on 4 years. This included DROP programs to keep old data off the new DB2 tables. Meetings were held to discuss the drop criteria and number of GDGs to keep and for how long. Invoices were kept for 7 years. Also coded and tested Financial and Vendor system programs. Anixter went from an IMS database company to strictly DB2 relational after Anixter purchased a product called DL2. DL2 allowed IMS databases to be converted to DB2 relational databases and now Anixter only develops in DB2. No longer using IMS. DL2 is a UK company I believe.

Used JIRA and confluence to communicate status and estimates to project leads and analysts.

Conducted peer code reviews for all systems at one time or another.

Also involved in coding/unit testing CICS Web RESTful Service transactions to do such things as auto allocation of inventory. Auto Allocation is used by the sales order system to allocate inventory and is a background CICS transaction in the receiving system. So as the warehouse receives inventory for a certain part and if there are orders out of that warehouse that need allocating, the auto allocation CICS background transaction would allocate as much of the part inventory to all sales orders if the part received in had quantity enough.

Wrote technical specifications for the Vendor Costing System. This system is a WEB system using JAVA technology and DB2 stored procedures written in COBOL II. The Vendor Costing System used excel spreadsheets to load costing information from Anixter’s vendor and the vendor also allowed for certain cost breaks depending on the volume of product Anixter bought from said vendor.

For smaller team lead duties, I was in charge of converting IMS Databases to DB2 databases. I lead 2 to 3 employees for these conversion efforts. This included the Credit Database and Routing Database. The Routing Database was used to print sales orders at the warehouses whenever the workers needed to pick and pack inventory and ship it out the doors. I also worked on the Financial Billing system which handled billing of sales orders for wire and cable, and serial items and what were also called stuff items, non –serial and non-wire and cable.

Worked on (coding/unit testing) production program defect resolution for application defects. These defects covered all systems mentioned above. We have a Development Environment, System Test Environment, Quality Assurance Environment and then on to the Production Environment.

In the past, in between project work and lead duties, I analyzed/coded/unit tested production defects for the IS Financial Systems (both on-line and batch) and the warehouse Sales/Order Entry/Order Management/Purchase Order/Receiving systems.

Komatsu America, Inc. (November 2006 through October 2007)

As a senior mainframe consultant, I was involved in the SERVIGISTICS interface to the mainframe Parts System (PIPS). This involved material ordering, purchasing parts from vendors, and warehouse parts transfers/balancing.

Using TELON (IMS DC/DB), I added fields to existing screens such as the Customer Master Update/Inquiry Screen, the Order Entry Screen, and the Purchase Order Line Maintenance Screen. Programs were written in COBOL II and used DB2 tables.

Created/Modified 5 COBOL II/DB2 SQL batch Material Request/Purchase Order add and change programs.

Created two Easytrieve Plus report programs for the errors that were incurred during Material Request processing and Purchase Order processing.

Consulted for approximately 17 years in the Chicago area working at Blue Cross Blue Shield (twice), Baxter (twice), Northern Trust, Exelon to name a few.

Worked primarily as a senior consultant at all of these companies

Mainframe architecture, CICS, DB2/SQL, IMS, COBOL, VSAM, JCL, INSYNC, Test Tools, etc.

Hi,

As you can see from my resume, I have management/team lead/software development skills in the mainframe environment.

I also have a good set of skills in Java programming and J2EE exposure.

At this point in my career, I am looking only for perm work or contract to hire and would like to let my future employer know that I wish to find a job where I can remain working until I retire.

Both my mainframe and Java skillsets are current as I could possibly do either application coding or support to start with. I say support as a suggestion to possibly get acquainted with a company’s legacy systems as well, whether Java and / or Mainframe.

Sincerely,

Tom Gerlach

Contact this candidate