PROFILE

Experienced and accomplished professional with over 25-years of experience in application analysis, design, development and maintenance in IBMi/AS400/iSeries platform with emphasis on RPG/400, RPGIV, ILE, CLP, DB2, SQL.

SKILLS

Skills Overview:

Over 25-years of experience in ALL facets of iSeries/AS400; from Operations and Administration to full life cycle development including analysis, design, coding, testing, debugging, documenting and support & training.

Programming:

RPG including RPGII, RPGIII, RPGIV, RPG-FREE, ILE, Interactive and Embedded SQL, CL, DSPF, Printer files (RLU), Subfiles, DDS, DDL, PF, LF, APIs, Sub-procedures, Modules, Service Programs etc. Knowledge of COBOL.

Utilities:

SEU, PDM, Query/400, DBU, DFU, TAATOOLS, Hawkeye, ROBOT Job Scheduler, iSeries Navigator, Client Access, ACS, SQL Stored-Procs, familiar with RDi.

Change Mgmt.:

Turnover, Aldon LM, Implementer

ERP:

J.D. Edwards (JDE) World 7.38, EPICOR, PRMS, BPCS

Other:

System operations, administration and security functions, Work Management, Journaling, Advanced Job Scheduler, FTP (File Transfer Protocol), IFS (Integrated File System), XML (Extended Markup Language), Data Queues.

Industries:

Supply Chain and Distribution, Manufacturing, Healthcare, Consulting, Custom In-house development.

Other:

MS Office 365, Windows, familiar with Networking concepts, TCP/IP, ODBC/JDBC.

EXPERIENCE

Infoview Systems, Livonia, MI

Feb. 2020 – Present

Developer/Consultant

Involved in Data conversion and integration of Waste Management's acquisition company. Devised a Subfile interface to enumerate and provide a "bird's eye view" of various stages of a data set's conversion progress.

Facilitate, code and/or enhance conversion processes to allow for custom processing of the data, primarily using SQL.

Be a part of "Go-live" each month for a given "Wave" of Data Sets being converted and implemented into Production. Provide support & resolve post conversion/implementation issues.

CDW, Chicago, IL

Apr. 2019 – Jan. 2020

Developer/Consultant

Involved in Item Master trigger project to e-commerce Product Mgmt. Information team using SQL stored procedure in DEV/QA/Production environment.

Devised a generic utility AS400 command-based program involving extensive use of SQL to map, convert, upload, and integrate Excel (.csv) based data from within IFS to corresponding IBMi database files.

This helped save tremendous amount of time, money, and manual effort of coding, testing, and maintenance of multiple objects per each data file being converted to IBMi.

Werner Enterprises, Omaha, NE

Dec. 2018 – Apr. 2019

Developer/Consultant

Identified, updated, tested, and documented close to 400 RPG programs to use the new trigger process.

Silveredge Consulting, Inc., Westchester, IL

Feb. 2017 – Oct. 2018

Staff Consultant

Enhancement and Support of PRMS based applications on IBMi/AS400 using RPG/CLP/SQL for another major Healthcare client – Depuy, Inc. – a subsidiary of Johnson & Johnson, Warsaw, IN.

IBMi/AS400/iSeries project using DB2, RPG-Free, ILE, SQL, and CLLE for a major Healthcare Insurance industry client (Delta Dental of WI) within SCRUM/Agile Environment.

Capgemini USA LLC, Atlanta, GA

Dec. 2014 – Jan. 2017

Sr. iSeries Consultant - An Office Supply Client, Itasca, IL

Involved in development, support and integration of client’s Order Management System.

Conceptualized, designed and implemented historical data migration from iSeries (AS/400) to BI servers (DataStage/ParAccel) using Journaling concepts.

Automated several manual tasks, thereby saving costs and improving SLA’s, gaining in efficiency. Resolve helpdesk tickets and issues; on-call rotation.

Coordinate system support and development activities with offshore team. Mentor and train teammates with iSeries related technical issues.

Readerlink Distribution Services, LLC, Oak Brook, IL

Sep. 2013 — Nov. 2014

Sr. Programmer Analyst – iSeries/AS400

iSeries/AS400 programming, analysis, design, enhancement and support of in-house Retail, Distribution, and Warehouse based applications using RPGIV, Free-format, Embedded SQL.

Data conversion, processing and support of customer’s orders using FTP related data from SQL server to iSeries.

Support, maintain and evaluate conversion of legacy RPG applications to free-format, RPGIV standards where applicable. On-call rotation and user support.

Power Plant Services, Inc., Melrose Park, IL

Jan. 2012 — May 2013

Business Analyst/Training Coordinator

Instrumental in analyzing and establishing enterprise-wide business process flow. Initiated documenting functional user guide by department for various EPICOR ERP related software modules.

Devised, conceptualized and implemented training programs...first, by way of Presentation training, and subsequently, an online video-based training program (LYNDA.COM). Developed reporting solution using MS Access, Excel and Mail-merge facility of Word.

Helped in streamlining Marketing projects; compiled and consolidated various Power Generation customer database and their turbines related products & service details.

Analyzed annual Sales data in establishing trends using QlikView - the BI (Business Intelligence) tool. Devised ad-hoc and various other Excel based Sales related reports.

Baxter Healthcare Corp., Deerfield, IL

Oct. 2000 — Aug. 2010

Systems Consultant — AS400/iSeries

Maintained and enhanced J.D. Edwards World (7.38) applications and provided native iSeries/AS400 Systems programming support using RPG, CL, and SQL.

Engaged in production database analysis, support, correction, extraction, conversion and management; primarily using SQL.

Devised a data-refresh process to periodically refresh the data in Test, Integration, and Q/A environments/LPARs.

Achieved significant run-time gains through optimizing database by creating SQL indexes and LFs, purges. FTP Data transfer, Aldon, Hawkeye, Data Mirror.

Additional Job History Summary:

Dynamic Systems Resources, Rolling Meadows, IL

AS400 Consultant/Analyst

02/1999 — 08/2000

Interactive Business Systems, Oak Brook, IL

AS400 Consultant/Analyst

11/1997 — 01/1999

Delray Farms, Inc., Chicago, IL

AS400 Programmer Analyst

04/1997 — 10/1997

Synergy Software, Inc., Schaumburg, IL

AS400 Consultant/Analyst

07/1996 — 04/1997

Midas International Corp., Chicago, IL

AS400 Programmer Analyst

06/1993 — 07/1996

H.P. Smith, Inc., Bedford Park, IL

AS400 Programmer/Operator

07/1990 — 01/1993

Marks Bros. Jewelers, Inc., Chicago, IL

System/36 Operator

09/1989 — 07/1990

Sassafras Enterprises, Inc., Chicago, IL

System/34 Operator

02/1986 — 08/1989

EDUCATION

UNIVERSITY OF BOMBAY, BOMBAY, INDIA - B.S. IN BIOLOGY, 1980

PROFESSIONAL DEVELOPMENT

Programming and IT related courses at local community colleges; College of DuPage, Glen Ellyn, IL; Moraine Valley Comm. College, Palos Heights, IL.

Attended COMMON and LUG (Large User Group) conferences.

Subscribe to IBMi/Midrange computing related publications/newsletters and member of various IBM AS/400 related websites and forums.

Training in DataStage ETL tool – May 2011.

Pursuing online technical resources and educational opportunities on an ongoing basis.

Contact this candidate