• Involved in Creation, Development , Deployment and monitoring of SSIS packages in SQL Server 2012• Created SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements• Extracted data from various sources like SQL Server 2008/2012, CSV, Excel and Flat files and Oracle JDE from Client servers and through FTP.• The packages created included a variety of transformations, for example Look up, Aggregate, Derived Column, Conditional Split, Multicast and Data Conversion.• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, data flow task, Script task and send mail task• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments • Developed Database Objects such as Tables, Views, Stored Procedures, Functions and used MERGE statements instead of using Cursors in T-SQL using SQL Server Management Studio (SSMS).• Developed WCF services to send and retrieve data from eWPS to external systems such as QRMS, JDE by calling SSIS packages from WCF Services and vice versa.• Designed and Developed Reports using SSRS.

 Designed and Developed a new module Returned Mail to CIS system Worked on enhancements of AE Module  Implemented Change Requests  Designed and Developed Automated email alert for excel Monthly Reports generation for Client Module using XML and XSLT  Worked on enhancements of Report Module Automated Monthly and Daily Statements generation  Worked on Bug fix projects  Developed new SSIS packages to download and process the data from Singapore Exchange and Hongkong Exchanges respectively Involved in migration of existing DTS packages to SSIS packages Responsible for Automation of downloading the necessary files into the system Processing adhoc data requests and manual changes raised by users as part of daily support

 Application development using agile software development methodology with Scrum framework. Requirements gathering by attending user meetings Developing the application using ASP.NET 3.5, with C# Involved in phase by phase development documentation along with test suits. Involved in Unit Testing and deployment. Presenting the application to the users Prepared the user guide.

 Developed WebForms using C# and ASP.NET Developed application logic using C# Involved in writing WebServices. Involved in writing queries, stored procedures  Prepared the Unit Test cases. Performed Unit testing ,Integration testing Interacted with UAT Team in testing phase.

 Developed User Interface Screens using WinForms. Developed middle-tier components retrieving and modifying data in the database according to users request using ADO.NET. Involved in writing queries, stored procedures and in tuning the stored procedures for performance improvement Involved in implementing Change Requests as part of production support. Prepared the Unit Test cases. Performed Unit testing ,Integration testing Interacted with UAT Team in testing phase.