Contact me at Ritsond1@gmail.com Unparalleled expertise in architecture for the Callidus TrueComp/TrueProducer/Producerpro and datamart products, including: - SQL performance. - Product functionality - workarounds - stagehooks and plugins - pipeline functionality - plan and rule performance - plan and rule design - data acquisition for reporting - producer management and Insurance industry webservices - UI performance - inbound and outbound integration - Informatica ETL performance tuning - parallel pipelines and processing - batch cycle planning and shell scripting - data manipulation - data conversion - historical data strategies - PL/SQL and Informatica development for the TrueComp pipeline - best practices - Producer Pro and TrueProducer products - Development of web services againest Callidus ODS or producer Management databases Oracle, DB2, SQL Server, Informatica Powercenter, UNIX, Windows, VMS, Shell scripting, Performance tuning, design and architecture, ASK/ingres. Expertise in the design, construction and tuning of Informatica/Powercenter and Oracle database solutions. Oracle, MS SQL and DB2 query and procedure performance tuning, Ability to make the toughest queries run in reasonable times. Modification of sql to provide runtime stability and no dependence on statistics. Specialties: Telco, Finance, Insurance, Cloud/Multi tenant development

Senior Technical Director (Solution Architecture) @ Lead the solution Architect group From November 1999 to Present (16 years 2 months) Consultant @ Design, Development and testing for the Bank Of America Mortgage Service Rights Valuation datawarehouse. Took feeds from mainframe DB2 and performed complex transformations to convert data into the data warehouse. The datawarehouse helped the bank value their loans and decides which one to sell. From June 2002 to November 2002 (6 months) Charlotte, North Carolina AreaSenior Consultant @ Design and development of complex Informatica solutions. Clients included Nike and Callidus Software From November 1999 to February 2000 (4 months) Snr Consultant @ Design and development of complex Informatica solutions. Clients included Nike and Callidus Software From November 1999 to February 2000 (4 months) Snr principal Consultant @ Provided technical leadership for large telco customers including Nextel and Telefonica. Helped projects convert to use oracle partitioning features. Design, development and tuning of VLDB's. From November 1998 to August 1999 (10 months) Senior Principal Consultant @ Provided technical leadership for very large database projects involving Oracle. The applications were typically database marketing. Worked at the following clients 1) Pacific Bell, rewrote most of the data interfaces to reduce run time and increase stability. Wrote code to do high speed data transfers between the Oracle warehouse and the smaller reporting datamarts (Pro*C, PLSQL, SQL Loader, Shell Scripts) 2) John Hancock, wrote several data interfaces (Pro*C) 3) Merrill Lynch, conversation of COBOL mainframe based data to an Informatica and oracle based environment. 4) Cadillac Motors, technical business process improvement From August 1995 to November 1998 (3 years 4 months) Greater Denver AreaPrincipal Consultant @ dbINTELLECT From August 1995 to November 1998 (3 years 4 months) Snr principal Consultant @ See DBIntellect From August 1995 to November 1998 (3 years 4 months) Consultant with IBM workflow solutions @ Building of workflow solutions using using oracle, MOTIF and C. From March 1995 to October 1995 (8 months) Senior Software Engineer @ Development of PRO-IV PROIV From January 1993 to May 1994 (1 year 5 months) Senior Programmer @ Support and development for the PRO-IV 4GL. From January 1993 to May 1994 (1 year 5 months) Programmer @ Development of C/INGRES programs on VAX/VMS to support Apple's business From 1990 to 1993 (3 years) Programmer @ Design and development of an INGRES database and associated apps to track emissions in the Los Angeles area. From May 1991 to October 1992 (1 year 6 months) Senior Consultant @ Software development to support campaign management and email promotions. From September 1990 to October 1991 (1 year 2 months) Programmer @ Commercial FORTRAN, , General Automation, Ingres From March 1988 to May 1991 (3 years 3 months) Newcastle upon Tyne, United Kingdom

Postgraduate Diploma, Computer Science @ The University of Stirling From 1986 to 1988 BSc, Physics @ Queen Mary, U. of London From 1983 to 1986 David Ritson is skilled in: Oracle, Informatica, SQL, Unix, Unix Shell Scripting, DB2, DB2/SQL, SQL Server 2005/2000, Oracle SQL, Linux, Architecture, Information Architecture, Server Architecture, Database Design, Database Management