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 |