QA Lead

NARSING RAO

Email id: *************@*****.***

Mobile: 980-***-****

Senior QA Analyst/QA Lead with around 12+ years of experience in the field of Software Testing with good exposure in Quality Assurance and Automation Testing. Working knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC), Quality Assurance including Agile/Scrum and Waterfall methodologies.

PROFILE SUMMARY

12+ years of progressive experience in Information Technology with emphasis on leading Automation and Manual testing teams, Quality Assurance, Manual Testing, Automated Testing, System Testing on Web and Client/Server based applications.

Solid experience Leading a team and in developing Test Strategy, comprising Test Plan, Test Scenarios, Test Scripts, Testing Methodology and Test Reports.

Expertise in Manual and Automation Testing of Client/Server, Mobile, Web - based, API, Jenkins, Azure, AWS DevOps Cloud applications.

Configure and manage web apps deployments in Azure cloud.

Experience with the Cloud (Azure) DevOps - Infrastructure and Platform as a service.

Expertise in understanding Business Requirement Specifications, Functional Specifications and Design documentations and converting them into Test Scenarios.

Experience in Waterfall and Agile Projects, worked very closely with Product owners in Agile and attended different ceremonies like Sprint Planning meeting, Scrum, Backlog grooming, Sprint Review and Retrospective

Proven ability in designing and creating automation frameworks using Java, Selenium WebDriver, Junit, TestNG, Appium, Maven, Jenkins tools.

Experience of Creating, Modifying and Maintaining new and existing Automation Framework Models (BDD/TDD/ATDD, Hybrid, Keyword and Data Driven Frameworks).

Tested and Automated API’s/Restful Services developed Java and Rest Assured java libraries

Expertise on Testing REST API using Robot Framework and SOAP UI

Strong knowledge in web services testing via Tool SOAP UI/ Restful web services

Working with Unit Test Frameworks like TestNG, Junit.

Experience in implementing the Page Object Model (POM) by creating element for each page object and reused all the objects in various scripts.

Experience in testing Web Services-SOA architecture, XML transactions, SOAP, HTTP, WSDL, and REST using various tools like SOAP UI/Ready API and selenium.

Experience in backend Database testing writing and executing SQL queries and other database operations with databases like SQL Server and Oracle.

Performed Database/Backend testing by writing complex SQL Queries for data validation and integrity, good at writing complex Joins and knowledge in PL/SQL

Experience include Unit testing, Functional testing, User Acceptance Testing, Integration testing, System testing, browser compatibility testing & Security testing of client/server and Web base Applications.

Expertise in using various defect-reporting and defect-tracking tools like JIRA, Rally, Bugzilla, and HP ALM.

Co ordinating between the Stakeholders and (Onsite / Offshore model).

Possess good communication skills, analytical skills, self-motivated, pro-active, task oriented, good team player, and quick learner at new technologies and systems.

TECHNICAL SKILLS

Testing Tools

Selenium Web driver, Appium, Quick Test Professional HP QTP 10.0, UFT, Rest Assured, Postman, JMeter, Load Runner

Methodologies

Agile /Scrum, Waterfall, SDLC

Frameworks

Page Object Model (POM), Keyword Driven, Data Driven, Hybrid, Junit, TestNG, TDD/BDD.

Test Management / Bug Tracking Tools

HP Quality Center, HP ALM, Test Director, Rally, Bugzilla, JIRA, ClearQuest, Issue Tracker

Code Version Control

SVN, GIT, GITHUB

CI/CD

Jenkins, Hudson

Build tools

Maven, Ant

Programming Languages

C, C++, Java, .NET, SQL, VB script

Databases

MS Access, MS SQL Server 2000/ 2005/ 2008, MSDE, Oracle, My SQL, Oracle, Mongo DB, Teradata(v13), Netezza.

Operating System

MS Windows 9x/ 2000/ XP, MS DOS, UNIX

MS Office tools

Outlook, Word, Excel, PowerPoint.

ETL Tools

Informatica Power Center 7.x/8.x,9. x.

Domain Knowledge

Insurance, Retail, E-Commerce, Banking, Mortgage, and Healthcare

WORK EXPERIENCE

BHG, Bankers Healthcare Group - Florida, Feb,’20 to till date

Role: QA Consultant.

Description: BHG is specialized in providing Business Loans, Personal Loans, SBA and Startup Loans. BHG is now with a new name BHG Money, same commitment to service, and still dedicated to helping you accomplish more – professionals and professionally. BNH Money was founded in 2001 to provide financing for the unique needs of professionals. As the company has grown from three to over 1,000 employees, BHG Money has remained committed to providing professionals a better lending experience. Loan size and interest rates vary and are determined by applicant's credit profile and certain other information provided in loan application. Monthly payment is not guaranteed and is only an estimate. BHG bases payment amounts on various factors in addition to applicant income and fico. Loan products advertised through BHG payment calculator, and the payment provided to customers feature rate quotes of no greater than 29.04% APR with terms up to 144 months and include $2,995 documentation fee. Your actual rate, APR, terms and monthly payment could be higher or lower depending upon your credit score, loan amount, loan term, and credit usage, history and other information provided in loan application. Optional fees are not included in payment estimate. Monthly payment, APR, fees and other loan details vary by customers’ individual profiles.

Roles and Responsibilities:

As a technically focused QA Consultant in the Credit Assessment and Origination (CAO) Services team, I will be participating in various software implementation projects by aiding our clients for the configuration and implementation of our Commercial and Corporate Loan Origination software solutions. Possessing both functional and technical capabilities, I will be assisting in performing project tasks such as:

Working closely with the client and internal teams to solution implementation activities

Design the Test Plan for every Sprint gather the requirements from the meetings and prepare Test Cases.

Develop Automation framework and automated tests using Selenium WebDriver using Java for Continuous regression testing and reducing manual testing using Selenium, TestNG and Maven.

Providing estimates for testing effort to senior management for each release and sprint.

Create functional scenarios for the requirements under test each sprint.

Creating and Developing test scripts for all functional, GUI and data verification for each functionality.

Providing support to the automation team and providing them with business - critical scenarios to automate as well and helping them with regression scenario execution.

Daily Status reports to all the stakeholders and keeping them apprise on any blocking issues

Managed test cases, defects in JIRA.

Designed and documented REST/HTTP, SOAP APIs, including JSON data formats and API versioning strategy.

Follow Agile testing methodology, participated in daily Scrum meetings and tested each Sprint deliverables.

Use JIRA for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Attend triage meetings to understand and consider the scope changes for the release during the test execution phase.

Update of weekly and daily status to stakeholders and co coordinating with onsite leads and offshore team.

Participate in daily standup meeting (Scrum) and Sprint Planning Agile methodology.

Create and executes test cases, log and assign defects and keep track of the defect status

Mentor QA team and help them in their daily job responsibilities.

Testing of workflow process-related aspects of the software

Providing Production support with quick response time.

Environment: Selenium, .Net, REST API, JSON, Postman, MS SQL Server, SQL, JIRA, Manual.

State Auto Insurance, Columbus, Ohio Feb ’19 – Nov,’20

Role: QA Lead

Description: Guidewire (Claim center) is a web-based enterprise software application designed to manage the process of reporting, verifying, and making payments on claims against a policy. It manages the claims process from first notice of loss (FNOL) through execution of financial transactions, including the payments and setting of reserves. Claim center functionality includes Group-based ownership of claims and claims sub objects: This allows for assignment of objects to users based on the group they are in, as well as user access to an object based on who owns the object. Claim maturity, which is a set of rules that automatically manage the claim’s maturity level: Particular attention is paid to whether the claim can be paid out or not and whether activities are prevented if the claim is not yet payable. Claim financials, which manage the finances that surround a claim: This includes setting aside money for expected payments(reserves), issuing payments (checks), tracking recovery opportunities, and requiring approval for financial activity more than a given users authority. Portal - Customer Digital Self-Service is a project to create a digital interface that can be used by State Auto customers for the purpose of viewing and obtaining information about a previously reported claim. This system will be accessed through a customer portal and employ Claim Center, Guidewire integrations to provide key claim status information to the customer. The expectation is that this interface is scalable and can be accessed from any electronic device (desktop computer, laptop computer, tablet or phone). Portal - Customer Digital Self-Service is a project to create a digital interface that can be used by State Auto customers for the purpose of viewing and obtaining information about a previously reported claim.

Roles and Responsibilities:

Design the Test Plan for every Sprint gather the requirements from the meetings and prepare Test Cases.

Develop framework from scratch and automated tests using Selenium WebDriver using Java for Continuous regression testing and reducing manual testing using Selenium, TestNG and Maven.

Providing estimates for testing effort to senior management for each release and sprint.

Create functional scenarios for the requirements under test each sprint.

Creating and Developing test scripts for all functional, GUI and data verification for each functionality.

Providing support to the automation team and providing them with business - critical scenarios to automate as well and helping them with regression scenario execution.

Daily Status reports to all the stakeholders and keeping them apprise on any blocking issues

Managed test cases, defects in Quality center / ALM

Designed and documented REST/HTTP, SOAP APIs, including JSON data formats and API versioning strategy.

Follow Agile testing methodology, participated in daily Scrum meetings and tested each Sprint deliverables.

Use JIRA for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Attend triage meetings to understand and consider the scope changes for the release during the test execution phase.

Update of weekly and daily status to stakeholders and co coordinating with onsite leads and offshore team.

Participate in daily standup meeting (Scrum) and Sprint Planning Agile methodology.

Create and executes test cases, log and assign defects and keep track of the defect status

Mentor QA team and help them in their daily job responsibilities.

Environment: Selenium WebDriver, Java, Eclipse, Maven, Jenkins, REST API, JavaScript, JSON, Postman, MS SQL Server, SQL, JIRA, Manual.

Williams-Sonoma, Inc., San Francisco, CA Nov’ 15 to May’ 18

Role: QA Lead

Williams-Sonoma, Inc. (WSI) is a specialty retailer of home furnishings in the United States and Canada. The company was founded in 1957 by Chuck Williams and markets its brands through 3 channels “Retail Stores, Catalos, and the Internet. In addition to the original (primarily cooking oriented) Williams-Sonoma line of business, the business also encompasses: WILLIAMS- SONOMA, Inc. is a multi-channel specialty retailer of high-quality products for the home. Williams-Sonoma, Inc., is an American publicly traded consumer retail company that sells kitchenware and home furnishings. The process starts from SKU’s i.e., Inventory management, Purchase Order maintenance, Sterling Order Management OMS, tracking the orders Warehouse Management System. Testing the mobile applications using Appium in IOS and Android platforms.

Roles and Responsibilities:

Analyzed and reviewed the software requirements, functional specifications and design documents.

Interacted with the project development team to understand the project requirement and derive the test plan.

Helping functional testing team to understand Sterling OMS functionalities and preparing test plan accordingly.

Design the test strategy, test plan, and write test cases and test results for Sterling OMS. Including unit testing, end-to-end testing and UAT.

Work with business and technical Subject Matter Experts for validation and verification of functional specifications and business end-to-end requirements.

Ensure requirement traceability documents are created and demonstrate appropriate test coverage.

Involved in designing the framework from scratch using Selenium Web driver and Java.

Responsible for planning, designing, building reusable and scalable automation frameworks for various Web applications.

Involved form Inventory Management, Order Process Management, and Datawarehouse for the entire project.

Prepare Design documents according to requirements and estimation

Implemented order management capabilities like Ship-to-home ship-from-store ship-to-store pickup in store reverse logistics. Experience of working closely with customers to help influence and guide their decisions."

Preparing Upgrade and migration plan which includes upgrade of Sterling OMS, DB upgrade, WebLogic upgrade.

Helping functional testing team to understand Sterling OMS functionalities and preparing test plan accordingly.

Work with the Business and project team to understand test requirements.

Used Selenium WebDriver APIs for writing TestNG test suites and test cases for testing functionality.

Extensively worked in Regression testing using Selenium Web driver in TestNG.

Implemented BDD through Cucumber.

Created the Feature Files for Cucumber Automation framework with Cucumber and Selenium WebDriver.

Configured Cucumber Report Plugin and Performance Plugin to Jenkins to generate html test reports.

Monitor test execution status through log4j and maintain Code versions through GIT.

Bug Reporting and Tracking through JIRA.

Created and executed JMeter scripts for performance testing of portal

Responsible for transferring the knowledge about the use of test framework to developers and manual testers.

Hands on Experience on Test cases, Automated Tests and Test Data and expertise in reviews of various Testing Documents.

Environment: Java, Selenium Web driver, Cucumber, Gherkin, Maven, Jenkins, TestNG, GitHub, APPIUM, Rest Assured, JMeter, JIRA, Oracle, Sterling OMS, Tibco, Windows 7.

Ally Bank, Charlotte, NC Aug ’14 - Nov’ 15

Role: Senior QA Engineer

Project: Ally Bank (Retail Banking and Mobile Application)

Description: Ally Bank is a Core Banking application, application deals with creation of Account, Funds Transfer. Ally Financial has many ways to help you manage your finances through online banking and auto financing. Ally Bank is a subsidiary of Ally Financial Inc. Member FDIC. Today, Ally Financial is a leading automotive financial services company powered by a top online banking franchise. Our emphasis is the same today as it was nearly 100 years ago – provide best-in-class service and comprehensive, innovative, and unmatched product offerings to our customers. Ally Bank is a Core Banking application, application deals with creation of various Accounts like online, CD’s, Money Market, Savings and Checking and IRA’s, Funds Transfer. When user chooses Ally Bank, they get simple convenient access to their accounts with online banking and mobile apps, award winning 24/7 customer care and the most important feature you expect from a bank.

Roles and Responsibilities:

Design the requirements and test strategy in line with the scope and organization standards.

Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs

Create the software test plan, get it reviewed and approved / signed-off by the relevant stakeholders.

Involved in decision making of converting manual test cases into automated test scripts and analyzing their lifetime and time required to update the scripts.

Expertise in writing the Selenium Web driver in C# using the MS Test framework.

Used HP Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Updating of weekly and daily status to stake management and co coordinating with the onsite leads and offshore team.

Participated in daily standup meeting (Scrum) and Sprint Planning Agile methodology.

Create the test schedule tasks, dependencies and assigned team members.

Identify the training requirements of the software test engineers.

Identify any test metrics to be gathered.

Communicate with the client or on site/offshore team members, as required.

Review the test cases and test data generated by the software test engineers and get them to address the review comments.

Track the new/ updated requirements in the project and modify testing artifacts accordingly.

Managing resources effectively, working with the team and to ensure that allocated tasks are completed on time.

Created test scripts referring to the requirement and tracked the trace-ability matrix; created and prepared test cases during test plan and got approval from all stakeholders

Participated in walk-through/ requirements review meetings to ensure that requirements are clear, complete, precise, and detailed enough to test

Environment: .NET (C#), MS SQL Server 2008, HP UFT, Selenium, C#, Mobile testing, SQL, HP QC ALM, Manual, Azure.

FHA, Washington, DC

Role: QA Engineer Jul’13 to Jul’14

Description: Federal Housing Administration (FHA) and Department of Veterans Affairs (VA) loans are popular homebuyer choices. FHA has different modules like Loan Search, Document Tracking, MDL Tracker, Under Writing etc. Underwriting is the downstream application where underwriter validates the document submitted by the borrower provides various alternates or work around and sends it to FHA. There is a nightly batch which runs in FHA process the data from underwriting and moves the loans to FHA or rejects them these loans are again sent to Underwriting for any missing document or more.

Roles and Responsibilities:

Make sure the data is transformed correctly.

Ensure that ETL application rejects and replaces with the default values and reports invalid data.

Need to ensure that the data loaded in the data warehouse within prescribed and expected time frames to confirm scalability and performance.

Without any data loss and truncation projected data should be loaded into the data ware-house

Developed ETL programs using Informatica to implement the business requirements

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

All methods should have appropriate unit tests regardless of visibility.

To ensure their effectiveness all unit tests should use appropriate coverage techniques.

Work with data conditioning team to get the data for the test scripts

Create unit tests that target exceptions.

Hands-on experience in test execution and defect management tools (HP Quality Center/ALM) and handle the things independently.

Execution of scripts and report any defects, work closely with App and Dev, SA for closing the defect.

Identified problems in existing production data and developed one-time scripts to correct them.

Fixed the invalid mappings and troubleshoot the technical problems of the database

Effectively worked on Onsite and Offshore work model.

Environment: .NET (C#), MS SQL Server 2008, Informatica Power Center, ETL, SQL and Manual, HP Quality Center/ ALM

Harleysville Insurance, Harleysville, PA May’10 to Jul’13

Role: Test Analyst / QA Engineer III

Description: Harleysville is a member of the Nationwide family of companies and a leading regional provider of insurance products and services for small and mid-sized businesses, as well as for individuals, and ranks among the top 60 US (property & Casualty) insurance groups. Policy Center supports the entire policy lifecycle for personal, commercial, and workers' compensation insurance. ... It is a complete system of record and supports the core functions of the policy lifecycle, including product definition, underwriting, quoting, binding, endorsements, and renewals lifecycle for personal, commercial, and workers' compensation insurance. ... It is a complete system of record and supports the core functions of the policy lifecycle, including product definition, underwriting, quoting, binding, endorsements, and renewals. Guidewire (Claim center) is a web-based enterprise software application designed to manage the process of reporting, verifying, and making payments on claims against a policy. It manages the claims process from first notice of loss (FNOL) through execution of financial transactions, including the payments and setting of reserves. Claim center functionality includes: Group-based ownership of claims and claims sub objects: This allows for assignment of objects to users based on the group they are in, as well as user access to an object based on who owns the object. Claim maturity, which is a set of rules that automatically manage the claim’s maturity level: Particular attention is paid to whether the claim can be paid out or not and whether activities are prevented if the claim is not yet payable. Claim financial s, which manage the finances that surround a claim: This includes setting aside money for expected payments(reserves), issuing payments (checks), tracking recovery opportunities, and requiring approval for financial activity in excess of a given users authority.

Roles and Responsibilities:

Participated in walk through/ requirements review meetings to ensure that requirements are clear, complete, precise, and detailed enough to test

Worked alongside with Business and Development teams to understand requirements, and to determine scope of testing

Worked on various QTP Automation tools QTP using VB Scripting and descriptive programming

Worked on hybrid framework using QTP 10.0 using VB scripting and descripting programming

Developed and executed QTP scripts and run the batch execution.

Developed Test Plans based on Functional specifications of the application

Performed manual testing that involved web testing which covered testing the application functionality, User Interface, compatibility, and usability

Created and executed test scripts for Functional and Regression testing

Involved in the Quality of the system being developed by giving feedback to the Developers on bug fixes and modifications required

Ensured that functionality, as defined in requirements, is the intended behavior of the product after the defects were fixed

Reported bugs in Quality Center and assigned to concerned developers

Participated in daily standup meeting (Scrum) and Sprint Planning

Environment: .NET (C#), MS SQL Server 2008, QTP 10.0, Manual, Test Link, Rally, Team Web Access, Project Office, QC, MS Test Manager 2010, Guidewire Policy Center, Claim Center, Billing Center.

ExceliCare: Glasgow Royal Infirmary Hospital -Glasgow, UK

Role: Software Test Engineer Jan’07 to Apr’10

Description: ExceliCare is a product suite aimed to automate patient care in hospital environment and Electronic Patient Record (EPR) management system that enables clinicians in U.K to manage patient details and other records efficiently. Clinician’s store and share clinical data and images for later review and discussion across and disciplines with the greatest of ease. Seamless integration of telemedicine technologies with an electronic patient record ensures coherence of clinical, enabling users to record patient data at source. ExceliCare in turn can be designed as a virtual doctor. ExceliCare was adjusted and awarded the best software in terms of reliability and user friendliness in UK for the year 2002-2003.

Roles and Responsibilities:

Written Test Plans, which detailed the testing scope, strategy, hi-level test requirements, and necessary resources

SOAP testing

Testing the DICOM images, HL7 message format and Patient monitoring systems.

Actively participated in ISO 9001-2000 and ISO 13485-2003 Certification for medical devices.

Prepared all the documents for testing process like Test Plan, Test Cases, RTM, Test Closure report, Test Summary Report, CCB meeting report for the ISO 13485 certification.

Identified Beta Sites, Beta site deployment, and maintenance

Install the software on Beta sites and validating the software.

Reported and tracked Bugs status

Responsible for defect analysis and reporting to Project Manager

Closely worked with developers and System Engineers to nail down the technical problems.

Environment: .NET, MS SQL Server 2000, MSDE, SQL Express 2005, Manual, SOAP UI, JIRA, MS Windows 2000/ XP/ Server 2003

Education:

M Sc CS: Master’s in computer science, Osmania University, 2004.

B SC (CSE): Bachelor’s in computer science and Engineering, Osmania University, 1999.

Contact this candidate