| Web
Site, e-Commerce, Digital Imaging |
RJ
Systems Inc.
Designed, installed and trained |
07/01
- Present
Web Design Tools |
| Created
several web sites for various clients using a combination
of Adobe Photoshop for digital imaging, Macromedia Dreamweaver
for the sites, Macromedia Fireworks for buttons, Macromedia
Flash for animations and Miva for an online store that handles
inventory, customers, orders and credit card gateways. |
|
| |
| Custom
ActiveX Components |
RJ
Systems Inc.
Designed and coded |
12/00
- 06/01
Visual Basic 6.0 |
| Created
several custom ActiveX components for integration into other
applications including TripMaster, a shuttle scheduling system.
One ActiveX component managed software licensing and locking
an application if the license expired. Also developed an ActiveX
component for creation and management of staff scheduling. Additionally
developed a tool for management of SmartNote templates. |
|
|
| WinLimo |
Monetech
Designed and coded |
10/00
- 11/00
Visual Basic 6.0 |
| A
system used to manage the scheduling and billing operation
of a limousine, black car or shuttle service. Contained several
innovative design ideas such as notes, alerts and media processing
with custom .ocx's in a data driven data model. |
|
|
| Custom
Reports |
ERG
Designed, coded, installed and supported |
10/99
- 9/00
Actuate & VBA |
| Used
Actuate to create custom reports for various clients. This
sometimes required the creation of ActiveX components in VB
and integration of VBA and Seibel. |
|
|
| Custom
Controls & Features |
RJ
Systems Inc.
Designed and coded |
8/99
- 9/99
Visual Basic 6.0 |
| Created
several custom .ocx's to allow multiple addresses, phones,
notes, media and alerts to be attached to a parent record.
Designed some special features to restrict specific fields
with a User selectable Mask (Mask of Codes) and automatically
increment specific portions of specific fields based on User
selectable preferences (Auto Incrementing). |
|
| |
| Trip
Management |
MTL
Designed and coded |
12/98
- 7/99
Visual Basic 6.0 |
| Part
of the development team to create Trip management tools for
a fleet of over the road trucks. I Developed software using
third party components and SQL Server to produce government
reports on trips. |
|
| |
| Bar
Code Interface |
MCI
Designed, coded and installed |
7/98
- 8/98
Visual Basic 5.0 |
| Created
an Active X component that allowed the Users to select desired
attachments for mailings and interface with two separate applications.
That information was translated into a bar code, which was
printed on the cover letter and read by the mail management
system to assemble the packet to be mailed to the customer.
|
|
| |
| Requirements
Gathering |
Babcock
& Brown
Managed the Requirements process |
3/98
- 7/98
OrganizeIt! |
| I
was responsible for the requirements gathering and documentation
process of a sophisticated financial application. I used our
OrganizeIt! tool to collect and distribute the information.
The process included organizing and conducting meetings with
users and developers to define the needs. |
|
| |
| Invoice
& Project Tracking |
Bay
View Bank
Designed, coded, installed and supported |
12/97
- 9/98
Visual Basic 5.0 |
| An
application to do cost allocation of projects managed by the
bank, with full reporting capability. |
|
| |
| Report
Automation |
Bank
of America
Designed, coded, installed and supported |
9/97
- 10/97
VBA in Excel |
| Used
VBA in Excel to communicate with "Business Objects"
data warehouse to create a spreadsheet. Allowed the user to
select parameters, passed the information to "Business
Objects" and retrieved the query results into an Excel
workbook. It then manipulated the data in the spreadsheet
and produced a report. |
|
| |
| Quote
Creation |
Network
Tools Inc.
Designed, coded, installed and supported |
2/97
- 8/97
Visual Basic 5.0 |
| Created
an Active X component that managed the movement of Quotes
(multi-level object hierarchy) between databases while maintaining
version level compatibility. |
|
| |
| Quote
Compare |
Network
Tools Inc.
Designed, coded, installed and supported |
2/97
- 8/97
Visual Basic 5.0 |
| Allowed
the user to select two Quotes and displayed the differences
between them. An optional printed report was available. |
|
| |
| Find
Duplicate Parts |
Network
Tools Inc.
Designed, coded, installed and supported |
2/97
- 8/97
Visual Basic 5.0 |
| A
utility which scanned a multi-level Part file (bill of materials)
to locate duplicate Parts. Allowed consolidation of duplicate
part records to insure that child components were not orphaned. |
|
| |
| Un-Replicate
Database |
Network
Tools Inc.
Designed, coded, installed and supported |
2/97
- 8/97
Visual Basic 5.0 |
| When
using the database replication features of Access, there is
no simple method to un-replicate a database. This process
requires a complex series of manual steps. The Un-Replicate
Database tool was created to automate this complex process.
The application created a new non-replicated database, copied
all Tables, Queries, Forms, Reports, Macros, Modules, Relationships,
Menus, Toolbars and data from the replicated Access database
to the non-replicated Access database. |
|
| |
| Parts
Catalog |
Network
Tools Inc.
Co-Designed and coded |
2/97
- 8/97
Visual Basic 5.0 |
| A
system used to maintain a multi level parts catalog for many
high tech component manufacturers. Provided an Explorer interface
to ease navigation of the parts hierarchy. The catalog uses
an underlying technology, Screens On The Fly, to dynamically
create the UI on the fly as the user navigates the object
model. |
|
| |
| Data
Import |
Hewlett
Packard
Designed, coded, installed and supported |
10/96
- 2/97
Visual Basic 4.0 |
| Imports
text files in various formats from different vendors into
a SQL server (data warehouse) database. Extensive error trapping
and data correction to deal with corrupt text files and data.
The application handled receiving header/detail sets of data,
writing an exception file with all records that could not
be processed and a log file to document the entire process. |
|
| |
| Financial
Modeling / Forecasting |
Applied
Materials
Co-Designed, coded, installed and supported |
2/96
- 10/96
Visual Basic 4.0 |
| A
system deployed world wide to allow forecasting of sales.
This consisted of two components. The first allows for creation
and maintenance of all sales orders, which uses a complex
multi-level data structure in several currencies. It allows
selection of data from a detailed criteria definition screen
that developed optimized SQL on the fly to retrieve the requested
data. This tool is connected to an Oracle back end. The second
component was co-developed to allow users to select data from
the data warehouse and create reports, spreadsheets, database
tables or text files on the fly. This tool can attach to any
datasource and build an internal structure from which the
user can select fields and apply attributes to the selections.
The results of the users choices are directed to Excel via
OLE automation, Access or a text file. |
|
| |
| Document
Control |
Intel
Designed, coded, installed and supported |
2/95
- 2/96
Visual Basic 3.0 |
| Check
in and out documents keeping a history of document changes.
Maintain, print and export information about the documents.
Notify document owners of status changes. Ability to have
secured documents with restricted login rights to view them. |
|
| |
| Pre-Payroll
System |
Chase
Manufacturing Co.
Designed, coded, installed and supported |
7/94
- 6/95
Access 2.0 |
| Daily
import time card hours from the Simplex Time Clock system,
allowing user input of daily work cards with easy reconciliation
of hours. Perform complex pay calculations based on Union
contract of production pay versus hourly pay, shift differentials
and piecework. Export weekly file for Ceridian Payroll Company
to import. |
|
| |
| Construction
Job Tracking |
TDC-MITS
Designed, coded, installed and supported |
9/94
- 11/94
Visual Basic 3.0 |
| Inventory
and track movement of equipment and supplies from suppliers
to job sites and from one job site to another including partial
shipments, for a large construction project. |
|
| |
| Report
Writer |
Intel
Designed, coded, installed and supported |
7/94
- 9/94
Visual Basic 3.0 |
| User
defined selection criteria from various tables to produce
SQL based queries with drill-down, graph and export capability. |
|
| |
| Project
Consultant |
Nike
Designed |
7/94
- 11/94
Visual Basic 3.0 |
| I
designed and documented their new system and data model. |
|
| |
| Project
Consultant |
Nor
Pac
Designed |
7/94
- 11/94
Visual Basic 3.0 |
| I
designed and documented their new system and data model. |
|
| |
| Project
Consultant |
Nu-Vision
Designed |
7/94
- 11/94
Visual Basic 3.0 |
| I
designed and documented their new system and data model. |
|
| |
| Project
Consultant |
Tualatin
Valley Fire & Rescue
Designed |
7/94
- 11/94
Visual Basic 3.0 |
| I
designed and documented their new system and data model. |
|
| |
| Upgrade
Guide |
Intel
Designed, coded, installed and supported |
11/93
- 7/94
Visual Basic 3.0 |
| A
multi user on-line system for customer support staff at Intel,
to track CPU processor upgrades, recommendations, technical
notes, revisions, work in process, installation and manufacturers
information. Interface with other systems to share data. |
|
| |
| Technical
Programmer |
The
Laughlin Group of Companies
Problem Solver |
9/92
- 11/93
|
| Assist
two lead programmers, one to keep the legacy system alive
in PICK, the other to help with hardware problems and research
a new system to be purchased. I was also in charge of all
training in WordPerfect and Quattro Pro. |
|
| |
| Electronic
Clip Art |
AJ
Graphics
Owner |
7/92
- 8/93
|
| I
owned and ran half the business, creating clip art, marketing,
selling, order taking and shipping product. |
|
| |
| Credit
Tracking |
Larsen
Electronics Inc.
Designed, coded, installed and supported |
5/90
- 6/92
WANG Basic |
| Tracks
credit bureau reports on personal and business "dead
beats" to eliminate paper files in excess of 10,000 documents.
Allows instant access and cross-referencing for credit managers
and staff while on the phone processing credit applications. |
|
| |
| Manufacturing
- OE IN PO BM CS |
Larsen
Electronics Inc.
Designed, coded, installed and supported |
5/90
- 6/92
WANG Basic |
| Complete
Order Entry, Inventory, Purchase Order, Bill of Materials
and Contract Sales systems for a manufacturing operation with
approximately 100 employees. |
|
| |
| Medical
- PC EF |
Medical
Data Systems
Coded |
1/90
- 4/90
WANG Basic |
| Provided
more than 50 clients with updates to the Paper Claims and
Electronic Forms for their Accounts Receivable system. |
|
| |
| Accounting
- GL AR AP BM IN |
Larsen
Electronics Inc.
Designed, coded, installed and supported |
11/88
- 12/89
WANG Basic |
| Complete
accounting system, including General Ledger, Accounts Receivable,
Accounts Payable, Bill of Materials and Inventory that I wrote
and supported for several years. |
|
| |
| Accounting
- Billing PC EF |
CyCare
Systems
Designed, coded, installed and supported |
3/85
- 10/88
WANG Basic |
| Provided
more than 350 clients with updates to the Billing, Paper Claims
and Electronic Forms for their Accounts Receivable system. |
|
| |
| Accounting
- GL AR AP DA |
J.
Thayer Co.
Designed, coded, installed and supported |
1/84
- 3/85
WANG Basic |
| Complete
accounting system, including General Ledger, Accounts Receivable,
Accounts Payable and Depreciable Assets that I wrote and supported
for several years. |
|
| |
| Accounting
- GL AR AP DA |
Butcher,
Shook & Assoc.
Designed, coded, installed and supported |
3/82
- 1/84
WANG Basic |
|
Data entry operator, computer operator and programmer.
I wrote their Depreciable Assets system.
|
|
