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.
  • Define Group strategy for Data, BI and actionable insight.
  • Lead and manage BI, data engineering and data governance teams in the execution of the strategy (hands-on).
  • Ability to balance strategic against tactical demands.
  • Manage and coordinate cross departmental projects.
  • Lead customer facing BI and commercial product development.
  • Lead the delivery of innovative machine learning powered solutions with major contribution to cost control.
  • ££: designed, developed & rolled out a revenue protection solution (£1million additional revenue in first 15 months).
  • ££: led the development of a driver pay solution fueled by data-science.
  • Strong line management credentials (x9).
  • Develop a high quality professional BI team capable of providing a high standard of BI support to the business (from 5 BI devs to 8).
  • Effectively translate high-level business requirements into detailed specifications and quality fit-for-purpose solutions.
  • Select the appropriate BI toolset to be used within the DX Group.
  • Define DX's data strategy and vision for business intelligence initiatives.
  • ££: led the delivery of a predictive ETA Solution which contributed to the retention of customer accounts totalling circa £80m revenue.
  • Hands-on development of various solutions (Datamarts, MS SQL SSIS & SSAS, SAP BI 4.1 Universes and Reports, .Net web apps, etc..).
  • Perform focused data analysis & story-telling (SQL, SAP Lumira, PowerBI).
  • BI Team leader supervising 4 BI developers (inc 1 offshore).
  • Leading MIS team in BI platform enhancement & migration (3000+ indirect users).
  • Supervising BI team in day to day enhancements of the BI solution.
  • SAP Business Objects 3.1, Crystal Reports 2008, SAP OLAP Voyager, Xcelcius, SQL Server BI 2008 R2.
  • ££: Reduced back office costs for report generation (£50k/year).
  • Design & development of a web scraping based lead generation tool.
  • ££: Revenue generated from BI lead generation tool (£120k over 12 months / ROI x1.85).
  • 1st Prize winner at internal « Hack Day 2010 » with a Web BI mashup.
Learn more
  • New Web CRM application (inc BI module) for 200+ direct users.
  • Contribution to client loyalty and sales increase with Net Promoter Score method.
  • SQL Server 2005, SSIS, SAP Business Objects XI, ASP.
  • Outcome:
  • Increased customer retention from better engagement.
  • Revenue generated from increased engagement.
Learn more
  • EMEA BI Platform rollout of a sales performance monitoring & staff reward reporting.
  • 3000 indirect users (pushed reporting) & 50 direct users (BOXI premium licenses).
  • SQL Server 2000, MS Analysis Services, SAP Business Objects XI.
Learn more
  • Promotion from UK business unit to worldwide corporate headquarters.
  • New enterprise datawarehouse EDW for 3 different SAP ERPs.
  • Budget responsibility (Capex budget of €3m inc 3000 direct BOXI Premium users).
  • Manage project start-up and design phases.
  • Oracle, IBM Datastage, SAP Business Objects XI.
Learn more
  • New Line of Business datawarehouse for 3 ERPs of which one SAP R/3.
  • Budget responsibility for prototype and licenses (Capex £70k).
  • Manage project from start-up to close.
  • SAP R/3, SQL Server 2000, DTS, MS OLAP, Crystal Enterprise 10, Crystal Reports.
  • 2012 Update *** this Line of Business DW has now become a Global Enterprise DataWarehouse ***
Learn more
  • Roll-out of ERP SAP R/3 at 1 tram maintenance depot.
  • Budget responsibility for ERP configuration (Capex £60k over 6 months).
  • Manage Project from Start up to Close.
  • SAP R/3 PM, MM, FI-CO.
Learn more
  • Part of the blueprint “pilot site” team for SAP R/3 rollout.
  • Business Analysis and Testing of SAP R/3 modules.
  • SAP R/3 PM, MM, FI-CO, SD.
  • “High potential” programme entry.
Learn more

DBT Program

Udemy

January 2022 to March 2022

Online Machine Learning

Stanford University School of Engineering

March 2019 to May 2019
from Andrew Ng

Persuasive Dialogue

Onsite

December 2012
Socrates Method, “Listening” to understand.

Business Intelligence Training

itelligence Group

June 2011
on-site training on Microsoft SQL Server 2008 Business Intelligence

PRINCE2 Registered Practitioner (2010)

Datrix (Candidate no P2R/753984)

August 2010
Methodology to deliver desirable, justifiable, and feasible projects in a controlled environment

Business Intelligence Training

itelligence Group

May 2003
Classroom & on-site training on SQL Server 2000 BI & Crystal Reports XI

Business Systems Analysis

Pentland Training

January 2002
On site course Fact Findings, Dataflow Diagrams, Data Modelling.

MBA European Business

Coventry University, UK

January 2000 to June 2001
Corporate Finance, Statistics, Marketing, Information Technology.
Learn more

Maîtrise Sciences de Gestion (MSc Finance)

Université de Caen Basse Normandie

September 1998 to December 1999
Management Accounting, Fiscal Law, HR Management, Marketing, Statistics.
Learn more

DUT GEA (Diploma in Business & Finance Studies)

IUT Angers (France)

September 1996 to June 1998
Financial Accounting, Financial Analysis, Statistics, Data Modelling.
Learn more
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
  • Athletics 800m - international masters competitions
  • Sailing
  • Gold medal winner at Masters Athletics European Championships in M40 age group (2019)
  • DX Group plc Innovation Awards winning team for ETA Solution (2015)
  • 1st Prize winner at Robert Half worldwide «Hack Day» with Salesleader Web BI Mashup (2010)
  • Alstom High Potential Program entry (2002)
  • Team win at French universities business simulation championships "Olympiades de Gestion" (1999)
  • Team Lead for Angers University at sailing "Course Edhec" - team of 15 (1998)
  • Team member for Lycée St Louis at sailing "Course Edhec" (1996)