Tom Mcarthur, Msis

Tom Mcarthur, Msis Email and Phone Number

IT Manager at ReviewWorks @ ReviewWorks
northville, michigan, united states
Tom Mcarthur, Msis's Location
Jackson, Michigan, United States, United States
Tom Mcarthur, Msis's Contact Details

Tom Mcarthur, Msis personal email

n/a

Tom Mcarthur, Msis phone numbers

About Tom Mcarthur, Msis

Results-oriented programmer with 30+ years of experience developing, testing, and maintaining enterprise software applications. Increased the efficiency of programming team by creating coding standards and multiple utility programs. Increased the efficiency of users by giving them easy-to-use, feature-rich reports, and by creating iSeries “reports” that retrieve data directly into Excel.

Tom Mcarthur, Msis's Current Company Details
ReviewWorks

Reviewworks

View
IT Manager at ReviewWorks
northville, michigan, united states
Website:
reviewworks.com
Employees:
52
Tom Mcarthur, Msis Work Experience Details
  • Reviewworks
    Information System Manager
    Reviewworks Jan 2022 - Present
    Remote
    View
  • Briteskies
    Senior Software Developer
    Briteskies Sep 2021 - Dec 2021
    United States
    View
  • Reviewworks
    Senior Programmer Analyst
    Reviewworks Oct 2019 - Aug 2021
    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
    View
  • Dawn Food Products
    Business Liaison / Rpg Programmer / Sql Programmer / Vba Programmer
    Dawn Food Products Nov 1995 - Sep 2019
    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
    View
  • Baker College
    Adjunct Professor
    Baker College Apr 2015 - Jun 2017
    Jackson, Mi
    Taught the following college classes: Intermediate Spreadsheets, Advanced Software Solutions, Enterprise Architecture, Principles of Computer Science, Electronic Spreadsheets
  • Dart Container
    Programmer/Analyst
    Dart Container Nov 1994 - Nov 1995
    AS400/iSeries RPG Programmer
    View
  • Kendall Electric
    Programmer/Analyst
    Kendall Electric Jan 1992 - Nov 1994
    AS400/iSeries RPG ProgrammerEDI Programmer

Tom Mcarthur, Msis Skills

Rpg Ibm Iseries Db2 Lotus Notes Os/400 Programming Database Design Access Supply Chain Sap Linux Desktop Sql Sap Apo Html Odbc Systems Analysis Databases Erp Forecasting Process Improvement Vba Microsoft Excel Excel Automation Supply Chain Management Business Process Improvement Linux Aldon Embedded Sql Microsoft Office Ifs Ftp Stored Procedures Electronic Data Interchange Spanish Data Analysis Communication Data Structures Business Logic Ile Manufacturing Change Management Analytical Skills Macro Ibm As/400 Clp

Tom Mcarthur, Msis Education Details

  • Baker College Online
    Baker College Online
    Information Systems
  • Baker College Of Jackson
    Baker College Of Jackson
    Computer Science
  • Baker College
    Baker College
    Computer Programming
  • Maple Valley High School
    Maple Valley High School
    College Prep

Frequently Asked Questions about Tom Mcarthur, Msis

What company does Tom Mcarthur, Msis work for?

Tom Mcarthur, Msis works for Reviewworks

What is Tom Mcarthur, Msis's role at the current company?

Tom Mcarthur, Msis's current role is IT Manager at ReviewWorks.

What is Tom Mcarthur, Msis's email address?

Tom Mcarthur, Msis's email address is tm****@****ods.com

What is Tom Mcarthur, Msis's direct phone number?

Tom Mcarthur, Msis's direct phone number is +151778*****

What schools did Tom Mcarthur, Msis attend?

Tom Mcarthur, Msis attended Baker College Online, Baker College Of Jackson, Baker College, Maple Valley High School.

What skills is Tom Mcarthur, Msis known for?

Tom Mcarthur, Msis has skills like Rpg, Ibm Iseries, Db2, Lotus Notes, Os/400, Programming, Database Design, Access, Supply Chain, Sap, Linux Desktop, Sql.

Who are Tom Mcarthur, Msis's colleagues?

Tom Mcarthur, Msis's colleagues are Pier Marchese, Donna Canzoneri, Robert Bartlett, Belinda Walker, Pamela Drost, Dianne Mateja, Brianna Egbert Rn, Bsn, Ccm.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.