• Created Database objects - tables, views, and functions.• Implemented physical database design in SQL Server 2008.• Responsible for transferring the data using SSIS packages.• Queried Triggers and Stored Procedures and T-SQL Queries to capture updated and deleted data from OLTP systems.• Worked with SSIS in using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc. • Analyzed database population routines (ETL) and ensure quality of production load processes.• Wrote T-SQL queries using different kinds of joins and also implemented functionality for removing duplicate records like using CTE and ranking function.• Worked collaboratively with DBA to Improve Performance of the database by creating Stored Procedures, Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements.• Designed SSIS packages to migrate the data from DB2, flat files, excel documents and CVS files to the Staging Area in SQL Server. • Worked on large Data Transfers from and to SQL Server Databases using SSIS and used Configuration Files and Environment Variables for production deployment. • Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments. • Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS. • Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.• Created SSIS packages to load data into SQL Server using various transformations in SSIS.