Sign in

Sql Server Project

Roorkee, UL, India
August 23, 2012

Contact this candidate


Gaganmeet Kaur

Mail id:

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


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.


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


Name of the company Designation Total Experience

Infosys Limited, Pune

Senior Systems Engineer 2 years 7 months


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,


Jan2010– May 2010


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


Development of assignments and assessments

Evaluation of assignments and assessments

Solution Environment MS BI Suite


Business Intelligence & Data warehousing training from Infosys EnR

Internal Informatica Power Centre Developer


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


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 %


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


Passport No : H7393245

Contact this candidate