Resume

• 1970

  Business and Psychology

  BS

  CIS

  Business

  General Interest

  AA

  Transportation and Distribution

  Honor Society

  Mt Hood Community College

• Visual Basic

  MySQL

  Microsoft SQL Server

  Visual Studio

  PHP

  XML

  Systems Analysis

  Database Design

  JavaScript

  T-SQL

  SDLC

  Oracle

  Access

  SQL

  HTML

  Software Development

  Databases

  PL/SQL

  Visio

  System Administration

  Jonathan

  Vicki

  Jonathan

  Paul Carlson Associates

  Inc

  Consolidated Freightways

  Oregon Institute of Technology

  Freightliner Corporation

  Portland Community College

  Clackamas Community College

  Oracle forms & reports

  SQL and PL/SQL. Microsoft SQL Server Management Studio: SQL

  Transact-SQL

  Visual Studio

  C#

  VB.

  Adjunct Instructor

  Portland

  Oregon Area

  Oregon Institute of Technology

  · Audited and processed all freight bills for payment.\n· Maintained tariff library in support of that rate audit.\n· Developed rapport with motor and rail carriers

  tariff bureaus

  and vendors to\n guarantee the best price and service for the transportation needs of the company.\n· Assisted other team members as needed.

  Freightliner Corporation

  Programmer

  · COBOL

  Easytrieve Plus

  TSO

  JCL

  DB2

  SAS.\n· Read/write mag tapes/cartridges/pc diskettes

  ETL.\n· Maintain Computer Assisted Rating (CAR) System tariff database (DB2).\n· Provide data in many formats and information to various clients including customers

  \n the field

  the Pricing department

  the Boise Rate Center

  and other I/T personnel.\n· Developed better reporting processes and products

  consistently met deadlines

  and\n always performed quality work.\nRate Auditor\n· Field audit researching and assisting both customer and company to ensure correct\n freight rates and charges applied to bills.\n· Rate quotes and billing. Allowance claim processing.\n· Freight bill auditing and support for auditors in interpreting freight tariffs.\n· Proof-reading rates and assisting in the proper update of tariff pages.

  Consolidated Freightways

  Clackamas Community College

  Oregon City

  OR

  Part-time Instructor

  · IBM mainframe skills include TSO

  JCL

  COBOL

  DB2

  VSAM and Easytrieve Plus.\n· Microsoft Office applications including Visio.; · Online and Batch on-call support.\n· I/T Resource Training Team member involved in planning in-house education.\n Developed lesson plans and instructed classes in COBOL and DB2 SQL.\n· Subject Matter Expert on rates and tariffs. Trained and supervised co-workers in\n tariffs and the process of loading them.\n· Essential member of team supporting the yearly general rate increase:\n· Sole responsibility for loading (ETL) competitor and customer tariffs:\n · Each accurately loaded tariff resulted in time savings for the Rate Center varying\n in a per person savings of from minutes to hours daily. Often the savings was\n from a manual rate lookup to computer rating.\n · Participated in the development of time-saving procedures that also ensured\n accuracy of the rates for billing and quoting.

  Consolidated Freightways

  Portland Community College

  Portland

  Oregon Area

  · Distance and face-to-face courses in database design and development

  systems analysis

  and introduction to computer systems. This includes but is not limited to CIS125D Database Application I w/ Access. CIS275 Data Modeling and SQL Intro w/ SQL Server or MySQL w/ CLI

  Workbench and PHPMyAdmin

  CIS276 Advanced SQL w/ Transact SQL and Oracle PL/SQL

  CIS244 Systems Analysis using the system development lifecycle (SDLC).\n· Past instructor for CIS133C Cobol I using ES/9000 and AS400 computers.\n· Web pages and PowerPoint and Camtasia utilized for class support.\n· Helping others with computer concepts.

  Adjunct CIS Instructor

  · MS Word

  Excel

  Access

  and PowerPoint in support of the safety and health projects\n performed by the Industrial Hygienists.\n· Internet research providing reference material for co-workers in support of their goal\n to provide our clients with the best service possible.\n· Webmaster for several sites.

  Paul Carlson Associates

  Inc