Qa Analyst Resume
Marshall, MN
OBJECTIVE
- I have over 5 years of diverse experience in Information Technology with an emphasis on Software Quality Assurance in Retail Industry.
- My ambition is to take up a challenging position in the area of Software Quality Assurance and Testing in a progressive, fast - paced dynamic environment that will allow me to align my skills in the organization in the most efficient manner.
SUMMARY
- Job operated within Agile environment, employing 2-4 week sprints, daily scrum meetings, burn-down charts, task weighting, pair programming, refactoring, presentations and review.
- Attended requirements and design meetings, review and analysis of requirements and design documentation.
- Developed and executed functional, integration and system test plans for initial implementation, all break/fix and enhancement changes to the POS System.
- Strong SQL skills, including the use of nested table expressions, unions, and multi-table joins, scalar functions, outer joins and derived columns.
- Good knowledge of Test Case Management and Defect Management tools like HP Quality Center (ALM), Microsoft Test Manager (MTM), Visual Studio Team Foundation Server(TFS).
- Organized five QA resources on site and five from India.
- Performed functional, integration and system testing.
- Worked on Log file to make sure they are generated as per the transactions.
- Extensively usedSQLstatements to query theOracle Databasefor Data Validation and Data Integrity.
- Reported and Tracked bugs using Quality Center.
- Involved in end-to-end test of Sales and Non sales data in downstream applications, key and poll is the process where sale data originating from stores POS flows to the backend applications
- Interface testing by comparing flat files from the exchange information against application.
- Executed multi-faceted testing including Black Box, Functional, Smoke, Regression, Integration, and Ad hoc Testing according to test plan.
- Designed, implemented, and updated the test plans using Quality Center by reviewing appropriate documentation to test the functionality of different modules.
- Participated in releasing and iteration planning, and represented the QA team.
- Interacted and managed expectations of multiple participants in the application development lifecycle.
- Participated in risk management to help determine best use of development and testing resources.
- Worked with different backend environments to successfully complete the given tasks
- Managed small teams of testers, delegated testers to implement plans and Allocate resources with changing business processes.
- Conducted Backend testing on the Oracle Database using SQL.
TECHNICAL SKILLS
Defect Tools: JIRA, Bugzilla
Test Reporting Tools: Rational Clear Quest, TFS, Quality Center, ALM, SOAP-UI
Operating Systems: Windows 98/2000/XP/NT, UNIX, LINUX
Databases: Oracle, DB2, MS SQL Server, MS Access, TOAD
Testing Languages: TSL, SQA Basic, VB Scripting
Web Technologies: HTML, XML, ASP, JSP
Programming Languages: C, C++, SQL, Visual Basic, JAVA/J2EE,.NET
PROFESSIONAL EXPERIENCE
Confidential, Marshall, MN
QA Analyst
Responsibilities:
- Exported Test Cases using Mercury Excel add-in into Quality Center and converted them into Test Scenarios for automating in Test Plan and Test Lab module.
- Integrated the developed modules to the Payment Gateway application
- Reviews test plans for teammates and coworkers.
- Performed Functional and Testing using POS.
- Validated that POS BO is configured to work with Replication of data i.e. any Price, adding, editing and deleting operators from POS Back Office (POS BO) for all server and stores.
- Developed test cases and scripts using Micro Excel for Functionality, PCI, Gift Card, Rewards Card Discount, DTI and Regression Testing.
- Extensive experience with e-commerce and POS platforms
- Maintained Project Glossary for the entire project team.
- Performed web service testing using Soap-UI for the functional testing.
- Executed test by sending the request and receiving the response in XML format using SOAP-UI.
- Implemented Automation process in manual testing environment using Mercury Test Suite.
- Worked on Requirements, TestPlan, TestLab and Defects modules in Quality Center for Regression testing.
- Automated the Back-End testing for reusability by writing Unix Shell Scripts.
- Created and maintained SQL Scripts and PHP scripts to perform back-end testing on the oracle database.
- Kept track of all the defects opened by UAT execution using Quality Center.
- Wrote complex SQL queries to perform the backend testing of the Oracle database using PL/SQL developer and UNIX shell commands
- Enhanced Scripts by Putting Check Points like standard checkpoints, Text Checkpoint, output values by putting Text Area output value Check point, passing values between actions if the scripts needs.
- Worked on a PHP platform and experience in backend testing by executing SQL queries
- Generated Project status reports thru Quality Center and Document Generator for team meetings and Management review.
- Data validation and Database integrity testing done by executing SQL, PL/SQL statements.
- Validated the load of data to the environment using SQL queries.
- Develop and execute scripts to test data migration using SQL and UNIX Shell Scripting
- Tested the validity of the data cleaning done by the ETL by writing SQL queries.
- Manually tested the new test cases for new functionality and automated them for further loads to reduce testing effort and time using Quick Test Professional.
- Manipulated theThink timein order to see the response of the application was affected or no in Load Runner.
- Used Quality Center for error reporting and communicating between developers, product support and test team members.
- Interacted with developing team to resolve technical issues and investigated software faults.
- Developed and maintainedTest & Traceability Matrices.
- Manually tested the web application to ensure the flow of the application functionality.
- Worked with offshore support team for issues and concern for the payment gateway.
Environment: Windows NT, Windows server 2003, SOAP, Agile, Scrum, Compuware tools,Quality Center, Oracle, .NET, UNIX, SQL Queries, Test Plans, Test Scripts, Test Scenarios, Oracle, TOAD, Test Lab
Confidential, Cincinnati, OH
QA Analyst
Responsibilities:
- Involved in developing detail Test Plans for different benefit packages according to Business requirements documentation.
- Performed Functional, System, Security, Regression & User Interface testing of software and applications
- Implemented a successful supply chain management process within the POS group.
- Interacted with the client groups to determine performance requirements and goals, determine test strategies based on requirements and architecture.
- Checked compatibility of all the applications configured by the image capture specialists.
- Drafted detailed system Test cases for the Application; worked with the built team to modify the documents and updates.
- Worked in Mainframe environment and used SQL to query various reporting databases
- Extensively worked on Agile Methodology.
- Involved in Daily scrum meeting for Test status and Defect Status.
- Participated in Sprint Planning as part of the agile development for Different functionality for Testing.
- Involved in continuous Business Requirement scrubbing to ensure the stores and POS strategies.
- Created and maintained Test Scenarios and Test Cases Documents for Pre-Order, order Replacement and order generation.
- Created and executed test plans and scripts to verify software functionality and adherence to business requirements.
- Reported bugs inTFS, and actively followed up with the development team to get all issues resolved
- Performed manual testing using SQL Scripts.
- Performed the Backend integration testing to ensure data consistency on front-end by writing and executing SQL queries on the Database.
- Updating daily tasks and storing the automation code in Visual StudioTFS
- Reviewing the defects and Reporting the Defects throughTFS
- Developed and maintained test status reports for each certification.
- Created graphs and generated performance reports.
- Executed positive and negative testing manually.
- Performed execution of test cases manually to verify expected results.
- Done Security testing manually on the log on screen for members.
- Involved in the discussions of Defect Tracking Process and Updated Work Progress in Excel Sheets.
- Experience in developing Automation Frameworks right from scratch for huge testing projects using Business Process Testing (BPT).
- Monitored resources to identify performance bottlenecks, analyze test results and report the findings to the clients, and provide recommendation for performance improvements as needed.
- Involved in discussion with the Subject Matter Experts (SME) during creation of test plans and updating of business requirements.
- Involved in new development, support, enhancement of application.
- Created manual testing and troubleshooting methodology.
- Involved in manual documentation as to how to maintain and run scripts for future enhancements.
- Ran the scripts on multiple environments (QA, UAT and Production) to ensure that requirements were still met.
- Reported defects according to Defect Life Cycle using TFS.
- Monitoring the defect life cycle, generating customized graphs and reports for the client, using Quality Center.
Environment: Manual Testing,SOAP-UI Pro, TFS, .NET, Android, IOS, Test Harness, Windows XP, Oracle, Agile, Scrum, SME, UAT, BPT, Quality Center, Test Cases, Test Scenarios, Test Plans, MS Excel, MS Access. iOS, java, ASP.Net.
Confidential, Goodlettsville, TN
QA Tester
Responsibilities:
- Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and Test plans.
- Designed the business requirement collection approach based on the project scope and SDLC Methodology
- Gathered requirements to conduct and schedule stress tests.
- Develop a clearly defined Test plan to ensure the test scenarios will accomplish testing objectives..
- Performed System, Functional, UAT and Black box Testing.
- Responsible for writing and executing the test cases for GUI, hardware and communication interfaces using HP Mercury Quality Center.
- Validated that POS BO is configured to work with Replication of data i.e. any Price, adding, editing and deleting operators from POS Back Office (POS BO) for all server and stores.
- Involved in end-to-end test of Sales and Non sales data in downstream applications, key and poll is the process where sale data originating from stores POS flows to the backend applications
- Create Test lab and map the defects directly to the requirements in the HP Quality Center and run Reports.
- Maintain Traceability Matrix: Ensure that all the Test Cases are updated in the HP Quality Center along with Master Test Plan.
- Prepared Test Scenarios using SQL Queries for Backend Testing and Test Cases for the application under test.
- Worked on UNIX shell scripts using SQL commands for the data validation.
- Generated Project status reports thru Quality Center and Document Generator for team meetings and Management review.
- Responsible to report bugs using Quality Center and MS Excel.
- Updated bug status in Quality Center through regular communications with Development team.
- Validated the scripts to make sure they have been executed correctly and meets the scenario description.
- Participated in requirement analysis and prepared systems test documents.
- Using SQL for checking the output of various reports.
- Created and maintained SQL Scripts to perform back-end testing on the oracle database.
- Designed and implemented basic SQL queries to generate statistical report
- Created different manual and goal oriented scenario to sketch real time scenarios in production.
- Validated the scripts to make sure they have been executed correctly and meets the scenario description.
- Worked with offshore support team for issues and concern for the payment gateway.
Environment: Windows NT, .NET Windows server 2003, Quick Test Professional, Quality Center, Oracle,UNIX, Visual Studio, Test Cases, Test Plans, Test Scripts, TOAD, Quality Center, PuTTy, Unix, UAT, UML, Actvivity Diagrams, SDLC, STLC, MQC.
Confidential, Minneapolis, MN
QA Analyst
Responsibilities:
- Assisted the business analyst team in preparing the Functional Specification Document
- Prepared Test Plans and Test Cases based on the business requirements
- Performed Security Testing.
- Conducted Back End Testing using SQL Queries to ensure proper data validation
- Performed Data Validation and Data Integration using SQL Queries.
- Performed Positive and Negative testing to ensure appropriate user authentication.
- Created multiple user scenarios to measure severe performance.
- Scheduled scenarios using Ramp - up, Ramp-down to simulate varying amount of user load on the server.
- Performed Regression testing using QC.
- Participated in the team for User Acceptance Testing. Performed web service testing using Soap-UI
- Involved in writing Traceability Matrix and performed Gap Analysis.
- Conducted result analysis and interacted with developers to resolve bugs.
- Used Quality Centre to Track, generate, and Report Bug. Also documented the report.
Environment: Quality Center/ALM, Agile, Windows, QC, Oracle, Test Cases, Test Plans, Test Scripts, Test Scenarios, SQL Queries, Gap Analysis, Black End Testing, Data Validation, MS Excel, MS Access, TOAD, SOAP UI, Java, ASP.Net, DB2.
