Gary Belleville

*** ********* ****

Victoria, BC V9A 4K8

250-***-****

aboqww@r.postjobfree.com

Summary of Qualifications

. University of Waterloo graduate with a Computer Science major.

. Skilled at the following roles: BI Architect, Dimensional Modeler, Data Architect,

Metadata Layer Designer, ETL Developer and Reports Developer.

. Proficient with the SAP Business Objects suite including Data Services, Universe

Designer and Web Intelligence (Webi). Trained in BO Xcelsius.

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

. 16 years of experience with the Oracle database management system and two years with

SQL Server.

. Good working knowledge of Cognos Data Manager.

Work Experience

Jul 2012

to presentSr. BI Consultant (Independent), James Bay Consulting Inc

.

Ministry of Social Development

Sr. BI ConsultantJuly 2012

to present

Tools used: Cognos 10 -

Data Manager, Framework Manager, Reports Studio

Database used: Oracle 11g

Mar 2008

to Jun 2012BI 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 ArchitectSeptember 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 DesignerAugust 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 DeveloperJanuary 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 DesignerJuly 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 ArchitectMarch 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 2008Senior 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 ConsultantApril 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 DeveloperMay

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 LeaderApril 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 2001BC Ministry of Transportation

Web-Enabled Applications Project

Oracle Technology Consultant

Oracle Designer, Forms, Reports

Oracle

Apr 2000

to Mar 2001BC 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 1999Senior 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 1998Senior Consultant, Stellar Systems Group (now HP Advanced Solutions

)

Date

Client

Project

Role

Tools

Database

Dec 1997

to Mar 1998BC 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 1998BC Ministry of Transportation

Traffic Information System

Oracle Technology Consultant

Oracle Designer, Forms, Reports

Oracle

Apr 1997

to Mar 1998BC Ministry of Environment

Bathymetric Maps Enhancement Project

Project Manager

MS Project

N/A

Oct 1996

to Apr 1997BC Ministry of Transportation

Property Acquisition & Inventory System

Business Analyst / Data Architect

Oracle Designer

Oracle

Apr 1996

to Sep 1996BC Ministry of Environment

BC Geographic Names Information System

Technical Project Leader

Oracle Designer, Forms

Oracle

Sep 1991

to Mar 1996Senior Consultant, Sierra Systems

Date

Client

Project

Role

Tools

Database

Jan 1996

to Mar 1996BC Ministry of Transportation

Rockfall Hazard Rating System

Project Manager

MS Project

N/A

Jul 1994

to Mar 1996BC Ministry of Transportation

Property Acquisition Management System

Technical Project Leader

Oracle CASE, Forms, Reports

Oracle

Jul 1993

to Jul 1994BC Ministry of Transportation

Oracle Database and Tools Introduction

Oracle Database Consultant

Oracle CASE, Forms, Reports

Oracle

Jan 1993

to Jun 1993BC Office of the Ombudsman

Case Tracking System

Oracle Developer

Oracle CASE, Forms, Reports

Oracle

Sep 1991

to Dec 1992BC Ministry of Health

Practitioner Monitoring Systems

Business Analyst

PL/1

DB2

Other Work Experience

Date

Organization

Position

Tools / Languages

Database

May 1989

to Aug 1991McGill University

Senior Systems Analyst

Natural, Super Natural

ADABAS

Oct 1988

to May 1989Air Canada

Consultant / Systems Analyst

TSO, ISPF, PL/1

DB2

May 1986

to Aug 1988Sun 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 1982Royal 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

. 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

Contact this candidate