Established and operate a computer-consulting corporation, which requires maintaining relationships with multiple clients, managing and performing project work, and resolving insurance, tax, and accounting issues.

Architected and implemented a large scale stock and yield accounting system throughout one of the largest US refining organizations. This system integrates a dozen large applications including SAP, expert systems used to rationalize real-time process data, linear programming models used to optimize refinery yields based on spot prices, and many others. The system is built on top of an ORACLE operational data store, and is hosted on 10 – 15 servers located in the corporate headquarters as well as each refining site. All interfaces send and receive XML to/from BizTalk using xmlhttp (the organization is not ready for SOAP). This system uses an integrated messaging system that logs all errors and messages to files and the databases. This approach has greatly reduced the support effort and has also assisted in the development effort.

Designed and developed a SQL Server database and accompanying web site that consolidates all federal, state, and corporate operational compliance requirements for a continuous process facility into an easy to use web site. This system integrates several 3rd party applications as well as custom applications through various interfaces.

Designed and developed a web site publishing system and implemented several web sites with it.  The publisher allows multiple users assigned various security levels to maintain a web site's content within a database using web based forms.  The publisher also allows dynamic forms to be created with user defined fields.  A drill down reporting system depicts all site user form submissions, including user defined submission types and user defined data fields.  The system is based on middle tier COM components using defined (high speed) ADO command objects to communicate with the SQL Server database.  Server side and client side JavaScript are used to communicate with the COM components to retrieve/present and store data in the database. 

Tuned the ORACLE System Global Area (SGA) for a fortune 50 company's PeopleSoft database.  This database is running on a 10 processor Sun server with 9GB RAM, and was experiencing extremely poor performance.  After modifying the SGA parameters to properly use the available system resources, reports and queries that once took minutes now take seconds. Also asked  the client to rebuild the database indexes since they were extremely out of balance, yielding more performance enhancements. 

Worked closely with a client to architect a multi-tier application that delivers real-time and historical process data to users via a web browser. Resolved all issues related to DCOM and MTS security, COM object deployment to web clients, and efficiently marshalling data from middle tier objects to web clients. Developed all of the middle tier database and security objects as well as several client side database and report management objects. Also developed all of the server side and client side script that combines the objects developed by the rest of the team into a coherent system.

Designed a real-time process data warehouse that currently stores 1 billion rows (500GB). This design was adopted and deployed throughout refineries within the largest US refining organization. Installed Oracle 8, created the schema objects and transferred data from the previous system into the new database at 3 of the locations. Developed a suite of NT services that load real-time data into this database at a rate of 10,000 records per minute.

Created and deployed an intranet site which allows users to access database driven web pages that display refinery charge and yield data, energy intensity index (EII) data, plant and unit weight balance data, and equivalent distillation capacity (EDC) data.

Worked with a series of postdoctoral and undergraduate students from the University of Delaware's Chemical Engineering department to design and create expert systems.

Consolidated approximately 25 ORACLE 6 and 7 instances into 3 ORACLE 8 instances, greatly reducing the support costs associated with the related applications.

Managed a development team and acted as a liaison between a large client and third party developers. Gathered requirements and performed system analysis, design, and development.

Designed and implemented a yield accounting operational data store that serves as the core for a large refinery’s process data related financial reporting system. A third party developer used a portion of this design as the database for a yield accounting product that is currently used in refineries throughout the world.

Designed and implemented several ORACLE databases that were used as the data store for applications in the traffic and blending areas of a refinery. Managed a group of programmers that created and implemented the associated applications.

Lead DBA responsible for the administration of 20+ ORACLE 6 and 7 database instances. This responsibility included managing an ORACLE DBA, installing and maintaining ORACLE, planning and executing migration to new versions of ORACLE and SQL*Net, as well as using and modifying a variety of UNIX scripts to monitor the databases.

Managed a programmer, a data entry clerk, and a mail clerk to accomplish the creation and distribution of daily and monthly reports used by management to track credit card delinquency. 

Designed and developed a regression based loan loss forecasting model by aggregating credit card portfolio delinquency cycles.  Received the most valuable player award for a 250+ person department for this and other contributions.