Profile Sr. IT Consultant with 30+ years of experience using SQL server and 20+ years using business intelligence tools (SSRS, SSIS, ETL, SSAS, Tabular). Performed complex work using: SSRS, ETL (SSIS), SQL server, OLAP cube (SSAS). Expertise includes: Data Modeling, Data Performance, Database/architect, database design and implementation, collecting information directly from the end user, leading the team, planning the project, planning the work, creating reports with SSRS. Fluent in English and French. Certifications: Implementing a data warehouse with Microsoft SQL server 2012/2014 Administering Microsoft SQL server 2012/2014 Querying Microsoft SQL Server 2012/2014 Relevant Skills • Database programming (TSQL, Procedures, Tables, indexes, views, triggers.) + modeling & Analyst & Administration: SQL 32 years • Data warehouse architect using Kimball methodology • Banking and finance: 8 years • Benchmarking and threshold testing of databases • Data modeling and prototyping • Data Lineage Analysis and Data Quality Analysis • Team leader: 7 years • IT Manager: 5 years • Crystal Reports 8 years. • Data structures, Data cleaning and transformation: 22 years • BI tools (SSIS, SSRS, SSAS, SQL DQS, and OLAP): 18 years • Database Architect: 8 years • ASP.net, C#, VB, VB.net, HTML, JavaScript, VBScript, Visual SourceSafe, SharePoint: 10 years • International experiences: 3 years in USA, 1 year in France and 17 years in Canada. • DAX, MDX • Structured Query Language TSQL • Tabular BISM • Complex Data structure • Dashboard • Power BI, Power View, Power Query. • API REST, SOAP, JSON, XML Responsibilities: • Designed, tested, implemented, maintained and control centralized databases for leadership. Worked closely with technical management and leadership to design and implement databases and database support tools in support of complex business application development requirements and processes • Maintained customer-focused approach with users to provide different solutions. • Supported designed and managed upgrades to software that interacts with these databases. • ETL maintenance and job monitoring. • Integrity and security of data in Data Warehouses and Data Marts. Beside that I have: • Designed new/modify existing conceptual and logical models for the data warehouse and/or data mart. • Designed data mart solutions including star schema and cubes. • Managed scheduled and ad hoc data loads to ensure that data be • Monitored, supported, and troubleshoot the ETL processes. • Designed, enhance, and maintain SSIS packages to load data in a variety of formats • Developed SSIS packages in a multi-server environment using SSIS SQL configurations to share configured parameter values between packages. • Leveraged the full functionality of SSIS expression, script tasks, loop controls. And full functionality of T-SQL features as it applies to tables, views, stored procedures, user-defined functions, cursors, dynamic SQL, and partitioned tables. • Developed, and maintained a variety of SSAS cubes that make use of partitions, • Created new and maintain existing SQL Agent jobs, schedules, notifications, and Configurations that execute SSIS packages. • Used SQL Profiler and any other tools required to investigate, identify, and resolve issues in ETL, T-SQL, reporting, and legacy SQL applications. • Maintained SQL database backups and monitor SQL servers. • Maintained a documented history of changes to data systems • Data Management and Optimization • Assessed and refactored reporting and visualization from multiple data sources, for internal and external clients consumption. • Create operational Reporting (Ongoing and Ad-hoc) • Conducted QA test Professional Experience Company: Intact November 2025 – May 2026 Role: Data Analyst - Expert SQL server and Business intelligence, Data Bricks , Power Bi Accomplishments and created: Complex queries Data optimization for better performance Data analysis Data modeler for the project Gotrex SSIS packages SSRS reports Power BI (dashboard, scheduled refresh, workspaces, apps, deployment pipelines) Technological Environment: SQL server (2019,2016,2014,2012,2000), SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BI, DAX, Tabular BISM, Power Bi Desktop, Windows Azure, C#, VB.net , Azure data factory, Azure Data Lake, Azure Analytic Services, GitHub, API REST, SOAP, JSON Dynamite: February 2024 – September 2025 Role: Data Analyst - Expert SQL server and Business intelligence Accomplishments: - Creating and maintaining MS SQL code supporting - Performed extensive detailed data analysis for data quality. - Responsible for full cycle: T-SQL coding, developing analytics and reporting capabilities, documentation, troubleshooting and remediation. - Responsible for helping the client’s business problem to be solved, formulating a data-driven approach to solve the problem and finally, analyzing and drawing conclusions. - Responsible for creating, editing, and maintaining SQL code, including performance tuning. - Development using SQL server: stored procedures, views, tables, indexes, constraints … - Loaded data into SQL server using SSIS from sources (csv files, DB2, Excel, Oracle …) - Created reports using Power BI ( cloud) - Created OLAP cubes with SSAS - Created Function with DAX - Created Reports with SSRS - Created and supported packages with SSIS (ETL) Technological Environment: SQL server (2019,2016,2014,2012,2000), SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BI, DAX, Tabular BISM, Power Bi Desktop, Windows Azure, C#, VB.net , Azure data factory, Azure Data Lake, Azure Analytic Services, GitHub, API REST, SOAP, JSON. Grics: May 2022 – January 2024 Role: Data Analyst - Expert SQL server and BI Accomplishments: - Creation of stored procedures, views, tables, indexes, constraints : TSQL - Helped the clients solve their problem and created reports for that from SQL server - Worked on complex queries and improved the performance from hours to few seconds - Loaded data into SQL server using SSIS ( sources : files, Database …) - Created Power BI Dashboards ( cloud) - Created OLAP Cubes and tabular with SSAS - Created functions with DAX - Created Reports with SSRs - Worked on Azure cloud ( Azure data factory, Azure Data lake ) - Created and supported packages with SSIS (ETL) Technological Environment: SQL server (2019,2016,2014,2012,2000), SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BI, DAX, OLAP,Tabular BISM, Power Bi Desktop, Windows Azure, C#, VB.net, Data Science, Azure data factory, Azure Data Lake, Azure Analytic Services,GitHub. Via Rail: July 2020 – April 2022 Role:DBA , Data Architect, Data Modeller && BI expert and Team Lead Accomplishments: - Created new data model using Erwin with concepts : Conceptual Logical Physical - Programmed SQL server : Created stored procedures, views, tables, indexes, constraints - Created packages ; using SSIS ; o Extract : extract data from different sources o Transformation ; transform data types to match the destination table o Load ; load data into the destination table - Created reports with Power Bi desktop and SSRS - Configured Power BI premium (hybrid Solution : on premises & on cloud) - Configured Power BI on the cloud. - Worked with SQL Server native tools (DTA, Profiler, and System Stored Procs, DMV's, DMF's) - Created OLAP Cubes with Microsoft SSAS Tabular - Added calculation function to the tabular with DAX. - Created Microsoft SSAS Multidimensional Cubes - Used SharePoint scrum to do daily follow-up on the advancement of the tasks. - Defined ER diagrams - Defined Data Flow Diagrams (DFD) - Created and supported packages with SSIS (ETL) Technological Environment: SQL 2016, SQL 2014, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BI, DAX, Tabular BISM, Power Bi Desktop, Windows Azure. Refuah Health Center: September 2017 - Juin 2020 Subject : Health Role : Data architect, Expert SQL server and BI Requirement: Database Modeller, Create Tabular and BI Reports Accomplishments: - Created new relational Data store - Created packages to Load the data into the new model using SSIS - Configured Power BI premium (hybrid Solution : on premises & on cloud) - Configured the on power BI report server - Created complex reports with SSRS - Created and configured reports with power BI dashboard. - Added some DAX calculation the power BI reports. - Created OLAP SSAS tabular to be used as data source for the Power BI dashboard - Daily follow-up of the tasks with SharePoint SCRUM - Defined ER diagrams - Defined Data Flow Diagrams (DFD) Technological Environment: SQL 2016, SQL 2014, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BI, DAX, Tabular BISM, Power Bi Desktop, Windows Azure. State of Maine (Minister of Education - Maine): Expert SQL server and BI Mars 2016 – July 2017 Requirement: Create Full Microsoft BI Stack(Data Architect && Data Modeler) Subject : Education Accomplishments: • Created new database model: Full relational model (facts and dimension). • Created SSIS packages to load the data from different sources to the data model. • Created tabular cube • Added calculation with DAX • Created reports with SSRS about the schools, students, the grades the teachers, the exams with locations • Created Power BI dashboard map, to show all the exam results , the grades, the schools, the districts.. • Optimized the database Technological Environment: SQL 2014, SQL 2012, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BI, DAX, Tabular BISM, Power Bi Desktop, Windows Azure. PSP INVEST (WWW.INVESTPSP.CA/) November 2013 to July 2015 Role : Expert SQL server and BI Department: Finance Role : Create SSAS cube, Reports with SSRS and Reports with Power BI PSP hired me to help them during the conversion from their old system to new system. Participated to help balance the data. Helped users finding the problem with non-balance accounts. • Monitoring the database to improve the performance SSAS: • Created new cubes for the company Portfolio with SSAS • Updated the current cube with new measurements and dimension • Added new DAX/MDX calculation to the cube SSIS: • Created SSIS packages to import data from live databases and other sources like flat files, excel to the data mart. • Used the incremental load, to load the new and the updated rows. • Configuration of the packages to use external parameters like the server name the data base name the folder name • Added logging to the packages to log the errors, so it will be easier to fix the problem when it happens. • The final step, I have scheduled the packages on daily basis. SSRS: Created very complex reports for finance dept use like: • Trial Balance report • Port report • Collateral transaction • Transaction amendment • Transaction Report • Treasury transaction • Accounting impact on position • Accounting impact on transaction • Physical and reconciliation to Economic Technological Environment: SQL 2012 enterprise, SQL 2008 Enterprise, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table, Microsoft SharePoint, Power BI, DAX, Tabular BISM, Power Bi Desktop OPENTEXT July 2005 to October 2013 Department : Transport Role : Expert SQL server and BI Requirement: Create new data store Create Packages with SSIS Create SSAS Cube Create Reports with SSAS Daily follow up for the team on the advancement of the asks Accomplishment: • Create new Database Model (facts and dimension) • Created 155 SSIS Packages; • Created 89 Reports with SSRS; • Created 2 cubes with SSAS; • Daily meeting with IT team • Weekly meeting with the users or on request. Technological Environment: SQL 2008 Enterprise edition, SQL 2005, SQL 2000, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, Erwin, Cube OLAP SQL, MDX, XSLT, Microsoft SharePoint, Microsoft Access, Microsoft SharePoint,Orale CANADA DIRECT: Pharma & Heath care May 2003 to July 2005 Database Architect and Web Application Specialist Team Lead Subject: Pharmaceutical and health care • Created more than 6 pharmaceutical programs; Clients were: Fosamax, Persist, Pfizer and others • Designed more than 6 projects. - Creation of more than 44 packages with DTS, SSIS (sending faxes, emails, reports...) • Created Complex SQL procedure, triggers, functions; • Created more than 50 Reports with Crystal reports and reporting services; • Client support; • Created of 2 OLAP cubes with SSAS. Technological Environment: OLAP, Analysis services, Cubes, .Net Framework, SQL Server enterprise edition, VB.net, Cube, SQL analysis, Crystal.net, Visual source, Safe, ASP.net, HTML, XML, CSS, SOAP, WSDL, XHTML, DTS, Visual Studio, Reporting Services, Crystal Reports, Microsoft Access, Microsoft SharePoint, Unix, Unix, Shell script TP TRADESOFT (BUSINESS INTEGRATION SERVICES) January 1997 to April 2003 Permanent employee Database Architect/Developer Specialist: Team Leader Subject: Finance, Education Tradesoft is a financial Service company, achieving competitive advantage in the global information age, providing programs for more than 50 financial companies (banks like funds, portfolio) • Developed and designed programs like Mutual funds, Portfolio Risk Management, CRM, Fixed Income Securities, Funds, Cash Flow Analysis & Position Keeping, Portfolio Management, Corporate Finance, Customer Services, accounting, real-time communication; • Migrated most of the programs from VB6.0 to VB.Net and C#.Net.; • Migrated of databases from SQL6.5 to SQL7.0 • Migrated of databases from SQL7.0 to SQL2000; • Designed and developed data conversion processes and scripts; • Designed and developed data warehouse specific data conversion processes and scripts; • Experienced extracting, transforming and loading data with MS SQL Server 2000, DTS and SSIS. • Scheduled stored procedures; Technological Environment: SQL Server (6.5, 7.0, 2000), OLAP, DTS (SSIS, ETL), Access, Excel, VB (3.0, 4.0,5.0, 6.0), Crystal Report, Visual source safe, ASP, FoxPro, HTML, SOAP, WSDL, XML, XHTML, Microsoft Access, Java, DTS, UNIX, Visual Studio, .Net Framework, Net (VB.Net, C#.Net), COM+, COM