American Backflow Calibration-Consultant/Business Anaylst

Backflow Device Management System

Environment: PC, IIS, VBA, MS Access, MS SQL2005

Design and quality control for a complete online web management

system for water

Backflow systems (29,000+ customers). The system manages the

backflow devices for each

municipality in the local area. Responsible for the high level

overview and design.

Gathering of specs from municipalities and users in the field.

Budweiser/Anheuser Busch-Consultant/Product Development

Text Promotion System

Environment: PC, IIS, VBA, MS Access, MS SQL2005

Design and quality control for an instantaneous, electronic gateway

method to bypass the

delays of CSC codes, carrier approvals and restrictions. The

content-programs include

contests, surveys, direct marketing, games, and giveaways. The

system, IM4TEXT, allows

any wireless subscriber to participate.

Beta testing performed at a Nickelback concert in St. Louis where a

series of front-row

seats were given away. Submitted and granted a USPO provisional

patent.

Various St. Thomas, USVI Companies-Consultant/Business Analyst

Restaurant POS System

Environment: PC, Dinerware, QuickBooks

Researched best system solution (Dinerware), negotiated price,

installed, customized

setup, tested and trained for 4 restaurants: Island Beachcomber,

Molly Molones,

Grapevine Grille, Modern Saute. Implemented with best credit card

processing service.

Set up interaction with QuickBooks accounting software.

Accounting System

Environment: PC, QuickBooks

Researched best system solution (QuickBooks), selected best QB

product, installed,

Customized setup, tested and trained for 2 contruction companies:

Roy's Construction

and Do Right Construction, as well as a marine repair center: All

Points Marine and

a hotel: Island Beachcomber.

TING INC-Owner/Product Invention

Live Photo Email Kiosk

Environment: PC, IIS, VBA, MS Access, Kiosk-in-a-Box, Touch-screen

Conceptualized and lead the creation of an invention, TING, a self-service

station that

allows you to electronically transmit a personalized, live on-location

photo greeting that prints a collectible photo card. Research, design,

coding, testing, and sales of this product that went to market.

TING was placed at various amusement parks and venues to include

Kings Island,

Ohio State Fair, Florida Spring Break and 2002 Winter Olympics in

Utah. Cost and legal

research and analysis for creating a franchise in Rotorua, New

Zealand.

Central Benefits Mutual Insurance Company-Consultant/Project

Coordinator

PROJECT TRACKING AND QUALITY CONTROL

Environment: IBM 3090 MVS/ESA - ROSCOE, TSO/ISPF, CA-

DISPATCH, WINDOWS

Languages : COBOLII, CICS/ESA, DB2, VSAM, ACCESS, EXCEL,

WORD

Duties: Created Brainstorm Task Force to review and discuss quality

assurance issues, TSO usage, and configuration management procedures.

Introduced a new project process for Central Benefits' Y2K project.

While adding quality assurance controls, this procedure also provided

accurate tracking capabilities for each task within each phase of a

project.

Presented process to I.S. staff, managers, and vice president.

VARIOUS COMPANY-WIDE TRAINING

. Produced training manual and held multiple classes for CA-DISPATCH,

geared toward users and same for TSO/ISPF geared toward I.S. staff.

. Held one-on-one sessions with users for Windows, Excel, and Word.

. Mentor to new I.S. employees for various tools and languages to bring

them "up to speed" quickly and make them more productive.

. Ordered, distributed, reviewed latest TSO/ISPF and MVS/JCL reference

books for each I.S. manager to keep them up-to-date.

. Analyzed, produced and distributed training requirements, company-wide.

. Contacted and analyzed various training vendors and methods (classroom,

computer-based, internet).

. Organized and set up vendor presentations and demos.

. Obtained free course trials.

. Analyzed and assisted in selecting best training fit for Central

Benefits.

. Negotiated with vendors for best cost.

. Registered I.S. staff for offsite training.

. Created ACCESS database to track training: requirements, vendors, courses

offered, participants.

Borden Foods-Consultant/Product Implementation

Human Resources

PeopleSoft Conversion

Environment: IBM 3090 MVS/ESA, ROSCOE, TSO/ISPF,

PEOPLESOFT 8/SQR

Duties: Initial implementation of the PeopleSoft HR,

Payroll, Benefits

with related SQR's. This was a short term project as

Resource Partners

took over the project then Borden shut down it's

operations.

BANK ONE SERVICES CORPORATION-Consultant/System Architect

Environment: IBM 3090 MVS/ESA - TSO/ISPF and LIBRARIAN

Languages : COBOLII, CICS/ESA, DB2, VSAM, REXX, ACCESS,

PROJECT WORKBENCH

REFUND ANTICIPATION LOANS - RETAIL CONSUMER LENDING SYSTEMS

FRONT-END PROCESS REWRITE

This system accepted loan applications for IRS tax

refunds from various participating

tax filing companies. The old system, a slow,

inefficient, batch system that ran

hourly has been rewritten into a background CICS

environment to simulate real-time

responses back to the tax filing companies and allow

data to be shared on-line

during the work day.

Duties: Produced a functional high-level design of the

new background CICS process

and transmission of responses to the tax filing

companies. Held periodic

presentations for our users to keep them informed of our

design ideas and status.

Wrote detailed design packages to be programmed and

assisted in the programming phase.

Assisted in integration testing and implementation. Via

workbench and access,

created a quality assurance control process, including

REXX procedures for

migrating programs, that is now a part of standard

procedures for the department.

10 YEAR HISTORY DATA CAPTURE

This DB2 system retains customer demographic, relevant

loan, fee and tax related

information for reference, statistics and application

scoring.

Duties: Discuss with and analyze user requirements to

best design data

dictionary, screens and transmission of

responses to the tax

filing companies. Wrote detailed design

packages to be programmed

and assisted in programming phase.

DIRECT DEPOSIT INDICATOR - ELIMINATION

The IRS used to send an indicator depicting the status

of the applicant;

whether credible or not. This helped remove the burden

of having to score

applicants via credit bureaus. The IRS decided to

remove this indicator

from their response records, 2 months prior to tax

season, forcing us to

install a credit bureau interface and enhance our

internal scoring process.

Duties: Created many eztrieve reports on

behavioral scoring for the

bank's statisticians to analyze. Cost

justifications for the

various solutions to a credit bureau

interface - and proposed an

effective, efficient resolution which has

been implemented.

(SPECIAL MENTION)

Received a Certificate of Appreciation for the DDI

Elimination project.

AMERICAN ELECTRIC POWER-Consultant/Site Mentor

Environment: IBM 3090 MVS/ESA - ROSCOE, TSO and VM

Languages : COBOL, PL/I, CICS, VSAM, NATURAL 2.1 (4GL),

ADABAS (relational) ADASQL, ADAMINTS,

Design I/Method I (CASE)

PLANT INFORMATION MANAGEMENT SYSTEMS

POWER PLANT QUALITY CONTROL WELDING

This system assists engineers in the effort of

welding materials

together via automation of engineering code

standards and safety

precautions.

Duties: Assisted in all phases of life cycle,

from project scope to

installation. Created all detail

designed packages,

integration test plan, and installation

plan. Responsible for

user interface.

POWER PLANT PREVENTIVE MAINTENANCE

Triggers many repetitive maintenance jobs at the

power plants to avoid

operation outages.

Duties: Assisted in detail design, programming,

integration testing,

and installation. Authored installation

test plan.

POWER PLANT TIME REPORTING/PAYROLL

Integrated this manual system into AEP's corporate

on-line time reporting

and payroll system to track power plant employees'

time.

Duties: Solely responsible for the quality

assurance on this project.

Assigned and tracked completion of detail

design, programming,

testing, and reviews using gantt charts.

ENERGY COST INFORMATION SYSTEMS

ADAMINT TO ADASQL CONVERSION

ADAMINT calls to the ADABAS database were no

longer supported from the

vendor, thus a conversion to ADASQL calls was

required.

Duties: Conducted initial research, prototype,

and parallel

testing for converting these ADABAS query

languages.

CASH MANAGEMENT INFORMATION SYSTEMS

ACCOUNTING AND FINANCE CASH MANAGEMENT

Designed to track AEP's current and future debt

and investments.

Duties: Assisted in detail design, programming,

integration testing

and documenting of this on-line system

using Andersen's

Design I/Method I case tool.

(SPECIAL MENTION)

OPERATIONS IMPROVEMENT TEAM

Appointed member of organized team designed to

evaluate problems and

opportunities within the production systems area.

Brainstorming

sessions, researching solutions, feasibility

studies, and implementing

ideas were the major responsibilities involved in

this process.

CABLE & WIRELESS COMMUNICATIONS- Programmer/Analyst

Environment: IBM 3084 MVS/XA - TSO/ISPF

Languages : COBOL, Natural 1.2 (4GL), ADABAS, VSAM, CICS

ENGINEERING INFORMATION SYSTEMS - FRONT END PROCESS

TELEPHONE NETWORK CALL DETAIL RECORD SYSTEM

Liaison between engineering systems and billing,

rating, and revenue

reporting systems.

Duties: Designed a universal call detail record

to facilitate data

between all departments of this long-

distance carrier. Also,

major on-call responsibilities for system

problems.

NEW SERVICES PROTOTYPING

Duties: Designing prototype systems to test new

service plans such as

Tollfree-800, pay phone, and

international dialing.

Contact this candidate