home | professional experience | it portfolio | programming and database projects

Programming and Database Projects

In addition to an understanding of many of today's office automation software packages, I have an understanding and working knowledge of ways to extend the functionality of this software into custom applications. The following list is illustrative of the types and sizes of projects I have worked on that required programming and/or database knowledge.

Room reservation and accounting management application developed in FoxPro
Developed for use in a university environment for their summer conferences program. The system replaced an older, legacy style application with a newer, easier to use, GUI driven system. The project scope included all new screens for room reservations, guest information management, revenue management, and special services management. The project also included the development of a new database and table structure as well as the development of 55 standard reports and several dozen customized reports for different buildings and end-users.

Inventory management & equipment service history systems developed in FoxPro
This system was developed for a Fortune 500 information technology outsourcing firm. It involved the creation of a database system to manage incoming shipments of client equipment, outgoing shipments to both the client and to warranty repair centers, and the tracking of all client, OEM, third-party vendor, and warranty operations information. The project scope included all database development, interface development, report writing, training material development, and implementation.

Back-office sales management system developed in Access 2000
This sales management system was developed for ATi as a custom solution for managing leads, sales contacts, contracts in-negotiation, contracts in-progress, and invoicing management. It was designed using Microsoft Access for both the database back-end as well as the GUI front-end. The system included database, end-user interfaces, reports, and a web output module.

Back-office work order management system developed in Access 2000
This tool was developed for an internet consultancy to assist them in managing employee requests for facilities work. This included such requests as hot-cold calls, painting, moves, adds, and changes, telecommunications requests, and office equipment service calls. The system resided in Microsoft Access 2000 and included the database and relevant tables, end-user interfaces, and reports.

Budget analysis worksheet tool developed in Excel
Developed for a Fortune 200 client, this tool was designed to assist the client in evaluating budget data that came out of a legacy system. By entering data from the legacy system into the worksheet's data-entry sheet, then keying in parameters (such as revenue forecasts, burn rates, or sales targets) the system would calculate out budget forecasts as well as perform analysis of deviation on current or past periods.

Project financial analysis tool developed in Excel
Developed for a Fortune 200 client, this tool was designed to assist the client in evaluating project expenses. Specifically oriented toward the firm's information technology projects, the workbook tool allowed the entry of a multitude of data points (such as employee salaries, overhead costs, and hardware and software costs). Entry of similar data for not doing anything as well as outsourcing was also permitted. The parameters worksheet would allow the firm to worst case or best case scenario the project by adjusting delivery times, overtime costs, and other related costs. The output worksheet would allow the user to see the data formulated based on the initial inputs and contingency parameters and would assist them in decision making by providing comparison data (such as internal rates of return, hurdle rates, and benchmark rates).

Back-office facilities request management system developed in FileMaker
Developed for Athena Neurosciecnes, Inc., the facilities request management system was designed in FileMaker. Distributed network access was provided to end-users in the organization to enable self-filing of facilities requests. This included requests for lab glassware, housekeeping, safety inquiries, and general facilities maintenance requests. The system consisted of the database back-end and end-user input front-end.