DWAYNE KING

PROFESSIONAL EXPERIENCE

PROFILE

Mr. King is a senior Systems Developer and Database Administrator with experience in mainframe, client/server and n-tier environments.

Mr. King has designed, developed, tested and implemented several large systems. These projects have utilized various platforms - client-server based systems (UNIX, Oracle 9, Oracle Designer & Developer 2000), mainframe (IBM 370, CICS, DB2), minicomputers, and web based applications.

His versatile skill set, including several client side development tools, and a firm grasp of server side technology makes him a valuable asset in any capacity. He is continually upgrading his skills, as opportunities become available.

Previous projects have added to Mr. King’s technical, managerial, and interpersonal skills, and allow him to adapt quickly to different work environments. He has utilitized his strong technical and organizational skills to supervise the transition of a large application from a character based platform to a GUI platform, as well as porting systems from various RDBMS’s to Oracle.

Mr. King has also been involved in many of the non-technical aspects of implementing successful computer systems. In previous assignments, Mr. King has performed and assisted in tasks such as preparing tender documents for the procurement of personal and mini computers, planning and implementing Total Quality Management procedures, teaching numerous Oracle courses, and authoring portions of several highly regarded books on the Oracle RDBMS.

TECHNICAL EXPERIENCE

Languages

PL/SQL

Java

UNIX Korn shell

COBOL

CICS

C

JCL

Pascal

Database Management Software

DB2

ORACLE 7.x, 8.x, 9.x

MS SQL Server 7, 2000

xBase (FoxPro, dBase, Clipper)

Operating Systems and Software

TSO/SPF

UNIX (IBM AIX, HP-UX, Solaris, Linux)

Microsoft Windows 2000/XP

Microsoft Office (Word, Excel, Powerpoint)

Microsoft Project

Wordperfect

Software Development / CASE Tools

Symantec Visual Café

Microsoft Visual J++

Oracle Designer 2000

Oracle Developer 2000

Oracle Developer Server

Oracle J Developer

PowerBuilder 6.0

ADW / IEW

EDUCATION

Wilfrid Laurier University

Waterloo, Ontario - Canada

B. Sc. (Honors) in Computer Science (1993)

CERTIFICATIONS

Oracle Certified Database Administrator (8i)

Oracle Certified Database Operator

Oracle Certified Application Developer

SECURITY CLEARANCE

Mr. King currently holds a Secret security clearance.

PROFESSIONAL DEVELOPMENT

Basic and Advanced Programming with SQL

Oracle Forms 4.5 - Introduction

Oracle Forms 4.5 - Advanced

Oracle Database Administration

Oracle Backup & Recovery Workshop

Oracle Performance Tuning Workshop

FastTrack to PowerBuilder Development

PUBLICATIONS

Retained by O'Reilly publishing for technical review and contributions for several Oracle related books:

Oracle PL/SQL Programming (2^nd & 3^rd Edition) ISBN 1-56592-335-9

Advanced Oracle PL/SQL Programming with Packages ISBN 1-56592-238-7

Oracle Built-In Packages (1^st & 2^nd Edition) ISBN 1-56592-375-8

Oracle PL/SQL Programming: Guide to 8i Features ISBN 1-56592-675-7

Oracle PL/SQL Workbook ISBN 1-56592-674-9

Retained by Brain Bench Inc. to assist in the preparation of Oracle certification tests, and developing content for:

OCP PL/SQL Study Guide

MEMBERSHIPS

Mr. King is currently a member of a Panel of Experts for the United Nations (International Monetary Fund)

RELEVANT EXPERIENCE

1) Cognos Inc.

Development Team Leader / Database Administrator

April 2002 – present

While at Cognos, Mr. King acted as the lead Oracle developer for a new product that was developed and subsequently became the best fastest selling product in Cognos history. He was responsible for the creation and administration of all development and testing environments for a team of approximately 25 developers and 5 testers. This entailed initial database creation, disaster recovery planning, and regular upgrades.

Duties also included involvement in the product design, establishing a framework of code for reuse by other database developers, and the porting of any new or existing code between all platforms (e.g. MS SQL Server, Oracle, DB2 UDB).

Environment: Oracle 8.1.7, 9i on Win2K, HP-UX and Solaris, Tomcat Application Server, Cognos Series 7

2) Bell Canada

Development Team Leader / Database Administrator

July 2000 – April 2002

At Bell Nexxia, Mr. King performed several duties, ranging from data modeler to Java programmer. After evaluating and improving upon data model related deliverables from previous consultants, he advised management on the appropriate direction for the project, with respect to database issues.

He was responsible for the continued availability and support of several development, testing and production environments, and coordinating efforts between himself, and other consulting groups involved. The resulting e-Commerce web site was used as a portal for all of Bell Nexxia's customers, to order new services, obtain the status of orders, and research other Bell Nexxia offerings.

Environment: Oracle 8.1.7 on NT, HP-UX and Solaris, Oracle Designer 2000, WebLogics Application Server, Symantec Visual Café, Entrust getAccess authentication software

3) OMG Seattle – Niagara Mohawk Power Monitoring System

Performance Tuning / Database Mentor

January 2001

OMG engaged Mr. King to perform an independent assessment of a system they were currently developing, and make recommendations for both performance and design improvements. This included presentations and discussions explaining the inner workings of the Oracle RDBMS, as well as recommendations to improve upon the maintainability and scalability of the current design.

Environment: Oracle 8.1.5 on Windows NT, MS Visual Basic

4) National Research Council of Canada – Industrial Research Assistance Program

Data Modeler / Database Administrator

January 2000 – July 2000

At IRAP, Mr. King served as a mentor for current staff who were tasked with obtaining the necessary skills to build and administer their own customer relations system. This included assisting in the decision making process for the design and development tools to use, as well as instruction on the tools eventually chosen. Considerable time was also spent on tuning and refining the data model provided by a previous team of consultants.

The resulting customer management system will be deployed on an intranet platform with a browser interface, and eventually exposed on the Internet, for client use.

Environment: Oracle 8.1.5 on NT, Oracle Designer 2000, Oracle Application Server

5) Calian Technology Services – Strategis Project

Database Designer / Administrator

November 1999 – June 2000

On the Strategis project, Mr. King was conducted an initial review of the existing data model, and design documents. His duties included specifying the physical architecture of the database, the setup and maintenance of separate development, test, and production environments, and maintenance of the physical and logical data models using Oracle CASE tools. He was also responsible for the coding and implementation of Java classes that required database access.

Mr. King also participated in the training of client resources in the areas of database administration, and maintenance.

Environment: Oracle J-Developer, Oracle 8i on HP-UX / NT, Oracle Designer 2000

Apache Web Server

6) National Research Council of Canada - CISTI

Application Designer / Database Programmer

March 1999 – June 2000

On the Intellidoc project, Mr. King was responsible for performing a evaluation of the existing data model, and design documents. Mr. King's work on the architecture helped the NRC move from a client oriented model for their new system, to a more server-centric, and table driven system. The results of this review were presented to all teams and project management for discussion, and later revision.

Mr. King was responsible for establishing standards for the development of PL/SQL on the project, and designing and implementing all libraries, functions, queries, and reports reused by other developers. Mr. King was eventually asked to lead a DBA group consisting of NRC employees and external consultants, to move the new system to production, as well as plan and restructure the existing databases in the branch for optimal performance.

The NRC also retained Mr. King to provide a two week course for staff, in Oracle PL/SQL Programming.

Environment: Visual Basic 6.0, Oracle 8.0.5 on HP-UX / NT, Oracle Designer 2000

Oracle Application Server, Oracle Developer Server

7) Department of Justice - Canadian Firearms Registration System

Senior Database Programmer

Dec. 1997 – January 1999

On the CFRS project, Mr. King functioned as lead PL/SQL and database developer, in a team of five other server-side programmers. He was responsible for establishing the framework for subsequent coding, standards and guidelines to be used, and hiring additional PL/SQL resources. He developed a large number of modules to implement business rules, supplement front end processing, and provide scheduled batch processing. Duties also included writing several Pro*C applications to manage interfaces to other government agencies.

After six months, Mr. King was asked to accept the additional role of DBA for five development and testing databases, while retaining his team leader role. This entailed the configuration and maintenance of several environments, as well as performance tuning on the development and production systems. Consultation and assistance was also given to the production DBA.

Environment: PowerBuilder 5, Oracle 7.3, HP-UX, Oracle Designer 2000, Windows NT

8) Nav Canada - AIRSS Project

Database Administrator

April 1997 – September 1997

Mr. King’s role on the AIRSS project was primarily that of database administrator, implementing and managing the physical database. In addition to his regular duties of user and resource management, Mr. King was also responsible for the development of stored procedures and triggers required to implement business rules and enforce data integrity. Situations often required working with development staff to assist in application design decisions, develop and tune custom SQL, or provide advice on how application logic should be partitioned between client and server.

Environment: PowerBuilder 5.2, Oracle 7.3, HP-UX, Windows NT

9) International Monetary Fund (State Tax Administration - Ukraine)

Computer Systems Technical Advisor

October 1994 – February 1997

As a technical advisor, Mr. King’s responsibilities varied widely from highly detailed and technical tasks, to solving administrative problems. His main objectives were to guide the local software developers from the initial stages of the project, incorporating modern software engineering principles, proposing and implementing an appropriate testing methodology, and overseeing the initial introduction of the computer system into a pilot site. This was later increased to almost 20 sites, utilizing an Oracle 7.3 / AIX client-server platform.

While deeply involved with the technical details of the project, Mr. King was also responsible for other administrative tasks such as process improvement in the development area, preparation of technical requirements for large tenders, and serving on selection committees.

Environment: Oracle 7.3, Oracle Developer 2000, AIX, Windows NT

10) Revenue Canada - GST

Senior Systems Analyst

March 1993 – October 1994

For Revenue Canada, Mr. King was part of a team composed of consultants and employees responsible for the maintenance and enhancement of the government's existing GST computer system. Mr. King performed all required work for fixes and enhancements, from the initial impact analysis, to the final migration of the affected system components.

The technical work performed by Mr. King was in an environment utilizing DB2, CICS, COBOL, OS/2, and CASE tools (ADW, IEW). Mr. King’s responsibilities also included planning and participating in quality reviews, training several new employees, and supervising their work.

Environment: DB2, CICS, COBOL, OS/2, ADW, IEW