Software Developer RPGILE DB2

Thomas Rock

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

Cell: 715-***-****

Wausau, WI 54403

Email: ******@*******.***

Last Updated: 2015-12-21

Career Overview

S O F T W A R E

RPG/400

CL/38

Novell Netware 2.x, 3.1x

COBOL/400

RPG II

Windows 7, 8

CL/400

Dbase III

DB2 Including Double Byte

RPG III

RPG IV

Clipper

RPG ILE

CLLE

IBM i API adaptation

RPG IV

RPG IV

And all versions of RPG

RPG ILE

RPG

Extensive Experience of RPG IV SQL and Imbedded SQL

SYSTEM/38

SYSTEM/3 Mod 10/12/15

Token Ring

SYSTEM/34

Local Area Networking

Network Wiring

AS/400

iSeries V5/R4 V6/R1 V7R1

Firewall Configuration

iSeries

Power 6 and Power 7 Processors

A P P L I C A T I O N S

Manufacturing

Accounts Receivable

General Ledger

Oil & Gas

Accounts Payable

Inventory

Communications

Order Entry

Distribution

Job Costing

Cost Allocation

Operations Tools

Paper Industry

EDI

PCI Compliance

IBM Rational Developer for i

E X P E R I E N C E S U M M A R Y

Extensive hands-on experience in most business applications since 1973.

Heavy expertise in problem solving.

Strong skills in data base design and implementation.

Experienced in all phases of application programming including analysis and design, programming, implementation, documentation, and user training.

Management skills acquired during tenure as DP Manager for several companies.

Database Administration; Development, and Tuning on DB2 for IBM iSeries

S K I L L S E T S

iSeries/AS400 APP DEVELOPMENT/RPG/ILE/FREE/EMBEDDED SQL/EDI

iSeries/AS400 SYS ADMN/DB-2 ADMN/DB2 DATA ARCHITECT

DB2 TRIGGERS/STORED PROCEDURES/USER DEFINED FUNCTIONS

IBM i ACCESS FOR WINDOWS TOOLS

OVER 5 YEARS EXPERIENCE USING IBM RATIONAL DEVELOPER FOR i V7 THROUGH V9. CAN PROVIDE SUPPORT AND TRAINING.

EXTENSIVE EXPERIENCE WITH ALL VERSIONS OF RPG; PROVIDING MODERNIZATION PROGRAMMING, TRAINING, AND SUPPORT OF LEGACY APPLICATIONS.

General Experience

Strong Project Manager for Order Entry/Distribution Systems

Extensive experience developing applications on the IBM i (AS/400, iSeries) platform.

Roles on the IBM i include administration, security, backup, recovery, programming and configuration.

Highly skilled with Microsoft Windows including Windows 7 and some SQL Server experience.

Demonstrated ability to take projects from inception to finish, working as part of a team or independently.

Highly organized with the ability to manage multiple projects and meet deadlines.

Exceptional computer technology aptitude, possessing the ability to learn and apply new programming languages and methods quickly.

Well-developed interpersonal skills for working with people in non-technical departments.

Demonstrated ability to mentor and coach fellow programmers.

Technical Skills

IBM i security, operations, planning, configuration, communications and programming.

Languages RPG, ILE, RPG Free, Embedded SQL, DDS, DDL, CLP, CLLE, COBOL, SQL, XML Tools.

Extensive experience using Sub-files, message handling, and System API programming.

Software design and coding experience utilizing RPG free format and embedded SQL, with re-usable prototyped procedures, service programs, modules, binding directories, binder language, and named activation groups.

IBM i DB2 Database Architect/Administration/Programming

Architect table specifications, relationships, use of data types at the field level, and best practices

Administrate security and field level data encryption

Programming using DDS, DDL and SQL including:

Conversion of DDS to DDL

From DDS Physical file to SQL tables

From DDS logical views to SQL views

Physical files (DDS) Tables (SQL)

Logical views

SQL views

Indexes

Materialized query tables

Triggers

Stored procedures

User defined functions.

Development tools SDA, SEU, RLU

Rational Developer for Power System Software; Training, support, installation, configuration

IBM i Access For Windows Tools; INavigiator Toolset; Deployment, training, extensive use of index advisor and database monitoring.

Experienced with the following change management and source analysis and other software tools

IMPLEMENTOR

Aldon LMI

HAWKEYE

MIMIX hot backup tools.

EDI ANSIx12 using PREMENOS (Trusted Link) mapping software, VAN setup and communications.

Microsoft Business Intelligence; SQL Server 2008; MDX coding

Proficient with Microsoft Office, VISIO

Familiar with project management using Microsoft Project.

Training in Java and Visual Basic; Internet protocols SOAP, XML, etc.

Work Experience

Systems Development Specialist at Ashley Furniture Industries

Arcadia WI March 2009 – Oct 2012

AS400/MAPICS/XA, RELEASE 8.0/DB2 DATABASE ADMN/RPGLE FREE/EMBEDDED SQL

DB2 TRIGGERS/STORED PROCEDURES/USER DEFIND FUNCTIONS/Microsoft BI MDX

Develop software for the manufacturing processing

Provide DB2 database analysis, performance tuning, DB2 tables; index creation.

SQL stored procedures and user defined functions, in multiple environments including double byte DB2 databases.

Multiple language support development including Chinese, Vietnamese, and others.

Microsoft Business Intelligence cube specifications; MDX; SQL server 2008

Introduce modular development in RPGLE to create multi use service programs.

Code service programs to enable ease of use of the IBM i OS API’s Including:

Message handling

SQL diagnostics

Error handling

retrieve last escape message from job log

forward to job’s user message queue

forward to operations message queue

Retrieve job description, system values, and object description API’s.

Set current job’s library list from the library list stored in a job description.

Retrieval of user profile information for configuring authorized menu options at sign-on.

Rollout Rational Developer for Power System Software to the IBM i development team.

Providing guidance training, and support for the new client development tool methodology.

Provide data analysis and code change support for upgrading the Mapics/Infor software to Version 8. Including

Provide assistance with multiple language support.

Database analysis to determine the changes needed for the custom code to be adapted to the new table structures.

Implement all code changes to the custom RPGILE and Traditional RPG programs

Code changes were implemented using the Rational Developer For Power Systems Software.

Regular expressions were used with the RDp search tool to find and then change the custom code to conform to the field and data type changes in the Infor 8 version.

Thousands of lines of code were searched, analyzed, and updated in 2 days saving weeks of development effort.

Created custom compile commands to work with the Aldon LMi deployment software used at Ashley Furniture for source control and change management.

All changed programs compiled successfully enabling the upgrade to the Mapics/Infor Software to be delivered on-time and below budget.

Aldon LMI support

Diagnose problems with the source version archiving

Source files used for archiving had reached the limit of members

Source was continued to be archived into overflow source files but could not be accessed

The overflow source file members were not being indexed to the source control archive tables

Designed, coded and implemented software to rename the overflow source file members with original source name and version, and then add the entry into the Aldon LMI index so they could be accessed.

Analyst/Programmer at Mills Fleet Farm, Appleton WI 2004 – 2009

AS400/RPG/ILE/IBM 4690 POINT OF SALE/ILE/RPG/FREE FORMAT/DB2 DATABASE

PCI COMPLIANCE IMPLEMENTATION/ADMINISTRATION/ENCRYPTION

Mills operates retail stores in four states with a unique mix of products for farm, work, and home.

Designed and coded modular system using ILE RPG for retrieving and processing all sales and credit card data from the POS systems at each store (IBM 4690 ACE) using the following tools:

RAIS (Retail Application Interface Suite) to retrieve and convert the TLog (transaction log) data.

NuBridges field level encryption to encrypt credit card and customer information from the TLog.

ISD Corporation authorization and settlement engines for credit card processing.

Database for credit history created with SQL including triggers for automatic encryption, stored procedures, and materialized query tables for data summarization and analysis.

Embedded SQL used to simplify some programming tasks.

Performed duties as lead analyst in designing security for handling all credit card data to enable Mills to qualify for and maintain PCI (Payment card industry) compliance:

Design security practices and standards for the IBM i running the credit card processing and settlement.

Participated with network group to design the protected network segments.

Mentor junior programmer to design and program exit point control software (RPG ILE) for IBM i Client sign-on, FTP, etc. including access control and logging.

Setup and design monitoring of IBM i audit journals including training the administrators in viewing and interpreting the audit journal entries.

Design of object level security for all credit card and customer data.

Designed and coded service programs for integration and standardization of processes involving the use of system tools and API’s including:

Batch FTP with log file parsing and error reporting.

Retrieval of user profile information for configuring authorized menu options at sign-on.

Standardize access control and usage of the NuBridges encryption API’s.

Management of multi-format logical views (retrieve member lists, add and remove members).

Retrieve job description, system values, and object description API’s

Set current job’s library list from the library list stored in a job description

Encapsulation of user space and message handling API’s

Participated in creating conversion plans and integration of existing legacy applications to Oracle Retail Suite.

Independent Consultant/IBM AS400 FREE FORMAT/ILE/ JAVA/COBOL 1992 - 2004

Kitchen Exhaust Cleaning Service Company; Review business practices and prepare requirements documentation for software specification to replace existing Great Plains PC platform software.

Insurance Company; Integral part of the team re-designing the core business processes for HIPAA compliance.

Local Bank; Provided installation and configuration support for new iSeries installation and ongoing support for PTF and system updates.

Window manufacturer; Work directly with user departments to enhance the Order Entry system; Designed and programmed a rules interpreter within the order entry system saving the manufacturer over $100,000 a year in order entry errors; Worked with IBM to create a Java Client and RPG back-end order entry system.

County government; Designed and programmed a forestry information system for tracking land and timber stands, timber harvest bidding, timber harvest tracking, and accounting functions.

Paper manufacturer; Enhanced and maintained complex COBOL order entry application; Setup and automated EDI purchase orders and advanced shipping notice transactions from major customers.

Manager at Hoffer’s Inc., Wausau WI 1990 - 1991

Window glass manufacturer, Netware, Clipper data base language. (laid off)

Took control of failing Netware network and brought back to operating condition.

Lead team for software design to move the Clipper application to the AS/400.

Internal consultant at Eaton Corp., Milwaukee WI

Auto parts and Electrical controls manufacturer

Configure and troubleshoot communications from AS/400’s to company’s mainframe network.

Acting data center manager for a large manufacturing branch.

Programmer/Analyst at Megaco Inc., Milwaukee WI

Health insurance Company. (out of business)

Maintenance and enhancement of document inventory system.

Identify and correct data base errors in multi System 38 environment.

Programmer/Analyst at Flambeau Paper, Park Falls WI

Maintained and improved the Rack Inventory Stock Storage System which was utilized to select warehouse locations for storage and retrieval of palletized paper inventory.

Experience 1973 through 1986 (Minneapolis/St. Louis/Houston)

Manager Distribution – Senior P/A Chemical Manufacturing – P/A Home Builder – P/A Oil & Gas

Sys/Admin Industrial Supply – Manager Re-manufacturing & Fabrication – P/A Furniture Manufacturing

EDUCATION

Wisconsin State University, Pre-Engineering

Wisconsin Indianhead Technical Institute, Superior WI - 1 year certificate in Data Processing

Engaged in continuous self-education, keeping current with IBM i technology by reading the technical manuals, self-assigned study of new technologies such as SOA, WebShpere, Eclipse, XML and Java.

Contact this candidate