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
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.
Skills

Information Technology Practices

  • Data Engineering (EDW, data lakes, ETL/ELT)
    Advanced
  • Business Intelligence
    Advanced
  • Relational database design
    Advanced
  • Platform & Data Architecture
    Advanced
  • Data Governance & Management (DAMA)
    Advanced
  • Agile BI, Waterfall, Iterative
    Advanced
  • Project Management (Prince2)
    Advanced
  • ERP Implementation
    Good
  • Web Development (RAD)
    Good

Data Engineering and Integration

  • Microsoft SSIS, MDS, DQS
    Advanced
  • Azure Data Factory
    Good
  • PowerQuery
    Good
  • Qlik Replicate, Debezium
    Good
  • DBT, Airflow, Airbyte
    Good
  • AWS Glue
    Intermediate
  • Elastic Search
    Intermediate
  • Apache Spark & Kafka
    Intermediate

Business Intelligence

  • MS SQL 2019 (SSAS, SSRS)
    Advanced
  • PowerBI
    Advanced
  • SAP Business Objects Enterprise 4.1
    Advanced
  • SAP Crystal Reports
    Advanced
  • SAP Business Objects Universes, IDT & Webi
    Advanced
  • SAP Dashboard (Xcelcius) & Lumira
    Advanced
  • Excel Advanced Dashboards
    Advanced
  • Metabase, Apache Superset
    Good
  • IBM Cognos
    Good
  • Qlikview
    Good
  • AWS Athena & Quicksight
    Intermediate

Database Management Systems

  • Microsoft SQL Server 2000-2019
    Advanced
  • MySQL 5.7 - 8.0
    Good
  • SQLite
    Good
  • Azure SQL DB
    Good
  • Oracle 12c
    Good
  • Snowflake
    Intermediate

Architecture & Modelling Tools

  • Oracle SQL Data Modeller
    Advanced
  • Visio
    Advanced
  • Draw.io
    Good
  • Erwin
    Good

Programming Languages and Scripting

  • SQL (T-SQL, P-SQL)
    Advanced
  • Web Development (RAD, VBA, VB.Net, PHP, CSS, Javascript)
    Good
  • Python
    Good
  • Powershell, Batch and Bash Script
    Good

ERP E/R Data Models

  • SAP R/3
    Advanced
  • Salesforce
    Good
  • JDE Enterprise One
    Good
  • Great Plains
    Good

Tools

  • Project Management: Microsoft Project, Redmine and Confluence
    Advanced
  • Issues Mgt: Azure DevOps, TFS, Redmine & JIRA
    Advanced
  • Website Mgt: IIS Manager 7.5, Wamp
    Advanced
  • Database Mgt: Readgate SQL Toolbelt
    Good
  • IDEs: SSMS, Oracle SQL Developer, Visual Studio Code, PyCharm, Google Colab
    Good
  • Source Control: Azure DevOps, TFS, Git, SVN, Tortoise, AnkhSVN
    Good
  • Jupyter
    Good
  • Stress Testing: Microsoft WACS
    Good
  • Performance Monitoring: PerfMon, Dynatrace, Fiddler
    Good
  • PowerApps and Power Automate
    Good

Operating Systems & Servers

  • Microsoft Azure, Windows Servers 2000-2016, Linux Fedora 35
    Advanced
  • IIS 5.0-7.5, Apache Tomcat
    Good
  • Virtualisation: Microsoft Virtual PC, VMWare, Oracle Virtual Box, Boxes..
    Good

Industries & Business Acumen

  • Logistics & Parcel Delivery (Data Architecture, CRM, Strategic Metrics, Data Science Optimisation Models, SOPs, Revenue Protection).
    Advanced
  • Recruitment industry (Data Architecture, CRM, Financials, Customer Retention, Lead Generation, Strategic Metrics & BI).
    Advanced
  • Rolling Stock Services (Data Architecture, MRP, Financials, Service Management Planning, Plant Maintenance, Strategic Metrics & BI).
    Advanced
  • Rolling Stock Manufacturing (Data Architecture, Strategic Metrics & BI).
    Advanced
  • Fintech and Capital Markets (Exchanges and Brokers).
    Intermediate

Functional Knowledge

  • Marketing
    Advanced
  • Management and Financial Accounting
    Advanced
  • Customer Service
    Advanced
  • Sales
    Advanced
  • Service Management
    Advanced
  • Human resources
    Advanced
  • Logistics and Transport
    Advanced
  • Trains and Traffic Management
    Advanced
  • Treasury Management
    Intermediate
  • Brokers and Exchanges
    Intermediate

Languages

  • French: mother tongue
    Expert
  • English: bilingual
    Expert
  • Portuguese: basic conversational
    Notions
  • German: basic conversational
    Notions