Shahab Khan

**** ******* *****, **********, **, L7M 0L2

Home Phone: 905-***-**** Cell Phone: 905-***-**** email: adne0c@r.postjobfree.com 3/1/2021 4:12 PM Page 1 of 5

Over 20 years of experience in designing, developing, maintaining and translating business needs into iSeries application using innovative techniques and proven programming practices on AS/400 platform in roles ranging from Programmer to Project Leader.

Extensive experience in RPG’s Sub files, Service programs, Modules, procedures, Stored Procedure, Pointers, prototype, Binding Directories, Activation Groups and Journaling.

CAREER PROFILE

• Worked on all phases of Software Development Life Cycle Methodology (SDLC), from design through development, testing, implementation and support.

• Strong background in designing and implementing inventories, billing, student enrolment and registration system, warehouse management.

• Demonstrated experience in new development, enhancements of existing applications, production support (supporting existing applications), conversions/migrations, bug fixing, and testing applications.

• Top troubleshooting and problem analysis skills.

• Strong knowledge of IBM iSeries eServer Performance Management System (PM400) and OS/400’s components 1P and CMVC, Clear Case, and IBM Rational Tools (WDSC), JIRA, MKS Change Management, ALDON Change Management, and GitHub.

• Exceptional programming experience on application development tools (IBM’s CSP/AD, SSA’s AS/SET, and Computer Associates’ SYNON).

• Extensive Knowledge of Lotus Notes, Windows XP/7/10, MS Office (Words and Excel)

• Outstanding knowledge of JasperReports’ JasperSoft and iReports, MYSQL, and Dundas BI (Business Intelligence Tool).

• Highly motivated professional and a solid team player.

• Quick learner and very interested to learn new technologies.

• Bachelor’s Degree in Commerce and Accounting, Diploma in Computer Science. Hardware &

Systems:

IBM iSeries eServer, AS/400, Mainframe System/390, and Personal Computers. Languages &

Utilities:

RPG 400/IV/Free/ILE, XMLRPG, SQLRPGLE, AS/SET, SYNON, OS/400 CL/400, C/400, QUERY/400, Crystal Reports, Synon, CICS COBOL, CSP Application developer. Tools (Subfiles, SEU, RLU, PDM, SDA, DFU, FTP, ABSTRACT, Interactive Source Debugger), Embedded SQL in CSP and in RPGILE, CMVC, Clear Case, Aldon, and Rational Development Tool (WDSC). Knowledgeable in XML programming. Application

Software:

BPCS’ Modules, Inventories, Procurement Module, Purchase Price Variance, Shop Order and Bill of Material, Aircraft Maintenance and Management System, IBM’s Performance Management for iSeries eServer (PMiSeries), iSeries Operating System OS/400 Component 1P.

Databases: DB2/400, UDB for iSeries, SQL/400, IFS

Industry

Experience

Software house, Alloy Steel mill, Banks, Government and Education(Kuwait Government), Computer manufacturing industry (IBM), Cable and internet service provider(OCANIC Time Warner Cable), Food and Pharmaceutical, and Construction Industry Applications

(Canada)

Shahab Khan

3324 Hopkins Drive, Burlington, ON, L7M 0L2

Home Phone: 905-***-**** Cell Phone: 905-***-**** email: adne0c@r.postjobfree.com 3/1/2021 4:12 PM Page 2 of 5

EllisDon Corporation, Canada (Nov 2013 – Mar 2020) SYNON/RPGILE Application Developer

EllisDon is a leading construction company that operates in all market sectors in Canada as well as globally. I was hired as an application programmer as a part of their FMS and payroll application development team. The FMS and payroll programs were developed exclusively in Synon (CA 2E).

• Involved in Analysis, Maintenance and Testing of Programs and Applications

• Created/Modified files and relations between file to file and file to fields by using SYNON (CA 2E) for the applications. e.g. (Capture CPT, Record RCD, Reference REF, Structure STR)

• Modified/created new files in DB2/400 (physical, logical in DDS files)

• Created/Modified Access Paths (Physical PHY, logical UPD, Retrieve RTV) by using SYNON (CA 2E)

• Created/Modified Screens and Reports using SYNON (CA 2E).

• Created/Modified Functions, Objects, and actions (logic) by using SYNON (CA 2E) for applications

• Created/Modified Service programs in SYNON (CA 2E).

• Developed new as well as modified existing RPGILE programs exclusively for maintenance of the database

• Developed queries in SQL/400 for rapid report generation

• Heavily involved in debugging & troubleshooting to identify and fix errors in the database

• Responsible for unit testing of programs and applications.

• Documentation of the system and work being done for the project

• Created reports via JasperSoft’s iReports and MySQL for EllisDon’s Gate 3 application

• Used MKS/400 Change Management System for change control for RPGILE development, and used GitHub for iReports development Formica Inc., Cincinnati, Ohio, USA (Mar 2013 – Nov 2013) RPG ILE Developer/Consultant

Formica Inc. is a leading Formica sheet manufacturer, as well as being the creators of this process. I was hired as a Consultant for Formica for a one year contract to convert their BPCS Ver. 6.0 Database to a newer version of BPCS, known as ERP/Lx Database.

• Converted all the master data from the DB2-400 files into Microsoft Excel Worksheets. Used VLOOKUP commands to analyze and prepare reports for final approval from the user. Performed data analysis to remove any inactive accounts in the master file as per transaction files

• Wrote an RPGILE program to upload previous master file data into the newer version ERP/Lx Database

• I finished this one year project of schedule in 8 months’ time. Shahab Khan

3324 Hopkins Drive, Burlington, ON, L7M 0L2

Home Phone: 905-***-**** Cell Phone: 905-***-**** email: adne0c@r.postjobfree.com 3/1/2021 4:12 PM Page 3 of 5

Johnson Insurance, St. John’s, NL (Mar 2012 – Sep 2012) RPG ILE Developer/Consultant

Home/Auto Insurance Claims

Johnson Insurance is a Canadian Insurance Company in Canada located in St. Johns, Newfoundland. I was hired as an RPGILE developer/consultant for their Home/Auto Insurance software.

• Due to regulatory changes by the Government of Canada, there were some changes to be made in the Core Insurance System which is writing in RPGILE on the AS/400.

• Identified and translated these changes in the RPG code, and updated the Insurance Letter Module and claims reforms module.

• Used RPG400 and RPGILE (Free format), SQLRPG (embedded), SQL400, DB2/400, SDA, RLU, AND WDSC languages and tools.

• Also used the ALDON system for change management

• I finished this project on time in 6 months.

Time Warner Cable, Hawaii (Nov 2010 – Feb 2011)

RPG ILE Programmer Analyst/Consultant

(Three months project)

Customer Care Online application

Business Class Phone (BCP) and Residential Phone

Avaya IVR migration project: Web service communication link setup. Worked with TSG to setup the connectivity between HBS and the Avaya IVR Web service server via HTTPS. Setup the connectivity for the Q/A systems and there Test Environment. Setup a production mode Web Service link. I was involved in development and implementation programs using RPGILE (Free format).

• Responsible to deliver the functionality to retrieve account details from billing system, equipment reset, appointment lookup, appointment release, equipment info, pay pal credit card account verification, outage verification, from the data base which was in DB2/DBU by using extensively ILE concepts like Procedures, Sub Procedures, Stored Procedures, Service program, Binding directory, and embedded SQL/400.

• Worked exclusively on binder language commands to developed and service programs.

• Developed CL program for Avaya IVR menu and its display (DSPF) file.

• Conducting unit testing and user acceptance testing and provide follow-up research and program fix from the testing results.

• Increasing program operating efficiency and adapting to new requirements, as necessary.

CATEK Canada, Mississauga (Aug 2010 – Oct 2010)

Wireless Network Tester/Consultant

(Three months project)

I was responsible to test more than 100 cell phone towers and their signals in the GTA for Bell and TELUS. Tested all the three (Alpha, Beta and Gama) and in some cases delta sectors HSDPA, (short for High-Speed Downlink Packet Access), is a new protocol for mobile telephone data transmission. It is known as a 3.5G (G stands for generation) technology. 911 calling was also part of this testing. Shahab Khan

3324 Hopkins Drive, Burlington, ON, L7M 0L2

Home Phone: 905-***-**** Cell Phone: 905-***-**** email: adne0c@r.postjobfree.com 3/1/2021 4:12 PM Page 4 of 5

Tested Wi-Fi Internet Network and downloaded and uploaded speed of Bell and Telus. I maintained a logbook for reading and at the end of the day I sent it to our office in Mississauga before 4PM. On the basis of that log the office staff fixed the problems and schedules for the next day testing. I travelled frequently all over the GTA from Hamilton to Markham. Nestle Purina, Mississauga (Apr 2008 – Jan 2010)

RPG ILE Programmer Analyst

• Developed and Modified their BPCS Inventory, Shop order, and Bill of Material Data base and Programs. Most of the programs were in AS/SET which is a BPCS CASE tool while some were in RPG/ILE, SQLRPG and free format. I was working on both the languages at the same time as well as CL/400, SQL, Query/400.

• Developed a process to split four Address fields into ten address field (Street 1, Street2, Building no, floor no., House, City, Postal code, ZIP code, Country, PO Box no., Telephone).

• I developed Sub files data entry programs for the Accounts Payable system to enter customer name address.

• Developed a process to upload Innisfil factory sale forecast data which came in Excel spread sheet on iSeries and to print a forecast report. (Process was in DOS BAT file which was using iSeries Transfer data to Host function.)

• Modified some of the programs which was in AS/400 COBOL for their procurement system.

• Documentation in Excel and Word.

NEBS PayWeb, Cambridge, ON (Jul 2006 – Oct 2007)

RPG ILE Programmer Analyst

• Develop moderately complex and highly critical programs in ILE RPG in Free format for Accrual system. Sub file report selection programs using APIs QRCVDTAQ and QSNDDTAQ. Report programs using complex Array Variables logic. Sub Procedures for reading and writing database files. Batch programs for validation of receiving data from XML files.

• Provide maintenance support for existing payroll applications in RPG/400 Cycle and CL/400 Programming also worked on SYNON programs to change into RPG ILE free format.

• Produce external/internal design using Chapin Charts and Structure Charts in Visio.

• Unit testing, Debug and troubleshooting in complex Applications (Wrote test scripts and create test date for testing. Document results after testing).

• Document during and after development cycle

• Arrange presentation and walkthrough meeting for design before program development and code review meeting after development

• Develop Queries in SQL, Query/400 and DBU. Develop Queries in SQL/400 using iSeries Navigator.

• Write RPG ILE programs to feed data to the files which were then used in the XML programs for reports printing.

Shahab Khan

3324 Hopkins Drive, Burlington, ON, L7M 0L2

Home Phone: 905-***-**** Cell Phone: 905-***-**** email: adne0c@r.postjobfree.com 3/1/2021 4:12 PM Page 5 of 5

IBM, Rochester, MN (Aug 2004 – Jun 2006)

RPG Programmer Analyst

• Involved in Maintain IBM's Performance Management for iSeries eServer (PM 400) 1P component.

• Involved in designing, development and maintenance of the PM iSeries OSXPF code

(iSeries Operating System) as well as parts of the report generation/creation code.

• Responsible for providing secondary level support for the PM iSeries Support line staff.

• Involved in ensuring the integrity of customer data and the accuracy of the reports generated and maintaining department's web pages in HTML.

• Developed IBM's Maintenance tools (CMVC, Clear Case and Lotus Notes) using RPGILE and CL.

EDUCATION

• Bachelor of Commerce

• Diploma in Computer Science

PROFESSIONAL & TECHNICAL COURSES

• IBM Karachi: AS/400 Facilities, Concepts and Programming

• IBM Karachi: AS/400 CL, SDA, RLU, DFU

• NOBLE Karachi: AS/400 Securities and administration workshop SQL/400.

• NOBLE Karachi: QUERY/400, RPG/400, DB2/400 and AS/SET.

• Seneca College Toronto: RPG/400

• Seneca College Toronto: Advance RPG ILE/Free/Sub files

• Sheridan College Toronto: Payroll Administrator Course

• PIA Karachi: CICS/COBOL, SQL/DS, CSP/AD

• IBM Rochester: CMVC, Clear case and Rational Development Tools

Contact this candidate