Automation QA Analyst

Sivaram Prasad Chakala

Phone: 916-***-****

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

SUMMARY:

Around 10 years of experience in Software Testing with 7+ years of experience in Web and Mobile Automation Testing.

Strong exposure in development of Data Driven and Test-Driven Frameworks

Good exposure in BDD - Behaviour Driven Development for automation

Good experience in Mobile automation using Calabash, Cucumber and Ruby

Experience in working with Selenium Web Driver using Java

Good exposure in TestNG, Junit, Maven, Jenkins, GIT, Extent Reports

Good exposure in Customized automation reports

Good experience in Mainframes testing using JCL, DB2

Having experience in working with SQL Server

Experience on developing framework using Page Object Model

Excellent understanding of entire Software Testing Life Cycle, Techniques and Strategies.

Expertise in analyzing Business requirement specification and System Requirements specification, and involving in designing, developing and executing Test Strategies, Test Plans and Test Cases and have excellent documentation skills.

Responsible for preparing efforts Estimation, Project Metrics and reporting the progress of the Project on daily and Monthly basis

Extensively using DB2, SQL Server in querying backend DB tables for Data Validation and Verification.

Experience in project/application documentation and user presentation.

Analysis, Design, Development and Software Quality Assurance in testing of various applications in different domains.

Experience in Testing of web applications using FitNesse/Selenium automation tools

Experience in working with clients in HCLS and Retail domain.

EDUCATION:

Masters in Computer Applications (MCA) from Osmania University, Hyderabad – 2008

TECHNICAL SKILLS:

Operating System

Z OS/390, Windows 9x/NT/2000/XP

Languages

Core JAVA, Ruby

Databases

DB2, ORACLE, SQL Server

Testing Tools

Quality Centre, JIRA,

Automation Tool

Selenium Web driver, MAVEN, TestNG, Junit, Calabash, Cucumber

Integration Tool

Jenkins

IDE

Eclipse, Xcode

WORK EXPERIENCE SUMMARY:

Project# 1

Entrada iOS Automation

Client

Entrada – Brentwood, TN

Domain

Health Care

Project Duration

Feb’ 2016 to till date

Tools/Technologies

Calabash, Cucumber, GIT, SQL Server, XCode and Ruby

Project Description: Entrada is a leading provider of integrated mobile solutions that improve healthcare efficiencies and outcomes. Entrada’s commitment is to protect physician and staff productivity for the next generation of patient care. Entrada was founded in 2010, and our mission remains unchanged even today. Entrada helps caregivers achieve additional efficiencies and improve outcomes by offering mobile solutions that integrate deeply with the organization’s existing technology systems.

Responsibilities:

Develop the complete framework end-to-end in Behaviour Driven Development model

Work with Development team on the development of Automated Testing scripts

Develop Cucumber features as per the sprint plan

Develop Cucumber step definitions and Test scripts

Develop Generic and business Functions using Calabash library and Ruby language

Develop the test scripts using Ruby language

Identity the object and add to the repository

Maintain code in GIT repository

Implement and maintain Test Data Management processes

Work with Development teams to implement Unit Testing processes and technologies

Perform the Smoke, Functional and Regression execution

Work with Development team to implement QA processes and validation in as part of the Release Automation processes

Analyse the test execution reports and update scripts accordingly

Report the bugs found during the execution

Develop functions to avail WEB SERVICES and Stored Procedures to generate dynamic test data

Update the status to the Customer in daily scrum call

Project# 2

Advanced Commerce Portal, Vendor Managed Pricing, ReposiTrak

Client

Park City Group – Salt Lake City, UT

Domain

Supply Chain Management

Project Duration

Aug’ 2014 to Jan’ 2016

Tools/Technologies

Oracle, Selenium Web Driver, Java, TestNG, Maven

Project Description: Park City Group, Inc. (NASDAQ: PCYG) was established in 2002 and now is headquartered in Salt Lake City, Utah. The company focuses on software-as-a-service (SaaS) for the suppliers and retailers in the whole supply chain, reducing out-of-stocks, optimizing inventory, and improving profits and operational efficiencies. In the year of 2009, the company acquired Prescient Applied Intelligence to form "The New" Park City Group. In 2013, the Company moved trading in its shares from the NYSE, formerly the American Stock Exchange, to the NASDAQ Capital Market.

Responsibilities:

Lead a team of technical resources and collaborate with technical leads and developers from other teams

Testing the enhancements, patches and production tickets

Analyzing the requirements (Solution plans)

Preparing the Test plan

Identifying the Test Scenarios and authoring Test cases

Test Execution and Defect management

Prepare SQL queries

Identify the Features to be automated for Regression Testing

Develop Automation scripts using Selenium Web driver, java, TestNG and Maven for Regression Testing

Develop log reports and execution reports

Enhancing the test scripts as per the latest application changes

Execution of developed automation scripts, analyze the results and report Bugs

Involving in Functional and Regression Testing

Involved in investigating and fixing the issues related to automation frame work

Involved in documentation of the scripts mapping with the cases

Project# 3

AutoFlight

Client

48HourPrint – Brook Park, OH

Domain

e-Commerce

Project Duration

Feb’ 2013 to Aug’ 2014

Tools/Technologies

Selenium Web Driver, Java, MAVEN, Jenkins, Redmine, TestNG

Project Description: 48HourPrint is an e-Commerce portal which deals with the online printing service for a wide range of product as well as delivering the print products and located in Boston, USA.

Responsibilities:

Involved in exploring the application and identifying the test scenarios

Performed automation feasibility analysis

Authored regression test cases and converted into automation scripts

Authored automation scripts using Selenium web driver and Java

Configure the library using Maven

Develop Data/Test driven suites using TestNG

Configure the Jenkins and integrate with the Test Suite

Developed scripts and updated to SVN, GIT

Involved in analysing the automation testing reports and perform root cause analysis

Involving in code integration to the GITHUB using GITBASH

Involved in code review

Prepared customized automation reports

Involving in developing of automation scripts for Functional and Regression Testing

Involved in investigating and fixing the issues related to automation frame work

Project# 4

Conversion

Client

Blackboard Inc – Washington, DC

Domain

e-Learning

Project Duration

Jul’ 2011 to Jan’ 2013

Tools/Technologies

Selenium, JIRA, Silk Central, Fitnesse Tool, Eclipse

Project Description: Blackboard Inc. is an enterprise software company with its corporate headquarters in Washington, D.C. and is primarily known as a developer of education software, in particular learning management systems. The company provides education, mobile, communication, and commerce software and related services to clients including education providers, corporations and government organizations.

BB Conversion: Convert manual test plans of Black Board web application into automation scripts using FitNesse and Selenium automation tools. FitNesse is a web server which allows users to enter specially formatted input in FitNesse editor (Eclipse) in the form of wiki pages. This input is interpreted and executed by the test engine (Selenium) and test fixture, which is invoked by the testing engine in turn, invokes the system under test and output is returned back to the user.

Responsibilities:

Automate the manual test cases using the tool Fitnesse and wiki language

writing and executing test plans, test scripts, test scenarios, and test cases for both automated nd manual testing needs

Identify application components using Selenium IDE, Firebug and prepare Xpaths

Prepare scripts using FitNesse classes(fixtures)

Log and track Application defects as well as FitNesse Issues using Defect Management Tool JIRA

Debug and Promote successfully executed test scripts into AXMAN (Automated Execution Monitoring Asynchronous Network)

Perform the root cause analysis and identify the bug/error in test scripts failed in Axman.

Project# 5

Regression Automation Adjustments

Client

Medco – Franklin Lakes, NJ

Domain

Health Care

Project Duration

Jan’ 2010 to Jun’ 2011

Environment

Mainframes, PEGA, QTP, Teradata

Tools/Technologies

JCL, VSAM, Teradata, QTP, HCLS Tools

Project Description: Medco Health Solutions, Inc (NYSE: MHS) is a health care company currently serving the needs of more than 65 million people. Medco provides pharmacy services for private and public employers, health plans, labour unions, government agencies, and individuals served by Medicare Part D Prescription Drug Plans. Medco is a third-party administrator of prescription drug programs. They are primarily responsible for processing and paying prescription drug claims. They also are responsible for developing and maintaining the formulary, contracting with pharmacies, and negotiating discounts and rebates with drug manufacturers. Today, more than 210 million Americans nationwide receive drug benefits administered by PBMs.

RA-Adjustments: Identifies the reasons for any differences, or adjustments, between the original provider charge for a claim or service and the payer’s payment for it. The adjustments are identified by reason codes to communicate an adjustment, meaning that they must communicate why a claim or service line was paid differently than it was billed. If there is no adjustment to a claim/line, then there is no adjustment reason code.

Responsibilities:

Involved in requirement analysis, Test data identification, Testing tools and Applications

Thoroughly Involved in KT sessions regarding tests to be prepared and automated

Analyzed, prepared and executed the test cases end to end in Mainframe

Preparation of test data

Customized the JCL jobs as per the environment.

Designed the test case flow to develop the test scripts.

Executed and Debug the entire automated test scripts.

Prepared the User guide documents for all the automated test scripts and shared with the customer

Organized deliverable regarding the automated test scripts.

Resolved the issue and maintain the scripts till the end of project.

Prepared Teradata IW Queries to verify the results.

Project #6

Farmers All Lines Billing

Client

Farmers Insurance – Los Angeles, CA

Domain

Insurance

Project Duration

Dec’ 2008 to Dec’ 2009

Environment

Mainframes

Tools/Technologies

JOBTRAC, STROBE, FILE-AID, ENDEAVOR, BETA, SPUFI, QMF.

Project Description: The Farmers Insurance Group of Companies is a personal lines property and casualty insurance group providing auto, life and homeowners insurance services and financial services in the United States. It is the third largest insurance group in the US servicing over 10 million households in 41 states. Farmers Group Inc. is headquartered in Los Angeles and California but is 100% own by Zurich Financial services based in Zurich, Switzerland.

The project is about the ACP - Automated Conversion Project. This ACP solution is meant for migrating the in-force policies from the legacy billing system to FS-CD billing system. This solution involves the batch jobs that download the data from production and push the policies via ALSB, R2P to SAP FS-CD.

The objective of the automated mechanical conversion project is to successfully convert all qualifying Farmers Personal Lines policies from the old Billing Systems (ASB, FSB, Easy pay) to the new FAB Billing System through an automated process.

Responsibilities:

Interacting with the Client Department and gathering their requirements for customizing the application to meet their needs.

Involved throughout the testing life cycle, requirements gathering test design and review, through the development and the testing process to customer implementation.

Analysis of the specifications provided by the clients.

Customizing the JOBs as per the test region.

Code analysis and updates as per the latest functional business rules

Preparing detail level design documents.

Test case preparation, Test case execution and Debugging.

Maintaining Coding Standards.

Configuration Management and Version Control using Version Control Management (VCM) tools.

Issue analysis and resolution.

Reporting and tracking of Defects along with defect analysis

Project# 7

CMA-CRN Redesign

Client

Farmers Insurance – Simi Valley, CA

Domain

Insurance

Project Duration

Mar’ 2008 to Dec’ 2008

Environment

Mainframes, QC

Tools/Technologies

JCL, DB2

Project Description: Customer Restoration Network (CRN) is Farmer’s primary Claims system, supporting the Claims business. It is a distributed Siebel claims processing application supported by legacy mainframe applications, which connect Farmers’ vendors, employees, business customers, agents, insured customers, and systems into one holistic, integrated and interdependent environment. As part of the Claims IT Roadmap, the CRN system is built on Siebel 6.0 and related upstream and downstream systems and integrations are being redesigned under the “CRN Redesign” initiative with Siebel 8.0 as the centrepiece of this effort. This is a strategic initiative and its success is critical to Farmers. This program is intended to support the Claims business.

This Project has mainly 4 phases.

1.Data Migration (DM): To migrate the data from existing FACTS database (IMS segments) to New FE data base (DB2)

2.Data Sync(DS): To verify if the data in the Existing Siebel-6 system is in Sync with the New System-8 and whether all the business rules are applied.

3.CMA (Functional): This Phase mainly deals with the New system for siebel-8(front end) and FE (DB2) where in the cycle starts with creating a claim in front-end (Siebel-8) and making some financial transactions and then validating the FE (DB2) tables.

4.Down Stream Testing (DST): This phase mainly deals with all the functionality of the Functional, Data Migration and Data Sync where the data is created in Seibel-6, Seibel-8 and then all Seibel-6 claims is migrated to Seibel-8 and is made Sync with the existing data by running a Delta Mainframe Job, to make the claim available in Sieble-8. The flow is involved to send the files to CITI Bank with related Payments and amounts that the customer and Farmers have to pay. The files and reports are generated by executing the Mainframe Jobs and the data validation is made with respect to the related DB2 Tables and files with predefined business rules.

Responsibilities:

Involved throughout the testing life cycle, requirements gathering test design and review, through the development and the testing process to customer implementation.

Analyzed system requirements specifications, developed Test Strategy, Test plans, Test Cases, Test Data for testing the functionality, GUI, Compatibility, performance, usability and User Acceptance of the application.

Wrote SQL Joins, Unions and Nested Queries on various data tables for Data validation.

Coordinating with the Onsite Coordinator for understanding the new requirements.

Involved in preparing detailed Test Strategy, Test Plans – Test Conditions, Cases

Testing - unit testing & integration testing

Involved in the End-To-End Testing of the interface.

Reporting and tracking of Defects along with defect analysis

Coordinating and Communicating with on-site team regarding the test status reporting.

Responsible for overseeing the Quality procedures related to the project.

Tracking and reporting the project status on a weekly basis and working towards various milestones of the project.

Contact this candidate