|
Client:
Platform:
Project:
|
Commercial Bank
Visual Interdev, FrontPage, Access, Active Server Pages, ActiveX Data
Objects
Web site for enrolling customers for electronic banking servicesDeveloped an online banking enrollment
application to sign up internet
customers on a secure site. Cross-browser support and both client-side and
server-side data validation routines were developed to maximize integrity
of input data. Validated data is
committed in real-time to an Access database and forwarded via
email to the applicant and to Customer Service
Representatives.
A separate back office
system was developed to transfer new enrollments through several
firewalls via XML into a master database for mail merge
acknowledgements and subsequent transfer into the electronic
banking system.
|
|
Client:
Platform:
Project:
|
Channel
Retailer
Visual Interdev and Internet Information Server, MS
Access 95, ODBC
Web site for order tracking by customer; companion
secured extranet for
performing database maintenanceDeveloped a web user interface to a customer
order tracking database which provided order status and
delivery information to a major contract customer over
the internet. A companion secured web site provided
access to the database for additions and changes.
|
|
Client:
Platform:
Project:
|
Channel Retailer
Visual Basic, MS Access 95
EDI (electronic data interchange) and Point-of-Sale integration
Programming to transfer
sales and inventory data from a commercial point-of-sale
program into an EDI transaction set for transmission
through the ADVANTIS network. An abstract layer was
established between the code and the FoxPro inventory
database in the form of an Access query to select and
transform the data. This provided a very simple method
for handling a planned change to a btrieve based Point of
Sale system. The Access query was re-attached to the
btrieve data source, and no change at all was needed for
the Visual Basic EDI data translator code.
|
|
Client:
Platform:
Project:
|
Channel Retailer
MS Access 95 in Access BASIC
Custom Quote, Sales Order, and Assembly Ticket system
Automated the import of
distributor's inventory database in dbase format with
60,000 SKUs. Access BASIC routines used DDE to generate
email message to the distributor auto-response system to
trigger weekly transmission of the inventory. When an
updated file was received, handler programs notified the
administrator to schedule data import. Upon entry to the
system, sales person was notified that inventory updates
had occurred and they could print a report of quotes with
item cost changes that may require re-pricing for the
customer.
The main sales person
routines provided real-time quote generation using a
shopping basket methodology. While speaking with a
prospect over the phone, the sales rep could search for
items, quote prices from a table of pre-calculated
margins, check stock status for multiple warehouses,
advise customer of special circumstances such as
constraints and non-returnable items, and add the item to
the shopping basket.
After adding all items,
the quote could be printed and optionally a FAX cover or
envelope could be selected. Quotes could be converted to
sales orders upon proposal acceptance, and open orders
were tracked through receipt of goods, assembly, and
delivery.
|
|
Client:
Platform:
Project:
|
Chemical Manufacturer
MS Access 2.0 in Access BASIC
Chemical Inventory, Receipts, Batch Consumption, Efficiency, Cost system
Developed a database
application to track chemical inventory and usage from
receipt through delivery. An interesting aspect of the
project was a self-modifying design of the storage vessel
calculation routines. Process and storage vessels used
geometric formulas supplied by an engineer to calculate
the weight of the tank contents. The system was designed
to store the formula as data in the database and then
automatically define a program function to implement the
formula. The design made it easy for engineers to add and
change vessel equations, and obtain the weight of tank
contents for inventory calculations without calling in a
programmer for every change. This feature of the system
was used successfully to bring up an entirely new vessel
in only 3 hours rather than several days that would
otherwise have been required to code new logic for input
routines, reports, and testing.
Other unique elements of
the system involved programming for handling materials
that were received in pipelines, tank trucks, and rail
cars. Chemicals had to be accounted for in the cost
system not only in terms of weight, but by concentration
of solutions, and percentage of water for solids.
|
|
Client:
Platform:
Project:
|
Automotive Parts Manufacturer
MS Access 2.0 in Access macros
Union Payroll Integration Developed
a union payroll front-end to Great Plains Accounting
payroll. The payroll module did not resolve multiple pay
rates per period, shift differentials, or temporary
re-assignments in departments or job codes. The
integrated logic attached an Access database to the Great
Plains btrieve tables for lookup of the assigned
employee/department/shift/job/rate values. The payroll
clerk could generate a default batch based on the
standard employee assignements and then override specific
transactions in the case of temporary re-assignments on
the shop floor. The resulting transaction set was
imported into Great Plains through the Import Manager
module for batch processing, check printing, and
accumulation for W2 forms..
|
|
Client:
Platform:
Project:
|
Automotive Parts Manufacturer
MS Access 2.0 in Access BASIC
Order Entry / Shipping / Accounts Receivable integration
Developed an Order Entry
System with unit pricing resolved for standard catalog
price, customer discount, volume discount, and customer
quoted price methods. The system produced production
scheduling and shipping documents and reports
automatically upon entry by sales clersk. For
out-of-stock conditions backorders were produced based on
shipping/production clerk directions. Shipped orders were
transferred daily into Great Plains A/R for posting to
customer accounts.
|
|
Client:
Platform:
Project:
|
Automotive Parts Manufacturer
MS Access 2.0 in Access BASIC
Shop Floor Production Order Release system
Developed a custom system
to schedule production and track standard order releases
for die cut parts purchased by Ford, GM, and Chrysler.
|
|
Client:
Platform:
Project:
|
Welding and Truck Body Repair Shop
MS Access 2.0 in Access BASIC
Parts Inventory and Work Order system
Developed a system to keep
parts inventory, receipts, and cost data. The work order
system printed shop orders and relieved inventory for
items used in the repairs. A repair and maintenance log
was kept for company owned vehicles. A direct pay sales
tax report calculated state tax remittances on taxable
purchases.
|
|
Client:
Platform:
Project:
|
Fraternal Organization
Q&A and Turbo C++ (DOS based)
Membership Management and Lock Box Dues Accounting system
Developed a system to
manage member information and track dues history. Printed
dues notices and payment receipts.
|
|
Client:
Platform:
Project:
|
Medical Laboratory Service
IBM BASIC compiler (DOS based)
Automated Data Collection, Storage, and Distribution system
The client's former method
of receiving test results from the testing laboratory was
via ascii terminal login to a unix system and requesting
reports be printed to a local attached printer. Reports
were received in order of test completion by the lab
rather than by doctor or hospital. This resulted in
hardcopies having to be bursted, hand sorted and manually
distributed by courier resulting in delayed delivery to
outlying facilities. Many requests from doctors for
results reporting over the phone consumed tremendous
customer service resources.
No storage and retrieval
was possible, only printed copies were received, and were
very weakly formatted resulting in protracted time
required for doctors to interpret the reports.
Additionally, no indicator showed which test results of a
panel were out of range, so the doctors had to visually
compare each test result to the normals range and assess
the result. Daily preliminary reports for cultures that
required several days to complete were not culled out
from hardcopies, so doctors spent an inordinate amount of
time reviewing reports that were not final.
A system was developed for
automated login and download of the report data to disk
using a pre-determined dialog much like a human operator.
A program then parsed the transmitted data and stored
patient information and test results in discreet fields
and records within a database.
Report programs then
provided a strongly formatted columnar report for final
completed panels with the addition of interpretation aids
that denoted out-of-range results. Additional programs
sorted the tests by doctor/hospital destination and
either printed test reports for timely manual
distribution or transmitted reports in batches to modem
attached printers at outlying hospital locations.
|