Database

Need a specialized database for internal and/or web-based management, sales, and/or accounting? Look no further! I offer custom database solutions, for both intranet and internet, exclusively using MySQL and PHP technologies. Both MySQL and PHP are very powerful, fast, efficient, and best of all, completely free open-source technologies!!! Some past examples would include:

1) Designed and built from scratch a web-based system for a new Human Resources company to be able to place appropriate drivers with various trucking companies (clients). This system would allow the HR company the ability to: A) process driver applications with background checks, MVR`s, etc.; B) manage all positions (position open, driver under consideration, position filled, etc.); C) manage all clients (active, inactive and otherwise); D) manage all recruiters (individuals/companies that would refer drivers); and E) manage all drivers. The driver's bi-weekly performance rating would also be tracked, as a numerical rating from 1-10 on each of 23 specific factors would be automatically averaged for each rating period, as well as being averaged over the drivers entire employment period with the company. Accounting information would also be managed with this system, including information such as accounts payable/ accounts receivable, and would be retrievable in several various types of reports. This online system was designed with various log-in levels, to allow the HR company complete access, while allowing the clients, drivers, and recruiters limited access appropriate for each of their needs

2) Developed web-based database utility for music school using PHP and MySQL, which increased accuracy and dramatically aided sales persons` ability to quickly best match the customers` needs with available resources, and thus complete sale in a single phone call. By eliminating the need for a later confirmation callback, sales by phone nearly doubled.

3) Developed sales tracking database for above mentioned music school using MS Access, which enhanced their ability for analysis of advertising and sales effectiveness.