Greer Farms

Cashion, Arizona

Produce Grower/Brokerage

Sales & Inventory Management Solution

Client since 10/04

Have been working in the produce business for over 10 years servicing long time client Aztec Herb & Specialty Company.  With my experience and knowledge Greer Farms opted to have me develop a custom application for their business rather than buying a competitive off the shelf application.  Developed twice the solution at half the cost. 

US Bank Company, Voyager Fleet Systems

Huston, Texas

Telestream Solution

Client since 6/04

US Bank Company is a major player in the banking industry.  Raffel Systems developed Telestreamä for the Voyager Fleet department of US Bank.  The application processes fuel and maintenance fees for major fleets within the General Service Administration of the Federal Government.  This includes Postal, Navy and National park light fleet equipment.  This has been a very interesting and on going project.  Would look forward to discussing the scope and players in this project.  Current monthly transaction volume is upwards of 10 million. 

Multiforce Systems Corporation

Princeton, New Jersey

Application Re-Development

Client since 5/03

Multiforce is a major player in the large fleet fuel controller business.  Basically they provide software to manage company owned fueling sites.  Mutiforce has been in the business since 1983 and the main controller software needed modernization.  Raffel Systems was contracted to build a new modern application.  The project has been a resounding success and has attributed to a successful marketing push in 2004 with a 50% increase in business over the prior year.  

Clean Energy, Inc.

Seal Beach, California

Fuel Contoler Integration

Client since 2/03

Clean Energy is a vendor of Compressed Natural Gas (CNG).  They have roughly 1,000 fueling sites through out the southwestern United States.  The work performed involved integrating data from different fuel systems into one master system.  Allows nightly polling of all company sites for timely information the next day.  

Rock Mountain Fleet Managers Association (RMFMA)

Phoenix, Arizona

Invoice System

Client since 2/02

The RMFMA consists of over 500 members.  This is a group of fleet management professionals that meet semi-annually to discuss the latest development in the profession of fleet management.  The system developed for RMFMA automates the process of billing and development of rosters for up coming events. 

Oregon State University (OSU)

Transportation Services/University Motor Pool

Client since 1/02

 The motor pool consists of approximately 450 vehicles assigned to 80 different agencies.  Equipment is paid by the use of the equipment by department and federal grants/programs.  Transportation services facilitates the fueling, maintenance and disposition of equipment to provide for a more economically advantaged use of state funds.  The system provided facilitates the monthly billing and produces information to show costs per mile for comparison to private providers (Enterprise, National and Budget car rental)

State of Oregon

Department of Administration Services

State Motor Pool

Client since 8/99

MD Healthline (mdhealthline.com)

Invoice System

Phoenix, Arizona

Client since 2/99

Resource Recovery Techniques of Arizona (RRTA)

Work Order Tracking System

Client since 12/98

Developed a waste tracking system specifically to how RRTA does business.  Recently finished new upgrades to help with how generators are profiled.  This business is not in the cleanest line of work but it does seem profitable.  Their main business is treating liquid and semi-solid waste.  Treatment can range from old grease to toxic waste requiring special handling.  For example the spent chemicals from the chrome platting processes.  The system tracks the type of waste, how it should be treated and assigns cost based on volume and type.  The generators (clients) are handed an invoice as the material is offloaded. 

Arizona Department of Transportation

Equipment Services

Fleet Management

Client since 12/96

 The initial phase of the project was to convert a DOS based Fleet Management system.  It was determined the current vendor was not capable to create a viable application.  A new project was started to create a new application for the ground up for the 10,000+ equipment units.  My responsibility was to work with fleet personnel to create a working model within a year.  A prototype system was created in 6 months.  The conversion from the DOS based fleet management system to the newly created system was completed within the year.  The new system was a client server system using SQL Server and Visual Basic as the client.   The new system was more intuitive and provided a platform to develop new modules that were inconceivable in the past.  The current version of the system is currently being marketed by a spin off company.

 Arizona Department of Transportation

Technical Information Resources

HEAT Conversion

Project started 9/96 completed 11/96

The overall objective of the project was to convert an older version of software into the latest version.  The system is a client server application serving 250 users.  The conversion process required converting prior version data with new type codes and redirecting data to fields with differing data types.  The original version used an Oracle data server.  The latest version was to be installed using SQL Server as the data server.  An automated data conversion process was created using Visual Basic to convert the existing data into a format that could be loaded into the new version.  The entire process was automated to make for a seamless conversion process that was run over a weekend. 

FRANTEK

Design, Engineering, Excellence

Frantek, Inc. 

Electrical Engineering

Client since 7/95

Frantek is a vendor of Qwest (formerly US West).  Frantek provides electrical engineering services for new phone cabling and manages installations.  The system created for them tracks vendor’s data on all projects.  Vendors log time by remotely logging data into a SQL data server. 

NORTHERN AUTOMOTIVE

Checker/Schucks/

Kregan

Northern Automotive

Arizona Corporation

Store relocation system

Project started 4/96 completed 9/96

 Northern Automotive is the holding company for Checker, Schucks and Kregan auto parts.  They are in the business of selling auto parts at the retail level.  The company currently owns over 1,300 stores in the west coast states.  The company is an expansion mode and is attempting to open 100 new stores a year.  Northern Automotive has four departments responsible to make this happen:  Market Research, Real Estate, Construction and Legal.  Market research is responsible for finding the best places to put stores.  Real Estate has responsibility to find the best deals on land and lease rates.  Construction is responsible for to building stores in a timely cost effective manner.  Legal makes sure everyone does the right thing.  The problem: the entire process was tracked on a shared excel spreadsheet.  Information was not available in a timely manner and things were missed.  My responsibility was to create a system to facilitate the distribution of retail stores in the best possible markets with the least cost to the company.  Within four months a working system was developed to facilitate the process.

AZTEC Herb & Specialty Company

Invoice/Inventory/Accounting System

Client since 3/94

 Developed an automated accounting system specific to the produce industry.  This project can be considered a partner client.  The inventory control and ability to set costs based on supply have made for a very successful business.  When I began working with AZTEC Herbs they were working out of their house.  They now own three farms and a distribution center in Tempe.  My systems have been keeping pace with them every step of the way.  From the system on one PC to the distributed systems that exists today, the efficiency improves as sales increase.

Lindberg & Associates Interior Design

Invoice/Inventory/Accounting

Client since 1/94

Developed an automated accounting system specifically for the interior design industry.  This has been a long-term client.  Have been working with them to automate just about every facet of the business.  It would seem there is always something new to make more streamlined.  The latest project was the development of a system to track paint colors.  This is very important to a developer of new track housing.  The system is set up with a master paint ledged (set by the housing developer), which keeps the designer within the proper scheme.  This also helps eliminate the possibility of a house being painted with the wrong paint colors.  It is amazing how wrong things can get if someone slips up on the paint codes. 

The Restaurant Connection

Van Arsdale Properties

Billing System

Project started 10/94 completed 10/95

Developed a lease management system around the needs of the restaurant industry.  Allows users the ability to enter all pertinent information into the database and produce the necessary lease documentation and bookkeeping reports. 

Biomechanics Research & Consulting

Invoice System

Client since 7/93

Developed an automated case tracking/invoicing system.  All facets of case research are automatically tied to a billing system.  Effect:  Engineers spend more time engineering. 

First Interstate

Bank

First Interstate Bank

Assistant Vice President

MIS/Systems Administration

Employed:  8/93 to 7/96

Lee & Associates

Commercial Real Estate Services

Phoenix, Arizona

Market Research/Networking

Employed:  9/91 to 8/93

Client since 8/93

International Business Machines (IBM)

Phoenix, Arizona

Employed:  1/91 to 12/91

Responsible for developing  marketing strategies and awareness for educational computer sales.  Was top sales representative for the collegiate sales program.  The program offered sales and computer training by IBM.