SUMMARY

• A graduate in BE Computer Science Engineering, with 7 years of IT experience, as Test Analyst in Confidential, with a working knowledge of Test Methodology and Processes. Experienced in ETL Testing and Manual Testing in (BFSI Segment).
• Roles performed - as onsite co-ordinator understanding the business requirements and functional specification documents, gap analysis and decomposing them into testable functions, test ware preparation, preparation of sql queries based on transformation logics as well as functional requirements and logical data movement, execution, defect logging, participate in daily scrum calls, participate in defect calls, performing end to end testing activity, interaction with offshore, having exposure in handling projects independently and maintaining all metrics and trackers related to the project.

AREAS OF EXPERTISEETL Testing:

Responsibilities:

• Proficient in preparing Oracle - SQL queries and execute in SQL developer, Toad and Teradata.
• Have very good knowledge and working ability in HP ALM for Defect tracking and maintenance.
• Proficient in ETL Testing methodologies and approaches.
• Code deployment in Teradata and Informatic
• Manual Batch processing through UNIX.

Manual Application Testing:

Responsibilities:

• Having good knowledge in End to End application testing approaches and functional scenario validations.
• Have worked for Scope,ANZ, Confidential (Royal Bank of Scotland) Confidential and TSYS with Capgemini
• End to End Functional Workflow Testing.
• Database Testing.
• Functional Scenario Validations.
• Testing Application database for proper data movement from Front End application to Application database.
• Data impact Validations.
• Incident reporting and Defect metrics maintenance.
• Having Expose in Testing Mainframe Application (i.e. CICS screens)
• Having good experience in Banking, Capital Markets and PRIME (For e.g. Application Manager, Manual Transactions, Transaction Management, Manual Authorisation, Customer Services and Merchant Management)

Testing Tools & Methodology:

Responsibilities:

• Database Performance Testing Tool SQL,MS Access, Toad, Informatic.
• Defect Tracking Tool HP ALM (HP-QC) and
• Batch Processing Tool Control M
• Worked on both Waterfall Model and Agile methodology
• Agile - Version 1 for Sprint Planning

Other Skills:

• Oracle - Sql
• Proficient in Data Masking Approaches and Data Integrity testing approaches.
• Testing Data Impact Analysis after data masking.

PROFESSIONAL EXPERIENCE

Confidential

Test Analyst-Onsite Co-Ordinator

Environment: My SQL,Toast,AutoSys,HP-ALM

Responsibilities:

• Involved in requirement analysis and Design preparation including RTM updates
• Involving in daily Offshore meeting
• Sprint Planning for offshore team
• Test execution using Toast and Oracle SQL Assistant
• Participating in Daily Scrum /Defect status call
• Tracking defects in Quality Centre - ALM defect tracking tool
• Mentoring fresher’s about Retirement Technology & 401(k) and testing
• Code deployment and Manual Batch Processing.
• Operational Acceptance Testing(OAT).
• User Acceptance Testing(UAT)
• Preparation of Queries for QA Execution
• Preparation of Test Summary Report
• Preparation of Test Completion Report
• Production Support during Production deployment in onshore
• Preparation of Test Artifacts(Test Plan,Test Startegy,Test Cases,RTM(Requirement Traceability Matrix)

Confidential

Test Analyst

Environment: My SQL,Teradata,Informatic,Unix,HP-QC

Responsibilities:

• Involved in requirement analysis and Design preparation including RTM updates
• Test execution using Informatica and Teradata SQL Assistant
• Participating in Daily/Defect status call
• Tracking defects in Quality Centre defect tracking tool
• Mentoring fresher’s about FATCA and testing
• Code deployment and Manual Batch Processing.
• Operational Acceptance Testing(OAT).
• Preparation of Queries for QA Execution
• Preparation of Test Summary Report
• Preparation of Test Completion Report

Confidential

Associate Consultant

Environment: My SQL,Toad,Control M Oracle 11g, HP-QC

Responsibilities:

• Understanding the Business Requirement and Functional Specification documents
• Defining the Scope based on the Functional and Technical Documents
• Preparation of Detailed Test Plan
• Preparing Test Scenarios, Test Cases, Test Scripts & Data Guidelines based on the Functional Specification documents
• Preparation of Queries for QA Execution
• Making sure that Data migrating from the source to target is in line with the logic specified
• Functional Scenario Validations.
• Performing Root Cause Analysis for Critical Defects
• Handled Defect Calls
• Preparing Defect logs, Closure logs and pass logs
• Publishing Daily Status and Defect Metrics
• Preparation of Dashboard and weekly status report
• Co-ordinated with onsite for execution and defects closure
• Co-ordinated in case of issues and challenges with Client technology teams
• Validation of data on LIVE (Production) Environment and analysing the defects that comes up
• Preparation of Test Summary Report
• Preparation of Training Materials

Confidential

Associate Consultant

Environment: Oracle 11g, JSP,Main Frame, Test Director

Responsibilities:

• End to End Functional Workflow Testing.
• Interaction with onsite team and client team to frame the Approaches.
• Query Preparation.
• Attending defect calls with client and DBA team.
• Defect Fixing.
• Preparation of Trackers for the client.
• Providing KT session for Rest of the Team regarding the project.

Confidential

Test Analyst

Environment: Tandem, Power Builder, UNIX, My SQL

Responsibilities:

• Preparing Test cases, Test Conditions and Functional Scenarios based on Business documents and Technical Specs.
• Preparing Sql Queries based on business Logics used to populate data and then validating it against the Database.
• Functional workflow testing to ensure proper data Movement.
• Defect Logging.
• Follow up with Development Team for defect fixes, for retesting and regression testing.
• Marinating all Trackers and Metrics according to the project.
• Retesting and regression testing after Batch loads.

Confidential

Test Analyst

Environment: PRIME, My SQL,HP Quality Center

Responsibilities:

• Involved in Requirement Analysis, Query preparation, Test Artifacts preparation i.e. Test condition, Test cases, Traceability Matrix etc
• Involved in complete defect life cycle which includes Logging defects, Defect Tracking, Facilitating the defect meetings and follow-up till Logical closure of the defects.
• Involved in Peer review and Formal review of Test Artifacts
• Planning and Execution of test cases
• Preparation of Test Status Reports (Daily / Weekly basis)
• Escalated the issues and Followed up with the relevant stakeholders till the issues got resolved.
• Involved in Predelivery Audits and supported the team with relevant documentation I.e. Test Artifacts, Relevant Approvals, Review Documents etc.
• Involved in Test closure Activities i.e. Test completion report, Metrics Collection Proof Documentation and Sign off