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
Experiences
  • 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.
Detailed Description
  • Business analysis (requirements gathering, fact findings)
  • Prepare BI roadmap with Finance Manager (functional & technical)
  • Create “Agile BI” project plan and sprints with team
  • Plan and lead staged BI platform migration (BO XI to 3.1)
  • Supervision & technical leadership of 4 developers (2 permanent, 2 contractors)
  • Define and implement team cross training plan
  • Design & implement source control & development standards
  • Model datawarehouse of 13 datamarts (Oracle SQL Data Modeler)
  • Hands-on development with SQL Server 2008, 15 SSIS pkgs, 13 SSAS cubes
  • Hands-on development on SAP BOE 3.1 (Publications, 200+ Crystal Reports, Voyager)
  • Design and build metadata driven multi-tenant datawarehouse (ETL and datamarts)
  • Design & develop datawarehouse maintenance web UI (Classic ASP)
Company Description
Recruitment specialist listed on NSE, 2011 Revenue $4B.
Founded in 1948, Robert Half International (RHI) is the world's first and largest specialized staffing firm. RHI is a recognized leader in professional staffing and consulting services, and is the parent company of Protiviti, a global consulting and internal audit firm composed of experts in risk and advisory services.
Company website
http://www.rhi.com
  • 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.
Detailed Description
  • Gather functional requirements and write business case.
  • Supervise and technically lead 3 internal developers.
  • Model & design application (web app with 100 database tables).
  • Hands-on database and front-end developments (SQL Server 2005, Classic ASP).
  • Load & stress test application (web server & database server).
  • Install & administer web based Redmine project management system (Apache Tomcat, MySQL, Ruby, Subversion).
Company Description
Recruitment specialist listed on NSE, 2011 Revenue $4B.
Founded in 1948, Robert Half International (RHI) is the world's first and largest specialized staffing firm. RHI is a recognized leader in professional staffing and consulting services, and is the parent company of Protiviti, a global consulting and internal audit firm composed of experts in risk and advisory services.
Company website
http://www.rhi.com
  • 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.
Detailed Description
  • Gather functional requirements & model EDW.
  • Design & build ETL, semantic layer and reports (20+ Crystal Reports).
  • Design & build 10 OLAP cubes (MS Analysis Services, linked cubes, MDX).
  • Design & build datamarts (SQL Server 2000 stored procedures and DDL).
  • Install & administer BI platform (SAP BO XI).
  • Operate & support staff reward reporting (including data stewardship).
Company Description
Recruitment specialist listed on NSE, 2011 Revenue $4B.
Founded in 1948, Robert Half International (RHI) is the world's first and largest specialized staffing firm. RHI is a recognized leader in professional staffing and consulting services, and is the parent company of Protiviti, a global consulting and internal audit firm composed of experts in risk and advisory services.
Company website
http://www.rhi.com
  • 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.
Detailed Description
  • Establish enterprise data referential dictionary.
  • Model EDW & MDM against functional requirements and strategic direction.
  • Technically evaluate & select business intelligence platforms (Datastage, Oracle, BO).
  • Take part in SAP Business Objects XI licenses negotiation with programme manager (3000 licences).
Company Description
Transport specialist quoted in Paris, 2005 revenue €13B
Alstom Transport develops and markets the most complete range of systems, equipment and services in the railway sector. Alstom Transport manages entire transport systems, taking in rolling stock, signalling and infrastructure, and offers “turnkey” solutions. The company is no. 1 in the high and very high speed train sector and keeps investing in high end segments, while developing products suited to the specific needs of the emerging markets.
Company website
http://www.alstom.com/transport/
  • 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 ***
Detailed Description
  • Negotiate resources with directors.
  • Build up matrix BI team from internal and external resources.
  • Write up business case, gather requirements, send invite to tenders.
  • Select business intelligence partner (Contemporary Plc now “Itelligence”).
  • Negotiate cost of crystal enterprise licenses.
  • Supervise BI team (up to 4 internal & external developers).
  • Hands-on datamart & OLAP cube development (8).
Company Description
Alstom Transport Service offers a range of customised services to public or private rail operators (Rollstock services, Infrastructure Services).
Company website
http://www.alstom.com/transport/products-and-services/services/
  • 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.
Detailed Description
  • Negotiate resources with programme manager
  • Supervise 3 business analysts
  • Coordinate issues resolution with offshore configuration team
  • Responsible for communication and change management with operational staff
Company Description
Alstom Transport Service offers a range of customised services to public or private rail operators (Rollstock services, Infrastructure Services).
Company website
http://www.alstom.com/transport/products-and-services/services/
  • 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.
Detailed Description
  • Model business processes and analyse gap with SAP R/3 modules
  • Develop issues management system & coordinate issues resolution (MS Access)
  • Develop reports and queries in SAP ABAP query and user friendly GuiXT front-ends
  • Responsible for communication and change management stream
  • Support users and audit usage & compliance post-rollout
Company Description
Alstom Transport Service offers a range of customised services to public or private rail operators (Rollstock services, Infrastructure Services).
Company website
http://www.alstom.com/transport/products-and-services/services/
twitter facebook linkedin