Executive Profile

Results-driven professional with extensive experience in managing technology systems, IBM AS400/ISeries management/programming/development, and Microsoft Access/VBA programming and development. 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, Advertising, Health Care and Human Resource Services.

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

·         TL Ashford Barcode400

·         HealthCare Management Systems(HMS)

·         Integrated Distribution Solutions(IDS)

MICROSOFT

·         Windows NT/2000/XP/Vista

·         Exchange

·         Office Suite

·         Outlook

·         Access

·         Visual Basic Applications (VBA)

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.

·         PWI-ITG (aka Mercury-Kintana)

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:

Blue Cross/Blue Shield of Vermont, VT November 2009 – On-Going

(Health Care)

AS400 (ISeries)

1)       Participated in a comprehensive Infrastructure Assessment, focusing on the ISeries infrastructure. This included reviews of hardware, software, maintenance agreements, policies, procedures, practices etc.

Fidelity Investments, NH November 2002 –December 2009

(Financial Services)

MICROSOFT ACCESS PROGRAMMING

2)       Modify and add to existing Access databases and queries associated with the Payroll Verification system, Year-End Projects Management system and Customer Statistics Reporting system.

3)       Extensive data analysis and reporting to support client Service Level Agreements

4)       Created a suite of integrated databases associated with Operations Readiness project management (ORIS: Operations Readiness Information System). This included seamless integration between Access and Excel.

5)       Developed critical need databases for Implementation to replace manual systems for Supply-Demand Capacity Planning and Project Budget-Actual reporting.

6)       Developed critical needs database for Supplier Contract Management to replace manual systems for managing the relationship between Fidelity and Suppliers and Clients served by the Suppliers. This application includes information such as Demographics, SLAs, Invoices, Volume Metrics, Change Controls, Risk Assessments, Performance Metrics, Budget/Actual/Forecast. Includes dashboard style reporting.

7)       Developed a database to house and report on the Large Market Offering taxonomy, including What-If analysis.

8)       Developed a database to automate a manual billing process for Corporate Action and Change Order Management projects.

PROJECT MANAGEMENT

1)       As a member of the Process Excellence and Strategic Planning organization, supported project initiatives, including primary oversight responsibility for a 3.5 million dollar budget for Service Gaps (Change Controls).

Gentex Corporation, NH September 2008 – On-Going

(Manufacturing)

MICROSOFT ACCESS PROGRAMMING

1)    Modify existing Access databases to modernize, and to meet new requirements.

Merchants Reporting Service, MA November 1999 – On-Going

(Legal Document Research Service Provider)

I.S. MANAGER SUPPORT

Support all computer operations on as needed basis (AS400/Windows NT environment).

SPECIAL PROJECTS

1)    Designed and programmed a complete AS/400 software application suite in RPG to automate Merchant’s internal business systems. Implemented Electronic Data Interchange (EDI) in order to satisfy their primary client’s requirement to interact with them electronically.

2)    Designed a web site that allows customers to order services and check on the status of orders via the Internet (http://www.merchantsreporting.com/).

3)    Designed and implemented an AS400 based email solution to email documents, such as invoices, to customers that requested this type of service.

Bird Precision, MA, September 2000 – December 2007

(Manufacturer of High Precision Flow Control Components)

I.S. MANAGER SUPPORT

Support all computer operations on an as needed basis (AS400/Windows NT environment).

SPECIAL PROJECTS

1)    Installed a Windows NT network with corporate wide AS400, e-mail and Internet access.

2)    Implemented a corporate wide anti-virus solution.

3)    Identified and implemented a PC server based client server Document Management solution that integrates with the AS400 to create a paperless office environment (DocuXplorer). Included custom design work from the vendor.

4)    Developed a Customer Contacts application in Microsoft Access.

Harrington Memorial Hospital, MA April 2002 - July 2007

(Health Care)

IBM QUERY, AS400 RPG & C/L PROGRAMMING SUPPORT

1)    Design and build reports using IBM Query and RPG programs to provide needed reports and application modifications that were not available from their new AS400 software vendor, HealthCare Management Systems.

2)    Design and build interfaces using RPG and C/L programs to outside systems and vendors, including banks, printing systems and billing vendors.

3)    Design and build an AS400 based application that tracks and reports required training for health care professionals. This included automatic emailing of compliance reports to department heads.

MICROSOFT ACCESS PROGRAMMING

2)    Design and build a Microsoft Access application to record and document patient stress test results. Included a seamless interface to Microsoft Word.

3)    Design and build a Microsoft Access application to create mailing documents for patient satisfaction surveys. Built the user interface for recording survey results. Designed and built survey reports for management. This application includes a direct link to the AS400 database. This application includes a seamless interface to Microsoft Word.

Mailways, August 2005 – On-Going

(Advertising Services)

AS400 (ISeries) RPG PROGRAMMING

1)       Define, Design, Develop end-user programs for data manipulation of massive data files.

Manchester Wholesale Distributors, Inc., NH October 2003 – May 2007

(Wholesale Distribution – Food Service Industry)

AS400 RPG PROGRAMMING

1)       Provided RPG programming support by customizing vendor supplied programs (IDS) to meet unique client requirements.

State of Rhode Island, Dept. of Human Services May 2006 – October 2006

(Public Health)

PROJECT MANAGEMENT

1)       Oversee the implementation of an Internet based software suite for Early Intervention Services, by Welligent (RIEICCS). This software was rolled out to twelve Early Intervention Service Providers.

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.

StockCross Financial Services, Inc., April 2005

(Financial Services)

AS400 (ISeries) DATA EXTRACT

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 EXTRACT & 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 – December 2006

(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.

2)    Developed RPG and C/L programs to automate the creation of data export files for an outsourced Loan Collection vendor.

Meeting Street, RI May 2004 – August 2006

(Public Health)

PROJECT MANAGEMENT

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

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

Public School Retirement System of Missouri February 2004

(Financial Services)

AS400 (ISeries) SECURITY ASSESSMENT

1)       In February, 2004, executed a complete AS400 security assessment of the production ISeries partition 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.

State of Hawaii August 2003

(State Government – Department of Health)

PROJECT MANAGEMENT

1)       Performed an analysis of an integrated infant health screening software solution. The objective was to determine the appropriateness of the software solution towards meeting the long term goals of the Health Department.

Legato Systems February 2003

(Software Solutions and Services)

AS400 INSTALLATION and CONFIGURATION with Lotus Domino

1)      Unpacked, installed and configured a new AS400 including Lotus Domino Server

ConQwest, MA November, 2002 – August, 2004 (Senior AS400 Security Engineer)

(Technology Security Solutions)

AS400 Security Assessments 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.

1) Bahamas Electric Corporation, Nassau, Bahamas, December, 2002

One AS400

2) New Hampshire Ball Bearings, Peterborough, NH, April 2003

Four AS400’s, (including LPAR’s)

3) Bahamas Telecommunications Co., Nassau, Bahamas, August 2004

Two AS400’s

Robert Howard Law Office, NH August 2002 – December 2004

(Legal)

NETWORK SUPPORT

1)    Support all computer operations on an as needed basis (Windows XP/2000 environment).

Hesser College, NH July 2002 – December 2004

(Higher Education)

AS400 RPG PROGRAMMING

1)    Replace existing earnings report applications, developed with IBM Query, by building a consolidated RPG application that streamlines the data collection effort and significantly reduces end-user involvement.

2)    RPG programs for data conversion between TEAMS 2000 and Campus 2000 software applications.

3)    Replace existing Financial Aid reporting application, developed with IBM Query and TEAMMATE, by building a consolidated RPG application that significantly reduces end-user involvement.

Wright & Cherry, P.L.L.C., NH May 2002 – Feb 2003

(Legal)

NETWORK SUPPORT

1)    Support all computer operations on an as needed basis (Windows NT/2000 environment).

State of New Hampshire Oct. 2000 – June 2006

(State Government, Department of Health and Human Services)

PROJECT MANAGEMENT

1)    Assigned as the Information Systems Specialist for the Adolescent Health Strategic Planning Project. The primary goal of this project was to improve New Hampshire’s adolescent health care system through strategic planning and implementation to improve the health status of New Hampshire’s youth. Performed a statewide search for data systems containing adolescent health data. Wrote a comprehensive report that became the roadmap for moving the project forward

2)    Assigned as the Information Systems Specialist for the Early Hearing Detection & Intervention Project. The primary goal of this project was to develop a high quality, efficient, family-centered, and sustainable statewide universal newborn hearing screening program. Performed a comprehensive search for the right technology solution for the State and for partner birthing facilities. Lead the RFP effort to choose the best vendor.

(Co-wrote a grant application to the Center for Disease Control which resulted in $400,000 in funding for this project.)

3)    Wrote data interface documentation for hospital Information System Departments to get patient demographic data into the web based Newborn Hearing Screening application. The goal is to reduce the hospital’s manual data entry effort.

Notre Dame College, NH Nov. 2001 - Dec. 2001

(Higher Education)

AS400 INTEGRATED FILE SYSTEM

1)    Configured the IBM AS400 and Client Access Operations Navigator to use the Integrated File System (IFS) on the AS400 to store PC files and documents. This created a secure and safe storage location for PC files and documents that did not exist before for this organization.

Quincy College, MA Nov. 2001 - Dec. 2001

(Higher Education)

AS400 BACKUP & RECOVERY

1)    Provided assistance through a computer disaster after AS400 hard drive failure. Designed and documented an AS400 Backup and Recovery strategy.

Town of Salem, NH, Feb.2000 – Mar. 2002

(Municipal Government)

I.S. MANAGER SUPPORT

Support all computer operations on an as needed basis (AS400/Windows 2000 environment).

SPECIAL PROJECTS

1)    Developed routines and wrote RPG and C/L programs to automatically link data from an Oracle database residing on an NT server to an AS/400 database. This was a hands-off database synchronization solution.

2)    Recommended and assisted in the implementation of a corporate wide anti-virus solution.

3)    Assisted in the roll-out of Microsoft Exchange Server 2000.

Aviation Technology, NH Feb. 2000 – Apr 2004

(Manufacturer of Specialty Aviation Test Equipment)

I.S. MANAGER SUPPORT

Support all computer operations on as needed basis (AS400/Windows NT environment).

SPECIAL PROJECTS

1)    Implemented a Windows NT server based network with central storage and backups for critical company electronic files and integration with the AS/400..

2)    Used the IFS on the AS/400 for storage and backup of archived CAD drawings.

3)    Recommended and implemented a corporate wide anti-virus solution

Professional

Affiliations / Recognitions

Veritude-Fidelity

Employee of the Quarter nominee – 1st Quarter, 2008 (1^st Place Platinum Award)

Employee of the Quarter nominee – 4^th Quarter, 2006 (1^st Place Platinum Award)

Employee of the Quarter nominee – 1^st Quarter, 2006

NH Midrange Users Group (NHMUG), 1987 - Present

Member 2000-Present

Director Special Projects 1994-1996, Treasurer 1991-1993, Director Programs & Speakers 1990, Vice President 1989, Director Big Brother Program 1988.

New England Municipal Building Officials annual convention - Speaker

“Introduction to Geographic Information Systems (GIS)”, 2002

“Troubleshooting Computer Problems”, 2001

“The Internet and World Wide Web”, 1999

“Computers for the Novice”, 1998

“Computers for the Novice”, 1997

“Computers in the Office”, 1989

Salem Public Administrators Association (SPAA), 1989 - 1999 Treasurer/Secretary

Education

Microsoft Office Certified Specialist for Access 2000, 2005

AS/400 RPG IV Programmer (an ILE Language) – IBM Certified Specialist (ICS), 2004

Web Enablement Workshop for iSeries – IBM - 2002

Microsoft Access 2000 – 90^th Percentile or above – ProveIt.Com, 2002

Microsoft Outlook 2000 – 90^th Percentile or above – ProveIt.Com, 2002

AS/400 Professional System Operator – IBM Certified Specialist (ICS), 2001

Microsoft Windows 2000 Professional – Microsoft Certified Professional (MCP), 2001

Associate Degree in Electronic Data Processing, NH Technical Institute, Concord NH