Luc Mercier Email & Phone Number

Leader of a small team of BI experts providing valuable insights and data autonomy to cross-functional stakeholders.

Montreal

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

Montreal, Canada Area

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

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

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

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

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.

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.

Bachelor Of Engineering (B.Eng.), Computer Engineering - Multimedia Orientation

Activities and Societies: Comité des Étudiants en Génie Informatique (secretary, treasurer), Poly-Théâtre (actor, director)Accomplished.

Dec, Natural Science

Activities and Societies: Student Radio