PROFILE:

• Sr. IT Consultant with 25+ years of experience using SQL server and 16 years using business intelligence tools (SSRS, SSIS, ETL, SSAS).
• Performed complex work using: SSRS, ETL (SSIS), SQL server, OLAP cube (SSAS).
• 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.
• 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.

RELEVANT SKILLS:

Database programming (TSQL, Procedures, Tables, indexes, views, triggers.) + modeling& Analyst & Administration: SQL 25 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: 18 years

BI tools (SSIS, SSRS, SSAS, SQL DQS, and OLAP): 17 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

Power BI (Power query, Power View, Power Pivot, Gateway, Hybrid, on - premises and on-cloud configuration )

PROFESSIONAL EXPERIENCE:

Confidential

Database and BI expert

Responsibilities:

• Creating New data store with tables, views and procedures
• Data analysis
• Loading the data with SSIS
• Creating reports with Power Bi desktop and SSRS

Confidential

Database, Data architect and BI developer/Analyst

Responsibilities:

• Created a full cycle data warehouse
• Data modeling
• Data integration (SSIS)
• Created Cubes, Reports SSRS and Power BI reports
• Documentation

Confidential, Boston, MA

Database, Data architect and BI developer, Analyst

Responsibilities:

• Created new data warehouse by modeling the current database.
• Created SSIS packages
• Created SSRS Reports
• Created Reports with Power BI Desktop
• Added calculation with DAX/MDX

Technological Environment: SQL 2014, SQL 2008, 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, Gateway connection, DAX, Tabular BISM, Power Bi Desktop

Confidential, Augusta, Maine

Database, Data architect and BI developer, Analyst

Responsibilities:

• Created new data warehouse by modeling the current database.
• Fixed and create SSIS reports
• Created SSIS packages.
• Updated and modified the current SSAS cube
• Added calculation with DAX/MDX
• Created Power BI dashboard (using power BI desktop)
• 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

Confidential, St. Louis, IL

Database and BI developer

Responsibilities:

• Created more than 245 SSIS reports
• Created more than 55 SSIS packages
• Created DataMart and cube
• Added calculation with DAX/MDX
• Created Power BI dashboard reports

Confidential, NY

Database & BI Developer, Analyst, architect (SSIS, SSRS, SSAS)

Responsibilities:

• Monitoring the database to improve the performance
• 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
• 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.

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 BIDAX, Tabular BISM, Power Bi Desktop

Confidential

Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

• Created more than 10 packages with SSIS to load the data from different sources to the SQL server. Sources like: Flat files CSV, Text, XML, or from different servers like: SQL server.
• Created reports with SSRS using data sources: SQL server and cubes.
• Improved the database performance using different mereologies.
• Designed new DataMart
• Created new cube and added calculation with DAX/MDX

Technological Environment: SQL 2012 enterprise edition, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, DAX, Tabular BISM, Microsoft SharePoint, Power BI.

Confidential

Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

• create packages with SSIS fix the performance problems update the current cube with new request
• Advised on the best strategy to create cubes;
• Advised and helped on monitoring and fixing the data performance;
• Helped finding solution for some complex problems.
• Added new functions to the cube with MDX
• Added new dimension (Linked, Role playing, Junk, Conformed, SCD) and facts tables
• Added new measurement (Full additive, semi additive)
• Created new packages to feed the DataMart.

Technological Environment: SQL 2012 Enterprise edition, SSIS, SSRS, SSAS, OLAP, ROLAP, Power BI, MOLAP, Transact/SQL, MDX, TSF, Kimball methodology, Microsoft Access, Microsoft SharePoint.

Confidential

Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

• Create list of reports required by the users
• Create new packages to load the data into the datamart
• Update the current cube with new requests.
• Created a list of reports with SSRS, about 150 reports
• Created 15 packages to load the new data from sources like XML, CSV and Excel to the data art
• Updated the currents cubes with new requests
• Created new cube for the portfolio of the company

Technological Environment: SQL 2012 Enterprise, SQL 2008 enterprise, SQL 2005, SQL 2000, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, Erwin, Cube OLAP SQL, MDX, XSLT, Team Foundation Server (TSF), Microsoft Access, DAX, Tabular BISM, Microsoft SharePoint

Confidential

Team lead, Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

• Created 55 SSIS Packages;
• Created 50 Reports with SSRS;
• Cubes 2 cubes with SSAS;
• Created 2 Data mart

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

Confidential

Database & BI Developer and architect (SSIS, SSRS, SSAS)

Responsibilities:

• Created 22 SSIS Packages;
• Created 44 Reports with SSRS;
• Created 2 Cubes with SSAS;

Technological Environment: SQL 2008 Enterprise, SQL 2005, SQL 2000, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, Erwin, Cube OLAP SQL, MDX, XSLT, Team Foundation Server, Microsoft Access, Microsoft SharePoint

Confidential

Database & BI Developer and architect (SQL 2005 & 2008) Team Lead

Responsibilities:

• Created 145 packages using SSIS
• Created 4 data Mart in SQL server
• Created 85 reports using SSRS

Technological Environment: SQL server 2005/2008/2000 Enterprise, Analysis services (SSAS), Cube, MDX, Reporting services (SSRS), Pivot table, Integration services (SSIS), Microsoft SharePoint

Confidential

Database & BI Developer and architect (SQL 2005 & 2008)

Responsibilities:

• Fixing the performance problem of the database server;
• Architect and development of more than 105 SSIS packages; designing and development of 75 reports with reporting services; designing and development of 5 Cubes with services;
• Database design, Creation of tables, triggers, function, views, stored procedures;
• Data analyst & Data models;
• Designing and developing data conversion processes and scripts;
• Designing and developing data warehouse specific data conversion processes and scripts;
• Experience extracting, transforming and loading data with MS SQL Server 2005, 2008, 2008A, SQL Server Integration Services (SSIS);
• 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