SUMMARY:

• 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). 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.
• Database programming (TSQL, Procedures, Tables, indexes, views, triggers.) + modeling& Analyst & Administration: SQL 25 years
• Data warehouse architect using Kimball methodology
• Confidential: 8 years
• Benchmarking and threshold testing of databases
• Data modeling and prototyping
• 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.

TECHNICAL SKILLS:

SKILLS: Data Lineage Analysis and Data Quality Analysis 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, 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:

• 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.
• 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 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

Confidential

Team Lead/Database & BI Architect & Team Lead (contract: 5 renewals)

Responsibilities:

• 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 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

Confidential

Database Architect and Web Application Specialist Team Lead

Responsibilities:

• Created more than 6 pharmaceutical programs;
• 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

Confidential

Database Architect/Developer Specialist: Team Leader

Responsibilities:

• Developed and designed programs like Mutual funds, Portfolio Risk Management, CRM
• 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