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.
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.
Group Head of Business Intelligence
DX Group plc
September 2017
to December 2021
Full-time
SLOUGH
United Kingdom
- 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).
Business Intelligence Manager
DX Group plc
May 2013
to August 2017
Full-time
NORTHAMPTON
United Kingdom
- 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
Robert Half International
March 2009
to March 2013
Full-time
BIRMINGHAM
United Kingdom
- 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.
CRM Technical Lead
Robert Half International
February 2007
to February 2009
Full-time
BIRMINGHAM
United Kingdom
- 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.
BI Architect & Developer
Robert Half International
January 2006
to January 2007
Full-time
BIRMINGHAM
United Kingdom
- 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.
Enterprise DataWarehouse Manager
Alstom Transport (HQ)
January 2005
to December 2005
Full-time
PARIS
France
- 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.
Hands-on BI Lead
Alstom Transport Services
January 2002
to December 2004
Full-time
BIRMINGHAM
United Kingdom
- 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 ***
ERP Junior Project Manager
Alstom Transport Services
January 2001
to December 2001
Full-time
DUBLIN
Ireland
- 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.
ERP Business Systems Analyst
Alstom Transport Services
September 2000
to December 2001
Full-time
BIRMINGHAM
United Kingdom
- 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.
from Andrew Ng
on-site training on Microsoft SQL Server 2008 Business Intelligence
Methodology to deliver desirable, justifiable, and feasible projects in a controlled environment
Classroom & on-site training on SQL Server 2000 BI & Crystal Reports XI
On site course Fact Findings, Dataflow Diagrams, Data Modelling.
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
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)