Software System

Sam Morris

**** ********* *****, ******** *****, VA 23452 757-***-****

cell 757-***-****

■ yb6yii@r.postjobfree.com

PROFESSIONAL SUMMARY

Have used Access as a debug and front end for various types of database

Over 20 years in data processing, Application Design and Database Design with expertise in Access, Oracle, PL/SQl, Unisys A Series DMSII, COBOL, Algol, LINC, LINC II, EAE,ETL, Powerbuilder and other tools

Developed basis and strategy reports to determine profitability and maintained inventory of traded commodity

DBA (DMSII, ORACLE and Access)

PL/SQL writing both Stored Procedures and Triggers and using Constraints

Trained in the entire Decision Management Suite from Choridiant including Predictive Analysis Director, Strategy Director, Data Preparation Director, Deployment Manager, and Decision Monitor

Experience with ETL (extracting, translating and loading data) from various databases, programs, and files to various databases and files

TECHNICAL SKILLS

Access SQL DMSII COBOL Algol COMS

LINC II EAE PL/SQL PowerBuildeOracle Server

Visual Basic C Java TCP/IP CRONTAB

ACCOMPLISHMENTS:

Have written Access application for a non-profit as a volunteer (can offer the empty version as an example of my work.)

3 years working on phone supporting LINC for Unisys on the LINC Line working with Unisys clients to better utilize LINC

having worked with a multitude of different software I have developed the ability to adapt quickly to whatever is necessary.

PROFESSIONAL EXPERIENCE

MDV/Nash Finch, Dec 2010-present

MDV supplies the inventory for the military commissaries over half the world.

Maintained and developed software to help manage a warehouse

Worked on traffic software for scheduling trucking

Worked on software to maintain inventory and determine differences in prices.

Maintained legacy EAE software

Update DMAlgol software which read database information.

Tools used: Algol, MS Access, Cobol, WFL, LINC

e.serv Technical Solutions Inc., Feb 2007 – Oct 2010

Contract Consultant assigned to Global Petroleum, Waltham MA

Global Petroleum, a $5.8 billion company, is the largest wholesaler of heating fuel and petroleum products on the East coast maintaining an inventory of 93M barrels of fuel.

Maintained, designed and developed software to track mark to market inventory so that the cost and price could be compared to the daily price for the geographical terminal and the New York Mercantile Exchange

Mark to Market inventory allowed users to compare costs calculated either as flat fee, percentage of price, or per unit and prices to the daily value of inventory as determined by fluctuations in the market.Designed and created a basis report for reporting on the profitability of petroleum inventory comparing price and cost with market prices from the physical locality and New York Mercantile Exchange

Maintained and significantly modified the strategy report for this inventory using EAE reporting facilities to obtain values, costs and prices of the product inventory that included floating prices that were determined over a series of business days and daily market prices.

Maintained inventory legacy software written in EAE and used Excel and DQView as a diagnostic tool to find the cause of problems

Helped maintain the product inventory database tracking over 90M barrels of fuel

Tele-commuted and worked independently with end users to solve their concerns with the software

Tools used: MS Access, Cobol, LINC

Convergys, St Louis MO Jul 2006 - Feb 2007

ISP Support

Work with Users to overcome connectivity and configuration issues for high speed internet access

First and second tier phone support

Help people with problems concerning high speed internet

Worked with TCP/IP technology on both PCs and Macintosh computers

Tools used: MS Access, Excel,

Infogain Corporation, Jan 2006 - Jun 2006

Telecommute Contract Oracle DBA for site in California

Company offers consulting and outsourcing services related to customer relationship management (CRM), enterprise resource planning (ERP), business intelligence, and systems integration.

Performed duties as Oracle DBA (9i) including daily maintenance, user support and installation of tools and software

Maintained and developed Java classes for the system (primarily passports)

Installed various Chordiant software both directly and in middleware, Weblogic and Jboss

Worked with Access installing and using add-ons created by Chordiant

Worked with business analysts to give them the tools they needed and showed them how to use them.

Trained in Chordiant technology, specifically Decision Management Suite

Studied HP-UX 11i to use when we were going to install Chordiant software on Unix systems

Tools used: Java, Oracle. PLSQL, Chordent

Jack Cooper Transport, Kansas City MO Jun 2004 - Nov 2004

Company hauls over 1M motor vehicles from assembly plants, ports, and railway terminals to dealers and other locations across the US through its Jack Cooper Transport and Pacific Motor Trucking and maintains a fleet of about 1,200 tractor-trailer pairs.

Developed software to maintain information for an auto transport company using LINC II (EAE) on a 2200 system.

Worked with ASP and Java to help maintain web pages for this system

Used SQL to directly modify data in RDMS

Modified COBOL 74 legacy programs

Tools used: MS Access, SQL, Java, Cobol,

Vance County Public Schools, Dec 2003 - Jun 2004

Taught 8th grade Geometry and NovaNet, a computer-aided instruction for students who did not succeed in the standard classroom environment

Tools used: MS Access, Excel and Educational software

Senior Net, Jul 2003 - Dec 2003

Volunteer

Designed and constructed an Access database to handle students, courses, classes, instructors for a community program to teach seniors to use computers

Taught seniors how to use computers

Tools used: MS Access, Excel

CognicaseUSA, Jul 2002 - Apr 2003

Contract Consultant assigned to various client sites

Minneapolis Fire and Life

Extracted data from a LINC II system using LINC II report

Extracted data using COBOL74 for analysis

Used Access and Excel to analysis data being extracted

A years experience in insurance

Sunshine Beverages

Wrote LINC II code to handle rebates in a beverage wholesale business

A years experience each in retail

Tools used: MS Access, Excel, Cobol, LINCII

CIBER, Inc., Jul 2000 – Dec 2001

Contract Consultant assigned to ALCOA

Supported and enhanced a system to maintain and analyze energy futures (Powerbuilder front end and Oracle database)

A years experience working on software for Energy futures at ALCOA

Maintained and supported a Visual Basic front end to a third party software

Maintained and modified ASP pages which used VB script to extract information from an Oracle Database

Maintained and developed Unix scripts to run batch jobs in Oracle using CRONTAB

Created and maintained stored procedures, functions and triggers using Erwin to maintain the database

Maintained two Oracle databases from the application point of view

Normalized a relational database

Worked on a series of Access and Excel procedures and databases to get the commodity spending for ALCOA

Tools used: Powerbuilder, Toad, PL/SQL

Upp Business Systems, Downers Grove IL Oct 1998 – Jun 2000

Senior Consultant Assigned to various client sites

Home Shopping Network

Maintained and supported LINC II system which is used for placing orders

Hillyard

Converted a LINC II system into PowerBuilder with an SQL Server Database

Spartan Mills

DMSII DBA

Maintained and installed an ODBC interface for DMSII

Worked in an industrial environment

Designed and developed an Access front end to a DMSII database

Designed and developed an Access system using VBA

Designed and developed an Access front end to Sybase

Worked with a team to design a Sybase database to maintain color formulas

Made COBOL system Y2K compliant

Maintained LINC II system

Maintained COBOL system

Tools used: Powerbuilder, SQLServer, DMSII, MS Access, SQL, Sybase, LincII

SCI, Apr 1997 – Oct 1998

Analyst

Developed LINC II City and County governmental financial packages Mainframe, Unix and PC platforms

Evaluated automated testing software by applying it to the window-based system

Made the application Year 2000 compliant

Trained programmers. Aided new programmers in associating non-standard cash drawer into the system

Installed and maintained an ODBC (Transit) product for the mainframe

Phone support that gave the users customized software as well as technical help on their platforms as well as their software

Tools used: SQL Server, SQL, VB, LincII

UPP Business Systems, Downers Grove IL Jan 1994 – Apr 1997

Senior Consultant assigned to various client sites

Spartan Mills

DMSII DBA

Developed and maintained LINC II systems for manufacturing environment

Maintained COBOL legacy systems

AN Derringer

Maintained legacy LINC II system for an import broker

Worked on the conversion of Aseries Linc to Unix Linc.

Added required features to the system

DAD

Maintained and developed LINC II system for telephone book distributor

Designed and developed an order entry system

Helped establish coding practices

Trained and mentored new hire programmers

AAR

Converted a system from A Series LINC II to Unix

Tools used: DMSII, Cobol, LincII, Unix

Independent Consultant, Sept 1993 – Jan 1994

Programmer Analyst assigned to Jneil

Helped develop an Order Entry System for a large catalog company

Trained new hired programmers in how to develop software in a business environment

Tools used: DMSII, LincII

UNISYS Corporation (formally Burrough’s Corporation), Jun 1979 – Jul 1993

Senior Representative

Developed a telephone tracking system in LINC II and worked as phone support for the LINC II software on the LINC Line assisting End Users write various routines in LINC II

Worked on project to determine if LINC II naturally normalized databases

Special liaison with Home Shopping Network on their LINC II system

Worked on problems which were related to the LINC II software, writing programs in LINC II, A Series NDL, WFL, and ALGOL to test and debug various problems with LINC II

Wrote code in COBOL for various Burroughs systems

Developed the example used for explaining the CALL command and worked closely with a customer on the EXTERNAL AUTO command and used various LINC II systems

Developed remote diagnostic and system performance tools on A Series, V Series, and B1000s

Initially worked on an experimental relational database in a software development environment

Tools used: BPL,ALGOL,MIL,Cobol, NDL, LINCII,Assembler.

EDUCATION

University of the South, Sewanee, TN

BA in Fine Arts

University of Tennessee Knoxville, Knoxville, TN

Coursework for certification for TN for Math and History Secondary level

Chattanooga State Technical Community College

AS in Computer Science

Concurrently took upper level courses from University of Tennessee in Chattanooga

Georgia Institute of Technology, Atlanta, GA

Graduate coursework in Information Science and finished the course work for a masters degree in Technology and Science Policy. Have about a years work in graduate level courses in ICS and finished all but my Master’s Thesis in Technology and Science Policy.

Contact this candidate