• Over 8 years of strong experience in the IT industry as a MS SQL Server 2008/2005/2000 Developer/BI Developer in various domains like Financial, Healthcare and Banking. Maintained positive communications and working relationship at all levels. • Expert knowledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation. • Experience in analytical Database Design and Data Modeling skills using MS Visio, ERWIN, ER Studio Data Architect. • Expert in Extraction Transformation Loading (ETL), Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies. • Excellent knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools. • Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing. • Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS. • Expert in developing and modifying multi dimensional cubes using MS SQL Server Analysis Services (SSAS). • Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS 2008/2005. • Strong in developing and modifying cubes using SSAS and transform into pivot table. • Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2008/2005. • Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS) • Extensively us