Contribute to a gifted team of engineers responsible for the QP layer of SDB. Particularly client/server protocols, capture/replay for headless pre-production CI test/performance. Low level debug. Failure analysis.

Investigate and solve complex customer issues involving DB2- core file analysis expert, AIX, Linux (x86/64)- repro expert, specializing particularly in single shot customer data capture scenarios (solution/RCA mandatory without another outage) - performance metrics analysis - multi component/stack data correlation analysis, with attention to details such as time skew mediation - huge datasets - developed specialized code injections to capture multi-threaded/multi-process time dependent , trace sensitive aults- prototype code fixes, tested at customer sites, and passed to development as a guide to product solutions- multi-discipline comprehension leading to innovative workarounds to many customer crit-sit situations- code developer relationship managementOutstanding Technical Achievement Award 2010 (Data Analysis tool development)

o Joined Lotus / Domino to bring advanced DB2 skills to Lotus Notes architecture team.o Seconded to the performance team. Initiated and produced in-depth analysis of allocation patterns in live Notes servers, from data gathered by custom measurement code. This analysis yielded several recommendations to improve IO. Also built a prototype alternative to the Notes internal disk buffer allocation algorithm that seems showed good to huge IO improvements (up to 75% reductions), most particularly in not-logged Notes databases. (Addendum: this code was implemented). o Developed a multi-threaded notes API driver, very useful in investigating notes behaviour and simulating bug situations.

o DB2 Entity Analytics Solutions (EAS) was acquired by IBM in 2005. It produces state of the art software for entity identification and relationship resolution. The software is directed primarily at areas such as Threat and Fraud, and Homeland Security (U.S.). Primary duties included:o Consulting on DB2 database usage and optimization, especially in regards to record search and entity relationship processing.o Research and development of new string matching software for name recognition (patent filed), and recently in the incorporation of AMiT CEP, out of IBM Research Labs, to provide advanced and complex management of alerts generated by the EAS system. I also participate in many of the design reviews for the future EAS releases.

o Investigations into opportunities for self management within the DB2 product. Research, in collaboration with Watson Research Lab, into algorithms to govern resource consumption, and resource sharing, between DB2 tasks. Delivered a design recommendation for introducing utility job recognition and management into the DB2 core engine awareness. Worked with senior members of the DB2 community, and lead a team of junior and intermediate members.

o Directed the re-write of the DB2 TPCC benchmark implementation, exploiting advanced DB2 query capabilities. DB2 took (and has held) TPCC leadership. o Lead the performance management of DB2 V8 internal architectural change to “common client”. Wide and deep impact, requiring thorough DB2 knowledge, and ability to work with many DB2 development teams. o Designed and developed Web enabled graphical tool to analyse and delve into instruction trace data. Key feature was ability to compare multiple runs to illuminate subtle changes. Tool included collaboration features, whereby remote users could interactively share data and views, whilst attending a teleconferenced meeting.o Created high performance benchmark driver, including very large multi-threaded and multi-processing investigations. Patent for Spin Laches (granted 2005) derived directly from experiments with this driver.o Invented XML to Java marshalling package, for rapid transformation of XML to and from Java classes. Requires little to no XML parser knowledge, or setup. o Designed and developed Web enabled Xquery tool to excersise and practise Xquery against DB2. Includes a simultaneous Saxon Xquery engine, for side by side comaprison of function and results. Includes on-line web enabled collaboration enabling the sharing of Xquery statements and results for remote demonstration.o Partipated in numerous performance hunts, achiving many meaningful improvements in the DB2 code base, particularly around concurrency, and data movement efficiencies.Outstanding Technical Achievement Award, 2003 for performance contributions

o Lead the porting effort for the C++ Control Centre to Java. o Implemented a Web-centric (browser enabled) solution. o Specific responsibilities included design and development of middleware to link the sandbox applet to the DB2 engine. Invented many internal design patterns, most notably high speed materialization of internationalized messages and translated strings, and seamless challenge and response re-try mechanism for security failures. Outstanding Technical Achievement Award 1998 for delivery of WebCC in DB2 V5.2 .

Began career at IBM performing a variety of versatile development jobs, with a focus on communications protocols. Included a SCO port, and command line, with optional graphical interface, for changing an MVS TSO password from Windows and NT workstations (used LU6.2 SNA)

Capital Markets Systems. Develop and maintain software in support of Capital market trading systems at the bank. Derivatives, Repos, Swaps, etc...Unix based , C / C++ . Also included adhoc programming on request from traders in Toronto , Montreal, London.

1989 - 1993Member of the team that delivered GDM at Royal Bank, on time , and on budget. Collaboration with IBM. Particular responsibilities: designed and developed a generic callback interface to shield application layers from all communication considerations. Designed and developed a GDM Message API giving each message an IMS database look and feel, allowing fetch, fetch next, update , delete of message fields, without the need for message structure to be understood by caller. Responsible for many other components, and live deployment. Awarded Most Valuable Contribution to the project at initial implementation.1985 - 1989 Began career at Royal Bank, working in the systems department providing tools and services to application developers. Numerous experiences, most memorably reverse engineered the data format of a source management archiving system. The system had spilled to 30 tapes and a request for retrieval could take several hours to complete. Managed to decode the storage map, build an index into the tapes, and with a dummy header record prefixed to each tape, could retrieve all source members with a maximum of two tape mounts. Achieved significant cost savings.

Guest developer at Hursley Park, IBM UK for MQ Series The GDM project at Royal Bank gave rise to IBM developing MQM. I was invited to provide IMS expertise to the Hursley development team for a few months in 1993, prior to the release of this new technology. Very successful and pleasant experience.