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

TECHNICAL SKILLS

• TSQL, Procedures, Tables, indexes, views, triggers
• SSIS, SSRS, SSAS, SQL DQS, and OLAP): 17 years
• ASP.net, C#, VB, VB.net, HTML, JavaScript, VBScript, Visual SourceSafe, SharePoint: 10 years
• DAX, MDX
• Power query, Power View, Power Pivot, Gateway, Hybrid

PROFESSIONAL EXPERIENCE

Confidential

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

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

Database & BI Developer, Analyst

Responsibilities:

• 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

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

Confidential

Database & BI Developer and architect

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

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

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