Resolve day to day service request from the business. Add new fund and Cusip to different Database. Optimize stored procedure and functions to match the business need. Analysis the VBA Macro and resolve the sudden issues. Create multiple Excel reports using access macro. Work on various Macro connected with SQL server and MS Access database. Create new form and control using VBA to meet the business requirements. Maintain day to day work using MS SharePoint as per company requirement. Documentation all the project document and upload in the SharePoint sites. Update the query as well as the store procedure to meet the dynamic change in business rules. Using the MS office communicator directly connect to the user pc and resolve the issues. Involved in writing stored procedures, triggers, User-defined functions, sub-queries and views. Experience in creating joins for complex queries involving multiple tables. Implemented the Error handling in Stored Procedures and SQL objects and also modified existing stored procedures, triggers, views, indexes depending on the requirement. Involved in query optimization and tuning stored procedures for better performance. Worked on huge Data Transfers from & to SQL Server Database using utilities/ tools like DTS, SSIS, BCP, BULK INSERT etc. Experience in creating complex SSIS packages using proper control flow and data flow elements. Worked on different kinds of Transformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc.) in SSIS as per client requirements. Experience in Error handling by using Event Handler for SSIS packages Worked with different methods of logging in SSIS. Configured and maintained Report manager and Report Server for SSRS. Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2012. Created logical and physical data models using Erwin 7.0 to design new database after discussion with technical team and application. Analyzed data quality, by working in conjunction with the data warehouse architect on the development of logical data models. Designed and developed SSIS packages to move data from production environment to different environments within the organization. Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages. Migrated database from MS SQL Server 2008 to MS SQL Server 2008R2 using SSIS packages. Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP sources like MS SQL Server 2008R2, Oracle, Text Files, Excel and Access to OLAP with the help of MS SSIS. Used SSIS to manually transfer DTS packages 2000 to SSIS packages 2008R2. Developed and maintained a combined data store for reporting purposes. Generated reports using Global Variables, Expressions and Functions using SSRS 2008R2.