Rodney W. Hull (Rod)

South Bend, Indiana *****-**13

574-***-**** - abg8a9@r.postjobfree.com

Special Skills and Interests

Am skilled at scripting/programming using both direct and indirect

techniques. That is, using one language to generate another program in the

same or different language. Quite frankly, can script and/or automated

everything encountered so far. Can see far and around corners and can work

with multi-layered or multi-dimensional problems and solutions. Have

specialization in modernization, conversion, migration, transformation, and

automation. Prefer both bash and korn shells; makes no difference to me.

Easily, over 100,000 lines authored.

Most Recent Technical Training (Indiana University-SB Continuing Ed.

Portal)

. 2010, CRYSTAL REPORTS course*, Final exam, Certificate

. 2010, ASP.NET (CMS on SQL Server) course*, Final exam, Certificate

. 2010, PHP (CMS on MySQL) course*, Final exam, Certificate

. 2009, PERL course*, Final exam, Certificate

. 2009, ORACLE PL/SQL course*, Final exam, Certificate

* Online, Instructor driven; 12 Lessons/assignments/quizzes; 24 Hrs, 2.4

CEUs.

Project/Assignment External/Internal History

Project: State of Oklahoma, OK, 2009

. Type: Platform/Database/Applications Modernization/Transformation

. Targets: HP-UX (UNIX family), Oracle, SQL*Plus, ESQL, Stored

Functions, COBOL, PuTTY SSH/SFTP, Internal Data Transformation

Repository (DTR) (bash, awk, HTML) tools, Testing: UT, SIT.

. Description: As a senior consultant in the role of senior data

analyst deployed my self-authored bash/awk based transformation tool

set to convert the State's legacy COBOL inventory from CODASYL-aware

database OLTP to DB2-SQL-aware processing. Also, wrote five, new

phase plug-ins, in bash, for the specific additional demands of the

style and features used by the State of Oklahoma. Unfortunately, the

project never made it out of pilot due to the recession and demands on

their people with the spike in volume of the UI benefits system. This

resulted in staff layoffs on our end without another project ongoing

or in the pipeline.

. Employed/paid by: Practical Transitions (delivery center staff)

Internal: Practical Transitions, IN, 2006-2009

. Type: Data Transformation Repository and Tool Suite (core business)

. Targets: Fedora Linux, Oracle, SQL*Plus, SQL*Loader (conventional,

direct), PL/SQL, Stored Objects, SQL, Import/Export, ETL (FTP/SFTP,

SQL, 3GL, UTL_FILE, UNIX/Linux, Loaders, etc), PuTTY SSH/SFTP, bash,

awk, Perl, Windows Server/XP, CIFS, SAMBA, TCP/IP, LAN/WAN, Berkeley

Utilities, cvs, GNU: C, OpenCOBOL, TinyCOBOL, Java applets, GRUB, Sun

VirtualBox, Zenmap, GanttProject, MySQL, Power*Architect, ERD, HTML,

RAD, Testing: Regression, UT, SIT, QA.

. Description: As a senior consultant in the role of senior data

analyst and tools architect, this internal company project spanned

multiple external projects for partial use and development. Developed

the HTML generated (by bash, awk, Perl) Data Transformation Repository

(DTR) for analysis of the existing database inventory using CODASYL

structures and data to produce a server-less network of navigation

with statistical analysis (max, min, type, empty, sort) the legacy

data for new/transformation development and use-case checking and

database cleansing, drop/add, and primary/foreign key establishment.

Comprised of approximately seven bash (with embedded awk) and some

stand along Perl the actually phased tool suite was developed to

perform all of the nuances of shifting client program inventory from

CODASYL to SQL (Oracle, DB2, or SQL). Established the SOP for this

suite and each component was designed to begin and end with clearly

defined units of work and be largely customizable to the specific SOI

deployed by the client's legacy programming staff. For both LACOE and

Oklahoma, a "live" feature was added to the DTR to allow available

Oracle databases to add drill-down features to the working data. This

used Java applets, Oracle stored functions, and the HTML feature of

SQL*Plus to achieve the extended capability. Engineer and

administrator responsibility for the Linux servers.

. Employed/paid by: Practical Transitions (delivery center architect)

Project: Los Angeles County Office of Education, CA, 2008-2009

. Type: Platform/Database/Applications Modernization/Transformation

. Targets: z/OS, TSO/E, ISPF/SDSF, DB2, SQL, ESQL, SPUFI/DB2I, CICS,

Xpediter, Enterprise COBOL, HTML, Cisco VPN, Red Hat Linux support,

SAMBA, CIFS, DTR (bash, awk, HTML, Perl), Fedora Linux, Red Hat Linux

support, Testing: QA.

. Description: As a senior consultant in the role of transformation

architect deployed the entire suite of transformation phase tools on

LACOE. This suite was developed in the above "Internal" project with

input from staff testers, management, and clients. Using the suite

and on-demand modification converted over 800 CICS and batch program

components to dismiss embedded legacy CODASYL DML and replace with the

full range of embedded SQL DML to access the new DB2 databases.

. Employed/paid by: Practical Transitions (delivery center staff)

Project: State of New Jersey NJKiDS, NJ, 2006-2009

. Type: Platform/Database Modernization/Transformation

. Targets: Red Hat Linux, Fedora Linux, Oracle, SQL*Plus, SQL*Loader,

GnuPG/GPG (PGP, Encryption), PuTTY SSH/SFTP, DTR (bash, awk, HTML),

OpenCOBOL, HTML, RDP, DTR, Cygwin Linux (Win32), JAD.

. Description: As a senior consultant in the role of senior data

analyst developed a suite of daemons and controlling monitor to

operate on the ETL side of the State's transformation to the new

NJKiDS child support enforcement system. Legacy NJ ASCES was COBOL-

based. Protech Solutions handled the Java redevelopment using new

code and parts of MI and ME systems. We provided Use-Case support

using our evolving DTR product as well the daemons for unloading,

splitting, loading, packaging, and transporting. We performed all of

the legacy transformation as a subcontractor for IBM. Protech took

possession of my daemons by invoking an ownership rights clause in the

master State contact. Daemons put into use in NJ with minimal

training.

. Employed/paid by: Practical Transitions (delivery center staff)

Project: Honeywell International, MN, 2007

. Type: Platform/Database Modernization/Transformation

. Targets: Fedora Linux, Oracle, SQL*Plus, SQL*Loader, DTR (bash, awk,

HTML), Red Hat Linux support.

. Description: As a senior consultant in the role of data analyst/data

architect authored the loader control files and performed the direct

loads of Honeywell's legacy data into Oracle for archiving. Installed

the infrastructure so developers/DBAs could develop and modify

OpenCOBOL programs to provide splitting (relationalizing) of CODASYL

structures and data. Supplied Honeywell with a loaded version of our

own Data Transformation Repository presentation (HTML) tool for a

permanent, navigable record of the legacy structure and statistics.

. Employed/paid by: Practical Transitions (delivery center staff)

Project: Clearing Corporation, IL, 2006

. Type: Platform/Database/Applications Modernization/Transformation

. Targets: Sun Solaris (UNIX family), Oracle, SQL*Plus, Micro Focus

COBOL, CoSort, Hummingbird Exceed, X11, PuTTY SSH/SFTP.

. Description: As a senior consultant in the role of special UNIX

advisor to the BluePhoenix project manager, used advanced system

interrogation techniques in the shell to get project diagnostic

information to be used to make adjustments to the CoSort mechanism

that allowed IBM JCL to work like Korn shell scripting (sort of).

Developed a number of highly encapsulated shell scripts that the PM

could used to continually monitor and fix, now known, vulnerabilities

that had surfaced during discover.

. Employed/paid by: BluePhoenix Solutions (delivery center staff)

Project: Port of Felixstowe, UK, 2004-2006

. Type: Platform/Database/Applications Modernization/Transformation

. Targets: Windows Server, SQL Server, SQL, ESQL, T-SQL, Triggers,

Micro Focus COBOL for Windows (aka microfocus), Micro Focus Animator,

Fujitsu COBOL, SQL Analyzer, MS telnet/ftp, MS Visual SourceSafe

(VSS), XML, VNC, RDP, Nmap, Mandrake (Mandriva) Linux support, SDLC,

ERD, Testing: UT, SIT, Whitebox/Blackbox.

. Description: As a senior consultant in the roles of senior programmer

and systems analyst stepped in at the request of the project manager

to provide stability and bottleneck breaking to all aspects of this

port modernization project. Singularly handled the wireless programs

used by RF equipped container handlers to locate and move target

containers. Consulted on SQL Server performance and deadlock issues

with internal personnel as well and Felixstowe folks across the pond.

. Employed/paid by: BluePhoenix Solutions (delivery center staff)

Project: A. G. Edwards, MO, 2003-2004

. Type: Database/Application Field Chase/Expansion

. Targets: OS/390, TSO/E, ISPF/SDSF, BP C-SCAN (QSAM ETL), REXX,

JES/JCL, Regina REXX, Cygwin Linux (Win32), SOW.

. Description: As a senior consultant in the role of investigator and

modeler, deployed BluePhoenix C-SCAN, a flat-file relational ETL-like

software, to do impact analysis and planning of a major securities

application field expansion. Conducted What-Uses and What-Affects

analysis, performed resultant variable (item) chases both vertically,

in programs, and horizontally (across programs) for form a reliable

roadmap of modification instructions and remediation issues.

. Employed/paid by: BluePhoenix Solutions (delivery center staff)

Project: DePuy/Johnson & Johnson, IN, 2002

. Type: Oracle Post-execution Diagnostic Scanning and Reporting

. Targets: HP-UX (UNIX family), Oracle, SQL*Plus, Korn/ksh, awk,

Hummingbird Exceed, X11.

. Description: As an IT contractor consultant under the direction of

the senior data architect developed awk scanners within korn shell

wrappers to sweep the staged and trapped output results of Oracle

overnight processing. Scanned for well-known Oracle diagnostics,

complex errata indicators, and expected but missing results and

triggered email alerts to interested and responsible maintenance and

support parties.

. Employed/Paid by: Laso Corporation (on-site contractor)

Project: Shaw Industries, GA, 2000-2001

. Type: Platform/Database/Applications Modernization/Transformation

. Targets: OS/390, DB2, SQL, ESQL, SPUFI/DB2I, TSO/E, ISPF/SDSF, CICS,

VS COBOL II, Xpediter, SDLC, ERD, Testing: UT, Regression.

. Description: As a senior consultant in the role of special projects

assistant to the enterprise project manager investigated all issues of

system interfaces and integrity for various elements of Shaw

manufacturing information system (e.g. order services, inventory

control, et al.) and called upon to develop model prototypes of

CICS/DB2 OLTP using modern and advanced techniques such as leveraging

CICS temporary storage for forward looking scrolling.

. Employed/paid by: IntraComp Group (delivery center staff)

Project: Illinois Secretary of State, IL, 1998-2000

. Type: Platform/Database/Applications Modernization/Transformation

. Targets: OS/390, DB2, SQL, ESQL, SPUFI/DB2I, TSO/E, ISPF/SDSF, CICS,

CICS FEPI, CICS TS, VS COBOL II, Xpediter, SCLM, SDLC, ERD, JAD,

Testing: UT, SIT, QA, Whitebox/Blackbox, Regression.

. Description: As a senior consultant in the role of lead OLTP

developer for the "Drivers Online" subsystem guided a mixed team of

online and batch programmers and analysts to the successful, albeit

very complex, conversion of the main tools of the State's central

support cell for licenses, registrations, and titles. Also, worked

tirelessly to resolve tickets from all systems as well as special

assignment with the ISOS communications group to resolve an important

RS6000-to-CICS FEPI buffering issue. We were a subcontractor for IBM.

They provided only client-side PM.

. Employed/paid by: IntraComp Group (delivery center staff)

Project: Underwriters Laboratories, IL, 1996-1998

. Type: Platform/Database/Applications Modernization/Transformation

. Targets: HP-UX (UNIX family), Oracle, SQL, ESQL, PL/SQL, SQL*Plus,

SQL*Loader, Stored Procedures, Pro*COBOL, Micro Focus COBOL for UNIX

(aka microfocus), Micro Focus Animator, Korn/ksh/sh shells, awk,

telnet/ftp, SDLC, ERD, JAD. Testing: UT, SIT, QA, Whitebox/Blackbox.

. Description: As a senior consultant in the role of background

processing team leader of, on average 8 people, transformed hundreds

of programs to access Oracle and lay the backend support for UL's web

system. Personally concentrated on CIS (customer information) and OPR

(operations) data as well and personally and privately handled the

overhaul of the PAY (payroll) interfaces, specifically for Cyborg and

benefits providers EDI requirements. Conducted code walk-thrus.

Trainer to UL IT staff.

. Employed/paid by: IntraComp Group (delivery center staff)

Project: National Steel Corporation, IN, 1995-1996

. Type: Human Resources Benefits/Payroll Check/Advice ERP modules

. Targets: OS/390, DB2, Dun & Bradstreet Millennium ERP, DB2, SQL,

ESQL, ERD, SPUFI/DB2I, OS/VS COBOL, VS COBOL II, ISPF/SDSF, TSO/E,

REXX, JES/JCL, SOW, ERP, Testing: UT, Regression.

. Description: As a lead IT contractor consultant in the role of lead

contractor developer worked from specifications and authored many

reports and worked with the overall project leader and manager to

craft intricate and massive checks, advices, and statements for NSC's

multiple locations. Also, developed a seamless online/offline

(archive) retrieval system with a REXX wrapper to respond to union

grievance issues.

. Employed/paid by: Aerotek/Maxim Group (on-site contractor)

Internal: Comshare Inc, MI, 1989-1995

. Type: Fortune 1000 North American Support Center/CRM

. Targets: Comshare DSS, Comshare EIS, Comshare WM (document

management), Comshare ExecuView, MVS/XA, MVS/ESA, VM/CMS, TSO,

ISPF/SDSF, REXX, CLIST, JES/JCL, EXEC2, VSAM, BDAM, VTAM, Windows

3.1/NT, OS/2, OS/2 Warp, VAX/VMS, UNIX, ANSI C, NT Batch, Bourne, DCL,

W/Pipelines: DB2, Oracle, SQL/DS, CRM, Remote installations, Testing:

Alpha/Beta, Regression, Diagnostic, Designated "Applications

Consultant for the Company".

. Description: As the ranking product support consultant in the role of

server support team leader handled level 1-3 DSS/EIS product and

application support and fielded over 10,000 requests and issues while

leading this team to the Information Technology Association of America

(ITAA) Total Quality Customer Support (TQCS) award. Top priority was

Level 3 issues of strategic importance to client and company. Only

person to ever hold the "consultant" designation in the support/call

center. Numerous and frequent written testimonials (scans) from

Fortune 1000 customers. Expert guest trainer for Comshare formal DSS

training courses.

. Employed/paid by: Comshare Inc. (support center staff/consultant)

Project: Bethesda Hospital/Medicus Systems, OH, 1989-1990

. Type: Doctor/Patient/DRG Data Warehouse

. Targets: VM/CMS, EXEC2, REXX, Comshare products (System W-DSS/MOLAP,

Commander EIS/BI, Datman ADL/ETL), Window NT, SDLC.

. Description: As a senior professional services consultant in the role

of product specialist advised Medicus Systems designers in the OEM-ing

of Comshare data warehouse product to produce a market pilot for

doctors and patient multidimensional OLAP per Bethesda Hospital needs.

Paid professional trainer to Medicus and Bethesda Hospital IT staff.

. Employed/paid by: Comshare Inc. (on-site/support center consultant)

Project: Computer Task Group, NY, 1988-1989

. Type: Sales/Marketing/Revenue Data Warehouse

. Targets: MVS/TSO, CLIST, REXX, JCL, Comshare products (System W-

DSS/MOLAP, Commander EIS/BI, Datman ADL/ETL), Windows NT, SDLC, NT

Batch.

. Description: As a senior professional services consultant in the role

of project leader guided CTG IT staffers in assisting me in the

development of a revenue, marketing, and sales MOLAP data warehouse

system using mainframe server and windows clients for the execute

offices of CTG. Written commendation from the vice president and

corporate controller.

. Employed/paid by: Comshare Inc (on-site consultant)

Project: General Electric Lighting, OH, 1987-1988

. Type: Budgeting Data Warehouse/DataMarts

. Targets: VM/CMS, EXEC2, REXX, Comshare products (System W-DSS/MOLAP,

Commander EIS/BI, Datman ADL/ETL), Window NT, SDLC.

. Description: As a senior professional services consultant in the role

of team leader of Andersen (Accenture) consultants and GE IT staff

developed a distributed (DataMart) corporate budgeting Data Warehouse

and operational data store (ODS) at GE Lighting campus headquarters.

Paid professional trainer to General Electric Lighting IT staff.

. Employed/paid by: Comshare Inc (on-site consultant)

College Education

Bachelor of Science (BSL), Excelsior College, Albany, NY, 1987

Liberal Studies Option, depth areas in Mathematics, History, Computer

Science.

Military Service

United States Army, Sergeant, Military Intelligence (INSCOM) Chief, 1983-

1987

Including Community College of the Air Force School of Cryptology.

Contact this candidate