Automation Engineer with Selenium, HP ALM/QC,SQL Database,ETL,Excel

PH: 480-***-****

Email:*******@*****.***

Anupama Ganesh

Professional Summary

•About 10 years of IT experience in Quality Management of Automation testing on web and GUI based applications using Manual, Selenium Web driver, UFT performing UI based testing like Smoke, Black Box, White Box, GUI, Functionality, Unit, Integration, Regression, Usability, Compatibility, Installation, System, Performance, Load, Stress and User Acceptance (UAT) of GUI and client/server applications.

•Development experience in Client/Server applications using OOP, C++, Java, Javascript and C# with emphasis on Quality Assurance.

•Scrum Master facilitator for an agile development team using Agile-SCRUM+Kanban and Waterfall Model.

•Considered the best Documentation expert for Project Management Activities during Audit.

•Worked extensively on Database Connectivity using SQL Statements to test and interpret complex queries.

•Been able to work with an AGILE mindset while engaged in Agile Program Management where Epics were broken down into user stories.

•Experience in developing Applications in Object Oriented Programming with C++, Java, Javascript, JSP and related concepts using MS Access, Oracle, DB2, Sybase, FoxBASE, FoxPro and UNIX.

•Management level experience in functional/performance testing different Database Applications and Business Intelligence (BI) applications.

•RESTful API and SOAP Web Service testing including creating Requests for intra/inter using Soap UI.

•Responsible for designing test scenarios in order to test the applications throughout Software Development Life Cycle.

•Analyzing requirements to split up as Epics/user stories,creating test plans and communicating via Bug tracking systems like Rally & Jira.

•Performed System Testing, Regression Testing, Sanity Testing,Performance Testing, End-End testing and Production Smoke Test.

•Generating Sprint activities & Bug Report graphs using Test Management Tools such as ALM, Rally & Jira.

•Tracking and resolving issues in Requirements phase before relegating issues as stories and tasks.

•Professionally Experienced with Test Driven Development(TDD), Acceptance Test Driven Development (ATDD) & Behavior Driven Development(BDD).

•High level exposure on Extract Transform Load (ETL), essentially predominant in domains like Healthcare, Banking, Insurance, Education, Finance, Travel etc.

•Extensively used SQL queries/Unix commands for data verification and backend testing.

•Hands on experience in writing SQL queries, Joins, Functions, Procedures, Packages, DBMS, RDBMS, and Triggers in Oracle, MS Access, Sybase, DB2 and FoxPro.

•Strong experience in UNIX shell scripting and monitoring the UNIX logs to check for any errors.

•Highly experienced in building Automation Frameworks using Selenium Webdriver, Cucumber and Angular 2 Protractor in Node JSwith Jasmine and integrating Maven builds on Jenkins through Saucelabs.

•Software Versioning for programs like Java, Javascript, JUNIT & TestNG using revision control systems like GIT & SVN.

•Performed Browser based testing on Mozilla, IE, Chrome, and moblie apps like Safari.

•Team Leader with excellent communication skills, strong problem solving capabilities and orchestrated planning skills.

•Brainstormed with development teams and business analysts to analyze scenarios and ensure that application functionality meet the Requirement traceability Matrix.

•Delivered application specific solutions which helped Business get a better perspective through high level Proof of Concepts(POCs).

•Managed multiple projects and delivered High Quality Products like clockwork which helped achieve milestones for Releases/Sprints successfully.

•Dedicated, conscientious individual with a strong sense of responsibility, work flexibility and quickly able to adapt to changing environments.

Technical Skills

Tools

HP ALM,Eclipse,Webdriver,JSon

Languages

Angular 2,Java, Maven, HTML/XML,C++, JSP and SQL,SQL 400

Data Base

MS SQL Server,Oracle, MS-Access, FoxBASE, FoxPro, Sybase,Db2 400

Automated Testing Tools

Selenium Suite,Saucelabs,Jenkins,Protractor & Cucumber,ALM

Methodologies

AGILE with Jira,Rally & Rational Team Concert,Waterfall

Protocols

HTTP, WAP, TCP/IP & FTP

Operating Systems

WINDOWS,Unix and MS-DOS, Oracle 8i/9i, SQL Server, MYSQL, AS 400(OS 400), I Series.

Management Processing Tool

Jira, Confluence, Rally, HP ALM, HP Service Center & Rational Team Concert.

EDUCATION

MS in Computer Science.

Acquired certification in the Actuate Reporting System.

Completed training and development in Java, JDK, J2EE, JSP and Javascript.

WORK EXPERIENCE

Client: American Express, Phoenix, AZ Mar 2017-Current

Role: Senior Automation Framework Architect/Developer

Worked on building different Automation Frameworks for separate developing teams.

American Express Identity Client Access for Information Security decides to adopt Single Sign On as a part of their architecture.The AUT was Test Driven Development(TDD) in Angular 2. Had to create Protractor framework from scratch to incorporate automation scripts for regression and functional testing.Protractor uses Jasmine language to run the scripts on Selenium Webdriver.

Amex Identity Client was developed in Java and created Cucumber-Selenium framework from scratch to integrate with Jenkins through Saucelabs using Selenium Webdriver.Before developing the framework, had to conduct POC to test the feasibility of using Cucumber-Selenium architecture.The entire development was Behavior Driven Development(BDD) which needed Cucumber integrated with Selenium for easier shift in development changes.

Both frameworks were accepted by the client after POC documentation and successful demo.

Responsibilities:

Conducted POC and detailed research on Protractor and Cucumber-Selenium frameworks simultaneously.

Conducted Smoke test,Regression testing & Functional testing to program the scripts for the frameworks.

Communicated with Amex Leadership in high level terms on Features of the framework and how test automation architecture would benefit the new Project integration monetarily and optimise quality time while testing.

Trained myself on Angular 2 development concepts to create a Sandbox project to demo the leadership on the benefits of Protractor framework for Angular 2 as the development was not ready for test automation framework setup.

Regression scripts were run often to check the different data in Protractor for the TDD work involved in Angular 2.

Completed framework for Cucumber-Selenium for Identity Client in Java and conducted demo for Leadership to demonstrate the uses of Cucumber architecture with Selenium in a BDD Project.

Completed successful walkthrough on Cucumber-Selenium after completion of an entire module by the Dev team.

Built the framework in Maven to run the Project Object Model in Jenkins.

Environment: Angular 2,Node JS, Protractor, Jasmine, Cucumber, Selenium IDE, Webdriver,TestNG, Java, Maven, Jenkins.

Client: American Express, Phoenix, AZ Jan 2017-Mar 2017

Role: Technical Project Lead

Promoted Tech Project Lead for Single Sign On(SSO) application framework and coordinating with Business team and Backend team to plan the UI Architecture for Automation Framework Modules and Enhancements. Conducted POC on some modules before planning the Architectural UI framework that applied Acceptance Test Driven Development (ATDD) to decide the Application changes.

Responsibilities:

Successfully executed defect free User Acceptance and deployments for the teams in tandem.

Ensured Deployments for modules and enhancements met the Amex Quality Assurance standards.

Worked with Developers and UI personnel insisting on rigorous testing of UI features and breaking the application framework to deliver defect free Business Features.

Automated Regression testing, Functional testing with a choreographed ATDD UI application framework using Selenium Webdriver adding detailed enhancements with improved miniature Releases.

Communicated with Amex Leadership in high level terms on Features being released and Deployed and how the UI architectural design enhanced monetary value to all the integrating Applications .

Escalated issues faced with synchronising teams to analyze resolutions and decide cost effective strategies that did not exceed the Project Budget Funds.

Communicated with leaders on how the Application Framework enhancements raised the Profits in dollar value benefits to the company.

Scheduled Change Requests(RFCs) using Soap UI to deploy module enhancements and worked with teams to fix issues before they impacted scheduled deployment.

Made determinations for Amex applications coming in for modifications that had old data which had to be enhanced with Data Driven Testing (DDT) so that the Application request completed the new enhancement successfully.

Currently, moving SSO(Single Sign On) Automation into Amex owned Identity Client which services the Information Security for all Amex Applications in it's varying domains.

Administrator for Confluence where team Architectural designs, test plans and linking with Jira were taken care of for documentation purposes.

Guided the onshore and offshore teams in solving their problems and encouraging team participation updates in Jira making sure there was visibility for the Leadership in my Jira Dashboard implementation.

Environment: Jira, Confluence, Selenium IDE, Webdriver,Soap UI.

Client: American Express, Phoenix, AZ Sept 2016-Jan 2017

Role: Technical Lead/Scrum Master

AMEX applications' integration system involved Single Sign On(SSO) where I started as the Technical lead for Security Integration Portal (SIP) team where I had to develop the Framework for Selenium Webdriver Automation Testing where Selenium scripts were continuously integrated with Jenkins and run on Saucelabs.

Amex has Travel, Banking, Financial & Publishing applications that had to use the SI Portal where they merged with the SSO UI Framework to access Amex Webservers and Agents to secure their application URLs.Policies are created via SSOAPI agents to secure the URLs and configured through respective agent configurations.These policies were manually configured by the SSOAPI team which is the backend that controls our operations.

SIP application's objective when I came on board was to automate these policies and configure them on SSOAPI end.Within a month, I was promoted from Technical Automation Lead to Technical Project Lead and Scrum Master.

Responsibilities:

Initially, as Automation Lead, I set up the Selenium Framework for Saucelabs.

Responsible for converting Unit test cases to System Integration Test(SIT) cases and User Acceptance Test(UAT) cases.

Coordinated with Offshore testers to conduct UAT walkthroughs and Amex leadership Demos.

Created Selenium scripts with offshore and compiled the framework on Saucelabs via Jenkins.

Created RFC Requests for intra/inter using Soap UI.

As the Project Lead co-ordinated with Back-end & Business to analyse the architectural automation framework needs for UI and Server requirements.

Assisted in Production Support for the Released modules conducting UI walkthroughs and Automation assistance as Administration.

Planned on Releases and Sprint modules/enhancements, regularly co-ordinating with Offshore Developers to convey the System Design and enhancements applied to ensure defect free User Interface.

Planned and set up team meetings, review meetings and discussed on the Retrospectives after each Release identifying the key issues to avoid in future Releases.

Environment: Rally, Jira, Confluence, Soap UI, Selenium IDE, Webdriver, Jenkins, Saucelabs.

Client: Cigna Healthcare, Phoenix, AZ May 2016-Sept 2016

Role: Quality Assurance Functional Lead/ETL Analyst

Cigna Healthcare is going through some major application changes where they are updating their fifteen year old applications to newer systems.Some applications have to be entirely transferred to a new one,scratching out the old while some applications are being upgraded to a newer version.

I was involved in the transfer of an old application to a newer application called Appeals and Grievances.

The data from the Application was vital to conduct Database testing and ETL testing.This was the main jad that started the entire process for the EBT program at Cigna Healthcare,Nashville,TN,where data consolidation of all Cigna Healthcare groups had to be successfully formatted,auditted and preserved in the data-warehouse with the pertaining history.

Responsibilities:

•Involved in entire application testing creating test scripts and verifying test cases with real time data.

•Monitored the entire application while understanding Business requirements, Functional specifications and helped create Test Strategies.

•Developed Test Plans, Test Scenarios and Test Cases based on BI requirements with necessary approvals.

•Checked the Forward and Backward implementation of the Requirement Traceability Matrix while creating the Test Scenarios.

•Assisted in identifying the testing scope variables for the QA environment which helped fix major defects and escalated the testing process.

•Worked closely with the various project teams in a team environment using Sharepoint to check if standard specifications were met.

•Worked with development team to check compatibility testing with Business requirement, created test matrix on bugs, functionality and interface issues.

•Communicated actively with developers regarding priority & severity of bugs, checked the fixes and updated the status.

•Completed entire smoke/system testing and functionality testing with UAT approval under strenous circumstances with limited time.

•Convinced Client and automated test scripts for regression and functional testing using Selenium Webdriver.

•Mapped fields using SQL Server scripts to extract, transform and load from Host database to Universal database.

•Successfully completed smoke/system testing and functionality testing which was critical to meet a deadline and completed ahead of testing timeline.

•Involved in gathering testing data, project estimates, breakdown of testing tasks and test plan dependencies for the EBT testing process at Nashville.

•Conducted peer reviews and quality checks with Users on functionality testing specs.

•Creating SQL query scripts required for data mapping which included database testing during the ETL process.

•Created entire structural flow based on Business requirements and Application work flow with tested scenarios in ALM.

•Maintaining the test logs, test reports, test issues, and executing tests in the test lab while tracking defects using ALM.

Environment: HP ALM, MS Access, MS Excel, MS SQL Server, SQL Server Scripts, SSIS, MS Sharepoint,Selenium IDE and Selenium Webdriver.

Client: Republic Services, Scottsdale, AZ Feb 2016-May 2016

Role: Senior QA Analyst

Republic Services is a Waste Management System dealing in non-hazardous solid waste industry. Their Collection Companies, Transfer Stations, Recycling Centers and Landfills focus on providing reliable services and recycling solutions for commercial, industrial, municipal and residential customers. The Company motto was to support their belief in protecting the planet and applying common sense solutions to customers’ waste and recycling challenges.

They had to upgrade their entire ERP(Enterprise Resource Planning) application which included HR, Payroll, Finance, General Ledger Maintenance etc. in which I was the lead from project initiation to signoff, where I coordinated with onshore and offshore teams .

Application Testing process and web site design testing was started for an Ecommerce website which had to be continuously tested while development was on and automated too.Aumation was simultaneously completed for each module during the project stages of enhancement.

Responsibilities:

•Involved in upgrade and application testing creating test plans and verifying test cases with real time data.

•Actively monitored the entire upgrades from start to finish understanding Business requirements and applying enhancements.

•Coordinated with offshore teams checking their test cases, data and documenting their overall performance.

•Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.

•Actively involved in the Forward and Backward implementation of the Requirement Traceability Matrix.

•Verified the test data by inserting, updating, and deleting the test data values in the database and querying with SQL.

•Interacted with developers regarding priority & severity of bugs and updated the status once they were fixed.

•Verified the defects which are reproducible on the earlier applications and checked for inconsistencies.

•Participated in improving the departments’ QA processes and procedures.

•Co-ordinated with the Security team testing the application transition behavior assigned with tester roles for different Business users.

•Worked closely with the various project teams in a team environment using Sharepoint to check if standard specifications were met.

•Worked with development team to check compatibility testing with Business requirement, created test matrix on bugs, functionality and interface issues.

•Maintained the test logs, test reports, test issues, and executing tests in the test lab while tracking defects using ALM.

•Worked with user stories and tracked iteration progress using Rally in Agile Scrum.

•Participated with team members during Agile Retrospectives,focussing on results and strategies to bring teams to their highest level of performance.

•Tested internal and external web services using SoapUI to connect to different applications.

•Regression Scripts were run in Jenkins integrated with Cucumber for executing the steps.

•JavaScripts were created for applications and executed using Protractor framework for Angular JS.

•Completed verification,approvals and effective signoff of QA procedures with respect to the Company's standard policies with User acceptance.

Environment: HP ALM, SQL400, DB2,MS SQL Server Angular JS on Protractor, Web driver JS, SOAPUI,Jenkins, Cucumber, Rally, Agile Scrum, Microsoft Sharepoint.

Client: Sears, Chicago, IL Apr 2012-Jan 2016

Role: QA Engineer

Sears has many project applications which require extensive manual and automated testing. Their web site needs to be updated every twenty-hours and Stock information has to be checked as often as possible to process the growing customer needs during major sale events and otherwise so as to create an even flow in the tremendous influx online as well as the retail businesses for the customer. The web site had to be tested frequently to accommodate the high level of customer queries and needs as well as creating correct error messages for appropriate issues encountered. Sears also has their POS shopping application that needed extensive testing and maintaining throughout their transactions. Database flow had to be consistent and error free while taking the pressure of the influx of record transactions. Recurrent testing of the databases ensured the flow was smooth and continuous. Also, third party tie ups had to be synchronized with the site while maintaining that the stock was replenished there too.

Responsibilities:

Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.

Followed an extremely light and efficient Agile process adapting to changes in Project plans convincing stakeholders and winning them over.

Business requirements and Product backlog were broken into user stories and channelised into different Sprints based on Agile Scrum.

Used ETL methodology in testing for supporting data extraction, transformations and load processing in a corporate-wide-ETL solution system.

Expertise in writing SQL Statements and AD HOC querying using SQL Query Analyzer to make sure whether the data is populated in Database according to Business Intelligence.

Worked with Data warehouse to export and load data to/from different source systems including flat files.

Generated interactive, multidimensional OLAP graphs/reports through Business Objects from Informatica targeting through MS Access/MS Excel.

Used complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.

Regression testing of websites with Selenium Web driver integrating conditional statements in Java on the Eclipse editor.

Created HTML pages and implemented JavaScript to program the behavior of web pages and handled form data using JSP.

Involved in testing the account details screen and statements screen for credit card consumers.

Involved in Functionality and Security creating automated scripts as a Lead tester testing User Authentication using Selenium Suite for their websites.

Created Use Case Scenarios and was actively involved in the Forward and Backward implementation of the Requirement Traceability Matrix.

Generated validation reports executing complex SQL queries in three tiered internet architecture.

Integrated SQL with Java using JDBC (Java Database Connectivity) and used joins to merge tables.

Verified the test data by inserting, updating, and deleting the test data values in the database.

Used SQL Queries to verify POS databases were consistent and transactional flow uninterrupted.

Applied Performance testing to check the stress and load on the databases.

Worked with DML (Data Manipulation Language), DDL (Data Definition Language) and TCL (Transaction Control Language) in SQL queries against the SQL server database to interpret more complex queries.

Interacted with developers regarding priority & severity of bugs and updated the status once they are fixed.

Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Worked closely with other testers and developers to improve framework with bug fixes.

Verified the defects which are reproducible on the earlier sites and checked for site inconsistencies.

Participated in improving the departments’ QA processes and procedures.

Worked closely with the various project teams in a team environment using Microsoft Sharepoint to check if standard specifications were met.

Environment: AGILE, Selenium IDE, Web driver, Eclipse, SQL, HP ALM, UNIX, TOAD, SQL SERVER, Oracle, MS SQL Server, Java, Javascript, JSP, Microsoft Sharepoint,

Client: Wimoku, Phoenix,AZ Jan 2010-Mar 2012

Role: Sr. QA Analyst

Wimoku is one of the leading IT Consulting, Application development, Integration, Quality assurance support organization. They have executed successful projects in Healthcare, Financial, Manufacturing and Utilities Industries. They were actively involved in developing and maintaining their client websites. They provided staffing solutions to the various needs of their clients. They had to maintain the clients’ database architecture and provided remote database assistance and support.

Responsibilities:

•Involved in the entire software Testing Life Cycle of the projects from initiation to implementation.

•Worked with an Agile SCRUM methodology to ensure delivery of high quality work with every monthly iteration.

•Created test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.

•Built Use Case Scenarios creating easy to understand perspectives for customers on the basis of SRS (Software Requirement Specification).

•Worked with development team to do automate testing, created test matrix on bugs, functionality and interface issues.

•Maintained the test logs, test reports, test issues, defect tracking using Quality center.

•Created and executed SQL queries to perform Data Integrity testing.

•Creating quality assurance documents like Traceability matrix, Defect trend charts and metric reports.

•Performed Functional, Negative, Smoke & Regression tests as per design specs.

•Tested Full load & Incremental load by entering the sample test data to couple of entities and making sure Inserts & Updates of loading the data is done correctly.

•Written several complex SQL 400 queries for validating and testing DB2 databases.

•Participated in various meetings and discussed Enhancement and Modification Request issues

•Work with business to complete User Acceptance Test (UAT) and sign off.

•Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

•Database Administration with Quality Assurance Testing of SQL queries.

•Developed an entire project consisting of HTML code, frames, buttons and tables with HTML script on hyperlinks using Java, Javascript and JSP.

•Involved in developing and testing their client websites onshore as well as offshore.

•Developed Tables, Schema and Stored Procedures, Functions and Triggers.

Environment: Selenium IDE, Web driver, SQL, Rally, HP ALM, UNIX, MS SQL Server, Oracle, SQL 400, Java, Javascript, JSP, XML, Agile SCRUM,UNIX, Visual Studio.

Client: AT&T, Atlanta, GA Jul’2008- Dec’2009

Role: ETL QA Tester

AT&T is the largest Telecom Company in the USA. Joined BI team as Sr. ETL Analyst and successfully participated in design, testing business solutions and contributed under Broadband operation and Business Intelligence (BOBI) project which aims in fulfilling AT&T’s need for reporting to better understand the market trends, behavior, future opportunities and to improve their decision making process. Coordinated with the business and P&A team to understand the system requirements and then analyzing and designing ETL solutions to accomplish the same. Involved in various successful releases to accomplish AT&T’s reporting needs under order-activation (OA) functional area.

Responsibilities:

•Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Ab Initio components.

•Worked in a Agile SCRUM process with two week iterations delivering new features and working software at each iteration.

•Responsible for creating Test plan, development of test scripts, execution and validate test results and document test evidence.

•Executed test cases, and test scenarios for User Acceptance (UAT), Functional and Regression test cases.

•Mapped test cases to requirements using Quality Center.

•Involved in entering and tracking defects using Quality Center.

•Involved in communicating with support, business and development teams to resolve issues during test execution.

•Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.

•Effectively communicated testing activities and findings in oral and written formats.

•Extensively used SQL 400 in backend and front-end functions, procedures, packages to test business rules and security.

•Tested the Integration between Oracle Apps, and the B2B, and B2C Websites, validating data for Business Objects reports.

•Performed Backend testing by writing complex SQL queries on table joins and running them in DB 400.

•Provided status reports on test execution, and defects identified during testing.

Environment:Java,Selenium Suite, HTML, XML, DB2, SQL 400, SQL Server, Agile SCRUM, Rally, UNIX, AS 400, Oracle, MS SQL Server.

Contact this candidate