PROFILE:

• I am working on IT since 24 years, including 22 years using SQL server and 16 years using business intelligence tools (SSRS, SSIS, ETL, and SSAS).
• I have performed various complex work using: SSRS, ETL (SSIS), SQL server, OLAP cube (SSAS) I have taken various responsibilities: Programmer, IT Manager, team lead, Analyst I am very good at: data modeling, data performance, data base/ 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.
• I am autonomous and versatile, I could adapt easily to the client s expectations.

PROFESSIONAL EXPERIENCES:

Confidential, Boston, MA

Database, Data architect and BI developer 

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

Confidential, Augusta, Maine

Database, Data architect and BI developer (consultant)

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.

Confidential

 St.Louis, Illinois.

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

Manhattan, NY

Responsibilities:

• 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
• I have created SSIS packages to import data from live databases and other sources like flat files, excel to the data mart.
• I have used the incremental load, to load the new and the updated rows.
• I have configured the packages to use external parameters like the server name the data base name the folder name and ..
• I have 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 ( that summarize everything in the portfolio): I have used MXD to generate this report from the cube.

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,

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

• To create packages with SSIS
• To fix the performance problems
• To 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, MOLAP, Transact/SQL, MDX, TSF, Kimball methodology, Microsoft Access, , Microsoft SharePoint, Power BI.

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 the a new request
• 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

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

Responsibilities:

• 22 SSIS Packages;
• 44 Reports with SSRS;
• 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

Database & BI Developer and architect 

Responsibilities:

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

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

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

Responsibilities:

• 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

TECNOLOGY EVALUATION:

Database + BI Architect/Developer/IT Manager

Responsibilities:

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

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

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, and 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, DCOM