"Traditional" Client Server Program Listing.
| Program | Year | Language | Database | Description |
| 2006 | Delphi 7.0 | MS SQL 2000/Access 2000 | Used within a Membership Based club, this system uses Magnetic Stripe Card Readers to read Drivers License and Credit Cards for membership access to different club facilities as well as for charging and check out. This system is “skinable” with 11 different skins included in the base system. Additionally, this system has been packaged and released as shareware. |
|
| 2005 & 2006 | Delphi 7.0 | MS SQL 2000/Access 2000 | This system was designed for a non-profit abused children’s adoption agency. The primary purpose is to track the multiple pages of data that is associated with the placement of children within foster families. One of the Unique features in this system is the Data Miner and Reporting in which the user is able to create large reports which group and calculate based on search fields throughout the system as well as specific true/false includes. |
|
| 2004 | Delphi 7.0 | MS SQL 2000/Access 2000 | Another membership based club system that uses bar code scanners to read membership cards which allows access to multiple different areas within the club all controlled by this central system. This system also uses a skin system. | |
| 2005 | Delphi 7.0 | MS SQL 2000/Access 2000 | This system was a very challenging design. The purpose of MSchedule is to coordinate production between multiple plastics production lines. This system is 100% Drag-And-Drop and each job listed on the schedule is “aware” of the other jobs around them. After inserting, deleting, updating, or dragging a job, each job that may be affected in or around the changed job is updated in the order of production. Different color indications illustrate to the user if a job is on schedule, behind, or ahead. | |
| 2003 | Delphi 6.0 | MS SQL 2000/Access 2000 | Used in a chemical plant, the MPROD program tracked master parts and costs, Bill of Materials (B.O.M.), and production/plant costs. Sales team would generate quotes based off information, update pricing, detect pricing changes, and complete sales. Prior to system, the client was doing all manually or with Excel. Sales accuracy increased over 60%, time required to complete sales decreased, and customer response increased. Client estimates system saved them close to $100,000 per year. |
|
| 2002 | Delphi 6.0 | MS SQL 2000 | Used by a Direct Mailing company tailored for the Automotive Industry, the system tracks all sales, promotions, artwork, customers, and financial information. As portions of the sale are completed, the user is able to generate email orders to their vendors without leaving the system. Email is tracked for issues, feedback, and completion. All sales have up to 9 different sections that are tracked individually and reported on. Prior to system, client was doing all sales manually and creating very large document folders. Was difficult to review history with clients as they called. Documents where often lost, in the event a person was not in attendance that day, co-workers where unable to monitor status of sale. Sale orders where faxed to each vendor, often with 20 or more fax sessions going back and forth. On converting over to this system, client saved over $2,000.00 per month in decreased long distance costs from faxing. |
|
| 2002 | Delphi 6.0 | Access 2000 | The CEO of a Fortune 500 company had spent a substantial amount of money in a large software system integrated with their PBX system to track calls and log call notes. The system was too complex and timely to use. The I.T. Manager requested that I complete a very simple program to accomplish those two specific tasks. Program was completed within 2 hours and installed. CEO states it is the most used program on his computer now. Additionally he later asked for a "Task Manager" tab to be added as he did not like using Outlook. This program is show here not to demonstrate great programming skill, but rather to demonstrate the simplicity of a small focused "utility" program. |
|
| 2002 | Delphi 6.0 | MS SQL 2000 | Program is for a long term return client. This system tracks legal and lease information for the multitude of properties owned by the client. Prior to system, this information was tracked by Excel. On missing several
lease renewal dates, the client requested this system to track all corporate
information and provide email notices prior to lease renewal dates. |
|
| 2001 | Delphi 6.0 | MS SQL 2000 | This system was created to combine several programs I had already written. Created as an ERP (Enterprise Resource Planning) program, this program completed the tasks of Inventory Control, Production Processes, and Planning. Prior to system, this company used multiple programs to achieve 80% of
the functions needed. This system also went on to merge with Compaq and
UPS web portals via custom .DLL programs I created in order to give outside
access to information. |
|
| 2001 | Delphi 5.0 | MS SQL 2000 | This system was built while I worked in Scotland, and managed two teams of Software Developers (Both in Scotland, and in the U.S.). The purpose was to provide a "mini" ERP system to the Scotland branch of an international client. The system interacted with SAP and a proprietary Accounting system to bridge the gap and create Shop Floor control, planning, Preliminary Build Plans, Warehouse Pick Lists, and Inventory Control. Prior to system , the client did not have any software in place to fulfill
these functions. Automation increased staff abilities, inventory accuracy,
and allowed the client to move from an Order Reaction fulfillment ability
to a Just In Time (JIT) fulfillment ability. |
|
| 2000 | Delphi 5.0 | Access 97 | This system was built as a lobby tracking program for guest. On entering the building, a guest would use the touch-screen monitor to input their name, who they needed to see, and the company they represented. System would then print out name badges at the reception desk, and vocally (Using custom ActiveX controls) welcome them to the facility. Managers are able to print out daily visitation reports and track who is in the building at all times. | |
| 2000 | Delphi 5.0 | MS SQL 2000 | This system used touch-screen controls and bar code scanners to streamline production floor operations for Compaq Monitor refurbishment. A total of seven production stages used this system to track, test, flow, and print out labels in a production environment where Compaq Monitors are unpacked from customers returning equipment, tested them, and then re-packaged for sale as "Refurbished" monitors. Real-Time tracking was provided to management via Wall-Mounted displays in several locations throughout the facility. |
|
| 1999 | Paradox 5.0 | Paradox | A manufacturing company with 60,000 square feet in warehouse space was in need of a small, thin system to control inventory. The result was a single screen system with Min/Max control levels which only required 5 minutes to train on. Training time was critical due to the high temporary employee ratio within the warehouse facility. System has an "English" and "Spanish" logon for multi-lingual support. After implementation in one location, the client requested a web interface as well which they then implemented in several locations including 5 warehouses overseas. |
|
| 1999 | Delphi 5.0 | Access 2000 | This system was an upgrade to an earlier program (Wings 1.0 located at the bottom of the list). The client had been running version 1.0 for 6 years. In some locations they still enjoy 1.0 today. Please reference version 1.0 for more information. | |
| 1997 | Delphi 5.0 | MS SQL 7 | System was generated for an Artistic Design and Manufacturing company. Client had the need to automate their production and CRM process due to expansion. This system tracked all information for Customers, Current Production, Raw Materials, Art, Accounting/Billing, and Sales information. Client was previously using paper forms for all process control and often times’ lost important information, or simply could not fulfill customer demands in a timely manner. |
|
| 1997 | Delphi 5.0 | Paradox | System created for a Funding firm that catered to large investment clients in multi-transactional and diverse portfolios. The system logs all transactions clients are involved in and monitored pay-outs, investments, amounts, beneficiaries, and return opportunities. Not only did the system increase productivity through automation, but it identified multiple additional investment opportunities based on market logic input by the users. |
|
| 1996 | Paradox 5.0 | Paradox | System was designed to track Sales Calls, Leads, and Correspondence for a software company selling database systems to the Medical industry. Prior to system, company was using pen and paper. Increase in sales was directly measured after system installation. |
|
| 1993 | Paradox 5.0 | Paradox | A Houston, College Station, and Corpus Christi Restaurant chain was in need of a new system to manage the "Back of the House" of their locations. This system tracked employee's, sales figures, inventory (FiFo system), paid-outs, and all reporting. Later modules were integrated to poll cash register systems and provide "Menu Mix" reports which later progressed to a full Point-of-Sale (POS) system replacing the cash registers. An additional system was put in place at the corporate offices to poll and consolidate each restaurant location. This system has been in place in several locations for 10 years. Many of the managers still prefer version 1.0 instead of version 2.0. Both systems can access the data equally. The ease of use and continued functionality has been a testament to the system. |
|
| 1992 | Superbase | Superbase | One of the very first programs I worked with. This system was created to control Documents and Complaints within Medical Device Manufacturers (MDM's) in accordance with Government FDA guidelines. This system tracked all master records and procedures for building products, engineering change releases, and updating of index masters. Additionally, the Complaint management system reported to the FDA offices when complaints triggered preset criteria. This system was packaged, and commercialized, having over 300 installed customers between 1993 and 1995. Interactive Data, a company in which I was part owner, later purchased the software line and continued its commercialized sales. |