4611 Bedford Blvd
Wilmington, Delaware 19803      

Have telnet, will travel

Servicing Delaware, Southern New Jersey, North and Central Maryland and Southeastern Pennsylvania.

NOTABLE PROJECTS by HOOVER COMPUTER SERVICES

     Hoover Computer Services has accomplished many notable projects throughout our history.  Below is a generic summary of some of them.

     Index of Projects:  Click for details or scroll down.

~ First State Accounting ~ Special Project for Printing Company: Solaris File Storage Indexing ~ County Health Departments ~ Large Retail Store with Multiple Locations and Internet Presence ~ Shopping Cart Web Presence for FSA Users ~ Mental Health Facility Billing and Service Tracking System ~ Scanning Documents Linked to Database Records ~ Truck Trailer Tracking Program and Customer  Web Interface ~ Culling names from a Web Published Report for a Mailing List ~ Truck Drivers Log Program ~ Structural Skylight Estimating Project ~ Export Images from Badge Holders Photo Program.

~ County Welfare Office ~ Job Costing System ~ Service Module ~ Support for Abandoned filePro System ~ Credit Card Software Linked to FSA ~ Marina Management System ~ Dry Cleaning System ~ Medical Office System ~ X12 Electronic Billing ~ Tire Store Program ~ Sheriff's Office ID Department

Some projects turn out great ... and others, well could be better.  Some last longer than others.  Most of ours are great!

     We wrote this suite of accounting modules from scratch over the course of twenty years so far, constantly updating and enhancing the system as more and more clients come on board, adding features and functionality on almost a daily basis.  It is a mature, proven system, time tested by a large array of industries.  We have complete control of the programming code, thus allowing us to customize each module for every customer while still maintaining strict GAP accounting principals.
     Our FSA is the base for many of our custom designed projects; we can attach a custom module to it or modify an existing module.

     This company has a huge Sun Solaris Unix storage system which stores millions of graphics files for thousands of completed jobs.  Storage is split between "on line", meaning on the hard drives and "near-line", meaning on a large tape carousel controlled by the Unix server.  Over the years multiple users would store their jobs rather randomly using a "drag and drop" system from MAC clients.  Naming of the job folders was up to each user without a specified naming convention.  Without consistency it was very hard to locate a past job for reprint.  As most jobs were reprinted repeatedly, much time was spent looking over this massive system to find jobs for retrieval.
     Using filePro on the Solaris server, we were able to write code to seek out all the jobs scattered throughout the hard drives and 256 tapes and catalog them in the filePro data base.  Thus we achieved a system whereby a user could simply plug in a job number or a job name and all the files associated with the job would be automatically retrieved wherever it was located and dropped into a specified location for reprint.

County Health Departments

     We wrote a complete billing and statistical system which tracks services rendered by county health departments including mental health and drug & alcohol as well as all other clinical activity and services performed by health departments. It includes HCFA-1500 paper billing, which then evolved to HIPPA regulated X12 electronic billing.  This software had been implemented by three counties and is still used today by two after 20 years in service.  Other features included fiscal planning and budgeting and tracking of expenses for expenditure planning.  Flu shot tracking, on-site dental services, were among other projects performed for these customers.

County Welfare Office

     We have written a client service tracking system for a county welfare office which includes a master file of all people who enter the agency for services and follows them throughout the system, tracking the various services rendered in various departments, thus eliminating duplication of data entry and allowing every department to see what was done in other departments.

     For one large manufacturers representative we integrated our First State Accounting system into a job costing system which tracked all operatinal functions from quotations to order entry to purchase orders and material requisitions for jobs and billing.  It fulfilled AIA billing requirements as well as standard and custom billing.  Material could be ordered and tracked for specific jobs as well as for stock inventory.  An array of reports tells the company the exact status of each job including material deliveries, billing and collections. 

     We wrote a custom service module for a large service company which handled both preventative maintenance agreements as well as normal repair calls.  It tracked the hundreds of different maintenance items that the company performed and calculated exactly how long a PMA call should take, creating a schedule for their dozens of techs to perform their duties when preventative maintenance schedule arose for each customer.  Then, after performance of duties, the system recorded what was done and sorted the billing from the non-billing, automatically creating the billing.  All of these items were posted to the general ledger for a complete analysis of work flow.

Large Retail Store with Multiple Locations and Internet Presence

     Our First State Accounting system runs a large retail operation, beginning with Point-of-Sale entry at multiple registers and multiple locations, all connected to one server at the main store.  The Order Entry module allows back office entry of large bulk orders for shipping and delivery.  A function in Order Entry shows the clerk the entire ordering history of each customer to help ease confusion during order taking, as this store has over 50,000 different items in their inventory.  Searches for items by SKU #, UPC code, item description, and even key word and fuzzy searches help select the right product if no bar code is on the item, or if entering from the back office.
     Purchase orders shows the purchasing agent the exact costs paid previously for every item, showing a browse window of past purchasing history.
     Inventory allows for levels pricing based on quantities and accepts either markup from cost or discounts from list price.  Inventory can be exported to Excel for editing in batch then re-uploaded into the FSA Inventory module.  Transfers of inventory between stores can be requested on-line by each store, then processed by the main store, thus keeping track of inventory flow.

Support for Abandoned filePro System

     A company that had been developing a custom system to control every aspect of their business with an in-house programmer came to us after their programmer left after years of development.  We were able to support and continue development of their system, much to their relief.  Since filePro code is open and modular, it is possible to pass on a legacy system to another person to pick up and support.

     We created our file2Xcart product in order to meet the needs of a large retail store that wanted a web shopping cart presence, but didn't want to spend time maintaining their thousands of  inventory  items duplicated on the website, especially since prices changed frequently and products became discontinued or new products added every day.  Thus we found a way to link the store's FSA inventory directly to the store's website.  They set up and maintain a web structure in FSA and define which products go on which page.  At a press of a button and all the product information gets transferred in a few seconds onto the website, with all fresh data coming from FSA.  No duplication of effort at all.  As prices change in FSA, they change on the website.  We use inexpensive X-cart shopping cart software as the web based server and send data into it from FSA.

     One of our customers needed to have our Point-of-Sale, Order Entry, and Cash Receipts modules interfaced directly to a credit card processing company with no user intervention required and no lengthy waits for dialup modems to connect.  We were able to integrate FSA with Monetra® payment processing software, by Main Street Softworks and now that feature has been added to FSA's Order Entry and POS modules.
     We have also done work with another customer linking filePro programs to Icverify®, another payment processing company.

     We  wrote a complete marina management system which, in addition to standard accounting functions (FSA based), is able to record work orders, track boats, docks, slips, and price all services including land storage, dockage, and dozens of other services.   There is a transient boaters function, a retail store/ gift shop function, and other features that make it a complete marina package.

     We wrote a complete dry cleaning system which logged in clothes customers dropped off, tracked them through the processing plant and back to the store again, printed tags, printed invoices, and kept track of accounts receivable.  It also gave valuable reports to the owner on what types of items he processed.  Included was a interface to a barcode reader so that garments were always tracked by scanning in and out.  This module was linked to our standard FSA system.

     Over the course of a decade we developed a total system for a large mental health facility with multiple locations.  This system includes our FSA accounting as the core with specific modules developed for patients/clients and all their visit data.  Billing includes private pay, Medicaid, Medicare and Insurance in both paper and electronic formats.  It is all HIPPA compliant.   Over the years, this system has been able to be adjusted quickly to the changing rules and regulations of medical billing, keeping cash flow at a maximum while other facilities on inferior systems were forced to operate in the red due to their inability to adjust to government red tape.  

  We have been able to assist with customers of Virtual Software System's Medical Office System, the filePro based doctor's office software.  We have rendered local SCO Unix and Linux support and server sales to these V.S.S. customers.
     We have also linked Medical Office System to our FSA accounting system back end.

     For our county billing we were required to comply with HIPPA regulations, and one of the requirements was adherence to X12 electronic billing in 835 and 820 formats.  Thus, we wrote a "black box" X12 program that will work with any X12  requirements including purchase orders, etc.
     For this project we were able to upload client billings and download adjudication results.

     We wrote a custom program for a tire store to track new and used tires by serial number, size, type, and manufacturer, including tracking tire tread depth in used tires.  This module was linked to our standard FSA system.

     We completed a project which links scanners to a filePro based record.  While on a record in a database (such as Order Entry) you can press a button which will activate an attached scanner.  The scanned document (perhaps a hand written completed work ticket) will be stored on the system with associations to the record you are viewing with no other user input needed.  Then, to later view or print out the scanned document, pull up the record you were on and press a key.

     We helped rewrite a data base that county sheriffs use to help identify arrested individuals based on physical characteristics and demographics.  This is a SCO Unix and filePro based application.

Truck Trailer Tracking Program and Customer  Web Interface

     We developed a complete package for a company that buys, sells, and leases truck trailers.  This system is attached to our core FSA accounting package. Trailers are classified and cataloged in the database, as are customers and their various lease agreements.  The system tracks the trailers as they are bought, sold, or leased.  It automatically generates invoices based on the lease agreement.  Revenues and expenses are posted to FSA.  The system keeps track of maintenance and associated expenses in the form of industry standard ATA codes.  It also emails clients when FCC inspections are due.
     The system posts all trailer and maintenance information up to a web site nightly so that customers can log in and see any and all information pertinent to the trailers that they are leasing.

     One of our customers was printing out federally issued lists of names that came out weekly and manually copying the names into their mailing list database.  This was a full time job for one person and they were months behind.
     We created a process that would take all of the lists, which, by the way, were not formatted, but in a random order throughout the report, and pulled the names and addresses, contacts and phone number, plus other information off of the lists and formatted them properly in their database.
     The customer was not only able to catch up on their name gathering, but did so with more accurate results and turned a full time job into a five minute a day task.

     Throughout the United States, all truck drivers must submit driving logs showing time driven vs. time off, time in the sleeper berth, and time off-duty.  This is a federal requirement.  The rules for driving are extensive and tricky to interpret and a driver can get a violation very easily if he drives too much without the proper breaks.  This program allows easy input of truck driver logs and determines if the driver drove legally or triggered one of the many types of violations of the FCC rules.

     We wrote an application to calculate the costs of large structural skylights.  A user would enter dimensions obtained from blue print takeoffs and specify glazing and finish, and the program would calculate the selling cost of the skylight.  It would advise on structural members size to use, based on span, loading requirements, local building codes and section modulus of the member used on the span. 

     A large corporation needed to export employee photos out of their badge holders software, but the utility provided did not work and support was slim.  We figured out the technique to export the thousands of photos and wrote a script to automate the procedure.