We provide IT Staff Augmentation Services!

Sr. Quality Analyst Lead Resume

Scottsdale, AZ

EXPERIENCE SUMMARY:

  • Software Professional with 8 years IT experience in analysis, design, development, data integration, Data Warehouse, testing, documentation and implementation of client/server, Intranet, and Internet applications.
  • Performed various roles of a Test Lead, QA analyst, Project coordinator.
  • Strong experience in Developing Business specifications, Test Strategies, Test Plans, Test Conditions, Test Cases, Test Scripts, GAP Analysis, Defect Management, Status Reports, User Acceptance Test Coordination, Test Team Management, Impact Analysis & Risk Escalation and User Manuals.
  • Worked on Manual and Automation testing of various web and Client/Server applications.
  • Experience in performing end - to-end functionality testing for web based, client-server, database, and middleware applications.
  • Experience of the full SDLC Methodologies and Validations to ensure the Quality Assurance Control.
  • Strong experience in Software Development Life Cycle (Agile - Scrum & Waterfall Model) & Software Testing Life Cycle (STLC) and SDET(Software design engineer in Test) and supporting techniques (e.g. Test Driven Development and continuous integration processes).
  • Experienced in understanding the SDET and Hands on experience in SDET (Software design Engineer in Test).
  • Well-acquainted with QA Processes, Software Development Life Cycle (SDLC), Software Testing Life Cycle and Defect Life Cycle, UI automation testing, Web service testing(SOAP,REST) and Hands on experience on SOAP UI.
  • Experience on Mortgage, Health Care, Banking, Insurance and E-Commerce Domains.
  • Expertise in Understanding the Cloud applications and Hands on experience in the Cloud technology.
  • Expertise in performing different types of Testing: Black Box Testing (Functional Testing), White Box testing, System Testing, Integration Testing, Regression Testing, Acceptance Testing, Sanity Testing, Back End Testing, infrastructure testing, GUI Testing and Adhoc Testing.
  • Experienced working with automated testing tools including Quick Test Professional 10.0, Load Runner 9.0, Jira, SharePoint, Selenium, Quality Center 9.2 under Different Environments for various applications adhering to different industry standards.
  • Expert on Selenium Automation using Web Driver. Heavy programming experience using Java.
  • Developed Test Scripts to automate process of testing in Selenium Web driver.
  • Execution of test scripts using Selenium.
  • Developed and maintained automated regression test cases in Selenium Web driver using Java programming language.
  • Visual Studio 2010 supports differentprogramming languagesand allows the code editor and debugger to support (to varying degrees) nearly any programming language, provided a language-specific service exists.
  • Analyzed defects and worked with development team and users to ensure that all defects were resolved.
  • Experience on Oracle ERP Order to Cash (OTC) and Performed in several activities like Customer order is documented, Order is fulfilled or service is scheduled, Order is shipped to customer or service is performed, Invoice is created and sent to customer, Customer sends payment /Collection, Payment is recorded in general ledger
  • Expert in analyzing Business Requirements Specifications(BRS) & User Requirements Specifications
  • Excellent knowledge onRDBMS, Oracle (SQL & PL/SQL), MS SQL Server, MS-Access databases.
  • Capable to work under pressure and with aggressive timelines to deliver quality work on time.
  • Proactively monitor and control task status by collecting and analyzing task data, appropriately communicate, performing multiple tasks and resolves or escalates any problems that arise.
  • Experience in working with offshore teams and coordinating with offshore team for issues, sharing the ideas and solving the problems.
  • Coordinating with the Offshore/Onsite team for resolving issues related to requirements and creating the Test Data.
  • Co-coordinated with Development team and offshore team to work on the day-to-day tasks to meet the timelines for the deliverables.
  • Experienced working with automated testing tools including Quick Test Professional 10.0, Load Runner 9.0, Selenium, Quality Center 9.2 under Different Environments for various applications adhering to different industry standards.
  • In-depth knowledge of testing process and extensive experience in creating automation environment using Quick Test Pro, Test Director, and Quality Center.
  • Manually create, execute and analyze test cases using Quality Center.
  • Experience in documenting the testing process using MS-Office tools including Word, Excel, Power Point and MS-Project.
  • Good Understanding in Web related technology like HTML, JUnit, Python, C#, Oracle BRM, ASP, Groovy, grails, JavaScript, Jenkins, Cobol and SQL and PL/SQL.
  • Written End to End SQL queries for testing.
  • Developed SQL Queries to fetch complex data from different sources, tables in remote databases using joins, database links and kept logs.
  • Hands-on experience in Table Schema validation, referential integrity check, commands of DDL and DML statements. Experience in writing advanced SQLs joins, sub query, dynamic query.
  • Capable to demonstrate a commitment to increase product and test process knowledge and skills in current technical/functional area, keeping up to date on any new technical developments.
  • Able to quickly learn new technologies think creatively and solve problems in a team environment and able to handle the work independently.
  • Good experience in Software Testing includes Effort estimation, Test Planning, Test Design & Execution.
  • Good Knowledge on Database testing using SQL commands. Experience inSQLand PL/SQLon testing Stored Procedures/Data integrity/Data mapping/Data conversion /Interfaces.
  • Creation and maintenance of the Requirements Traceability Matrix for the Test case traceability with project requirements.
  • Hands on experience on Selenium web driver with java and Good experience in writing scripts in selenium web driver.
  • UsedMicrosoft Team Foundation Server(TFS)for integration, maintenance andSecurity of Code
  • Hands on experience on Web service testing and API service testing.
  • Excellent knowledge in Software Testing Levels, Bug Life Cycle and Testing Types.
  • Highly motivated, quick learner, team player with good technical and analytical skills.
  • Have got experience in testing web based applications built on Java technologies across different Browser combinations and windows based applications built on Java.
  • Good experience in Working as Project Test Leadership in different projects.
  • Excellent experience in testing the mitigate risks. Handling the mitigation risks and helping business experts define requirements.
  • Highly motivated, quick learner, team player with good technical and analytical skills
  • Excellent written and oral communication skills.

TECHNICAL SKILLS

Testing Tools: Quality Center, Web Service testing, Selenium Web Driver, Jira, Share Point, Visual Studio 2010, QTP

Programming languages: C, C++, OOPs concepts, Java, C#, phyton, Unix

Platforms: Windows 98/2000/2003/XP.

Database: MS-Access, SQL Server 2012

Web Technologies: HTML, XML, Java Script

Content Management System: Clickability

Other web analytics: Adobe Site Catalyst, Test & Target tools, SQL, TFS

MS Office Tools: MS (Word, Outlook, Excel, Access, PowerPoint).

Methodologies: SDLC, Waterfall Model, Agile model, SCRUM.

PROFESSIONAL EXPERIENCE:

Sr. Quality Analyst Lead

Confidential, Scottsdale, AZ

Responsibility:

  • Gathered business requirements, functional requirements and data specifications from the business analyst’s team and development teams.
  • Extensively worked on Functional, Regression and performance testing.
  • Worked with business teams for gathering business requirements, and also worked with development teams.
  • Attended daily Agile/Scrum stand up meetings.
  • Involved in writing Test plan, Test cases and responsible for executing the Test Scripts and created defects.
  • Involved in Preparing Test Data for various scenarios of functional specifications.
  • Extensively worked on production validation after deployment of code to prod environment.
  • Extensively worked on creating the SQL statements for ETL applications as well as for validating the data.
  • Involved in creating test cases, test data for various business requirements.
  • Tested the output of Statements from sql vs. ETL output.
  • Extensively worked on backend testing for the front end of the application using SQL Queries.
  • Developed SQL Queries to fetch complex data from different sources, tables in remote databases using joins, database links and kept logs.
  • Created DB link scripts and written Queries using DB links.
  • The C# language is intended to be a simple, modern, general-purpose,object-oriented programminglanguage. C# is intended to be suitable for writing applications for both hosted andembedded systems, ranging from the very large that use sophisticatedoperating systems, down to the very small having dedicated functions.
  • Extensively worked with database objects including tables, views, indexes, schemas, stored procedures, functions, and triggers.
  • Although C# applications are intended to be economical with regard to memory andprocessing powerrequirements, the language was not intended to compete directly on performance and size with C or assembly language.
  • Worked on .NET for validating user’s access and data validation.
  • Worked with Explain plan to resolve the performance issues of the ETL queries.
  • Worked with flat, csv files on UNIX environment and worked with ftp, sftp protocols.
  • Involved in white box testing, black box testing for all the projects.
  • Written SQL queries for each business rule and verified the rule logic by executing queries against DB.
  • Performedsecurity testingfor unauthorized access of the Web application with valid and invalid data.
  • Worked in Agile methodology and attended daily stand up meetings.
  • Developed Test Cases based on Functional Specifications and Design Documents.
  • Mentored, Trained team members as SME on different Projects.
  • Experienced working with different legacy systems and files, etc.
  • Extensively used TOAD, SQL developer to create SQL queries.
  • Actively involved in debugging the ETL workflows and Auto sys jobs.
  • Created test data for testing the business logic based on test cases.
  • Proven excellent data analysis skills, total understanding of data flow all the way from legacy sources to the Data Marts.
  • UsedExt Java Scriptwas written for theclient side validation, browser detection and application functions.
  • Extensively UsedAsp.net web controls, master pages, user and custom controls.
  • Performed Unit Testing for all units in developed pages usingJunitTool.
  • Code review as per the standard andtestingapplication.
  • UsedMicrosoft Team Foundation Server(TFS)for integration, maintenance andSecurity of Code
  • Written complex sql queries for validating the data.
  • Created Automation test cases and test scripts using informatica DVO tool and sql scripts.
  • Created defects in HP Quality center and assigned the defects to developers.
  • Experience in working with offshore teams and coordinating with offshore team for issues, sharing the ideas and solving the problems.
  • Co-coordinated with Development team and offshore team to work on the day-to-day tasks to meet the timelines for the deliverables.
  • Performed code migrations as part of weekly/Monthly Change request releases.
  • Determined appropriate action by referencing defined operating policies and procedures and using proven approaches.
  • Worked on UNIX environment with files, running scripts on back end, etc.
  • Statistics were gathered for the identified tables to improve the performance of the objects and also run times of the jobs were monitored.
  • Involved in production validation of data.

Environment: Quality Center, Jira SME, Selenium web Driver, Agile, Visual studio 2010, black box testing and white box testing SOAP UI, REST, QTP, Java scripting, Share point, C#, SQL, Web Services testing, MS Excel, MS Word, Web service testing(SOAP,REST), IE 6.0/7.0, Firefox, Jenkins, Adobe Site Catalyst, Java, Test & Target tools, Windows NT, Windows 2000.

Confidential

QA Analyst

Responsibilities:

  • Involved in Business requirements review with Business Analysts, Modelers, developers and end users.
  • Worked with Business Intelligence, Business and third party teams on a day to day basis.
  • Attended daily Agile/Scrum stand up meetings.
  • Created Master Test plan, Test Strategy, Test cases and review documents.
  • Developed Manual, Automated test cases to cover all the quality risks identified as needing extensive or balanced testing.
  • Created test data for each business requirement within existing cases or new test cases to cover critical customer usage profiles, customer data to known defects in our application.
  • Used exploratory testing methods in areas that were not addressed previously and that appear due to test results.
  • Performed the browser compatibility testing for employee stock portal (IE9, Firefox, Safari, Google chrome).
  • Worked on Regression testing for mapping document/req changes from source to target systems.
  • Used DVO tool extensively for automation testing of ETL Loads.
  • Created defects, test plans and test cases in Quality Center.
  • Tested data validation from ESB systems.
  • Attended Defect Triage meetings for resolving the issues.
  • Assisted Business Intelligence team for validating the data against the generated reports.
  • Created test case for each business requirement from mapping document.
  • Worked on Integration testing with other systems and teams and collaborated with them.
  • Test reports and results were sent to team end of every day and on weekly basis to the team.
  • Conducted meetings with developers and business analysts for unresolved issues and escalated them to higher management for quick resolution.
  • Written End to End SQL queries for testing.
  • Developed SQL Queries to fetch complex data from different sources, tables in remote databases using joins, database links and kept logs.
  • Created DB links and written scripts for validating the data between source and target systems.
  • Worked with User acceptance testing with business users and application users and created the test cases to verify the scenarios.
  • Written and executed complex SQL queries for testing and validating the data for each business requirement.
  • Worked with third party application vendors for Integration testing.
  • Tested report output in UI, PDF, Excel, and Text.
  • Worked on Oracle, SQL server and Netezza DB environments and worked on data analysis and created defects for not failed test results.
  • Worked on monthly reports, daily reports data.
  • Experience in working with offshore teams and coordinating with offshore team for issues, sharing the ideas and solving the problems.
  • Co-coordinated with Development team and offshore team to work on the day-to-day tasks to meet the timelines for the deliverables.
  • Tested .NET applications and validated data from users end on applications.
  • Worked with Informatica power center components (Designer, wf manager and wf monitor) extensively for running and doing white box testing.
  • Worked on UNIX environment for transferring files, killing jobs, etc.
  • Reviewing the Test Reports and Preparing Test Summary Report.
  • Performed functional, compatibility and regression testing, Sanity testing.
  • Participated in identifying the Test scenarios and designing the Test cases.
  • Prepared and Executed Test Cases as per System Requirements.
  • Developed and maintained automated regression test cases in Selenium Web driver using Java programming language.
  • Performed various black box testing Methodologies Like functional and Regression Testing.
  • Defect tracking and Reporting.
  • The data verification has been done from DB end and application end.Some more Roles and responsibilities related to working on manual testing.
  • Understanding business requirements.
  • Performed functional, compatibility and regression testing, Sanity testing.
  • Participated in identifying the Test scenarios and designing the Test cases.
  • Prepared and Executed Test Cases as per System Requirements.
  • Performed various black box testing Methodologies Like functional and Regression Testing.
  • Defect tracking and Reporting.

Environment: Quality Center, Jira SME, Selenium web Driver, Visual studio 2010, Agile, black box testing and white box testing SOAP UI, REST, QTP, Java scripting, Share point, SQL, Web Services MS Excel, MS Word, Web service testing(SOAP,REST), IE 6.0/7.0, Firefox, Adobe Site Catalyst, Java, Test & Target tools, Windows NT, Windows 2000.

Software Quality Assurance Role

Confidential, California

Role and Responsibilities

  • Worked in Agile software development model and involved in daily meetings with program managers, modelers, product owners, developers, etc.
  • Worked as project lead for projects and allocated tasks to team members and coordinated with other teams and perform multiple tasks.
  • Extensively worked on OLTP and OLAP modeling techniques and analyzed the data from different source systems.
  • Created Test strategy, test plans, executed test cases, test cycles against the Dimensions and Facts on the Data warehouse.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Created test strategy based on requirements from product owner.
  • Developed test cases and test scripts against the mapping, session logic and jobs in technical as well as business terminology.
  • Extensively worked on snowflake and star schema models.
  • Written SQL queries to be tested against Dimensions and Facts.
  • Created defects in HP Quality center.
  • Developed mappings based on business requirements.
  • Validated the data from dims and facts against the created reports and dashboards.
  • Assisted Business Intelligence team for validating the data against the generated reports.
  • Evaluated the user requests for new or modified process and developed specifications to them.
  • Worked with various teams to load data into the data warehouse/data mart and identify potential problem areas in the source and target systems.
  • Expertise in mapping and tracing data from system to system in order to solve a given business or system problem.
  • Worked on Data integration projects testing, writing SQL queries to test the output. Used PL/SQL as well as MS SQL Server.
  • Coordinated with end users to perform UAT and obtain sign off.
  • Expertise in analyzing the data based on subject matter and on requirements.
  • Created defects, Reported Defects and tracked them to closure using Jira and logger.
  • Involved in testing the workflows and jobs from informatica and Data Stage with respect to the business logic in parallel and the defects were verified.
  • Extensively worked in Regression testing.
  • Written UNIX shell scripts, worked extensively with ftp and sftp process.
  • Worked with source and target files from the file servers and verified them at UNIX file server.
  • Verified the output of files processed (success/failures).
  • Trained less experienced testers.
  • Involved in scrum meetings, status meeting and business user meetings.
  • Tested thenavigationand theUser Interfacefor ease of use.
  • PerformedGUIandfunctionalitytesting.
  • Involved inRegression Testingand User Acceptance Testing(UAT).
  • PerformedCross-Browsertesting on Internet Explorer and Netscape Navigator.
  • Expertise in testing the code in multiple environments at a time.
  • Performed testing on user defined persistent variables and parameters for the workflows.
  • Provided assistance to new users with installation and monitoring of the process.
  • Involved on various test cycles like Unit, Integration, System and User acceptance testing. Assisted several professionals for fixing the bugs.
  • Involved in performance tuning testing of the SQL, workflows and testing the event wait, command and email tasks.
  • Suggestions were provided to the team upon testing of the objects and make sure the standards are met.
  • Analyzed project and design specifications to test .NET software applications.
  • Prepared testing technical documentations at both program level and user level.
  • Verified coding standards defined by Company.
  • Co-coordinated with Development team and offshore team to work on the day-to-day tasks to meet the timelines for the deliverables.
  • Tested applications for .NET and verified data on applications.
  • Reviewed Test Plans and Defect logs written by the business testers.
  • Expertise in testing CDC (change data capture) process and Golden Gate Application process.
  • Developed and maintained documents to comply with internal and external audits (SOX compliance).
  • Created checklists for QA process and used share point to upload.
  • Adhered to the company policies in implementing the process.
  • Extensively worked on automation testing using Informatica DVO automate tool.
  • Written several SQL statements. Tested the output of Statements from sql vs. ETL output.
  • Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Worked on compliance projects. Submitted results from the tested programs to end user for approval and the raised questions were answered.
  • Worked with off-shore team for daily status meetings and project co-ordination.
  • Worked on UNIX environment extensively used file transfer, ftp and sftp process.
  • Extensively worked with Informatica, Oracle, SQL server, Golden Gate and UNIX environments.
  • Written documents to describe program development, logic, coding and corrections.
  • Analyzed reviews and altered programs to increase the operating efficiency or to adapt new requirements.
  • Attended Informatica User Group meetings and exposed to new tools and processes.
  • Identified potential database performance problems and resolved system-wide performance issues.

Environment: Quality Center, Jira SME, Selenium web Driver, Agile, Visual studio 2010, black box testing and white box testing SOAP UI, REST, QTP, Java scripting, Share point, SQL, Web Services MS Excel, MS Word, Web service testing(SOAP,REST), IE 6.0/7.0, Firefox, Adobe Site Catalyst, Java, Test & Target tools, Windows NT, Windows 2000.

Confidential

senior Quality Assurance Analyst

Responsibility:

  • Responsible for gathering the updated requirements.
  • Performedbusinessprocess mapping for change requests and new requirements.
  • Created the Test plan, Test Scenarios, Test cases.
  • Created Test Data based on Requirement specifications
  • Prepared usability test plans and reports based on usability tests performed.
  • Involved in regular project review meetings & Testing Status Meetings and sending Test Report to Project Manager and Project Team
  • Extensively used Quality Center for executing, maintain test cases and defects.
  • Analyze Functional Requirements and Business Requirement Documents to get a better understanding of the system on both functional and business perspectives.
  • Maintaining the Defect Log. Training the team and providing them KT on the application and tool if any CR’s are raised.
  • Involved in Monitoring and tracking the resolution of defects
  • Participated in Project Meetings & Conducting Knowledge Sharing Sessions and Training to fellow team members.
  • Executing the test cases and authoring the test scripts for the Adhoc bugs that are encountered
  • Retesting the application for new build, performed Compatibility testing and user acceptance testing.
  • Involved in monitoring and analyzing the Quality assurance metrics.
  • Performed browser compatibility testing.
  • Responsible for regular project review meetings & Testing Status Meetings and sending Test Report to Project Manager and Project Team
  • Involved in Conducting research into project-related issues and products
  • Prepared a detailed project understanding document for future reference.
  • Responsible for regular project review meetings & Testing Status Meetings and sending Test Report to Project Manager and Project Team.

Environment: Quality Center, Agile, MS Excel, MS Word, IE 6.0/7.0, Firefox, Adobe Site Catalyst, Test & Target tools, Windows NT, Windows 2000, Jira.

Confidential

Responsibility:

  • Prepared Test Plan, Test Scenarios and Test Scripts as per functional, Business requirements using Quality center, developed the Test Procedures and Test Cases using Software specifications document.
  • Participated in BRD walkthroughs along with Business System Analysts, development team.
  • Developed Use Cases and work flow diagrams.
  • Involved in high-paced agile development environment and worked closely with internal groups such as Product Management, Client services and Software development to deliver high quality sprint releases.
  • Performed test preparation and test execution tasks.
  • Escalated the issues about the User Stories and Acceptance Criteria.
  • Involved in testing web services.
  • Prepared usability test plans and reports based on usability tests performed.
  • Involved in regular project review meetings & Testing Status Meetings and sending Test Report to Project Manager and Project Team
  • Analyze the user requirements by interacting with system architect, developers, Business Analyst and Client.
  • Estimation of new Test requirements and efforts.
  • Preparation of Test Management Reports and expertise in preparation of Regression Plan and Regression Summary Report
  • Analyze Functional Requirement and Business Requirement Documents to get a better understanding of the system on both functional and business perspectives.
  • Executing the test cases and authoring the test scripts for the Ad-hoc bugs that are encountered.
  • As a Subject Matter Expert (SME) give presentations to the team members on new functionalities in the application.
  • Retesting the application for new build, performed Compatibility testing and user acceptance testing.
  • Team Management - Worked in Scrum methodology, providing quick estimates and scheduling tasks, delivering reports, providing KT to team.
  • Involved in End to end testing and test management for the e-commerce transformation.

Environment: Quality Center, Agile, MS Excel, MS Word, IE 6.0/7.0, Firefox, Adobe Site Catalyst, Test & Target tools, Windows NT, Windows 2000, Jira.