QA Manager

Sathvika Allam

Ashburn, VA ***** Cell: 609-***-****

******.****@*****.***

QA Manager

Drive Quality with Effective Project Management, Innovation & Strong Global Teams

Over 13 years of Versatile, results-oriented leader possessing global leadership experience in quality assurance (QA) and quality engineering (QE) & Business Analysis expertise in large enterprise scale applications platforms and global distributed onshore & offshore resources. A Certified SAFe® 5 Scrum Master. Expert in Finance, Banking, Insurance, and Telecom domain applications testing and rich experience in Web, client server, DevOps Engineering applications & platforms. Adept at preparing Test Strategy, Test plans, release planning, Prod Support & management and problem solving. Effective leader building successful distributed onshore and offshore teams and mentor to get up to the project speed. Work closely with the stakeholder teams with effective communication and collaboration. Played an important role in BA and QA roles equally.

Technology and Tools

Databases

Oracle 10g, 11g, MS SQL Server 2008, 2012, 2014, SQL Developer

ETL/BI Tools

Informatica PowerCenter and Microsoft-BI (SSIS, SSRS)

Testing Tools

UFT, QTP, Selenium, Postman

DevOps

ADO (Azure DevOps), Continuation Integration and Deployment (CI/CD)

MS Technology

Office 365, SharePoint, Word, Excel, PowerPoint, MS Project, Exchange, & Visio

Test Management Tool

ADO, HP-ALM Quality Center, TFS, Rational ClearQuest

Operating Systems

Domain

Windows 2000/XP/Vista/7/10, Unix & Linux

Telecom, Banking, Finance, and Insurance

EDUCATION:

Tricentis Certified – Automation Specialist Level1

Scaled Agile – Certified SAFe 5 Scrum Master

Bachelor of Technology from JNTU University, India

Professional Experience

Client: Value Momentum Inc – GEICO, MD and COUNTRY Financial, IL

Duration: March 2016 – Present

Role: QA Manager

Projects: Sales, SSP, TESLA & DMV

Managed a team of size 25 (Offshore and Onshore) and responsible for delivering largescale projects including risk, quality, change management, schedule, and financial management.

Leading a team and coordinating onsite and offshore activities Sales and SSP applications.

Perform initial analysis on the User Stories/JIRA and work with the scrum leads (PO and SM) to analyze the requirements further.

Involved in User story, story point estimation and Prioritizing content for the Sprint.

Actively participate in Sprint Planning/Grooming session to analyze the Bugs/User story and give testers perception in giving the story points.

Managed the release activities such as Requirement Analysis, Test Case execution, defect tracking, reviewing test results, analyzing the failures, coordinating with the stakeholder on defect analysis and signing off on successful testing.

Extensively performing API Testing using Postman for Policy creation in Sales application.

Using JASON and XML collections for creating Request and get the Response.

Create/Modify JASON for testing various positive and Negative scenarios.

Well versed in using various web methods like GET, POST, DELETE and PUT.

Facilitated Team discussion, decision making and conflicts across cross-functional teams.

Been part of SOS meetings and involved in after meet meetings.

Prepared capacity reports to designate work across teams.

Thoroughly reviewed the test plans prepared by the team and conducted walkthrough to make sure 100% test coverage is done for the requirement and responsible for the RTM.

Coordinated the test plan reviews with the customer and actively participated in discussions with analysts and Developers to check if the possible test coverage is done.

Participated in Retrospective meetings after every release and took lead to represent the testing team concerns to the scrum master and product Owner.

Train the new resources to bring them up to the speed of the project, help them in understanding the requirements and preparing the test plan with utmost quality.

Performed Database, Functional, Regression, Integration, System, and end-to-end testing for the Application.

Took the lead to review regression cases with the Regression Review Board, the Chief Product Owner, and SMEs.

Coordinate release and production activities and perform production verification during the production window.

Extensively used SQL Server Management Studio for query execution and wrote complex queries to retrieve data from the Database.

Conducted daily Stand up for the test team and get the status from Onsite and Offshore teams.

Extensively worked on JIRA for JIRA logging for the issues found in different environments.

Used ADO for creating User stories, Tasks, Test Cases, and bugs.

Prepared hardcoded Selenium Scripts for performing smoke tests.

Prepared Daily/Weekly Status Reports and Release Reports and attended weekly meetings with the Managers and the leads.

Took entire responsibility in doing Request for Proposal (RFP) for Insurance client(s) from QA standpoint.

Interacted with the client daily in running the assessment questionnaire, to understand the client needs.

Extensively performed the gap analysis and proposed recommendations per the client business requirement.

Client: Udig LLC- IXI services – A division of Equifax, VA

Duration: July 2015 – Jan 2016

Role: Sr. QA Analyst

Took lead role in implementing QA process and building a team.

Interacted with the top-level management in helping them understand the importance of QA process and setting up test environment.

Worked closely with the product management team, scrum master and the team in identifying scenarios and building requirements.

Participated in daily scrum and stand-up meetings to communicate with the team with work status and progress.

Performed Database, Functional, Regression, Integration, System, and end-to-end testing for the Application.

Extensively used SQL Server Management Studio for query execution and wrote complex queries to retrieve data from the Database.

Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process using SQL Server Integration Services (SSIS 2005, 2008, 2008R2).

Thoroughly validated all the reports generated using SQL Server Reporting Services.

Developed SQL Scripts to validate the database tables for backend testing.

Performed positive and negative testing against requirements and executed SSIS packages to make sure the data files are loaded correctly.

Regularly followed up with the development team to discuss the defects identified during project lifecycle.

Prepared all the Documentation based on Client’s requirement.

Documented all the test results and prepared test summary report based on the test results.

Client: General Dynamics- Federal Energy Regulation Commission, Washington DC

Duration: August 2012 – July 2015

Role: Principal Engineer

Performed Database, Functional, Regression, Integration, System, and end-to-end testing for the Application.

Extensively used SQL Server Management Studio for query execution and wrote complex queries to retrieve data from the Database.

Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process using SQL Server Integration Services (SSIS 2005, 2008, 2008R2).

Developed SQL Scripts to validate the database tables for backend testing and proficient in troubleshooting database issues including critical and high-volume Production issues.

Gathered all the requirements from the Project Manager and Business Analyst to understand the workflow.

Lead a team of five and managed the release activities such as Test Case execution, defect tracking and analyzing the results.

Proactively communicated with the customer for all testing activities and provided them with updated status of the project.

Acted as Subject matter expert (SME) for the end-to-end process of the application.

Attended design meetings and suggested many enhancements to the application.

Prepared test data for different SSIS validation, Database Validations and FileMonServices.

Followed Agile – Scrum testing methodology.

Client: Freddie Mac, Mclean VA

Duration: January 2011 – February 2012

Role: Senior Backend/UAT Tester

Written Complex SQL queries and triggers and extensively used Rapid SQL and SQL Developer for SQL query execution.

Worked extensively on executing the UNIX jobs through Autosys and verified Data stage logs.

Performed backend testing using Oracle /DB2/Sybase databases.

Used Quality Center for creating and executing test cases and Quality Center10.0 for traceability and defect logging.

Executed automated scripts and developed manual testing cases for different modules.

Prepared detailed test strategy, test scenarios, test cases, and test data based on requirements and design documents.

Reported the daily status of test cases executed/failed and documented all the test results as per the company standards.

Client: Verizon Business, VA

Duration: January 2009 – December 2010

Role: QA Tester

Used Quality Center to organize and manage all phases of the software testing process, planning tests, executing automated scripts, and tracking defects.

Extensively tested cross Browser, Cross platform, Usability, Accessibility, and security testing for

all the applications.

Utilized Quick Test Pro to validate links, objects, images, and text on Web pages to check the functionality.

Involved in database testing using TOAD for all the Queries that are associated to the test case scenarios.

Checked the data flow through the front and backend and executed SQL queries to extract data from the database.

Contact this candidate