Resume for Bruce Williamson

Introduction

Contact

Address:



906/44 Shoreline Dr
Rhodes
NSW 2138
Australia 

Mobile:

+61 478 302-992

Email:

Bruce@Williamson.net.au

Interests

Rugby, golf, camping, fishing, photography, cooking, travelling, emerging technology and fund raising

Summary of Industry & Software Experience

Briefly

  • Over 27 years experience in the information & communications technology industry including 17 years database administration.
  • Experience includes all facets of database and systems administration including:
    • Application, SQL & database performance monitoring, analysis and tuning
    • Data modelling & database design
    • Procedure development
    • Technical support
    • Software installation & maintenance
    • Full systems development life cycle
    • Training & mentoring
  • Ability to communicate effectively at all technical, operational, administrative and management levels to provide innovative customer-centric solutions.
  • Capacity to adapt to new technologies, becoming productive in limited time frames.
  • Documented broad work experience as well as the expertise to work with little or no supervision but at heart very much a team player both in the work place and outside of it.

Industry

  • Banking
  • Government
  • Telecommunications
  • Transportation
  • Marketing
  • Healthcare
  • Mining
  • Retail
  • Energy

Software

  • DB2 10 for z/OS
  • SAP (Banking, Bank Analyzer, BW, ERP, Insurance, PI & SolMan)
  • SAP NetWeaver
  • DB2 Administration Tool
  • DB2 Automation Tool
  • DB2 Utilities Suite for z/OS
  • SPUFI (SQL Processor)
  • Omegamon Performance Expert for DB2
  • DB2 Buffer Pool Analyzer
  • Omegamon XE for z/OS
  • z/OS 2.1, TSO/ISPF, SDSF, TWS & JCL
  • Windows 8.1 & MS Office 2013
  • KNIME 2.11

Detailed Work History

Commonwealth Bank of Australia - Sydney, Australia

12/10 to Present - SAP DB2 Database Administrator

Employed by CBA to provide DB2 database administration services to the Core Banking system

Duties:

  • Designed CBM database REORG automation strategy based on ITSMO "Shift Left" initiative, to optimise database performance and eliminate customer impact
  • Implemented ITSMO REORG automation process in all sandpit, NFT (Non-Functional Test) and production systems, a total of 23 DB2 sub-systems managing hundreds of thousands of tables and indexes
  • Documented REORG automation SOP (Standard Operating Procedure)
  • Worked closely with IBM software engineers to improve the REORG utillity to meet CBA's 24/7 availability requirements
  • Implemented SQL queries for accurate monitoring and tracking of outstanding database housekeeping to facilitate better housekeeping practices
  • Liases with internal clients who utilise DBA services, providing detailed consultancy services and responses to problems and service requests
  • Attended zSAP VLDB Conference as CBA technical representative; approximately 10 customer requirements submitted; 4 out of the top 10 very high and high priority submissions voted by other zSAP customers as needing attention was more than any other attendee, confirming the value and recognition of attendance
  • Implemented process to capture DB2 SMF statistics and populate DB2 PM (Performance Management) database for easier access to performance data for reporting and problem diagnosis
  • Scheduling database housekeeping in the DBA Cockpit for all development, system test, UAT and staging environments
  • Provides constructive input into team meetings and mentors more junior members and new employees within the DBA area
  • Using RMF to collect performance data for z/OS and sysplex environments to monitor systems' performance behavior and to optimally tune and configure system according to business requirements

Environment:

  • DB2 10 for z/OS, DB2 Utilities Suite for z/OS, DB2 Administration Tool V11.1, DB2 Automation Tool V4.2, DB2 Recovery Expert V3.1, DB2 Buffer Pool Analyzer & SPUFI
  • z/OS 2.1, TSO, ISPF, JCL & TWS
  • SAP NetWeaver 7.30, SAP Banking, SAP Bank Analyzer, SAP Business Warehouse, SAP Enterprise Resource Planning, SAP Insurance, SAP Process Integration & SAP Solution Manager
  • Omegamon DB2 Performance Expert on z/OS V5.2, Omegamon XE on z/OS V4.1 & z/OS Resource Measurement Facility (RMF)
  • DB2 Performance Expert Client, IBM Data Studio V4.1 & RMF Spreadsheet Reporter Version 5.3

Allied Irish Banks - Dublin, Ireland

02/08 to 11/09 - DB2 Systems Programmer/Database Administrator - Contract

Contracted to AIB to provide DB2 systems programming and database administration services on the Acorn/iFlex, SmartDoc and Integrated Markup projects

Systems programming accomplishments included:

Database administration assignments on these projects included:

Environment:

Lloyds TSB Bank - London, UK

08/06 to 01/08 - DB2 Database Administrator - Contract

Contracted to Lloyds TSB Bank to provide database administration services on the OCIS, Internet Banking, BIT & Bank Letters projects.

Duties on these projects included:

Environment:

Bank of Ireland (HP Ireland) - Dublin, Ireland

05/01 to 10/05 - DB2 Database/Systems Administrator - Contract

Contracted to Hewlett-Packard Ireland to provide database and systems administration services to Bank of Ireland

Duties on the BoI Euro, CRM & Alnova projects included:

Environment:

Northern Territory Government - Darwin, Australia

10/00 to 05/01 - DB2 Database Administrator - Contract

Contracted to Northern Territory Government to provide database and systems administration services to DCIS Department of Corporate Information Services

Duties on the DCIS project included:

Environment:

IBM Global Services Australia - Brisbane, Australia

12/97 to 08/00 - DB2 Database Administrator - Contract

Contracted to IBM GSA to provide database administration and production support services to the START Street and Address Reference Tables and NPAMS Network Plant Assignment Management System projects. START is 1 of the 6 most mission critical applications within the Telstra organisation, with approximately 1.5 million CICS transactions/day and 25,000 registered users 8,000 concurrent. NPAMS is another mission critical application with approximately 1.3 million CICS transactions and 7000 concurrent users

Duties on the START project included:

Duties on the NPAMS project included:

Environment:

Summary of Employment

Period Organisation Position Location
| 04/97 - 10/97 | Burlington Northern and Santa Fe Railway | Analyst Programmer - Contract | Fort Worth, Texas, USA |
| 04/96 - 04/97 | RJ Reynolds | Analyst Programmer - Contract | Winston-Salem, North Carolina, USA |
| 12/92 - 04/96 | Telstra | Senior Analyst Programmer - Contract | Brisbane, Queensland, Australia |
| 03/92 - 10/92 | Comalco Mineral Products | Analyst Programmer - Contract | Brisbane, Queensland, Australia |
| 01/90 - 09/91 | Comtex Group Limited | IT Consultant | Wellington, New Zealand |
| 11/87 - 07/89 | Bougainville Copper Limited | Analyst Programmer - Contract | Brisbane, Queensland, Australia |
| 10/86 - 07/87 | M/V Jodimaro | 1st Mate | Fort Lauderdale, Florida, USA |
| 07/86 - 10/86 | Travelling around the US | | |
| 03/86 - 06/86 | Halfords Plc. | Analyst Programmer - Contract | Redditch, United Kingdom |
| 07/85 - 02/86 | Standard Bank S.A. Pty Ltd | Programmer | Johannesburg, South Africa |
| 01/84 - 06/85 | Total S.A. Pty Ltd | Programmer - Analyst Programmer | Johannesburg, South Africa |
| 01/83 - 12/83 | Travelling around Ireland, Europe and the UK | | |
| 01/80 - 12/82 | Anglovaal Pty Ltd | Learner Mine Official | Stilfontein, South Africa |
| 01/79 - 01/80 | 1 Rhodesian Special Air Service Regiment | National Service | Kabrit Barracks, Salisbury, Rhodesia |

Education

Date Course Institution
| 06/15 | Experimentation: Advanced Proficiency Level | CBA |
| 03/15 | Data Analytics: SOUND Proficiency Level | CBA |
| 10/14 | Design Thinking: AWARENESS proficiency level | CBA |
| 09/14 | DB2 10 DBA for z/OS (Exam Certified) | IBM |
| 09/14 | DB2 10.1 Fundamentals (Exam Certified) | IBM |
| 05/13 | ES Breakthrough Service Performance | CBA |
| 05/13 | The Four Productivity Habits | CBA |
| 04/13 | Productivity Essentials | CBA |
| 05/03 | Alnova Application Back-End Development | Alnova Technologies |
| 04/03 | MainView for DB2 | BMC Software |
| 04/03 | Log Master for DB2 | BMC Software |
| 03/03 | DASD Manager for DB2 | BMC Software |
| 03/03 | Change Manager for DB2 | BMC Software |
| 03/03 | Catalog Manager for DB2 | BMC Software |
| 06/02 | UNIX System Administration | Thomson Learning |
| 05/02 | Introduction to UNIX | Thomson Learning |
| 03/02 | Fast Path to DB2 UDB for Experienced Relational DBAs | IBM |
| 06/99 | DB2 High Performance Design | RYC Inc - DB2 Symposium |
| 06/99 | Advanced & Complex SQL | RYC Inc - DB2 Symposium |
| 06/99 | Advanced DB2 Programming - Techniques for Performance | RYC Inc - DB2 Symposium |
| 06/99 | Advanced DB2 Programming - Triggers, Stored Procedures & UDFs | RYC Inc - DB2 Symposium |
| 03/95 | Navigator Practitioner Overview | Ernst & Young |
| 03/91 | Business Systems Analysis | Software Education |
| 08/90 | Netware Systems Manager CNE | Comtex |
| 07/90 | Structured Systems Analysis | Software Education |
| 07/85 | TSO/ISPF Introduction | Standard Bank |
| 07/85 | MVS/XA Introduction | Standard Bank |
| 07/85 | OS JCL Coding | Standard Bank |
| 07/84 | NATURAL Applications Workshop | SPL |
| 07/84 | ADABAS Concepts and Facilities | SPL |
| 01/84 | Structured Programming and Design | van Zyl and Pritchard |
| 12/82 | National Diploma 2nd year - Metalliferous Mining | Witwatersrand Technikon |
| 12/78 | AEB 'M' Levels | Guinea Fowl School |