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
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:
Technical Design and Architecture (DB and Business Intelligence Solutions):
ETL Development and Data Migrations
Projects/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.
FUNCTIONAL DOMAIN KNOWLEDGE
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.
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:
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:
2006
Class: MCA
Board/University: Panjab University Chd.
Marks Obtained: 75.64%
2003
Class: B.I.T
Board/University: Guru Nanak DevUniversity, Amritsar
Marks Obtained: 68.41%
2000
Class: 10+2(Commerce)
Board/University: C.B.S.E
Marks Obtained: 72.6%
1998
Class: 10th
Board/University: C.B.S.E
Marks Obtained: 64.2%
Professional Summary
Specialties:
Technology/Tools:
Software Exposure
Area Of Interest
Strengths
Awards and Achievements: further information on request
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
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:
Technical Design and Architecture (DB and Business Intelligence Solutions):
ETL Development and Data Migrations
Projects/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.
FUNCTIONAL DOMAIN KNOWLEDGE
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.
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:
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:
2006
Class: MCA
Board/University: Panjab University Chd.
Marks Obtained: 75.64%
2003
Class: B.I.T
Board/University: Guru Nanak DevUniversity, Amritsar
Marks Obtained: 68.41%
2000
Class: 10+2(Commerce)
Board/University: C.B.S.E
Marks Obtained: 72.6%
1998
Class: 10th
Board/University: C.B.S.E
Marks Obtained: 64.2%
Professional Summary
Specialties:
Technology/Tools:
Software Exposure
Area Of Interest
Strengths
Awards and Achievements: further information on request
Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.