The systems listed below were built with direct input from end business users,
helping to design and build custom solutions that addressed their specific and unique information management and processing requirements.

Accounts Payable Reporter
Created in order to enable a department to track and examine it's expenses in greater detail than the legacy accounts payable system could easily be customized to allow, information from incoming invoices is extracted and classified by departmentally defined project and matter codes and attributes. A subset of the data is summarized to print out payment request forms in the format expected by the legacy accounts payable system, while the additional data is used to create detailed reports for department managers and exported for additional pivot table analysis.

Corporate Brand Protection
This database integrated 4 legacy databases into a single resource, creating a mechanism for coordinating brand protection services while providing a searchable catalog of trademark infringement, opposition and counterfeit intelligence. Users in North America, Asia, and Europe maintain the database, adding and updating records as necessary. Related images are imported, cataloged, and stored on a secure intranet server and are retrieved via standard web browser. The system also includes comprehensive report-generation capabilities.

Currency Exchange
Programmed to retrieve a daily e-mail message containing the currency exchange rates for 70 countries, this simple utility parses out all exchange rate information and then re-builds a table which shows comparisons of each of the currency's units per US$ and US$ per each of the currency's units. The updated information is then passed into a globally referenced accounts payable database for inclusion in various currency related calculations.

E-mail Distribution List Management
This utiltiy repackages data extracted from a legacy corporate directory application in order to create an MS Exchange server's e-mail distribution list input file. Besides giving administrators precise control over rules for defining distribution list members, the system also searches for and repairs errors in various e-mail address components. Aspects of the system are also used by communications, security, and executive administrative personnel as an enhanced corporate directory utility as it provides a hierarchically-defined departmental cross-reference with comprehensive records on 14,000+ employees, contractors, and temporary workers, many with photographs later integrated from the company's security access system.

Human Resources
A rapidly growing company required a multi-user database to track details pertaining to employee compensation and incentive plans as well as life, medical, dental and vision insurance premiums and expenses, time off accruals, and related service provider information. The finished database consisted of approximately 200 fields of information (40 of which were proprietary, company-specified calculations) in 10 related tables with roles-based password security controlling different groups abilities to view or modify different forms or data. 

Information Merge Editor
When two departments found that they had overlapping data collections with no common field to relate the collections together (each department had created their system independently) I built a utility which used a variety of criteria to compare components in each collection, narrowing down potential matches to a pick list. A workgroup was instructed on how to make a final selection based on various properties made visible in the editor, and then the workgroup members were assigned record sets to process. The utility worked well and the collections were accurately merged in one afternoon.

Litigation Reference
Providing attorneys a simple method to keep accurate tabs on various litigation management components, this system is a searchable catalog of detailed court and counsel information, case analysis, litigation types, case statuses, key dates, parties involved, damages claimed, and depositions scheduled. It also tracks legal fees by vendor, invoice, and date plus provides links to the accounts payable system for drill down fee detail.

Off-site Records Storage
Keeping track of boxes of documents sent off-site to a long-term storage facility, this system provides a searchable database of 200,000+ folders stored in 66,000+ containers. The information is indexed by file classifications, key dates, and user-supplied contents descriptions. A web interface enables users to search for and request retrieval of their records storage set's contents.

Technical Recruitment
This system makes it easier for a technical recruitment service to quickly and accurately match available people to open positions and open positions to available people. It reduces confusion as recruiters gain a single, unified view of all transaction progress. Incoming job orders and candidate resumes are verified and entered into either a jobs table or a candidates table. Relational links are created as recruiters match open positions to candidates or candidates to open positions. The links are contained in a third table with time, date, and action description. The chronologically sorted actions are viewable from either the jobs record or candidates record, making it easy for recruiters to view potential matches, initiate e-mail or fax messages, and update activities as transactions progress.