Manager Data

GREG DORVAL

PROFILE

Mr. Dorval has played many roles throughout his successful career -

software architect, data modeller, project manager, BI architect, and big

data solutions consultant. His biggest strength no matter what the role is

his creativity and innovation. He won two awards for innovation during his

time at Cognos and IBM. He has a rather unique ability to see things from

the perspective of the different personas for which he designs and to

architects solutions that provide a truly outstanding user experience. He

thrives on collaborating on a vision and then diving deep to flesh out the

details. He prides himself on his ability to come up with truly elegant

solutions to complex problems. His references will attest that he always

shines a different sort of light on things and that he has the superior

critical thinking skills and creativity to deliver high quality, innovative

solutions to any problem. He is an expert in crafting data driven

solutions and has gained experience over the years coding in Java and

Python, designing relational, multi-dimensional, NoSQL and graph databases,

designing components in multi-tier and services oriented architectures. He

is looking for a new challenge that will bring out the best in his problem

solving skills.

Security Clearance

Level: Secret

File No: 95724695

Expiry: 25-Oct-2021

Education

1994 - 1998, Bachelor of Computer Science - Combined Honors Computer

Science and Mathematics

Carleton University, Ottawa, ON, Canada

Awards & Patents

2005 Cognos Innovation Award for my contribution to the design of the

Adaptive Analytic Framework

2006 Cognos Award of Excellence for my design and prototype of a relative

time reporting solution for dimensionally modeled relational data in

Framework Manager

US Patent 7,720,804 -Method of generating and maintaining a data warehouse

Certifications

IBM Certified Designer - Cognos 10 BI Reports

IBM Certified Developer - Cognos 10 BI Metadata Models

Professional Experience

Project # 1

Qlevor and Brisqq

Advisor - Software and data architecture

May 2014 - Present

Qlevor is a local Ottawa startup that is developing a collaborative cloud

computing platform and applications to capture organizational knowledge and

measure the value of individual contributions, as well as team task

management, social feed and messaging. Mr. Dorval is one of three

cofounders and has contributed significantly to the original concept, the

high level design as well as the design of a massively scalable system and

data architecture.

Brisqq is an international startup that is providing a crowd-based solution

to the last mile delivery problem. Mr. Dorval has been involved since

inception, contributing the overall concept, system design and

architecture. His primary role has been to provide advice and guidance to

the development team on implementing a highly scalable, reliable, available

and responsive data platform.

Project # 2

Cloudera

Solutions Consultant

February 2014 - August 2014 (7 months)

At Cloudera Mr. Dorval harnessed his passion for big data to deliver high

quality data solutions to Cloudera customers. He has been on numerous

customer engagements with varying data requirements. In his role as a

solutions consultant he not only designed and implemented solutions but

also lead each project, managing all of the resources and deliverables.

Each engagement entailed architecting data marts and the ETL processes to

drive them on Cloudera's enterprise data hub, based on Hadoop. He re-

engineered an Oracle solution to Hadoop that delivered over 100x

performance improvement and data throughput, allowing them to scale as

their business grows. He also implemented a web store analytics solution

that integrated weblog data with online transactional data.

. Reviewed customer requirements, developed implementation strategies

and recommended solutions based on industry best practices

. Presented strategies, concepts and solutions to senior executives,

internal and external clients, business partners and end users

. Modeled, designed and developed data marts on Cloudera's Hadoop

enterprise data hub

. Educated customers on Cloudera technologies;

. Managed project resources and deliverables, including authoring and

maintaining project management documents;

. Installed and configured Cloudera CDH;

. Responsible for Hadoop administration and performance tuning;

. Developed MapReduce jobs to process and transform data;

. Modeled and developed HBase applications;

. Designed Sqoop jobs to import and export data;

. Implemented Flume agents to stream data;

. Developed Oozie workflows to streamline and manage data processing.

Technologies: Cloudera CDH 4 and 5, MapReduce, Parquet and Avro file

formats, Java, J2EE, Hibernate, Spring, Eclipse, Sqoop, Flume, HBase, Oozie

Project # 3

Niagara Water

Senior Business Intelligence Architect / Data Warehouse Architect

March 2013 - February 2014 (12 Months)

Mr. Dorval implemented a customized sales analytics application, inventory

data mart, pricing analysis application, supply chain analysis, and

transportation management application, all on the Cognos 10 BI platform and

Oracle 11g RDBMS. He was responsible for gathering requirements, modeling

and architecting the data warehouse, developing the ETL and Framework

Manager models, and designing and developing reports and dashboards. He

also documented a roadmap to moving towards a big data solution on Netezza

and Cognos Dynamic Cubes.

. Gathered and analyzed business requirements from participating teams,

stakeholders and management

. Modeled, designed & developed multi-dimensional data marts and BI

solutions based on analysis of requirements;

. Presented strategies, concepts and solutions to senior executives,

internal and external clients, business partners and end users

. Defined and documented dimensional modeling conventions and best

practices

. Managed project resources and deliverables, including authoring and

maintaining project management documents

. Worked with management and IT infrastructure team to define and

implement a data management strategy for data warehousing

. Produced technical architecture document, detailing end to end

solution architecture

. Developed logical and physical data models for Sales, Pricing,

Inventory, Finance and Transportation data marts

. Implemented metadata models in support of data warehouse design

. Optimized data warehouse performance on Oracle 11g database

. Implemented IBM Cognos Customer Performance analytic application on

Adaptive Warehouse

. Optimized report and data warehouse performance using aggregates,

indexes and query tuning

. Defined and documented ETL best practices in ETL architecture document

. Developed technical ETL specifications, including source to target

mappings and transformation rules

. Developed ETL code and processes with IBM Cognos Adaptive Warehouse

and shell scripts;

. Implemented Cognos Framework Manager models using industry best

practices;

. Designed and developed dashboards using IBM Cognos Business Insight

. Implemented OLAP cubes using Cognos Transformer;

. Mentored other consultants and employees on Cognos best practices and

performance tuning

. Designed and developed analytic reports using Cognos 10;

. Administered and managed security for all Cognos environments

. Developed advanced Report Studio reports using custom HTML, XML,

JavaScript and CSS.

Technologies: Adaptive Warehouse 10.1, Framework Manager 10.1, Data Manager

10.1, Report Studio 10.1, Oracle 11g, Netezza

Project # 4

Canadian Internet Registration Authority

Senior Business Intelligence Architect / Data Warehouse Architect

August 2012 - February 2013 (6 months)

Mr. Dorval designed and architected additions to the Oracle 11g data

warehouse, including several data marts, merged existing Framework Manager

models into a single model that applied industry best practices, and he

designed and developed reports and dashboards. He also managed the upgrade

from Cognos 8.4 to 10.2.

. Implemented complex BI solution to analyze top level domain market

data;

. Managed project resources and deliverables, including authoring and

maintaining project management documents;

. Gathered and analyzed business requirements from participating teams,

stakeholders and management;

. Modeled, designed & developed multi-dimensional data marts and BI

solutions based on analysis of requirements;

. Presented strategies, concepts and solutions to senior executives,

internal and external clients, business partners and end users

. Defined and documented dimensional modeling conventions and best

practices;

. Produced technical architecture document, detailing end to end

solution architecture;

. Implemented metadata models in support of data warehouse design;

. Developed logical and physical data model for Oracle data warehouse;

. Designed and developed dimensional data warehouse models;

. Implemented Cognos Framework Manager models using industry best

practices;

. Defined and documented ETL best practices in ETL architecture

document;

. Developed technical ETL specifications, including source to target

mappings and transformation rules;

. Developed ETL code and processes with Data Manager, PL/SQL procedures,

and shell scripts;

. Designed and developed dashboards using IBM Cognos Business Insight;

. Implemented OLAP cubes using Cognos Transformer;

. Researched and developed best practices for metadata modeling, ETL

development and report design;

. Lead upgrade from Cognos 8 to Cognos 10.2;

. Designed and developed dashboards using IBM Cognos Workspace;

. Designed and developed analytic reports using Cognos 10;

. Developed advanced Report Studio reports using custom HTML, XML,

JavaScript and CSS;

. Lead big data initiative for analysis of DNS traffic.

Technologies: Framework Manager 8.4 & 10.2, Data Manager 8.4 and 10.2,

Report Studio 8.4 & 10.2, Cognos Transformer 8.4, Motio CI, Oracle Designer

Project # 5

Canada Post Corporation

Manager, ETL Development

April 2012 - August 2012 (5 months)

At CPC Mr. Dorval was responsible for the design and development of ETL

processes feeding into the Microsoft SQL Server data warehouse, using SAS

Data Integrator.

. Designed and developed ETL processes;

. Developed technical ETL specifications, including source to target

mappings and transformation rules;

. Lead requirements gathering and analysis process with business users;

. Presented strategies, concepts and solutions to senior executives,

internal and external clients, business partners and end users

. Collaborated with team members to produce technical design

specifications;

. Worked with various teams to define and implement a data management

strategy ;

. Developed data models for ETL data flows and data warehouse.

Technologies: SAS Data Integrator, MS SQL Server

Project # 6

Attain Insight

Senior Business Intelligence Consultant

November 2011- December 2012 (13 months)

Mr. Dorval worked on several small projects through Attain Insight where he

was called upon as a senior consultant to provide solutions that

demonstrate the value of a Cognos BI solution.

. Implemented complex operational BI solution to monitor government

grants for innovation

. Gathered and analyzed business requirements from participating teams,

stakeholders and management;

. Modeled, designed & developed multi-dimensional data marts and BI

solutions based on analysis of requirements;

. Presented strategies, concepts and solutions to senior executives,

internal and external clients, business partners and end users

. Defined and documented dimensional modeling conventions and best

practices;

. Implemented metadata models in support of data warehouse design;

. Produced technical architecture document, detailing end to end

solution architecture;

. Managed project resources and deliverables, including authoring and

maintaining project management documents;

. Lead data modeling for operational BI solution;

. Developed data model for corporate data warehouse on Oracle 11g;

. Optimized data warehouse performance on Oracle 11g and Microsoft SQL

Server 2005 & 2008;

. Performed Operational Entity Relationship modeling of Enterprise

Resource Platform applications;

. Developed technical ETL specifications, including source to target

mappings and transformation & validation rules;

. Implemented ETL processes in Data Manager;

. Designed and developed Cognos Business Intelligence (BI) content

including Framework Manager models, Report Studio and Analysis Studio

reports, active reports, cubes and dashboards;

. Implemented OLAP cubes using Cognos Transformer;

. Developed advanced Report Studio reports using custom HTML, XML,

JavaScript and CSS;

. Implemented Cognos Insight solution for sales and marketing analysis

and planning

. Mentored junior technical staff;

. Administered and managed security for all Cognos environments;

. Effectively communicate changes via documentation updates.

Technologies: Framework Manager 8.4 & 10.1, Data Manager 8.4 & 10.1, Report

Studio 8.4 & 10.1, Oracle 11g, MS SQL Server, ERWin

Project # 7

RealDecoy

Software Architect

June 2011- November 2011 (5 months)

Mr. Dorval was brought on as an expert in the Business Intelligence domain

as RealDecoy was looking to break into that market space. He outlined a

strategy for adapting their expertise in eCommerce to the BI space and

investigated approaches to delivering data through BI solutions.

. Developed reference information architecture for e-commerce solutions;

. Managed project resources and deliverables, including authoring and

maintaining project management documents

. Defined a vision for expanding into the BI solutions marketplace;

. Presented strategies, concepts and solutions to senior executives,

internal and external clients, business partners and end users

. Gathered and analyzed customer requirements;

. Designed solutions based on enterprise information architecture

methodologies;

. Advised solutions team on architecture and platform;

. Performed data modeling, ETL development and analytics design and

development.

Technologies: Endeca, Pentaho ETL, Java, J2EE, Hibernate, ERWin

Project # 8

IBM / Cognos

Software Engineer / Software Architect

February 2003 - June 2011 (101 months)

Mr. Dorval started on the Analytic Applications team developing and testing

packaged analytic content, including ETL code, reports and data models.

For the version 2.0 release of our applications he lead the design of the

Framework Manager models. He was promoted to the software architecture

team where he contributed to the design of the Adaptive Analytic Framework,

which is a combination of products that manage the end-to-end lifecycle of

an analytics solution, including source mapping, ETL, data warehouse

management, Framework Manager model, and a report generation engine based

on a user information needs model. During this time he also contributed to

the design of many of the packaged analytic applications that were

developed on this framework. He was the lead architect responsible for

porting the IBM Cognos analytic applications to Netezza.

Project A: Workforce Performance

Cognos Workforce Performance is a packaged analytic application that

provides insight into workforce and human resource issues. The solution

provides access to multiple data sources for consistent analysis and

reporting. It helps you analyze factors including workforce capacity,

hiring, retention, training, development, performance and compensation.

Project B: Financial Performance

Financial Performance General Ledger Analytics provides packaged reporting

and analysis of general ledger accounts. It is a module of the Cognos

Financial Performance Analytics application. The solution helps finance

organizations monitor performance across income, balance sheet, and margin

and revenue measures to assess how the organization is generating revenue

and utilizing cash flow and assets. Financial Performance Payables

Analytics provides packaged reporting and analysis of accounts payable. It

is a module of the Cognos Financial Performance Analytics application. The

solution helps finance managers gain insight into cash outflow, vendor

account and payment trends, the handling of adjustments and adherence to

payment policies. Financial Performance Receivables Analytics provides

packaged reporting and analysis of accounts receivable. It is a module of

the Cognos Financial Performance Analytics application. The solution helps

finance managers quickly assess account history, customer payment trends,

departmental effectiveness, high-risk accounts, cash inflow trends and

measures of customer satisfaction.

Project C: Sales Pipeline Analytics

Sales Analytics is packaged software that delivers insight into existing

and emerging sales opportunities. It helps you analyze sales force

productivity, pursue new market opportunities and accelerate pipeline with

up-to-the-minute insight.

Project D: Supply Chain Analytics

Supply Chain Performance Procurement Analytics is a packaged supply chain

management (SCM) solution to help organizations lower costs and improve

margins. The solution provides insight into procurement spending, supplier

performance, contract management and operational efficiency.

Project E: Manufacturing Analytics

Project F: Consumer Insight

Consumer Insight is an analytic application that enables marketing

professionals to be more agile and responsive to customer opinions

expressed on social media. Cognos Consumer Insight analyzes large volumes

of content available on publicly available websites and connects seamlessly

to IBM business analytics solutions.

Project G: Talent Analytics

Talent Analytics provides standard reports that simplify the analysis and

assessment of talent management programs. The software includes 100

measures and 1000 workforce attributes to support cross-organizational

reporting and analysis of workforce and human resource issues.

. Produce Cognos BI solutions, for example delivering historical, point-

in-time workforce headcount analysis

. Develop advanced Report Studio reports using custom HTML, XML,

JavaScript and CSS;

. Gather and analyze business requirements from participating teams,

stakeholders and management

. Presented strategies, concepts and solutions to senior executives,

internal and external clients, business partners and end users

. Model, design & develop multi-dimensional data marts and BI solutions

based on analysis of requirements;

. Produce technical architecture document, detailing end to end solution

architecture

. Implement metadata models in support of data warehouse design

. Lead dimensional data model design and implementation for analytic

applications

. Collaborate with resources from the services, industry, technology and

software groups of IBM to define multi-dimensional information and

decision management solutions;

. Design and implement enterprise data warehouses on Netezza MPP

architecture;

. Provide technical leadership and expertise in the development of

integrated solutions;

. Design and develop Cognos 10 BI content including Framework Manager

models, Report Studio and Analysis Studio reports, active reports,

cubes and dashboards;

. Troubleshoot and provide technical guidance for Cognos 10 BI content

including Framework Manager models, reports, active reports, cubes and

dashboards;

. Migrate Cognos BI content to version 10;

. Design and develop executive dashboards targeted for the office of

CFO;

. Develop user training material and documentation for CFO Dashboard;

. Research and design next generation platform for Cognos packaged

applications - Adaptive Analytic Framework - based on Cognos 8

technology;

. Prototype several aspects of the product using Java and web

technologies;

. UML and Entity Relationship modeling of application metadata store

. Lead the design of best practices for the Cognos Framework Manager

data warehouse model;

. Design Data Manager ETL best practices for Adaptive Analytic Framework

in ETL architecture document;

. Met with Product Management and Sales management to get feedback and

gather business requirements from customers and review their top

priorities;

. Prototype Adaptive Process platform - an analytics-based Business

Process Management framework;

. Author application documentation, including user guides and install

guides, for production applications;

. Work directly with sales and partners to ensure success on major

deals;

. Engage with customers to provide guidance on best practices;

. Provide ongoing research, design and prototyping of new concepts;

. Work with product management, development and test teams throughout

entire software development lifecycle (SDLC) to ensure product

success;

. Participate in working group on transition plan to Cognos ReportNet;

. Develop Cognos ReportNet best practices for version 2.0 of Cognos

packaged applications

. Provide technical guidance to other developers;

. Implement Cognos packaged analytic applications including: Financials,

Sales, Procurement, Workforce, Inventory, and Manufacturing;

. Develop technical ETL specifications, including source to target

mappings and transformation & validation rules

. Develop Cognos Data Manager ETL code and scripts, following best

practices for a multi-stage approach;

. Design and implemented logical and physical models for application

data marts on Oracle, Microsoft SQL Server and IBM DB2 databases;

. Develop Metrics Manager models and implement scorecards on Cognos

Metrics Studio

. Consult with ERP source system experts and develop complex SQL as

input to ETL;

. Develop and maintain database stored procedures for complex fact data

management

. Develop reports using Cognos Series 7;

. Provide third-level support to customers.

Technologies: Cognos Series 7, ReportNet, Cognos 8 & Cognos 10, Oracle 10g,

DB2 8, SQLServer 2005 & 2008, Oracle Designer, ERWin, Eclipse, Java, J2EE,

Hibernate, Hibernate

Project # 9

Indian and Northern Affairs Canada

Data Modeler / Data Warehouse Architect / Project Manager

June 1999 - January 2003 (44 months)

Mr. Dorval started his career modeling operational transaction systems for

Oracle databases. In 2000 he lead the department's first data warehousing

initiative, allowing for the analysis of financial and transfer payment

data.

. Established Corporate Data Warehouse team;

. Analyzed and document current state vs. desired future state for

business intelligence and data warehousing

. Managed project resources and deliverables, including authoring and

maintaining project management documents

. Developed long-term business intelligence road map, incorporating key

milestones

. Collaborated with IT infrastructure team to define data management

strategy for corporate data warehouse

. Worked with various teams and stakeholders to define business

alignment strategy for business intelligence

. Researched and develop a technology strategy for long term success

with business intelligence and data warehousing

. Presented strategies, concepts and solutions to senior executives,

internal and external clients, business partners and end users

. Lead Request for Proposal for business intelligence and ETL tools;

. Worked with senior management to define an organizational strategy to

ensure continued success

. Developed department best practices for report and ETL development;

. Established scalable data warehouse infrastructure - both hardware and

software;

. Designed and lead development, deployment and support for first two

phases of the Corporate Data Warehouse and Operational Data Store

following the Rational Unified Process for project management;

. Multi-dimensional data modeling;

. Participated in Rapid Application Design sessions with departmental

clients;

. Designed logical and physical data models to support the applications;

. Maintained department-wide operational Entity Relationship data model

to which all applications conform;

. Migrated legacy applications to new department standards.

Technologies: Oracle 7 & 8i, ERWin, DataStage 3.5, Crystal Reports 8

Other Projects and Experience

Dynsight March, 2013 to March 2014

Chief Software Architect (12 months)

Project 1: Dynamic Warehouse

Dynamic Warehouse is a modern implementation of the Adaptive Analytics

Framework that Mr. Dorval developed at IBM. It takes lessons learned from

that experience and delivers a new data warehouse modeling and lifecycle

management experience.

Technologies:

. Java, J2EE, Spring

. MongoDB

. Eclipse RCP & EMF

. Cognos 10.2 SDK

Project 2: Unnamed Big Data Social Analytics and Recommendation Engine

This is a work in progress that aims to provide an innovative new set of

metrics by which to recommend digital content to social network users.

Technologies:

. Hadoop, HBase, Hive, Pig, Map Reduce

. HTML5, AngularJS, CSS3, JavaScript, JSP

Contact this candidate