SUMMARY

• Senior Information Technology professional wif 20+ years of expertise in RPG - III, RPG-IV aka ILE-RPG Free-Format, SQLRPGLE and CLLE on teh AS400 in Information gathering, Analysis, Design and Documentation for Business applications and Maintenance to accomplish Strategic Corporate Objectives and Implemented Software Architecture, Development, Testing, and Project Management

TECHNICAL SKILLS

Hardware: IBM me 7.4, System 38, GEAC 8000

Operating systems: OS/400, Microsoft Server and Windows Desktop Computers

Languages: RPG-III, RPG-IV aka ILE-RPG, SQLRPGLE, CLP and ILE-CL, Microsoft SQL, ZOPL GEAC 8000

Database: IBM DB2, SQL Server, Microsoft Access

Knowledge of: Cobol, Java, JavaScript, C++, HTML, Python, XML

Software: JD Edwards World (A7.3.11), Infor ERPLx (8.3.1), BPCS(4.05CD), Bridgelogix Bridge to Barcode (Custom WMS), Infor WM, Harbinger’s TrustedLink EDI/400, T.L. Ashford, Barcode400, Loftware Barcode, Seagull Scientific BarTender, TAI Commerce (St. Paul) EDI Software, Help Systems Job Scheduler, Create Print Forms Design Application, Kronos Timekeeper, Ceridian HR/Payroll Web, Mattec Shop Floor data collection, Intermec, Symbol, and Microsoft Office Applications

PROFESSIONAL SUMMARY

Confidential

AS/400 Consultant

Responsibilities:

• Modification to ERP/Lx running on an IBM i5 AS400 system using modern RPG programming language
• Modification and design of Barcode labels using Bartender Software
• Program change as requested and created databases using DB2
• Worked wif IT Team to upgrade from BPCS(4.05CD) to Infor ERP/Lx and modified base applications to meet specific business needs

Confidential

AS/400 RPG Consultant

Responsibilities:

• Worked wif project manager, IT team, planned, designed and executed tasks to extract and format data files from teh AS400 for import into Microsoft Dynamics CRM tables in a Microsoft SQL Server Database. dis goal was to eliminat teh need for a dedicated staff having to manually re-enter data into CRM. It also saved time, and eliminated teh possibility for errors

Confidential

Consultant Petersburg

Responsibilities:

• All work was executed remotely from home in Scarborough
• Modification to JD Edwards v7 cum 11 running on an IBM i5 AS400 system using modern RPG programming language
• Created database using DB2
• Projects ranged from design, creation and documentation of new programs and maintenance to applications: Accounting, GL,Payoll, Manufacturing and Purchasing

Confidential

Business Systems Analyst Toronto

Responsibilities:

• Worked closely wif Managers and Senior personnel to analyze and define user requirements
• Documented, Created and Maintained Applications based on analysis and user requirements
• Created Barcode box labels using Loftware and TL Ashford applications for internal use and customer specific requirement
• Lead teh implementation of Harbinger TrustedLink EDI/400 and trading partner functionality into BPCS(4.05CD)
• Managed Warehouse systems(Barcode Scanners, Box Label Printers, Cicso Access Points) and wireless infrastructure
• Maintained AS400 system updates and upgrades to ensure continuous (24/7) access to system resources and minimize downtime across two facilities and four production plants
• Supported users wif system, application, and reporting requests to ensure continuous availability of resources to meet their needs in 3 shifts and 24/7 operation serving Canada and US plants

Confidential

AS/400 Programmer Analyst

Responsibilities:

• Analized, designed, documemnt and developed Modules using RPG-III, RPG-IV, ILE-RPG, SQLRPGLE, CLLE and DDS following JD Edwards development standards for company’s specific business logic
• Designed, developed and implemented applications to import PLC data into custom databases which were used to automatically update JD Edwards database files. dis eliminated teh need for manualy data entry, possibility for errors and saved time
• Used Create Print software and designed Invoices, Purchase orders, Payroll Checks and Bill of Lading forms, using JD Edwards database. dis saved teh company from purchaing preprinted forms, had better and quicker access to control changes
• Designed and implemented programs that extracted JD Edwards Payroll data and electronically transmitted to Financial institution for automatic credit to employee’s accounts. Programs were created using SQLRPGLE and teh Integrated File System(IFS)
• Upgraded JD Edwards from version 5 to 7.3 cume 11 and DB2.
• Responsible for teh integrity of JD Edwards Database and Technical Foundation (Data Dictionary, UDC, VO, DW, WW, Security, Menus)
• Performed physical database design, prototyping, documentation, development, implementation and testing of application modules to meet business needs
• Installed and supported several Third Party applications that were critical to busines operations
• Worked closely wif managers and IT development team to analyze, document and define user requirements

Confidential

AS/400 Programmer Analyst

Responsibilities:

• Managed software programming changes and daily operations on an IBM AS/400 system
• Provided application documentation, training and support for users in Richmond, Virginia and four remote locations
• Planned and coordinated teh migration process from a System/38 to an AS/400 along wif user training. Responsible for system administration; user’s security access, performance tuning, and developing programming standards
• Managed User’s daily ERP (BPCS) connectivity issues. Logged and assigned requests to appropriate functional areas
• Performed physical database design, prototyping, development and implementation and testing of application modules to meet company’s business needs
• Setup Harbinger TrustedLink EDI/400
• Installed and maintained software modifications to Help Systems (Robot) Job Scheduler Created CL programs to submit jobs via Robot to perform daily, nightly, weekly and monthly processing
• Worked closely wif Third Party application vendors to identify and resolve issues quickly
• Planned, managed and executed AS400 upgrades and PTF updates