Avinash Goud Athelli

E: adcvb4@r.postjobfree.com c: 612-***-****

https://www.linkedin.com/in/avinash-a-82a91b20

Professional Summary

An experienced Test Consultant with 9 years of Software Testing experience. Analytical approach to problem solving with excellent interpersonal skills, proven skills in creating Test plans, Test cases, test strategy and execution of all test cases.

Over 5 years of experience in leading & managing QA teams & vendor teams in different time zones.

Over 6+ years of experience working in Agile projects across multiple scrum teams and usage of various tools like rally, version-one and TFS.

Expertise in manual and automated testing using QC, Quick test pro, UFT, TFS, Selenium Web driver & Visual Studio Code.

Tested WebServices /XML / SOAP and RESTFul services using SoapUI tool.

Expert in QA Processes, SDLC and delivery of quality software, products, systems, and applications to meet business, market and customer need.

Strong knowledge of Testing Automation, Web, and Client/Server based Commercial Applications.

Experience in creating and executing very large and complex End to End Test Scripts across different application Interfaces both Automated and Manual.

Proficient experience in User Acceptance Testing (UAT) & Business acceptance testing (BAT).

Expertise in writing, maintaining, executing test plans, test cases and test scripts, analyzing bugs and interacting with team members in fixing the errors

Exposure to varied fields like Retail Automation, Property and Casualty Insurance, Banking, Mortgage Banking, Auto Insurance, Small Commercial, Life, Annuities & Legal, Capital markets & Trading tools.

Expert in developing Behavior Driven Development(BDD/TDD/ATDD)by writing Gherkin language using cucumber tool, developed Scenarios, Scenario outlines, features and Step definitions and generating the cucumber reports.

Hands on experience in execution of Coded UI Scripts using Visual studio 2015.

Hands on experience in scripting BDD scripts using VSC with typescript.

Experience working with software development methodologies - Agile, Waterfall & Kan-ban.

Experience working as a QA lead with both Onsite-Offshore model and at Onsite.

Hands on experience in version control systems like GitHub and knowldge on configuring and integrating Automation scripts on Continuous Integration tools (CI/CD) like Jenkins for nightly test suit execution

Extensive experience in functional, unit, integration, regression testing and mobile testing in different stage of Software Development Life Cycle.

Thorough understanding of DevOps process and best practices

Exposure to Unix scripting technologies (Bash and Perl)

Good experience as a Test Lead for successfully delivered projects and able to work in a team environment and individually with minimal supervision.

Mobile cross platform functional testing for Android and IOS.

Knowledge on performance testing tools like Jmeter & Gatling.

Ability to interact with all levels of personnel from technical to high level executive management, Excellent interpersonal, communication & writing skills.

Proven ability to Assure Quality Project/Product in on time and on budget.

Familiarity with web service concepts, REST, SOAP, and XML/JSON business object representations.

Deep understanding of Equities, ETFs and working knowledge of trade execution for these securities.

EDUCATION

1.Masters (M.S) in Engineering from Texas A & M University 2010

2.Bachelor in Technology (B. Tech) in Mechanical Engineering from Gokaraju Rangaraju Institute of Engineering & Technology- India 2006

SKILLS

Testing Tools

UFT, Quick Test Pro 10, Quality Center, ALM, UFT, Visual studio, TFS, MTM, Visual Studio Code, JIRA

Operating Systems

UNIX, Windows 9x/NT/2000/XP, Mac OS 8.

Languages

Advance COBOL, C, SQL, Java, Quick Basic,

VB Script, SQA Basic, T-SQL, PL/SQL,

Web Languages

VB.Net, Java Applets, HTML, DHTML, ASP, JSP, PERL, Java Script, DHTML, XML, C Sharp, Typescript

Databases

Oracle, Sybase, SQL Server 2000

Project Management Tools

MS Office 2003/XP, Microsoft Project 2000

PROJECTS:

Client: Wells Fargo Advisors Charlotte, NC Aug 2019 – March 2020

Senior UAT Analyst

About Wells Fargo Advisors Wells Fargo Advisors is a subsidiary of Wells Fargo, located in St Louis, Missouri. It is the ninth largest brokerage firm in the United States as of August 17, 2017 with $490 billion retail client assets under management.

Project Abstract:

Consolidated Audit Trail (CAT) reporting is a regulatory requirement and will be available to all client firms that process on the BETA System. The Consolidated Audit Trail will track orders throughout their life cycle and identify the broker-dealers handling them, thus allowing regulators to more efficiently track activity in Eligible Securities throughout the U.S. markets.

The primary goal of Securities and Exchange Commission (SEC) Rule 613 is to improve the ability of the SEC and the Self-Regulatory Organizations (SROs) to oversee trading in the US securities markets. Once implemented, CAT will run parallel with OATS (Order Audit Trail), Electronic Blue Sheets (EBS), and Large Trader (LT) reporting until FINRA (and the SEC (EBS, LT)) determines that the quality and accuracy of the CAT data is enough to retire these existing reporting systems.

Roles & Responsibilities:

Test planning & test execution to run the testing activities within the timelines and help in resolving queries through meetings with project team & product owners as required.

Development of the UAT test strategy.

Development of a UAT test plan including test cases and scenarios, technical specification document and detailed test schedule.

Write test scripts including detailed manual steps and execute test scripts in ALM.

Fully document all testing results, including defect tracking and root cause analysis, to be summarized into UAT test results artifact.

Oversee the testing effort and defect management process for the project/package as it relates to your work stream.

Log issues found in UAT testing in JIRA for internal tracking and ensure that the same defect is logged in client portal.

Ensure business partner involvement in Test Plan development, execution, verification, problem resolution, and approval of coding changes that impact UAT.

Provide information needed for documenting UAT in the Project/Master Test Plan.

Good understanding of the pre and post trade.

Ensure traceability is completed for the relevant test scripts.

Good understanding of various equity trading work flows and end to end trade origination’s.

Assist test teams with identifying test data requests.

Trade execution of equities/options in various trade applications like Beta, Smart station, e-brokerage and Tradeport.

CATS report validation using various tools like Refinitiv CAT UI, FIS protegent tool and comparison of results with Wisdom CAT reports.

Perform industry testing as per the CAT specification document and log issues in ALM.

Client: Amtrak Charlotte, NC April 2019 – Aug 2019

Senior Quality Assurance Analyst

About Amtrak

Amtrak’s mission is to deliver intercity transportation that helps move people, the economy and the nation forward. Amtrak is advancing its goal of being America’s preferred mode of travel by running an efficient and effective business, modernizing the customer experience, and investing in infrastructure, rolling stock, stations and support facilities.

Amtrak is a federally chartered corporation, with the federal government as majority stockholder.

Project Abstract:

To implement the Unified Matters Management System (UMMS) is the initiative for the Amtrak Law department. Amtrak is seeking an ELM vendor that can provide the software product, perform the requisite historic data migration and execute the implementation and associated support services for this platform.

Roles & Responsibilities:

Test planning & test execution to run the testing activities within the timelines and help in resolving queries through meetings with project team & product owners as required.

Preparing test design, high level scenarios & requirement traceability matrix based on the business required documents provided by business.

Writing test cases in Gherkin format and reviewing it with the project team.

Perform In sprint Automation using BDD driven test framework from the scenarios prepared as per the acceptance criteria.

Maintain Code versions through Code check in Github, performing peer code reviews and maintain re-usable code in common functions.

Prepare test data in Json format and drive the Automation execution with the test data prepared.

Documenting common failures and resolution so that other team members can benefit.

Contribute to the maintenance and improvement of the current Automation framework.

Ownership of test data and test data readiness so that same test data can be used for Automation execution across multiple environments.

Preparation of various test metrics and dashboards to represent the test execution status.

MQ testing and verifying that there are no XML message format issues.

Testing of queues using RabbitMq.

Created and maintained manual test cases for the Office companion app to test the app in both IOS and Android platforms and also on other ipad devices.

Perform mobile testing of the app in multiple android and iphone devices.

Document defects with required screenshots and all the details on steps to reproduce.

Reporting of defects in HP ALM, following up with project team on defect resolution, defect retest & closure.

Ownership of test design and prioritizing testing activities.

Develop regression test suite and perform regression testing whenever new code is deployed or any major defect fixes have been made.

Client: The Hartford Insurance Charlotte, NC July 2018 – March 2019

Position: SDAT

About The Hartford Insurance:

The Hartford Insurance Company founded in 1810 is one of the largest investment and insurance companies in the U.S and headquartered in Hartford, Connecticut. The Hartford is a leading provider of investment products – annuities, mutual funds, college savings plans – as well as life insurance, group and employee benefits, automobile and homeowners' insurance and business insurance.

Project Abstract:

EBC APDM (Electronic business center – Agent Portal Digital modernization) is rewrite project to rewrite the existing agent portal to accommodate latest technology in the market to provide “one distribution partner experience with one set of keys to the Hartford’s agents / producer functions and unified content which is public and secure. This is project is being operated in Agile mode along with modern digital architecture and tools will enable greater agility to adapt to marketplace changes and user preferences as well as increased speed to market for testing, adapting and delivering new capabilities with reduced execution risk and the project will be executed with different scrum teams to achieve extensive agility.

Roles & Responsibilities:

Involved in writing functions & developing automation frame work to support behavior driven development methodology to align with the EBC- APDM agile project.

Used Gherkin language to write the scenarios, and working on enhancing the page object model framework.

Participating in the program iteration PI planning meetings & refinement meetings, to gather and contribute on the project road map.

Test planning & co-ordination with Offshore QA testers & project stakeholders to run the testing activities within the timelines and help in resolving queries through meetings with project team & product owners as required.

Responsible for the maintenance of the Automation regression suite during every sprint to make sure the regression suit is up to date to align with recent application changes.

Perform In-sprint Automation as per the tasks assigned during sprint planning meeting.

Execution of Automation scripts across various environments – Dev region during in sprint testing, QA region during integration testing and Prod region during production day testing.

Extensive usage of SOAP UI for creation of test data and Toad(Oracle) as required.

Restful API testing using SOAP UI.

Usage of GitHub desktop to check in the code and VSC to write the test scripts in Gherkin format.

Work with development team to Continuously improve DevOps methods, procedures, processes, and tools setup.

Will be responsible for testing the application in pre- production regions and also in production regions on release date to make sure that there is bug free release to production.

Implemented BDD through Cucumber.

Perform both manual and automated test using Selenium and Appium on mobile devices covering Android Phones, iPhones, Android Tablets, iPads, Windows Phones and desktop.

Used UI Automator viewer in Appium to inspect elements in mobile applications.

Knowledge of CI/CD pipelines so that each commit a developer makes will go through standard process of software lifecycle and gets tested well enough before it can make it to the production.

Responsible for maintaining Test Automation Framework with Selenium.

Responsible for creating Json for test scenarios.

Involved in WebServices Testing using soapUI tool. Validated request and response XML

Bug reporting and tracking through rally.

Create defect summary documentation for each release.

Responsible for monitoring the testing activities and showcase the QA metrics to the project management to give them better understanding on project current state to make key decisions.

Perform mobile testing on various devices and test the functionality in ipad devices.

Provide knowledge transition to other scrum teams on the key functionalities implemented in production.

Guide other QA members on the release execution plan/testing, production checkout walkthrough scenarios with business and scrum teams and assisting other QA members on prod day testing.

Client: Cuna Mutual Group,Waverly, IA Apr 2016- July 2018

Position: Senior Testing Analyst

About Cuna Mutual Group

CUNA Mutual Group is a mutual insurance company that provides financial services to cooperatives, credit unions, their members, and other customers worldwide. CUNA Mutual Group sells commercial and consumer insurance and protection products.

CUNA Mutual Group provides retirement plan services to small businesses and credit union employees. The Madison, Wisconsin-based company also provides auto, home, life and loan protection products to credit union members through its TruStage brand.

Project Abstract:

The primary focus of the LIfepro Bus Ops Functional project is to develop new functional enhancements related to lifepro Admin system, handle EXL IR’s, retrofit the code & perform required testing before the code gets deployed to Prod.

Roles & Responsibilities:

Go over project requirements, Prepare Test Strategy, test plan and testing effort estimations.

Provide estimations for new testing engagements.

Perform On-site Test Lead responsibilities & Co-ordinate with client project team, Business team and offshore test team throughout the project.

Created QA dashboard in TFS to effectively communicate test status to the project team and management.

Accountable for oversight and reporting of team’s test execution to project team & business.

Ensured adherence to Testing Standards & framework.

Command Line execution in Unix/Linux.

Review the issues logged by offshore team; discuss them with the stakeholders & business as required & logging defects in TFS.

Performed native mobile app testing on IOS and Android

Effectively participate in cross-platform and cross-browser testing of all responsive design web-sties in Mobile phones and tablets, verifying page layout meets the design specifications and identifying key issues.

Participate in interview process to select the right candidates for the ongoing project.

Tested the Application in different Web Browsers and on Multiple Platforms-UNIX, Linux and Windows.

Tracking defects to closure, working with development teams to establish defect validity, cause and retesting as required.

Tested Web Services, Validated Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI tool.

Performed E2E Testing on ACT (Allocation change & Transfer) tool. Through ACT tool Owner of a MEMBERS Horizon (MH) and/or MEMBERS Zone (MZ) contract can request allocation changes (MH & MZ) and/or transfers requests (MH only) on the contract(s).

Experience in working with remote (offshore) QA members & completion of project as per the time lines.

Involved in testing Annuity Net Application (Annuities) which is used by servicing agents of Cuna.

Tested embedded application software on various mobile devices, including smart phones and tablets

Execute balancing scrips using Visual studio to check whether the Lifepro System is in balance.

Writing test scripts in Visual studio for the regression and new business functionalities using C# as the coding language.

Working knowledge of load generation and measurement software such as JMeter & Gatling.

Knowledge on Job scheduling and scripting for UC4.

Troubleshooting issues encountered during e2e testing.

Maintenance of the craft Automation framework and implementing best practices as required from the feedback of the client.

Execute smoke test scripts as required & when new IR’s get deployed to the QA demo environment.

Review Automation regression execution performed by offshore & maintain regression automation suite.

Technologies: Visual studio 2015, Coded UI, TFS, MTM, SQL Server, Java

Client: Capital One, Plano, TX Nov 2013- Mar 2016

Senior SENIOR TEST ENGINEER/UAT Lead

About CapitalOne:

ENGINEER/UAT Lead

About CapitalOne:

Capital One Financial Corporation is a bank holding company specializing in credit cards, auto loans, banking and savings products headquartered in McLean, Virginia. The company offers various non-interest bearing and interest-bearing deposits, including demand deposits, money market deposits, negotiable order of withdrawal accounts, savings accounts, certificates of deposit, foreign time deposits, and other consumer time deposits. Its loan portfolio consists of credit card loans; consumer loans, such as automobile, home, and retail banking loans; and commercial loans, including commercial and multifamily real estate, middle market, specialty lending, and small-ticket commercial real estate loan.

Project Abstract:

The Capital One Loan Origination System (CLO) deals with the underwriting and funding processes for auto loans. An auto loan application can come into the CLO system through various ways because of this the origination process is split into two main lines of business that are treated differently i.e direct and dealer line of business. The system was developed using Agile Methodology as part of the Project and Delivery management portfolio that provides agile expertise to all projects. As part of Agile-application development was carried out in different iteration and regular review meeting and discussion were held with the customer and application development team on successful delivery of single iteration

Roles & Responsibilities:

Test Execution for the assigned module /product area, Responsible for execution of Manual and Automated test cases.

Responsible for Test Execution, Test case development (automated/manual), modifications / enhancements, test case review, end to end support for simple applications and for reporting bugs and test bed issues.

Timely completion of creation of test cases, test case review, test case writing and execution to complete the sprint commitments as planned, and accurate burn down of hours in version one.

Giving demos to Product owner and other team members on all the use cases related to acceptance criteria and helping out in closing the user story as planned.

Performing regression execution, creating regression test cases and covering the end to end application flow in integration testing for every release.

Knowledge using Test Driven Development approaches (TDD, BDD)

Worked on testing and reporting the defects on enhancements of Route one UI which is a .net based application.

Working experience on power shell and Bash.

Strong domain knowledge on Auto loans on both direct and dealer line of business

Performing xml and web service testing using test harness tool which enabled in comparing results across different environments and saving time instead of directly hitting the proxy web service.

Expertize in using dealer web applications like dealertrack and routeone.

Implemented ATDD Cucumber framework for Automating web applications and webservices.

Tested RouteOne Contracts using SOAPUI.

Restful API testing using SOAP UI & Postman.

Generated test data sets using input json data and verified that the output is correct using Postman.

Familiarity using different web service concepts, REST, SOAP, and XML/JSON, CURL business object representations

Hands on experience in using Putty and Control M for scheduling Hadoop batch jobs and other LO batch jobs.

Initiated Change Requests (CRs) as appropriate to capture defects and enhancements identified during the testing process.

Working knowledge of Cassandra data base system.

Technologies: UFT 12.5, VB script, SQL Server, Share Point, SOAP UI, Java & Cucumber.

Client: US BANK Corporation, Richfield, MN Aug 2012- Oct 2013

Position: Agile Automation Tester

About US Bank Corporation:

U.S. Bancorp is a diversified financial services holding company, headquartered in Minneapolis, Minnesota. It is the parent company of U.S. Bank, the fifth largest commercial bank in the United States. U.S. Bank ranks as the sixth largest bank in the U.S. based on deposits. U.S. Bancorp offers regional consumer and business. banking and wealth management services, national wholesale and trust services and global payments services to more than 15.8 million customers.

Project Abstract:

The project involves web-based automation of end-to-end functionality with HP- QuickTestProfessional-10.0 (QTP), using native object repository mechanism and advanced descriptive programming. It includes design & development of automation scripts for manual test suites. It involves understanding the application workflows, gathering test data as well as enhancing the existing QTP standard framework. The project is phased into deliverables set for periodic milestones and would further extend into maintenance support activities for the automation in place.

Roles & Responsibilities:

Review manual test cases provided by ETM testers.

Understand the test automation scope and formulate the design & approach.

Analyze the existing test suite and estimate test automation efforts.

Prepare Automation workflows, develop & implement automation test scripts.

Participating in Agile Sprint planning meetings and planning the tasks to complete the Automation development on time.

Developing and maintaining test automation frameworks and automated test scripts using HP’s Quick Test Professional within the agile project/sprint.

Developing and executing automation and manual scripts using HP Quick Test Professional and Quality Center in various environments

Worked on single point sale .net application which includes enhancements for the sales and origination of customers in various categories like ACH, Credit etc.

Debugging the scripts and handling over the scripts to the execution team with successful completion of each sprint.

Performed Mobile Compatibility testing and Mobile application testing - iPhone, iPads /tablets.

Test results, status reporting to Project Manager.

Mentor other engineers in the team as needed & Organizing internal trainings on various products.

Technologies: Mercury Tools (QuickTestPro10.0, Quality Center 10.0) VB script,SQL Server, Share Point, MS Excel, MS Access.

Client: JP Morgan Chase New York, DL Sep 2011- July 2012

Position: Retail Automation Tester

About JP Morgan Chase

JP Morgan Chase is a leading global financial services firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, Mortgage and private equity.

Project Abstract:

JP Morgan Chase has several applications which are used for end to end maintenance of Retail Loan Originations. The project focus is to support automated, manual and functional executions of various mortgage applications like Loan builder, Closr and Zippy which help in loan origination, processing, underwriting and finally loan closing.

Roles & Responsibilities:

QTP had been used for testing and automation maintenance.

Reviewed Business Design Specification Scenarios, and Technical Specifications.

Report the defects and work with development team to fix issues.

Made Test cases for all the functionalities of the web application and identified the once which could be automated

Build queries for the loan origination, processing, underwriting

Defect tracking, requirement gathering, planning, analyzing results, storing and executing automation and manual scripts using HP Quality Center

To capture all the requirements and enhancements required of Closr Automation to process end to end flow from Loan builder to CLOSR for all kinds of loans

Performing End to End Flow smoke testing in different environments for each build.

Executed various mortgage component test cases and review the results by comparing the actual results again the expected results.

Implementation, execution and training for .net based application Assure, which is a self-service automation tool for executing various automation requests of end users.

To debug and resolve issues if any end users face any issues while staging loans through Assure

Participating in defining Automation strategy and applying appropriate automation technologies to meet the short and long term goals of Retail Automation in Mortgage banking, developing and maintaining test automation frameworks, solutions and automated test scripts using HP’s Quick Test Professional.

Evaluating test processes and procedures and making recommendations for improvement.

Execution of various mortgage components like Trillium, credit etc using Assure Mortgage Comp Release and looking for issues.

To support Zippy Work Bench dry run and executions.

Working knowledge of Chase File Manager (CFM)

To interact with the offshore team and arrange meetings as required to check the status of tasks accomplished and to meet the required automation deadlines.

Technologies: Mercury Tools(QuickTestPro10.0,Quality Center 10.0),Net, XML, HTML, VB script,Unix, SQL Server, Share Point, Windows XP Professional, MS Excel, MSWord.

Client: Horace Mann Insurance, Springfield, IL May 2011- Aug 2011

Position: Quality AnalystAbout Horace Mann Insurance

Horace Mann is an Illinois-based auto, property, and life insurance, as well as financial services company that emphasizes on retirement annuities and mutual funds. Horace Mann primarily works with educators and their families.

Project Abstract:

Horace Mann (HM) is replacing its old legacy maintenance intensive P&C Systems with a 3rd Party, Canned P&C Product Application to better serve customer needs. It takes too long to react to current business needs within Horace Mann. The P&C Group would like to replace these systems with a solution that reduces cost of maintenance and increases functionality. This project handles the new business and support features that are currently used in existing field automation system. This includes a new workflow that automatically accesses 3rd party calls along with interfaces required to support the new proce

Roles & Responsibilities:

Modified scripts for .NET and DCT applications.

Created business scenarios using requirements

Involved in reviewing and updating test data

Involved in auditing integration testing

Involved in reviewing the policies at the backend (ANBR testing).

Involved in Mainframe testing.

Performed Back end testing, and hands on experience in ETL Process.

Validating the data to see if it is transformed correctly.

Involved in load and performance testing

Used JIRA tool for tracking defects encountered in UAT testing.

Used and updated local data base

Involved in UAT’s and interacted with business users.

Involved in all the different cycles of UAT testing which include creating regression score card and defect score card and updating the defects in quality center

Helped determining how quality testing can be accomplished and provided the solutions for quality and error free product to be deployed in production environment.

Working knowledge of P & C Insurance policies provided by Horacemann.

Worked in production environment

Involved in testing application under different contexts such as CSR, HOA…

Used QTP for testing and automation.

Used Quality center for Defect tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.

Involved in different testing phases using testing tools

Technologies: Mercury Tools(QuickTestPro9.2, Quality Center 9.2), .Net, XML, HTML, Soap, VB script,Unix, SQL, Windows XP Professional, MS Excel, MSWord.

Contact this candidate