• Responsible for installation and configuration of SQL server 2008R2/2012 database. • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012. • Involved in the Requirements Analysis, Data gathering and Database design. • Identify data issues and Address any issues that impact the business.• Rebuilding / monitoring the indexes at regular intervals for better performance using maintenance plans. • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. • Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA). • Timely Database Backup (Differential, Complete, Transactional) and Recovery. • Designing and supporting high availability SQL Server solutions that include Log shipping, Replication, Database Mirroring & Clustering. • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases. • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files. • SQL Server upgrades with new service packs and hot fixes. • Developed SSIS Packages to automate the complex data flow processes (ETL) • Developed SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions. • Working on incidents and change controls based on the client requirements. • Creating users and assigning permissions • Scheduling ETL's as SQL Server Jobs • Monitoring all server jobs daily, weekly and monthly basis.

• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes. • Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints. • Designed Physical and Logical Data model and Data flow diagrams. • Worked on various tables to create Indexes to improve query performance, also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space. • Worked with offshore team in coordinating for production support. • Involved in writing several complex Queries and Procedures using joins, sub queries and correlated sub queries. • Optimized the performance of queries by Data Manipulation which includes modifications in T-SQLqueries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins wherever necessary. • Used bitmap Indexes, materialized views and partition tables to optimize the queries. • Developed Data Mappings using various Transformations and PL/SQL Packages to extract, transform and load the data. • Loaded the data into database tables using SQL*loader from text and excel files. • Worked in Application tuning for slow running queries using Explain plan (Auto trace). • Extracted required data from the database tables and exported the data to different sources in different formats. • Used advanced Bulk techniques to improve performance. • Developed Data entry, Query and Reports, request screens and tuned the SQL queries. • Used Joins and Indexes effectively in WHERE clauses for Query optimization. • Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system. • Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key. • Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints. • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio. • Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries. • Created views to restrict access to data in a table for security. • Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report. • Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS • Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server. • Scheduled the monthly/weekly/daily reports to run automatically. • Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email. • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS. • Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

• Extensively worked with Informatica 8.6/7.x, Power Exchange 8.x, Oracle9i/10g, PL/SQLProcedures, Unix Shell Scripts, Business Objects Report development. • Facilitates the gathering, consolidation and prioritization of client business requirements for various ETL Developments across the enterprise. • Participated in designing and developing of the ETL/BI architecture for all business intelligence solution components including database design, ETL, report design and system integration. • Developed complex Mappings, Sessions, and Workflows using Informatica Mapping Designer, Workflow Manager respectively. • Designed ETL specification, PL/SQL Procedures and Unix Scripting to populate reporting data mart for Remaining Principal Balance RPB application associated with different Issuers, Investors and Custodians. • Documented user requirements, translated requirements into system solutions, and developed implementation plan and schedule. • Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance. • Issue Tracking and Defect Collection. • Worked very closely with the Reporting team and was responsible for creating few Issuer reports using Business Objects XI.