John A. Bernard       603-867-7998       jabccs@comcast.net       www.jabconsulting.net

 

INFORMATION TECHNOLOGY PROFESSIONAL

IBM AS400 / Microsoft Systems / Project Management

 

Executive Profile

 

Results-driven professional with extensive experience in managing technology systems, IBM AS400 programming and development, and Microsoft operating system environments.  Eighteen years of success as an Information Systems “hands-on” style manager.  A unique ability to work effectively with people at all levels of an organization.  Experience in the following industries: Manufacturing, Local and State Government, Public Safety, Public Utility, Service, Legal, Higher Education, Financial Services, Wholesale, Banking and Health Care. 

 

 

Areas of    

Expertise

IBM AS/400 (ISeries)

·         Management/Support

·         RPGIV  Programming

·         Structured Query Language (SQL)

·         Applications Design

·         DB2-400 Database Design

·         Security Assessments

·         Integrated File System

·         Operations Navigator

·         Automated Paging

·         IBM Client Access

·         IBM Query

·         ASC Query and Report Writing

·         MAPICS 1 – Financial/Mfg.

·         HTE Public Safety (Crimes/CADIII)

·         New Generation General Ledger

·         Pro-Help Forms Design

·         SoftLanding SoftMenu

·         HealthCare Management Systems(HMS)

·         Integrated Distribution Solutions(IDS)

 

MICROSOFT

·         Windows 95/98/NT/2000/XP

·         Exchange 2000

·         Office Suite

·         Outlook

·         Access

·         Visual Basic

 

NETWORKING

·         Design/Implementation/Support

·         Protocols

·         Cabling

ENTERPRISE

·         Project Management

·         Strategic Planning

·         Capacity Planning

·         Technical Support

·         Decision Making / Problem Solving

·         Backup/Recovery/Availability

·         Multi-Site Technology Operations

·         24/7 Operations Support

·         Security

·         Internet Access

·         Budget Preparation & Management

·         Voice Mail

·         Corporate Antivirus

·         Telecommunications

·         PC Troubleshooting & Repair

 

OTHER

·         Public Speaking

·         Web Site Design

·         Vision Property Mgt. Application

·         Geographic Information Systems

·         Structured Query Language (SQL)

·         Centrex Voice System

·         ActiveVoice Voice-Mail

·         Corel Office Suite

·         Cartegraph Asset Management

·         File Transfer Protocol (FTP)

·         Electronic Data Interchange (EDI)

·         DocuXplorer Document Mgt.

 

 

 

 

Work

Summary

=Consulting

=Full Time

Company

Type of Work

Mailways

RPG and C/L Programming

StockCross Financial

AS400 Data Export

Community Bankshares, Inc.

AS400 Security Assessment

Detwiler, Mitchell, Fenton...

AS400 Data Export and Application Documentation

Saint Anselm College

RPG and C/L Programming

Meeting Street

Project Management – Public Health

Public School Retirement System of Missouri

AS400 Security Assessment

Manchester Wholesale

RPG and C/L Programming

State of Hawaii

Project Management – Public Health

Legato (EMC)

AS400 Installation and Configuration

ConQwest

AS400 Security Assessments

·    Bahamas Electric Corporation

·    NH Ball Bearings

·    Bahamas Telecommunications Company

Fidelity Investments

Microsoft Access Programming

Robert Howard Law Office

Network Administrator

Hesser College

RPG and C/L Programming

Wright & Cherry Law Office

Network Administrator

Harrington Memorial Hospital

RPG Programming, IBM Query, AS400 Support, Access Programming

State of New Hampshire

Project Management – Public Health

Notre Dame College

AS400 Support

Quincy College

AS400 Support

Bird Precision

Network Administrator, RPG Programming, Project Management

Aviation Technology

Network Administrator, RPG Programming, Acting IS Manager

Merchants Reporting Service

RPG Programming, Project Management, Network Administrator, Acting IS Manager

Town of Salem, NH

IS Manager, RPG Programming, Project Management

Network Administrator

Hastech Inc.

RPG Programming, IS Manager

Pike Industries

RPG Programming

 

Project

History

2000-Today

(Consulting)

JAB Computer Consulting Services, LLC, NH  January 2000 - On-Going 

(Computer Consulting)

 

Established a computer technology consulting business specializing in the IBM AS/400, Microsoft Operating Systems and Project Management.  Following are businesses that have benefited from the extensive industry experience associated with this company:

 

Mailways,  August 2005 – On-Going

(Mass Mailing Services)

 

AS400 (ISeries) RPG PROGRAMMING

1)      Develop programs for data manipulation of massive data files

 

StockCross Financial Services, Inc.,  April 2005

(Financial Services)

 

AS400 (ISeries) DATA EXPORT

1)      Identified and exported critical data off the AS400 for other uses by the client.

 

Community Bankshares, Inc.  April 2005

(Banking)

 

AS400 (ISeries) SECURITY ASSESSMENT

1)       In April, 2005, executed a complete AS400 security assessment of the bank’s ISeries system analyzing the physical security, backup procedures, user profiles, password rules, device descriptions, line descriptions, command authorities, network configuration, remote access, system values etc.  Presented a complete prioritized report of findings with recommended follow-up actions.

 

Detwiler, Mitchell, Fenton & Graves, Inc.  February 2005 – July 2005

(Financial Services)

 

AS400 (ISeries) DATA EXPORT & APPLICATION DOCUMENTATION

1)      This client was using the AS400 for access to historical data only.  They wanted to migrate this data to a non-AS400 platform.  Starting in February 2005, assisted the client by identifying the data still in use, exporting that data off the AS400 and documenting the data relationships and user interface so it could be replicated on another system

.

Saint Anselm College, NH  June 2004 – February 2005 

(Higher Education)

 

AS400 RPG PROGRAMMING

1)    Developed RPG and C/L programs to integrate a PC based financial aid package called PowerFAIDS, with associated applications running on the AS400.  This involved the transmission of data extracts between systems.

 

 

Meeting Street, RI  May 2004 - Present

(Public Health)

 

PROJECT MANAGEMENT

1)       Overseeing the implementation of an Internet based software suite called Health Manager by Welligent.  Health Manager is a comprehensive, integrated Client Management Information System. 

2)       Developed a Microsoft Access database that “bridges” Early Intervention data from the Welligent application to the State of Rhode Island’s EIMIS Access database.

 

 </