Project Software Engineer

KARANDEEP SINGH Curriculum vitae

Designation: Software Engineer Email: *************@*****.***

Employer: Infosys Ltd, India Address: Infosys Ltd, Technology Park

D.O.B: Nov 26,1987 Chandigarh-110018, India

: +91-783*******

PROFESSIONAL ABRIDGEMENT: A dynamic professional with 2 years of rich work experience in Software Development mainly on Ab-Inito, UNIX, Informatica and Oracle.

EDUCATION:

Graduation

Course: Bachelor of Technology

Institute: Department:

Guru Tegh Bahadur Institute of Technology

Department of Electronics and Communication Engineering

University: Guru Gobind Singh Indraprastha University, New Delhi

Marks%: 76% (First Class)

Duration: June 2006 – May 2010

Senior secondary (All India Senior School Certificate Examination)

School: Guru Harkrishan Public School, Vasant Vihar, New Delhi 110027

Board: CBSE

Marks%: 74

Duration: 2005-2006

Higher Secondary (All India Senior School Certificate Examination)

School: Guru Harkrishan Public School, Vasant Vihar , New Delhi 110027

Board: Marks%:

Duration:

C.B.S.E

78%

2003-2004

Trainings Attended:

Program or Course Coverage

Client Interfacing Skills Client Interfacing

Leading Teams Team Building and Nourishment

Unix Aix Training Basic Unix Commands , Shell Scripting

BI Reporting Business Objects

Data warehousing Ab Initio , Talend Tool, RDBMS CORE, RDBMS Essentials

Six Sigma Six Sigma Awareness Training

Oracle PL/SQL PL/SQL Programming Fundamentals

JAVA Core Java

WORK EXPERIENCE:

CURRENT ASSIGNMENTS:

Informatica Ramp up: I am trained on Informatica along with the complete handson exercises

and aware of all the basic components that are used in it.

Employer: Infosys Ltd

Department: System Integration –Business Intelligence(FSIADT).

Duration: June 2010- present

Project Name : Global Risk Reporting ( Citibank)

Description : Citibank is the consumer banking arm of financial services giant Citigroup. The project involves the data acquisition of facility, obligor, transaction and relationships data. Global Risk Reporting (GRR) system is a data warehouse used for Wholesale Risk Reporting.GRR receives Obligor, Relationship and Customer Support data from multiple systems .

Technologies Used : ETL (Ab-Inito), Oracle, Sybase, Unix.

Duration : From August till now

Role : Developer

Team Size : 12

Roles and Learnings :

• Completely migrated , tested GRR project from Linux to AIX server(From 2.15EME to 3.0 EME).

● Migrating of files using SVN.

● Monitoring the complete autosys JIL’S cycle (PRESIT/SIT/DEV/UAT environments).

● Prepares the database DDL, DML scripts.

● Prepares JIL scripts to run graphs on Autosys scheduler.

● Mapping of fields inside Ab initio.

● Prepares and tested the test cases to test the graphs end to end.

● Prepared the release notes.

● Developed some graphs .

● Mentoring juniors in the team regarding technical and domain skills.

Previous project:

Project Name: P1 UAT Support

Client: CitiBank Singapore COE

Description : The objective of the P1 project is to consolidate the data received from various sources (up- streams) into a database and provide transformed data to down-streams.

Technologies Used : ETL (Ab-Inito) , Oracle, Unix.

Duration : From March 11 to Aug 11

Team Size : 4

Role and Learnings:

Managing jobs and schedules via Tivoli.

UAT support and undertaking of change requests..

Catering to Ad-Hoc requests.

Maintaining Oracle database.

RESEARCH EXPERIENCE:

Publications:

Author

1.Barjesh Kochar, Karandeep Singh Anand, Simranjit Singh “Query Optimizer – A way to enhance Query performance”, published in the proceedings of National Conference on Next Generation Technologies for Information Management(‘NGTIM-2009’) at Institute of Science and Technology, Ghaziabad, India

Conference Date: November 7, 2009

Proceedings: ISBN 978-81-89547-69-1, INDEX [21], PAGE [195-206]

SKILLS:

Programming languages: C,C++, Java and PL-SQL.

Operating Systems: Windows, UNIX .

Extra curricular/ Hobbies:

• Volunteered in event “Tug of War” at GTBIT annual fest GATES “07”.

• Event coordinator of “Tug of War” at GATES “08” and GATES “09”.

• Was active member of divine society of GTBIT.

• Playing Cricket, Swimming , Squash.

I, Karandeep Singh Anand, hereby declare that the information above is true to the best of my knowledge.

Date:

Place: (KARANDEEP SINGH ANAND)

Contact this candidate