Sql Server Data

Enbridge Consumers Gas Brewers Retail AT&T Canada Workers Compensation Board

Extracurricular

**********@**********.***

Tim Johnson

Tim has extensive experience in a variety of relational database environments across a broad range of operating systems, databases, software products, and services. Having spent a number of years specializing in all aspects of installation and implementation of DB2 for MVS, he has subsequently expanded this experience into the UNIX and Client/Server environments. Tim has been involved with the design, and implementation of Client/Server and Data Warehouse applications, using Windows based Client workstations accessing Sybase, Teradata, Oracle, and most recently DB2 for OS/390. Tim is an IBM Certified Solutions Expert - DB2 UDB V6 Database Administration, and also a Certified Sybase Professional DBA (CSPDBA) for Sybase System 11. In addition, he has been involved in the establishment of the Data Administration function, including the development of standards, and the implementation of data modelling and data dictionary tools. He has worked in several different functional areas including application development, development support, database administration, technical and production support. He has been involved in the design and implementation of corporate Data Warehouse applications, requiring specialized modelling and design techniques, and has published an article in the IDUG Solutions Journal, based on these experiences. Tim has been on the executive of the Toronto based Central Canada DB2 Users Group, since its formation at the end of 1985, and is currently the Chair and Webmaster for the Users Group. He was also actively involved with the startup of the Ontario Sybase User Group in 1995, and held the position of the President of the group until November 1997. Involvement with the local DB2 Users Group has also lead to a post with the International DB2 Users Group (IDUG), as chair of the 1998 and 1999 IDUG Technical Symposia in Canada. Active participation the Users Groups has given him valuable exposure to many other DB2 and Sybase user organizations and professionals. EDUCATION: University of Bristol, B.Sc. (Hons) Chemistry Enbridge Consumers Gas Role: Database Specialist, October 1995 - Present Responsibilities: 1 support the development and implementation of Enbridge Consumers Gas new Customer Information and Billing System, including DB2 database design, application SQL design, data conversion, performance analysis and tuning, backup and recovery, maintenance of project data dictionary and data models 2 support the testing of existing Consumers Gas applications for compliance with Y2K requirements 3 support development and implementation of Corporate Data Warehouse environment using SQL Server 11 for UNIX, and Replication Server with DB2 Rep. Agent 4 support development and implementation of various applications using Sybase SQL Server including: various software packages; an Internet application for Gas trading; an Intranet application for Information Management using HAHTsite; Corporate PC audit database 5 develop standards and procedures for definition of security business rules, and implementation of database security through stored procedures 6 develop procedures for database administration and Sybase database design Technical Environment: DB2, Sybase SQL Server 11, OS390/TSO/ISPF, Windows NT, UNIX, Sybase Replication Server, ERwin, Sybase Open Client, SQL Backtrack Brewers Retail Role: Database Specialist, August 1995 - December 1995 Responsibilities: 1 develop backup, recovery, statistics and space management procedures 2 assist with Sybase implementation procedures for roll out of retail store Point of Sale equipment across province of Ontario Technical Environment: Sybase SQL Server 10, Windows NT 3.51, Uniface AT&T Canada (Unitel Communications) Role: Data Analyst and Database Administrator, January 1993 - July 1995 Responsibilities: 1 act as DA and DBA for implementation of data replication environment, migrating data from operational DB2 database to operational Oracle platform 2 act as DA and DBA for implementation of Corporate Information Warehouse environment using Teradata and Oracle RDBMSs 3 Create Information Warehouse database tables; assist with extraction of existing DB2 data, reformat and load into Information Warehouse; tune database for optimum performance of critical business queries 4 Assist with development and implementation of Information Warehouse operational procedures Technical Environment: Oracle 7.1, Teradata, DB2/2, DB2, SQL, QMF, Bachman Analyst & DBA, OS/2, UNIX, TCP/IP, ODBC, Microsoft Office, MVS, TSO/ISPF, CICS Workers Compensation Board Role: DB2 Specialist, September 1990 - December 1992 Responsibilities: 1 provided DB2 support for development of new Corporate Information database, and Revenue application, including database and application design reviews, program reviews, performance tuning and problem resolution 2 assisted with installation and implementation of new DB2 development environment, including system backup and recovery procedures 3 assisted with development and enhancement of DB2 standards, procedures, and guidelines; and implementation of a variety of DB2 tools 4 assisted with migration of Image Plus application from DB2 v2r1 to DB2 v2r2 5 provided DB2 support for operation of Production Image processing application Technical Environment: DB2, MVS/ESA, SQL, CICS/COBOL, DB2PM, TMON/DB2, DB/ProEdit, TSO/ISPF, CLIST, WordPerfect, Lotus 123, Prokit Workbench

Imperial Life Assurance Role:

DB2 Specialist, October 1985 - April 1989 Responsibilities: 1 managed Development and Database Support staff 2 developed Data Administration standards and guidelines 3 implemented data modeling tools, standards and guidelines 4 DB2 system and database administration 5 developed DB2 standards and guidelines Technical Environment: MVS, DB2, SQL, QMF, CICS/COBOL, CLIST, EXCELERATOR, PROFS Mars Group Services (UK

) Role:

DB2 Specialist/Project Leader, September 1981 - September 1985 Responsibilities: 1 installed DB2, and established environment 2 designed and developed pilot DB2 application 3 monitored and tuned DB2 environment 4 DB2 application and system support 5 provided support for CICS/PL1/DL1 programming Technical Environment: MVS, DB2, SQL, QMF, CICS/PL1, IMS DB, TSO/ISPF, CLIST, DCF/SCRIPT, REXX, DataManager Back to the Top