ETL Programmer/Analyst Consultant

Royal Bank Financial Group

October 2005 to Present

Mr. Wierdsma's responsibilities include analysis, design, architecture and development of ETL processes at this large financial institution while creating a contact centre reporting data mart. 

Tools: IBM Mainframe z/OS, ISPF, JCL, TeraData, Ascential DataStage 7.5 

ETL Programmer/Analyst Consultant

Direct Energy Essential Home Services Data Warehouse

 December 2003 to July 2005

Mr. Wierdsma reprised his role at Direct Energy.  Analysis and design was carried out.  He was responsible for modifying and creating new programs in DataStage.  Some Unix scripting was also performed. Mr. Wierdsma was charged with system integration testing and supported the business clients in user acceptance testing.  Performance tuning was performed as necessary.

Tools: MS Office 2000, Visio, Oracle 8i, Ascential DataStage 6.0, Harte-Hanks Trillium, TOAD, UNIX scripting

Data Modeler

Ontario Ministry of the Environment

October 2003 – November 2003

Mr. Wierdsma’s assignment was to create the data model and participate in the architecture of a data integration project.

Tools: Oracle 9i, Oracle Designer, TOAD

ETL Programmer/Analyst Consultant

Bell ExpressVu

September - October 2003

A brief assignment to complete some DataStage programs and implement the Certificate Tracking System.

Tools: Ascential DataStage 6.0, TOAD, UNIX scripting

ETL Programmer/Analyst Consultant

Direct Energy Essential Home Services Data Warehouse

May 2002 to June 2003

In this assignment, Mr. Wierdsma was initially charged with creating a technical feasibility document.  He then participated in product evaluations for a data cleansing tool while turning business requirements into technical specifications. He created necessary data mapping documentation.  He assisted the data architect in making modifications to the existing data model.  Mr. Wierdsma was responsible for ensuring the source extracts satisfied the specifications. He then created the code that loaded and transformed the resulting data into the appropriate tables in the data warehouse.  Created and modified scripts to run load programs. He performed unit and system integration testing.  Made performance tuning modifications as required.

 Tools: MS Office 2000, MS Project, Visio, Oracle 8i, SQL Server 2000, Ascential DataStage 6.0, Harte-Hanks Trillium, TOAD, UNIX scripting

Data Architect, Sprint Canada

ADSL Integration Project

December 2001 to April 2002

Mr. Wierdsma joined the data architecture department at Sprint for this assignment.  He participated in the creation of functional and technical specifications and created a logical data model of Sprint’s Siebel implementation.

Tools: Oracle 8.1.7, Siebel Tools, Tool for Oracle Application Developers (TOAD), ERWin 3.5.2, Rational Rose Professional Data Modeler Edition.

ETL Programmer/Analyst, RBC Insurance

LifeMAP Project

February 2001 to September 2001

 This assignment saw Mr. Wierdsma’s return to RBC insurance as an ETL developer on the LifeMAP application.  Responded to problem logs identified by the user acceptance testing team. Maintained data model & dictionary and made performance tuning modifications as necessary. Created scripts to schedule and run the extract and load code.  Participated in the production roll out of the application.

Tools: Oracle 8.1.7, PL/SQL, TOAD, SQL Server 7.0, Transact SQL

Programmer Analyst, Ontario Power Generation

MetCal Control System

October to December, 2000

Mr. Wierdsma created the functional and technical specifications for this client server application.  He created data model and dictionary. Created physical implementation of the database. Created stored procedures and front end code.

Tools: Centura Team Developer, Oracle 8.0.6. PL/SQL. Visio.

Data Analyst, Maxlink Communications

NIU Outages Project

August, September, 2000

A brief assignment where Mr. Wierdsma performed data analysis.  Data was extracted from UNIX based applications for and loaded into a RDBMS.  Reports were created according to user requirements. 

Tools: SQL Server 7.0, DTS

ETL Programmer/Analyst, RBC Insurance

WestMAP Project

June 1999 to June 2000

Mr. Wierdsma was part of the team that built a data warehouse for Westbury Canadian Life, now part of RBC Insurance. The team followed the methodologies presented by Ralph Kimbal in his two works that, for many, define the field as it is today, "The Data Warehouse Toolkit" and "The Data Warehouse Lifecycle Toolkit". Mr. Wierdsma’s main role was that of ETL specialist, designing the architecture for data extraction and loading and writing the technical load specifications. He participated in the creation of the data model and wrote the code to extract and load data into the data warehouse. He also created some of the OLAP reporting required by the client. 

Tools: Oracle Data Mart Suite, (Oracle 8.0.5, Oracle Web Server, Oracle Builder, Oracle Discoverer, Oracle Designer), PL/SQL, Microsoft Project, TOAD, SQL Server 7.0, Transact SQL

Database Developer/Administrator, Canadian Federation of Independent Business

Territory Management and Prospect Distillery System

April 1999 to June 1999

Initially, Mr. Wierdsma participated in the technical design and data modeling for this operation data store.  He then created the physical production RDBMS environment for the application.  He wrote upwards to 100 scripts to load extracted data into the production database and carried out performance tuning on the data load processes where necessary. Advised on the set up of a second system supplied by 3rd party vendor. 

Tools: SQL Server 6.5, 7.0, Windows NT, Visio

Team Leader, Programmer Analyst, Ministry of Economic Development, Trade and Tourism

Loan and Investment Tracking System, InfoCat, Ice Storm database, etc.

June 1998 to March 1999

Mr. Wierdsma’s roles were varied at the Ministry.  He supported a number of Lotus Notes production databases as a developer.  Mr. Wierdsma also lead a small team in the development of a client server application.  He created the functional and technical specifications as well as the data model.

Tools: Lotus Notes Domino 4.6, Lotus Script, JavaScript, Microsoft Access, ERWin.

Programmer Analyst, IBM

Volume Product Supply and Demand for Notes, Partner Information Supply System

November 1997 to June 1998

Mr. Wierdsma performed his familiar role of programmer analyst as he participated in the design and created the data model and dictionary. He performed maintenance of production code.

 Tools: Lotus Notes Domino 4.5

Team Lead, Programmer Analyst, Ontario Insurance Commission

Organizations and Individuals, Insurance Ombudsman Information Tracking System, etc.

June 1996 to October 1997

Mr. Wierdsma was involved in a number of roles at the commission.  He supported several production client server applications.  He was also tasked with taking over the lead of a team of programmers on a stalled development initiative.  He created functional and technical requirement, data models, data dictionaries.  He wrote code and physically implemented the RDBMS design.

Programmer Analyst, Comnetix Computer Systems

Automated Criminal Intelligence Information System II (ACIIS II)

April 1995 to May 1996

Mr. Wierdsma was responsible for making the interface of this client server application bilingual and programming the necessary front end.   He created a data dictionary.

 Tools: SQLWindows, Oracle 7

Programmer Analyst, Kraft General Foods Canada, Inc.

Blueprints

December 1994 to March 1995

Mr. Wierdsma wrote and maintained code & reports for this client server application

Tools: SQLWindows, SQLBase, and Netware

Project Leader, Programmer Analyst, Confederation Life Insurance Co.

November 1986  to November 1994

Mr. Wierdsma fulfilled a number of roles as a full time employee.  By 1994, he held the title Applications Assistant Manager.  He gained experience in a broad range of technologies from a 3090 IBM mainframe environment to PC based DOS programming and finally Windows-Netware based client server development.  Used such tools as PL1, VSAM, CICS, DB2, JCL, Clipper, SQLWindows and SQLBase.  Learned data modeling using System Architect, project scheduling using Microsoft Project, joint application design (JAD) and was trained in a number of project management methodologies