• 9 years of experience as Business Intelligence Developer in Development, Production
In SQL Server[removed]R2.
• Expertise in SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS & SQL Server Reporting Services SSRS.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services SSIS.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Experienced in programming tasks-Stored Procedures, Triggers and Cursors using SQL Server 2008 R2 with T-SQL.