Around 3-4 years of experience in Database Design, Development, Deployment of large-scale enterprise applications and testing in various projects executed in T-SQL environment.
Have a good knowledge in MS SQL Server 2005/2008/2008R2 products like SSIS, SSRS.
Have a good knowledge in ETL, DSS and Data Warehousing.
Created different Reports using SSRS.
Designed/Implemented the testing environment for MS SQL Reporting Services.
Skilled in High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, Flat File, Text File Data).
Experienced in defining Data Sources for creating data source views.
Successfully created Fact & Dimensions Tables and joined them to extract meaningful data.
Expert in designing Reports using SQL Server Reporting Services (SSRS) and Excel Pivot tables.
Experience in using tools like SQL Profiler, Index Tuning Wizard and Windows performance Monitor for Monitoring and Tuning MS SQL Server Performance.
Highly proficient in the use of SQL Server and T-SQL in constructing Tables, functions, views, indexes, Stored Procedures , user profiles Relational Database Models, Data Dictionaries, Data Integrity, SQL Joins and effective Triggers to facilitate efficient data manipulation and data consistency. Good understanding of Normalization and De-normalization.
Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduling DTS/SSIS Packages.
Experience in migrating data from SQL Server to Oracle