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