Resume

Sign in

Senior IBM i Developer. RDi for iSeries

Location:
Manorville, New York, United States
Posted:
November 18, 2018

Contact this candidate

Resume:

Alex Montalvo

980-***-****

ac7qgk@r.postjobfree.com

https://www.linkedin.com/in/alexmontalvo

SKYPE ID Alex.Montalvo27

PROFESSIONAL SUMMARY

Team Lead Systems Analyst /Tester experienced in Applications development and enhancement of ERP Systems and systems analysis using the iSeries (IBM i) coding in RPG IV ILE, COBOL, CL using Query/400, SQL/400 DB2, DDS. Collected data via Query/400, SQL, and OS/400 commands for destructive testing of new and updated programs for data integrity.

Worked with IFS, FTP, SQL native and embedded, DOS scripts, Sterling MFT, and Pervasive Data Junction Integration Manager for cross platform transfer of data. Created and change inbound/outbound EDI mapping. iSeries, EDI transactions (810,820, 850, 856,214).

Experienced with stored procedures and service programs with excellent communication, interpersonal skills. High Interaction with end users, IT Management and staff experience achieving consistent customer satisfaction.

Experienced with gathering user requirements developed specifications & flow charts, application program development, static & integration testing, and deployment. Data Migration Specialist using Data Junction/ Pervasive software/ Repository Explorer & Map Designer. Data Mapping and conversion and formatting from comma delimited format to Excel and DB2/400

Experienced with all aspects WMS systems including Warehouse Inventory Operations including Item Inquiry, Allocations, Transfers, Receipts, Manifest.

TECHNICAL EXPERIENCE

Midrange:

iSeries, RPG ILE, RPG III, COBOL, SQL/400, Embedded SQL,OS/400, V5R2- V7R1, CLP, QUERY, EDI, DB2, Aldon/CMS TURNOVER, DBU, SEU, PDM, FEU, RLU, SDA, EDI, ERP, ECM, PowerMHS, VAI System 2000, MKS Integrity, APlus, ROBOT Job scheduler, CGIDEV, FTP, Cute FTP, Visio Pro, Groupwise, Crystal Reports, Compleo, Zebra, SunGard GMI.

Enterprise:

TRIOLE (TFS), MACESS, CONTROL-M, IPD, MOBIUS, UNIX, Sterling MFT, Microsoft LYNC, RDi 80, X-Analysis

Mainframe:

MVS, OS 390 RPG II, CICS, COBOL, DB2, focus, BAL, IBM Utilities, JCL, SAS, TSO, VSAM

Windows:

MS Outlook, MS Lync, MS/DOS Open Office 365, Document Direct 2.3 Mobius, Service Center, Windows NT Admin 4.0, XP Professional, Workstation and Server. HTTP, TCP/IP, Cisco/Telephone System, Lotus Notes, VCN, VPN, Pervasive Software Data Junction, XML, HTML, DOS, Robocopy, Adobe Acrobat 8.0 Professional, Excel Macros, Auto Split Professional, A+, Bitlocker

Hardware:

IBM Midrange: iSeries

IBM Mainframe: 370, 3081, 3083, 4381, 4341, 3090 &3090E.

DASD: 3380, 3350, 3330.

Networking: Netopia, Cisco, Westell

EDUCATION

Empire Technical School, Manhattan, NY

Mainframe Programming Training - COBOL, BAL, RPG 2, 3, JCL

NETCOM Long Island City, NY

WEBSPHERE, PL-SQL, JAVA Programming

St. John’s University, Queens, NY Major Biology/Chemistry Athena and EPIC EMR

PROFESSIONAL EXPERIENCE

IFIC NEWARK, NJ Feb 2018 – Present

Senior Consultant Developer/ Production Support Programmer Analyst

Project development Surety Production Support Contract and Claims Support.

Creation of Bond Codes General Ledger transaction posting file system for Accounting.

Data extracts for General Ledger postings for monthly, quarterly, and yearly totals.

Development of Production Systems for Bond Contracts and General Ledger.

Accounts Payable and Accounts Receivable modifications and new project work.

Production support for Bond, Bond Claims and reserves.

Programs with Stored procedures using RPG free with embedded SQL.

Technologies:, iSeries V7R3, RDI 9.6 RPG/400 ILE, FREE OS/400, DB2, SQL

MERCOM GROUP Berlin, NJ May 2017 – Feb 2018

Senior Consultant Developer/ Production Support Programmer Analyst

Project development in Micro strategy data migration project Windows 2012 server AS/400 to RMS Oracle Database.

Programing development and Production Support for SBARS systems in house developed software.

Creation of RPG/400 ILE programs from Backlog, Production support and user requests and IT management.

Development of applications for projects based on Business Requirements Specifications, Software Requirements and Detailed Designed Specifications.

Using Zebra Printer command codes to format labels in DDS for RPG programs and associated CLP and DDS display files after extensive destructive testing using copy of live data for program integrity.

Responsible for administrative and operational tasks system backups IPL’s Disaster recovery.

Technologies:, iSeries V5R4, RPG/400 ILE OS/400, DB2, SQL, CLP, OS/400, ZEBRA

THE HARTFORD Hoboken, NJ May 2016 – Apr 2017

Senior Consultant Developer/International Claims Project/ WINS Support

Specialized in applications development for WINS Software and homegrown systems for Underwriter Warehouse Systems Support Team for applications development.

LAP International Claims data migration and applications development for project processing new claims to inbound system via MFT application programming and database creation for inbound process

Project involved research analysis coding and documentation for 150 CL COBOL program modifications of all reports and feeds involving Policy files with international affiliation

Use of complex Dynamic Logical Files DLF’s compound Query files feeds and complex Joined Logical files.

Creation of RPG ILE and COBOL and Embedded SQL application Programs

Development of applications for projects based on Business Requirements Specifications, Software Requirements and Detailed Designed Specifications.

iSeries ILE RPG and COBOL and embedded SQL

iSeries Claims system Linkage RPG / Embedded SQL Programs used to interface with browser integration VISION, PRONTO Web application Insurance Underwriter process system using HTML,

Technologies:, iSeries V7R1, RPG ILE COBOL OS/400, DB2, SQL, CLP, OS/400, MKS/ IMPLEMENTER, TOMCAT, RDi 80, X-Analysis

EMBLEM HEALTH (GHI) New York, NY Jan 2016 –Apr 2016

Senior Analyst/Tester/ Systems Applications Support/Contractor

EDI Systems Analysis development of applications for Data Match Project MSP for Emblem Health/GHI Customer Support.

Versed in Medical terminology via Athena EMR

Medicare BCRC EDI Helpdesk/Troubleshooting in-bound calls from Businesses and authorized designees.

Heavy interaction with internal/external community to assist with CMS /EMQ application process within the COBSW web portal.

Responsible for HIPPA compliance maintaining PHI, PII, FTI confidentiality for data security for GHP and NGHP to insure CMS SSA and IRS agencies data sequencing.

Programming development and maintenance including coding testing for Emblem Health COB-R Data Match MSP project thru July of 2016.

Development of applications for projects based on Business Requirements Specifications, Software Requirements and Detailed Designed Specifications.

iSeries, ILE RPG, COBOL and SQL, coding along with Mainframe JCL TSO, CICS EDI utilized.

Technologies: MAINFRAME, TN3270 EXTRA X-TREME, JCL, CICS EDI, iSeries V5R4, RPG ILE COBOL OS/400, DB2, SQL, CLP

STEVE MADDEN, LTD Long Island City, NY Sept 2015 – Dec 2015

Senior Developer Analyst/ Production Support iSeries/ Tester/Contractor

Project Design application development and program maintenance including coding RPG ILE testing for all of Steve Madden related iSeries systems and ongoing projects.

Experienced with Point of Sale systems retail operations including Invoicing, Billing, AP, AR, GL, Sales Analysis and Sales History on the iSeries.

WMS systems work involving Warehouse Inventory Operations including Item Allocations, Transfers, Receipts, Manifest.

Development of projects based on Business Requirements Specifications, Software Requirements and Detailed Designed Specifications.

Third party O.R.S.I POS integration of e-commerce system for Retail support of Business.

RPG and COBOL coding in ILE environment utilized.

E-Commerce browser integration front end using HTML5, XML, and JAVA linkage synchronization with RPG Backend

Technologies: iSeries V7R1, RPG ILE COBOL OS/400, DB2, SQL, CLP, OS/400 CGIDEV, WEBSPHERE, RDi 80, X-ANALYSIS

FED EX Canonsburg, PA May 2015 – Sept 2015

Senior Developer Analyst/Tester/ Production Support iSeries/Contractor

Project Design application development and Program maintenance including coding testing for all of FedEx related RPG ILE systems and ongoing projects.

Experienced with Point of Sale systems retail operations including Invoicing, Billing, AP, AR, GL, Sales Analysis and Sales History.

Warehouse Management System WMS for tasks for this project included data synchronization replication of updated package information in real time from pickup, between transfer points and final destination to all 4 regions Eastern, Central, Midwestern and Western.

Development of projects based on Business Requirements Specifications, Software Requirements and Detailed Designed Specifications.

In house POS warehouse distribution system for wholesale and retail businesses.

RPG and COBOL coding in ILE environment utilized.

Use of MS Lync to record knowledge transfer sessions team members interoffice communications including multimember conferencing for support issues

Use of Turnover change management, CMS Aldon, Tracer Ticketing system

Technologies: iSeries V7R1, RPG ILE COBOL OS/400, DB2, SQL, CLP, OS/400

OFFICE MAX Chicago, IL Nov 2014 – Apr 2015

Senior Developer Analyst/Production Support/Contractor

Manager for Onshore Production Support Team for the Office Max/ Office Depot Merger and ongoing projects.

Experienced with applications development and program maintenance for Point of Sale systems retail operations including Invoicing, Billing, AP, AR, GL, Sales Analysis and History.

Warehouse Management System maintenance Service request work included Inventory Operations Scanning in items Allocations, Transfers, Receipts, Manifest.

Coordinating with off shore teams to handle all aspects of production support.

R.A.C.E. In house POS warehouse distribution system for wholesale and retail businesses.

Application development using RPG and COBOL coding in ILE environment.

Use of Turnover change management, Remedy ticketing system, Microsoft LYNC, communicator

Use of MS Lync to record knowledge transfer for team meetings and communications

Technologies: iSeries V6R1, AS/400, RPG ILE COBOL OS/400, DB2, SQL, CLP, OS/400

BLUE CROSS BLUE SHEILD NORTH CAROLINA, Durham, NC Aug 2013 – Sept 2014

Senior Developer Analyst/Team Lead/Conctractor

Claims & Adjudication Manager for BCBSNC ISBA for iSeries Production Support Team On Call.

New department involving handling all production issues for their Claims processing, Adjudication and Membership issues.

Flowchart and documentation of existing systems through KAP and Reverse KAP sessions.

Maintaining standards and practices of BCBSBC and ITS association compliance.

Created and completed service requests for Claims issues including: Code modifications, DST Defect forms, Type 1 documents, File restorations, Job Creation and Reinstatements, MFT setup and configuration.

Use of MS Lync to record knowledge transfer sessions team members interoffice communications including multimember conferencing for support issues.

RPG and COBOL used in ILE environment utilized.

Updated and maintained PowerMHS surround code for Claims processing systems.

Utilized Control M job scheduler for researching jobs, restarting, editing streams adding new jobs and removing obsolete entries.

Technologies: iSeries V6R1, AS/400, RPG ILE COBOL OS/400, DB2, SQL, CLP, OS/400, RDi 80, X-ANALYSIS, CONTROL M

LAPP USA, Florham Park, NJ Jun 2011 – Aug 2011

Senior Application Developer / Systems Analyst/Contractor

iSeries, Consultant Automating Data Migration Project involving Month End Processes.

Experienced with Point of Sale systems retail operations including Invoicing, Billing, AP, AR, GL, Sales Analysis.

Use of IFS on the iSeries to migrate data from Windows server via script.

Running SAP Reports load process to Excel Spreadsheets Scheduled SAP migration and automation of Month End Process to the iSeries.

Technologies: AS/400 iSeries V5R4, SAP, MS Excel,

INDEPENDENCE BLUE CROSS, PHILADELPHIA, PA Nov 2010 – Apr 2011

Senior Developer Analyst/Contractor

Project Team Leader iSeries Consultant Project for PAPPO and AHPPO Par Professional Providers Criteria Project involving a real-time solution for the processing of Header and Detail claims records process through their system end rejected due to data errors.

Creation of frontend RPG ILE Menu Driven system on the iSeries with backend RPG ILE, CL programs as per Functional Program Specifications.

Complex multi format menu DSPF creation multiple windowed screens in RPG driven sub-files.

Creation of operational documentation including screen shots as well as Flowcharts.

Use of MS Lync to record knowledge transfer sessions team members interoffice communications including multimember conferencing for support issues.

Collected data via Query/400 SQL and OS/400 commands against DB2 files for destructive testing of new and updated programs for data integrity.

Extensive use of sub files, physical and logical files, display and print files in RDBMS.

Technologies: AS/400 iSeries V5R4, SQL, OS 400, DB2, RDBMS, OS 390 RPG,

VIRGIN GROUP WORLDWIDE, Long Island City, NY Jul 2009 – Nov 2010

Senior Developer Analyst/ Tester/Contractor

iSeries Consultant to a Team of 15 consultants to Global Chief Technology Officer for new project in planning stages.

The project is involving creating an iSeries DB2 database system allocation of files.

Collected data via Query/400, SQL/400, and OS/400 commands against DB2 files for destructive testing of new programs for data integrity.

Modification and enhancements of RPG ILE, CL programs as per program specifications.

Extensive use of sub files, physical and logical files, display and print files in RDBMS.

Used SQL and Query/400 commands, to run ad hoc reports and inquiries on demand for multiple purposes including assisting QA testing of RPG ILE programs.

Technologies: AS/400 iSeries V5R2, DB2, SQL, OS 390 RPG, CL, OS/400, RDBMS

UBS, Weehawken, NJ Oct 2008 – Mar 2009

Senior iSeries Developer Analyst/ Tester/Contractor

Using GMI SunGard Brokerage Database System iSeries Account Inquiry/ Model 204 Decommissioning project Creating a new data base system tables for web facing software integration Technical Support.

Redesigning of Money line Customer Master MTD/YTD/LTD Security on Deposit.

Margin Call Date Credit Monitor A type/Currency A type/Rate Positions Future Master.

Creation of Database file cluster to create a web friendly environment to be viewed on demand

Commodities Report Commissions and Fees.

Newly Created DB2 linkage files include web Front end interface.

Linkage File creation included Account Balance Transaction Fee Code Transaction Position Detail and Position Foreign Exchange Position Summary Detail and Margins files.

Coding RPG ILE DDS to create DB2 files for new Commodities pages for Master, Transactions, Positions, Securities on Deposit, FX, Futures accounts futures contract codes

Futures code changes as per the Commodity Futures Trading Commission (CFTC) maintained for all work done.

Production Support and root cause analysis and extensive regression testing performed on physical files and spool files.

AS/400 files used for integration with MVS systems for web facing software integration.

Technologies: AS/400 iSeries V5R2, OS 390 RPG, DDS, DB2, WEBSPHERE, RDi 80

P. KAUFMAN, New York City, NY Sep 2007 – Jun 2008

Senior Developer Analyst/Tester/Contactor

iSeries Consultant Developing RPG COBOL, ILE DYNAX Software Textile business, point of sale warehouse/retail applications.

Designed, planned and quality control of software enhancement.

Extensive use of sub files physical and logical files, display and print files in a relational database management system.

Used SQL and Query/400 RBM and A/plus to run reports on SQL servers and inquiries on demand in assisting QA testing of RPG ILE programs.

Created and transferred Excel files to and from the iSeries and Mainframe Databases.

Used SQL and Query/400 RBM and A/plus to run reports on SQL servers and inquiries on demand in assisting QA testing of RPG ILE programs.

Checking scheduled EDI Transmissions received for accuracy.

Assigning tasks to Programmers familiar with systems in development.

AS/400 Helpdesk support for IT dept. using Outlook to coordinate with users.

Use of A/Plus Job Scheduler MKS Implementer software for organizing issues and work orders

Technologies: iSeries AS/400, SQL, Query/400 RBM, A/plus, SQL Servers, RPG ILE, MS Outlook,

ADP INC., Dayton, NJ Feb 2007 – Sep 2007

Senior Developer Data Migration Specialist/Contractor

Using Pervasive Software Data Junction, HTML, XML, Dos Batch, Robocopy, Adobe Acrobat 8.0 Professional, Auto Split Professional, Migration of 20,000 plus clients from remote acquired clients to 18 iSeries machines located across the country.

Using Dos scripts in batch unzipped moved split and distributed 20,000

Employee’s to our data base system to FTP and SQL file servers for Client use.

Extracted mapped data from Excel Reports spreadsheets to run mapped Data Junction conversions through Repository Explorer and Dos Batch scripts.

Uploaded run conversions to designated AS/400 based on location 18 in total modifying RPG ILE, CL programs and XML scripts.

Collected data via Query/400 SQL, OS/400 commands against DB2 files for destructive testing of new and updated programs for data integrity.

Modifying RPG ILE, CL modules as per program specifications

Using Query/400 and SQL/400 for research data manipulation and reports

Technologies: iSeries AS/400, Query/400, SQL/400, OS/400, RPG ILE, CL, AS 400, MS Excel, WEBSPHERE HTML, XML, DOS Batch, Robocopy, Adobe Acrobat, Auto Split Professional

LIZ CLAIBORNE INC., North Bergen, NJ Nov 2005 – Feb 2007

Senior Developer/Contractor

Homegrown warehouse/retail system coding in RPG/400 6+ month project making changes to packing slips, lists, labels, manifests formats.

Working with Barcodes formatted Printer files using advanced printer functions Automating, Flowcharting and documenting all procedures.

Modification and enhancements made to existing Homegrown ERP and Change management systems for implementation from scheduled tasks.

Using Zebra Printer command codes to format labels in DDS for RPG programs and associated CLP and DDS display files after extensive destructive testing using copy of live data for program integrity.

Technologies: AS/400 iSeries V5R2, CLP, DDS, RPG/400, OS/400, Zebra



Contact this candidate