Sushma Thotakura Sr. QA Analyst/Tester

214-***-**** adin4p@r.postjobfree.com

Summary

●Over 14 years of extensive and diversified experience in Information Technology with emphasis on Quality Assurance of Web, Client/Server applications.

●Expertise includes Manual testing process, Black Box Testing and Automated testing in various domains like Railways, HealthCare, Financial and Insurance.

●Expertise in Software Development Life Cycle process (SDLC), Quality Assurance Life Cycle (QALC) and QA Methodologies.

●Competence in writing and executing Test Cases and Test Scripts based on the Baseline Requirement and Design documents.

●Automating manual scripts using Quick Test Pro (QTP) and well-versed in using Quality Center, Test Director, MKS for test management and defect reporting.

●Expertise in analyzing business specifications and developing Test Cases and Test Scripts and executing them.

●Expertise in various types of testing including GUI, User Acceptance (UAT), Integration, Functional, Regression, Compatibility and End-to-End testing.

●Writing and executing Test Cases (both positive and negative scenarios) for System and Security testing.

●Database querying and data manipulation using SQL and involved in back-end testing as well as front-end testing.

●Strong problem-solving skills and able to adapt new technologies as needed in a rapidly changing IT environment.

●Excellent analytical skills coupled with good communication and inter-personal skills and a committed team player.

●Used Oracle, Gemfire and SQL Server and DB2 databases.

●Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center and SSIS ETL tools

●

Technical Skills

Databases: Oracle 8i/9i/10g, MS SQL, DB2, SQL Server 2000/2005

Methodologies: Waterfall, Agile/Scrum

Defect Tracking Tools: HP Quality Centre 9.2/9.0/8.2

Data Access Tools: TOAD, Oracle SQL Developer, SOAP/REST UI 5.2.1

ETL Tool: Informatica PowerCenter,SSIS

Reporting Tool: QLikView

Programming Languages: Java and SQL

Version Control Tool: Rational Clear Case, Win CVS

Operating Systems: MS DOS, Win 98/2000/XP, UNIX, Linux

Professional Experience

Client: Southwest airlines, Dallas, TX

Tester/Sr.QA Analyst/Test Lead/Business Analyst (Sep 2015 – Mar 2020)

Southwest Airlines is a major United States-based airline, operating an extensive international and domestic network. Played a major role in conducting manual, regression and ad-hoc testing including security testing on OS ODS, an application which handles traffic of various flight operations.

Responsibilities:

●Gather and thorough walkthrough of business requirements and prototypes with Business Analysts, Code reviews with development team and got a good grasp of requirements, functionality of the airline system Worked on identifying and filling gaps in test coverage in core product.

●Developed Test plans by coordinating with other team members on the road map

●Developed Test cases by reviewing the requirement documents.

●Mapped the test scripts to the functional requirements in Quality Center.

●Worked closely with Technical Project Managers and Development Team in defect tracking, re-testing and validation.

●Develop Test strategy, test plan/design,execute test cases and defect management for the ETL & BI systems.

●Worked on the automated Selenium scripts and modified the scripts when necessary.

●Airlines data exchange between different carriers thru EDI, verified the logs if it kicks back.

●Attending daily standup meetings to track defects and report status from the Scrum teams.

●Report discrepancies and analyze them to determine the root causes. Evaluate script failures at a high level.

●Verified bug fixes and tested all impacted modules in application.

●Coordinating with other team members and providing status to project manager.

●Created UAT documentation to be used by users.

●Executed and modified Selenium Web Driver automated test cases for regression test cases.

●Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests for various phases of this application

●Execution of Manual Test scripts and responsible to track and log the defects using QC.

●Used SQL queries for Backend testing and Frontend Data validations.

●Created complex SQL queries to validate various reports.

●Involved in integration testing, to ensure data flows across multiple applications.

●Create and validate XMLs from XSDs in XMLSPY based on the architecture of a particular service & bridge queue.

●Tested SSIS packages according to business requirements and data mapping requirement documents.

●Managing both direct implementation and offshore implementation teams.

●Dealing with project management while sharing housekeeping on many internal test lead responsibilities, test activities and monitor compliance and applicability of test standards.

●Participated in project management meetings, monitor progress and review any kind of documents, decision making for our testing office & update status.

●Conducted training sessions for the team to adapt to the change in technologies and adopt new applications

●Ensured team experienced a healthy Team Culture where all team members received the required training, experience and nurturing they need to perform their individual tasks efficiently.

●Partner with other team members to provide advice/solutions with QMO’s reach.

●Reviewed Business and Functional Requirements and analyzed them from User’s perspective to replicate real-time situations.

Environment/Tools: Oracle, J2EE, Java, JSP, Web Services, SOAP UI, Oracle Quality Center, MS Office, SQL Server, SSIS

Client: BNSF Railway, Fort Worth, TX

QA Analyst/Tester (April 2011 – May 2015)

BNSF operates one of the largest freight railroad networks in North America, with 32500 miles of rail across the western two-thirds of the United States.

Rail carries more than 40 percent of our nation's freight, and transport touches nearly every individual in all walks of life: grain, soybeans, lumber, steel, plastic, ethanol, coal and more. We do this while reducing emissions, saving fuel and relieving highway congestion.

Responsibilities:

●Extensively worked on Switch Planner and Terminal Planner a yard planning tool that helps the Yardmasters and Trainmasters to virtually plan inventory, manage the status of yard tracks and execute the in- yard switches in a single screen.

●Developed Test Cases, Test Plan, Test Strategy and Traceability Matrix based on design requirements.

●Involved in defining test objectives for the applications and performed Manual Testing.

●Worked with test JCL on mainframes.

●Performed Smoke and Sanity testing, Functional Testing, Web Testing, Performance Testing, Back end Testing, UAT, Regression Testing, System Integration testing and end to end testing.

●Managed the defect management using Application Lifecycle management QC Tool.

●Extensively worked on SQL for back end testing on DB2.

●Interacted with cross-functional teams. Worked closely with Business Analysts, System Analysts, and Developers etc. to track down the requirements.

●Developing the testable requirements from technical specification, identifying interdependencies and maintaining test scripts using Mercury Quality Center/Test Director/ Rational Manual tester etc.

●Wrote Test scripts for Regression testing.

●Involved in design review meetings, Test case peer review, Team meetings.

●Extensively tested all web applications to check the compatibility in IE and Chrome.

Environment/Tools: DB2, MKS Integrity, Excel, Quality Center 9.2, SQL, Batch processing, Agile, MS-Windows.

Highland Campus Health Group, Irving, TX

QA Analyst/Tester (Aug 2009 – Mar 2011)

HCHG is one of the leading medical billing services provider healthcare and related services organizations, providing a full spectrum medical billing management services. The application is a web based application and it helps the HCHG members and its clients manage and view billing activities and decision support tools.

Responsibilities:

●Prepared test cases, scripts based upon the business requirements documentation (BRD), use case documentations, and functional requirements specification (FRS).

●Performed manual testing of the application

●Performed Smoke and Sanity testing, Functional Testing, Web Testing, Performance Testing, Back end Testing, UAT, Regression Testing, System Integration testing and end to end testing.

●Mapped system requirements with Test Cases. Manually executed test cases in QC. Ensured traceability of Test Cases back to the Business Requirements using Quality Center. Prepared RTM for the application.

●Utilized TOAD, SQL tool for querying and analysis of Oracle databases.

●Extensively performed backend testing on databases by writing complex SQL queries.

●Point of contact for the client data testing, data accuracy and accuracy of functionality.

●Developed high level documentation of Test Cases and test data to test GUI, Security, Performance and functional requirements of the application.

●Data mining using SQL and provide the test data for different test conditions.

●Defects were identified, provided documentation to the development team for debugging.

●Tested Patient Aging Reports based on Entry or bill date.

●Validated the EDI reports at the middle tier-Mckenson and verified the logs for the kicked off records.

●Tested several complex reports including Dashboards, Summary Reports, Master Detailed, Drill down.

●Performed Regression testing of the fixed issues in the new build until no new issues are identified.

●Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings.

●Submitted Final Test Report; required documentation for the project within assigned time frame.

●Involved in getting final signoffs from Test Manager and Business.

●Gather API Testing requirements, estimate, review LISA automation scripts

●Validate services using SOAPUI and LISA by testing XML request and response data

Environment/Tools: SQL Server 2005, Quality Center 9.2,QTP, XML files, Remedy, VB Script, Java Script Flat files, SQL, Batch processing, Agile, MS-Windows.

JPMorgan Chase

QA Analyst (Jan 2008 – July 2009)

Description: JPMorgan Retirement Plan Services is a division of Asset & Wealth Management. Specifically, concentrate on retirement plans and support both defined contribution plans (such as 401(k) and profit sharing plans) and defined benefit plans (such as pension and cash balance plans).

Responsibilities:

●Understanding the requirements from the functional document

●Drafted Test plan which included testing objectives, testing phases, scenarios and Test environment after a thorough analysis of the business rules.

●Updated Test Plans and Test Cases periodically any changes in requirements.

●Involved in Level Of Effort (LOE) for the testing efforts like Test case Preparation, Test data, Test Execution.

●Smoke testing was performed for each and every build that came out.

●Actively participated in Test Review Meetings and Defect Triage Meetings.

●Test Activities included Functional testing, GUI testing, Integration testing, Regression testing, System Testing.

●Plan, design and execute the testing strategies and practices to meet the functional testing requirements for the applications in the Telephony space such as IVR/VRU applications, call routing, and call monitoring, outbound Dialer etc.

●Develop test scripts based upon business requirements and processes, in line with defined workflows and use cases.

●Define test bed configurations, create test scripts for automation, integrate test tool sets and developed automated test suites to perform testing on application processes and API web services.

●Strong working knowledge with Database Validation and Transactional data validation by executing SQL queries in Oracle & Toad.

●Create and Administer Quality Center for Test Management and Defect reporting.

●Data mining using SQL and provide the test data for different test conditions.

●Validate the structure and components of XML file generated as result set from the application.

●Testing the web service applications with SOAP scope Request/Response handling.

●Work collaboratively with other teams to coordinate testing efforts across multiple releases of the application.

●Extensively used Quality Center, for test planning, bug tracking and reporting

●Coordinate component, system and documentation testing with the appropriate technical groups and Release Management.

●Assigning, Monitoring and Tracking Tasks of Team Members.

●Executed the test cases with positive and negative inputs.

●Involved in Test effort estimation, Metrics preparation and defect prevention.

●Validated the Business Rules and the data in BO Reports.

●Coordinated with the BSA to validate and define the QA specifications.

●Prepared Test cases for the Peregrine tickets, executed and logged the defects.

●Wrote numerous reusable SQL scripts for data validations (back end testing) that are used for Integration Testing and System testing.

●Wrote SQL queries(Joins, Sub queries) and validated the data in DB2.

●Data mining (in DB2 databases) to get the respective data to meet the test requirement.

●Validated IVR data through SOAP scope web services.

●Interacted closely with developers regarding defects, participated in tracking defects using Quality center, Reviewing and Analyzing bugs.

●Performed cross-browser testing on Internet Explorer and Fire fox for various modules of testing.

●Creating and implementing test environments for a client-server and distributed system involving relational databases.

Environment/Tools: Java, J2EE, BO Reports, XML, SOAP scope, Quality Center 9.2, SQL, DB2, Windows, Mainframes, Omni Plus.

State Farm Insurance, Bloomington, IL

QA Tester (Oct 2004 – Dec 2007)

Claim Management Application has several modules. I have worked in Auto Insurance module testing. The Auto Insurance system deals with the insurance of automobiles. It checks the driving history of the insurer when the SSN & Driving License Number is given and handles customers’ insurance claims.

Responsibilities:

●Interacted with end users to obtain specific system requirements.

●Developed Test plans and Test cases for the application using Test Director.

●Performed Black Box testing (Functional, Integration and Regression testing).

●Conducted Smoke tests and Regression tests for every new build.

●Documented all Test cases, Test results and Test procedures.

●Used SQL statements for back-end testing.

●Maintained a test log, reporting defects using a defect-tracking tool, Test Director.

●Created data driven scripts to be used with various data/test cases for positive and negative testing of the application.

●Reported software defects and interacted with developers to resolve technical issues.

●Performed application builds as and when any modification has been done for release of any version of the application and release for further testing by developers and QA personnel.

●Customized test scripts using synchronization points and check points.

●Modified scripts using TSL according to functionality.

Environment/Tools: Win Runner 7.5, Test Director 7.6, Windows NT, JavaScript, Java, Oracle, MS-Office

HDFC Bank, Hyderabad, India

QA Analyst/Back-end Tester (May 2003 – Sept 2004)

Responsibilities:

●Manually tested the application for a few modules for the functionality of the application

●Provided facilitation among cross-functional departments translating new business and market needs to functional requirements

●Created test cases to validate the functionality.

●Extensive manual testing to ensure that the system meets the requirements

Involved in User Interface, Functionality, Load, Performance and Security testing, Beta Testing.

●Involved in regression testing of the application.

●Developed and executed the test scripts and test cases.

●Involved in tracking defects and creating test summary report.

●Identified and reviewed the design outputs against the Design input requirements.

●Assisted QA team in planning and performing User acceptance testing (UAT) for the all the modules involved in the project and ensured they are in line with both business and functional requirements.

●Participated in meetings to update the status of testing to the management

Environment/Tools: Informatica Power Center, MS Office, MS Visio, Java, Rational Rose, TOAD, SQL, .Net, MS Project, UNIX, Flat files, Oracle 8i, UML, Ticket Tracker.

Education: Bachelor’s in Computer Science

References: Provided Upon Request

Contact this candidate