SUMMARY:

• 15 years of experience in software testing on various phases in Waterfall/Agile development methodologies in Banking, Financial Services and Insurance (BFSI).
• Proven QA experience in requirements analysis, data analysis, handling high volume of data like 300 millions, defect triage, data flow testing for production incident triage .
• Experienced in providing estimation, requirement analysis, QA Management, Test environment management, test data management Co - ordination with business user, development team in onsite -offshore environment
• Extensive experience in GUI, Functional, Regression, System testing and User acceptance testing.
• Expertise in QA Methodologies, Defect Management Life Cycle, Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) methodologies.
• Hands on experience in handling millions of data compare with different applications.
• Good understanding of ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Analysing the data with multiple application for any production issue.
• Domain knowledge of Retail banking, Mortgage and Credit card.
• Managed a team of 15 members using onsite-offshore model.
• Strong experience in creation of Test Plans and Test Strategies
• Estimation of the Test conditions, cases & scenarios
• Experienced in SharePoint 2010 application testing (Workflow, Alerts, Template etc)
• Ability to develop complicated SQL queries for Data validation testing using Oracle, DB2 and SQL server database.
• Good exposure in UNIX and tools like Putty.
• Adequate knowledge on Loan Origination Systems.
• Aware of Quality processes and Change Management procedures.
• Part of Defect analysis meetings contributed more with past experience.
• Coordination of testing activities between clients and the offshore testing team.
• Requirements review & testing of the applications developed.
• Functional testing experience in Core banking implementation for Retail Liabilities module.
• Test execution, Defect logging, Test reports generation using QC
• Managed defects using QC and provided walk through of defects to clients in defect calls
• Managing agile boards, defect logging and test execution using JIRA
• Provided value additions in process improvements and in improving productivity
• Flexible enough to learn and adapt new technologies

AREAS OF EXPERIENCE:

Industries: Retail Banking Mortgage Credit Card Data Warehouse

Applications: Retail Banking Application Loan Origination System Collection Application Dataware house

RDBMS: Oracle, SQL Server, Sybase, DB2

Languages: SQL, Unix Scripting and Java

Operating Systems: Windows 98/NT/XP/ Windows 7, iOS

Test/Defect Management Tool: Selenium, HP ALM, DataStage, DOORS

PROFESSIONAL EXPERIENCE:

Confidential

Environment: DataStage 8.5, Oracle, DB2, Sybase

Sr. Data Quality Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications interacting with developers and QA Team
• Written Test Plan, Test Strategy, Test Script, Test cases, reported bugs and tracked defect using Quality Center.
• Tested migrated data from different source system.
• Tested adhoc report for Micro Strategy 10.0
• Extensively tested server ETL mapping developed using Informatica and Data Stage Tool.
• Verify the Source system data with target system data
• Tested ETL jobs as per business rules using ETL mapping design document
• Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirement including identifying the tables and columns from which data is extracted.
• Hands of experience in developing of Requirement Traceability Matrix (RTM)
• Extensively used DB2 for testing the data which is loaded in the target database.
• Worked in an agile technology with Scrum.
• Attending the Scrum meeting and updating the testing status and knowing the current and upcoming changes from development team.
• Performed Black Box, UI Testing and analyzed the code to test the functionality of the applications
• Writing complex SQL queries for data validation for verifying the reports functionality as per the business Rules.
• Created Test cases based on BRD, FRD, SRD
• Queried in DB2 Database and validated the data using SQL.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Used HP Quality Center to create Status Graphs, test coverage, re-work, delivered defect Metric’s
• Leading 10 member’s team.

Confidential

Environment: s: JDK 1.6, EJB 3.0, Oracle 11i, Quality Center 11.0, Site minder - 12

Test Lead

Responsibilities:

• Providing the Requirement overview and application flow to team members.
• Participate in the Requirement gathering from Business User
• Preparation of Test Plan
• Review the Test Scenario
• Review of traceability matrix and mapping the requirements.
• Responsible for all deliverables such as Test Design, Test Execution, Defect Report and Daily Status report to the stake holders.
• Preparing the Weekly status report and send it to project manager on every week.
• Initiating the Defect meetings and publish the risk to the stake holders.

Confidential

Environment: s: .Net, SharePoint 2010, SQL Server 2008, TFS, SSRS

Test Lead

Responsibilities:

• Understanding the Requirement and application.
• Participate the Requirement gathering from Business User
• Preparation of Test Plan
• Review the Test Scenario and Test Script
• Identified test requirement and checked if the test cases were complete to test the business functionality.
• Executing the scripts in High Risk Area.
• Writing complex SQL query for querying data against SQL server database for data verification.
• Responsible for all deliverables such as Test Design, Test Execution, Defect Report and Daily Status report to the stake holders.
• Preparing the Weekly status report and send it to project manager on every week.

Confidential

Environment: s: Oracle 10g, Java, Ext JS, JSF, DataStage, Informatica

Senior Test Analyst

Responsibilities:

• Understanding the application.
• Preparation of Test Scenario and Test script documents
• Participate in Peer Review of test scripts
• Set the data for Mainframe Job and confirm the job has run.
• Execute the test cases and verify the report output in all possible formats.
• Prepare defect logs and logging these defects in HPQC and subsequent fix verification considering the impact areas along with the up-to-date Change Requests if any based on defect fix.
• Perform End to End testing by submitting transactions in Confidential Application and verify the same in Reports.
• Writing complex SQL query for querying data against SQL server database for data verification.
• Extensively tested server ETL mapping developed using Data Stage and Informatica tools
• Document the Functionalities and mentor the team

Confidential

Environment: s: PeopleSoft 9.1 FSCM

Team Lead

Responsibilities:

• Involved the test plan preparation
• Involved in PeopleSoft (PS) Accounts Payable (AP) module with focus on AP processing from maintaining vendor information to processing and finally sending accounting to the PeopleSoft General Ledger system.
• Involved in PeopleSoft (PS) General Ledger (GL) module with focus on GL processing from journal and suspense processing within the PS GL system.
• Understanding the client requirements by studying functional document.
• Identified test requirement and checked if the test cases were complete to test the business functionality.
• Review of the Scripts and suggesting modification in the scripts.
• Executing the scripts and reporting the bugs.
• Responsible for all deliverables such as Test Design, Test Execution, Defect Report and Daily Status report to the stake holders.
• Preparing the Weekly status report and send it to project manager on every week..

Confidential

Environment: s: .Net, C#, Windows XP, DB2

Team Lead

Responsibilities:

• Interacting with the business analysts, project manager and developers in order to clarify any queries pertaining to functionality.
• Preparing the execution plan and tracking the updates.
• Preparation of High level scenarios, Test Condition and Test Script.
• Reviewing the Test cases and aligning them for execution in Quality Centre
• Responsible for all deliverables such as Test Design, Test Execution, Defect Report and Test summary report.
• Defect Review and Management with client and the developers.
• Writing complex SQL query for querying data against DB2 database for data verification.
• Communicating the execution status to the stake holders.

Confidential

Environment: s: JAVA, JSP, Oracle 10g, Windows XP

Functional Consultant

Responsibilities:

• Understanding the application.
• Preparation of High level scenarios, Test Condition
• Review the Test scripts.
• Review defect document and logged in Quality Centre defect tracker tool
• Subsequently retesting the fixed defects by considering the impact areas along with the defect fixing
• Writing complex SQL query for querying data against Oracle database for data verification.
• Continuous Monitoring of defects and updating the defects status.
• Participating in regular status meetings and prepared weekly reports on the status of the application.

Confidential

Environment: Oracle 10g, Windows XP, iManage v 4.1

Module Lead

Responsibilities:

• Analyzing and reviewing Use case realization Document.
• Understanding the application and its requirements.
• Participated in Use case realization review meeting.
• Involved in Preparing System Test Design
• Leading the Back-Office Product.
• Involved in System Test Execution.
• Defect Review and Management with client and the developers.
• Involved in Preparation of Test Exit Report.

Confidential

Environment: s: FCC 6.3, Branch 6.3, Oracle App Server 10g, Oracle 10 g

Functional Consultant

Responsibilities:

• Understanding business requirements, functional specifications and the application
• Preparation of High level scenarios
• Preparation of Run chart based on High level scenarios
• Executing scripts in Run chart as per the logical day plan
• Prepare defect document and logging these defects in Eazy Test defect tracker tool
• Subsequently retesting the fixed defects by considering the impact areas along with the defect fixing
• Continuous Monitoring of defects and updating the defects status