Robert W. (Rob) Garrison
(Address and phone numbers removed -- to contact, please send e-mail)
  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.
   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
      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
  Bachelor of Science, Computer Science, Portland State University
Completed: August, 1996.  Emphasis: database systems
  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
View Rob Garrison's profile on LinkedIn