Currently working as Associate Consultant in TCS Gurgaon for Aon Account. I was rebadged from AON to TCS because Aon- ARS North America ITG Account was outsourced to TCS. Leading a team of 5 DBA members.

Shared Services Team for AMS and AD

• Special expertise in building and leading top performing Shared Services teams serving horizontally for different Business Units and Organizations.
• Managing client relationships, delivering end-to-end DB infrastructure solutions
• Extensive experience in successful Data Center Migrations, DB Up gradations and Data migrations from File based Systems (Mainframe, Lotus Notes) to Relational DBMS.
• An experienced professional with extensive experience in Database health assessment and performance tuning.
• Managing Operations DBA, Engineering Solutions DBA and Application DBA Teams
• Internal Trainer for SQL Server in multiple organizations.

Leading a team of 4 members.

Shared Services Team
Working in Shared Services SQL Team and supporting multiple applications across ARS North America account and working on DBA, Development, DB Design and architecture, Data Migrations, Performance Tuning, Data Warehousing and BI Activities in Multiple Portfolios.

Application DBA:

• Involved in Data Center Migration from CSC to Aon.
• Providing Application Production support to various applications in various portfolios.
• Supporting Application Jobs in different Production environments. Supporting 80+ Servers.
• Performance Tuning and Optimization of long running queries, stored procs, SQL Jobs etc
• Configuration and Monitoring of servers using Spotlight.
  
  • Disk, Memory, CPU, Long Running queries, Deadlock.
• Reading Deadlock Graphs
• Setting Code Development guidelines, Design reviews and code reviews on DB code written by Application/Front Developers.
• DB Capacity Planning.
• DB Up gradation

Technical Design and Architecture (DB and Business Intelligence Solutions):

• Code Development with T-SQL, SSIS, SSRS and SSAS.
• Design and architecture Reviews of DB and BI solutions in multiple applications like BD, Aonwrap and NGG.
• Providing Archiving and Partitioning Solutions to Huge Tables in multiple Applications.
• BI Infrastructure (SSIS package deployment, SSRS, Managing other BI tools for Ad-hoc reporting)

ETL Development and Data Migrations

• Data Migration from Lotus Notes to SQL Server 2012- NGG Project
• Migration of Legacy DTS Packages to SSIS 2012.

Projects/Applications:

• Colo Data Center Migration
• NGG- Lotus Notes to SQL Server 2012 Migration
• BD Data Warehouse and OLTP Applications
• Aonwrap Application and Reporting.
• Oracle HTML DB Projects
• ABL, Aonwrap, GCP, Affinity, CRP, NAR Applications.

Leading a team of 4 members.

RBS (Royal Bank of Scotland)
RBS is a Fortune 500 company (Investment Banking) with employee strength of 135000 and placed among top 20 banks in the world. RBS has more than 40 well known consumer brands including RBS, ABN Amro Bank, NatWest, Direct Line, Churchill, Coutts, Ulster Bank and Citizens Bank etc.

Markets-BI
Markets MI provides Management Information to person involved in Investment banking with Royal Bank of Scotland (RBS). This is a very huge system in which trade data comes from more than 40 feeds systems like Sempra, Kondor, Anvil, Sapphire, ICE, GDS, GFX, Calypso, WallStreet, ABN Amro system like CMIS and Crissie, Greenwich and many more. Loading strategy is based on Extraction Loading Transformation (ETL) rather than conventional ETL concept.

Roles and Responsibilities:

As a Leader of Data Warehousing Team, I am involved in the following Activities.

• Performed design and technical architecture validations for the whole engagement.
• Provide technical support to the development team and performed testing validations
• Coordinated implementation activities with all cross functional teams like (DBA, Windows, Infrastructure etc..,) continued with hyper care support.
• Engaged at the highest level of management at the client organization to provide solutions and case studies with the latest BI features for organizations Banking applications.
• To interact with the client on critical issues, manage customer expectations & align customer business goal.
• Responsible for leading development teams both Onsite and Offshore to ensure smooth delivery.
• Coordinate Weekly Status, Prioritization and Incidence Review Calls.
• Involved in identifyingand applying data modeling techniques and best practices.
• Analysis of business requirements with the help of Business Analysts Leads.
• Creation of logical / physical relational data modeling using Erwin
• Transform logical models into physical database designs for staging areas, data warehouses, and data marts
• Involved in identifyingand applying data modeling techniques and best practices.
• Analysis of business requirements with the help of Business Analysts.
• Prepared functional specification and program specification documents like Technical docs, Unit Test Case, Test Request etc.
• Creation and modification of ETL packages using SSIS.
• Creation and Modification of Data Marts, Cubes and Dimension, Measures/ Facts& Calculation using SSAS.
• Creation of T-SQL Objects such as Stored Procedures, T SQL queries, Functions, Tables, Views, Triggers, Scripts, Global code and other Database Objects using Transact SQLPerformance Tuning of queries and stored procedures.
• Responsible for deployment of ETL packages and Cubes.
• Responsible for providing facility of slice and dice and roll up features using SSAS Cube.
• Database Schema Design and Normalization/ DeNormalization using appropriate Standards and data warehousing concepts.
• Troubleshooting jobs failure and L3 Support
• Preparation of deployment guide and Unit Testing and SIT using Autosys scheduler.
• Migration of DTS into SSIS
• Creating Backup Policies and Recovery Model and implement it on production database.
• Change Request Management.
• Support to the Testing and Production Databases.
• Interacting with Offsite and Onsite Team members for understanding the requirement and functionality of different requirements and delivering the stored procedures, SSIS Packages, etc and providing support.
• Creating a data model(Logical and Physical) by applying formal data model descriptions using data modeling techniques. CA ERwin Data Modeler (ERwin) is used for data modeling (data requirements analysis, database designetc) of Sales MI databases.
• Used reverse engineering which is a process that takes advantage of an existing database to create a data model, ERwin lets us reverse engineer the database schema which is converted into a graphical representation of the database structures in a new model. The process of reverse engineering saves considerable time because ERwin does the work of creating a new data model directly from the database.
• Creating DB Maintenance Plans, Scheduled Database Maintenance jobs, Database Roles, DB users, Logins.
• Incremental Changes to be done on Database during Labels, Sanity Releases and Production Releases during Project Delivery using SQL Delta.

FUNCTIONAL DOMAIN KNOWLEDGE

• Banking & Finance (Investment Bank)
• Financial markets instruments like Money Market Instruments, FX Market Instruments, Derivatives, Bonds and Equities.
• Knowledge of various Asset Classes and Financial Products, Trade Life Cycle.
• Supply Chain Management (SCM)

MPAS- Data Migration
The State Retirement and Pension System (SRPS) of Maryland were among the first to automate the management and administration of its services by adopting the mainframe technology. True to its legacy of deploying technology to enhance services, the state is now poised to employ bleeding edge expertise in the pension and retirement domain.
MPAS-1, the first phase of this project has “Modernizing Legacy Technology” as its theme. MPAS-1 aims to transition the pension and retirement system from the mainframe to the Microsoft Technologies.

Roles and Responsibilities:

As a Leader of Database Migration Team, I am involved in the following activities.

• Managed a development project involving transforming MainFrame Project of Legacy Retirement System into .Net and SQL Server Platform.
• Achieved smooth transition to offshore team to support the critical applications and lead the team to support these applications with adherence to the Service Level Targets.
• Creation of logical / physical relational data modeling using Erwin.
• Involved in identifyingand applying data modeling techniques and best practices.
  5. Creation of SSIS (ETL) package, Changing SSIS for data migration of
  mainframe VSAM File client data, transforming it in specified structure
  and loading in our relational database structure.
  6. Transform logical models into physical database designs for staging
  areas, data warehouses, and data marts
  7. Creating Backup Policies and Recovery Model and implement it on
  production database.
  8. Database Development, which includes Creation of Stored Procedures,
  T-SQL queries, Functions, Tables, Views, Triggers, Scripts, Global code
  and other Database Objects using Transact SQL.Performance Tuning of
  queries and stored procedures.
  9. Database Schema Design and Normalization using appropriate
  Standards.

Objective:

eCloserTM is a comprehensive Web-based title and escrow management system designed to fully automate order entry, transaction management and status reporting, title production, escrow closing and settlement, creating and balancing disbursements, account reconciliation, recordation, policy creation, and file storage.

As a member of Database Team, I am involved in the following
activities:

• Creation of SSIS (ETL) package for extracting the client data, transforming it in specified structure and loading in our structure.
• Database Development, which includes Creation of Stored Procedures, Functions, Tables, Views, Triggers, Scripts and other Database Objects using Transact SQL.
• Database Administration activities such as Back Up, Restore, Performance Tuning, Log shipping, Creating DB Maintenance Plans, Scheduled Database Maintenance jobs, Database Roles, DB users, Logins.
• Backup Policies and Recovery Model to be defined and implemented.
• Database Design and Normalization using appropriate Standards.
• Incremental Changes to be done on Database during Labels, Sanity Releases and Production Releases during Project Delivery.
• Change Request management.
• Maintaining Configuration Data for different Databases.

Objective:

Greenfield Online is an Online Market Research Firm based in US, which conducts online surveys throughout the world. It has a panel size of 3.5 Million Panelists.

As a member of Database Team, I am involved in the following
activities:

• Database Development, which includes Creation of Stored Procedures, Functions, Tables, Views, Triggers, Scripts and other Database Objects using Transact SQL.
• Database Administration activities such as Back Up, Restore and Performance Tuning of the Database.
• Manage databases and provide support to the Production, Testing and Development Databases.
• Interacting with Offsite and Onsite Team members for understanding the requirement and functionality of different modules and delivering the stored procedures and providing production support.