• 6+ years of experience in Business Intelligence -MSBI Stack.
• Having 6+ year of experience in Data warehousing developing and enhancement of cubes (SSAS) in multidimensional model and 3 year of experience in creating and modifying cube in tabular model.
• Having 6+ years of Experience on ETL Architecture, DTS, Control Flow, Transaction and Data Flows in SQL Server Integration Services (SSIS).
• Having 6+ year of extensive expertise in reporting tool (SSRS) - Generating Tabular, Parameterized (single, multi), Drill through & Drill Down, Map, Gauge, Matrix and Sub Reports in SSRS with PDF, XLS and CSV Formats.
• Lead or actively managed team of EDW engineers on Projects.
• Having 2+ year of experience in TABLEAU Reporting Tool.
• Having 2+ year of Experience in DAX and MDX Language.
• Experience in Installation, Configuration, Deployment and security of SSRS.
• Involved in data migrations, transfers and BI Development and Deployment of SSIS packages from MS-Access, Excel and CSV, SQL SERVER, MYSQL and Salesforce.
• SALESFORCE database integration using DBAMP and SSIS.
• Experience in creating Jobs, Scheduled SSIS Packages.
• Experience in creating dashboards using Power BI.
• Experienced in Stored Procedures, Dynamic Queries using SQL Server 2012/2008/R2 with T-SQL.