SUMMARY:

• ETL QA Analyst/Lead with 9 years of experience in Informatica PC, Oracle, SQL, Unix Shell Scripting.
• Experience in Health Care and Communications Domain.
• Experience in Safe Agile for 6 years.
• Strong experience in Informatica Testing, Administration, Analysis, Design, Coding and Implementation.
• Experience in Project Planning, Execution, Monitor and Control.
• Effective communication skills for coordination between globally located teams.
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non - technical audiences.
• Experience with a variety of sources (Oracle, XML, flat file, Excel Spreadsheet etc)
• Experience with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data marts.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, data validation, systems integration and user acceptance testing.
• Experience in HP Quality Center/JIRA for Bug Tracking and Defect Reporting.
• Experience in System, Integration, QA testing methodologies and major deliverables.
• Experience in Informatica Installation, Configuration and Maintenance.
• Excellent team building, onsite-offshore coordination, Interpersonal and Communication skills.
• Extensive experience in managing Offshore and Onsite IT Projects and teams. Strong planning skills for the requirements gathering phase
• Strong analytical, problem-solving and communication skills, emphasizing on clear, detailed Business Requirements
• Experience in helping end users and development teams design efficient User interfaces, writing Functional Specifications and Workflows.
• Experience in working with end users and Quality Assurance team for developing test cases, test plans, Defect management and prioritization
• Ability to work with minimal supervision where self-reliance and lateral thinking are required
• Ability to work independently or as a team member with an analytical bent to problem solving and delivering under high stress environment Info.
• Rapid accommodation to emergent technologies, able to quickly learn new technologies and proprietary systems.

TECHNICAL SKILLS

ETL Toos: Informatica 9.0, 9.1, 9.5, 9.6, DataStage

Database: Oracle 10g, 11g, Teradata, Netezza, MS-Access

Programming Languages: C/C++, JAVA, JSP

Scripting Languages: JavaScript, HTML, UNIX Shell Scripting

Tools: RALLY, HP QC, MS Office, Visio

Reporting Tools: Business Objects, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, California

Environment: Netezza Aginity, INFORMATICA 10, PUTTY, JIRA

QA Test Lead

Responsibilities:

• Responsible for discussions with the client to understand the correct scope of this project and clarifications
• Responsible for code deployment from Development to Test environment
• Responsible for Production deployment
• Responsible for forecasting for the project
• Responsible for SLA metrics preparation
• Prepared Test Plan and Execution documents
• Responsible for Test case review
• Responsible for Test case execution
• Responsible for Requirement Analysis for the new releases
• Responsible for Defect Management
• Responsible for tracking and logging defects in Quality Centre
• Responsible for Performance testing
• Responsible for Query tuning and performance optimization involving voluminous data
• Responsible for day to day performance analysis of production data
• Responsible for Review and validation of test results
• Responsible for documentation in all phases of testing
• Responsible for Knowledge Transition to new Team members
• Hosting Defect calls and updating the status in QC.
• Schedule calls between Offshore/Onsite and report the status to the Customer.
• Quality Reviews & Metrics collection.
• Scheduling meetings. Preparing Meeting notes with action items & responsible Stakeholders.

Confidential, CHICAGO

QA Test Lead & Informatica Administrator

Environment: INFORMATICA 9.5.1, 9.6.1, ORACLE 10G/11G, PUTTY, WINSCP, RALLY, QC

Responsibilities:

• Responsible for Informatica installation and configuration
• Responsible for code deployment from Development to Test environment
• Responsible for Production deployment
• Responsible for forecasting for the project
• Responsible for SLA metrics preparation
• Prepared Test Plan and Execution documents
• Responsible for Test case review
• Responsible for Test case execution
• Responsible for Requirement Analysis for the new releases
• Responsible for Defect Management
• Responsible for tracking and logging defects in Quality Centre
• Responsible for Performance testing
• Responsible for Query tuning and performance optimization involving voluminous data
• Responsible for day to day performance analysis of production data
• Responsible for Review and validation of test results
• Responsible for documentation in all phases of testing
• Responsible for Knowledge Transition to new Team members
• Hosting Defect calls and updating the status in QC.
• Schedule calls between Offshore/Onsite and report the status to the Customer.
• Quality Reviews & Metrics collection.
• Scheduling meetings. Preparing Meeting notes with action items & responsible Stakeholders.

Confidential, CHICAGO

Environment: INFORMATICA 9.5.1, ORACLE 10g/11g, RALLY, PUTTY, WINSCP

QA Test Lead

Responsibilities:

• Responsible for interaction with end users for collecting, analysing and documenting requirements
• Responsible for testing data mappings between source systems and warehouse components
• Prepared Test Plan and Execution documents
• Responsible for Performance testing
• Responsible for query tuning and performance optimization involving voluminous data
• Responsible for day to day performance analysis of production data
• Responsible for review and validation of test results
• Responsible for documentation in all phases of testing
• Responsible for Knowledge Transition to new Team members
• Responsible for requirement Analysis for the new releases
• Assess and identify mitigation for risks including those related to high level design, integration, and quality of data.
• Prepared Unit test plan for each individual requirement.
• Actively involved in the system testing and end to end integration testing of the new system developed.
• Providing support to QA testing.
• Responsible for production implementations.

Confidential

Environment: INFORMATICA 9.0, DATASTAGE, PUTTY

Informatica Admin

Responsibilities:

• Responsible for configuration, maintenance and monitoring various environment
• Responsible for Installation and Configuration of Informatica 9.0 and 9.1
• Responsible for Informatica deployments
• Responsible for monitoring Data stage jobs

Confidential

Environment: INFORMATICA 7.6, TERADATA, ORACLE, PUTTY, TOAD 9.5

Informatica Developer

Responsibilities:

• Discussions with the client to understand the correct scope of this project and clarifications
• Involved in requirements gathering, coding and testing phase of the project
• Assess and identify mitigation for risks including those related to high level design, integration, and quality of data.
• Coding and testing Informatica components
• Prepared Unit test plan for each individual requirement.
• Actively involved in the system testing and end to end integration testing of the new system developed.
• Providing support to QA testing.
• Responsible for production implementations.
• Responsible for maintenance of applications, performing technical change requests scheduled according to the Release Management process.
• Involved in planning of the integration strategy, integration environment requirements, and determine the product-component integration sequence.

Confidential

Environment: C#, ASP, Microsoft Visual Studio .NET 2003, Microsoft Emulator 5.0

Developer

Responsibilities:

• Discussions with the client to understand the correct scope of this project and clarifications
• Involved in requirements gathering, coding and testing phase of the project
• Assess and identify mitigation for risks including those related to high level design, integration, and quality of data.
• Coding and testing the C# programs
• Prepared Unit test plan for each individual requirement.
• Actively involved in the system testing and end to end integration testing of the new system developed.
• Providing support to QA testing.
• Responsible for production implementations.
• Responsible for maintenance of applications, performing technical change requests scheduled according to the Release Management process.
• Involved in planning of the integration strategy, integration environment requirements, and determine the product-component integration sequence.