A senior software engineering position in the general area of Distributed Systems. This includes (but is not necessarily limited to) Database Systems, Transaction Processing, Decision Support Systems, Business Intelligence and/or Distributed Objects.
MS Computer Science, University of Wisconsin, Madison (1988).
BS Business Administration, University of California, Berkeley (1982).
Siebel Systems, Inc. purchased nQuire software in October, 2001. Participated in the effort to integrate the nQuire Server (nQS) into Siebel’s software suite as a business analytics component.
Wrote design documents, participated in design reviews, implemented new functionality and maintained existing code in the nQuire Server (nQS), a SQL engine designed for decision support queries and business analytics against multiple back-end databases. nQS can simultaneously access multiple and varied databases through specialized gateways and present its clients a unified view of heterogeneous data. The back-end databases include Oracle, DB2, SQL Server, XML and any databases accessible via ODBC. nQS also acts as a fully functional SQL compilation and execution engine that joins tables across multiple databases and performs any other operations that the back-end databases can not perform. For improved performance, nQS caches query result sets locally.
Worked in all components of nQS. This included rewriting transformation rules in the SQL compiler component, fixing various execution operators in the executor component and extending the Oracle and ODBC gateways to use Unicode in preparation for internationalizing nQS. Also designed and implemented a cache management facility for analyzing and improving the effectiveness of the query cache and rewrote the space management code for the query cache to make it more robust in the presence of space allocation constraints. Also designed and implemented a usage tracking facility for measuring resources used by nQS clients. This provided customers with a mechanism for charge-back accounting. Finally, integrated Microsoft performance monitoring into nQS to assist in evaluating overall nQS performance.
Designed and implemented a roll-up costing model for the optimizer component of NonStop SQL/MX, the Tandem Division’s flagship database product. This costing model captures the interactions between operators in a query tree using a sophisticated vector algebra and produces more accurate query plan costs (and thus better overall query plan selection) than traditional roll-up costing models. This work resulted in US Patent Number 6,330,552, “Database query cost model optimizer”. Other work in the optimizer component included developing a unit test suite for parallel query plans and the design and implementation of pruning algorithms (based on the above costing model) to reduce the optimizer search space.
In addition to software development duties, acted as lead recruiter for the database group at the University of Wisconsin. Successfully recruited six top candidates over a two-year period.
As part of Tandem's distributed object technology effort, designed and implemented a log manager and transaction state machines for a prototype version of the Object Transaction Service (OTS) as specified by Object Management Group (OMG). Also implemented a log manager in Java as part of a prototyping effort to add transactional semantics to Java objects.
Wrote design documents, participated in design reviews and code inspections, implemented new functionality and maintained existing code in Tandem’s database kernel known as the Disk Process—a product of central importance to Database and Transaction Processing at Tandem. Disk Process functionality includes lock management, cache management, access methods (primarily B-trees), recovery management, file directory management (including open/close processing), data manipulation (including high level relational operators pushed down into the kernel for improved performance), log (i.e. audit trail) management, free space management and transaction management all within a fault tolerant context. Worked in every area listed above with the most significant work involving a rewrite of the log manager to increase on-line log capacity and improve log generation throughput. This work resulted in four patents: US Patent Numbers 5,590,274, 5,764,879 and 6,041,420 "Multi-Volume Audit Trails For Fault Tolerant Computers" and US Patent Number 5,978,914, “Method and Apparatus for Preventing Inadvertent Changes to System-critical Files in a Computing System”.
Taught 2 sections per semester of CS302, a class in introductory programming with Pascal. Had complete responsibility for both sections including lecturing on the material, preparing and grading homework assignments and exams, and determining the final grades. Published lecture notes which received extremely high student evaluation ratings. Achieved the highest overall student evaluation rating of any CS302 Teaching Assistant in the Fall semester, 1987.
Worked on the EXODUS extensible database project for professors Michael Carey and David Dewitt. Wrote design specifications and coded page allocation and buffer management routines. Completed all work successfully and on schedule.
Determined user specifications, wrote design documents, coded and tested programs and trained user representatives for data processing systems relating to energy conservation incentive plans. Produced on-line data entry programs as well as batch update and report programs. Consistently received praise from users (including a letter of commendation) and excellent evaluations from superiors.
Coded and tested programs for a financial information system including on-line data entry programs, report programs and a small scale text editor used to view reports on-line with a 132 column terminal. As a college intern, produced as much working software as many of the full-time company employees.
Languages |
Operating
Systems |
Text Editors |
Computers |
Applications |
|
§ C++ § C § Perl § Java § Pascal § TAL § COBOL § Modula2 § PDP-11 Assembly |
§ Windows NT § UNIX § Windows 3.x § MS-DOS § Guardian Nonstop Kernel |
§ MSDEV § Vi § Word § TEDIT § Wordstar § Wylbur § Ex |
§ NT Workstation § Tandem § VAX § PDP 11-70 |
§ Word § Excel § Powerpoint § Quicken98 |
§ Passed entire Uniform Certified Public Accountant Examination by November, 1986
§ Received Competent Toastmaster (CTM) certification from Toastmasters International in September, 1995
§ Attended a one week seminar course in Object Oriented Analysis and Design in September, 1995
Available on request.