Software Analyst Resume
Sterling, VA
SUMMARY
- 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.
- Experience in Agile Scrum methodology and Waterfall methodology.
- Expertise in all phases of Software Testing Life Cycle (STLC), Bug Life Cycle (BLC).
- Excellent knowledge in managing QA process using Test Management Tools like Mercury Test Director, HP Quality Center (QC), HP ALM and Bug Tracking Tools like JIRA, Rally, Bugzilla
- Proficient in Software testing process which includes Test Planning, Test Strategy, Test Anlysis, Test Case Creation and Execution, Defect Creation and Tracking, Test Metrics, Reporting.
- Expertise in performing System testing, System Integration testing (SIT), Regression testing, GUI testing, Back end testing, Black box testing, Compatibility testing, User Acceptance testing (UAT).
- Experience in Defect - Analysis, Prioritize, Reporting, Management using QC, JIRA, Rally, Bugzilla.
- Proficient in writing SQL and PL/SQL required to perform backend database validation.
- Experience in working with databases like Oracle 11g, DB2, Sybase, SQL Server.
- Involved in data warehouse testing by validating ETL procedures/ mappings.
- Experience in performing testing SOAP and Restful Web Services using SoapUI, RestClient tools.
- Experience in using XML, XSLT, XSD and Schema Validations, XML Spy.
- Excellent Analytical skills to understand the Business Process, Requirements and Functionality.
- Proficient in collaborate with business analysts for business requirement clarification and developers to meet all the acceptance tests reflect the desired functionality.
- Expertise in preparing Test documents in all stages of Testing Life Cycle for reference and auditing.
- Well versed with basic code debugging, analyzing system log files for any application issues.
- Motivated self-starter with exceptional team building, leadership and interpersonal skills, Hardworking team player with the ability to work in time sensitive environments.
TECHNICAL SKILLS
Testing Tools: HP Quality Center, HP ALM, Win Runner, Test Director, IBM Test Manager, IBM Requisite Pro, IBM Clear Quest, Doors
Database: Oracle 11g, DB2, Sybase, SQL Server, MS Access
Other Tools: Toad, SQL Developer, Putty, Win Scp, XML, XSLT, XSD, SoapUI, RestClient, JIRA, Rally, Bugzilla, SharePoint, Atlasian Confluence, MS Office
Languages: SQL, PL/SQL, Shell Scripting, HTML, VB Script
Data Warehousing: Informatica
PROFESSIONAL EXPERIENCE
Confidential, Sterling, VA
Software Analyst
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 requirement gaps are clarified.
- Developed test scenarios, test scripts for both Manual and Automation as per business requirements.
- Involved in creating the End to End test scenarios and execution.
- Performed backend testing to validate the data writing SQL queries in Oracle using toad.
- Used SQL extensively to validate data partitions, data transformation and to validate consistency of data moved from the source system to target database.
- Performed SOAP and Restful Web Services Testing using soapUI, RestClient.
- Tested Restful Services which handle the calls to backend and provided JSON to front end.
- Performed all UI screen validations and data flow between screens that matched with the backend.
- Did GUI testing, User Roll based testing, Functional testing, Database testing, Regression testing.
- Performed Regression testing of the application and Troubleshooting the data.
- Did cross browser functionality test on browsers like IE9, Firefox and Chrome.
- Executed Batch Jobs in Unix to import/export the data and verified database for data accuracy.
- Worked on the batch job failures by tracing the log files and resolved the issues.
- Designed the data driven tests in QTP scripts to validate with different sets of test data.
- Created the defects in the HP Quality Center and communicated with the developers for resolution.
- Generated the RTM by mapping all the requirements in the QC that are loaded from DOORS.
- Assisted UAT team in setting up the test data.
- Demonstrated the application to business team and end users.
- Worked in Agile methodology and followed the Sprint planning, Iteration, Scrum.
- Used Rally for sprint planning, story tasking, acceptance criteria, defect creation and tracking.
Environment: HP Quality Center, QTP, Rally, Doors, Oracle 11g, Toad, XML Spy, Soap UI, RestClient, Win Scp, Putty, Unix, Java, IE 8, Window 7
Confidential, Arlington, VA
QA Analyst
Responsibilities:
- Involved in analyzing business requirements and responsible for planning and execution.
- Reviewed the High level design (HLD), Functional requirements, System impacts and discussed with business analysts and developers.
- Created the test cases and test scripts to cover the business flows.
- Reviewed the test cases with the business and system analysts.
- Participated in review meetings and walkthroughs with business analysts and development team.
- Did back end testing by executing SQL queries with conditions that derived from business rules.
- Created test cases and mapped them to the requirements in QC and executed test cases from test lab.
- Involved in testing interfaces, which includes extracting XML messages using web service utility and verified the data mapping into main tables.
- Verified XML messages using XML Spy.
- Involved in Smoke, Ad Hoc, Functional, Regression and Back end testing.
- Quality Center was used to create the test plan, store test cases and run the test sets.
- Performed manual and automation to test end to end scenarios.
- Reported defects to the development team by using defect tracking tool 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, Oracle, Toad, Sql Developer, Doors, Win SCP, putty, Unix, Windows, XML Spy, SoapUI, Java
Confidential, Atlanta, GA
QA 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 .
- 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.
- 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, Share Point, Oracle, Toad, Sql Developer, Sql Server, JIRA, Win SCP, putty, Unix
Confidential
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: Sql Server, Excel, Visio, putty, Unix, .NET
Confidential
Test Analyst
Responsibilities:
- Gathered requirements from client and did analysis.
- Involved in designing test cases, executing and testing of modules.
- Prepared reports of various modules as per the client requirement
- Involved in team review meetings.
- Performed GUI and Functional Testing.
- Performed extensive database testing by writing SQL queries.
- Used Toad to execute SQL queries.
- Retested the fixed defects.
- 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 in understanding and reviwing business requirements.
Environment: Visual Basic 6.0, SQL-Server 7.0, Windows-NT, SQL Developer