Simon "Sam" Revill

Senior Programmer Analyst / System & Database Admin / Consultant

Phone (647) 886-2214 • E-mail SRevill@Samwize.ca Full Resume at Samwize.ca/Resume

Over 38 Years Of Professional Consulting Experience

Work History Latest Position Held

10+ Years - Current Position Held Since June 2010
Samwize Enterprises Inc. Primarily For Exiom Tech, TopLinQs And Shoppers Drug Mart

 Roseneath, Ontario / Toronto, Ontario

Senior Programmer Analyst

Consulting Services

PC – AS400 – Windows IIS 2008 R2 – Linux Servers

For Shoppers Drug Mart: JDA E3 custom programming changes on the AS400, refreshing the test environment from live, testing, test result analysis, custom before & after reporting with difference analysis for overnight mass updates and new warehouse creation, data extraction, reporting, after hours support for go live of changes and AS400 technical support.

For Exiom Tech; DBA for MySQL, SQL Server 2008, Oracle, Teradata / Programming and support for Perl, DataStage, Toad, Global ECS, Spiceworks. E-Commerce projects on the web using a variety of solutions. Server administration, maintenance and support for both MS Windows IIS 2008 R2 and various versions of Linux.

Setup and support products on Amazon and Best Buy Canada.

Install / Setup / Maintain various Web Site Software Platforms and E-Commerce Platforms.

Investigate / Test and Find Software Solutions for a given set of project requirements and specifications.

Some of my past long term customers:

Ontario Teachers Pension Plan Board, Lexmark Canada, Hunt-Wesson Canada, Maple Leaf Gardens, Sheridan Nurseries, Ontario Hydro, Scor Reinsurance, Lever Industrial, Rorer Pharmaceutical, Kingsmill Ross & McBride, Ganz Bros, McCallum Transport, Builders Supplies Ltd, Granite Club, HMV Canada, Metro Beauty, Minolta, Narco Scientific, PFAFF Canada, Penetang Midland Coach Lines, VH Foods, WindFields Farm, Cabal Mngmnt and many others.

Work History Previous Positions Held

4 years From February 2005 to April 2009
Genisys Management Services

Mississauga, Ontario

Senior Programmer Analyst

Insurance Management Processing Services

PC – AS400

Insurance processing for a variety of customers using a package known as USSI, primarily for Life and Disability.

AS/400 iSeries : RPGLE, RPG, COBOL, CL, Query, SQL, C sub-routines, XML, data conversions, automated Email & file transfers, FTP, TCP/IP, Native AS400 Data Encryption/Decryption, PC Support. TurnOver change management software in force. Presentations in Powerpoint, Visio, MS-Excel and MS-Word.

Project specification development in conjunction with the customer or internal end user, and Genisys BA’s. In some cases a BA was not assigned therefore I would fill in for that absence.

Provide written detailed program modifications and database changes required to achieve the project objectives.

Where applicable offer alternative solutions and/or enhancements for future flexibility.

Complete programming changes, submit changes to preliminary testing and then assist the BA and/or Customer to complete acceptance testing. Co-ordinate and/or supervise additional programming staff assigned to a project.

Prepare end user documentation for projects.

Prepare documentation for project promotion, taking in to consideration any data conversions and job schedules.

Work with system admin staff to ensure promotions are completed in full and changes are functional.

Time sheet entry for billing, project tracking and comparison of estimates to actual time recorded.

24 hour on call production support. This is on a rotational basis.

Impact assessment for production issues and solution analysis.

Conflict resolution for programs being modified by two or more projects for the same customer environment.

Genisys Projects for which I was the primary person:

  1. Address validation, reporting and updating using files downloaded from Canada Post.
  2. Census management of group policies; reports, output & uploading of returned files to update the database.
  3. Data warehousing for policy analysis, statistics & projections.
  4. Bank Account and Credit Card Masking in conjunction with Data Encryption / Decryption for stored data.
  5. Staff discounting for policies, with a wide range of flexible user setup options.
  6. Removal of hard coding from CL programs for printers, folders names, document names and IP addresses.
  7. Formulae based reporting output directly to the IFS for MS-Excel.
  8. Automated FTPs with centralized User ID and Password files for maximum security, user modifiable settings for log histories, number of retries, who to notify via message or email and location of both command and log files.
  9. Automated E-mails, e-mailed reports and automated file transfers.

Genisys Mangement Services closed its Mississauga Ontario offices effective March 31st 2009.

16 years From June 1988 till May 2004

(when the Toronto Office was closed-shortly after DPS Canada closed)
Systemetrix Corporation/ NxTrend Technology Inc./ DPS Canada Ltd.
Toronto, Ontario

Programmer Analyst

for an IBM Business Partner / IT Consulting Firm

PC – S34/S36/S38 – RS6000 – AS400

Distribution systems (OE, AR, AP, GL, IC, IM, FA). DPS, TREND, JDE, JDA

Freight Management interfaces; UFMS and Scancode.

Manufacturing systems; Data 3.

Custom EDI processing and interfacing with EDI software.

Real time credit card validation, address verification, approval number tracking, re-approve expired and bill.

Payroll; Canadian standard salary and hourly payrolls, union payroll, fish payroll (Newfoundland/Labrador).

Pension fund processing and repayment of pension loan calculations.

Legal office support systems.

Custom work for a Reinsurance company; policy tracking and reporting.

Time accounting for our internal systems.

Customer support call tracking system, with reporting, faxing satisfaction surveys, analysis and result tracking.

Front line technical support for PC, S/3x, AS400 and RS6000.

AIX upgrades over the phone for customers all over North America.

S/3x and AS400 PTF application and installation of system software.

AS/400: RPG, RPGLE, CL, Query, SQL, C, PC Support, data conversions, and automated e-mail/fax/file transfers/FTP, TCP/IP, Data Encryption/Decryption.

RS/6000: AIX, Progress (programming language), change management software, AIX OS upgrades

S/34 S/36 S/38: RPG, OCL/CL, Query, COBOL (S/36 only). WSU to RPG conversions.

PC: Dos 3.3-6, Windows 3.0-XP, IBM Basic, Borland Turbo Basic, and setup/maintenance/problem resolution.

MS Office, Lotus Smart Suite, Displaywrite, Wordperfect, Wordstar, Norton Utilities, Custom Data Conversions.

Working within a team or independently provide a one stop solution for our customers IT needs.

Traveling to the customer, working from the office and working from a home office after the Toronto office was closed.

Third party software assessment and integration with where required.

Project specification development in conjunction with the customer or internal end user. In some few cases a BA was assigned.

Provide written estimates, present project specifications, estimates and options to the customer for approval.

Provide written detailed program modifications and database changes required to achieve the project objectives.

Where applicable offer alternative solutions and/or enhancements for future flexibility.

Complete programming changes, submit changes to preliminary testing and then assist the customer to complete acceptance testing. Co-ordinate and/or supervise additional programming staff assigned to a project.

Prepare end user documentation for projects.

Prepare documentation for project promotion, taking in to consideration any data conversions and job schedules.

Work with the customers system administration staff to ensure that promotions are completed in full and that all aspects of the changes are functional in the production environment.

Time sheet entry for billing, project tracking and comparison of estimates to actual time recorded.

PC installation and setup for both hardware and software. Responsible for all PCs in our own office.

24 hour on call production support. This was provided for specific customers.

Impact assessment for production issues and solution analysis.

DPS Canada Ltd. Was formerly known as NxTrend Canada and prior to that as Systemetrix Corporation.

4.5 years from March 1984 till June 1988 with
Columbus Computer Business Systems
Toronto, Ontario

Programmer Analyst

for an IBM Business Partner / IT Consulting Firm

PC – S34/S36/S38

Distribution systems (OE, AR, AP, GL, IC, IM, FA). GAS.

Manufacturing systems; Data 3 and Mapics.

Payroll; Canadian standard salary and hourly payrolls.

Time accounting and internal systems.

Custom PC programming written in IBM Compiled Basic and Borland Turbo Compiled Basic.

Front line technical support for PC and S/3x.

S/3x and AS400 PTF application and installation of system software.

S/34 S/36 S/38: RPG, OCL/CL, Query, WSU

PC: Dos 1.1-6, Windows 3.0-XP, IBM Basic, Borland Turbo Basic, and setup/maintenance/problem resolution.

6 months from October 1983 till March1984 with
Quasimodo Ltd.
Toronto, Ontario

Programmer

for an IT Consulting Firm

IBM System 23 – PC

S/23: Basic IBM PC: DOS, Windows, IBM Basic.

Distribution systems (OE, AR, AP, GL, IC, IM, FA), time accounting, payroll, customer support, PC setup, installation and maintenance. Converting S/23 code for the IBM PC.

Over 35 Years Of Professional Consulting Experience

Technical Skills Summary

Hardware: AS400 – S/38 – S/36 – S/34 – S/23 - RS6000 – UNIX – VAX – PDP – PC – MAC

OS: OS400, IBM proprietary ( S23 thru S38) – Windows – Unix – AIX – DOS – VAX (DCL)

Windows OS: 3.0 – 3.11 – W95 – W98 – WIN ME– W2000 – WIN XP – VISTA– Win 7– Win 8 – Win 10 - MAC OS X

Programming Languages: RPG – RPG ILE / RPGLE – BASIC – COBOL – C – PROGRESS – VISUAL BASIC – CL – OCL – DCL – DOS Batch – UNIX Scripts, SQL – HTML­ – PHP, Java

AS400 Tools: PDM – SEU – SDA – RPU – DFU – DDS – QDLS – IFS – FAX – E-Mail – FTP – TCP/IP – TELNET – Pass Thru – User ID Setup – Security – Dedicated Service Tools – Disk Replacement/Manage/Balancing – Encryption/Decryption – Software Install – PTFs – System Upgrades.

Utilities: SQL – Query 400 – FTP – TCP/IP – Encryption/Decryption – EDI – XML – E-Mail – Client Access – ODBC – MS-Office – Lotus Notes – Cognos – SQL Server – Oracle – Teradata

Distribution Systems (OE/IC/IM/AR/AP/GL/FA) : GAS – Systemetrix – DPS 9000 – Unified – JDE (custom bi-directional interfaces) – JDA - Various PC Based

Canadian Payroll Systems: Hourly & Salary - Union – Fish Payroll (Nfld)

Manufacturing Systems: Data3 – Mapics

Insurance: Property & Casualty (Reinsurance) – Life & Disability with some reinsurance

Freight Management Packages: UFMS – Scancode

Other Systems: Time Tracking and Accounting – Legal Tracking & Billing – Customer Support – Pension and Pension Loan Repayment – Custom Code – Data Conversions – EDI

Version Control: Turnover

Networking Setup: AS400 – PC – Windows – UNIX

Hardware Support: AS400 – PC – PC Servers (Windows / Unix)

E-Commerce and other Web Site software solutions:

PrestaShop, OpenCart, CS-Cart, CS-Cart Multi-Vendor, Clip Bucket (Video), Big Commerce, Duda Mobile, LinQDeals, Piwik Analytics, VIMP, Yelo, WordPress and many others.

Education

1979 TorquayGrammar School Devon, England

Oxford GCE “O” levels.

Later recognized as at least equivalent to Ontario Grade 12 as a prerequisite required by SenecaCollege.

1982 - 1983 Seneca College Toronto, Ontario

Computer Programming

Data processing Concepts, BASIC Language and structured COBOL, Systems analysis and a systems development project, Microcomputer programming, Bookkeeping and Keyboarding Skills

1984 SenecaCollege Toronto, Ontario

Professionals Programming RPG II (436)

Evening classes to learn programming in RPG II

1991 IBM Canada Toronto, Ontario

AIX V3 for Users

This was a basic introduction course to AIX.

I also attended internal classes for more advanced AIX held by Don Laidlaw

1991 Progress Software Toronto, Ontario

Programming in Progress

A weeklong full time hands on programming in Progress course.

1997 IBM Canada Toronto, Ontario

AIX Version 4 Implementation Differences – Course Q1139

Course required so that I could guide customers through an upgrade to AIX 4.1 over the phone. (NxTrend)

1999 DPS Inc Indianapolis, Indiana

DPS Technical Training Course

Course designed to give programmers a better understanding of the internal and technical aspects of DPS software, covering installation options/Customer Setups/OE/AR/AP/INV/GL and an overview of other software offerings.

2002 IBM Toronto, Ontario

IBM Satellite Courses

S1650 An introduction to the Integrated Language Environment

N42S0 Thinking in Terms of Objects.

N80S0 Java Programming

Other Work Experience

Security Guard - Ontario Guard and Intercon Toronto Ontario, Woodworker - Fenlon Falls Ontario, Cook - Burger King Toronto Ontario, Apr Chef - Ramada Inn (401&404) Toronto Ontario, Truck Driver/Loader - Skidmore Toronto Ontario, Waiter - Husky Car & Truck Stops Hinton Alberta, Planer Stacker - Lumber Mill Northern Alberta, General Labour Alberta, Night Cleaner - McDonalds West Vancouver B.C., Head Grill Cook - White Spot Restaurants West Vancouver B.C., House Painting Vancouver B.C., Handyman - Retirement Home Vancouver B.C..