Discuss data demands with the Business UsersAnalyze the source data and to design the target layout as per requirement. Create the data models for data demand provided.Prepare workflow charts and diagrams to specify in detail operations to be performed by equipment and computer programs and operations to be performed by personnel in system.Conduct studies pertaining to development of new information to meet current and projected needs.Deployment of Change request to implement business functionality in Production and other lower environments.Review the peers work and code.UAT/Production issues support and resolutions.Used RTC as a repository for the code versioning.Worked with the Release Life cycle management tool to get the code deployed in the various environments.Analyzed the differences in the datatypes between Oracle DB and NZ DB and provided the necessary script fix.Analyzed and Updated the Entity sheets for the new entities or attributes being added in the model.Created Design documents for schema changes, tables, SP’s.Resolved Critical/High defects on time in different environments like SIT, PCT, PAR, UAT, PROD.

I have 7 years 3 months of experience in Database Design, Development and Administration in MS SQL Server 2008R2/2012/2014 in OLTP and Data Warehouse environments. My key areas were: Experience in creating/modifying Tables, Views, Stored Procedures, Functions and Triggers and knowledge in query optimization and Performance Tuning. Expertise in Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS) Tool. Worked extensively on Unit testing and Integration testing in projects involving Data Migration (2005 to 2008). Worked on Reconciliation, Integration Testing and Volume testing to check that the data is correct. Have knowledge on Team Foundation Server (TFS) Basic knowledge on SSRS and SSAS. Have knowledge of Power BI Reporting tool. Highly motivated, hardworking, excellent team player with ability to handle multiple tasks and a cent percent optimist. Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal, communication skills, desire to excel, fast learner, hardworking and a good team player.