OBJECTIVE:

Looking forward to work in a challenging environment that can harness my knowledge and skills and allow me scope for upward movement.

SUMMARY:

• Having 12 years of experience in IT Industry.
• Informatica certified professional.
• Have experience in designing the complete ETL architecture for multiple projects.
• Have experience in Informatics 9.6.1, 9.5.1, 9.0.1, 8.6.1, 8.1 and 7.1.2
• Have experience in Data Modeling, Erwin 9.6, 9.5.2 and Toad Data Modeler.
• Have experience in leading/delivering 6 major transformation project.
• Have experience in Performance Tuning of Informatica mapping.
• Have experience in designing the complete Job Scheduling Architecture - Tidal.
• Have experience in Netezza, Vertica, SQL, PL/SQL, Maximo and VB.
• Have experience in UNIX Shell Script.
• Have experience in Amazon Workspaces, SVN, HPQC, SharePoint, WinSCP, Ultra Edit, MPP and ServiceNow.
• Experience with Agile development - Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups.
• Experience managing onshore and offshore teams.
• Hands on experience on all the stages of software development life cycle (SDLC).
• Expertise in Japanese Language - JLPT Level 3 Certified.
• Hands on experience in migrating data into maximo.
• Having knowledge of Confidential concepts and Utilities domain.
• 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. .

TECHNICAL EXPERTISE:

Tools: Informatica 9.6.1, 9.5.1, 9.0.1, 8.6.1, 8.1 and 7.1.2, Erwin 9.6 and 9.5.2 Tidal-Scheduling Tool Aginity Work Bench for Netezza, Squirrel SQL Client, Toad, SQL Plus, Win SQL, SQL Server Management Studio, Maximo, SVN, HPQC, SharePoint, MPP, Service Now.

Programming Language: Shell Script, SQL, PL/SQL, XML, XSD VB.

Database: Netezza, Vertica, Oracle, SQL Server.

Operating System: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, Pennsylvania

Architect - ETL Informatica

Environment: Windows, Unix

Tools: Informatica 9.6.1 and 9.5.1Erwin 9.6 and 9.5.2, Netezza, Vertica, UNIX shell script, SQL Server and Tidal

Responsibilities:

• Complete responsibility of providing end to end solution of the business requirement and designing the ETL Model.
• Working closely with the business owner and create the Data Model.
• One point source of contact for the client.
• Preparation of Functional Specification Document.
• Source System Analysis and Requirement gathering
• Giving technical solution to the team to achieve business requirement.
• Review Mapping specification (Source to Target) document to ensure 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, Las Vegas

ETL Lead Designer

Environment: Windows

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

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
• 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
• Performance Tuning of the Informatica mapping.
• Handling the Team meeting and status update meeting with the customer and business owners.

Confidential, Las Vegas

ETL Lead Designer

Environment: Windows

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

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

Technical Lead

Environment: Windows

Tools: Informatica 8.6.1, Oracle 10g

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.

Confidential

Technical Lead

Environment: Windows

Tools: Informatica 8.6.1, Oracle 10g

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.
• Handling the Team meeting and onsite calls.
• Review the UTC and UTR prepared by the Team.

Confidential

Software Developer

Environment: Windows

Tools: Informatica 8.6.1, Oracle 10g

Responsibilities:

• Develop 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.
• Preparing Unit Test Cases.
• Unit testing of enhanced & newly developed ETL mappings.

Confidential

Software Developer

Environment: Windows

Tools: Informatica 8.1, Oracle 10g

Responsibilities:

• Analyzing the application historical data and extracting required data to support management decisions.
• Implemented ETL solution using Informatica.
• Actively involved in Performance Tuning.
• Developed mapping to extract data from various sources and load to staging area using various transformations.
• Developed mapping to extract data from staging area and load to data warehouse.
• Done unit testing.

Confidential

Onsite Coordinator

Environment: Windows

Tools: Informatica 8.1, Oracle 10g

Responsibilities:

• Coordinating between clients and offshore from onsite.
• Requirement Gathering and passing the same to offshore.
• Actively involved in review meetings
• Analyzing the application historical data and extracting required data to support management decisions.
• Implemented ETL solution using Informatica.
• Analyzing the different source system.
• Developed mapping to extract data from various sources and load to staging area using various transformations.
• Developed mapping to extract data from staging area and load to data warehouse.
• Done unit testing.
• Done performance tuning.