SUMMARY:

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

PROFESSIONAL EXPERIENCE:

SME/Onshore Tech Lead

Confidential, Morristown, New Jersey

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

Responsibilities:

• Handled Production Implementation for various Major, Standard and Off-cycle releases.
• Created Value-ads for production support.
• Handle Weekly Production Load, validations and communication to 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 to completion.
• Create Process Documentations to support New Joiners.

Onsite Tech Lead

Confidential, Pennsylvania

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

Responsibilities:

• As application SME, gather Business requirements and communicate them to Offshore.
• Host daily meetings with Offshore team to communicate critical requirement updates and monitoring the work progress to meet Client timelines.
• Validate the ETL Jobs and other design deliverables to 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.

Technical Lead Developer

Confidential

Technology: Ascential Datastage 7.5.1, Shell script, DB2, Perl

Responsibilities:

• Prepare Design and Test deliverables to 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.

ETL Developer

Confidential

Technology: Informatica 8.1.1, Facets, SQL

Responsibilities:

• 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

Confidential

ETL/Reporting Developer

Technology: Datastage V7.5.1, Oracle, Crystal reports 2011, Perl

Responsibilities:

• Preparation of technical design document for Business Requirements.
• Develop and Unit testing of Datastage parallel jobs.
• Preparation Unit and Integration Test deliverables.

Confidential

ETL Developer

Technology: Datastage 7.5.1, C Programming, Shell script

Responsibilities:

• Coded and compiled C-programs transforming Java script logic to C program.
• Programmed Shell script to generate Statistical and Operation reports.
• Prepared function design specification documents
• Developed Datastage parallel jobs and performed reconciliation on Datastage Server and Parallel job outputs