Raffel Systems
Customer Projects
|
Raffel Systems
Customer Projects
|
|
 |
Cashion, Arizona
Produce Grower/Brokerage
Sales & Inventory Management Solution
Client since 10/04
|
Have been working in the produce business for over 15 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.
|
||||||||
 |
Huston, Texas
Telestream Solution
Client since 6/04
|
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 1 million.
|
||||||||
 |
Princeton, New Jersey
Application Development
Client since 5/03
|
Multiforce provides
software to manage company owned fueling sites. Mutiforce has been in
business since 1983. Raffel Systems helped redevelop the main application database software. 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.
|
||||||||
 |
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
|
||||||||
 |
Rocky Mountain Fleet Managers Association
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.
|
||||||||
 |
Transportation
Services/University Motor Pool
Corvallis, OR
Client since 1/02
|
Raffel Systems build a system to manage motor pool rentals. 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)
|
||||||||
 |
Department of
Administration Services (DAS)
Salem, OR
Client since 8/99
|
Implemented and support a system developed
from the experience working with the Arizona Department of Transportation (ADOT),
Equipment Services. The motor pool consists of approximately 4,000 vehicles
assigned to 200 different agencies. Equipment is paid for by the use fee’s
paid by each department. The department of administrative 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.
|
||||||||
|
Invoice System
Phoenix, Arizona
Client since 2/99
|
MD Healthline sells herbal remedies over the
internet. The system created for them process the orders that are entered
into from the WEB site and in house. The system also tracks the affiliate sales and determines the
monthly commissions payable to affiliates.
|
||||||||
 |
Work Order Tracking
System
Phoenix, Arizona
Client since 12/98
|
Developed a
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.
|
||||||||
 |
Equipment Services, Fleet Management
Phoenix, Arizona
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.
|
||||||||
|
Technical Information
Resources
Phoenix, Arizona
Client since 9/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 |
Frantek, Inc.
Electrical Engineering
Tempe, Arizona
Client since 7/95
|
Frantek, Inc. 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
|
||||||||
| Checker/Schucks/Kregan |
Store relocation system
Phoenix, Arizona
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.
|
||||||||
 |
Invoice/Inventory/Accounting System
Phoenix, Arizona
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/Accounting System
Phoenix, Arizona
Client since 3/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.
|
||||||||
 |
Van Arsdale Properties
Billing System
Phoenix, Arizona
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
Tempe, Arizona
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
Phoenix, Arizona
Employed: 8/93 to 7/96
|
Provided accurate monthly reporting on the
banks activities in southwestern Unites States. Developed processes to
download data from the banks mainframe systems. The data was used to on a
monthly basis to drive multi-color charts and graphs used by bank
management. Used to show profitability of the bank by department.
Worked with management to fund a bank wide project to tie all areas together
in one client server tool. The tool would be used for client relationship
development and management reporting.
|
||||||||
 |
Commercial Real Estate
Services
Market Research/Networking
Phoenix, Arizona
Employed: 9/91 to 8/93
|
Lee & Associates Arizona began the same day
I started. A group of eleven commercial real estate agents started a new
real estate franchise and they knew they would need a guy like me. They
needed a computer network, market research and billing systems. I did it.
The office was networked early on. The market research and billing systems
were developed from scratch based on my experience from Grubb & Ellis. The
initial systems were DOS based. After leaving in 8/93, designed new
windows applications and sold them to Lee & Associates as a consultant.
Still have a solid consulting relationship with Lee & Associates and enjoy
doing projects for the company.
|
||||||||
 |
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.
|
||||||||
 Raffel Systems is a A+ rated business.
|
 Raffel Systems is a proud member of Local First Arizona.
|
  |
|
Raffel Systems
Software Development & Consulting Company
8021 N. 9th Avenue
Phoenix, AZ 85021
|
Phil Raffel
602-954-9099
|
 |