Test Cases, Test Data conditioning, Agile, Automation(Selenium/QTP) Et

PRASUNA PARVATANENI

617-***-****) *********@*****.***

SUMMARY:

Offering 10+ yrs. of industry experience in Manual, Automation and ETL Testing with a solid understanding of Test Planning, Test Design, Test Execution, Defect Reporting & Tracking. Expertise in Understanding and Analyzing Test Requirements, Tracking changes and maintenance of Test requirements. Well acquainted with all phases of SDLC and STLC. Experienced in Test Automation using Selenium and UFT (Formerly QTP) Tools. Good Experience in Automating Web Applications using Selenium WebDriver with TestNG framework. Well versed with Handling Elements in Selenium WebDriver. Writing automation scripts using Element locators, WebDriver methods, Java programming features and TestNG Annotations. Executing Selenium Test Cases and reporting defects. Experience in Data driven testing, Cross browser testing, mobile testing and Parallel test execution using Selenium WebDriver, TestNG and selenium Grid. Knowledge of JMeter Performance Automation tool. Experience in ETL testing using Datastage, Informatica and SSIS tools and validating data in staging, lookup and target tables and maintaining Data Integration throughout the process. Adept in running jobs using Autosys tool. Well versed in querying data using SQL queries and verifying data in database tables. Adept in using UNIX commands while validating files using TELNET/PUTTY tools. Involved in Test Estimation and Test strategy implementation. Proficient in devising all the artifacts of testing such as Test Scenarios, Test Cases, Defect and Test Summary Reports. Well experienced in onsite – offshore model. Self-motivated, energetic and highly ethical in all work related assignments thus able to immediately contribute to corporate goals and objectives. Good written, communication, interpersonal skills, proven team player/independent tester with an analytical mind bent to problem solving and delivering solutions.

ISTQB/ASTQB Certified QA Professional

Certified in Introduction to Oracle 9i, SQL

TECHNICAL SKILLS:

ETL Tools: Data Stage 7.52, Informatica 8.x, Visual Studio SSIS 2008, 2012, SQL Loader.

Scheduler Tools: Autosys.

Databases: Cortex, Oracle 11g/10g/9i/8i, SQL Server 2005/2008/2012

Languages: SQL, PL/SQL, UNIX, VBScript, JAVA 7, 8

Database Tools: KQL, Query Analyzer, SQL Developer, SQL Navigator, SSMS and Toad.

Operating Systems: UNIX, Windows 7/8/Vista/XP/2003/NT, AS400

Methodologies: Agile, RUP, Waterfall

Testing Tools: Rally, QC ALM, Test Link, JIRA v6.3.1, Microsoft Test Manager 2013, ALM/Quality Center/Test Director, Rational Clear Quest, Rational Quality Manager and RationalTeamConcert.

Automation Tools: SELENIUM, QTP/UFT, GitHub

Other Tools: Cognos, Beyond Compare, Clear Case, eRoom, Microsoft Office Suite, SharePoint 2010, 2013, Putty, Telnet, WinSCP 8 and Tortoise SVN.

PROFESSIONAL EXPERIENCE:

Eye Level – WORDS N NUMBERS: QUICKBOOKS

Senior QA Tester - Manual and Automation Feb 2017 – Jul 2017

Involved in the System Test Plan Preparation and Requirements Streamlining.

Performed Smoke, Functional and Integration Testing of the web application manually and automated Regression testing using Selenium.

Preparation of Test Procedures, Test Scenarios(both functional and non-functional), Cases and Test Data.

Responsible for design and development of automation framework using Selenium WebDriver

Analysis of test requirements and automation feasibility. Automate new features for reducing time and cost.

Coordinated with dev and business team for clarity on the requirements.

Responsible for GUI and Functional Testing, using Black box Testing Techniques.

Responsible for Test Execution, Results Analyzing, Defect Reporting and in RTM Preparation

Created Test cases Using Element locators and Selenium Webdriver methods. Ex: ODM(Object Dot Methods)

Created automated scripts for validating Account Set up, Dropdowns, Textboxes, All links in a web page, frames, Modal dialog boxes, Images, Mouse hovers options using Java. Good knowledge of Page Object Modelling (POM).

Performed backend testing and created automation test scripts comparing and validating with UI data.

Enhanced Test cases using Java programming features and TestNG Annotations.

Execution of Selenium Test cases and Reporting defects.

Conducted Data driven testing, cross browser testing and parallel test execution.

Solved Environmental problems with the help of Tech Support.

Performed Regression Testing using Selenium.

Preparation of weekly and monthly status reports.

Environment: Java 8, Eclipse IDE, Selenium WebDriver for IE, Chrome, Firefox, SQL Server 2012, Windows 7. SharePoint 2013, Custom developed defect tracking tool, Rally.

Randstad Technologies - Bank of AMERICA Jul 2016 – Nov 2016

Senior Software QA Engineer

Senior software QA Engineer with full system development lifecycle experience, including designing, developing and implementing test scenarios, test cases and test processes.

Responsible for testing the Breach Loan Web Application and End to End process of MSP – Breach project.

Conducted Smoke, Functional, Sanity and Regression testing of the web application.

Participated actively in Standup, Backlog Grooming and retrospective meetings in an agile environment.

Worked as onsite Senior QA Engineer for offshore India team mentoring and providing clarifications on the UI functionality, SQL scripts and assisted in getting and configuring access to various tools and Environments.

Wrote complex SQL queries while reviewing the SQL/Test scripts of the offshore team and clarified their questions on the core functionality of the Loan breach process.

Experience in testing the ETL process and running batch cycles and validating the loans breached after going through the J rules engine.

Performed cross-browser testing (IE, Chrome, Firefox) and web services testing to verify the Loan Amts and request numbers using WSDL in SOAPUI.

Well versed in creating tasks, test scripts and defects in Rally. Conducted test scenario reviews with business and dev teams.

Provided test status and summary reports to the project management team.

Environment: Oracle 11g, QC ALM, SharePoint 2013, Toad 11.x, SQL Server 2008/2012, Visual Studio 2013, Rally, Java 7, .Net 4.5.1, IBM Client Access 11.7, IBM AS 400 iSeries.

ACTIVE NETWORK Jun 2015 – May 2016

Senior Software QA Data Migration Engineer

Worked as a Senior QA Engineer with offshore (china) team and onsite dev team and ensured the quality of the project remains the top priority from a user point of view.

Wrote and reviewed test scenarios/test cases, SQL queries to ensure the correct level of test coverage for data integrity and consistency. Identified/replicated and reported defects and verified fixes. Conducted Functional, Sanity and UAT testing for the accuracy of the data.

Held test scenario review meetings and defect triage meetings with SMEs(User community), Project Manager and Dev Manager.

Responsible for the coordination and completion of all E2E testing activities right from gathering requirements to the implementation of the project.

Proficient in using Tortoise SVN to check out the code. Compiled and ran the import scripts as a part of SSIS package in Visual Studio.

Executed the ETL Automation tool(SSIS package) developed, to export data from source to staging tables and import to Target DB successfully by fixing the data issues.

Provided technical support and troubleshooting for customer reported issues. Participated in Change Management process.

Data Integration testing is done after merging two or more sources and staging the data on the staging tables and validating according to business rules in the mapping document and running the tasks to export data to Target tables.

Ensured the data integrity is maintained throughout the migration process from upstream application->legacy database->new database->downstream application.

Prepared test data by creating various test scenarios in the UI and validated the data in the database by running the extract scripts

Responsible for restoring and upgrading the databases throughout the migration process.

Validated the data migrated using the mapping documents to target DB and verified various scenarios on the web application to ensure the data correctness.

Executed PL/SQL statements when the DB is changed from SQL Server to Oracle to verify the data Integrity is maintained.

Prepared the SSIS package Set up document from a user point of view and conducted demo sessions to execute the package to migrate the customer data.

Performed data analysis for both source and target data systems during data migration.

Environment: Internet Explorer 11, Oracle 11g, SharePoint 2013, SQL Developer 4.2.20.09, SQL Server 2008/2012, Visual Studio 2008/2012, SSMS 9.00.2047.00, Test Link 1.9.13, Java 7, NetBeans IDE 7.0.1. Tortoise SVN, Jira

AFFIRMATIVE INSURANCE AND HOLDINGS, Inc. (Insurance) Addison, TX Apr 2013 – Feb 2015

Senior Quality Assurance Analyst

Played a key role in testing the Credit Card Payment Process and Indiana conversion projects.

Validated modules in a policy decision application. Integrated testing of Policy Decisions, Proclaims and Billing Decisions. Performed Sanity, Functional, System, End to End Integration and Regression testing for the Billing Decision client-server application.

Attended Review meetings to discuss Use-Cases, Business Rules, message rules, alternate flows and exceptions paths.

Actively involved in the preparation of test data by modifying the policy transactions in the front end UI according to business rules and conditions and verifying if the data is updated in the database tables after the tasks (jobs) were run.

Responsible for Test Plans, Test Prep and Execution of Functional, Sanity and Regression tests on multiple projects.

Experience in writing SQL scripts and executing PL/SQL statements to test Functions, Stored Procedures.

Validated the reconciled policies in the web application on a daily basis after the tasks (jobs) ran to integrate the payment and other transactions in policy and billing applications.

Documented software defects using bug tracking system and reported defects involving program functionality, output, online screen and content to software developers.

Tested performance of various functionalities in the application using JMeter. Updated and Executed automation scripts using Selenium.

Delivered thorough QA testing reports that determined product quality and release readiness.

Participated in project and triage meetings to discuss the issues and new functions with end users.

Performed API testing using WSDL for SOAP UI.

Submitted daily reports to management about the status and execution of tests.

Tested both web and client server applications including a self-serve website. Web-based applications involved cross browser and OS compatibility testing.

Used Mobilizer for mobile testing of Affirmative self-serve website and Underwriter Applications and validated payment transactions.

Utilized TFSàMicrosoft Test Manager for test prep, execution and defect reports.

Developed reusable shared test scripts to test the functionality of the application in Microsoft Test Manager.

Knowledge of HTTP, HTTPS protocols, Java Script, CSS, HTML and XML as well as Web Services technology. Experience with functional web services tests.

Environment: Internet Explorer 10, Microsoft Test Manager, Oracle 10g, SharePoint 2010, SQL Developer 3.2.20.09,

SQL Server 2008, SSMS 9.00.2047.00, .NET, Java, PHP 5, TFS, XML, Visual Studio 2013, Windows 7,

Web Services, Microsoft Project, Office 2013.

Infosys Ltd - FIDELITY INVESTMENTS (financial services) Dec 2011 – March 2013

Quality Assurance Analyst (ETL testing) – Lead Coordinator, Nashua, NH, Westlake, TX

Worked as a test lead for production support/data architecture team and triaged, managed Help Desk tickets and ensured follow through to closure while meeting Service Level Agreements (SLAs).

Executed test plans and scripts which determined data validity and tracked and resolved defects in software and specifications. Provided test estimates. Allocated resources.

Documented the quality assurance life cycle, analyzed functional requirements, and mapped documents. Tested production issues and adhered to deadlines.

Played prominent role in testing the Oracle 11g upgrade. Validated the performance of database tables.

Wrote complex SQL scripts using joins, and correlated sub queries.

Led projects in coordination with an offshore team. Provided test metrics at the end of iterations.

Performed quality assurance reviews for all phases of the system development life cycle.

Identified processing errors by analyzing computer logs and reports. Recommended corrections.

Supported the extraction, transformation and load process (ETL) for a Data Warehouse from the legacy systems using Informatica

Created the test environment for Staging area, loading the Staging area with data from multiple sources.

Reviewed the ETL mappings to ensure the transformation rules are applied correctly.

Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source tab delimited/csv files and RDBMS tables to target tables.

Checked the status and performance of jobs in Autosys UI.

Published release notes, approved change management tickets, and took part in change approval sessions. Prepared User Documentation for the enhancements.

Collaborated with business SMEs and development team to include data types and transformation rules in the mapping spec. Prepared and reviewed the mapping spec for source and target tables

Conducted triage meetings to review test results. Contributed to daily scrum meetings, daily discussions of defects and issues, and test planning meetings.

Performed DATA VALIDATION, DATA INTEGRATION, and DATA TRANSFORMATION.

Served as an engineer on modeling project. Contributed to complex projects with tight deadlines.

Identified integration user stories and tasks through sprint grooming and sprint planning sessions.

Helped to conduct User Acceptance Testing (UAT) meetings. Prepared test and defect status reports and other test metrics.

Performed post production validations and tested critical issues successfully that appeared in production.

Environment: Beyond Compare, Informatica 8.x, Oracle 10g/11g, Quality Center 10.x/11, Rational Team Concert 3.0, 3.0.1, SharePoint 2.0, SQL Developer, UNIX, Windows 7, WinSCP 8 Internet Explorer 8, Oracle 11g, Quality Center(ALM) 11, QTP/UFT, SharePoint 2010, SQL Navigator, Windows 7

Randstad Technologies - ASTRAZENECA (Biopharmaceuticals), Waltham, MA Jan 2011 – Dec 2011

Quality Assurance Specialist

Tested Web application which is based on different types of searches and automated regression test scripts using QTP after identifying features to be automated.

Developed and stored VBScripts. Handled dynamic objects of the application using RegEx in QTP.

Tested applications with multiple data sets using data-driven methods. Used Modular and data-driven frameworks. Created library for functions, sub-procedures.

Performed Smoke, Functional, Sanity and User Acceptance testing of the web application in Java.

Conducted detailed functional testing and GUI testing for functionality and security.

Contributed to requirement analysis, review of test cases, and triaging of defects.

Provided test estimates, schedules, and release sign-offs. Prepared detailed test plans.

Assisted with iteration planning, agile project management, and delivery of story points.

Updated the status of testing in daily scrum/stand-up meetings.

Environment: Apache Tomcat, IBM Cognos 8.4, ICEfaces, Java, J2SE, JIRA, Oracle 10.6.0.423, PERL, Rally, QTP, Toad, Windows Vista.

Vertical Info Tech - STATE STREET CORPORATION (financial services), Boston, MA Aug 2009 – Nov 2010

Quality Assurance Analyst /Data Analyst - ETL

Coordinated all testing activities with offshore team. Reviewed requirements & mapping specifications.

Provided effort estimates and scheduling to sign off the release. Updated traceability matrices.

Prepared test strategies and reviewed test cases. Validated source and target databases.

Reported and triaged defects. Took part in analyzing data and sending data feeds.

Performed tests in Systems Integration Testing (SIT) and UAT environments.

Demonstrated the functionality of each iteration and supported end users.

Contributed to functional, backend, end-to-end, and regression testing.

Designed the data flow diagrams using VISIO.

Compiled weekly progress and defect reports for management. Took part in stand-up meetings.

Tested Complex ETL Mapping using the mapping document.

Gathered high level requirements and converted them to business requirements

Performed Data Analysis and developed Data Mapping documents for ETL (Data Stage) projects.

Prepared User Documentation for the enhancements.

Collaborated with business SMEs and development team to include data types and transformation rules in the mapping spec.

Environment: Data Stage, Oracle 9, Quality Center 9.2, Quality Analyzer, SharePoint, SQL Server 2005, Toad, Unix, Windows XP, WinSCP3

Vertical Info Tech - HEALTH MARKETS Inc. (healthcare) Hartford, CT Aug 2008 – July 2009

QA/UAT Tester

Analyzed user requests and functional specifications. Designed test plans and test cases.

Performed functional, SIT, UAT, and regression tests of a web portal. Executed automation test

scripts. Managed tests, tracked defects, and generated reports.

Knowledge of health information and health care services regulatory environment including HIPAA, Medicaid/Medicare.

Conducted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements.

Designed, developed and implemented user acceptance testing protocols as the final phase of applications development.

Captured and tested all modifications to proposed functional requirements.

Environment: Firefox 30.x, Internet Explorer 5.x/6.x, J2EE, JSP, SQL Server, Quality Center 9.0, WebSphere, XML, Erwin 4.0

Vertical Info Tech - CORE METRICS (digital marketing), Austin, TX Oct 2007 – Jun 2008

Validation Analyst

Tested client database migration. Wrote test cases and entered defects in Clear Quest.

Performed regression and performance testing of reports. Attended project meetings.

Executed functional case tests. Reported trend, search, and download functions.

Designed queries in order to compare data migrated and validate reports.

Environment: Clear Quest, Internet Explorer 6.0, Oracle 8.i, Oracle 10g, SharePoint

Vertical Info Tech - MISSION HEALTH AND HOSPITALS, Asheville, NC Oct 2006 – Sep 2007

Quality Assurance Tester, Vertical Information Technology (in-house project)

Contributed to integrating a new provisioning system and web application. Prepared test procedures.

Took part in the design and execution of test cases. Performed user acceptance and regression testing. Prepared queries to validate and archive ad hoc reports.

Tracked bugs and created reports of defects.

Environment: Internet Explorer 5.x, LDAP, AS400, Microsoft Outlook, Oracle 9i, SQL Navigator, Test Director 7.0, Windows NT

EDUCATION

Postgraduate Diploma, Computer Applications, Padmavati Mahila University, Tirupati, India

Master of Science, Osmania University, Hyderabad, India

Contact this candidate