Rogers Communications Incorporated June 2009 to Present Mr. Wierdsma performed the role of ETL architect while working on the EDW project. Mr. Wierdsma was responsible for creating the ETL architecture artifacts and ensuring the standards and quality of the ETL deliverables. Mr. Wierdsma supervised the overseas development teams and was charged with accepting their deliverables.
Tools: UNIX, TeraData v6, Informatica Power Center 8.6.1
ETL Programmer/Analyst Consultant
RBC October 2005 to March 2009 Mr. Wierdsma performed the role of application architect, technical lead and ETL developer while successfully delivering a number of projects of varying sizes while employed by this large financial institution. Mr. Wierdsma created the ETL design documents, ETL data flows, reviewed the logical & physical data models and mapping documents and created implementation documentation while coding the solution.
Tools: IBM Mainframe z/OS, ISPF, JCL, TeraData v6, IBM WebSphere DataStage Enterprise Edition 7.5, Mercury Quality Centre
ETL Programmer/Analyst Consultant
Direct Energy Essential Home Services Data Warehouse December 2003 to July 2005
Mr. Wierdsma reprised his role at Direct Energy. Architecture was determined. 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. All project related documentation, including the implementation plan, was created by Mr. Wierdsma.
Tools: MS Office 2000, Visio, Oracle 8i, Ascential DataStage 6.0, Harte-Hanks Trillium, Tool for Oracle Application Developers (TOAD), UNIX scripting, Mercury Quality Centre
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.
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 8i, Siebel Tools, TOAD, ERWin 3.5, 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. He responded to problem logs identified by the user acceptance testing team. He maintained data model & dictionary and made performance tuning modifications as necessary, created scripts to schedule and run the extract and load code. Finally,Mr. Wierdsma participated in the production roll out of the application.
Tools: Oracle 8i, PL/SQL, TOAD, SQL Server 7.0, Transact SQL
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
LifeMAP 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 Kimball 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, 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 operational 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.
Tools: SQL Server, 7.0, Windows NT, Visio
Programmer Analyst, Architect, Team Lead, Various Clients
Lotus Notes Applications June 1996 to March 1999
Mr. Wierdsma designed and developed several Lotus Notes applications during his tenure at Ontario Insurance Commission, IBM and the Ministry of Economic Development, Trade and Tourism. This period also Mr. Wierdsma return to his role of team lead and architect for several projects.
Programmer Analyst, Client Server Applications, Various Clients April 1995 to October 1999, October to December, 2000
Mr. Wierdsma was involved in the development of a number of client server applications using GUI development software and various RDBMS databases. Experience in the retail sector was gained while working at Kraft General Foods. A contract at Comnetix Computer Systems saw Mr. Wierdsma develop an application for the RCMP. Time spent with the Ontario Insurance Commission and Ontario Power Generation garnered Mr. Wierdsma experience in the public sector.
Tools: SQLWindows, Oracle 7, PL/SQL, SQLBase, and Netware, MS SQL Server, Transact SQL, ERWin, Visio
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, including programmer analyst, architect, team lead, etc. 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. Mr. Wierdsma used such tools as PL1, VSAM, CICS, DB2, JCL, Clipper, SQLWindows and SQLBase. He also 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.
