Windows Server 2003, Windows 2000 advanced server/ Professional, Windows 7/ Vista/ XP/ 2000/ 95/ NT Microsoft Visual Source Safe, Microsoft ProClarity Jira, Team Foundation Server TFS 2010/2008/2005 SQL Server Management Studio SSMS, SQL Server Business Intelligence Development Studio BIDS, SQL Server Enterprise Manager, SQL Profiler, SQL Agent, Query Analyzer, DTS Import/Export Wizard, Microsoft Office PerformancePoint Server 2007, Performance Monitor, Database Tuning Wizard, Microsoft Visual Studio. SQL Server Reporting Services SSRS 2012 2008-R2 2008 2005, Power Pivot and Business Objects, SQL Server Analysis Services SSAS, Crystal Reports SQL Server Integration Services SSIS 2012/2008-R2/2008/2005, Data Transformation Services DTS T-SQL, PL/SQL, HTML, DHTML, XML, C, VB.NET, ASP.Net. Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills and has ability to handle multiple tasks can take initiative to handle responsibilities independently as well as a proactive member of a team.Created and configured data source and data source views, dimensions, cubes, measures and MDX queries using SSAS.Experience in designing and building the dimensions and cubes with star and snowflake schemas using SSAS.
Well-versed in usage of SSIS control flow items.Experience in extraction and migration of data from heterogeneous data sources like Excel, MS Access, oracle, flat files and DB2 to MS SQL server by using import export wizard and SSIS.Expert in data extraction, transforming and loading ETL using various tools such as SQL server integration services SSIS, DTS, bulk insert and BCP.Thorough knowledge of addressing performance issues and involved in index tuning, performance tuning, query optimization, database optimization, data profiling and database consistency checks using DBCC commands.Excellent command over managing alerts, operators and jobs through SQL server agent.Expertise in writing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views and cursors.Extensive work experience in normalization and de-normalization techniques on both OLTP and OLAP systems in creating database objects like tables, constraints primary key, foreign Key, unique, default, check, indexes.Expert in developing T-SQL DDL, DML statements, data integrity constraints and worked on validation issues.
Skilled software professional over 7 years of IT industry experience with Microsoft SQL Server, Integration Services SSIS, Reporting Services SSRS and Analysis Services SSAS environments.