Sr.qa Analyst Resume
Simi Valley, CA
SUMMARY
- 6 plus years of experience in IT with a focus on Quality Assurance (QA / Software Testing), Manual and Automation testing in different sectors like Government, Retail, Banking and HealthCare
- Exposure and understanding of all Phases of Software Development Lifecycle (SDLC) which includes methodologies in Agile - SCRUM and Waterfall methodologies and Software Testing Life Cycle (STLC)
- Reviewed & analyzed requirement documents such as BRDs, FRDs, SDDs and derived test cases
- Hands on experience in preparing Test plans, Test cases, Automated Tests and Test Data. And executing the same.
- Extensively used automated test tools like Selenium WebDriver and HP UFT for Functional and Regression Testing.
- Extensively contributed towards manual testing /Web testing /Mobile testing/ Client Server testing on application.
- Expertise in using Tools such as HP Quality Center/ALM, SOAP UI, Rally and Team Foundation Server.
- Excellent knowledge in writing unique XPath using firebug and fire path to identify web elements.
- Good experience of understanding of WSDL, XML documents in Web Services testing using SOAPUI 5.1.3 tool. Providing required input data to request XML & get the required output data from response XML with URL using SOAP Project and also provide required input data to request JSON format with POST method based on URL and get the required output data from response JSON format using REST API Project.
- Responsible for generation and communication of daily, weekly and monthly test case, test execution and for reporting & defect logging using HP Quality Center/ALM, Rally, JIRA.
- Proficient in SQL Server, Oracle and used various data retrieving tools like TOAD, SQL Analyzer & SQL Plus to extract the data and to perform the Data Validation and Data Verification by using DDL and DML Statements.
- Experienced in backend testing, wrote complex SQL queries like Statements, Joins, Sub queries, aggregate functions, Group by, Having, Views and Stored Procedures and verifying the data flows between SQL Serversusing Packages.
- Vast experience in Functional testing, Integration testing, Regression testing, System testing, User Acceptance testing, Browser compatibility, ad-hoc testing, Backend Testing and Smoke testing.
- Experienced with various web browsers like Internet Explorer, Firefox, Safari, Chrome and Opera.
- 8 months of experience on PRPC Pega RULES Process Commander as design Testing, and PRPC work flow experience.
- Ability to work as individual and a team member in challenging, cross functional environment with both onshore and offshore teams.
- Possess excellent verbal and written communication skills. Dynamic and Assertive team player with strong commitment.
TECHNICAL SKILLS:
Testing Tools: Quality Center 9.2/10.0/11, HP ALM QC11, Selenium Web driver 2.49, HP Unified Functional Testing 12.2, TortoiseSVN Repository Bowser, SOAPUI 5.1.3, Viper, Fiddler, Snipping, Beyond Compare .
Methodologies: Agile (Scrum) and Waterfall models.
IDE & Portals: Visual Studio 2012/2010/2008, .NET Framework 4.5/4.0/3.5, Eclipse IDE, Team Foundation Server 2005/2008,Pega 7
Reporting Tools & BI Tools.: Microsoft SQL Server Reporting Services(SSRS), SSIS and SSRS
Operating Systems: Windows 9x/NT/XP, Windows 7/8,Window Server 2003/2008
Databases: Microsoft SQL Server 2005/2008/2012/2014, Oracle 9i/8i/7x, Toad ( Oracle 11.6)/(Oracle 12.9)
Defect Tracking Tools: Quality Center9.2/10/11,HP ALM QC 11/12, Rally
MS Office: MS-Word, MS-Excel (VLOOKUP, Pivot table and advanced functions), MS-Power Point.
PROFESSIONAL EXPERIENCE:
Confidential, Simi Valley, CA
Sr.QA Analyst
Responsibilities:
- Reviewed and Analyzed Business Requirement Documents (BRD) & Functional Specification Documents
- (FSD) And design test strategies, test plans and test cases to ensure test coverage of application.
- Actively Participated in JAD Sessions, project meetings, review sessions with BAs, SMEs, LOBs, Network
- Admins and Developers, Defect Status Calls, UAT coordination calls.
- Worked in agile - scrum teams and participated in various sprints. Involved in all the meetings of daily scrum,
- Sprint Planning meeting, Sprint Review meeting, Estimations and Sprint Retrospective to keep track of the
- Progress of the project and discuss the milestones in Utilizing Rally to manage the team's softwaredevelopment lifecycle .Identify any potential quality issues per defined process and escalate them immediately to Developers, Product
- Owner, Dev Manager and Scrum Master.
- Collaborate with Product Owner, understand the user stories based on Acceptance Criteria given and writepossible test scenarios. Get the test Scenarios reviewed by Product Owner in form of Test Plan doc .
- Performed manual test procedures for API functional testing of Web services using Soap UI 5.1.3.
- Create test cases in XML, JSON documents with URL in Web Services testing using SOAPUI 5.1.3 tool. Providing required input data to request XML & get the required output data from response XML with WSDL URL using SOAP Project and also provide required input data to request JSON format with POST method based on URL and get the required output data from response JSON format using REST API Project.
- Reviewed/ modified/ created test cases and test scenarios for different types of testing like functional testing, system testing, integration testing and regression testing as per the requirements.
- Involved in End To End Testing, as part of this testing we will be performing validations step by step from loan origination to loan closing and get involved with all the integrated applications and multiple team members in different steps of the process.
- Created test plan and test cases based on the acceptance criteria of user stories and attached testing doc in Rally and HP Quality Center/ALM.
- Played a lead role in developing Test Cases in a spreadsheet and uploaded them to Quality Center Test Plan module and executed them in QC/ALM test lab for various source systems.
- Involved to work with XML/JSON/CSV files for creating and verifying Data from Various systems.
- Used advanced Microsoft Excel to create Pivot table used VLOOKUP and other Excel functions.
- Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting
- Tight timeline in HP Quality Center/ALM Management Tool.
- Undertakes UAT to ensure that the defined business requirements are fully tested prior to roll out.
- Ensures that UAT for allocated projects is completed within agreed timelines and to a high level of quality.
- Maintain a content management system 'SharePoint' to store all the project documents, save previous
- Extensively involved with backend testing by writing and executing complex SQL queries like statements, joins, aggregate Functions, Group by, Having, Views and Stored procedure. to fetch data from an SQL Server database Server tovalidate and compare expected results with those actually obtained by applying ONETIME Scripts. Verified the data flows between SQL Servers and Conducted database testing, passing SQL queries to the Oracle database.
- Provide knowledge Transfer sessions about project requirements and designs to new testers in the team.
- Coordinated & Supported Offshore and also Onsite work efforts during entire project.
Environment: SQL Server 2014, HP Quality Center/ALM 12, Toad (Oracle 12.9),UFT 12.2, Soap UI 5.1.3,Windows 7, MS-Word, MS-Excel, MS-Outlook, Notepad, OneNote, MS PowerPoint, Microsoft Sharepoint, Microsoft Visual Studio 2010, Snipping tool, Beyond Compare tool.
Confidential, Calabasas, CA
Sr. QA Analyst
Responsibilities:
- Working with business and IT to understand the requirements and design ensuring that the system solution fully meets business requirements;.
- Utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle (Agile-
- Scrum) which involved in all the meetings of daily scrum, Sprint Planning meeting, Sprint Review meetingEstimations and Sprint Retrospective to keep track of the Progress of the project and discuss the milestones.
- Identify any potential quality issues per defined process and escalate them immediately to Developers, Product
- Owner, Dev Manager and Scrum Master.
- Volunteered responsibility for QA data runs, in order to update the data in the test databases for all the
- Test cycles and tested the data.
- Reviewed/ modified/ created test cases and test scenarios for different types of testing like functional testing,
- System testing, integration testing and regression testing as per the requirements.
- Created test plan and test cases based on the acceptance criteria of user stories/PCR in TFS Server Tool
- Used advanced Microsoft Excel to create Pivot table used VLOOKUP and other Excel functions.
- Conduct the test cases and prioritize the defects based on priority and severity in HP Quality Center/ALM
- Management Tool
- Maintain a content management system 'SharePoint' to store all the project documents, save previous
- Versions, track updates and to make it easy for everyone to stay up-to-date and coordinate their efforts in the
- Project.
- Worked with complexSQL queriesto test the data generated bythe jobsagainst the target database to validate and compare expected results with those actually obtained by applying ONETIME Scripts and also batch/job processes.
- Extensively involved with backend testing by writing and executing complex SQL queries like statements, joins, aggregate Functions, Group by, Having, Views and Stored procedure.
- Successfully Completed User Acceptance Testing (UAT) on each release of the project with the help of end user Requirements.
- Coordinated & Supported Offshore and also Onsite work efforts during entire project.
Environment: SQL Server 2012, HP Quality Center/ALM 11, Toad (Oracle 11.6), TFS server (SDLC tool), Windows XP, MS-Word, MS-Excel, MS-Outlook, Notepad, MS PowerPoint, Microsoft Sharepoint, Microsoft Visual Studio 2010, Snipping tool, Beyond Compare tool.
Confidential, Sacramento, CA
Sr. QA Analyst
Responsibilities:
- Participated in the project life cycle, from analysis to production implementation, with emphasis on data
- Analysis, development and regression testing and auditable documentation of results through Agile/Scrum
- Methodology.
- Followed the organization’s standard process, documentation formats for developing test plan, test cases and
- Coordinated with project team.
- Developed test scripts to automate process of testing in Selenium WebDriver.
- Utilize knowledge of Java to create automation test scripts
- Used Firebug Tool to identify the Object’s id, Name, XPath, link in the application.
- Developed Test case Scripts in Eclipse IDE and modified the selenium scripts and executed. Prepared automation test framework.
- Added annotations to the test. (Selenium).and Web Element Inspection throughFirebugandFire Path.
- Implement SeleniumGridto execute test scenarios on multiple browsers.
- Build tests throughmavenpom file and Test execution and reporting throughJenkins.
- Tests developed in Eclipse to start and to stop the selenium server and to execute the tests in browser.
- Performed manual and automated test procedures for functional testing of Web services using Soap UI.
- Volunteered responsibility for QA data runs, in order to update the data in the test databases for all the test cycles and tested the data.
- Created and executed test cases in Quality Center and mapped test cases with requirement to validate the
- Business requirements.
- Coordinated with business analysts to understand requirements, use cases and formulated test scenarios, test
- Cases, test scripts and test data.
- Reviewed/ modified/ created test cases for functional testing, system testing, integration testing and regression
- Testing as per the requirements.
- Extensively involved with backend testing by writing complex SQL queries like statements, joins, views and
Environment: SQL Server 2012, HP Quality Center, J2EE,JDK 7, SOAP UI 5.2, Web Sphere, Web logic, Testing, Java Script, Apache Http Server, Firebug, Fiddler, Windows 7, MS-Office, MS-Word, MS-Excel, MS-Outlook, XML, Eclipse IDE(Selenium Web driver 2.4), Maven, Jenkins, Fire path, Snipping tool, Beyond Compare tool.
Confidential, Calabasas, CA
Data Analyst
Responsibilities:
- Analyzed Business Requirement Documents (BRD) and Functional Specification Document (FSD).
- Created and executed test cases in Quality Center and make sure test cases mapped with requirement to validate
- The business requirements.
- Coordinated with business analysts to understand requirements, use cases and formulated test scenarios and test
- Data.
- Attended JAD Sessions, regular project meetings, discussions with BAs, SMEs, Network Administrators and
- Developers.
- Utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle
- Including deriving product backlog Items, assigning sprint work items to developers and conducting sprint
- Review meetings.
- Reviewed/ modified/ created test cases and test scenarios for different types of testing like functional testing,
- System testing, integration testing and regression testing as per the requirements.
- Created test plan and test cases based on the acceptance criteria of user stories/PCR in TFS Server Tool
- Used advanced Microsoft Excel to create Pivot table used VLOOKUP and other Excel functions.
- Involved in scheduling and executing test sets, collecting test result and analyzing the data using
- Microsoft Visual Studio 2010.
- Extensively involved with backend testing by writing complex SQL queries like statements, joins, aggregate
- Functions, Group by, having, views and stored procedure using Microsoft’s SQL Server.
- Successfully Completed User Acceptance Testing (UAT) on each release of the project with the help of end user
- Requirements.
Environment: SQL Server 2012, HP Quality Center 11.0, Toad (Oracle 11.6),TFS server (SDLC tool), Windows XP, MS-Office, MS-Word, MS-Excel, Viper,MS-Outlook, Microsoft Sharepoint, Microsoft Visual Studio 2010,Snipping tool, Beyond Compare tool.
Confidential, Los Angeles, CA
QA Analyst
Responsibilities:
- Participated in the project life cycle, from analysis to production implementation, with emphasis on data analysis,
- System testing, regression testing and auditable documentation of results.
- Analyzed Business Requirement Documents (BRD) and Functional Specification Document (FSD).
- Followed the organization’s standard process, documentation formats for developing test plan, test cases, and
- Coordinated with project team.
- Attended JAD Sessions, regular project meetings, discussions with BAs, SMEs, Network Administrators and
- Developers
- Responsible for creating test plan to help in detailed testing of the DSI Imaging Solution as per the business requirements.
- Conducted Integration testing of DSI Imaging Module with the Reggie Registration application .
- Used LAN Desk automation process, installed and tested MSI Packages in multiple clients within the client network.
- Performed MSI Package integration testing.
- Used back-end database and created SQL queries to perform data integration testing using SQL Server.
- Performed scenario testing, and integration testing for the patients with different clinical Document categories provided by the business.
- Coordinated and Supported Offshore and Onsite work efforts during entire project.
- Performed functional, system, regression and user acceptance testing for DaVita’s patient registration module which was developed in .NET.
- Have good understanding and knowledge about Relational Database Systems and experience in working with SQL Queries.
- Wrote SQL queries to access the data from the database tables and crosscheck the results.
- Created and executed test cases in Quality Center and mapped test cases with requirement to validate the
- Business requirements.
- Responsible for documenting test cases and defects using Quality Center.
- Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline in Quality Center.
Environment: Windows XP, MS-Office, MS-Word, MS-Excel, MS-Outlook, HTML,HTTP, .Net, Microsoft SQL Server 2008, Crystal Report Web Applications,Fiddler,Internet Explore, and HP Quality Center.
Confidential, Chicago, IL
IT Analyst
Responsibilities:
- Participated in strategy and status meetings to report issues and also in Build release meetings and
- QA status meetings.Communicated with developers through all phases of testing to prioritize bug resolution.
- Effectively implemented different QA methodologies/policies, strategies and plans in all stages of
- SDLC(Scrum).
- Involved in scheduling and executing test sets, collecting test result and analyzing the data using
- Visual Studio 2010.
- Utilized Microsoft Team Foundation Server (TFS) to manage the team's software development lifecycle
- Including deriving product backlog Items, assigning sprint work items to developers and conducting sprint review meetings.
- Performed System, Functional and Regression test and verified all the failure conditions enhancement.
- Develop test schedule and scenarios for both system testing and User Acceptance Testing (UAT).
- Developed test execution plan describing important details regarding how the test sets need to be conducted, organized and executed.
- Performed Black Box Testing, Usability and Integration Testing.
- Wrote SQL queries to access the data from the database tables and crosscheck the results.
- Performed cross-browser testing using Safari,IE & Firefox.
- Performed Database Integrity testing using SQL*Plus to ensure the data has been populated as intended and all database events occurred properly.
- Participated in design, walkthrough and review meetings.
Environment: Windows XP, One Notepad, Visual Studio 2010,TFS 2010, HTML, XML, MS office, MS-Word, MS-Excel, MS-Outlook, Microsoft SQL server 2008.
