Tom Mcarthur, Msis Email & Phone Number

Remote

United States

Northville, Mi

* Implement iSeries-hosted web services using JSON, YAJL, HTTPAPI, and RESTful web services * Implement and support Aldon/LMi* Create, modify, and support all variants of RPG, RPG IV, and RPG ILE* Excel SME* Excel VBA automation

Jackson, Michigan Area

• iSeries RPG IV programmer for 15+ yearso Created dozens of reports that used OPNQRYF or embedded SQLo Created RPG stored procedures to allow Excel VBA to run RPG programs and retrieve the output of those programso Aldon administrator for 5 yearso Created RPG and VBA programs to FTP data to customerso Batch and online development experienceo Used SQL and ODBC to create a PC interface that created new projects within Aldono Created multiple iSeries utilities using RPG IV and CL: Change all PFs in a library to SIZE(*NOMAX) Flag RPG Source Code Loops Highlight source code comments• Supported the Accounting department by automating Excel using VBA – 6 yearso Converted dozens of midrange/mainframe/database reports and queries into refreshable Excel reports using VBA, SQL and ODBCo All of my VBA code is well commented with lots of white space and indentation (for readability)o Created hundreds of VBA macros  My VBA code often created dynamic formulas, new worksheets, new pivot tables (or refreshed existing ones), looped through all sheets and all rows, etc. Many would “cleanup” various workbooks Many would maintain ERP database tables, thereby making users more productive Many retrieved data from multiple databases, and then combined the data into a single reporto I use a large, custom-written code library while creating my VBA macros. This makes my macro development efforts fast and efficient.o One of my VBA reports builds a dynamic SQL statement that uses 4 CTE’s (Common Table Expressions) and 2 nested SELECT statements, and is over 150 lines long when printed.• MS SQL Developer - 2 years• IT Support for Oracle Demantra - 2 yearso Used Putty and SQL Developer to support several hosted Linux servers• Lotus Notes/Domino Developer and Administrator - 15 yearso Strong knowledge of LotusScript and @Formulaso Created 100+ custom Notes/Domino Databases• Several of the above positions/roles overlapped each other

Jackson, Mi

Taught the following college classes: Intermediate Spreadsheets, Advanced Software Solutions, Enterprise Architecture, Principles of Computer Science, Electronic Spreadsheets

AS400/iSeries RPG Programmer

AS400/iSeries RPG ProgrammerEDI Programmer

Master'S Degree, Information Systems

Bachelor'S Degree, Computer Science

Associate'S Degree, Computer Programming

Hs Diploma, College Prep