Your browser is outdated!

To ensure you have the best experience and security possible, update your browser. Update now

×

Frederic Tremblay (MBA, MSc)

Head Of Business Intelligence

Business Intelligence
Data Engineering
Data Science
Hands-on
R&D
Employed Available
Contact me
Entrepreneurial commercially savvy technologist with "Big Picture" hat on.
For the last 23 years, I have been responsible at different levels for helping organisations win, by driving the adoption of data architecture & business intelligence.
I have done this by raising the profile of BI among directors, developing business and commercial acumens, inspiring and technically directing teams in the delivery of business-critical information systems.
Home Experiences Education Skills Portfolios Interests
Download my PDF resume
Portfolios

Recommendations (Linkedin 1/2)

Recommendations (Linkedin 2/2)

Big Data Streaming Platform Reference Architecture

Creation date
21 Jun 2023

Modern Data Platform Reference Architecture

  • Batch and Streaming data pipelines.
  • Reference and Physical Architectures.
  • Cloud and On-Premise versions.
  • Kappa and Lambda versions.
Creation date
18 Apr 2022

Recommendations - SalesLeader BI Web Mashup - International President

Recommendations - Circle of Excellence 2011 Nomination

Download
Nominated in category:
  • Dedication to Excellence (for a 5 year working relationship).

Recommendations - Circle of Excellence 2010 Nomination (x2)

Download
Nominated in categories:
  • An Openness to new ideas
  • Dedication to Excellence

Bespoke Data Governance Portal

Central portal for managing data governance activities (glossary of terms, issues list, link to reports, etc..)
Creation date
07 Apr 2017

BI - SalesPilot Xcelcius Flash Dashboard - Screenshot

Objectives:
  • Help Field staff better understand how their rewards are calculated.
  • Help Field staff increase their rewards by modelling the impact of changes in key metrics.

Solution:
  • An interactive dashboard allowing What If Analysis.

Demo:
  • Right click attachment, Save As, then open in Acrobat Reader.
  • Use the sliders to model future reward levels.

Technology:
  • T-SQL, Excel, Xcelcius, Flash
  • Development IDE: SQL Server 2008, Crystal Presentation Design (Xcelcius)
  • Demo: Flash file embedded in PDF.

BI - SalesPilot Xcelcius Flash Dashboard - Demo (Pdf)

Download

BI - SalesPilot Xcelcius Flash Dashboard - Flyer

Download

BI - SalesLeader Web Mashup - Screenshot

*** Internal HackDay 2010 Winner *** in category "That's How We Make Money"

Objectives:
  • Reduce time spent collating client information.
  • Provide new leads and gain new business.

Solution:
  • Provide a single view of internal and external contextual client information.
  • Web BI Mashup solution linking internal client information with web information.

Technology:
  • IIS 7.0, Crystal Reports XI
  • HTML, Javascript (Googlemaps API, Linkedin API, Kompass API), T-SQL, Classic ASP.
  • Development IDE: RAD page generation in ASPRunnerPro 7, Mashup edition in WebMatrix, Database work in SQL Server 2008.

BI - SalesLeader Web Mashup - Flyer

Download

BI - SalesLeader Web Mashup - Internal Journal Article

CareerApp Mobile Android App - Screenshot (Nexus 7)

*** Internal HackDay 2012 Top 10 hacks ***

Objectives:
  • Provide field staff with mobile access to career path browsing (on tablets & phones).
  • Provide access to learning content on mobile devices.

Technology:
  • Android Ice Cream Sandwich, Javascript, HTML, SQLite
  • Development IDE: Windev Mobile 12, Eclipse, SQLite Database Browser
  • Demo device: Nexus 7 Tablet & HTC Desire Phone

CareerApp Mobile Android App - Demo (Nexus 7)

Download

CareerApp Mobile Android App - Flyer

Download

Model - BI Logical Model - Recruitment Enterprise DataWarehouse

Model - BI Logical Model - Recruitment SnowFlake Schema

BI - Migration Plan - BO XI to BOE 3.1

BI - Archimedes - Custom BI Web Portal

Custom-built BI Web Portal.

Objective: Provide an integrated BI Portal for two BI platforms, centralise helpdesk access, documentation and evangelise about BI Process.

Technology
  • Portal was built in DHTML with CSS
  • It integrates a Crystal Enterprise 10 platform (former SAP BOE) with an OLAP Web Portal called ReportPortal http://www.reportportal.com

DataWarehouse & BI - Custom Web Maintenance Portal

Objective:
  • Provide a configurable & easily maintainable datawarehouse environment.
  • Provide a single central point of configuration.
  • Configure the environment in a controlled auditable manner.

Solution:
  • DataWarehouse built for maintainability via configuration paradigms.
  • Web User Interface to configure most parts of the system.

Configuration Web screens:
  • SSIS ETL flow.
  • SQL Server Jobs Schedule.
  • SQL Server Jobs Enabling/Disabling.
  • SQL Error Notifications Email Limits.
  • Multi-tenant ETL Generation.
  • Master Data & Dimensions Data Enrichment.
  • BI Report Distribution Lists.
  • BI Report List of Values.

Read-Only Web Screens:
  • Master Data & Dimensions Lookup Tools for end-users.
  • SSIS Error Logs Reader.

ETL - Dynamic Configuration-Driven ETL Execution

Objective:
  • Reduce reliance on hardcoding for ETL Flow in the Execution Engine.
  • Trim down number of SSIS Packages from 13 to 1.

Solution:
  • ETL dynamic execution via an SSIS ForeachLoop container deriving ETL steps dynamically from a configuration table.

Technology:
  • Classic ASP Web UI to configure the ETL flows in a normalised table.
  • SQL Server 2008 SSIS to execute the ETL flows.
  • SQL Server 2008 Job with parameterised SSIS Package Execution Step.

EAI - Interfaces

Objective:
Build an automated interface between two back-office systems.

Solution:
SSIS package uploading interface files and populating a database.

Details:
  • Conditionnal Precedence Constraints with Expressions.
  • C# Script debugging task.
  • Database-side Environment-specific Package configuration.
  • Expression-driven File System Tasks.
  • Custom Error Event Handlers.

ETL - Template

Objective:
Standardise SSIS Package Development.

Solution:
SSIS Package Template under source control.

Details
  • Standard Documentation container.
  • Standard Naming Convention.
  • Most used Database Connections.
  • Standard Logging configuration.

ETL - Dynamic Configuration-Driven ETL Generation (Multi-tenant DataWarehouse)

Objective:
  • Reduce ETL scripting workload for each of the DataWarehouse tenants (countries).

Solution
  • ETL scripting automation via a central Template model.

Technology:
  • SQL Server 2008 Schemas, Stored Procedure (Dynamic T-SQL).
  • ASP Web UI.

ETL - AthleticStats - Athletics Results Web Mashup

Objective:
Provide an Athletics Website with a live feed from PowerOf10 result online portal.

Solution:
RSS mashup populated by web crawlers

Technology:
  • Feed43 Web crawling into XML.
  • ETL Yahoo! Pipes for XML Feed Data Cleansing and Aggregation (Regex, Union, Rename).
  • Display in Wordpress RSS Widget.
Website

Model - Database Physical Model - CRM Application

Custom-built Web CRM Quality Assurance system with BI module.

Objective:
Increase Client Loyalty and Gain New Business by better engaging with customers about service quality.

Technology:
  • 100+ tables SQL Server 2008 database in a fully normalised model.
  • data model designed and forward engineered with Oracle SQL Data Modeler.
  • Reverse Engineered and documented in Visio Professional for better rendering.
  • SQL Server 2008 Triggers, Stored Procedures, Partitions, Indexes, Constraints, Schemas.
  • 1 database for Transactions Processing.
  • 1 database for ODS reporting.
  • EAI Interfaces built in SSIS.
  • Data Entry via ASP pages generated by RAD tool and customised in Visual Studio 2008.
  • BI Reporting module built in SAP Business Objects Enterprise 3.1

DataFlow Diagram - CRM Application

Diagram - DataFlow - Fixed Assets Gaap Reporting Application

Custom-built Fixed Assets US Gaap Reporting System.

Objective:
Better model fixed assets depreciation on US, International and Local Gaaps to choose the most tax-efficient depreciation method.

Technology:
  • 15+ tables SQL Server 2000 database in a fully normalised model.
  • Triggers, Stored Procedures, Indexes, Constraints.
  • 1 database for Transactions Processing.
  • EAI Interfaces built in Microsoft DTS.
  • Data Entry and Configuration via MS Access Project.
  • BI Reporting module built in SAP Business Objects Enterprise XI.
twitter facebook linkedin