Pawan Kumar Pal

Background

About Pawan Kumar Pal

Professional Summary: Total 5+ years (IT Support & Development) • +4 years experiences in MSBI stack Analysis, Design and Development. • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) • 1+ year’s experience on SQL Server Analysis Services (SSAS) • Data sources, Data source view, Deploy the Database,Schema,Cube Architecture, Measures, Dimensions, hierarchy, Kpi, Role, Action, Perspective etc. • Experience and understanding of SSAS, OLAP cube and Architecture. • + 2 years. Experience on ETL Architecture, DTS, Control Flow, Transaction and Data Flows in Sql Server Integration Services (SSIS). • Deployment of DTS, SSIS packages from development to production environment. • Experience in importing data from different data source like MS-Access, Excel, Oracle, Informix, XML file and CSV file. • Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages. • + 2 yrs. experience to Generating Tabular, Parameterized (single, multi), Drill Through, Drill Down, Map, Gauge, Matrix and Sub Reports in SSRS with PDF, XLS and CSV Formats. • Developing reports on SSRS on SQL Server (2005/2008 and 2008R2). Sound Experience and understanding of SSAS, OLAP cube and Architecture. • Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS. • Expert in creating Parameterized Report and linked reports. • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL. Proven Record of Consistent, Strong dedication towards work to Ensure Delivery of projects according to the Schedules.