3. VALID2 - Database and maintenance and related applications

These independent systems were:

• The Contract Monitoring System
• The DAR ( Distributor Authorized Reseller ) Database
• The POS ( Point of Sale ) Database
• The IMPACT2 Database

In addition, ongoing data exchanges are operational with more than 20 organizations, these exchanges range from simple spreadsheet like extracts to more complex bi-directional links. Currently, the VALID 2 system consists of more than 50 related tables, containing more than 50MB of data, including 800 pages of the Channel Partner Solutions Catalog, published on hp.com

• Top 10 most accessed web sites on HP's Intranet
• "Flexible" data model success story

WINREF (HP's Wins & References Library) has moved to the top 10 most accessed sites on ESP (HP's Electronic Sales Partner intranet site) and is a flexible data model success story. Flexible data model technology for WINREF has successfully incorporated several different Win Reference Libraries with differing data model requirements, all with no down time. In a conventional data model, the database would have needed to be restructured in order to accommodate the new business data requirements.

Aardeus designed the WINREF database and data entry application and has supported the WINREF system since 1990. During this period, WINREF has migrated through 4 successive developments, as data model needs and business requirements changed. Each change required a significant data conversion / cleanup process to move the data into a significantly different data structure. With the last migration to the flexible model architecture the need for progressing to a different data structure ceased because the flexible structure can handle any data modeling requirement.

NETSCAPE COMMUNICATIONS CORPORATION (1996 - 1998)

Designed and developed:

1. Sample Applications for LiveWire Pro: DbAdmin, a generic web interface for managing SQL servers (Oracle, Informix, Sybase, Microsoft)

2. Internal Database Applications:a) Bug Tracking, used by engineering and QA to track and resolve software defects.b) Call Tracking used by technical support to track customer support calls.c) Feature Tracking used by marketing to track feature enhancement requests.

These applications were developed using HTML, Javascript and Netscape LiveWire Pro for updating and reporting from an Oracle database.

APOGEE INFORMATION SYSTEMS (1997-1998)

Developed an expert proposal generation system for a Fortune 500 industrial company. The system uses client-server architecture, with data bound rules, and Delphi 2 Client/Server as the User Interface. Developed some of the more complex SQL procedures mapped to a data bound outliner, designed and developed the Visual Rules Builder User Interface and developed all conversion utilities.

NEW YORK LIFE (1996-1997)

Developed a sales support product for NYL’s 25,000 agents, managers, and underwriters. The product used 3-tier architecture (Business Layer, UI, and Data) and was written in Delphi with SQL Anywhere as the database. Design and maintenance of the project object models, translation utilities, install programs, all builds, and project management/version control and bug reporting tools. The product was released on time and on budget.

ESKOM (Johannesburg, South Africa - 1995)

Business Processing Re-Engineering Consultant for South Africa’s only utility company. The project’s objective was to re-design the utility’s business processes to extend electricity to the 90% of the country’s population without electricity. Responsible for the development of all Marketing/Sales/Customer Support Models. Developed, in conjunction with this project, a set of CASE tools for Business Process work.

WELLS FARGO BANK (1993-1995)

Designed and developed an integrated Customer Support and Marketing System which includes international currency transaction processing, client/contact management, workgroup call reports, and a workgroup agenda manager. This system also includes a "DataSync" module to maintain data base synchronization in both the host and remote locations. Completely trained two mainframe programmers to take over development and maintenance.

ERICSSON TELECOMMUNICATIONS, INC. (1992-1993)

Designed and developed an integrated Production Management System. The application includes: Shop Floor Control, Material Requirements Planning, Inventory Management, Shipping/ Receiving, Purchasing, and Order Entry/Invoicing.

VARIAN ASSOCIATES (1989 - Present)

Redesign of the Varian Oncology Marketing Database. Convert existing data. Normalize and cleanse data. The future plan for this database is for it to become Varian Oncology's central client database, shared via an SQL server. The system is designed as a distributed database allowing distributed data entry at locations around the world and for all databases to update each other, automatically, with information from other regions. Currently supporting and providing enhancements to Varian’s Marketing Database and related applications.

VISA INTERNATIONAL (1993)

1. Insurance Monitoring Database: Developed and implemented an insurance monitoring database with facilities to support insurance reconciliation and auditing with supporting reports and connection to mainframe database.

2. Merchant Risk Management systems: Developed two merchant risk management systems involving complex data entry, search and retrieval UI as well as supporting reports.

MCI (1992 - 1997)

Designed, coded, implemented and documented a system written in C and Paradox PAL to report customer phone usage. This system is installed on PC 486's connected via a Novell network. The system collects records and generates reports 24 hours a day, 7 days a week.

FILOLI INFORMATION SYSTEMS (1994-1996)

Created foundation for Database Technologies Group which eventually grew to 30 people. Recruited majority of Filoli's early technical staff which created applications including a Document Management System and a Customer Information Sharing System. Helped introduce object-oriented programmers to relational database technology. Managed team of three DBA's responsible for maintaining several production and development servers using Sybase SQL Server and Replication Server System 11 on SparcServer 1000's. Developed Perl scripts for database maintenance and data importation. Administered Windows and NextStep clients.

TRW FINANCIAL SYSTEMS (1993-1994)

Mentored staff working on their first Sybase product implementation. Work involved creation of triggers, stored procedures, database administration, and coding in ctlib using Visual C++ for Windows NT.

MRA (1995 - Present)

Developed a database data entry system, using Delphi, to track financial institution product information. MRA surveys banks on their products and product features. This system developed allows MRA staff to enter financial institution product data and includes a reporting system.

SUN MICROSYSTEMS (1988-1989)

Provided Software Quality Assurance testing of Language Products (Fortran, C++, Cobol, SPARC monitor and debugger). Work required ability to reconfigure Sun network, perform administration tasks and automate test suites. Wrote report for Sun directors that obtained funding for Sun's Ruby hypermedia project.

Credentials:

Allaire Alliance Consulting Partner, 1999.

Microsoft Certified Professional: SQL Server Product Specialist, 1996.

Certified Sybase Professional: Interfaces Developer, 1996. Database Administrator, 1995.

Microsoft Certified Professional: NT Server Product Specialist, 1997.

Spoken Languages: