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.
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
I have the abilitity to develop analytical strategies to solve business problems
Professional Experience
MATROX : March 2023 – November 2023
Role: 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 to help 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.
- Data modalisation with Erwin
- 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 LOLAP cubes with SSAS
- Created Reports with SSRS
- Worked on Azure cloud: Azure data factory, Azure data Lake.
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, Python,IBM Cognos, Azure data factory, Azure Data Lake, Azure Analytic Services, Data science.
Grics : May 2022 – February 2023
Role: 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 Cubes with SSAS
- Created functions with DAX
- Created Reports with SSRs
- Worked on Azure cloud ( Azure data factory, Azure Data lake )
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, Data Science,
Azure data factory, Azure Data Lake, Azure Analytic Services.
VIA-Rail: June 2020 – April 2022
Role: Expert SQL server and BI
Accomplishments:
- SQL Server: Created stored procedures, views, tables, indexes, constraints
- Created packages; using SSIS;
- Created Power BI dashboard
- Fixed Database performance
- Created PostMan scripts
- Created Reports with SSRS
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
AGLC: March 2019 – January 2020
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 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)
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 - February 2019
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 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 August 2015 – 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
VIARAIL (TRAIN CANADA) January 2010 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
OPENTEXT (WOLRD WIDE COMPANY) January 2009 to August 2010
Department: Content management.
Database & BI Developer and architect (SQL 2005 & 2008)
Contract: 3 renewals
The Content Experts™ at Open Text offer the Open Text ECM Suite, which helps you manage and gain true value from your business content by connecting it with your people and processes. With the Open Text ECM Suite, you can control the cost and risk of content, make processes more agile, and empower your people to make better decisions.
o Fixing the performance problem of the database server;
o Architect and development of more than 105 SSIS packages;
o designing and development of 75 reports with reporting services;
o designing and development of 5 Cubes with services;
o Database design, Creation of tables, triggers, function, views, stored procedures;
o Data analyst & Data models;
o Designing and developing data conversion processes and scripts;
o Designing and developing data warehouse specific data conversion processes and scripts;
o Experience extracting, transforming and loading data with MS SQL Server 2005 ,2008, 2008A, SQL Server Integration Services (SSIS);
o Scheduling stored procedures and packages;
Technological Environment: SQL server 2008/2005/2000 Enterprise, Analysis services (SSAS), Cube, MDX, Reporting services (SSRS), Pivot table, Integration services (SSIS), TSQL, Microsoft SharePoint,
, Lunix, UNIX, Shell script, Orale
TECNOLOGY EVALUATION August 2005 to December 2008
Subject: Marketing
Consultant Company: no consultant company
DBA: Database + BI Architect/Developer: IT Manager
(Contract: 5 renewals)
Managed 10 programmers.
• Designed data base diagrams (ER) for 4 new projects, including tables, procedures, trigger, views, and functions;
• Created 120 reports with SSRS;
• Created 110 packages with SSIS;
• Optimized databases for better performance;
• Created new BI projects using analysis services SSAS, ETL, Reporting services and excel pivot Table.
• The steps I have used:
During Data staging:
• Created a Data mart
• Used SSIS to clean and combine data;
• Loaded the Data using SSIS
• Created a cube with SSAS;
• Scheduled the packages
Technological Environment: SQL server 2005/2000, Table, ETL), OLAP, XML, Reporting services, Crystal reports, SSIS, SSAS, SSRS, Share Point, BizTalk, ASP.net, BizTalk, SharePoint, Java Script, VB Script, Microsoft Access, Microsoft SharePoint , Unix, Unix, Shell script
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
Education: Bachelor in computer engineering, Marmara University