Sql Server Project

Gaganmeet Kaur

Mail id: ******.*****@*****.***

Mobile: +91-880*******

RESUME SYNOPSIS :

2.7 years of experience in Information technology industry with significant exposure in Design/Development of ETL solutions using Informatica 8.5, Oracle 9i and Unix

Well versed with Data Warehouse ETL solution SDLC processes

Ability to manage a team and with continuous development towards achievement

Excellent written and verbal communication skills, presentation and problem solving skills

Excellent team player, quick learner and demonstrate ability to handle multiple deadlines

Respected by peers and managers for cooperativeness, professionalism, creativity, accountability and responsiveness.

TECHNICAL SKILLS :

Languages : C/C++/Java

Databases : Oracle 9i, SQL Server

Operating System : Windows, Unix

ETL Tool : Informatica Power Center 8.5 /SSIS

Reporting Tool : Business Objects/SSRS

WORK EXPERIENCE :

Name of the company Designation Total Experience

Infosys Limited, Pune

Senior Systems Engineer 2 years 7 months

TECHNICAL TRAINING PROGRAM:

Name of the Training Program Company Duration period

Trained in BI stream and was trained in MS BI suite. ETL tools such as SQL Server Integration Services (SSIS), Reporting tools like SQL Server Reporting Services (SSRS) Infosys Technologies Limited,

Mysore

Jan2010– May 2010

WORK HISTORY:

Project Name Enterprise Performance Visibility

Client AstraZeneca Pharmaceuticals Ltd

Work location Pune

Description Supporting AstraZeneca customer and client based application

The project aims to significantly improve the visibility of AZ's performance across the enterprise to support decision making, providing a central store of trusted and consistently defined data. It supports operations, finance and Commercial data. This data acts as a source for several reports.

Role ETL Developer

Responsibilities • Involved in developing Informatica Mappings

• Resolving ETL issues based on Informatica.

• Modification of database to include new columns in tables

Partnered with onsite coordinator to ensure coding standards.

Bug Fixes and Code Enhancement

Solution Environment Informatica Power Center 8.5, Oracle 9i

Project Name SSM Implementation

Client Sysco

Work location Pune

Description The source data was fetched from various sources like flat files, Oracle for different vendor’s locations and was processed with validations to check the quality of the data. Before loading to the database we loaded the data into staging tables and then loaded it in into Database

Role ETL Developer

Responsibilities Involved in modifying Informatica Mappings

Solution Environment Informatica Power Center 8.5, Oracle 9i

Project Name Competency Development of fellow Infoscions on Data Warehousing/Business Intelligence

Client E&R, Infosys

Work location Mysore

Description Training fellow Infoscions both in classroom and virtual modes on BI Concepts and related tools like SQL Server, Perl, SSIS and SSRS. Development of relevant content to be used as training materials for the above mentioned trainings

Role Technical Trainer/Educator

Responsibilities Content Development

Facilitation

Development of assignments and assessments

Evaluation of assignments and assessments

Solution Environment MS BI Suite

CERTIFICATIONS

Business Intelligence & Data warehousing training from Infosys EnR

Internal Informatica Power Centre Developer

ACHIEVEMENTS/RECOGNITION

Got Confirmed in Top 5% Employee

Was a 5 Pointer at training Days with a CGPA of 5

Only Fresher to get CRR of 1 at our Unit at Pune DC

Won a BRAVO Award (on the spot) at Unit Level in recognition to the stellar contribution to the team

Contributed a portion of a chapter in ETL for the published book titled “Fundamentals of Business Analytics” authored by Infoscions, R. N. Prasad and Seema Acharya.

7th Merit holder in Electronics and Instrumentation at UPTU Tech University

ACADEMIC CHRONICLE :

Degree University/

Board Institute Year of Passing Specialization Percentage

B.Tech. UPTU, Lucknow Meerut Institute of Engineering and Technology, Meerut 2009 Electronics and Instrumentation 78.4%

XII CBSE Board Montfort School, Roorkee 2005 Science 79.6 %

X CBSE Board Montfort School, Roorkee 2003 General 79.4 %

PERSONAL INFORMATION :

Name : Gaganmeet Kaur

Father’s name : Gurbhej Singh

Nationality : Indian

Gender : Female

Marital status : Single

Current Address : D-501, Laxmi Angan, Pimple Saudagar, Pune-411027

Permanent Address : 300, Chaw Mandi, Roorkee-247667

PAN : BJWPK3292G

Passport No : H7393245

Contact this candidate