Technical Skills

IBMi, AS/*** Operations, Iseries, Programming and database tools - CLP, RPG II, RPG III, RPG IV(ILE), RPG FREE, Embedded SQL, CLLE, DSPF, LF, DDS, DDL, DDM, Binder Language, Service Programs, Modular Programming, Protoypes, Called Procedures, MAPICS XA Infor, GMI, JDA, BPCS, ERP packages, Trustedlink, EDI, XML, FTP, SFTP, MKS Implementer, ALDON, TURNOVER, AGILE, Scrum, Sprint, Jira, Sharepoint, Kleinschmidt, Sterling, Confluence, X-Analysis, Abstract/Probe, CONTROL M, ROBOT, MQ series, DB2/400, AS400 Query, DBU, DFU, EZVIEW, RDI, SDA, SEU and interactive & batch processing including extensive green screen & sub-file processing.

Work Experience

NEWARK - AVNET Sept 2021 – Present

I.T. Consultant – Sr. Programmer/Analyst Chicago, IL

PayPal Project – Establish PayPal processing for U.S. Canada and Mexico markets in BPCS environment.

Credit Card Process – Troubleshoot all issues regarding Credit Card Authorization interfaces in BPCS

Gentran to SCBN EDI Project – Migrate EDI documents from Gentran to SCBN. Create new processes to retrieve incoming and build XML documents with middleware.

Water Tight Reporting – Create report that ties all order, invoice, shipping and credit card processing to ensure successful end-to-end processing in BPCS

Daily Tickets – Handle various daily tickets from business for any/all IBM processing issues.

HSBC Sept 2020 – Sept 2021

I.T. Consultant – Sr. Programmer/Analyst Buffalo, NY

CRMS project development and Production support. Analyze, code, test and implement ETL process programs using CLLE, SQL and RPG free-format language.

Design, code and test process to delete potential customers records based on electronic data file per CCPA requirement.

Develop message specs for Data Asset Pull Project

Establish iWS on IBMi for CRMS

Work with MQ message push/pull for CRMS processes

DRE – Assist and monitor disaster/recover process exercise moving IBMi data processing from onsite to DRE site. Testing and troubleshooting existing applications at each level to ensure the integrity of the systems.

Analysis and development of API for data transfer to downstream server-based software packages. This will replace present MQ message processing. Work with JSON messages for ETL processing.

Support OS upgrade to V7R4

Oversee and manage off-shore RPGLE development for numerous projects.

Monitor and investigate tickets for all CRMS based issues

Tech Knowledge Partners Aug 2019 – June 2020

I.T. Consultant – Sr. Programmer/Analyst Lombard, IL

Design, map, implement and support EDI 810, 850, 855 and 856 data for multiple clients utilizing Mapics XA and TrustedLink mapping utility

Analyze trading partner specs, design and create multiple User Exit processes using CLLE, RPGLE & SQL to generate or modify required data for incoming and outgoing EDI documents.

Create, test and implement various green screen maintenance processes using DSPF, RPGLE and SQL for managing User Exits and other EDI related processes

Convert numerous RPGIV programs to RPG Free format.

ULINE Nov 2017 – Jun 2019

I.T. Consultant – Sr. Programmer/Analyst Pleasant Prairie, WI

Permanent daily POC to receive initial help desk calls for immediate triage for users and interactive/batch AS400 jobs. Including rotating after hours POC obligation for 24/7 on call troubleshooting.

Primary EDI developer to design, implement and troubleshoot all transmission and reception of EDI data via VAN and/or direct FTP transmissions with vendors

Work extensively with PMs and business holders to design & code RPGLE/SQL applications per user requests. Aggressively support UAT, implementation and post-implementation support with user community. This includes projects for Circulation, Finance, and Invoicing.

Catalog Cutover - assist in bi-annual implementation of new catalog from IT perspective across SYS, UAT and Production AS400 environments. Testing and troubleshooting existing RPGLE applications and data feeds at each level to ensure the integrity of the systems.

Data Restore process - assist in bi-annual data restore of production data to the SYS and UAT AS400 environments. Testing and troubleshooting existing RPGLE applications and data feeds at each level to ensure the integrity of the systems.

Bank of America Merrill Lynch Jun 2016 – Nov 2017

I.T. Consultant – Sr. Programmer/Analyst Chicago, IL

Collateral Price Variation Process - In depth analysis of pricing processes for multiple Global and Tokyo Closing Price feeds for customer collateral. Design process to monitor day-to-day collateral price variations, produce variation data based on measurement criteria and delivery reports to key business recipients.

GMI Supported/Unsupported Product Reporting Process - Design, code, test and provide support process to produces multiple reports providing detail GMI support levels and restriction codes for traded products. Designed and coded separate maintenance process for establishing and maintaining supported products, support levels restriction codes and firm values. Process runs in both GMI batch and ROBOT jobs

F & O IM/VM Variance Reporting Project – Design, code test and implement processes to issue Margin Variance Report providing fluctuations in daily margin requirements based on type of margin, account type and base currency. Establish database structure and create maintenance process for static records that provide margin day-to-day variance threshold levels based on % change and exact dollar values. Process runs in batch and is also accessible via menu selection.

IPS to GMI Customer Account Interface - Design, code, test and implement modifications to IPS interface processes to update customer account information in GMI software. Modifications will provide the ability to accurately issue customer statements to the correct non-domestic accounts. In addition, this customer information data flows to other downstream applications via FTP

CREDIT SUISSE Dec 2014 – Mar 2016

I.T. Consultant – Sr. Programmer/Analyst Chicago, IL

CSSEL To CSi Project - In depth analysis of all custom written CLLE, RPGLE and SQL source code to identify and pinpoint all instances where process will require modification to handle conversion of GMI Firm values. Analysis includes all GMI batch processes in GMI based MMRUN and Control M. Document and convey analysis results to PMs and upper management. Modify, test and implemented identified programs and batch processes for GMI Firm conversion.

Pending Cash Upload Process - revise and re-write existing upload process based on new functional specs. Update code from older RPG code to RPG free format, provide new and extensive validations to include the ability for users to interrogate data prior to update. Data movement from IFS to DDL files and present data in XLS format via email.

CDR and OPUS related MQ data feeds - provide backup support for real-time based data transfers and trouble shoot issues.

JP MORGAN Sept 2012 – Sept 2014

I.T. Consultant – Sr. Programmer/Analyst Chicago, IL

Extensive in-depth analysis, design and programming for automated daily data file extraction from CCPs using FTP and SFTP file transfer

Execution of GMI applications in nightly batch processing using VBATCH (similar to GMI based MMRUN processing) for daily CCP extracted files such as Margins, PAI and Rates for LCH, CME, ICE, Eurex and OCC exchanges

Analysis, modifications and support for various in-house trade load processes using MQ and GMI API functions

Regression testing various in-house, batch and GMI processes prior to implementation

Provide RPG code reviews and analysis of full life cycle project documentation prior to implementation by fellow colleagues

DSC LOGISTICS Nov 2009 – Sept 2012

Senior Programmer / Analyst Des Plaines, IL

Consolidation of Cross Dock orders for Outbound Truck Loads

Creation and modification of Zebra label layouts and printing functionality

Converting the current Inbound and Outbound processes to use an automated Calendar scheduling process

Expansion of NMFC code values across entire AS400 system. Modify, compile and test all RPG processes to ensure data integrity.

New manifest creation process for Outbound Truck Loads

Education

BS, Business Administration, Illinois State University

Contact this candidate