Sr. Qa Analyst Resume
Syracuse, NY
SUMMARY
- Accomplished, highly motivated technology professional with 7+ years of hands - on IT and quality assurance experience.
- Hand-on experience and in depth understanding of complete Software Development Life Cycle (SDLC) in client-server, intranet and working knowledge on mobile application development using OOAD, Agile(XP, SCRUM) and RUP methodology.
- Good Knowledge in UNIX, Mainframe, Java, J2EE, VB, VB.NET,C#, Oracle, AS/400, Developer 2000 and .NET applications
- Experienced inRequirement Analysis, Arriving at Test Scenarios from Requirements and Use cases, Test Planning, Test data Preparation, Test Case Execution, Defect Reporting and Documentation.
- Strong experience in using Test management tools like HP ALM, Test Director, JIRA and Defect tracking tools like Issue Tracker and IBM Rational Clear Quest.
- Experienced Setting up, configuring, and maintaining the automated testing environments and framework using VBScript functions, and descriptive programming using HP Quick Test Professional (QTP).
- Proficient in Smoke, Functional (Negative, Positive) system, Integration, Black-box, Gray box, GUI, End to End, Exploratory, Ad-hoc, Regression, Cross-Browsers and User Acceptance (UAT) Testing.
- Expertise in test automation using Selenium IDE and Web Driver (with Eclipse & JUnit).
- Experienced in Functional testing, System testing, Integration testing, GUI Testing and Regression testing using both Manual and automated testing tools.
- Expertise in creation of UAT Plan and UAT cases covering different business, functional and non-functional test scenarios and creation of expected test results.
- Performed Service Oriented Architecture SOA / Web Service testing using SOAP UI.
- Extensive knowledge of the HIPAA implementation guidelines, ICD-9 and ICD-10 code sets.
- Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
- Expert in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.
- Implemented RDBMS concepts in SQL Server and Oracle using T-SQL/PL/SQL (DDL/DML) to create Stored Procedures, User Defined Functions, Views, Dynamic SQL, and Triggers in Database Creation, Maintenance, and Testing.
- Achieved proficiency in creating Requirement Traceability Matrix (RTM) and Bug Reports.
- Experience working with offshore teams. Ability to work on multiple projects which are in various phases of the system development lifecycle
- Able to work collaboratively with testers, developers and other team members in testing complex projects and in the overall enhancement of software product quality.
TECHNICAL SKILLS
Bug Tracking Tools: JIRA 4.0/4.4/5.0, Bugzilla, HP ALM(QC 11.5), Quality Center
Testing tools: UFT (Unified Functional Testing), Quick Test Professional(QTP), Selenium, HP Test Director, HP Win Runner, SOAP UI, Load Runner, Clear Quest, WinRunner7.0/6.0, Microsoft Test Manager, Load Runner 7.8/8.0/11.0 , Rational Quality Manager, Rational Functional Tester, JIRA, Test NG, HP ALM, Groovy
Web Browsers: Internet Explorer, Google Chrome, Mozilla Firefox, Safari
Databases/ Tools: Informatica, Oracle, SQL Server, TOAD, PL/SQL, MS Access, and My SQL
Microsoft Technologies: VBScript, .NET, C#, Java, JSP
Web Technologies: CSS,HTML, XML, iPad, iPhone, Android
Others: Macromedia Dreamweaver, I-frames and Microsoft Office (Outlook, Project, Excel, Word, & PowerPoint).
PROFESSIONAL EXPERIENCE
Confidential, Syracuse, NY
Sr. QA Analyst
Responsibilities:
- Responsible for writing and executing test cases on department’s purchase order requisition according to the user story.
- Co-ordinate with Project Manager, Business Analyst, Developers, Subject Matter Experts, End users and other project team members to ensure project success and high quality of product throughout the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
- Documented pre-condition, post-conditions, entry-exit criteria for each test-scenario by creating test plan and test strategy documents.
- Developed and Managed Test Cases using requirement specifications, data flow diagrams.
- Used HP Quality Center and MS Excel to write test cases & executed them for user interface & functionalities.
- Successfully performed various types of Test effort such as Smoke testing, Functional testing ( Negative & Positive ) GUI Testing, Integration testing, Black-box testing, Database testing,, Cross-browsers testing, Security Testing and Regression testing, User Acceptance testing (UAT) etc.
- During test execution if any defects found than Logged the defects and tracked them by following Defect life cycle in QC until the defects are fixed verified and closed.
- Performed execution of the automation scripts for functional and regression testing on different builds using HP Quick Test Professional (QTP).
- Enhance the QTP test scripts with VB scripts and develop user-defined functions for frequent re-use.
- Developed and implemented load and stress tests with HP Load Runner, and presented performance statistics to application teams, and provide recommendations for improvements.
- Extensive knowledge of database Schemas, SQL Languages, querying Tools such as SQL developer, TOAD by using Oracle and proficient at performing Database Testing, data manipulation, checking constraints, etc.
- Hands on experience in performing Cross browser testing on IE, Chrome, and Firefox.
- Consulted with the customer service representatives to take their opinion on the customer satisfaction with respect to their prior experiences and designed the test cases.
- Attended Kick-off, daily stand up, weekly QA meetings and Teleconferences on problem resolution with the team.
- Prepared status summary reports in details such as how many test scripts executed, passed and failed on timely manner.
Environment: Agile/SCRUM, SQL Server 2012, Windows 8, Oracle 11g, MY SQL, PL/SQL, Java, J2EE, JavaScript, JQuery, Quality Center, QTP, UAT, Load Runner, TOAD, Test NG, MS Office, MS Visio.
Confidential, Rochester, NY
QA Analyst
Responsibilities:
- Review Business Requirement documents (BRD), Software Requirement specification (SRS) and Prepared Test Plan
- Created the automation frameworks in QTP
- Performed SQL Server’s data validation and database queries
- Used Back-end database SQL Queries to perform data testing
- Documented Manual Test cases, Test procedures and Test results.
- Extensive Web Testing & Black box Testing.
- Performed Functional, GUI testing ETL testing, Data warehouse testing & web based application.
- Conducted the Smoke Testing to check the High Level functionality of an application.
- Created the Automation Framework for the application to make sure the adequate coverage for the regression testing.
- Automated the test scripts for the GUI, Functional, Data Driven and Regression testing using QTP
- Created parameters that inserted different data into each iteration of a test run using Parameterize Test in QTP
- Developed VB Script using QTP
- Found bugs and updated JIRA with all bug details. Assigned it to Developers. Once bug fixed tested, verified and updated JIRA Ticket with all details.
- Provide the percentage of test scripts in JIRA, which is the project management tool.
- Planned and executedBack-End testingusing SQL Queries to verify the dataflow from the database.
- Checked for Broken links and number of links using
- Participated in weekly meeting and walk through to discuss Defects Priorities
- Defects tracked and reported using Quality Center Reporting tool.
- Performed system, Integration and Regression Testing.
Environment: Agile/SCRUM, Windows 7, SQL Server 2012, MY SQL, PL/SQL, Oracle 10g, JIRA, Java, J2EE, JavaScript, QTP, Quality Center, ETL, TOAD, Test NG, MS Office, MS Visio.
Confidential, Louisville, KY
Quality Assurance Analyst
Responsibilities:
- Gathered requirement documents for transition from ICD-9 to ICD-10.
- Involved in the Analysis of the Business requirements, test planning, test development, and test execution.
- Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams so that developers and other stake holders can understand the business process.
- Requirements gathering and evaluation in compliance with HIPAA 4010 and 5010 standard.
- Developed Requirements and Use Cases for Integrated Applications to support HIPAA EDI 4010 Transactions
- Performed Regression Testing and updated test assets periodically
- Participated in ICD 9 to ICD 10 codes conversion requirement gathering sessions and created high level business requirement document.
- Performed detailed analysis for all the functional areas impacted by ICD 10 codes.
- Extensively worked with Quality Analysts to make sure that the functionality meets requirements.
- Established Traceability Matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
- Prepared Requirement Traceability Matrix (RTM) to establish traceability between requirements and test cases and procedures.
- Worked on FACET modules such as pricing, payer, eligibility under claims processing system.
- Tested that the application can enable you to receive, store and send HIPPA standard transactions and facilitates the administration of HIPPA privacy rights.
- Implemented manual testing of a web-based application, including backend, functional and integration testing.
- Used Quality Center to record documenting information useful in debugging process, evaluating test data.
- Fully involved in backend integration database testing by writing and executing SQL queries to ensure data integrity and data consistency.
- Participated in protecting data security and confidentiality of healthcare standards.
Environment: RUP, Rational Requisite Pro, SQL Server 2008, MY SQL, PL/SQL, Oracle 11g, Java, J2EE, JavaScript, JQuery, Load Runner, TOAD, HP ALM 11.5, J meter, MS Office, MS Visio.
Confidential, Carrollton, TX
QA / Tester
Responsibilities:
- Actively Involved in Software Development Life Cycle and Test Life Cycle, Test strategies, Methodologies and processes.
- Developed test cases in Quality center (QC) for all modules for Customer, Inventory and Account management modules.
- Extensively involved Functional, Integration, and Regression testing for the above mentioned modules.
- Automated the test cases for the POS system by using QTP 10.0
- Created automated test suites for testing RESTful web services using SOAP UI and Groovy
- Used SOAP UI and Groovy to write automated test cases for database testing.
- Responsible for User Acceptance testing by giving demos and getting sign off.
- Written several SQL queries and analyzed them to validate the business rules in Oracle database through SQL Developer as part of Backend testing.
- Worked closely with Benefit Leads and Developers to isolate and troubleshoot defects and monitored until resolved.
- Experience utilizing Hudson for Java automation framework that integrates with Quality Center, uses page objects and scalable features.
- Used Quality Center tool for defect tracking and reporting bugs.
- Experienced writing scripts and automation in Python and working with SQL
- Used Service Oriented Architecture (SOA) Test for Web Services testing
- Implemented Agile best practices.
- Proficient in SQL Queries and analysis, Stored Procedures and PL/SQL programs.
- Performed black box testing like GUI, white box, integration, progressive, and system testing.
- Properly documented defects in Quality Center and followed up on bug resolution progress and escalated blockers to the lead appropriately.
- Prepared and participated in weekly status meetings, conducted walkthroughs, documented proceedings.
Environment: Agile/SCRUM, Windows 7, SQL Server 2012, MY SQL, PL/SQL, Oracle 10g, JIRA, Java, J2EE, JavaScript, QTP, Quality Center, ETL, TOAD, SOAP UI, Groovy, Test NG, MS Office, MS Visio.
Confidential, New York, NY
Quality Analyst
Responsibilities:
- Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers and QA team.
- Created and implemented Test Plan and Test Strategy Document outlining the scope, objectives, timeline and focus of software testing effort for functional, regression, user acceptance and stress testing.
- Involved in analyzing system specifications, design, development and execution of test plans and test cases for Manual and Automated testing.
- Developed Automation scripts for new enhancements using Firefox for record and playback using Selenium Web Driver/IDE and JUnit.
- Defect testing and exploratory testing/Ad-hoc testing was performed after each build.
- Provided back end testing for data validation using SQL on TOAD.
- Involved in testing the database and data validation using SQL Queries.
- Worked with source version control tool such as Subversion (SVN).
- Worked with developer to reproduce the bugs and to resolve usability issues during UAT.
- Created Regression Document to track and report testing activities during each phase of testing, including testing results, test case coverage, required resources, logged defects and their status, performance baselines.
- Participated in Stand-up meeting, walkthrough meeting, weekly automation meeting with all other QA, weekly assessment meetings with business analysts and developers.
Environment: RUP, Selenium, Selenium Web Driver, Selenium IDE, JUnit, MY SQL, PL/SQL, SQL Server 2008, UAT, HP ALM 11.0, TOAD, Java, J2EE, JavaScript, JQuery, Oracle 9, MS Office, MS Visio, JIRA
Confidential, McKinney, TX
QA Analyst
Responsibilities:
- Responsible for Gathering, Analyzing data and Articulating Tactical and Strategic Requirements for the purpose of developing solutions for the functional and business units.
- Analyze User Requests for New Systems as well as enhancements and modifications to existing systems.
- Communicate Project Requirements, Business Issues and make recommendation
- Coordinated Team in Primary Research in the identification of user’s specifications need
- Worked under Agile SDLC, which included requirements, specifications, design, analysis and testing methodologies.
- Performed Manual Testing to get a strong hold on the application’s primary function before automating the testing efforts.
- Conducted GUI testing to check for appearance and functionality of the application.
- Performed Manual Back end testing using SQL queries using Oracle SQL developer.
- Recorded Test scripts to conduct Regression Testing using Quick Test Pro (QTP).
- Collected and analyzed data from the scripts and communicated results to the Developers.
- Maintained an excel document with test defect information (i.e. Defect Header, Date Submit
Environment: Agile/SCRUM, SQL Server 2008, MY SQL, Oracle, PL/SQL, Java, J2EE, JavaScript, QTP, HPQC, MS Office, MS Visio