Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Timeline
Generic

John Moore

Windsor Heights,IA

Summary

Deadline-oriented Programmer Analyst with proficiency in RPG and Embedded SQL programming. Collaborative team player with commitment to building positive business culture. Focused individual with experience in testing software, diagnosing issues and documenting program development. A confident Programmer Analyst with exemplary math, analysis, and troubleshooting skills.

Overview

40
40
years of professional experience

Work History

Programmer/Analyst

LGI Inc.
12.2013 - 07.2024
  • Created and developed upload process of Wells Fargo payments file for all LGI Accounts payable transactions via pipe delimited document uploaded to Wells Fargo on demand
  • Designed and developed Certification of Analysis report providing lab testing data results to customers
  • Created Inventory data reports to provide daily or month end critically accurate data for accounting department
  • Maintained and developed EDI processes and all other incoming and outgoing documents

Programmer/Analyst

Ruan Transportation
03.2007 - 12.2013
  • Design, develop and maintain RPGIV and RPG Free programs for Accounting and Billing applications
  • Create RPG free programs to process uploads for customers to create and update orders on our system and companion reports for their analysis
  • Analyze and create specifications for new projects, applications and process improvements
  • Prepare and review unit test plans and create design and implementation documentation
  • Perform analysis and design solutions to issues opened by users

System Support Specialist

Oriental Trading Company
01.2002 - 03.2007
  • Held positions of increasing responsibility including: Application Support Specialist and Computer Operations System Specialist
  • Responsibility included documenting, tracking and resolving user and system related issues
  • Write SQL Queries, to the DB2 database using stored procedures
  • Execute daily, weekly and monthly backups on six AS/400 systems
  • Monitor servers, jobs and websites for problems
  • Tracking system statistics and web site performance through iSeries2 Navigator
  • Initiating system and web site updates to improve system performance
  • Research and resolve program errors and system messages
  • Create RPG ILE programs to monitor system jobs

Applications Support Specialist

02.1999 - 01.2002
  • Gather user system requirements; create code, test, and implement RPGIV programs in a team of programmers
  • Utilize SQL and Query for database analysis and testing in an AS/400 environment
  • Assisted in the design of solutions for existing problems, projects, and planned system implementations
  • Liaison between Programmers and the Warehouse user group
  • Developed Merchandise Valuation Report programs with corresponding user interface
  • Utilize service job debug and other debug tools to analyze and resolve program errors

Warehouse trainer

08.1993 - 02.1999
  • Responsible for training new and existing employees to operate user work stations and metering stations as well as training on other warehouse tasks relevant to improving Warehouse Operations
  • Troubleshoot and resolved workstation computer and printer issues
  • Scan and analyze outgoing packages via laser scanning device at workstations

Aviation Electrician

United States Navy
01.1985 - 01.1989

Education

IBM iSeries Programming -

Metro Community College
Omaha, Nebraska
01.2006

Skills

  • Programming development support
  • Design, develop and maintain RPG programs for Accounting, QA and Billing applications
  • Hardware and software installation
  • Software review
  • Application implementation

Accomplishments

  • .

Languages

English
Full Professional

Timeline

Programmer/Analyst

LGI Inc.
12.2013 - 07.2024

Programmer/Analyst

Ruan Transportation
03.2007 - 12.2013

System Support Specialist

Oriental Trading Company
01.2002 - 03.2007

Applications Support Specialist

02.1999 - 01.2002

Warehouse trainer

08.1993 - 02.1999

Aviation Electrician

United States Navy
01.1985 - 01.1989

IBM iSeries Programming -

Metro Community College
John Moore