SUMMARY:

• Sr. IT Consultant with 20+ 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 21 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): 16 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

PROFESSIONAL EXPERIENCE:

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

Responsibilities:

• Participated to help balance the data. Helped users finding the problem with non-balance accounts.
• 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.
• 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 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

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

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

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