EXPERIENCE SUMMARY:

• Around 8 years of experience in Database programming, System Analysis, Design, Development & Support of MS SQL Server 2000/2005/2008 on various domains like Loans, Financial and Health and Equipped with excellent communication and interpersonal skills and has in-depth understanding of Trade life cycle and Trade settlement process
• Experience in writing complex queries involving Multiple Table Inner and Outer Joins, Temporary Tables, Table Variables
• Wide working experience in “high availability” SQL Server solutions using Log shipping, Replication, Mirroring and SQL Server clustering
• Maintained large amount of tables by partitioning and indexing.
• Experience in creating, maintaining and tuning Views, Stored Procedures, Functions and Triggers and strong RDBMS concepts using SQL Server, T-SQL.
• Working experience in managing, monitoring and tuning SQL Server performance using SQL Server Profiler/Monitor and Windows Performance Monitor.
• Expert in Transact-SQL (DDL, DML).
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc)
• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experience in extracting and transforming (ETL process) data using DTS/SSIS Import
• Export Data from various sources, Bulk Insert, BCP and DTS/SSIS Packages.
• Hands on migrating DTS Packages to SSIS packages.
• Experience in pulling data from DB2 to SQL Server using SSIS.
• Good Experience in creating Master Child Packages in SSIS.
• Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, and fact and dimension tables in SSAS
• Good experience in Designing Aggregations and pre-calculating the same in SSAS.
• Actively involved in Processing Cubes, adding KPIs and Calculated Members.
• Extensive experience in Optimizing Cubes using SQL Server Analysis Services (SSAS) 2005.
• Experience in SSIS script tasks, Control flow tasks and Data flow tasks using T- SQL.
• Extensive experience in the development of Reports using SQL Server 2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports and score cards in multiple formats using multi – dimensional objects.
• Deployment of SSRS Reports on SharePoint Portal and integrating Reports, Analysis Reports with SharePoint 2007(MOSS).
• Good experience in ASP, C# VB.net, SQL Server tools DTS, SSIS, SSAS and SSRS.

Having good knowledge on Backup and Recovery

• Proficient in maintenance and optimization of Database and Server.
• Using performance monitor/profiler to solve deadlock/long running queries
• Experience working in a clustered OLTP environment with Very Large Databases (VLDB) and having version control (Visual SourceSafe and Team Foundation Server).
• Experience in logical and physical data modeling using ER Studio and Microsoft Visio.
• Thorough understanding of Kimball’s’ theory, KPI’S, SQL 2008 Architecture.
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.
• Evaluated server performance bottlenecks by analyzing Memory usage, CPU Processor utilization, Disk reads/writes, User connections and Locks with System Monitor.
• Created stored procedures for reporting purpose from i-batis(XML) files.
• Supported offshore testing team during late hours of the day.
• Experience is providing 24X7 support and on call rotation schedule

EDUCATION:

• Bachelor of Technology in Electrical Engineering.

TECHNICAL SKILLS:

Databases

MS SQL Server 2000/2005/2008R2

Database Tools

Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Replication, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS).

Reporting Tools

SQL Server Reporting Services(SSRS), Crystal Report

ETL Tools

SQL Server Integration Services(SSIS), Data Transformation Services(DTS), BCP, SQL Server Analysis Service(SSAS)

Languages

C, C++, T-SQL, PL/SQL,C#.Net

Web Technologies

Web Services, XML, HTML

Operating System

Windows NT/2000/2003/XP, Vista, BizTalk Server

Applications

MS-Office suite, MS Visual Studio 2005

Protocols

HTTP, TCP/IP, FTP

Exposure

MS SQL Server 2012, Informatica

PROFESSIONAL EXPERIENCE:

Confidential,Two Months
Virginia Beach, VA
SQL Server DBA/SSIS/SSRS

Project Description:

The scope of the project is need to work on disaster recovery for Sql Server databases and need to synchronize with data between the databases. Worked on migrating the databases using SSIS. The data is related to health services and I worked facets databases. Which is more important for claims. I recover the data in high availability mode.

Responsibilities:

• Worked with refreshing databases on Dev, QA and Prod to maintain synchronization with Production.
• Involved in Restoration and Backup of Databases periodically.
• Involved in replication (transactional) of database mostly and database snapshots.
• Used SQL DB Compare tool to Compare databases between Dev, QA and production Environments and synchronies them.
• Helped in Converting 12 SSIS packages to Informatica.
• Migrated the data using SSIS.
• Worked with changing connection strings with SSIS packages when splitting single source database to three source databases.
• Trouble shoots same SSIS packages by logging method the packages before forwarding to quality analysis (QA) testing.
• Configuring SSIS packages when migrating packages from 2005 to 2008.
• Error handling using integration services.
• Involved in testing on the store procedures using execution plans and performance tools.
• Scheduled SSIS Packages, using SQL Server Agent.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Evaluated server performance bottlenecks by analyzing Memory usage, CPU Processor utilization, Disk reads/writes, User connections and Locks with System Monitor.
• Monitored the growth of database objects for capacity planning of databases.
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Used Snapshot Isolation in SQL Server 2005.
• Used Data Mirroring two synchronize the data between two servers during disaster recovery.
• Created the document for disaster recovery plan.

Confidential,Jan’12-Tilldate
State Of California, Sacramento, CA
SQL Server DBA/SSIS/SSRS

Project Description:

The scope of the project is needed to insert data from flat files to the databases. Actual the data of the flat files related to medical and health services. Before inserting the data in to the databases, we need to validate the data by separating the header and body records of the flat files in two batches. Validation conditions provided in SPEC by EDD department. Need to maintain those databases for better retrieval with good performance. Here I got a chance to work on ETL tool (SSIS).

Responsibilities:

• Experience in working with fixed width flat files and did validation of header records using C#.NET conditions provided in SPEC.
• Using SSIS ETL tool I inserted data in to the required tables.
• Developed stored procedures for complex sub queries and joins using multiple tables.
• Implemented newT-SQLfeatures added inSQL Server 2005that areData partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE) , Data Partitioning, Snapshot Isolation
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2005tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Extensively used T-SQL in constructing user functions, views, indexes.
• Involved in creating SQL reports, data extraction and data loading scripts for different databases and schemas.
• Got a good knowledge on Team Foundation Services (TFS) which we use to maintain databases up to date and we also use TFS for storage of updated scripts and also to avoid the data loss.
• Experience in refreshing the databases and also know how to check with orphan users.
• Experience in working with SQL Server Agent Jobs and also scheduling the jobs to SSIS packages is my daily job.
• Worked on mirroring the databases for local servers of my team to keep the data up to date in between my team members. Without disturbing the whole environment by updating the scripts in TFS server.
• Expert in Full and Differential backup of the databases.
• Has a good knowledge on full, bulk and simple log recovery model.
• Obtained knowledge on cluster servers.
• Monitoring the event logs and Server error logs using DBCC utilities for troubleshooting purposes.
• Expert in SSIS deploying (flat file and SQL server deployment) and Scheduling.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Experience in configuring the SSIS packages using SQL server parameter databases. I mean experience in SSIS packages configurations like SQL server, XML files and Parent Package Configurations.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Identified Performance issues using SQL Server Profiler/Monitor and improved by Tuning, Indexing, and Query Optimization using Tuning Wizard.
• Tuned SQL statements (Using Indexes) and Stored Procedures.
• Knowledge on backup jobs on weekly basis and we store the back file in tapes and storages devices like TFS.

Environment: Microsoft SQL Server 2008 R2 Enterprise Edition, SSIS, C#.net, Windows Server windows 7/XP, Visual Studio 2010 & TFS.

Confidential,Ca May’11-Dec’11
MS SQL Server DBA/ETL(SISS)
Project Description:
The scope of the project involved working in Archive Retrieval Services which include table partitioning to maintain huge amount of data in tables and fast retrieval of data from the selected tables. The requirement of the customer is need to get displayed with selected records in the reports with in mille seconds. Need to maintain indexing like rebuilding and lot of maintenance work like checking with scalability, replication and log shipping. Worked with writing stored procedures for swapping data from one table to another table and creating automatic partitions with help of stored procedures. Used integration services(SSIS) for data movement from one table to another table. Involved in other projects for creating store procedures from MYSQL and MSSQL side.
Responsibilities:

• Need to maintain large amount of tables by partitioning and indexing.
• Created stored procedures to build partitions and data swapping. Data swapping using partition concepts help’s to move large amount of data from one active table to archive table with in no time
• Created complicated triggers like for inserting and deleting data in active tables which reference to sub tables.
• Worked with refreshing databases on Dev, QA and Prod to maintain synchronization with Production.
• Involved in Restoration and Backup of Databases periodically.
• Involved in replication (transactional) of database mostly and database snapshots.
• Used SQL DB Compare tool to Compare databases between Dev, QA and production Environments and synchronies them.
• Worked with changing connection strings with SSIS packages when splitting single source database to three source databases.
• Trouble shoots same SSIS packages by logging method the packages before forwarding to quality analysis (QA) testing.
• Configuring SSIS packages when migrating packages from 2005 to 2008.
• Created stored procedures for reporting purpose from i-batis(XML) files.
• Used integration services (SSIS) to extract data in to the tables from i-batis(XML) files
• Error handling using integration services.
• Involved in testing on the store procedures using execution plans and performance tools.
• Scheduled SSIS Packages, using SQL Server Agent.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Evaluated server performance bottlenecks by analyzing Memory usage, CPU Processor utilization, Disk reads/writes, User connections and Locks with System Monitor.
• Monitored the growth of database objects for capacity planning of databases.
• Migrated data from Oracle to SQL Server
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Used Snapshot Isolation in SQL Server 2005.
• Using log shipping for synchronization of database.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Worked on Huge Data Transfers from & to SQL Server Databases using SSIS, and used configuration files and Environment variables for production deployment
• Evaluated data storage considerations to store databases andtransaction logs. Created databases usingTransact SQL Statements,SQL Server Management StudioandDatabase Wizard.
• Involved in managing and scheduling daily jobs related to data transfers, backup and recovery using SQL Server Agent.

Environment: Microsoft SQL Server 2005/2008 Enterprise Edition, SSIS, SSRS, SSAS, Windows Server 2003/windows 7 and

Confidential,San Francisco, CA Mar’10-April’11
­­ MS SQL Server Developer.

Project Description:
The scope of the project involved working in multiple projects which included data migration from heterogeneous data sources. We do migration of data from Wachovia bank to Wells Fargo bank. So we have to migrate data from access, oracle database using TSQL and SSIS, stored procedures packages to destination. We have to schedule jobs using agent sever to maintain transactions.
Responsibilities:

• Responsible forInstallation, Configuration, Security, Maintenance, Restorationof SQL server 2005 on windows server 2003.
• Gather and Analyze Business Requirements by interacting with Business and end users.
• Involved in creating FunctionalSpecification Documents(FSD) by Analyzing Business Requirement Documents (BRD)
• Created SSIS Packages using complex transformations to import data from Access Databases
• Configured and managedLinked Serversbetween SQL Servers and oracle 10g.
• Implemented performance tuning and query optimisationusing various SQL Server tools such as SQL Profiler, SQL Performance Monitor, Execution plan and Index tuning wizard.
• Involved in Restoration and Backup of Databases periodically.
• Created stored procedures with complex transformations to migrate data from Oracle databases to SQL Server 2005.
• Used SQL DB Compare tool to Compare databases between Dev, QA and production Environments and synchronies them.
• Created SSIS packages to pull legacy data from Oracle, flat files, and spread sheets to SQL server 2005
• Involved in configuration and Maintenance of SQL server Agent Jobs
• Log files creation and improvement using Custom Component
• Developed SSRS report to analyze migrated data (Sales Force) for core objects and child objects.
• Created Complete Data migration documentation (high-level and technical).
• Error Handling using Custom Error Component.
• Implemented newT-SQLfeatures added inSQL Server 2005that areData partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE) , Data Partitioning, Snapshot Isolation
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2005tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Developer various reports on core objects for various criteria like what accounts have been added
• recently, who are the contacts to my current accounts, Leads with the status of working, and few more

on opportunity.

• Have deployed packages on different servers by configuring it.
• Scheduled SSIS Packages, using SQL Server Agent.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environment: MS SQL Server 2005, T-SQL, Oracle 10g, 11i, access 2003, Visual Source safe, SSIS, SSRS.