Rpg Cobol

OBJECTIVE

Seeking position in a progressive organization

as Application Developer on IBM i on Power Systems (AS/400, iSeries, System i)

CAREER HIGHLIGHTS

-Over 20 years of North American experience in Application development on IBM midrange including AS400, iSeries, IBM i

-Expert level skills in RPG, SQL, CL, and COBOL. Variety of Domain knowledge from Insurance, Retail, health care, telephony, logistics, and manufacturing.

-US / Canadian dual citizen. Available to relocate anywhere in these countries on a short notice.

PROFILE

Application Development: Expert level professional skills and experience in developing applications on IBM i on Power Systems (AS/400, iSeries, System i) using RPG, RPG IV (with /free), SQL (with Stored Procedures), CL, DB2 and Cobol etc in ILE (Modules, Service Programs, Binder Language). Some QShell scripts and RPG for IFS files

Database Maintenance: Expert level skills with DB2 for i SQL Stored Procedures. Useful skills in Oracle SQL+ and PL/SQL Stored Procedures and MS-SQL Server T-SQL

PROFESSIONAL SKILLS

IDEs: RDi, WDSC, PDM (Green Screen)

Reverse Engineering Tools: ISDB, Pathfinder’s Hawkeye, ASC Sequel, X-Analysis

Change Mngt Systems: Softlanding’s Turnover, Aldon, MKS Implementor

Operating Systems: Expert level at OS400, i5, IBM i. Also DOS

Databases: Expert level at DB2 for i. Useful with T-SQL and PL/SQL

Platforms: IBM i on Power Systems, System i, iSeries, AS/400

EDI: FTP. Also used SFTP, ESB e.g. MQ Series, Tibco.

EDUCATION and TRAINING

Web Development: Diploma in Web Development from Toronto School of Business

Application Dev: Certificate in Computer Based Accounting Information Systems

Mid Range: Certificates of attendance from I.B.M on S/34 in 1981 and AS/400

College: Diploma in Computer Sciences Cobol, Fortran, Systems Analysis

University: Bachelor of Commerce with majors in Accounts

AFFILIATIONS and RECOGNITIONS

Professional Recognition: International network of AS/400 professionals “AS400 Network” nominated as Pro on Cobol and RPG forums

IBM Recognition: IBM Toronto Software Lab has included in their User Center Design to provide feedback on their products at their development stages.

Member: IBM User Group – Nashville (IMUG)

EXPERIENCE

Developer at The General Insurance Co., (formerly Permanent General Insurance Co) Nashville, Tennessee: 07/2017 – current: (The General Insurance Co deals with specialty insurance)

-Develop new systems using **free RPG, ILE, SQL

-Maintained legacy written in all flavors of RPG.

-Used RDi, System i Navigator, iSphere as development tools.

-Used Turnover as Lifecycle Management system

Developer IV at Alfa Insurance, Brentwood, Tennessee: 03/2017 – 06/2017: (Alfa Insurance deals with specialty insurance)

-Project to investigate the root cause of the broken legacy system Specialty Insurance System (SIS) originally written in RPGIII on S38 in 80s. Suggested fixes in database design, data health, system design, and program coding. Plug pulled on the project.

Sr Designer at Mattel (Via TCS), El Segundo, California: 01/2016 – 11/2016: (Mattel is the largest manufacturer of toys that include Barbie Dolls, Fischer Price, Monster High, WWE, DC Comics, American Girl etc)

-Consolidated different database across multiple IBM i boxes around the world for different subsidiaries, and send them to Oracle based Operational Data Store over TIBCO Enterprise Service Bus, for use by BI and Enterprise Data Warehouse.

-Wrote SQL triggers on files to capture delta data. Wrote programs in RPG using TIBCO API’s to transfer the delta data to Oracle

-Did Impact Analysis, Risk Analysis, and other project management work

-Used MKS-Implementer as Change Management System

-Used System i Navigator for reverse engineering and performance tuning of DB2 tables. Also used it to write and test stored procedures.

Sr IBM i Developer at Staples (via TCS), Framingham, Massachusetts: 02/2015 – 01/2016: (Staples is the largest supplier of office products, and is taking over Office Depot (2nd largest), after having taken over Office Max (3rd largest)

-Help in transitioning support services from former vendor Cognizant Technology Services to Tata Tata Consulting Services, by chalking down existing processes

-Perform support services of data in DB2, and programs in RPG

-Provide testing support of programs written by previous vendor, and debug/fix programs before it goes to production.

-Used MKS Implementer as change management system

-Used DB-visualizer (System i Navigator comparable), for db2 table analysis and performance tuning. Also used it to write and test stored procedures.

Software Engineer at MedHost, Franklin, Tennessee: 07/2012 – 01/2015: (Formerly Healthcare Management Systems, is a fast growing healthcare software company that develops software for community hospitals). Part of the RPG based eArchive group to develop new and maintain existing applications written on AS/400 in RPG IV with embedded SQL, ILE, /free. Some legacy RPGIII as well. Also part of the Java based Document Management Group in helping transition from eArchive to DMS.

-Wrote programs in RPG to help produce legacy reports in PDF for DMS using IFS files

-Wrote Qshell scripts and RPG programs to maintain IFS files.

-Wrote data manipulation programs in DB2 SQL Stored Procedures

-Wrote some real light Java utility programs

-Used Linoma to convert RPGII and RPGIII legacy programs to RPG ILE as part of Major Growth Initiate and modernization

-Used Aldon as change management system

-Used RDi as IDE with Data Studio

-Used System i Navigator for db2 table analysis and performance tuning. Also used it to write and test stored procedures.

-Used X-Analysis for reverse engineering of programs

Analayst/Programmer at Medronics, Mansfield, Massachusetts: 08/2011 – 07/2012: (formerly Covidien / Tyco Health Care, is a fast growing health care provider that has taken over a number of health care companies). Part of the Information Services group to develop new and maintain existing applications written on AS/400 in RPG IV with embedded SQL, ILE, /free. Some legacy RPGIII as well. Also gathering requirements for integration of systems of taken-over companies.

-Analyzed interfaces linking Sales Analysis system to JDE and made modifications needed due to expansion in Sales Analysis tables.

-Made changes to programs and tables and unit tested.

-Used MKS-Implementer as Change Management System

-Used stored Procedures to create and modify tables structures, as well as load and modify tables data.

-Used RDi as IDE with Data Studio

-Used System i Navigator for db2 table analysis. Also used it to write and test stored procedures.

Systems Analyst at AT&T, Alpharetta, Georgia: 04/2005 – 08/2011: (AT&T Mobility is the leading provider of wireless services with an Unix/Oracle/Java based system Telegence as the primary billing software) Part of the Production Tables Support team.

09/2008 – 08/2011 – Lead Database Analyst

-Maintained AS/400 RPG based billing application CARE until sunset towards the Unix/Oracle/Java based application Telegence. Used RPGIV (/free format), ILE (Modules, Service Programs, Binder Language), SQL(with Stored Procedures), DB2 UDB and Cobol. Also used Softlanding’s CMS Turnover, Client Access Rumba, Mail Server Microsoft Outlook.

-Modified tools written in T-Sequel on SQL Server-2005 to link AS/400 with other platforms, to now link Oracle based Telegence with other platforms.

-Additionally wrote scripts and stored procedures in Oracle to produced reports. Used SQL+ and Aqua Data Studio.

-Wrote VBA scripts behind MS-Excel to produce templates for Data Analysis.

04/2005 – 02/2008 - RPG Programmer

-Designed and developed tools to automate table maintenance processes. Used RPGIV (/free format), ILE (Modules, Service Programs, Binder Language), SQL(with Stored Procedures), DB2 UDB and COBOL. Also used Softlanding’s CMS Turnover, Client Access Rumba, Mail Server Microsoft Outlook and some Websphere as Client Access and Java/400 subroutines.

-Wrote tools in T-Sequel on SQL Server-2005 to link AS/400 with other platforms and applications such as the Unix/Oracle based applications SAVVION and OASYS, and Unix/Sybase based application for Toll/Roamer.

-Used WDSC and then RDi as IDE

-Used Aqua Data Studio for db2 table analysis. Also used it to write and test stored procedures.

Systems Analyst at Nike, Beaverton, Oregon: 02/2008 – 09/2008: (Nike Retail is the retail division of leading designer/manufacturer of sportswear and sports equipment) Part of the team to integrate AS/400 based price optimization software Island Pacific with Oracle based ERP SAS thru a middleware developed in Informatica. Involved in gap analysis and system design as well as the AS400 side of programming in RPGIV (/free format), ILE (Modules, Service Programs, Binder Language), SQL(with Stored Procedures), DB2. Also used some Websphere as Client Access and Java/400 subroutines.

Systems Analyst at Dey Labs, Napa, California 11/2004 - 04/2005. (Day Labs is a member of Merck family and manufacturer of respiratory medicine e.g. Accuneb, Duoneb, Epipen). Developed AS/400 based Business Intelligence Data Warehouse applications for interface with BI application using Cognos platform. Used language RPGIV (/free format), ILE (Modules, Service Programs, Binder Language), DB2 UDB and SQL(ASC’s Sequel). Also used CMS Aldon, Mail Server Lotus, Client Access CA/400, tracking software Abstract Plus, iSeries Navigator etc.

Systems Analyst self employed 11/01 – 01/03

-Solcorp, Mississauga 02/03 - 09/04

(Solcorp is a Canada based international developer of Insurance software with branches in UK and Japan). Ported IBM/390 Cobol applications to AS/400 Cobol and RPG. Also converted Cobol/ILE applications to RPG/ILE as well.

-P.L. Snacks, Mississauga 11/01 - 01/03

Setup I.T. department. Buy all necessary hardware and software and setup. Setup JDE on AS/400 and MS-Office on PCs.

-IBM Software Development Lab

Evaluated their proto types including WDSC, RDi etc

Systems Analyst at Lincare Inc. Clearwater, Florida between 10/99 - 10/01

Designed, developed the Customer Survey System for accreditation (first JCAHO then CHAPS) and maintained the Account Receivable System. Converted AS/400 legacy programs from RPG-III/400 to RPG-IV/ILE for performance. Programmed in RPG-IV/ILE and SQL under QMQRY for maintenance and new development on AS/400. Used CAS-Templates as development tool, CA/400 as client server, ISDB and ILE-DEBUG as source debugger, Turnover and Hawkeye as Change Control, and MS-Outlook as e-mail.

Systems Analyst Saville Systems Edmonton between 03/97 - 06/99.

(Saville Systems is a Canada based largest developer of billing software for telecommunications companies with branches in Toronto-Canada, Boston-USA, Gallaway-Ireland, and Singapore)

-Worked in core team as Analyst/ Programmer developing their billing software CBP 3.2 on AS/400 using RPG and COBOL.

-Used RUMBA & Reflection for client server, ISDB for debugging, and Turnover for change control

Systems Analyst James River Canada, Toronto on contract between 05/95 - 03/97

(JRC (formerly Canada Cup and now Forte-James) was a Richmond-USA based Fortune 500 Co. and manufacturer of disposable crockery like Dixie)

-Maintained and developed systems on S/38 using RPG and COBOL.

-Provided backup to S/38 operator, PC Tech Support on Novell and Windows platform), and the PC programmer using MS-Access and Visual Basic.

-Helped convert data from S/38 to WAN SAP.

Contact this candidate