Ashwini Kalagotla

Cell: 206-***-****

Email: acwmjj@r.postjobfree.com

Qualifications Summary

•Over 8.5 years of professional IT experience as a QA Tester, Content Tester and QA Analyst roles in Health, Banking, Airlines, Insurance, Retail and Educational Domains.

•Extensive experience in software quality assurance testing on Client-Server and Web-based applications.

•Proficient with the Manual Testing and Automated testing.

•Expertise on all phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) ranging from requirements gathering to User Acceptance Testing, Defects Logging and Tracking till closure.

•Experience in Preparing Test Plan, Test Strategy, Test scenarios, Test cases and Test Data for Functional Testing and UAT

•Experience in analysing business specification documents, developing and execution Test plans, Test cases/scripts, Test Summary reports for Manual and Automation testing.

•Proficient in Validation, Functional Testing, Performance Testing, Integration Testing, Regression Testing, User Acceptance Testing(UAT), GUI Testing, and Cross Browser testing.

•Experience in Preparing Test Data.

•Full understanding of SQA, SQC, Waterfall and Agile SCRUM Methodologies.

•Effectively communicate defect management process during software testing and generate reports based on the test results using bug tracking tools like Quality Centre, Rally.

•Good understanding of ETL testing principles and Data warehouse concepts.

•Experience working in Agile and Scrum Environment.

•Hands on experience in developing test automation scripts using Quick Test Professional for regression and GUI functional testing.

•Extensively used SQL Queries for backend testing.

•Experience in PL/SQL, DML and DDL, writing Complex SQL and Testing scripts for Backend Testing.

•Familiar with testing web services using SOAPUI.

•Ability to work individually and as well as in a team by interacting with developers and business analyst regarding testing status and defect tracking.

•Experience in UNIX, Linux and Windows Operating System.

•Experience of working with Customers, Delivery Managers, Project Managers and Technical Teams for securing & executing concurrent projects.

•Have strong work ethic, taking ownership of all duties and responsibilities and Excellent oral and written communication skills with strong problem solving skills and a result oriented attitude.

•Keen attention to detail/accuracy and ability to function in a stressful environment.

•Ability to learn new technologies and adapt to new skills at quick pace.

Certifications

•ISTQB Certification

Technical Skills

Web Technology

HTML, XML, SOAP WSDL, Web Services, Web Logic, Web Sphere

Databases

SQL, Oracle

Testing Tools

Test director, Quality Centre, HP ALM 11.0, QTP 11.5, Win Runner, Load Runner, Soap UI, Selenium

Languages

C, HTML, XML,SQL,PL/SQL

Project methodologies

SDLC, STLC, Agile - Scrum

Operating Systems

Windows 2003/ R2/ 2008/windows7,vista,XP, UNIX, Linux

Defect Management Tools

Mercury Quality Centre (QC), Rally, Jira, TFS(Team Foundation Server), HP ALM

Utilities/Others

MS-Word, MS-Excel, MS- Access

Professional experience

New York State Department of Health – Albany, NY Apr 2015–Present

QA Analyst

Responsibilities:

•Prepared Test Strategy, Release Test Plan documenting testing approach accordance with QMC standards and analysed testing timelines.

•Prepared and executed test cases manually based Funtional Use Case and UI Migration Documents, identifying application’s functionality, test requirements and coverage

•Worked in the capacity of QA Lead role position and single-handedly performed all QA activities.

•Worked on two application migration projects.

•Responsible for As-is to As-is testing of the iTrak web-application migrated from IBM Web Sphere to IBM Web Logic.

•Performed Role Based Manual testing using different User roles on migrated iTrak application to ensure same functionality as of the old platform.

•Primarily responsible for testing the UI of the external DB systems( Final Actions, Expert Physicians & OPMC lookup, DOH Hearing cases) migrated from Lotus Notes to Oracle.

•Worked with team members to define test objectives.

•Through out the project conducted Functional, Cross Browser, UAT and Regression testing.

•Worked closely with the business team/customer in documenting various UAT scenarios, executing test cases, providing test data and troubleshoot issues during UAT phase

•Performed Manual testing on migrated external DB systems to ensure same functionality as of the old platform.

•Highly involved in meetings with Business Management Teams & JAD Sessions with End Users(OPMC) to understand their business Processes in the context of Lotus Notes DB external systems usage.

•Extensively involved in writing test cases, execution of test cases, reporting and documenting the test results using Quality Centre (QC)/ALM and Redmine.

•Managed defects using QC and Redmine.

•Executed simple queries for testing External Systems database applications in Oracle.

•Prepared status summary reports with details of executed, passed and failed test cases.

•Performed Stress Testing manually using Cluster Environment.

•Attended daily SCRUM Meetings to provide the status of the work.

•Participated in Weekly status meetings and test closure review meetings.

•Assisted BA in preparing data dictionary and mockups and kept track of new requirements.

•Worked with all stakeholders as and when required in regard to the QA effort.

•Conducted User Acceptance Testing along with the business owners.

Environment: Lotus Notes, Oracle SQL Developer, Redmine, File net, Java, SQL server 2000, SQL 2008, SQL 2012, QC/ ALM 11.0, Web Logic, Web Sphere

Citi Bank July 2014–March 2015

QA Analyst

Responsibilities:

Performed some manual testing procedures.

Data validation with manual testing procedures at the back end.

Performed back-end testing procedures using SQL statements to verify data integrity for some online customer interactions.

Involved in implementing and monitoring UAT and Production test environments.

Performed Security Testing and Regression Testing.

Was involved in Functionality Testing and GUI Testing.

Followed the SDLC in testing process.

Evaluated software test requirements for web application integration while delivering new/modified enhancements.

Involved in preparation of the essential groundwork for testing.

Ensured adequate testing of the release prior to implementation.

Cooperated and performed with development group to resolve the difficulties came across in a test execution.

Contributed in regular status meetings to state any bugs, problems and risks.

Maintained a standardized QA process to curb production risks and quality defects.

Used Quality Center tool for defect reporting and tracking.

Conducted Daily Defects status and Progress meetings with the help of QA Metrics.

Environment: Windows XP, MS Excel, Quality Center, QTP, MS Project Professional, Oracle, MS Access, PL-SQL

Blue Cross Blue Shield of Michigan Jan 2014 – June 2014

QA Analyst

Responsibilities:

Prepared Test Strategy and Test Plan documenting testing approach, testing environment and testing timelines

Prepared and executed test cases manually based on BRD, Technical Specifications, Functional Design and Use Case documents, identifying application’s functionality, test requirements and coverage

Investigated software faults and worked closely with the development team to resolve technical issues during SIT phase

Worked closely with the business team/customer in documenting various UAT scenarios, executing test cases, providing test data and troubleshoot issues during UAT phase

Generated and executed functional and regression test scripts using QTP as part of automated testing

Assisted performance tester in generating and executed performance test scripts using Load Runner

Prepared RTM document to ensure that all requirements had sufficient coverage for thorough testing and identified requirements and test cases to be automated

Involved in project planning, coordination and implemented QA methodology

Created technology evaluation matrices to provide best-fit solutions to customers

Coordinated with various teams about the defects that were found during SIT/UAT phases on a daily basis

Performed Defect Tracking using QC.

Environment: Quality Center, QTP, UNIX, Java, HTML, Oracle8i

US Airways March 2013 – Dec 2013

QA Analyst

Responsibilities:

•Analysed Business Requirements Documents (BRD) to prepare the detailed Test Plan and Test cases.

•Prepared the test strategy and planning document, test cases and test procedures for testing the application under Test.

•Managed the entire QA efforts, including manual and automation, of an application in Agile Methodology – SCRUM environment.

•Participated in Sprint Planning and Sprint meeting. Also attended story grooming meetings and estimated those user stories.

•Participated in review of Test Plan and assisted QA lead in updating the test plan

•Preparing Automation Test cases based on Functional Requirement Specifications and executing the prepared QTP Script.

•Created Test cases and test scripts (in QTP) based on the requirement passenger transaction module, enrolment process, travel and payment process.

•Created Standard, Image, page, Text/Text Area, Bitmap, Database, checkpoints in Quick Test Pro script for validations.

•Responsible for functional and regression testing.

•Added verification steps to tests and managed objects in the Object Repository.

•Used the Object Spy tool to learn the properties/methods of the object under test.

•Imported and exported data from and to Excel to and from QTP.

•Used Parameterization in Global and Local Data Tables QTP extensively to perform Data-Driven testing

•Performed Integration testing to check the flow of application.

•Performed User acceptance testing in the final phase of software development process to check the functionality of the software.

•Used SQL Queries to verify the data from the Oracle database.

•Written Both Positive and Negative Test Cases.

•Tracked the defects using Quality Centre.

•Preparing smoke test and regression test suites for every new Build on monthly basis.

•Creating member Firms and content pages with the Promos in the Author Site and checking in the Publish Mode Site.

•Tested the application on different browsers as a part of compatibility testing to maintain cross-browser functionality.

•Responsible for testing various applications in coordination with the offshore & onsite team for work related and other issues.

•Created daily, weekly and monthly status reports and defect reports to capture testing progress for every release and regression suites.

•Scheduled the tests for execution and then did monitor, measure, control and report on the test progress, the product quality status and the test results, adapting the test plan.

•Communicated the status in daily Scrum meetings.

•Involved in updating the execution dashboard and build report for each build.

•Guide and mentor the junior team members in resolving their technical issues.

Environment: Oracle 9i, J2EE, JavaScript, UNIX/Windows 2008, SQL Server, Quick Test Professional 11.5, QC.

JC Penney Company – Plano, TX Dec 2011 – Feb 2013

POS Tester

Responsibilities:

Involved in regression and user acceptance testing of JC Penney Point of Sales applications for stores and kiosks.

Actively participated in requirement gathering and Test Plan review meetings.

Implemented defect management process and test case templates using HP ALM 11.0. Worked on defect life cycle management process.

Involved in ecommerce testing of JCP.com for assortment, purchasing and shipping modules.

Involved in jcp.com app on Libby (IPOD) for regression testing after each modification and new enhancements. Reviewed and analysed executed test results with business analysts

Tested web applications in Waterfall and Agile development process.

Built automated test scripts using QTP for JCP.com and POS regression testing.

Tested system upgrades for JC Penney store workstations migrating from SQL server 2000 to SQL server 2008. Implemented SQL queries for test verification and to validate data in various databases.

Tested the workstation and register upgrades from Windows XP to Windows 7

Tested reporting tools for sales audit, loss prevention, cash room and electronic journal.

Involved in quality assurance of business rules engine for store and online returns, store gift card purchases and Sephora gift cards.

Tested POS software updates and new releases on Epicor and NCR

Performed Load testing and stress tesing of JC Penny website using Load runner.

Modified and maintained the existing test scripts in QTP to cover existing and new functionality.

Tested Centralized Salon Capabilities and associate scheduling application.

Environment: HP ALM 11.0, QTP, SQL Server 2008, VB Script, Windows 7, Load Runner

Wachovia Bank, Charlotte, NC Jan 2011 – Nov 2011

QA Tester

Responsibilities:

•Developed detailed Test Plans and Test Cases in Mercury Quality Centre and executed them.

•Analysed business processes and participated in Requirements gathering sessions. Fully understood Use-Cases and Requirements for creating test cases.

•Maintained requirements and traceability with test cases in QC.

•Performed GUI, Functional, System-Integration and Regression testing.

•Extensively used SQL for data integrity testing at the backend.

•Investigated Software defects and interacted with Analysts to resolve technical issues. Performed extensive data analysis.

•Analysed functional specifications for enhancement of existing functionality.

•Extensively worked on QC for bug tracking/reporting.

•Conducted Smoke testing on new versions. Trouble shooted network problems in the testing environment.

•Responsible for System Testing, Regression and User Acceptance Testing. Tested User Interface and application functionality.

•Recommended continuous process improvement, maintained QA standards and artifacts.

Environment: Windows 2008, IVR Systems, ASP, HTML, SQL Server, MS-Word, Ms-Excel, MS-Project, QC.

Company Name: MRCC Nov 2006 – Nov 2009

Test Engineer, Content Tester, UAT

Project: MWS Math project

Client: Houghton Mifflin

Responsibilities:

Worked on Maple soft 10.07

Requirements understanding

Create and program all question components using Maple Authoring Tool

Author new step-by-step components using Maple authoring Tool

Perform quality assurance – Including accuracy checking, copyediting, and proofreading.

Perform Content testing, Functional testing, Integration testing, Systems testing

and compatibility testing

Create and upload defects in excel

Re-testing and Regression testing

Deploy questions in preview environment for content acceptance testing by HM

Perform project management – Status reports to be submitted at least weekly, required to participate in weekly status meetings

Helped other team members in Execution of the project during their critical dead lines

Prepared a static data document which can be used during execution by everyone to reduce the problems faced because of static data

Cross Training other teams on Math Content Testing

Training New joiners on Product & System

Performed extensive Manual Testing on Client Server and Web based Applications.

Actively interacted with the development team in resolving Bugs identified from testing Ability.

Environment: C, Maple Authoring Tool

Educational Qualifications

Bachelor of Engineering (B.Tech) degree in Electronics and Instrumentation

Bhoj Reddy College of Engineering for women, Hyderabad, JNTU University

Contact this candidate