Rpg Iseries

Arturo Hartnack

(***) *** – ****

*********@*****.***

SUMMARY:

More than 15 years experience in successful development, maintenance, implementation and conversion of various applications in the Distribution, Financial and Manufacturing businesses utilizing the IBM iSeries (AS400) environment programming in RPG Free, RPG ILE, RPG IV/III/II, SQL, CL, DDL, DDS, Query, HTML, XML. Successful conversions of applications to SAP/R3, Oracle, UNIX, EDI (True Commerce).Excellent communication and interpersonal skills with the ability to work well independently or as part of a team.

TECHNICAL SKILLS:

Hardware: IBM iSeries(AS/400), PC's

Software: RPG Free, RPGILE, IV/III, SQL, CL, DB2 DDL, DB2 DDS, Query, JD Edwards, BPCS, XML, XSLT, Macro interface with IFS, Navigator, True Commerce, Aldon, Turnover, Hawkeye, Client/Access, Excel interface, TL Ashford, Rumba. Coursework in C#, JAVA, HTML, CGI, ORACLE and UNIX.

EXPERIENCE:

Kuehne & Nagel August 2017 – December 2021

Developer/Consultant

Development and maintenance of applications in the Shipping/Delivery business.

Interface of applications between the iSeries and the Web using XML, XLST file transmission/storage. Free format RPG programming using embedded SQL.

Broadridge Financial June 2016 – August 2017

Developer/Consultant

Conversion of applications to Web based applications for The Royal Bank of Scotland(RBS).

Heavy interface between the iSeries and the Web using ICI Impact. File conversions using XML in the Banking Industry. Free format RPG programming using embedded SQL in static and dynamic format.

FlightSafety International June 2015 – April 2016

Developer/Consultant

Conversion of applications through Net.Data into Microsoft Servers and enhancement of iSeries web-based applications using HTML, XML in the Aviation business. Heavy SQL usage thru Apache for Web pages using RPG programs for data extraction interfacing with PHP programs and SAP applications. Also, the decommissioning of iSeries computers so data is unusable.

Michael Kors January 2015 – June 2015

Developer/Consultant

Successful deployment of a Physical Inventory tracking system interfacing between RLM(Ron Lynn) and WMi in the Garment Distribution field. Programs written in RPG Free with embedded SQL.

Manhattan Supply Co. August 2013 – October 2014

Developer/Consultant

Successful conversion of a Transaction-based system interfacing with JD Edwards in the construction distribution field. Applications written in RPG Free with embedded SQL, prototyping, DDL(instead of DDS).

YMCA of Greater New York. June 2012 – July 2013

Developer/Consultant/Administrator

Successful conversions of various applications to Oracle and automation of applications interfacing with .Net/Windows/Unix servers through Navigator(IFS). Development and enhancements of applications written in RPG Free, RPG ILE with embedded SQL, XML, HTML interfacing with Web applications using Macros and CGI.

Power’s Fasteners. Inc. November 2011 – March 2012

Developer/Consultant

Enhancements of Accounts Payable, Accounts Receivable, General Ledger in-house programs written in RPG Free, RPG ILE with embedded SQL Also, on the fly conversions of data files/reports to Excel.

Page 2 Arturo Hartnack

NASDAQ OMX February 2011 – November 2011

Developer/Consultant/Administrator

Auditing of the FOMS Trading system. Maintenance and enhancements of existing programs written in RPG Free, RPG ILE, with embedded SQL.

Louis Hornick& Company April 2007 – Sept 2009

Programmer/Analyst, Developer /Administrator

Enhancements and maintenance of applications in the Distribution business. Conversion of applications to EDI (True Commerce) using invoicing(810), Orders(850), Acknowledgements(855), Ship Notices(856) transactions interface written in RPG Free, RPG ILE, SQL. Also worked with TL Ashford labeling software with scanning devices.

Sharp Electronics Corp October 2006 – April 2007

iSeries(AS/400) Consultant/Administrator

Conversion of AS/400 applications to SAP/R3 . Maintenance of remaining applications as required. Programming in RPG Free, RPG ILE, SQL with Sub-file processing, Data Queues and labeling software

(TL Ashford) and scanning devices.

JP MORGAN CHASE September 2005 – July 2006

Developer/Consultant

Successful development and implementation of a User Access Synchronization system for all user access to iSeries (AS400) servers worldwide. Finished the project ahead of schedule after starting it behind schedule. Programming done in RPG ILE, RPG Free, SQL with Sub-file processing. Loading of Excel spreadsheets from the iSeries(AS/400) and FTP of spreadsheets, programs and files to servers worldwide.

FORD MOTOR COMPANY/VOLVO CARS OF N. A. August 2004 – April 2005

iSeries(AS/400) Programmer Analyst

Programming in RPG ILE, CL, SQL, Query on the iSeries(AS400). Development and enhancements of applications in the Manufacturing business. Worked on behind schedule projects in the Parts System to bring them up to date using Aldon CMR, Sarbanes-Oxley (SOX) Compliance

BANCA INTESA September 2000 –May 2004

Sr. AS/400 RPG Developer, Administrator

Programming in RPG ILE, RPG/400, CL, SQL, Query, Client Access, FTP, Web work(HTML, CGI) TCP/IP on the AS/400. Development and enhancements of applications from the head office in the banking business. Worked closely with users of all departments to amend applications to user's requirements. Enhanced numerous applications from manual entry to a fully interactive non-user interface programs to cut down on data entry. Enhanced additional programs to be fully Windows compliant(e.g., Mouse-driven instead of keyboard driven). Conversion of programs from RPGIII/IV to RPG ILE.

EDUCATION:

A.A.S Degree in Computer Science from Westchester Community College, Valhalla, NY

LANGUAGES:

Spanish - Total fluency in reading, writing and speaking.

Contact this candidate