Skill Sets [HP3000 ] | IBM Hardware background | Partial Work History]

Software Experience- Windows

Software Product

Experience

Companies

Aspects of S/W used

Other Notes

Years

Level

MS Access

9

8

Masters Inst
PSCU
Solectron
MoSys
Solo Proj

Queries
(Crosstab, Totals, Update, Delete, Select, Append)
Reporting:
(Totals, Complex Grouping, Item numbers)
Forms:
(Triggers, Key combinations, What-If scenarios)
Modules: (VBA)
(DAO, ADO, SQL,ODBC, strings passed, Opening database or query programically, db.execute, updates, deletes, and other query functions this way)

Created a data application from scratch.   Have worked extensively with queries, reports, forms, & modules.

Published reports/queries/forms based on user requests.  Troubleshot problems.   Have understanding of all Aspects listed in the previous column

MS Excel

8

6.5

Informix
Masters Inst
Solectron
Apple Comp
MoSys


Pivot Tables,
Advanced and Filtered Sorts,
Subtotals,
"GoTo" section under "Edit" (includes data fills, selected fills of blank fields, etc),
If, MATCH & INDEX, Aggregates, V&HLookup,
Text to Columns
Many more Logical and some Financial as well.
Macros: (VBA)

Have both improved and created stand alone applications. With the press of a button, was able to make a whole process run to completion.
File Manipulation of regular text files with no formatting possibilites (was not a .crv file). This is to prepare it so it (the file) can be imported into another data source... Dealt with many a badly formatted text files.
Automated manual processes.

Understand how Excel behaves on a Mac compared to a PC when using VBA.

HTML

6

7

Freelance

Tables
Frames
Forms
Images
Styles

 

 Created own web pages integrating all “Aspects” to the left.  One of them can be found at http://www.steric.net, another at Fortune City
 
Been building and adding to these pages the past 4 years.   The “steric.net” site is both Perl and Cold Fusion (2 ODBC connections) enabled, so I am able to develop with both of those platforms.  

VBA

6

6.5

Informix
Masters Inst
PSCU
Solectron
Apple Comp

MoSys

 Stored Procedures, DAO, ADO
db.execute, SQL assigns,

AutoExec,

 Almost every contract I’ve worked on in the past few years include the backing programming languages for the MS products I’ve worked on.    Is the backbone to making applications operate seamlessly.   Also will use it to be a front end for real databases like MS/SQL, Oracle, and mySQL.

PHP 2 5 Solo Projects, Study, Websites. Database Interface, functions. the scripting of choice when having to do any sort of calculation or database calls. Have used this for my last 5 web projects, both volunteer and paying. Can do all database calls and updates using html forms, and can keep the server side from calling other pages to finish processes
mySQL 2 4.5 Solo Projects, Study. all SQL aspets Using this as the db of choice when doing web projects with PHP. All my recent website builds have used this as the database.

Cold Fusion

1+

3

Study,
Own Site

Many of the basic CFML tags and some others

Am self teaching myself this one.  Already understand the basics on how this works, through SQL calls to create nice front end apps from data stored in either Access, Oracle, text files, or MSSQL server.   One of the sites I am constructing on big-doggy.com is CF driven.  Also know that if you can build with this, javascript does not need to be learned.   It does it for you.

SQL 2 5 Masters Inst
MoSys
Used the SQL edit section of Access, also passed straight SQL through
Cold Fusion Updates
 

Dreamweaver

1

3

Study
Solo Projects

 

Nice alternative to using a straight HTML editor.  Makes building web pages easier.  

Fireworks

3

2

Study

 

Built a few .gif files.  Not worked with it much.

VBScript

<1

3.5

Classroom

 

An easier version of VBA and VB.   I like this because you don’t need to define variable types.  

Photoshop

2

1.5

Study, Image Builds, and Brochure Creation

 

Know a few shortcuts.

JavaScript 3 3.5 Study,
Solo Projects
Dates, programming Have incorporated it into my site (www.steric.net)
and other volunteer sites. For decision making and dynamic date strings.

Active X Ctls

<1

1.5

Informix

Changing Views

Just assigned one, to update the processor of the program what step the program was at. Used in the Excel program I wrote.

Java Basics

<1

1

Coursework,

Study

Commands

Took a recent course in java basics and am working on creating my own apps and applets.

XML

<1

1

Coursework,
Study

 

1 day course

           

Hardware, O/S


Platform Experience Companies Aspects Other Info
Years Level
PC 9 7.5 Informix
Masters Inst
Solectron
PSFCU
MoSys

memory/ board swapping, disaster recovery. Hardware of choice. Started building my own systems back at the advent of the 486DX33. Unafraid of looking inside and swapping boards/memory/motherboards, though the results can be unpredictable at times. Only worked on the software side of the PC at the companies listed. All H/W has been on my own system. Have built two other systems.

Apple

1 2.5 Apple C Chooser, running Excel 97 Can't say that I used this system much after the initial Apple II+. The system I used here was a GS3.
           
Windows 9x, ME, XP 10 5 All except AAPL Keyboard shortcuts, msconfig, sysedit, regedit, Device Mgr, and other diagnostics. More of a power user who can do some system administrative duties. Not lost
UNIX/Linux 2 3 EDS, AMAT Operator commands, .
crontabs, security
Understand some basic commands. Edited a few script files in vi.
Doing security work on a volunteer site, using .htaccess and passwords.
           


HP3000 S/W H/W


(I include this system to note how long I've been working in the computer field...)
Platform
Experience
Companies
Notes
Years Level
HP3000 7 4

EDS
HWP
AMAT
GaSonics
3Com (COMS)

  Operator dutes, some spot scheduling. Worked Grave Shift. Responsible for getting production completed. Made some program fixes. Never worked on the hardware end of it. That is what we called HP for to troubleshoot.
Maestro (Unison Corp) 5 3 EDS, HWP, AMAT, COMS   Composer, Arranger. Knew how to set up schedules
NBSPOOL 2 1 COMS   One of a few spooling programs I worked with. Also had limited exposure it's cohort, NETBASE.
MPE 7 3 EDS, AMAT, COMS   O/S for HP3000. Know how to check spooled files, jobs, users on, can cool and warmstart and do system shutdowns.
QEDIT 4 4 COMS   Text file manipulation of different utility programs (putting them together to generate reports)
ADAGER 2 1 COMS, EDS   Knew that this was the dataset compression program that could only be run with no one in any database
QUIZ (Powerhouse) 2 1 COMS   Was part of three programs. This one you could use SQL select commands to look at data in any database. The others were QUICK, and a viewer that I don't remember the name of.
MPEiX (VEESOFT) 5 2 COMS, EDS  

Used this to monitor status of jobs and to manipulate the rank on how much resource each job or print job got.

JOBRSQ 6 3 COMS, EDS   Another monitoring tool that I utilized when batch jobs failed.
           
This is my background in S/W H/W. It just a fleshed out version of my resume. Thanks for looking.
Top

Last Updated:
Dave Nicolai- Webmaster
Copyright 1998 to 2002, DNA Development