summary

• Proficient in writing SQL and PL/SQL requried to perform backend data validation
• Experience in defect management, defect analysis and defect reporting using various tools including quality center, bugzilla, jira
• Performed testing on Oracle, SQL Server, MS Access databases and Data Migration
• Experience in developing functional system integration test and test plans and test cases based on system requirements and business rules
• Expertise in GUI testing, Black box testing, Compatibility testing, User Acceptance Testing, Regression Testing, System and Integration testing
• Proficient in Software testing process which includes developing test cases, executing test cases, documentation and defect tracking
• Expetise in creating the presentations and documentation for training the team
• Well versed with basic code debugging, Traced and edited system log files and error files
• Expertise in Writing, Updating and maintaining the Test documents for various stages of Testing for reference and auditing purposes
• Cognizant in dealing with developers and business analysts to better understand requirements, functionality and business process for QA testing
• Extensively developed test strategies for GUI, Web Applications, Web Services, Client/ Server, Database
• Over 7 years of IT experience as Quality Assurance Analyst performing Manual Automation testing for various client-server and web based applications on Windows and Unix platforms
• Expertise in all SDLC methodologies and Agile Scrum methodology
• Extensive Knowledge in SDLC, STLC, BLC and those cycles integration
• Proficient in analyzing system requirements, use cases and other documents to determine the appropriate level of testing required and creating Test plans /Test Strategy and test cases based on requirements
• Excellent knowledge in managing the whole testing process using Mercury Interactive Test Management tool Quality Center
• Excellent analytical and problem solving skills in designing, developing, and implementing innovative business process and provide system solutions using new approaches

TECHNICAL SKILLS

experience

Confidential

Position: Software Analys

Responsibilities:

• Actively participated in complete software lifecycle of requirements gathering, analysis, design, development and testing of the project using Agile Software Development methodology
• Worked with business team to ensure requirements are understood and implemented according to specifications
• Developed test scenarios as per business rules defined in functional and non functional requirements
• Created Test Cases, Test Data and Test Scripts as per business requirements
• Performed backend testing to validate the data writing SQL queries in Oracle using toad
• Involved creating the End to End test scenarios and execution.
• Involved in testing with web services and XML using soapUI
• Validated XML files using the SOAP Web Services calls that load the data from source to the target
• Tested Restful Services to handle the calls to backend and provided JSON to front end
• Used SQL extensively to validate Data partitions, data transformation and to validate consistency of data moved from the source system to target Database
• Executed batch jobs in Unix and verified Event log file for testing and debugging
• Analyzed test results and prepares comprehensive subsystem and system level evaluation
• Created the defects in the HP Quality Center and communicated with the developers to fix them
• Generated the RTM by mapping all the requirements in the Quality Center that are loaded from DOORS
• Used Rally for story tasking, acceptance criteria and defect tracking defects
• Did regression testing of the application and troubleshooting the data
• Executed the batch jobs in the unix environment to load the data from source systems
• Performed all UI screens validations and data flow between screens that are match with the backend
• Did cross browser functionality test on browsers like IE9, Firefox, Chrome
• Worked on the batch job failures by tracing the log files and resolved the issues
• Assisted UAT team in setting up the test data
• Demonstrated the application to end users and business team
• Worked in Agile methodology for project development and testing
• Generated the test metrics and addressed the progress of the project in the daily status meetings

Environment: HP Quality Center 10.0, QTP 9.0, Java, J2EE, JSP, SOAP, HTML, Java Script, Internet Explorer 8, Oracle Enterprise Server 11g, Oracle XML DB, Toad 9.0, Clear Quest, Clear Case and Window 7, XML, XSD, XML Spy, Rally, Unix, Restful, SOAP, Soap UI, Restful, JSON

Confidential

Position: QA Analyst

Responsibilities:

• Involved in testing interfaces, which includes extracting XML messages using web service utility programs and verified the data mapping into main tables.
• Involved in a team for testing ETL process for Networx Order Statusing which constitutes five major processes and Installed Data Stage Client
• Created test cases and mapped them to the requirements in Quality center and executed the test cases from test lab
• Performed back end testing by executing SQL queries with conditions that are derived from business rules
• Participated in review meetings and walkthroughs with development and Business Analysts and make sure the A D documents are updated
• Involved in smoke, Ad Hoc, Functional, Regression and Back end testing
• Performed end to end testing manually
• Quality Center was used to create the test plan, store test cases and run the test sets
• Effectively defined, analyzed and documented client requirements utilizing UML standards including extensive use case modeling and use case realization
• Used Data Stage Director to run scheduled jobs and as well monitored server jobs.
• Verified XML messages using XSLT, XPath, XQuery, XML Spy sent to EMS via SOA
• Involved in Functional requirement analysis with the business analysts.
• Reviewed the High level design HLD , A D's, Functional requirements, System Impacts and discussed the new functionality Implemented in team meetings and A D walkthroughs
• Created the test cases and use cases to cover the business flows
• Reviewed the test cases with the Business and system analysts
• Reported defects to the development team by using defect tracking tools quality center
• Involved in tracking and updating requirement traceability matrix, thereby linking test cases with business requirements in QC
• Executed batch jobs and tested the data flow
• Participated in the Daily Standup meeting and addressed the progress.

Environment:

HP Quality Center, Manual Testing, Share Point, Oracle, Toad, Sql Developer, Sql Server, JIRA, Win SCP, putty, Unix, Win 7, JAVA/J2EE, Apache Tomcat

Confidential

Position: Manual Tester

Responsibilities:

• Interacted with business analysts, architects, developers in requirement analysis, design, review, testing
• Analyzed business and functional specifications and created test plan, test scripts for functional, regression and smoke testing
• Developed testing strategies based on priority and repeatability to determine test scripts to be automated and manually tested
• Created test cases, test data as per business requirements and did end to end manual testing
• Did GUI testing, Positive, Negative, Security, Integration, Regression testing using QTP
• Re tested the defects logged into the HP Quality Center database
• Extensively wrote SQL queries to validate the date across the application
• Oracle used as a relational backend and wrote complex queries, stored procedures, triggers, functions using PL/SQL
• Worked on SQL queries to test data consistency across the application
• Designed the data driven tests in QTP scripts to validate with different sets of test data
• Managed multiple versions of tests and test assets while maintaining data integrity
• Created release risk assessment and provide QA sign off for the application release
• Provided subset of functional test cases to UAT test
• Involved with performance testing group to test performance and stress the test scenarios and analyzed the results using graphs and reports
• Reviewed the quality matrices and keep track of project planning and progress
• Actively involved in testing in all phases of the product to best match the requirements

Environment:

HP Quality Center, Manual Testing, Share Point, Oracle, Toad, Sql Developer, Sql Server, JIRA, Win SCP, putty, Unix, Win 7, JAVA/J2EE, Apache Tomcat

Confidential

Position: QA Analyst

Responsibilities:

• Developed test cases and test data as per business requirements
• Did Manual testing on Tested application functionality
• Developed defect workflow in Test Director to enable team to log defects and maintain effective and efficient defect resolution.
• Created comprehensive test procedures for web based applications
• Using Visio created workflows and diagrams for new functionalities
• Executed compatibility testing on different browsers and different operating systems
• Analyzed, comprehend and verified test metrics obtained from test procedures
• Documented all test results along with test scripts and test plans
• Involved in build release on QA track and work independently within a team environment
• Worked independently in planning, anticipating problems, anticipated cross functional needs and taking appropriate action within the role
• In each development phase coordinated with all stakeholders and understood the client requirements

Environment:

Manual Testing, Sql Developer, Sql Server, Excel, Visio, putty, Unix, Win XP,

Confidential

Position: QA Tester

Responsibilities:

• Collected Requirements from Client
• Analysis of Client Requirements
• Involved in Designing, Coding and testing of Modules
• Prepared reports of various modules as per the Client requirement
• Involved in Team Review meetings
• Provided Training to Client People
• Performed GUI and User Acceptance Testing
• Performed extensive database testing by writing SQL queries
• Used SQL Developer to execute SQL queries
• Retested the fixed defects
• Maintained the Work Products in CVS
• Prepared and maintained Change request documents.
• Used Pre-Execution checklist to verify that the environment is ready for testing
• Actively Involved with Users and Business Team and actively participated in business meetings and reviews

Environment:

Visual Basic 6.0, SQL-Server 7.0, Windows-NT, SQL Developer