We provide IT Staff Augmentation Services!

Programmer/analyst Resume

Pittsburgh, PA

SUMMARY

  • 30 Years of IT experience in Confidential AS400 (iSeries) applications in analysis, design, development, maintenance and testing using OS/400, DB2/400, RPG/400, RPGILE, RPGIV, RPGIII, RPGII, SQL, CL/400, QUERY/400, BASIC, DBU.
  • Proficient in program creation and support, DDS, SDA, Subfiles, System Operations and Hardware configuration and installation.
  • EDI Trusted Link experience.

TECHNICAL SKILLS

HARDWARE: IBM i - Series, AS/400, PC 

OPERATING SYSTEMS: IBM OS/400, CLP, DOS, Windows

DBMS: IBM DB2/400

LANGUAGES: IBM RPG, RPG IV, RPG ILE, RPG Free, SQLRPGLE, CL, SQL, COBOL

UTILITIES: SDA, PDM, SEU, DFU, RLU, MQ Series, Websphere, RDI and Query

APPLICATION SOFTWARE: PRMS, Lawson, Warehouse Boss, Friedman

EXPERTISE: RPG / CL Program creation and modification, File (DDS)(DDL) support, EDI X12 Trusted Link, SQL and RPG free Subfiles, Open Query Files, Security Officer tasks, hardware configuration

AS/400 TOOLS (Change Mgmt): Hawkeye, Implementer, Aldon, DBU, TurnOver, Abstract, ROBOT

OFFICE AUTOMATION TOOLS: MS Office, VISIO

PROFESSIONAL EXPERIENCE

Confidential - Pittsburgh, PA

Programmer/Analyst

Responsibilities:

  • Part of a large programming group dedicated to upgrading custom health insurance software.
  • The largest program touched was around 80,000 lines.
  • Program upgrade involved making programs more modular, files were changed to SQL generated DDL files.
  • Some of the work was done in an Agile environment.
  • This site has a test environment as well as several production sites. On site 5 days / week, remote 5 days/week.
  • This medical establishment has 80,000 employees, including 1000 MD’s.

Environment: SQLRPGLE, RPGLE, CLP, Query, DB2/400, on Confidential AS400 (V7R3), (i-Series)

Confidential - Richardson, TX

Programmer/Analyst

Responsibilities:

  • The general goal for Frontier is to improve program efficiency because of a huge increase in the customer base.
  • Modify programs to reduce flat file usage and use a relative database model.
  • Part of a large programming group.
  • New coding involved SQL for file input/output and extensive usage of service programs.
  • Largest program touched was 15,000 lines. On site 1 week/month, remote from my basement the rest of the time.

Environment: SQLRPGLE, RPGLE, CLP, Query, DB2/400, on Confidential AS400 (V7R1), (i-Series)

Confidential - Waukegan, IL

Programmer/Analyst

Responsibilities:

  • Design and analysis to increase productivity.
  • Custom software to facilitate billing between domestic and/or international company affiliates.

Environment: RPGLE, RPG, CLP, Query, DB2/400, on Confidential AS400 (V5R4), (i-Series)

Confidential - Highland Heights, KY

Programmer/Analyst

Responsibilities:

  • Design and implementation of a security audit system of 60 files and programs across a dozen systems.
  • This identifies persons with authority to both buy and receive items (plus other security issues).
  • Contract completed on schedule.
  • Programming with RPGLE free and SQL.

Environment: RPGLE, RPG, CLP, SQL, Query, DB2/400, on Confidential AS400 (V7R1), (i-Series)

Confidential - Middlebury, IN

Programmer/Analyst

Responsibilities:

  • Software Upgrade for Friedman ERP manufacturing software - migrating from 2.1 to 3.1 version.
  • Assisted in updating and migrating 1500 programs (modified software) to interface with an upgraded version (3.1) Friedman software.
  • This was a successful production cutover in November 2014.
  • Some smaller projects were also revised and implemented during this period.
  • Modified RPG programs were upgraded to RPGLE.
  • Programming was done with RPGLE and SQL.

Environment: RPGLE, RPG, CLP, SQL, Query, DB2/400, on Confidential AS400 (V7R1), (i-Series)

Confidential - Pittsburgh, PA

Programmer/Analyst

Responsibilities:

  • Short term project loading files based on scanner data.
  • Intensive RPG free and embedded SQL - no RPG F specs used for this project.
  • These files were then used for reports based on Business Objects.
  • Contract completed on schedule.

Environment: RPGLE, RPG, SQL, CLP, Query, DB2/400, Websphere on Confidential AS400 (V7R1), (i-Series), multiple AS/400 computers and partitions, multiple companies (probably the most complex i-Series installation in the country)

Confidential - Jasper, IN

Programmer/Analyst

Responsibilities:

  • Provided intensive production support for EDI including the EDI support mailbox.
  • Production support was also provided for the i-Series 24/7 operation. Created and modified EDI maps as necessary.
  • Provided support for i-Series program maintenance as well as EDI projects. Worked with off shore personnel.
  • This company is in the process of shifting operations to Oracle.

Environment: RPGLE, RPG, CLP, FTP, Query, DB2/400, on Confidential AS400 (V6), (i-Series), Multiple i-Series partitions, mainframe and servers - Data transfer through FTP procedures

Confidential - Montgomery, AL

Programmer/Analyst

Responsibilities:

  • Provided production support for Vital Statistics (birth and death certificates), plus maintenance project/programming assignments as needed to help production effectiveness.
  • Programming was done with RPG, RPGLE, COBOL and embedded SQL.

Environment: RPGLE, RPG, COBOL, CLP, Query, DB2/400, on Confidential AS400 (V5R4), (i-Series)

Confidential - Pittsburgh, PA

Programmer/Analyst

Responsibilities:

  • Provided production support for downstream accounting service measurement, plus maintenance project/programming assignments to better determine driver delivery effectiveness.
  • Programming was done with RPGLE, embedded SQL and RPG free using Websphere (Rational Developer).

Environment: RPGLE, RPG, CLP, Query, DB2/400, Websphere on AS400 (V6R1), Confidential (i-Series), multiple AS/400 computers and partitions, multiple companies (probably the most complex i-Series installation in the country)

Confidential - Quincy, IL

Programmer/Analyst

Responsibilities:

  • Programming maintenance work with PRMS 8.4 programs, worked on 44 accounting projects (some new development)
  • Using SOX compliant change management system based on Implementer.
  • Creation of formal testing scripts for each of the projects that I worked on. Q/A then evaluated the scripts and either promoted or rejected the implementation.

Environment: RPGLE, RPG, RPG Free, CLP, Query, DB2/400, Websphere on AS400 (V5R4), Confidential (i-Series), multiple AS/400 partitions, multiple companies

Confidential - Pittsburgh, PA

Programmer/Analyst

Responsibilities:

  • Provided project support for accounting fiscal year modifications, analysis and programming for Confidential contractor's compensation working under the direction of the Settlement Department.
  • Second assignment area - International Group, modify information available to terminals, data (EDI) sent and received from US Customs.

Environment: RPGLE, RPG, CLP, Query, DB2/400, AS400 (V5R4), Confidential (i-Series), multiple AS/400 computers and partitions environment, multiple companies

Confidential, Middlebury, IN

Programmer/Analyst

Responsibilities:

  • Designed and helped implement an AS/400 e-mail system for non-PC work stations
  • Designed and helped implement a production status system for use by the production floor.
  • This helps provide almost real time information upstream and downstream of a production station.
  • Provided production support for PRMS.
  • Middleware modification -- provided interface support between PRMS and Warehouse Boss
  • Shipping - created Commercial Invoice, modified packing list, created export papers
  • Shipping - attach freight to super orders, link freight information to online programs
  • Interface - provide on-line real time data transfer between PRMS and Warehouse Boss
  • This process is similar to a data queue, except a file was used.

Environment: RPGLE, RPG, CLP, SQL, Query, DB2/400, Hawkeye, ROBOT, DBU on Confidential AS400 (V4R5), (i-Series)

Confidential, Nappanee, IN

Programmer/Analyst

Responsibilities:

  • Replaced/rebuilt a multi-million dollar rebate system to reward the better dealers. (This 6 month project retained about 1/3 of the original code.)
  • Middleware modification - linked custom programs to Lawson name and address information (400 programs)
  • Coordinated much of the Year 2000 (Y2K) software efforts (3 man years)
  • Enhanced the Gulf Stream RV Travel Club account system to function better.
  • Converted the spool file check output from Lawson to a laser printed check.
  • This required modifying the Jetform (Java) system.
  • Simplified the annual price changes for new models, converted to a file/table driven format.
  • Middleware modification - supported and enhanced production line labor payroll system.
  • Set up a new system to generate Manufacturer Suggested Retail Price Stickers
  • Middleware modification - Provided support for the annual standards price modifications.
  • Revised / rebuilt and maintained a system to handle material rejections.
  • Provided operations backup as needed.
  • Responded to daily maintenance requests on a priority basis.

Environment: Confidential RPGLE, RPGIV, RPG, CLP, SQL, Query, Hawkeye, Turn Over, DBU, VISIO, MS OFFICE.

Hire Now