Jon Wheatland

Managing Consultant

PROFILE

A strong technical background focusing primarily in the development of client/server and WEB CGI based applications with Relational Database back ends specializing in INGRES, Informix, Oracle and Microsoft SQL server. Additional expertise in UNIX, Windows95 and Windows NT operating environments. The primary focus of experience has been in the analysis, design, development and implementation of large scale OLTP systems involving Relational Databases, GUI, 4GL and C/C++ constructed interfaces. All projects utilized CASE tools and structured methodologies.

EXPERIENCE

1994 -

Managing Consultant and Partnet

Enterprise Information Solutions

1993 - 1994

Senior Systems Analyst

SHL Systemhouse Inc.

1990 - 1993

Senior Systems Analyst

Ameritech Information Systems

1983 - 1990

Software System Manager

Employee Security Plans Inc.

 

EDUCATION

1983 - 1988

B.S. Mathematics & Computer Science

University of Illinois - Chicago

 

RELEVANT EXPERIENCE

Enterprise Information Solutions

National Housewares Manufaturer’s Assiciation (NHMA).

Managed projct to reengineer enterprise system for this premier not-for-profit trade show organization serving the housewares industry. The system is designed to perform several critical functions: Operating a world class trade show, Enrolling and managing company memberships, maintaining information for the special interest group Housewares Export Council of North America (HECNA) and tracking individual membership in a variety of committees offered to member companies.

A subset of the business requirements stated above were previously satisfied by a system based on Macintosh/FoxPro technology. We have reengineered and extended the capability of this system using a more widely accepted platforfm. The server operating environment is Window NT coupled with the realational database Microsoft SQL server 6.x. The client interface was developed using SyBase’s PowerBuilder 6.x and executes transactions to and from the server over a TCP\IP local area network.

Compusystems, Inc.

Lead designer and developer of On-site Trade Show Registration System. This system is used at the point of sale to record attendance, print graphical credentials, track conference allotment and maintain financial information on a per registration basis. Responsibilities included requirements analysis, screen design, application development and testing, and report writing.

Provide in house SQL training to client staff and provided on-site support at client sites where product was deployed.

Designed application architecture and software for an automated faxing subsystem. This system interfaces with VSI*FAX, a UNIX based fax server product, and employs a custom server (daemon) process that logs fax transmit notification to remote databases indicating the success or failure of faxed confirmation letters. Additionally, integrated REFORM forms software to merge database information and aesthetically enhance a faxes appearance.

Performed preliminary analysis for company's batch processing/scheduling requirements for the advance portion of show registration.

Lead project to increase system performance employing EMPOWER remote terminal emulation software. Redesigned application modules to minimize SQLs and to cache data where possible.

 

SHL Systemhouse

HealthcareCOMPARE, Inc.

Assumed project management role in developing a system to track historical and administrative claim information. Additionally assumed responsibility of performing analysis and design of a

scheduled reporting system. Work included the creation of both Process and Data Models as well as Structure Charts and Module P-specs using the Visible Analyst Workbench CASE product. Front end applications were developed using INGRES Windows/4GL running under Windows 3.0 on PCs. Data services were provided using INGRES DBMS servers running on a VAX host under VMS and using INGRES NET to provide the client/server communication.

Ameritech Information Systems

Critical Shipment/Transportation Logistics System

Team leader for the preliminary and detailed design, development and testing of Field Services and Power Unit Dispatch application subsystems. Continued this responsibility into all continuing phases of the lifecycle. Front end applications were developed using INGRES Windows/ABF running under UNIX on a Sequent server. Data services were provided using INGRES DBMS servers running on the same machine.

Assumed lead development role during the follow-on engagement undertaken by AIS for Roberts which involved enhancing and performance tuning the original application system. Was one of four resources placed in this role by request of the client.

Project manager for RBASE Sales Reporting System conversion to INGRES platform. Performed all analysis and design for reports, initiation screens, database schema and historical data conversion and population.

Gross Payroll Management System

Assigned lead development role of the Gross Payroll Management System simply stated to convert timecard hours to gross earnings based on union negotiated wage practices. Responsibilities included the design and development of the timecard entry and timecard reprocessing subsystems, and major code revisions to the gross pay calculation process incorporating dynamic SQL and performance tuning techniques.

Personnel Radiation Exposure Management

Assigned to the design and development of the Inventory Control and Radiation Work subsystems. Responsibilities also included architecting EMPOWER scripts that would play a critical role in performance testing.

Employee Security Plans, Inc.

Designed and developed an employee group payroll deduction life insurance system using INFORMIX relation database, 3GL/4GL language and C. Assumed responsibility for application enhancement, system administration and hardware/software growth migration and upgrades.

 

TECHNICAL EXPERIENCE

Hardware Experience:

Computer:

System Software:

 

HP 9000

Sequent

IBM 370

FIVESTAR 386

IBM PC

HP/UX 8.0

DYNIX/PTX 3.1.2

MVS

SCO UNIX

MSDOS, Windows 3.1

Windows95

Software Experience:

Languages:

Application Software:

 

C

C++

SQL

INGRES 4GL/ESQLC

INFORMIX 4GL/ESQLC

BASIC

ASSEMBLER

Pascal

Fortran

ZPL II

Powerscript

PL/SQL

INGRES/Vision

Microsoft Visual C++

INGRES ABF

INGRES/Windows4GL(Training @ INGRES/Oakland, CA)

Empower (Remote Terminal Emulator)

Visible Analyst Workbench

 

 

ZEBRA Thermal Printer Language

SyBase/PowerBuilder 6.x

ORACLE 7.x

Application Experience:

Order Entry

Vehicle Dispatch and Routing

Field Services and Maintenance Tracking

Gross Payroll Management

Trade Show Registration

Payroll Deduction Life Insurance Enrollment

Structured Analysis, Design, Development

System Testing

Performance testing/tuning

Automatic Number Identification (ANI) Computer Integration

Project Management

Training

Trade Show Registration