Automation Engineer Data Analysis

Professional Summary

A Software Test Automation Engineer with more than 13 years of testing experience with mission to deliver quality software. Wealth of domain knowledge in Healthcare, Worker Compensation, Liability, Risk Insurance, Staffing and e-Commerce solutions. Extensive hands-on ETL, API and web applications manual/automation test experience. Experienced in creating comprehensive Test Plans, Test Cases Test Data, SQL queries, Data Analysis and XML/JSON requests to ensure success with quality by validating Front-End/UI, Web Services and Back-end including database. Extensive experience in leading Business/User acceptance testing (UAT), QAT, Offshore coordination and successfully testing applications in Non-Production and Production environments which includes Sanity, Regression and new feature enablement testing. Extensive knowledge in using tools like, RestAssure, Selenium Web Driver, ALM, QC, Fitnesse, SOAP UI, Postman, ETL testing, Shell Scripts/Power Shell. Some recent achievements to highlight:

-Datawarehouse ETL Testing - successfully created and verified multiple business reports

-Performed comprehensive data analysis by running complex SQL queries across multiple database tables to ensure quality of data in database reports.

-Created Test plan framework from scratch for data warehouse testing project

Work Experience

Zelis Healthcare. Atlanta, GA Position: Senior QA Analyst Sept 2016 – Present

Zelis, a market leading healthcare information technology company and provider of end-to-end healthcare claims cost management and payments solutions including network management, claims integrity and electronic payments serving healthcare payer clients, healthcare providers and healthcare consumers in the medical, dental and workers' compensation markets nationwide.

Role and Responsibilities:

Actively involved in all Sprint ceremonies including grooming, planning and retrospective.

Develop test plan and cases to align the testing efforts needed to complete user stories for each Sprint cycle.

Prepare and review test scripts using Microsoft Test Manager (MTM)

Used Swagger tool to test SOA based architecture application to test APIs.

Performed SOA / web services testing using Swagger, wrote adaptors to test / invoke web services.

Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from SQL server database.

Responsible for updating and maintaining the TFS for reporting and logging the defects found during the functional and regression testing and follow up the bug life cycle.

Functional and Cross Browser testing of Defined Browser Stack of the site experience.

Defect Triaging and Release sign off for Continuous Delivery cycles.

Writing complex SQL queries and update transaction and properties for accounts on stages for UI testing, Integration testing with different data points etc.

Participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts.

Environment: Swagger, TFS (Team Foundation Server), Microsoft Test Manager (MTM), Internet Explorer, Firefox, Microsoft Office Suite (MS Word, Excel etc.), SCRUM, Agile, SQL server Report Builder, Microsoft Visual Studio, XML, JSON, Power Shell, Jira, ADO

PeopleNet Inc. Atlanta, GA Position: Senior QA Analyst June 2014 – September 2016

PeopleNet provides a workforce technology solution customized to fit any business needs. It offers automated, fully hosted solutions designed to help agencies provide their clients with excellent time tracking and payroll processing services. The web-based solution stream lines all staffing processes which leads to improved operational efficiency of the customers.

Role and Responsibilities:

Actively involved with SCRUM and sprint meetings, managing product backlogs, removing obstacles to progress, re-allocating resources where necessary, prioritizing and review milestones and accomplishments.

Develop test plan to align the testing efforts with each sprint.

Prepare and review test scripts using Rally.

Used SOAP UI tool to test SOA based architecture application to test SOAP services and RESTful APIs.

Performed SOA / web services testing using Soap UI, wrote adaptors to test / invoke web services.

Reviewed database test cases per assigned Requirements to validate reports by retrieving data with complex SQL queries from SQL server database.

Responsible for updating and maintaining the Rally for reporting and logging the defects found during the functional and regression testing and follow up the bug life cycle.

Functional and Cross Browser testing of Defined Browser Stack of the site experience.

Defect Triaging and Release sign off for Continuous Delivery cycles.

Writing complex SQL queries and update transaction and properties for accounts on stages for UI testing, Integration testing with different data points etc.

Participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts.

Environment: Soap UI, Rally, Jenkins, JIRA, Postman, Internet Explorer, Firefox, Microsoft Office Suite (MS Word, Excel etc.), SCRUM, Agile, SQL server Report Builder, Microsoft Visual Studio, Eclipse, XML, XPath

Aon-eSolutions, Marietta, GA Position: Sr. QA Analyst October 2008 – July 2014

Position: Senior Test QA Engineer

Projects: Risk Console, IVOS, Automation (Fitness)

Aon Risk Console is a true browser-based risk management information system (RMIS) that combines claim, exposure, policy, and other risk-related data to provide risk managers with a comprehensive view of their organization's risk. Aon RiskConsole is the pioneer in browser-based risk information technology. Used by more than 100,000 users in more than 40 countries in eight languages, Risk Console is the premier global RMIS solution.

Role and Responsibilities:

Developed test automation, using TDD approach (Fitnesse, Groovy, etc.)

Worked in sprint team with business analysts and developers in Agile methodology.

Involved in Sprint planning, story prioritization and story points estimations.

Integrated automated testing with Jenkins Continuous Integration and Sauce Labs cloud-based test execution.

Modified automated test scripts as per functional requirements and created/maintained Groovy fixtures for new functionality.

Created REST API tests using Fitnesse REST services.

Analyzed Continuous Integration needs and developed and implemented test tagging strategy so that different tests were run at appropriate times.

Performed backend testing with SQL queries using Fitnesse Slim tables to perform CRUD operations.

I was responsible to report the sprint execution tasks and time entries in JIRA.

Reviewed manual testing methods, developed and executed automated scripts.

Involved in manual as well as automated testing of the applications.

Used SoapUI Pro NG/Ready API automation for REST based web services.

Involved in Defining user defined parameters to execute various functions in QuickTestPro

Used QuickTestPro checkpoints to automatically capture and verify properties such as the number of links, images, broken pages etc.

Managed offshore team in India and China.

Managed UAT co-ordination with various clients.

Environment: QuickTestPro, SoapUI, Fitnesse, Groovy, JIRA, QTP, QC, TOAD, Internet Explorer, Firefox, Oracle, Flex, Java, J2EE, Microsoft Office Suite (MS Word, Excel etc.), SCRUM, Agile, Citrix (Data Def, Load Def)

LBI, Atlanta GA Position: QA Analyst March 2008 – Sept. 2008

Project: Transitions Optical Managed Care Website, Home Depot and Bayer

LBI develops digital solutions from customer strategies to immerse interactive experiences to post launch results tracking, analysis and optimization. LBI offers interactive marketing services tailored to the clients' unique objectives.

Role and Responsibilities:

•Review and perform detail analysis of FSD (Functional Specification document).

•Wrote test cases and scenarios in Mercury's Quality Central (QC).

•Conducted manual and regression tests based on Test Cases.

•Performed manual testing on various websites like Home Depot, Bayer etc.

•Performed detail functional testing of all interactive and non-interactive pages.

•Performed testing of web applications developed on Java and .Net environments running on different operating systems for compatibility purposes.

•Prepared test summary and defect report.

•Communicating and coordinating with off-shore QA team in India and development team in Atlanta for defect resolution.

Environment: Quality Central (QC) 9.0, QTP 9.2, HTML, Windows XP and Vista, .Net, ASP, VB Script, Java, JSP, Java Script, Microsoft Word, Excel, Adobe flash

Contact this candidate