Srila Ramagiri

ad3g8u@r.postjobfree.com

Professional Summary:

** ***** ** ** ********** in Software Quality Assurance and Quality Control

Proficient in functional, regression, system integration (SIT), User acceptance (UAT), load/performance, security, browser compatibility, and performance testing.

Extensive experience in Agile, Kanban and waterfall methodologies

Experience in SDLC and STLC.

Extensive experience in Web testing, Database testing and Browser testing.

Excellent knowledge and working experience in with Test planning, Test execution and Test results analysis.

Experience Systems Analysis, Testing of various Client/Server and Internet/Web applications.

Experience in Manual Testing and writing Test Cases, and Test Plans.

Experience in Test Automation using Tools like QTP, Win Runner Selenium and Quality Center.

Experience in design and implementation of automation frameworks (keyword driven frame work) using QTP (VB script)

Performed SQL Server Administration tasks like Backup, Restore and creation of SQL scripts development using Stored procedures, Tables, Views, Triggers and Query Tuning and Data Migration.

Knowledge in automated testing tools WinRunner, QTP, Load Runner.

Experience in developing reports using Crystal Reports and generation of reports using SQL 2000/2005 Reporting services well-acquainted with the Software Development Life Cycle (SDLC).

Worked with large databases.

Extensively used SQL queries to manipulate the data

Hands on version control tool like VSS.

Experience using HP tools ALM/Performance center.

Experience in Mercury quality center.

Experience with Test Quest, HPQC, Rational CQ and Jira.

Experince in Jira, Rally, Bugzilla

Experienced in converting the Business Requirements into Technical Specifications for testing the application.

Excellent team player with problem-solving and trouble-shooting capabilities.

Excellent analytical, inter-personal, communication, written skills and customer interaction skills.

Technical Skills:

Databases : MS SQL Server 2000/2005, Oracle, DB2 and MS Access

Testing Tools : WinRunner, QTP, Load Runner Selenium, Version one, Rally,Appium

Defect Tracking : Quality Centre, Clear Quest

Languages : C#, Visual Basic.Net, C, C++, Java, COBOL T-SQL, PL/SQL

Web Technologies : ASP.NET, ADO.NET, XML, XSL, HTML, Java Script

Operating Systems : Windows’ 98/NT/2000/XP/2003

Web Servers : IIS 5.0/6.0

Version Controls : MS Visual Source Safe

Reporting Tools : Crystal Reports, Microsoft SQL Server 2000/2005 Reporting Services

Professional Experience:

Santander Consumer USA -Dallas, TX April 2020 to Present

Lead Quality Engineer

Santander Consumer USA is a full-service, technology-driven consumer Auto finance company focused on vehicle finance and unsecured consumer lending products.

MySup - The My Supervisor application is our Collections/Customer Service application that is accessed by thousands of people each week. Ensured program/project teams are following Software Quality standards and processes. Fine tuned specific processes to meet the needs of individual projects while adhering to Enterprise Quality objectives. Testing this application is vital to the overall success of the company. To access this application the user must be set up in SHAW and have a SHAW id Adding a security profile on Maintenance Manager and changing security levels.

Responsibilities:

Participated in the development and implementation of procedures for maintaining and or enhancing the integrity of Santander’s system application.

Ensured that requirements are clearly defined and testable. Responsible for the creation and execution of detailed test plans and scripts and the existence of development and service standards.

Verified software functionality and adherence to business requirements.

Executed scripts including reporting, defect tracking and risk assessments.

Responded and resolved issues beyond standard management requests as well as using independent judgment to make decisions where no clear precedents exist.

Led and reported on the QA Analysts’ testing strategy

Data Manipulation and Data intergration with Scheduler Tool ControlM

Ensured that delivery timelines are met by developing high quality test scripts and leveraging testing strategies to ensure changes are built/deployed without defects.

Designed end to end and UAT test scenarios around business requirements

Tested Iphones and android operating systems and applications.

Tested across multiple operating systems technical and detail-focused

Ensured product quality, working on mobile devices, i.e. smartphones, tablets and smartwatches

Tested apps across numerous screen resolutions, operating system versions, and distinct network bandwidths.

Ensured that the software under test conforms to the specified functionality.

Applied testing experience to validate complex .Net and Web applications

Manage the creation and execution of the manual testing program

Managed Product Requirements, enabling Traceability aross the Development process to reduce ccylke Times with JAMA

Managed Application Lifecycle management solution in Jira

Performed testing on multiple projects in a fast paced environment.

Performs other duties and special projects as assigned

Assisted in other related departments as required by business needs Working Conditions

Extended working hours as required by management and business needs.

Environment: Jira, Selenium, SQL, FDR, Control - M, MS Outlook, Mainframes, Citrix, .Net.

Achievements:

Increased overall Product quality by 10% through the implementation of new Testing Procedures

Reduced Product defects by 15% by identifying and addressing issues during the Testing processes.

BCBS, TX Oct 2015 to March 2019

Sr. Quality Assurance Analyst

NGEN is a cross enterprise program that provides the structure needed to execute on our expanding priorities focused on the individual consumer and retail marketplace.. HCSC Next Generation is an extensive effort across HCSC and its subsidiaries to revamp our retail (individual) business to meet the changing needs of our customers, position us as a leader in the future retail market and help the company fulfill our purpose.Provides HCSC with a retail mindset and help adapt to a variety of insurance exchanges private, state or federal.

BAM Blue Access for Members was redesigned to improve usability and increase utilization. The process used in the BAM redesign had four stages:

The usable solutions group (USG) conducted a heuristic (expert) analysis on the existing BAM site and identified inconsistencies in Web content and usability standards.

This stage is ongoing. Quarterly usability tests are done on the site as well as when new features are added.

Responsibilities:

Developed Test Cases and Test Scripts in Quality Center for testing the applications.

Maintained test traceability matrix(Mapped requirements to test cases and failures

Tested the Members/Provider in Member Provider/NPI.

Conducted Regression, Functional and System Testing.

Wide Scenario Testing with UAT team with test case reviews, triage and defect management for Member Claims,Authorizations, Enrollment, member and provider portals

Identified defects, retested defects using QC/ALM during various phases of testing.

Ran various 270, 276 files in Jmeter and validated the required loops and elements of 271, 277 responses.

Worked as part of Agile Team and participated in daily scrum meetings to provide day to day updates

Identified & analyzed test cases for various testing phases in functional, integration, UAT and smoke testing

Worked with ANSI X12/EDI 5010 Transactions (270, 271, 276 and 277) Functional Acknowledgement and Transactions (TA1, 999, 277CA, 997) & interfaces.

Created ANSI X12/EDI 5010 transactions, Processed them via EDIFECS spec builder for format and validated the EDI transactions.

Created and executed various end to end Test scenarios of healthcare products and services, variations of health insurance products, state of the art health plans associated with Medicare, Medicaid & Commercial LOB as used in the United States

Tested the Validation of claims data from HIPAA Repository.

Validated HIPAA Transactions and maintained HL7 Standards.

Involved in Testing Various Claims like 837,835, 270,271.

Extensively involved in doing data Validation using SQL, PL/SQL and using TOAD.

Developed Test Summary Reports and participated in meetings

Actively participated in all phases of testing lifecycle.

Reviewed Functional Specifications and Unit Test Designs and attended for Formal Walk Through meetings.

Participated in all Status Calls, Release Management Calls, Test Case Review meetings and Sign-Off meetings.

Bank of America, Plano, TX Jan 2013 to Sep 2015

Sr QA Analyst

Reporting and analytics is summary level reporting of Mortgage Operations QC and QA processes; to maintain monthly reporting of Key Risk Indicators reported in Business Control routines to provide ongoing reporting, query development support for the QC of Mortgage Operations; . There are operational, regulatory, process and reputational risks that need to be considered and weighed to manage the overall risk exposure.

Responsibilities:

• Experience in reviewing functional and design specifications to ensure full understanding and delivery of testing project deliverables

• Experience in understanding and identifying test data needed for testing and writing quality positive and negative test cases.

• Experience in hands on functional testing, systems integration testing, regression testing.

• Expertise with XML, SOAP based Web Services and Backend database testing in Microsoft SQL environment including validating stored procedures, jobs and triggers.

• Identify test requirements from specifications, map test case requirements and design test coverage plan.

• Develop, document and maintain Test Plans, functional test cases and other test artifacts including test data and automated scripts.

• Execute and evaluate manual or automated test cases and report test results.

• Hold and facilitate test plan and test case reviews with cross-functional team members.

• Ability to execute test cases in a timely manner, analyze test results, identify defects and experience in defect lifecycle.

• Very Good communication skills and an ability to participate in defect triage calls to explain defects to development teams and escalate as necessary.

• Ensure that validated deliverables meet functional and design specifications and requirements.

• Experience testing BATCH - mainframe, distributed and middleware (services) technologies and integrated applications and large scale E2E activities for multiple teams

• Worked with onshore / offshore model.

• Worked on the software development and QA life cycle processes (including test planning, test case design, execution, defect tracking and reporting)

• Strong knowledge of tools such as HP ALM/Quality Center, JIRA, Rally

• Hands on working experience in Automation and Web services testing

• Prior experience implementing process improvements in support of testing or software development such as risk based testing

• Excellent written and verbal skills interact across all levels from junior members to senior management

• Create and execute SQL scripts to extract test data and analyze it (ETL) that are uploaded into relational databases

• Trained/coached/mentored junior resources and interacted with Senior management.

• Adapted, flexible and comfortable working in a matrix environment as a Sr. team member and an individual contributor

Environment: IBM Lotus Notes 8.5, Blue star, Member Provider/NPI, Blue chip, Edifices Spec builder, AS400, SoapUI, Agile Methodology, MS Office tools, QC/ALM 11 and Clear Quest.

JP Morgan Chase Oct 2010 to Dec 2012

QA Lead

The software under test is a Web Based Clients apps named ‘agent Desktop’ (which is the Underwriter’s tool for JP Morgan Chase Bank Loan Modifications) and, ‘remediation’ tool. Rules testing based on CFPB (Consumer Financial Protection Bureau) Federal Regulations for various Investor types such as, Bank Owned, Fannie Mae, Freddie Mac, and Securitized Loans. Waterfall Workflows tested for HAMP and Chase ‘Making Home Affordable’ Plans. The software is written in Main frames (COBOL).

Responsibilities:

Develop and execute Tests for all new code pushed to the applications. The testing includes UAT, regression, and system end-to-end.

Coordinating Offshore Team to mentor and assign work based on Project Requirement

Mentor Junior QA and Planning Project from Initial Phase

Reviews functional specifications, Impact Matrices and Test Cases to understand the functional and technical requirements in order to test the application and verify requirements are successfully met.

Conducts test strategy, scenario reviews and test plan walkthroughs. Works with development teams to insure test coverage for all functionality.

Work in conjunction with the business analysis and development teams to ensure that applications meet requirement and are of high quality SQL Queries for data base Testing

Tested application on Mobile Handsets like Android, iOS while Testing of the chat conversations, Send Receive Picture messages, MMS, sending sms from the chat, calling from the conversation.

Performed compatibility testing with various mobile handsets to ensure that functionality works fine.

Experience on LTE, 3G, and 2G network for performance of the device.

Tested wireless protocol middleware and system and application level software

Supported Production deployments, Monitor and track high Priority defects and Production Issues on day-to-day basis Tested the application on various generation of Android and I phone.

Design test procedures, maintenance procedures abd configurations. Creates test strategies for application release. Executes test scripts and documents defects for test scripts where the actual results do not successfully meet expected results.Usage of Oracle SQL for Test Data analysis in several Databases and Schemas.

Responsible for using Agile Methodology.

Studied the business requirements, created detailed Test Cases in HP ALM associated them with the appropriate requirements.

Identified the initial setup, input data, appropriate steps and the expected responses in the manually test cases.

Manually tested the user interface to verify the functionality of various features.

Used Mainframe IBM tool MSP (Mortgage Servicing Platform) to verify Loan Conditioning.

Responsible for testing LIV (Loan Image Viewer) tool for viewing different documents of the customers like Cap sheet, Invoice, Lender Correspondence etc.

Involved in testing different loans for HAMP (Home affordability Modification Program), FNMA (Federal National Mortgage Association) and FHA.

Developed SQL Queries to query the database to test the back end process of the application

Performed the Back-End testing to ensure data consistency on front-end by writing and executing SQL queries.

Performed manual testing for the entire application by executing the test scripts.

Performed regression testing of the application manually.

Performed end to end testing with help of MQ for message transport.

Created test plan, test cases and test condition matrix for feature testing.

Developed and executed manual test scripts using test plan and test lab sections of HP ALM 11.0/Quality Center for System testing, Integration testing and Regression testing of the application.

Used HP ALM 11.0/Quality Center for test plan execution and defect tracking.

Data validation from end to end.

Establishing test strategy and planning for Integration, System and User Acceptance Testing (UAT).

Tested application under different networks and Internet speeds including on Edge,3G,4G, LTE & Wi-Fi

Thorough Knowledge of Mobile Platforms such as iOS

Created SQL scripts to change data and validate service response.

Environment: Jira, Rally,HP ALM 11.0/Quality Center, Mainframes, LIV,

AT&T Mobility, TX April 2009 to Sep 2010

QA Tester

AT&T Mobility is the largest Wireless Company in the United States, with more than 50 million subscribers. Performed end to end testing in Telegence, Combined Billing, EMI Regression, Bill validations, UEA testing. Worked on PDC2, OPUS, Phoenix, System-X which are Web-enabled activation systems remote dealers use to activate service and maintain equipment information for AT&T customers. Also worked on EMO, Premier, OLAM and Telco (AT&T Landline)

Responsibilities:

Design and execute Test plan and strategy

Perform requirements verification, test plan walkthroughs, test case walkthroughs, test case creation, regression testing, functional testing integration testing, defect creation.

Testing SIDs as per the business requirements. Account setup, adding new Price Plans, produce bills and send to core teams for approvals.

End to End testing including creating new accounts, adding different Rate Plans, FANs, Combine Billing, running MPS&MAF, End of Day jobs and Billing

Performed System testing, Regression testing, and UAT testing.

Created different types of voice and Data usage(Domestic, Roaming International, Tear Data) for the subscribers.

EMI Regression testing and transmitting inv, adj, fyi and txt files to Telco for validations

Issues were reported in Jack Track

Created Test Cases and executed in Mercury Quality Center.

Environment: UNIX, SQL, Test Director/Quality Center, Load Runner, Telegence, Amdocs Billing, PDC2.

Education:

Bachelor in Computer Science

Certification

SAFE Agile Certification

Business Analysis Skills

QA Principles

Contact this candidate