Robert W. (Rob) Garrison
(Address and phone numbers removed -- to contact, please send e-mail) rob@rwgarrison.com
SUMMARY OF QUALIFICATIONS
			Experienced, creative, motivated database designer and developer specializing in high-performance OLTP database development utilizing Microsoft SQL Server. Demonstrated ability to translate complex business requirements into technical solutions. Significant contributions to all aspects of development life-cycle of commercial software products in use by many of the largest financial institutions in the country.
WORK EXPERIENCE
	WebMD Health Services, Data Architect - October, 2007 to Present
		Current Reponsibilities:
					Responsible for all aspects of OLTP design, coding, standards, and scalability.
		Technology Environment/Process Environment:
					SQL Server 2005 in a Windows/.NET 2.0 environment
	Fiserv (formerly Corillian Corporation), Staff Software Engineer (Data Architect) - July, 1999 to October, 2007
		Current Reponsibilities:
					Design databases, program stored procedures and unit tests.
					Review and update use cases.
					Act as primary liaison between Product Management and Engineering development group for project.
		Technology Environment/Process Environment:
					SQL Server 2005 in a Windows/.NET 2.0 environment
					Microsoft SQL Server (6.5, 7.0, 2000, 2005), T-SQL, Embarcadero ER/Studio, ERwin
					Development environment: Scrum/Agile, continuous integration
		Other projects and assignments:
					Sole database designer and developer for “AMS” (rights management) project. At initial release, this project included 67 tables, 411 stored procedures and user-defined functions, and 638 stored procedure unit tests (including the automated database test framework).
					Worked on Corporate Banking, “Platform” (application server), Bill Payments/Bill Presentment, and eCRM teams.
					Developed and documented a set of “best practices” for database development.
					Managed relationships with technology partners.
					Managed the eCRM Engineering team for one year, including responsibility for the complete software life-cycle of Corillian's eCRM product suite as well as personnel management, budget, interface with customers, other departments, and executives.
					Wrote requirements for new releases of existing products.
	GemStone Systems, Inc. (previously Servio Logic) - August, 1996 to July, 1999
		Responsibilities:
					As intranet Manager: Designed, developed, and maintained GemStone's intranet, administered web servers, managed intranet content providers throughout the company.
					As Software Engineer: Developed and maintained GemConnect (a communication layer connecting GemStone's object database with multiple relational database systems), ported GemConnect to Windows NT (from Unix), developed a Windows NT installer, wrote on-line documentation, installed and administered Oracle and Sybase databases, developed JDBC connection pooling, wrote technical papers for Sales and Consulting.
		Technology Environment/Process Environment:
					Intranet: Microsoft IIS 4.0, FrontPage 98, and Image Composer
					Internet/extranet: Netscape Enterprise Server, APACHE web server, Stronghold and Raven SSL-enhanced web servers, CGI/Perl, HTML, Unix shell scripting, CVS (version control)
					C, Smalltalk, Java, JDBC, Oracle and Sybase C APIs, Oracle and Sybase databases, make, Unix shell scripts, InstallShield, Windows NT 4.0, and CVS
	Oregon Steel Mills - July, 1989 to August, 1996 - Systems Technician and Systems Engineer
	The Oregonian Publishing Company - December, 1988 to July, 1989 - Computer Operator
	Frederick & Nelson Information Services - February, 1988 to November, 1988 - Computer Operations Supervisor
	U.S. Air Force - August, 1984 to March, 1988 - Computer Operator
EDUCATION
	Bachelor of Science, Computer Science, Portland State University Completed: August, 1996.  Emphasis: database systems
PUBLICATIONS
	Database Journal Column: SqlCredit – Developing a Complete SQL Server OLTP Database Project
	Exploring NewSequentialID() in SQL Server 2005 (RTM)
	Performance Implications of Nullable Columns
	OLTP Drag Races: SQL Server 2000 vs. SQL Server 2005
	Exploring 'ON DELETE SET NULL' in SQL Server 2005
	Detecting and Reporting Errors in Stored Procedures - Part 2: SQL Server 2005 TRY-CATCH Blocks
	Detecting and Reporting Errors in Stored Procedures - Part 1: SQL Server 2000
	Exploring Table and Index Partitioning in SQL Server 2005