Luc Mercier

Experience

• 

  Fujitsu Canada

  May 2005 - Aug 2005

  Programmer

  Updates and modifications to a Microsoft Visio plugin (in C++ and VB) offering additional validation features. Change requests management. Quality assurance. Creation of the user guide.

• 

  Matrox

  May 2006 - Aug 2006

  Computer Engineering Intern

  Development of a software quality assurance tool for a library used in image processing graphic cards. More precisely, development of test functions for JPEG encoding and decoding and for image warping.

• 

  CMC Electronics

  May 2007 - Aug 2007

  Computer Engineering Intern

  Development of new features, peer reviews and documentation for a Flight Management System to be used in maritime helicopters.

• 

  Bombardier Aerospace

  May 2008 - Sept 2011

  Software Engineering Professional

  Leader of a small team in charge of a web application used for research and development activities. Main achievements:- Transformed a manual resource management process into a web-based collaborative process with a tool that received an honorable mention at the 2009 Annual Achievement Awards- Built an information gathering, classification and sharing tool- Implemented web analytics from scratch- Developed the application as full-stack developer, business analyst, product owner, trainer and advocate Show less

• 

  Cossette

  Oct 2011 - Jul 2019

  My role was to provide actionable insights from web, social, digital media and CRM data. Main achievements:- Used behavioral data to understand users of the Tourisme Montréal app using the k-means clustering machine learning algorithm- Improved understanding of content value by looking for important conversion criteria using decision tree classifiers for Tourism Yukon- Created behavior-based engagement indicators using DMP data, BigQuery and a Google Data Studio dashboard for CCM- Created a reusable vertical solution from implementation to dashboard in order to measure landing page performance with no maintenance effort for CCM- Created automated reports for web property performance using the Google Analytics API and Google Sheets for Québec’s Casinos- Used public BigQuery data to add meteorological information to some of our clients’ data based on user location- Defined and implemented performance measurement solutions using Google Analytics and Google Tag Manager as well as DMP solutions and other tracking elements- Delivered actionable insights on complex digital ecosystems using my knowledge of the data, data mining, machine learning and any other appropriate tools according to needs, time and resource availability- Created generic performance tracking components in order to optimize our tracking development operations- Proposed generic and personalized business intelligence service offers- Acted as Google Marketing Platform certified partner- Grand Prize B2C brand site or application - big company (Boomerang) for mtl.org (2017)- Grand Prize B2B brand site or application - big company (Boomerang) for camso.co (2015)- Main clients: Tourisme Montréal, Tourism Yukon, Camso, CCM, Québec’s Casinos, CAA Show less I was a business and functional analyst for web, mobile, CRM and intranet products. Main achievements:- Defined key performance indicators and implemented web analytics solutions- Created generic and personalized performance measurement dashboards- Gathered business requirements stakeholders and transformed them into functional requirements- Acted as product owner of a web tool used for CRM campaign operations for TD- Acted as scrum master for the business analysts’ team as well as a dedicated product development team- Main clients: Camso, TD, Royal Canadian Mint, Saputo, General Mills, DICOM Show less

  • Business Intelligence Analyst

    May 2016 - Jul 2019

  • Business Analyst

    Oct 2011 - May 2016
• 

  Vision Group

  Jul 2019 - now

  My role was to provide business insights to operational, marketing and financial teams using cross-functional data from multiple operational systems.- Automated all existing Tableau dashboards using modular and reusable components- Created an Executive dashboard for new clinic owners, regional directors and senior management with complex business rules enabling important business decisions- Developed a modular architecture for extraction, transformation and loading (ETL) data as well as feature engineering using Alteryx to optimize dashboard and analysis production- Developed modular ad hoc dashboards for cross-functional stakeholders while promoting them to permanent solutions- Developed a reusable ETL, data manipulation and scenario analysis tool for operational, marketing and financial predictions using an Alteryx backend and Excel front-end (at first) as well as Tableau (later)- Initiated agile project management practices within the team- Developed business relationships across functions in order to propose useful solutions that go beyond the first level- Responded to ad hoc analysis requests while optimizing reusability, documentation and delivery time Show less

  • Senior Business Intelligence Specialist

    May 2023 - now

  • Business Intelligence Manager

    Oct 2021 - Sept 2023

  • Business Intelligence Analyst

    Jul 2019 - Oct 2021