Swarna Lakshmi

Senior QA Automation Engineer SDET

C2C Consultant 3rd Party Employee

201-***-**** ac33t4@r.postjobfree.com

TECHNICAL SKILLS

AUTOMATION TESTING TOOLS

Selenium WebDriver/RC/Grid, Cucumber, Maven, QTP, LoadRunner

LANGUAGES/FRAMEWORK

JAVA, JUnit, TestNG, C#.Net, NUnit

BUG REPORTING TOOLS

Bugzilla, Jira, Rational Clear Quest BI Tools

PROGRAMMING LANGUAGES

C, SQL, T-SQL, PL/SQL, VB 6.0, VB Script, HTML, JAVA, SOAP, Web services, XML

DATABASES/TOOLS

Oracle 10g/9i/8i, MS Access, MS-SQL Server 7.0, DB2 9.x, DB2 9.7 luw, Teradata V2R6, TOAD, SQL Navigator, Teradata SQL Assistant 6.2, Oracle, SQL Developer

TESTING TOOLS

Quality Center 9.2, Test Director, QTP, SQL, PL/SQL, SQL Assistance, Toad

TEST STRATEGIES

Manual Testing, Functional Testing, Integration, System, Regression, Testing User Acceptance, Smoke, Black Box, Web Testing, White Box, Load Testing

TECHNICAL SUMMARY

7+ years of total IT experience and very good knowledge QA of Software Applications and Testing. Extensive experience in testing of data warehouse / data marts for business applications with Banking, Insurance, Manufacturing and retail.

Extensive experience in Automation Testing, Manual Testing, System Testing, User Acceptance Testing, Black Box Testing and quality assurance of Web applications and Client/Server using Black Box testing. Excellent experience in automation of Web-based, Highly transactional and large Client/Server/Multi-tier applications

Proven ability in writing JAVA, JUnit, C# scripts and Leading JAVA, C#.Net projects automation

Solid experience of AGILE Methodologies, AGILE Manifesto and Scrum processes

Solid experience of Defect/Test Management tools like JIRA, Quality Center/Test Director, Bugzilla

Strong Experience in Automating Web Application Testing using Selenium WebDriver with TestNG framework.

Well versed with Handling Elements in Selenium WebDriver.

Writing Test cases 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 and Parallel Test execution using Selenium WebDriver, TestNG and selenium Grid

Solid experience of Performance/Load/Stress testing with LoadRunner

Proven skills in SQL, RDBMS and UNIX variants like LINUX, Solaris, HP-UX

Expertise in writing SQL Queries, SQL Scripts and performing Database testing

Proven skills in Leading and training teams, Test Management and Meeting the deadlines

Strong communication & interaction with Clients, Developers, Business Analysts, Management

Strong experience of Financial, Banking, Insurance, Trading and Telecom domains

Proven ability in Windows/UNIX Commands, Scripts and testing on Windows/UNIX platforms

Proven ability in Working individually or as a part of team, Problem solving, Process improvement activities, Analytical skills, Reporting and Assisting to Manager

Excellent Analytical and Logical Programming skills with a good understanding at the Conceptual Level and possess excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals.

Excellent written and verbal communication skills including experience in proposal and presentation creation.

WORK EXPERIENCE

FIRST REPUBLIC BANK SF, CA

SR QA AUTOMATION TESTER

APR 2016 - ONGOING

Implemented automation using Selenium WebDriver, JAVA, Selenium Grid, Cucumber, Maven.

Extensively automated regression and functional test suites by developing over 237 test cases, 6 test suites using Selenium WebDriver, JAVA, JUnit.

Implemented Page Objects framework, Hybrid framework and 21 Page classes from scratch to represent web pages.

Developed Keyword Driven and Data Driven frameworks to retrieve test actions, test data from Excel files and SQL Databases. Configured Maven for JAVA automation projects and developed Maven project object model (POM).

Used Maven, Selenium Grid to execute Selenium automation suites on different platform, browser combinations in parallel. Developed BDD tests using Cucumber by writing behavior and step definitions. Developed required Selenium support code in JAVA for Cucumber.

Wrote SQL queries extensively, queried database and generated test reports. Performed Purchase Orders Database testing by developing 14 SQL scripts.

Performed Defect Tracking & Management in JIRA. Generated automated daily reports using JIRA API.

Worked in a highly dynamic AGILE environment and participated in scrum and sprint meetings

Assisted Manager by providing automation strategies, Selenium/Cucumber Automation and JIRA reports.

Identified weaknesses in QA Processes, Web testing, Selenium Automation. Suggested & implemented improvements.

Environment: Selenium WebDriver, Java/ J2EE, Java script, Oracle, Agile

PACIFIC GAS & ELECTRICITY SF, CA

QA AUTOMATION ENGINEER

AUG 2015 – APR 2016

Preparation of the Test Strategy and guiding the team. Involvement in the System Test Plan Preparation and Requirements Streamlining.

Involvement in Preparation of Test Procedures, Test Scenarios, Cases and Test Data. Responsible for GUI and Functional Testing, using Black Box Testing Techniques. Involvement in Test Execution, Results Analyzing and Defect Reporting.

Involvement in RTM Preparation. Involved in Automation Infrastructure Development using Selenium

Created Test Cases Using Element locators and Selenium Web driver methods. Enhanced Test cases using Java programming features and TestNG Annotations. Execution of Selenium Test cases and Reporting defects.

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

Enhancing the Test Scripts for Global Execution. Involvement in solving Environmental problems along with Technical Support People.

Involved in Regression Testing using Selenium. Preparation of weekly and monthly status reports.

Environment: Selenium WebDriver, TestNG Framework, Bugzilla, Java/J2EE

SEAR HOLDINGS CORP CHICAGO, IL

SR QA/SQL MANUAL TESTER

AUG 2014 – AUG 2015

Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.

Tested the data and data integrity among various sources and targets

Used debugger to test the data flow between source and target and to fix the invalid mappings.

Designed and created the Microsoft Visio diagram which represents the workflow and execution process of all the process in the reinsurance world.

Experienced using database query tools for Oracle, SQL

Worked with SOAPUI for testing Web Services

Tested both the User Oriented and Service Oriented based on requirements and service contracts

Tested both the Web Service Architecture and Service Oriented Architecture

Tested complex objects to the universe to enhance the report functionality.

Helped the team in analyzing the data to be able to identify the data quality issues

As a Test Lead involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans and Execution Plans.

Written several UNIX scripts for invoking data reconciliation.

Used Quick Test pro to write the automated test scripts by using various actions and reusable actions.

Manually tested the application functionality and developed Automation test scripts to perform functional and regression testing and prepared automation test scripts, Methods and functions in QTP.

Executed SQL Queries for testing integrity of data in database (Backend Testing)

Generated tractability Matrices to ensure that all the requirements are covered by the test cases.

Defect Reporting & Defect Tracking using Quality Center.

Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center

Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.

Environment: Autosys, Oracle 9i, Toad 6.3, XML, Java Script, SQL, PL/SQL, Windows 7, XP, HP - ALM Quality Center 9.2, Quick test pro (QTP), SOAPUI

HCL INFOSYSTEMS

QA/MANUAL TESTER

JUNE 2009 – JULY 14

Involved in the reporting analysis and configuration in Facets System.

Participated in business requirement walk through, design walk through and analyzed Business requirements.

Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional and Regression Testing.

Written customized SQL queries for business needs.

Reviewed system uses cases and functional specs with business and System Analysts.

Responsible for Data mapping testing by writing complex SQL Queries using WINSQL

Experience in creating UNIX scripts for file transfer and file manipulation.

Validating the data passed to downstream systems.

Worked with Data Extraction, Transformation and Loading (ETL).

Involved in testing data mapping and conversion in a server based data warehouse.

Involved in testing the UI applications

Involved in Security testing for different LDAP roles.

Worked with business team to test the reports developed in Cognos

Tested whether the reports developed in Cognos are as per company standards.

Used Quality Center to track and report system defects

Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: XML, UNIX, Shell Scripting, WINSQL, Ultra editor, Oracle 8i/9i, DB2, SQL Server 2000, SunOS 5.8, DTS, Windows XP

Contact this candidate