Overview
. I started working on the IBM midrange computer programming in RPG 30
years ago and have stayed with it ever since. I have chosen to stay
technical and endeavored to be as current as possible with new techniques
and technologies. My specific proficiencies are detailed separately for
readability.
Knowledge Base categorized by type
. RPG Proficiency - All code I currently produce is in free form ILE;
embracing the model/view/controller pattern where the model is
implemented in RPG service programs/subprocedures and modules. I use
both native file and embedded SQL for access to DB2 data. I am
comfortable with working with subfile display programming and traditional
RPG techniques. I have worked with all flavors of RPG since the System/3
and comfortably deal with old 36 code for maintenance and modernization
projects.
. XML - I have worked with DB2 XML Extenders product from IBM to parse and
generate XML documents into/out of DB2. I have familiarity with SAX/DOM
models for XML development and have worked with Xalan and Xerces on
system i. Also have coded RPG applications using XML-INTO and XML-SAX
operation codes.
. SOA & Web Services - I have worked as a lead architect on re-engineering
legacy code into function based procedures residing in service programs
that will be exposed as a web service. I work with the integrated web
services server for system i and have used Websphere V6.0 to expose RPG
functions. I also design and write functions on the system i to consume
services residing on other systems.
. Java - I have a working knowledge of Java having written applications
that run on the IBM i that serve as a interface between java front end
and system i back end ( IP sockets to system i data queues ). Knowledge
of JSP's, Java Toolkit for i series, and a basic working knowledge of
Struts and Java Server Faces.
. Database Administration - I have extensive experience with DB
constraints, triggers, and DDL for file creation using SQL, in addition
to traditional DDS proficiency. I have excellent knowledge of indexes,
views and SQL stored procedures. I use SQL as a tool to validate
referential integrity using all types of joins between files.
. Electronic Commerce - I worked as an EDI consultant with Whitman-Hart in
The Electronic Commerce group under Nahid Jalovic. I was the EDI
coordinator at Chem Central for 8 years. I supported EC at several
clients while with Evirt Systems and continued this at Tripp Lite in a
back end capacity. I have an excellent knowledge of X12 especially of all
major transaction sets (810,850,856, etc) used in most
manufacturing/distribution environments. Additionally I have worked with
implementing more esoteric transaction sets and processes (Financial
transactions, AS2). I served as project lead on a project (Sunbeam,
Mississippi) converting Sun Micro systems EDI to AS/400 platform
(GENTRAN). I am familiar with all major EDI translators on system i.
. Workbench/IDE - Currently using WDSC version 7.0 for ALL development on
system i. Also experienced with Thenon and MKS Implementor change
management tools.
. Team Member and Project Management - I have been in varied positions in
development/project teams of all sizes. I have handled projects
completely on my own from specifications through development, testing,
user acceptance, integration, deployment, and maintenance. I have also
been a constructive member of team projects. I am currently working as
system i lead on web service based integration between system i and
MICROS Systems Property Managements system. I am responsible for weekly
project updates to overall project manager and guiding the RPG developer
for integration programming tasks.
. SQL - I am proficient in using SQL in DB2 and have used the following
(among others):
o Joins- Left Inner/Outer, Exception, Subselect, UNION
o SELECT, INSERT, UPDATE, DELETE
o Written SQL User Defined Functions
o Scalar functions
o CASE statements
o Common Table Expressions
. IBM i on Power Systems Management/Workflow - I have excellent knowledge
of the IBM i (aka i5, system i, AS/400, etc). I am extremely comfortable
with anything related to how a job enters the system and processes within
it. I also know how to maximize resources allocated.
. Stored procedures - I have used both external and SQL to modularize and
modernize my development for maximum reusability/flexibility.
. Testing/Deployment - I have worked in environments with little or no QA
framework or positions. As a result I have done extensive testing of all
kinds - unit, system, regression, and integration. I have also worked
very closely with the parties responsible for UAT and supported them. I
recently was involved in a large scale project (working as the i
developer in conjunction with a SME/project manager and a Java developer)
with minimal bugs/complications and that had no negative impact during
deployment.
. Consulting Background/Relationships - I have over 6 years experience
consulting while with Whitman-Hart, Evirt Systems, and Insel Solutions.
I have been actively engaged in all aspects of the client relationship
process including initial sales meetings, project planning, design,
working with on-site resources, coordinating/supervising contract
resources, documentation, and transitioning off of engagements. I have
had long term maintenance relationships with clients as needed. I have
been exclusive to a single client for up to a year during a major project
and successfully handled supporting as many as 6 clients during lulls
between major engagements. I have excellent soft skills and a strong
ability to communicate.
Work HIstory
Brotherhood Mutual Insurance, Ft Wayne, IN; Follett Higher Education Group
Oakbrook, IL,
Hub Group, Inc, Oak Brook, Il
09/2009 - Present
Consultant
. Free form RPG/ILE using service programs and modular architecture, also
performing Web services on iseries.
. Heavy Embedded SQL in RPG
Shell Vacations, LLC, Northbrook, IL 09/2004 - 09/2009
Senior Programmer Analyst
. Free form RPG/ILE using service programs /modules. Heavy web services, MQ
series, integration work with all platforms/protocols. Main architect on
modernization projects.
Richco Plastics; Arjo 09/2003 - 09/2004
Consultant
. Free form RPG/ILE using service programs /modules. MOVEX, JDE, BPCS
Tripp Lite, Chicago, IL 03/2003 - 09/2003
Senior Programmer Analyst
. Free form RPG/ILE using service programs /modules. CGI programming with
RPG
Vienna Beef; Tripp Lite; Richco Plastics; Arjo 04/2002 - 03/2003
. Free form RPG/ILE using service programs /modules. Heavy imbedded SQL
ITW Brands; Richco Plastics; Arjo; Tripp Lite 11/1997 - 03/2002
Senior Consultant
. Free form RPG/ILE using service programs /modules
Sunbeam; Chem Central; Bosch; Radio Flyer 07/1996 - 06/1997
Consultant
Chem Central, Bedford Park, IL 1990 - 07/1996
EDI Coordinator and Programmer Analyst simultaneously
Education
DePaul University
Certificate Programs
. Web Development, XML Development, Project Management, Java Developer