Custom
Component Development |
RJ
Systems Inc.
Designed, coded, installed and supported |
1/97
- Present
Visual Basic 6.0 |
|
Created
and supported a number of ActiveX / COM components for use in numerous
applications. Some examples are Address, Phone, Note, Media, Alert
.ocx's. Additionally, Rate, Range and Point To Point pricing management
.ocx's were developmend. Additional COM objects include CheckList,
a data drived checklist manager, VisualizeIt! a time based object
visualization tool and LockIt!, a software license control component. |
OrganizeIt! |
RJ
Systems Inc.
Designed, coded, installed and supported |
1/97
- Present
Visual Basic 6.0 |
|
A system used to
manage the gathering, management and publication of application
specifications. Provides user configurable Scenarios in which
to organize the data.
|
WinLimo |
Surfside
Software
Designed, coded, installed and supported |
10/99
- 12/00
Visual Basic 6.0 |
|
A system used to
manage the scheduling and billing operation of a limosine, black
car or shuttle service. Contained several innovative design ideas
such as note, alert and media processing with custom .ocx's in
a data driven data model.
|
Real
Estate Foreclosure Management |
Meridian
Realty
Designed, coded, installed and supported |
10/98
- Present
Visual Basic 6.0 |
|
A system used to manage over 8,000 foreclosure
properties from receipt to sale. The system supports 50 concurrent
users with Access as the database engine.
|
Requirements
Gathering |
Babcock
& Brown
Managed the Requirements process |
2/98
- 8/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.
|
Cost
of Funds |
Federal
Home Loan Bank of California
Designed, coded |
12/97
- 8/98
Excel VBA |
|
Used by a large bank to collect financial
indicators and produce cost of funds indices for various financial
instruments over diverse periods.
|
Parts
Catalog |
Network
Tools, Inc.
Designed, coded, installed and supported |
12/96
- 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.
|
Time
Card Processing |
DeVries
Data Systems
Designed, coded, installed and supported |
2/97
- 4/97
Visual Basic 5.0 |
|
Used to manage employee time records for
small manufacturing environments. Time is entered using bar codes
and a scanner. Provided interfaces to manage the employee and
time information as well as print bar codes and time documents.
|
Server
Configuration |
Hewlett
Packard
Designed, coded |
10/96
- 2/97
Visual Basic 5.0 |
|
Part of a team developing a tool used to
configure a server for sale based on available components with
configuration validation. Responsible for screen capture and printing
using the WinAPI. Also responsible for daily builds and source
code management for a team deployed across the US.
|
Financial
Modeling / Forecasting |
Applied
Materials
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.
|
Literature
/ FAX Fulfillment |
Intel
Designed, coded, installed and supported |
8/93
- 2/96
Visual Basic 3.0 / 4.0 |
|
On-line system with over 200 users. Links
DOS and Windows client and lead tracking systems with a common
interface for ordering of literature (over 1,000 items) and FAXBack
documents (over 1,200 documents) while on the phone with the customer.
Allows review on all orders processed with minute by minute feedback
on order fulfillment status. Implementation was attributed with
a 20% increase in call volume for users of the system. This system
was upsized from MS Access to MS SQL Server.
|
Lead
Scoring / Assigning / Disposition |
Intel
Designed, coded, installed and supported |
8/93
- 2/96
Visual Basic 3.0 / 4.0 |
|
On-line system to process inbound lead information
received from outside vendors. Scores the lead based on table
driven criteria, and assigns the lead to the appropriate individual
/ team based on additional table driven criteria. This system
was upsized from MS Access to MS SQL Server.
|
Process
Server Management |
Intel
Designed, coded, installed and supported |
8/93
- 2/96
Visual Basic 3.0 / 4.0 |
|
Manages a process server. Polls servers on
the WAN to manage in and out bound orders and Faxes. Manages both
DOS and windows applications running unattended at specified times.
This system was upsized from MS Access to MS SQL Server.
|
FAX
Server Management |
Intel
Designed, coded, installed and supported |
8/93
- 2/96
Visual Basic 3.0 |
|
Manages orders for outbound FAX library of
over 1,000 FAX documents ordered from various OLTP systems. Updates
history files as to disposition of FAX requests on a real-time
basis. This system was upsized from MS Access to MS SQL Server.
|
Distributed
Data Base Support |
Intel
Designed, coded, installed and supported |
8/93
- 2/96
Visual Basic 3.0 |
|
Manages information flow for remote sales
force. Creates outbound and processes inbound files to keep sales
force current on product availability.
|
Quote
Management |
ALT
Designed, coded, installed and supported |
6/95
- 12/95
Visual Basic 3.0 |
|
Manages Quote processing for a laser cutting
operation. Manages information from initial contact through job
shipment. Full support table front end.
|
On-Line
Mail-Order Processing |
Yesterday's
Art
Designed, coded, installed and supported |
7/92
- 7/93
Visual Basic 3.0 |
|
Mail order on-line sales with a product line
of around 250 part numbers with a customer base of over 12,000.
Managed bulk mail preparation, order processing , literature fulfillment,
history reporting and state and federal tax reporting.
|
Inventory |
Larsen
Electronics, Inc.
Designed, coded, installed and supported |
2/90
- 6/92
NPL Basic |
|
Inventory management system for an electronics manufacturer with
about 1,000 part numbers. Tracks inventory at plant as well as
5 remote sites.
|
Manufacturing |
Larsen
Electronics, Inc
Supported existing system, enhanced |
2/90
- 6/92
NPL Basic |
|
Complete MIS system for a manufacturing operation with approximately
100 employees at $13 million per year in revenue. Handled complete
flow from receipt of order, through manufacturing to financial
statements.
|
Accounting
- GL AR AP IV DA PR |
Anderton
& Associates, Inc.
Designed, coded, installed and supported |
7/76
- 12/90
NPL Basic |
|
Complete accounting
system that I wrote and marketed for several years. Contains over
300,000 lines of code. Used by several of the "Big 8"
(back then) accounting firms for Client Management. The system is
still in use by several clients today. Pioneered MICR encoded check
printing. |