Jon Gagnon Email & Phone Number

-Create and manage Business Intelligence reports and dashboards based on user requirements, integrating data from multiple sources.-Develop and maintain the Babcock Data Warehouse, utilizing SSMS, SSAS, and SSIS tools for robust data management.-Provide analytical and technical support for complex projects, model data using the Kimball methodology, and deliver data services to end users.-Ensure data accuracy through validation and enhance BI services to support business processes.

Vancouver, British Columbia, Canada

- Collected and managed data and reports for contact collection tools used in client relationship management programs.- Provided and created ROI views for Telus corporate store and dealer events, including building reporting and analysis for dealer co-funding programs.- Collaborated with multiple stakeholders and marketing teams to gather and report on book of business programs and ad hoc requests. Effectively communicated data capabilities and set clear expectations to meet reporting needs.

Vancouver, British Columbia, Canada

- Built and maintained visualizations and reporting for multiple business units and stakeholders.- Used SQL to create tables and datasets in SAS.- Utilized Excel and Oracle tools such as TOAD to fulfill ad-hoc data requests.- Analyzed performance, results, and trends to provide insights and reporting.- Supported in the validation of multiple reporting dashboards used across various teams and products.

Vancouver, British Columbia, Canada

- Created and maintained store schedules to maximize traffic with productivity and business needs as well as ROI in mind.- Created a highly engaged team through coaching and building a culture on achieving strong performance through strong client experience.- Utilized tools such as DOMO to interpret data and metrics for use during coaching as well as for use in area-level primes and initiatives.