I.Professional Summary
An accomplished professional with around 9 years of rich and varied experience in Information Technology as a Sr. QA Analyst, and Expertise in Test Strategy, Test Planning, Test Cases Design, Test Cases execution, Defect Management, Test Results Report, Test Automation (functional & performance testing), and Team Management. Have Five plus years of domain expertise in Banking & Finance Sectors.
Currently working as a Sr. QA Analyst with Santander Bank for various Migration projects, Responsible for Requirement Analysis, Testing effort Estimation, Test Planning & Strategizing, Test Management, Team Management, Project Tracking, Reporting, and provide end to end testing solutions for various types of testing (System Integration, User Acceptance, Automated Regression, End to End and Pre-Production & Post Implementation Shakeout Testing).
Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test plans, Test Cases, executing Test Cases and Test Scripts based on baseline requirements
Experience in working on Agile Testing
Expertise in translating Business requirements to understandable IT systems requirements and Implementing Testing Methods & Procedures across the organization
Efficient in Back End Testing of the applications by writing and executing complex SQL queries on multiple Databases
Expertise in coordinating and providing support to User Acceptance Testing (UAT)
Coordinating Production issues, tracking and testing in pre-prod
Experience in Working on Different Applications simultaneously and guiding the team members to meet deadlines
Experience in writing automation test scripts and running keyword based test cases
Hands-on experience in Configuration Management (Clear case and CVS), Test Management and Defect tracking systems (HP ALM, Microsoft TFS, JIRA, Remedy, SharePoint, Rational Tools and Open Source tools like BugZilla)
Extensive experience in Functional Testing, Integration Testing, GUI Testing, Interface Testing, compatibility Testing, Mobility Testing, Back-end Testing, ETL testing,Regression Testing and End to End Testing
Strong experience in software testing process including executing tests, record result, and test reports and tracking defects
Good interpersonal skills, committed, result oriented, hard working with a quest and zeal to learn new technologies
Excellent verbal and written communication skills, especially with regards to presenting findings to both technical and non-technical audiences
Expertise in understanding Cursors, PL/SQL Procedures, Functions, Packages and Triggers
Good experience in SLA management, metrics driven test management, metrics analysis and implementation of appropriate corrective and preventive actions
Responsible and involved in design, development and validation, lead and coordinating of various System Software, Banking & Finance, Healthcare and e-Publication\Media applications
Thorough understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements Analysis, Design, Development and Testing
Ability to work under pressure and delivery under tight deadlines
Ability to work with off shore team
Actively participated in Auditing other QA projects and implemented QMS process to improve the Quality
Excellent understanding of the different development methodologies and associated SQA processes
II.Core Technical Competences Include
Testing Methods
Black Box Testing, Regression Testing, System Testing
GUI Testing, Usability Testing, Integration testing, Functional testing, Backend Testing & web testing. Mobility Testing, ETL testing,Compatibility Testing
Operating Systems
Windows 7, Windows 95/98/2000/XP, Windows vista, Android, IOS, Macintosh, Unix and Linux
Languages
C, C++, Java,Visual Basic,.Net
Web Technologies
HTML,XML
Scripting Languages
VB script and UNIX shell scripting
Databases
Oracle11, Ms-Access, SQL server2008,DB2,SQL,T-SQL,Toad,SQL Developer
ETL tool
Informatica
Defect tracking tools & Test Management Tools
JIRA, Bugzilla, HP ALM, Microsoft TFS and Remedy
Automated Tools
HP QTP
Browsers
Internet explorer family, FireFox family, Safari, Opera, Chrome, Netscape
III.Project Summary
Sr. QA Analyst
Santander Bank (Aug’11 – Till date)
Environment:Java,WindowsXP,MSOffice,Oracle,NotePad++,IVR,QuickTestPro(QTP),ALM 11.0,Portals,XML,XML Notepad++,Nebula, Text Pad, Mobile Apps(Apple and Android Operating Systems),DB2.JDAI,Frimware,SOAPUI, Informatica (ETL),SQL Server,C#,.Net
Various types of Testing’s Involved/Responsible:
System Integration Testing (ST/SIT), User Acceptance Testing (UAT), Regression Testing and End to End Testing (E2E), Mobility Testing, Compatibility Testing, Interface Testing and Back End Testing
Analyze the Business requirement Documents and Review them with Business & Development teams for understanding and to prepare Testing Strategy/ Testing Effort Estimation
Prepared test cases as per specifications and reviewed with business team
Create Requirements Traceability Matrix
Set-up Requirements,Test Plan and Test Lab module for execution in ALM
Preparing the test cycles for execution in ALM
Preparing Reusable Regression
Creating automation Test suits by keyword/Data Driven frame work
Executing the automation test suits using the QTP and validating the test results
Task assign, tracking and Monitoring
Performed Sanity, Adhoc, Functional, Regression and User Acceptance testing
Knowledge transferred to team members and Delegating the work and monitoring of Deliverables
Working closely with Offshore team to get the Project deliverables
Create\Gather test data for Testing activities
Validated all ETL rules using Informatica’s proprietary tool
Validated workflow using incremental and full load testing procedures
Performed Database testing by running the jobs manually and in automated as applicable
Performed database testing using SQL Queries, ensuring data was extracted properly, compared values from front end application with appropriate tables within the database.
Performed Data Validation, Data Integrity, Process Integrity and Performance testing for all the data moved from staging to target databases
Performed negative testing by giving invalid parameters and checked the output of the reports generated.
Verified data integrity through Backend testing of the application using SQL queries
Worked on reporting Services for Validations of the fields and for Report Generation.
Created SQL scripts used for testing scenarios and distributed to them to team members for execution.
Prepared UAT test cases and SQL scripts for conducting UAT
Review Project Health periodically and update various Business partners
Prepare testing schedule and act as a single point of contact for all testing needs
Participate in enterprise project meetings and communicate testing risks/issues/concerns
Interact with business partners, systems analyst, testing resource and ensure all testing deliverables are created on time and appropriate signoffs are obtained as per the organization policy
Conduct triage meetings and ensure effective testing and timely resolution of defects
Worked closely with Business, Development, Vendor and DQSS Teams for SIT, End to End, Regression UAT testing
Validating the Credit Card Risk Decision Call results using the SOAP UI
Defect Review/Testing Progress meeting with Business stakeholders for a Go/No Go decision to release the software to upper environments (like CERT, Pre-Prod and Production)
Prepare daily/weekly metric reports and share it with the senior management team
Support Users for UAT testing
Revalidating the production issues/defects in Pre-Prod environment and coordinating for Production deployment and post implementation activities
Managing the RFC to move the software from CERT,PRE and PROD environments
Worked on Mobile and Tablet Apps (App store & Google Plus)
Worked on IVR and Contact Center project related to call center activities
Module Lead
CFNA-Symphony, Citi Group (Nov’ 09- Jul’11)
Responsibilities:
Understanding Use Cases [UC] and User Stories [US] to create High Level Test Plan
Preparing the test scripts and uploading them into Quality Center
Prepared the Traceability Matrix based on the requirement documents
Reviewing the test Plan and test cases for the modules Interact with Development Team and users and conduct Meetings with Development team related to issues raised in TFS
Test Data Creation for QA testing
Performed database testing using SQL Queries, ensuring data was extracted properly, compared values from front end application with appropriate tables within the database
Verified data integrity through Backend testing of the application using SQL queries
Delivered the deliverables in Agile Methodologies
Developing the defect reports and Test Summary reports
Preparing the bug reports and organizing the defect triage meetings
Coordinating the team, Preparing the weekly assignments and follow up on the tasks
Involved in the QA effort estimation
Daily status report to the team
Reviewing the changes and prepared the impacted effort report
Version Control of project documents and working on metrics
Conducting the Daily team Scrum meetings
Environment: Java, Oracle 10, windows XP, IE6, Share point, Quality Center9.2, Manual Testing, QTP 9.2,Mainframe,DB2, Team Foundation Server(TFS), Oracle SQL Developer
QA Analyst
Thomson Reuters (Feb’ 05- Oct’ 09)
Responsibilities:
Understanding the Functional and Non-Functional requirements of the WOK application.
Test Data preparation.
Test Cases Preparation, Test Execution and Evaluation of Test Cases for different module (WOS, BCI,CSCD etc) in WOK application
Bug reporting and tracking them till closer
Participated in Project Review, Requirement Review and Bug Review Meetings
Interacting with the client through weekly status calls
Preparing and Maintaining Weekly and Daily status reports
Test data preparation for automation
Analyzing the automation scripts.
Ensure test systems outages/problems are reported immediately and followed up
Ensure entry criteria & exit criteria are met for each test cycles in each release
Ensure all the test artifacts related to their module are version controlled in configuration management tool
Comparing the data on web pages with XML files
Environment: Java, CGI-Perl, XML, XLST, Windows 2000/NT/XP, Macintosh, Linux, Solaris, IE8, FireFox4.0, Safari3.0.,Quality Center9.2, Manual Testing, JIRA,
Education Qualification:
Master of Computer Applications, Nagarjuna University India-2004