Sr. Qa Analyst/business Data Analyst Resume
Lenexa, KS
SUMMARY:
- Senior QA Analyst having over 7 years of experience in Software testing and Quality Assurance.
- Experience as QA lead, working in GDD Model, managing the offshore team.
- 7+ years of experience with Software Testing and QA Methodologies.
- 5+ years of Experience with HP Functional Tester 11 (Quick Test Professional 10.0/9.0).
- 1+ years of Experience in Performance Testing Tool HP Load Runner.
- Well Versed in working with all phases of Agile Methodologies (SCRUM,KANBAN).
- Involved in Business Process Testing (BPT) using QTP and Quality Center.
- Experience in Bug Tracking Tool BugZilla, JIRA, ClearQuest, Rally,TFS 2010/2012.
- Involved in installation, configuration and integration of IBM Rational Functional Tester and IBM Rational Quality Manager.
- Exposure to all stages of SDLC, STLC, Product Life Cycle, Bug Life Cycle.
- Exposure to Different Software Development models like V - Model and Agile testing models.
- Exposure to SEI CMMI (Capability Maturity Model Integration) and ISO Quality Processes.
- Involved in Smoke Testing, Sanity Testing, System Testing, Regression Testing, Installation Testing, Compatibility Testing, Database Testing and Business Process Testing( BPT).
- Experience in Database Testing using Oracle, SQL Server and DB2.
- Experienced in using TOAD for database testing and stored procedures.
- Experienced in data migration testing after destructive database upgrade.
- Expertise in Backend Testing using SQL queries as well as automated testing using Quick Test Pro, Quality Center by using ODBC connectivity.
- Participated in Design,Development of Automated implementations of Functional Requirements.
- Experience in of Installations of Web Application in Windows, Linux/Unix(AIX, HP-UX, Solaris.
- Experienced in writing UNIX Shell Scripts for start-up and shutdown scripts for applications.
- Having Experience Installation of Patches and Hot fixes on the installed application.
- Experience in XML and SOA ( Service Oriented Architecture).
- Experience in using SOAP UI for testing web interfaces using WSDL, creating mocks.
- Experienced in using Configuration management tools like VSS, CVS, Clear Case and StarTeam.
- Experience with HIPAA EDI 4010/5010 Standards.
- Exposure of preparing and presenting Test Reports, Defect Report, Weekly Status Reports, Senior Management Reviews (SRM) to the Project Team and Senior Management.
- Ability to Lead Teams and can Coordinate Assign work and can motivate team members.
- Experience in Developing and Analyzing Test Metrics and Bug Analysis.
- Extensively Participated in Sprint Planning Activities to scope and plan efforts, Analyze Test Efforts and ensure key delivery dates are met for the project.
- Work Closely with Scrum Team members to ensure project meets the deadlines.
- Experienced in Software Estimation Techniques.
- Participate in Client Meetings, Requirements Gathering Sessions, Product Owner Demos, Describe the important features developed in the Sprint to Business Teams.
- Knowledge of Cucumber,lettuce BDD Tools.
TECHNICAL SKILLS:
HP Functional Testing Tools: HP Unified Function Tester 11.5/QTP 10/9.5/9.2, WinRunner 7.0
HP Performance Testing Tools: HP LoadRunner 8.0
Test Management Tools: HP ALM 11/Quality Center 9.0, Test Director 7.6Bug Tracking Tools:BugZilla, JIRA, ClearQuest
Continuous Integration Tools: Hudson,Jenkins,CVS,VSS
Programming Languages: C, C++, SQL, PL/SQL, T-SQL, COBOL, Java,JScript
IDE: Eclipse 3, NetBeans 7
Operating Systems: Windows 9x, 2000, NT, UNIX, Linux, Solaris, Macintosh
RDBMS: Oracle 11i, 10g, 9i, SQL Server, MS Access, DB2, Sybase
Data Modeling Tools: ERWin, Cognos Framework Manager, UML
Business Intelligence Tools: IBM Cognos 8 Business Intelligence, OBIEE 11g,Informatica 8.6
Health Standards: HL7 (Health Level 7), EDI HIPAA 4010/5010 Standards, X12
Application Servers: Web Logic, Web Sphere, Tomcat, IIS
Web Technologies: HTML, XML, XSD, WSDL, SOAP
Web Service Testing Tools: Soap UI, XML Spy
GUI Tool: Visual Basic 6.0, Power Builder
Office Tools: MS Word, MS Excel, MS Power Point, Microsoft Project 2000
File Transfer Tool: FileZilla
Scripting Languages: VB Script, Perl, UNIX Shell Scripting.
Trade Tools: TOAD, SQL Developer, Visio, Beyond Compare 2.0
Open Source Automation: Selenium Web Driver,Selenium IDE
PROFESSIONAL EXPERIENCE:
Confidential, Lenexa, KS
Sr. QA Analyst/Business Data Analyst
Responsibilities:
- Analyzing the Business, Functional requirements and prepared Use cases diagram and Use Cases.
- Preparing the traceability Matrix to ensure the coverage of requirements, and test artifacts like test plan, test cases and test data for execution.
- Worked with the developer on outstanding defects and followed the defect management cycle.
- Test front end data functionalities and content loading like images, carousals and ensure data integrity. Tested Web application UI.
- Prepared flat files for ETL testing, data loading and did data validation on the target servers.
- Verified data loading at staging tables, verify the logs after the data loading, validate the tables at target servers.
- Scheduled jobs and run the process and maintain the application servers, validate the date integrity in the database.
- Validated stored procedure and prepared medium to complex queries for data analysis on the tables.
- Maintained test execution with Quality center and developed defect/executing summary.
- Actively involved in validating and follow up meetings Portal migration issues with developers and vendors. Worked extensively on Data Modeling for the purpose of designing and analyzing data requirements to support the application.
- Provided pre deployment, production and post-deployment support and resolved timely manner.
- Provided various data reports based on the business requirements and work extensively on Main frame (AS400) server on data validation and process verifications.
- Worked closely with developers to understand the functionality and validate the data replication after the data is loaded using ETL informatica.
- Performing Data Quality Analysis to determine cleansing requirements developed detailed Test Plan, Test Cases and executed. Working as Tier2 support & contact for all Web Logic Portal IT issues, working with developing teams for timely resolutions. Follow up with Portal build schedules and alerts.
- Tested various notifications and alerts using Content Management Systems (CMS) also updating content and populating security alerts, notifications.
- Build coordination after test execution, deployed code in QA, and Staging.
- Created medium to complex SQL queries in testing the back end and data validation and extensively used SQL for data integrity testing at the backend.
- Working on pre and post the deployment and production issues and actively involving in UAT testing.
- Support staff in diagnosing problems and reporting bugs and enhancements to development.
- Developed Defect Summary Report and Test Summary Report and documented test results
Environment: HP Quality Center, .Net Framework, Rally, Clear City, Check Box, Share point, Microsoft SQL Server 2012, SQL server Management Studio, Agile methodology, QTP.
Confidential, Houston, TX
Senior QA Tester
Responsibilities:
- Installation Testing on Win7 64 bit systems to ensure compatibility of the software.
- Analyse the Acceptance Criteria developed by the Requirements team to understand the testable and non testable features.
- Create Test cases for different Modules using Test Manager.
- Prepare RTM using Test Manager Feature in Visual Studio 2010/2012.
- Execution of Test cases and monitor the status from the Offshore on the Test Execution.
- Closely working time with Requirements team for understanding the Business Requirements.
- Provide Defect Reports to Development and Management to assess the quality of software from time to time.
- Create Test Plan documents, record and Track Defects, Report to higher Management on the progress of testing.
- Automation of Regression Test Scripts using QTP 11.
- Involved in Developing Test Automation Framework using QTP 11 for automating Regression Test Suites.
- Arrange Bug Triage Meetings with Requirements, Dev team to understand the Bugs identified and providing estimates for new changes.
- Review Test cases created by the Offshore team.
- Demo the features developed to the Product Owners at the end of the Sprint ( 4 weeks duration).
- Create End of the Sprint Reports and Analyse the bug metrics to assess the software quality.
- Function Driven Automation Framework is used for developing Regression Test Suite.
- Developed test scripts for Data Driven tests using QTP. Executed the test scripts and analyzed the results. Enhanced the VB scripts in QTP to include the application business logic.
- Strong working experience on MS SQL Server, Proficient in creating SQL queries and retrieving test data required for Functional Testing.
- Created Automation Scripts using Selenium Web Driver to Automate Regression test cases.
- Experience working in Agile Environment meeting Sprint Deliverables.
- Coordinate with other Technology teams.
Environment: MS SQL Server 2008 R2, Team Foundation Server 2010, MS Visual Studio 2010, Microsoft Test Manager, QTP 11,Selenium,Agile(SCRUM), Selenium.
Confidential, Lafayette, LA
Sr ETL QA Tester
Responsibilities:
- Performed Functional and Regression testing for the functionalities delivered in the QA, UAT and Production environment based on the business requirements in the incremental development environment.
- Analyzed the business requirements and use cases to understand the application and to identify the gaps performed regression testing in QA, UAT and Production environment for the reports in Inventory, Compliance, Licensing, Logging & monitoring modules of the project.Design and execute the test cases on the application as per company standards
- Performed integration testing, system testing, functional testing, Regression testing, Web testing and user acceptance testing.
- Developed requirements traceability matrix between requirements and test cases to ensure maximum coverage of the requirements
- Written Test Cases for compare Source and Target database systems.
- Extensively written test scripts for back-end validations
- Conducted data validation testing.
- Worked in Agile Scrum environment
- Performed smoke test after each and every code drop.
- Performed End-to-End testing after bug fixes and modifications.
- Extensively used windows to validate the backend errors generated during testing.
- Loading Flat file Data into tables.
- Wrote and modified required SQL validation scripts to validate the outputs.
- Performed regression testing once the defects are fixed.
- Generated XML files for testing data transfer from vendors to the client.
- Conducted regression testing on the application under test
- Involved in metrics gathering, analysis and reporting to concerned team
- Conducted review sessions on test case and regression test cases in quality center
- Conducted Bug Review meetings for update on defects from development team and retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
- Performed functional validations and defect tracking/reporting on a customized oil refinery manufacturing process tracking web application and its integration with ETL.
- Assisted developers with Unit Testing and performed Integration and Regression Testing.
- Assisting in creating Full Requirements Traceability Matrix using HP’s QC11
- Coordinating with 3 different development teams on QA’s approach to testing their code releases
- Assisting with day to day functions of all QA team members; delegating and prioritizing tasks
- UAT & Production to verify for any unexpected errors in the reports.
- Working with a core team of Business Users to gain sign-off on Test Cases created and Requirements compiled to date
Environment: SQL, Oracle, SQL Server, XML, Sybase, TOAD, HP Quality Center 11,Agile Scrum, Informatica, Netezza Windows, VB Script.
Confidential, Boston, MA
Senior QA Analyst
Responsibilities:
- Include leading a team of 4 people and closely working with Confidential Plan QA teams to ensure Offshore QA team is in line with expectations.
- Involved in requirements analysis, product customizations with the Product Teams.
- Involved in providing Effort Estimates and Planning.
- Involved in developing functional and performance test plans.
- Testing the transactions of the Health Plan as UB Claim Submission, HCFA 1500 submission.
- Analysing the 270/271 messages generated during an Eligibility & Benefits transaction.
- Simulating the transactions for testing during off time hours for Health Plans.
- Good understanding of HIPAA Rules and knowledge of traversing the EDI messages.
- Used Rally 6.0 for Test Case Management and to analyze the variation between the expected and actual results.
- Executing SQL queries to verify GUI front-end results and to extract and manipulate data to satisfy test cases/requirements.
- Closely worked with the Business and Development Team, to understand the system logic, and issues/defects resolving and closing.
- Automated Test cases using keyword driven framework in QTP 9.2.
- Create Test Plan, Tracking Defects and prepare Reports.
- Experienced in using Soap UI for web services testing.
- Experienced in data migration testing after destructive database upgrade.
- Providing Daily Reports on Status of the Project.
- Experience in closely working with Dev Team to compile Use cases.
- Coordinate UAT testing with Business.
- Created Automation Scripts using Selenium Web Driver to Automate Regression test cases.
- Worked on GUI testing to validate the behavior on multiple browsers.
- Worked on API Testing to validate the Web Services.
Environment: MS SQL Server 2000, IE 6.0, VSS, Silk Radar, Query Analyser, Naviwiki, Rally 6.0, Symphonia 8.2,Agile (SCRUM),Selenium IDE.
Confidential, Denver, CO
QA Tester
Responsibilities:
- Created, maintained, and enhanced automated quality assurance and Testing applications using Microsoft C#, iTextSharp, Microsoft Visual Basic .NET, and SQL Server
- Performed white-box testing of ETL-oriented applications written in C#, Transact-SQL and Visual Basic .NET
- Participated in the design and creation of a testing database using Microsoft SQL Server
- Designed, created, and implemented automated software deploy and install process
- Performed hands on testing for a company that develops automated risk-based loan Orgination application and Loan servicing, processing software for license to community and regional lenders.
- Assessed new project testing requirements, designed testing strategies, planned, scheduled and coordinated resources to insure delivery of error free products in Agile Environment.
- Execution of test cases and result analysis. Bug Tracking and Reporting through TFS bug tracking tool.
- Worked closely with Development teams to support testing strategies and activities. Provided testing estimates based on requirements documents.
- Maintained library of test scripts for re-use across projects and as regression test beds. Reviewed test scenarios for execution to ensure the system specifications are adequately fulfill the business needs.
- Involved in testing Web services and XML with tool called SOAP UI. I have been using this tool to locate WSDL file on internet, create Test cases, run them, do load testing, security testing.
- Involved in the development of the Automation Framework using Test Complete.
- Worked with product support and development to troubleshoot testing issues.
Environment: HP Quality Central, Utilized Agile Scrum, Microsoft Office, Test Complete, TFS 2010, Target Process, Visio, Windows XP, windows 7, SQL Server 2008, J Script, HTML, SOAP UI. and .NET.
Confidential, King Of Prussia, PA
Sr. QA Tester
Responsibilities:
- Understanding the business requirements and developed test cases to test the complete functionality of the application.
- Involved in writing Test Plan, which detailed the testing scope strategy. Hi-level test requirements, and necessary resources.
- Involved in preparing and documenting requirements, Test Plan and Test cases for various applications using HP Quality Center.
- Responsible for writing Unit test, Acceptance test case and Selenium tests
- Involved in functionality testing, regression testing and system testing.
- Performed in intensive Regression Testing with the help of data driven tests in QTP working with data files.
- Performing API/Web Services testing; may also be required to write test harnesses using web services and SOAP technologies.
- Performed GUI check points for GUI objects .
- Test scripts were synchronized and Bitmap Check points, GUI Check, Database check
- Developed automated test scripts for automation testing using QTP.
- Invovled in Testing Web based applications and Web Services (SOAPUI) developed in .Net technology.
- Used Load Runner for stress and performance testing.
- Performed Regression, functionality, System, Interface, front end, back end, negative, black box, positive and User Acceptance Testing using manual testing.
- Tracked the defects during different phases of testing thru Mercury Quality center/TFS
- Prepared Test Data using test scenarios for functional testing as documented in the test plan.
- Responsible for Backend testing and executing SQL queries.
- Performed User Acceptance Testing (UAT).
Environment: ASP.NET, C#, AS400, HTML, JavaScript, Selenium, SharePoint Portal, PHP, Quality Center, SQL SERVER, QTP, SOAPUI, Load Runner, HP Performance Center, HP Quality Center.
Confidential, Reston, VA
QA Analyst
Responsibilities:
- Lead a team of 6 people and responsible for successful test completion
- Participated in Requirement meetings and Detail Design meetings for understand the functional requirements of the application.
- Participate in all the requirement and design walk-thru for effective testing.
- Automated test cases using data driven framework in Win Runner
- Prepare effective test plans to address all the requirements.
- Create detailed test cases/scripts/queries for the assigned scope items in a release, new project
- Wrote the Test Scenarios, Test Cases, and Test Scripts and executed the Scripts successfully.
- Created the BAN users using CSM tool which help in smooth execution of our scripts
- Did the Regression, Integration and System testing.
- Used Quality Center for Test Management and to analyze the variation between the expected and actual results.
- Executing SQL queries to verify GUI front-end results and to extract and manipulate data to satisfy test cases/requirements.
- Closely worked with the Business and Development Team, to understand the system logic, and issues/defects resolving and closing.
Environment: Quality Center 9.0, Oracle 9i, UNIX, HTML, CSM, Windows XP, CVS, Change Synergy.
