Data warehousing Resume Profile Resume Profile

With an experience of 7 years 2 months in Datawarehousing,Confidential attended requirement sessions and performed design, development and production activities across various locations and clients.

Technical Skills:

ETL Development Tool
Ascential Datastage V7.5.1, IBM Infosphere Datastage V8.5,
Informatica 8.1.1, Informatica 9.1
Reporting Tool
Crystal reports 2008, Cognos 10.1
Scripting
UNIX/Shell script, Perl
Programming Language
C-program
Job Scheduling
Autosys, Mainframe Job Scheduling
Service Ticket Tracker
HP Service Center, Siebel Call Center 8.1
Database
DB2, Vertica 3.5, Oracle

Experience Summary:

Working as Senior Consultant/SME in NTT Data Inc for Honeywell Client at Honeywell Headquarters, Morristown, NJ, USA Sep-2013 t present
Worked as Associate - Projects in Cognizant Technology Solutions for Aetna Inc Pharmacy domain at Blue Bell, USA Mar-2011 t Sep-2013
Worked as ETL Module Lead for Aetna Inc Corporate domain at Chennai, India in 2010
Worked as ETL developer for Blue Shield of California in 2009
Worked as ETL and Reporting tool developer for AmeriHealth AMFC for in 2008
Worked as ETL developer for United Health Groups in 2007

Professional Summary:

Technical Lead/SME at Onshore Datastage/Unix handling a team of 6 members in Enhancement and Production Support
Subject Matter Expert SME for Aetna Inc Pharmacy Reporting Data Store application RxRDS
Received 'Associate of Quarter 2011 - Q4' Cognizant Technology Solutions
Received Client Appreciations for successful completion Medicare and Compliance projects.

Training Summary:

As Trainer

Trained tw batches each 25 of Experienced associates in Datastage V7.5.1 PX at Academy in Cognizant Technology Solutions
Trained 20 Entry-Level Trainees in Cognizant Technology Solutions in Aetna account

As Trainee

IBM Infosphere Datastage V8.5
Basics of Perl programming
Basics of Business Object XIR2

Project Summary:

Confidential

Technology IBM Infosphere Datastage V7.5, UNIX/Shellscript, Siebel Call Center 8.1, Informatica 8.1, Cognos 10.1

Responsibility

Handled Production Implementation for various Major, Standard and Off-cycle releases.
Created Value-ads for production support.
Handle Weekly Production Load, validations and communication t Functional and Business Users.
Support Functional leads on day-today production service requests.
Host Daily calls with Offshore team on production service requests and follow-up on them t completion.
Create Process Documentations t support New Joiners.

Confidential

Technology Ascential Datastage 7.5.1, IBM Infosphere Datastage V8.5, Oracle, DB2, Shell script, Mainframe

Responsibility

As application SME, gather Business requirements and communicate them t Offshore.
Host daily meetings with Offshore team t communicate critical requirement updates and monitoring the work progress t meet Client timelines.
Validate the ETL Jobs and other design deliverables t meet Business needs and Coding standards with maximum accuracy in Quality.
Support Onshore Testers and Business Users when needed.
Handle Production Implementation for various Major, Minor, Off-cycle and Emergency releases.
Provide support on Day today batch Production runs during US Business hours.

Confidential

Technology Ascential Datastage 7.5.1, Shell script, DB2, Perl

Responsibility

Prepare Design and Test deliverables t meet Business Requirements.
Develop Datastage jobs and involving complex logics
Support and Validate the deliverables of teammates
Train new joiner with Application and Tool knowledge
Support Onshore during Production Implementation and post production changes, if any.

Confidential

Technology Informatica 8.1.1, Facets, SQL

Responsibility

Prepare Application Design and Detailed design document for Business Requirements.
Develop and Unit testing of Informatica Mappings, Mapplets and Workflows.
Support Onshore during Production Installation and Business Checkout

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship