System Project

VINCENT D. FORBES

**** ****** ****

Burlington, Ontario

L7M 3Y3

905-***-**** *******@******.**

An experienced programmer analyst with a varied background in project management, programming, operations, security & networking in a large Financial Institution. Recognized for expertise and knowledge of current techniques and advancements in the field. Strong team player and supporter, willing to assist other members to solve problems and increase productivity. A flexible dedicated professional, willing to tackle any new challenge.

KEY SKILLS25+ years of professional programming in a financial environment.Knowledge of:

RPG – 25 yrs

CLLE – 10 yrs

Query – 25 yrs

Windows – 15 yrs

RPG le – 15 yrs

CMD – 25 yrs

WDSCi – 6 yrs

MS Office – 10 yrs

RPG Free – 7 yrs

FTP – 10 yrs

SQL – 2 yr

dBase – 5 yrs

DDS – 25 yrs

TCP/IP – 10 yrs

Image/400 – 5 yrs

Cobol – 5 yrs

CL – 25 yrs

SSL – 2 yrs

DOS – 25 yrs

Worked on the System 38 (V3R0), AS/400, iSeries, i5 system & Power i. i5 OS V5R4. IBM PC XT – Intel Pentium i7. Dos 2.0 to Windows 7.Third party tools: TAATools – 15 yrs, Synon – 10 yrs, Xmenu – 10 yrs, Robot scheduler – 10 yrs, MKS Implementer – 5 yrs, ASC Abstract / Probe – 15 yrs.Applications: Guaranteed Funds System, Personal Trust System, General Ledger Management, Mortgage Management, Mutual Fund Management, Term Deposit System, Personal Portfolio System, PPS Imaging, Wills Management. MRP Material Requirements Planning, SOE Sales Order Entry .Project management experience with numerous small & large projects. Report design, tax tracking & government report, capital gains, statement creation, mortgage & loan calculations / reporting, cheque tracking / printing {including French accents}, account performance calculation / reporting.Excellent problem solving abilities. After hours support to correct problems with the production system and the computer. Always solved problems before the system had to be up the next day.Expert at all aspects of the IBM AS400 & Power i computer systems.Experience in project analysis, programming, operations, security & networking.

EXPERIENCE

Rockwell Automation 2010 – 2011

Senior Application ConsultantTask performed: project analysis; programming; production support; operation / security support.SOX audit – Gathered information and acquired management approval of results.Data base purging. Old Journal receiver deletion. Old spool file deletion. Cleared over 20% disk space.Inventory audit was not working. Thousands of locations were not being counted. Re-wrote the process to guarantee that all locations would be counted the correct number of times per year.Created data conversion to SAP processes.Installed Excel spreadsheet Generator.Assisted in the planning & moving to a new Power i box.

CIBC 1990 – 2009

Senior Application AnalystTask performed: project analysis; programming; production support; operation / security / networking / desktop support.Analyzed projects, designed, programmed & implemented solutions using tools like Synon, RPG, WDSCi etc.Updated & maintained loans / mortgages contained in SD RSPs & pension funds. I wrote a program to calculate mortgage accrual rates.Statement enhancement / redesign, including adding a new product & features. Converting them from line printer to a colour laser printer.Updated tax reporting to reflect government legislation.Enhancement of the cheque process to use a secured laser printer with MICR and provide more cheque controls such as cancel & stale date cheques.Creation of numerous reports from simple queries to complex extractions involving more than a dozen filesUpdate the Fee process to calculate the fee by market value at the end of the previous month.When any user had a problem with the application, I analyzed the problem & advised the users on either how to use the application to solve or how to work around their problem or recommend a program / data fix.Optimized a long running nightly task from 1 hours to 30 seconds.Worked with a team to migrate the development & production systems to HP. I solved many of the configuration problems with the operating system & migration tools during the migration to keep the project on schedule. Advised the operations department how to accomplish tasks such as backups, security changes, performance tuning etc.After hours support of any & all production problems.Migration & conversion of multiple CICS AS/400 applications to an RISC AS/400.Setup security on the new AS/400.Configured the system values to meet the requirements.Converted the RPG & CL programs & fixed any exceptions.Parallel testing of all programs. Evaluated numerous third party software packages. Several were purchased.

Morgan Trust / Financial Trust 1982 – 1990

Programmer AnalystTask performed: project analysis; programming; production support; operation / security / networking / desktop support.Install PTFs & new versions of the operating system.Migration & conversion of multiple System 38 applications to an AS/400.Co-ordinate the delivery & installation of the new hardware.Install operating system, OS/400.Configure the operating system for multi-lingual character set, security & operations.Converted all RPG & CL programs. Fix all exceptions.Installed and configured new GL, mortgage, & mutual fund applications.Setup the security to restrict access.Setup the backup / recovery procedures.Managed the user’s PCs.Installed / upgraded versions of DOS, Windows, Lotus, Word Perfect, dBase, Sendero client access.Created menus for the DOS version of PCs.Performance tuning & capacity planning.Monitor the production programs to ensure reasonable interactive & batch times.Keep track of file growth to predict when a computer system upgrade would be needed.Established operation, security & programming procedures for the new System 38. This included: Securing the system from unauthorized users.Restricting access of the production database & programs from unauthorized changes.Creation of production promotion procedures including audit trail of changes.Setting up daily, monthly & yearly backup procedures.Migrated two applications from a System 34 to 38.Install operating system for the S38.Converted the RPG II & OCL programs to RPG III & CL and correcting the exceptions. Converted the data from flat files to externally described S38 files. Parallel testing of all programs.

AWARD / ACHIEVEMENTS

Member of Mensa Canada Society. {Requires IQ in top 2%}

On the Spot Award (2003) Assisted in Image System upgrade to solve start up problem.

Y2K Award (Jan 2000) Recognized for work done to make Y2K work without any problems.

Above & Beyond Award (1998) Recognized for after-hours support solving problems & still coming in to work the next day.

Above & Beyond Award (1998) Created new process that runs in minutes & saves days of manual work.

President’s Service Recognition Award (Nov 1994) Going above and beyond to solve user problems.

EDUCATION / PROFESSIONAL DEVELOPMENT

Bachelor of Math & Computer Science University of Waterloo

Technical Education Conference Toronto Users Group for System i

Common Conference Common Group

Emergency First Aid w/CPR Level A St. John Ambulance

Marketing Curriculum CIBC

Anti Money Laundering CIBC

Presentations CIBC

Image/400 {Contact Manager} IBM

Performance Tuning IBM

DB2 Web Query for System i IBM

Thin Client Synon

Synon / 2E / CM /TC Synon

Design to Construction II Synon

PERSONAL

Volunteer Cub / Scout Leader for 10 years.

Golf, downhill skiing, tennis, racquetball, baseball, football etc.

Photography {including darkroom work}, collecting records & old coins.

Contact this candidate