Experience

Fenplast

• Canada
• Wholesale Building Materials
• 100 - 200 Employee

• BI Developer (30% - DBA, 70% - Developer role)

  • Dec 2022 - Present

  ● Develop reports & dashboards, maintain the existing ones that were prepared using Power Bi & SSRS ● Use DAX and Power BI measures to obtain the results according to the business requirements ● Participate in the creation, modification, documentation of reports and dashboards, cubes, KPIs, ETL and database structures for the data warehouse. ● Assist with governance and deployment of Power BI, including administration, content distribution/sharing, training and support ● Participate in the creation and evolution of the BI architecture. ● Create, maintain, and validate the integrity of the data warehouse. ● Prepare and execute unit, functional and integrated test scenarios. ● Prepare and document the releases of the developed projects. ● Support customers in the analysis and documentation of their requests. ● Optimize the performance of the requests necessary for the deliverables. ● Collaborate with other specialists in my sector to define the rules of governance and standards surrounding the practice of business intelligence. ● Analyze, influence, and recommend the choice of different analysis tools facilitating and improving decision-making. ● Ensure the documentation and technical writing of the products. ● Support internal users. Show less



BRP (Bombardier Recreational Products)

• Montreal, QC

• Sr. BI Developer

  • Jan 2022 - Nov 2022

  ● Build queries that provide short- or long-term answers to business questions. ● Develop procedures and scripts for data migration. ● Generate complex analytic queries on huge data sets and develop T-SQL stored procedures, and Views. Deal with data manipulations as required. ● Rewrite and optimize performance of stored procedures by performance tuning through creating or modifying clustered or non-clustered indexes, setting transaction isolation levels as well as changing complex query structures. ● Write complex SQL queries using joins, sub queries and correlated sub queries. Have the expertise in SQL queries for cross verification of data. ● Deal with debugging stored procedures and views following the results of QA testing team. ● Participate to the meeting with FA and QA teams to discuss and optimize the development process. ● Build logic and indexed tables/views/stored procedures depending on the business requirements and rules; involved in writing heavy T-SQL queries, complex joins, Merge, Except commands etc. ● Modify temporary tables, indexes, and lookup techniques to optimize stored procedures. ● Conduct unit tests and assist in test preparations to ensure data integrity, data quality and program quality. Show less



MAZARS

• Montreal, Quebec, Canada

• Data Engineer

  • Aug 2020 - Dec 2021

  ● As a key developer, delivered the best results to the developmental needs, accomplished successful outcomes by working with SQL, SSIS, Power BI, ADF2 and other Azure tools ● Designed, developed & maintained ETLs of the data into existing data warehouses ● Designed and implemented solutions leveraging cloud native platforms, specifically Microsoft Azure ● Excellent knowledge in Azure SQL stack architecture (SQL Server, Synapse and Azure Data factory). Configured Azure platform for data pipelines, ADF, Azure Blob Storage and data lakes. Built workflows to automate data flow using ADF ● Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments ● Built efficient ETL packages, using both SSIS and Azure Data Factory ADF2 pipelines for processing Fact and Dimension tables with complex transforms and SCD type 1/ type 2 changes ● Developed and automated reports, dashboard, and other business performance tools. Analyzed processes and data to provide business insights ● Created scalable reporting solutions, data visualizations, or dashboards to track critical business metrics and identify trends ● Developed PBIX files in both Power BI Desktop and Power BI Services platforms and uploaded them into Report Server and Cloud Services with proper row level security settings ● Developed filters, reports, dashboards and created chart types, visualizations, and complex calculations to manipulate the data in Power BI. Used complex DAX query measures and KPIs according to the business questions ● Involved in applying Row-Level-Securities in all Power BI Reports, scheduled and monitored data source refreshes accordingly, and created measures and calculated column into reports using DAX. ● Developed test framework, prepared backend scripting/and Parsing using Python Show less



Levy Pilotte LLP

• Canada
• Accounting
• 1 - 100 Employee

• BI/ETL Developer

  • Sep 2018 - Jul 2020

  ● Analyzed the current ETL process to understand transformations and business logic. ● Developed and directed a process to clean and integrate complex healthcare datasets in order to create the data foundation for further analytics. ● Exported data from different kind of sources such as SQL Server, Azure SQL, Storage Table and Cosmos DB into Azure Blob storage using Azure Data Factory before doing analysis in Azure Analysis Services and creating Power BI reports. ● Accomplished SSIS Packages Configurations with different types like XML configuration file, Environment variable, Registry entry, Parent package variable and SQL Server table. ● Participated to the client team meetings for client engagements and strategic projects that require complex data management support. ● Experienced with the backend data retrieval team, data mart team to guide the proper structuring of data for Power BI reporting. ● Oversaw and summarized processes in logical and understandable formats for other team members including data manipulation and dataset preparation for client engagement analytics and applications. ● Built Views, Stored Procedures, and other SQL codes and joins for Incremental loading and Reporting processes. ● Regularly used stages such as Lookup, Join, Multicast, Merge, Transformer, Sort Filter and Delete duplicates to Cleanse/Transform the data that were exported to the staging. ● Performed Full and Incremental Loads to implement first load and to synchronize data changes between OLTP and OLAP databases using various ETL Operations. ● Performed the systematic processes to troubleshoot, solve application challenges and ensure data integrity across the platform. ● Automated manual tasks. Show less



Tremblay Guertin

• Montreal, Quebec, Canada

• BI/SQL Developer

  • Sep 2015 - Aug 2018

  ● Worked closely with management and business unit stakeholders to ensure alignment with enterprise business plans and strategic initiatives. ● Evaluated Source systems, standardized received data formats by understanding business/data transformation rules, business structure and hierarchy relationships. ● Wrote complex SQL queries using joins, sub queries and correlated sub queries. ● Extracted and loaded data from multiple sources (Excel, flat files, Oracle) to the staging area. ● Had in-depth experience with the Microsoft BI Stack (SQL Server, SSIS, SSRS and SSAS). ● Built logic and indexed tables/views/stored procedures depending on the business. requirements and rules; Involved in writing heavy T-SQL queries, complex joins, Merge, Except commands etc. ● Used data gathering, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs. ● Designed and developed MS SQL server stored procedures using T-SQL statements from scratch. Developed triggers on views to populate tables. Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete. ● Modified temporary tables, indexes, and lookup techniques to optimize stored procedures. ● Used various transformations in SSIS like Lookup, Derived Column, Union all, Merge to modify the data which is stored in various forms. Show less