** 5 Separate Contract during that time frame**ABB – Accounts Based Billing – mainframe version. DB design, screen design, programming – online. Complex processing.Shipping System - Wrote interface to send supply, emergency, and replenishment orders down to shipping system on AS/400. Coordinated technical requirements of project with user department and AS/400 system vendor.24Hr FWSS - modifications to make application run 22 HR under IMS.X-DAP Project -… Show more ** 5 Separate Contract during that time frame**ABB – Accounts Based Billing – mainframe version. DB design, screen design, programming – online. Complex processing.Shipping System - Wrote interface to send supply, emergency, and replenishment orders down to shipping system on AS/400. Coordinated technical requirements of project with user department and AS/400 system vendor.24Hr FWSS - modifications to make application run 22 HR under IMS.X-DAP Project - database redesign, reorgs, implementation, data dictionary, database conversion programs New Substances System - Designed, wrote and installed a system for managing data on new chemical and polymer substances being imported or manufactured in Canada as required by Environment Canada regulations. System consisted of on-line and batch programs.IMS DBA support. On-call support, provided IMS expertise to programmers, designed and set-up secondary indexes, designed databases, defined transactions, monitored space. Show less

Installed and supported local IDDE system (IMS DB/DC system)- setup databases, set-up and supported backup/recovery/reorg/smu jobs, tuned databases,set up transactions, jcl, OPCA schedules, local data tables, psb gens, dbd gens, set up IMS transaction and database gens, tested system. Worked with technical and business representatives of downstream and upstream systems in Canada and around the world to optimize data transmission and improve data quality in IDDE. Analyzed and documented… Show more Installed and supported local IDDE system (IMS DB/DC system)- setup databases, set-up and supported backup/recovery/reorg/smu jobs, tuned databases,set up transactions, jcl, OPCA schedules, local data tables, psb gens, dbd gens, set up IMS transaction and database gens, tested system. Worked with technical and business representatives of downstream and upstream systems in Canada and around the world to optimize data transmission and improve data quality in IDDE. Analyzed and documented business process for 'solution-in-a-box' invoices, exports from Toronto plant, and publications data. Security officer for IDDE. Worked extensively with U.S. clients and provided technical system information that played a key role in winning the bid to support the U.S. functionality through the Canadian system. IDDE - International Distribution Data Exchange. Programming, analysis, and support on CIS (import system -IMS DB/DC) and AIM (DB2/2) system. Rewrote sections of CIS (import system) to access DB2 version of CRDB.) Show less

Taught three courses: 2 sections of Systems Design and 1 section of Systems Implementation.

Pension Benefits System (participant level fund management).Project leader on 2-member team creating tape interface reporting system for insurance company client.Enhancements, trouble-shooting and documentation for functions including withdrawal, market value adjustment, and accumulated value (daily interest funds).Telephone support for several clients. On-line system. Environment: HP3000, IMAGE, COBOL

Expense Supply, Traffic Invoice Audit, Payment and Cost Distribution Systems. Combination of HP and IBM systems. System testing and debugging, re-wrote audit and input programs. Used MRJE to create an interface between an IBM MVS system and a system on the HP3000Environment: HP3000, IMAGE, COBOL, IBM mainframe, VSAM.

Pension Benefits System (participant level fund management).Project leader on 2-member team creating tape interface reporting system for insurance company client.Enhancements, trouble-shooting and documentation for functions including withdrawal, market value adjustment, and accumulated value (daily interest funds).Telephone support for several clients. On-line system. Environment: HP3000, IMAGE, COBOL.

NOSTRO and Foreign Exchange systems. Global Funds Transfer System. Logical database design - gathered and defined database elements and organized into third-normal-form. Identified and designed transactions. Participated in JAD sessions and design walkthroughs. Converted over 100 programs of on-line data entry system from DMS to CICS/COBOL. Prepared thorough test plan and performed system test. Implemented on schedule. Environment: IBM mainframe, COBOL, CICS, IMS DB.

Analyzed and implemented enhancements to manufacturing and leasing applications, supported production systems. Worked with internal and external customers. Prepared feasibility study for project to exchange data with customers using EDI.Environment: IBM 4341, PLI, IMS DB.

Part of team using Gane & Sarson Structured Analysis and Design techniques to design a massive on-line, real-time system to facilitate all aspects of Locomotive Repair Shop Operations. System functions included: inspection scheduling, allocation of human and material resources, creation of work tickets and b-of-m parts lists, planning and forecasting of workload. Reviewed logical database designs to verify efficient on-line transaction access and correct normalization of data. Part of a… Show more Part of team using Gane & Sarson Structured Analysis and Design techniques to design a massive on-line, real-time system to facilitate all aspects of Locomotive Repair Shop Operations. System functions included: inspection scheduling, allocation of human and material resources, creation of work tickets and b-of-m parts lists, planning and forecasting of workload. Reviewed logical database designs to verify efficient on-line transaction access and correct normalization of data. Part of a team developing and implementing traffic and oil analysis systems. Worked with users to develop specs for new programs and enhance existing programs, created documentation, performed system testing, assisted in implementations across Canada and supported production systems. Show less