Gary Belleville

 

Victoria, BC

(250) 884-2726

gbelleville@shaw.ca

 

Summary of Qualifications

 

·         University of Waterloo graduate with a Computer Science major.

·         Former Technology Leader in Sierra Systems’ BI Practice.

·         Strong proponent of the Kimball Methodology and well-versed in BI/DW fundamentals.

·         Skilled at the following roles: Data Architect, BI Architect, Dimensional Modeler, Metadata Layer Designer, Reports Developer and ETL Developer.

·         Proficient with Sparx Enterprise Architect, Cognos suite of tools (Report Studio, Framework Manager and Data Manager) and SAP Business Objects suite (Data Services, Universe Designer and Web Intelligence).

·         Working knowledge of SQL Server (2014) Integration Services (SSIS).

·         18 years of experience with the Oracle database management system and two years with SQL Server.

 

Work Experience

 

Oct 2013 to Dec 2014      Sr. Consultant, Vivid Solutions Inc.

Ministry of Forests Lands and Natural Resources – Sr. Database Consultant

October 2013 to December 2014

Database used: Oracle 12c

·         Evaluated Oracle 12c temporal features to support valid time / transaction time.

·         Developed best practices for importing custom audit data into an Oracle 12c Flashback Data Archive.

·         Wrote best practices manuals for temporal/spatial data modeling and temporal data conversion.

·         Managed SRs to report Oracle bugs with Oracle 12c temporal features.

·         Wrote a manual to document issues found with Oracle 12c temporal features.

 

Ministry of Forests Lands and Natural Resources – Sr. Data Architect

October 2013 to December 2014

Tools used: Sparx Enterprise Architect 11 / 10

·         Collected requirements and built domain models in Enterprise Architect.

·         Devised a technique for turning domain models into detailed logical data models in Enterprise Architect (EA).

·         Developed custom EA templates for the DDL Transformation facility.

·         Transformed logical data models into physical data models in EA.

·         Generated DDL from EA and implemented physical models in Oracle 12c.

·         Performed a gap analysis on the Common Client domain model and modified the model in Enterprise Architect.

Jul 2012 to Sep 2013        Sr. BI Consultant (Independent), James Bay Consulting Inc.

Ministry of Social Development – Sr. BI Consultant

Tools used: Cognos 10 - Report Studio, Framework Manager, Data Manager

Database used: Oracle 11g

·         Developed complex performance measurement reports using Report Studio.

·         Created and enhanced Framework Manager models.

·         Developed ETL using Cognos Data Manager and PL/SQL.

·         Designed and implemented a dimensional model.

 

Mar 2008 to Jun 2012       BI Practice Technology Leader, Sierra Systems

Intergraph Canada – BI Architect / Technical Lead for Niche RMS BI Project

February 2011 to June 2012

Tools used: (SAP) Business Objects - Data Services, Universe Designer and Webi

Database used: SQL Server 2008

·         Led a team of ETL and BI developers and mentored them on BI/DW best practices.

·         Designed dimensional data structures and wrote ETL specifications.

·         Designed and developed the metadata layer using BO Universe Designer.

·         Developed reports using Webi.

·         Designed the ETL process structure for incremental builds of fact and dimension tables.

·         Developed ETL processes using BO Data Services.

 

Quebec Ministry of Justice – Data Architect

September 2010 to January 2011

Tool used: Oracle Designer

Database used: Oracle 11g                                    

·         Led a team of three Data Architects implementing significant customizations to the physical data model of two large applications originally built for the Province of BC.

 

BC Ministry of Finance (Income Taxation Branch) – Dimensional Modeler

June 2010 to August 2010

Tool used: Pentaho Data Integration (open source)

Database used: Oracle 10g                                    

·         Designed four dimensional models (star schemas) and created detailed ETL specifications.

 

BC Ministry of Attorney General (Court Services) – XML Schema Designer

August 2009 to May 2010

Tool used: Eclipse IDE

Database used: Oracle                                           

·         Developed XML standards and XML schemas for e-filed court documents. These standards and schemas utilized many features of the National Information Exchange Model (NIEM) as defined by the US Department of Homeland Security.

 

BC Ministry of Attorney General (Court Services / MCFD) – ETL Developer

January 2009 to March 2009

Tools used: Cognos Data Manager, Report Studio and Framework Manager

Database used: Oracle                                           

·         Developed ETL processes (fact and dimension builds) using Cognos Data Manager.

·         Developed reports using Cognos Report Studio and Framework Manager.

 

BC Ministry of Housing and Social Development – Workflow Designer

July 2008 to December 2008

Tool used: SharePoint Designer

Database used: SQL Server                                   

·         Designed and implemented SharePoint workflows, including custom SharePoint lists to support the workflows.

·         Facilitated design review workshops.

 

BC Ministry of Attorney General (Facilities Services) – Data Architect

March 2008 to June 2008

Tool used: Oracle Designer

Database used: Oracle                                           

·         Gathered business requirements and defined the logical data model for a financial application.

 

Oct 1999 to Feb 2008 Senior Consultant (Independent), James Bay Consulting Inc.

BC Ministry of Attorney General – Data Architect

October 2003 to February 2008

Tools used: Oracle Designer, Oracle Application Express, Oracle Forms / Reports

Database used: Oracle

·         Developed automated reports to verify that logical data models and physical database designs followed the Ministry’s Data Architecture standards.

·         Developed a system to send automated e-mails to the Data Architecture Group summarizing the changes made to database objects in all Oracle databases.

·         Designed and developed an intranet application to allow Oracle Designer metadata to be easily viewed by Data Architects and developers.

·         Built automated reports to identify the differences between two logical data models or two database designs in Oracle Designer.

·         Performed the business analysis, design and development of an application that captured Quality Assurance comments made by Ministry Data Architects.

·         Performed Quality Assurance on logical and physical data models.

BC Ministry of Transportation – Oracle Technology Consultant

April 2001 to March 2006

Tools used: Oracle Designer, Discoverer, Forms and Reports

Database used: Oracle                                           

·         Provided consulting expertise and support for the Oracle Forms Services, Reports Services, Designer and Discoverer products.

·         Supplied technical support to developers on web application issues.

·         Developed a utility to compare data structures in an Oracle database schema to the physical model stored in an Oracle Designer repository.

·         Developed best practices manuals for using the Oracle tools and for upgrading to later releases.

·         Developed standardized Forms/Reports code for all Ministry applications.

 

BC Ministry of Advanced Education – Senior Oracle Developer

May to September 2003

Tools used: Web PL/SQL, Oracle Forms and Reports

Database used: Oracle

·         Developed a web application using custom-built Web PL/SQL modules.

 

BC Ministry of Finance (Provincial Treasury) – Technical Project Leader

April 2001 to January 2003

Tools used: Oracle Designer, Headstart, Oracle Forms and Reports

Database used: Oracle

·         Designed the technical architecture for the Debt Management System.

·         Configured the tools in the development environment.

·         Performed Quality Assurance duties on data and function models.

·         Mentored Business Analysts on the use of Oracle Designer.

 

Other client projects as an independent consultant:

 

Date

Client

Project

Role

Tools

Database

Jun 2000 to Mar 2001

BC Ministry of Transportation

Web-Enabled Applications Project

Oracle Technology Consultant

Oracle Designer, Forms, Reports

Oracle

Apr 2000 to Mar 2001

BC Ministry of Transportation

Oracle 8i Standards

Oracle DB Consultant

Oracle Designer

Oracle

Feb 2000 to Mar 2000

BC Ministry of Transportation

Property Acquisition & Inventory System

Sr. Oracle Developer

Oracle Designer, Forms, Reports

Oracle

Oct 1999 to Jan 2000

Alberta Distance Learning Centre

Student Administration System

Sr. Oracle Developer

Oracle Designer, Forms

Oracle

 

May 1998 to Mar 1999     Senior Information Specialist, EDS Canada (now HP Advanced Solutions)

Elections BC, EIS Project

May 1998 to Mar 1999

Tools used: Oracle Designer

·      Gathered and documented high-level functional requirements.

·      Facilitated workshops in which requirements were reviewed and refined.

·      Planned the analysis, training and user acceptance activities.

 

Apr 1996 to May 1998      Senior Consultant, Stellar Systems Group (now HP Advanced Solutions)

 

Date

Client

Project

Role

Tools

Database

Dec 1997 to Mar 1998

BC Ministry of Environment

Tenure Billing System

Business Analyst / Data Architect

Oracle Designer

Oracle

Sep 1997 to Dec 1997

BC Ministry of Attorney General

Jury Management System

Business Analyst / Data Architect

Oracle Designer

Oracle

Aug 1997 to Nov 1997

BC Ministry of Environment

Bathymetric Maps Web Project

Project Manager

MS Project

N/A

Apr 1997 to Mar 1998

BC Ministry of Transportation

Traffic Information System

Oracle Technology Consultant

Oracle Designer, Forms, Reports

Oracle

Apr 1997 to Mar 1998

BC Ministry of Environment

Bathymetric Maps Enhancement Project

Project Manager

MS Project

N/A

Oct 1996 to Apr 1997

BC Ministry of Transportation

Property Acquisition & Inventory System

Business Analyst / Data Architect

Oracle Designer

Oracle

Apr 1996 to Sep 1996

BC Ministry of Environment

BC Geographic Names Information System

Technical Project Leader

Oracle Designer, Forms

Oracle

 

Sep 1991 to Mar 1996      Senior Consultant, Sierra Systems

 

Date

Client

Project

Role

Tools

Database

Jan 1996 to Mar 1996

BC Ministry of Transportation

Rockfall Hazard Rating System

Project Manager

MS Project

N/A

Jul 1994 to Mar 1996

BC Ministry of Transportation

Property Acquisition  Management System

Technical Project Leader

Oracle CASE, Forms, Reports

Oracle

Jul 1993 to Jul 1994

BC Ministry of Transportation

Oracle Database and Tools Introduction

Oracle Database Consultant

Oracle CASE, Forms, Reports

Oracle

Jan 1993 to Jun 1993

BC Office of the Ombudsman

Case Tracking System

Oracle Developer

Oracle CASE, Forms, Reports

Oracle

Sep 1991 to Dec 1992

BC Ministry of Health

Practitioner Monitoring Systems

Business Analyst

PL/1

DB2

Other Work Experience

 

Date

Organization

Position

Tools / Languages

Database

May 1989 to Aug 1991

McGill University

Senior Systems Analyst

Natural, Super Natural

ADABAS

Oct 1988 to May 1989

Air Canada

Consultant / Systems Analyst

TSO, ISPF, PL/1

DB2

May 1986 to Aug 1988

Sun Life (formerly The Mutual Group)

Senior Programmer / Analyst

TSO, ISPF, PL/1

IMS, DB2

May to Aug 1985

Sun Life (formerly The Mutual Group)

Programmer/Analyst (Co-op Student)

TSO, ISPF, PL/1

IMS, DB2

Jan to Apr 1984,

Sep to Dec 1984

Sun Life (formerly The Mutual Group)

Programmer/Analyst (Co-op Student)

TSO, ISPF, PL/1

IMS

May to Aug 1983

Crowntek Sales Inc.

Systems Engineering Rep. (Co-op Student)

SPF, COBOL

IMS

Jan to Apr 1982,

Sep to Dec 1982

Royal Trust

Programmer (Co-op Student)

SPF, COBOL

IMS

 

Post-Secondary Education

 

University of Waterloo, Waterloo Ontario

·      Bachelor of Mathematics (Honours, Co-op).

·      Computer Science major, Combinatorics and Optimization minor.

·      Over-all average of 82%.

 

Ongoing Education

 

·      SQL Server (2014) Integration Services (SSIS) Tutorial

·      Business Objects Data Services – Core Concepts

·      Business Objects Data Services – Advanced

·      Business Objects Universe Design

·      Business Objects – Advanced Universe Design

·      Business Objects Web Intelligence (Webi) Report Design

·      Business Objects Xcelsius 2008 Enterprise: Core

·      OBIEE11g Foundation Workshop

·      National Information Exchange Model (NIEM) Certification - U.S. DoJ and Homeland Security

·      Cognos 8 BI Data Manager: Building Datamarts with Enterprise Data

·      Oracle Data Warehouse Database Design

·      Oracle Data Warehousing Fundamentals

·      Oracle Application Express (formerly HTML DB)

·      OracleAS Portal 10g: Build Corporate Portals

·      Oracle Development Tools User Group (ODTUG) Conference – 2006, 2005, 2003, 2002, 2001, 1997

·      2004 International Oracle User Group Conference

·      ODTUG Oracle9i JDeveloper Certification

·      CDM RuleFrame / Oracle Headstart

·      Oracle Web Application Server: Develop Web-Based Applications (V4.0.8)

·      Oracle Web Application Server: Administration (V4.0.8)

·      Effective Use Case Analysis (Riverton Software)

·      Object-Oriented Analysis and Design (Riverton Software)

·      Use Case Analysis using HOW (Riverton Software)

·      Component Design using HOW (Riverton Software)

·      Management Essentials (EDS Canada)

·      Project Management (Sierra Systems)

·      Data Modeling (Alec Sharp)

·      Oracle Designer/2000: System Modeling and Data Design

·      1995 International Oracle User Week

·      Oracle 7: New Features and Options