Summary

• Having 9 years of experience in IT Industry.
• Informatica certified professional.
• Have experience is leading and delivering 4 major transformation project.
• Hands on experience on all the stages of software development life cycle SDLC .
• Good Knowledge in Informatics 7.1.2, 8.1,8.6.1 and 9.1
• Good Knowledge in Performance Tuning of Informatica mapping.
• Having knowledge of Tidal-Scheduling Tool.
• Hands on experience in migrating data into maximo.
• Good Knowledge in SQL, PL/SQL, Netezza, SQL Server, Maximo, XML, XSD and VB.
• Good Knowledge in SVN, HPQC and SharePoint.
• Having knowledge of EWAM concepts and Utilities domain.
• Expertise in Japanese Language - JLPT Level 3 Certified.
• Have Experience working at customer location in USA.
• Have Experience as an onsite coordinator in Japan.
• Experience of handling a team of size as large as 18 members.
• Experienced in gathering requirement and documenting.
• Quick problem-solver, strong analytical, coding, debugging skills.
• A quick learner, team player and an individual contributor.
• Good communication skills and interpersonal skills. .

Professional Experience

• Currently working as ETL Lead Designer and Managing the Team from Cognizant in one of the Cognizant's customer location at Harrisburg, Pennsylvania, USA as from December'13 to till Date.
• Worked as ETL Lead Designer in one of the Wipro's customer location at Las Vegas, Nevada, USA as from December'12 to November 2013.
• Worked as Technical Lead in Wipro Technologies, Bangalore from October 2010 to November 2012.
• Worked as Senior Software Developer in Wipro Technologies, Bangalore from July 2009 to September 2010.
• Worked as Software Developer in Wipro Technologies, Bangalore from October 2005 to June 2009.

Technical Expertise

• Tools : Informatica 7.1.2, 8.1,8.6.1 and 9.1, Tidal-Scheduling Tool,
• Toad, SQL Plus, Win SQL,
• SQL Server Management Studio,
• Aginity Work Bench for Netezza,
• Maximo, SVN, PVCS , HPQC,
• SharePoint.
• Programming Language : SQL, PL/SQL, XML, XSD, VB, C, C .
• Database : Oracle, Netezza, SQL Server.
• Operating System : Windows XP.

Projects Profile

Confidential

Role : ETL Lead Designer

Environment : Windows, Unixt.

Roles and Responsibilities:

• Complete responsibility of providing end to end solution of the business requirement and designing the ETL Model.
• One point source of contact for the client.
• Preparation of Functional Specification.
• Source System Analysis and Requirement gathering
• Preparing Technical specification,
• Giving technical solution to the team to achieve business requirement.
• Reviewing Mapping specification S2T document and ensured that transformation rules are as per the business requirement.
• Helping team members to understand the business functionality and to solve the technical issues/errors.
• Reviewed the code Mappings and Session and ensured that code is perfect in all aspects.
• Guided the team to build the Unit Test Case to validate the ETL code
• Reviewed the functional validation script and reconciliation script.
• Performance Tuning of the Informatica mapping.
• Handling the Team meeting and status update meeting with the customer and business owners.

Confidential

Role : ETL Lead Designer

Environment : Windows

Tools : Informatica 9.1, Oracle 11g,Maximo and MSTR

Roles and Responsibilities:

• Complete responsibility of providing end to end solution of the business requirement and designing the ETL Model.
• Preparation of Functional Specification.
• Source System Analysis and Requirement gathering
• Preparing Technical specification,
• Giving technical solution to the team to achieve business requirement.
• Reviewing Mapping specification S2T document and ensured that transformation rules are as per the business requirement.
• Helping team members to understand the business functionality and to solve the technical issues/errors.
• Reviewed the code Mappings and Session and ensured that code is perfect in all aspects.
• Guided the team to build the Unit Test Case to validate the ETL code
• Reviewed the functional validation script and reconciliation script.
• Performance Tuning of the Informatica mapping.
• Handling the Team meeting and status update meeting with the customer and business owners.

PROJECT 8 : EWAM Data Migration Phase 2 Electric

Confidential

Role : ETL Lead Designer

Environment : Windows

Tools : Informatica 9.1, Oracle 11g, XML, XSD

Roles and Responsibilities:

• Complete responsibility of providing end to end solution of the business requirement and managing the Onsite team.
• Source System Analysis, Requirement gathering, Preparing Technical Documentation, Resource Planning and Allocation, etc.
• Reviewing Mapping specification S2T document and ensured that transformation rules are as per the business requirement.
• Helping team members to understand the business functionality and to solve the technical issues/errors.
• Reviewed the code Mappings and Session and ensured that code is perfect in all aspects.
• Guided the team to build the Unit Test Case to validate the ETL code and functional requirement reviewed them in all aspects.
• Giving technical solution to team to achieve business requirement.
• Performance Tuning of the Informatica mapping.
• Handling the Team meeting and onsite calls.

Confidential

Role : Technical Lead

Environment : Windows

Tools : Informatica 8.6.1, Oracle 10g

Roles and Responsibilities:

• Complete responsibility of providing end to end solution of the business requirement and managing the offshore team.
• Source System Analysis, Requirement gathering, Preparing Technical Documentation, Resource Planning and Allocation, etc.
• Reviewing Mapping specification S2T document and ensured that transformation rules are as per the business requirement.
• Helping team members to understand the business functionality and to solve the technical issues/errors.
• Reviewed the code Mappings and Session and ensured that code is perfect in all aspects.
• Guided the team to build the Unit Test Case to validate the ETL code and functional requirement reviewed them in all aspects.
• Giving technical solution to team to achieve business requirement.
• Performance Tuning of the Informatica mapping.
• ST Defect Fixes.

Confidential

Role : Technical Lead

Environment : Windows

Tools : Informatica 8.6.1, Oracle 10g

Roles and Responsibilities:

• Complete responsibility of providing end to end solution of the business requirement and managing the offshore team.
• Source System Analysis, Requirement gathering, Preparing Technical Documentation, Resource Planning and Allocation, etc.
• Reviewing Mapping specification S2T document and ensured that transformation rules are as per the business requirement.
• Helping team members to understand the business functionality and to solve the technical issues/errors.
• Reviewed the code Mappings and Session and ensured that code is perfect in all aspects.
• Check with team members to know the status of development and helped them whenever they are facing technical challenges and issues.
• Guided the team to build the Unit Test Case to validate the ETL code and functional requirement reviewed them in all aspects.
• Giving technical solution to team to achieve business requirement.
• Creation of the design document and S2T mapping document.
• Actively involved in Performance Tuning.
• Review the work dome by the team member.
• Handling the Team meeting and onsite calls.
• Review the UTC and UTR prepared by the Team.
• ST defects fixing.

Confidential

Role : Software Developer

Environment : Windows

Tools : Informatica 8.6.1, Oracle 10g

Description:

Roles and Responsibilities:

• Designing new ETL mappings using Informatica based on Data Mapping document.
• Created sessions and workflow.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Actively involved in Performance Tuning.
• Worked on Power Centre client tools like Source Analyzer, Warehouse Designer and Mapping Designer etc.
• Preparing Unit Test Cases.
• Unit testing of enhanced newly developed ETL graphs.
• Handling Client TCON from Offshore.