Around 5 years experience in Database Design, Development and maintenance and Testing of database applications on SQL Server 2000/2005/2008/2008 R2 in OLTP/OLAP/BI environment.• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.• Experience in Database Backup, Restore procedures.• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS. • Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management. • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.