Rama

ac4bw4@r.postjobfree.com

848-***-****

Status: GC (Permanent Resident)

Will work on W2

Professional Summary:

Over all 7+ years of experience in Quality Assurance, Automation QA, DWH Testing, ETL and Software Testing.

IT industry experience in Banking, Financial, Health Insurance & Mortgage industries with strong Business and Functional knowledge.

Experience in handling web-based, client-server, Mobile application and desktop based applications.

Strong expertise in all phases of SDLC and STLC Including initiation collecting requirements, planning testing process, test automation and execution, analyzing and reporting results, and managing defects.

Experience in reviewing of Business Requirements Document (BRD), Functional Specification Document (FSD), and System Technical Document (SD).

Proficient in developing solid QA documentation of all complexity levels: Test Plans, Test Cases, Test Summary report and Traceability matrix.

Experience in working with open source tools such as Selenium (Selenium IDE, Selenium Web Driver and Selenium Grid), Soap UI, JUnit, JIRA and Eclipse.

Experience in preparing and maintaining Automation Frameworks (Record/Playback, Data Driven and Page Objects).

Performed Continuous Integration (CI) using Jenkins for scheduling the jobs using Jenkins, GIT, TestNG, and Maven. Develops and analyzes business performance reports (e.g. for claims data, provider data, utilization data) and provides notations of performance deviations and anomalies.

Creates and publishes periodic reports, as well as any necessary ad hoc reports.

Experience in taking business issue and devising best way to develop appropriate diagnostic and/or tracking data that will translate business requirements into usable decision support tools.

Performed Functional, Integration, Regression, End to End, Smoke testing and User Acceptance Testing (UAT).

Functional/technical testing experience with sales quote tools, contract lifecycle management tools.

Excellent knowledge of Agile & Scrum development environment, multiple web browsers.

Solid knowledge of testing methodologies, software technical documentation analysis, test documentation design & development (test plans, test cases), test execution & results analysis, defects management and reporting.

Experience in testing web and desktop applications, manual testing, black box testing, functional, GUI, regression, user acceptance testing, verification and validation.

Solid expertise in designing SQL queries, relational databases, reports, data analysis and management.

Experience with Cross-Browser and Compatibility Testing to test whether the web applications are working as desired in different browsers and environments.

Experienced in Back-End testing to ensure data consistency on front-end by writing and executing SQL queries for data validation using advanced TestNG annotation Data Provider for code reusability and Java JDBC for retrieving the Data.

Performed Continuous Integration of code and scripts using Jenkins and triggered the Continuous Delivery process using Jenkins build jobs.

Expertise in Oracle table data manipulation using SQL queries and UNIX commands/UNIX scripts.

Experience with manual and automation methodologies used for software testing.

Experience in developing Test scenarios, Test cases, Test data, Test procedures, Test reports, Test Summary report, Traceability matrix and documenting Manual and Automation Testing.

Experience & diverse background in software testing, software development, and infrastructure management (Cloud, hosting, or systems integration)

Experienced in using Test Management and bug reporting tools such as QC, Rally, JIRA and Bugzilla to track test progress, execution and deliverables Highly motivated team player able to work on a variety of projects and project styles.

Experience with relational databases and knowledge of query tools and statistical software is required. Ability to manipulate large sets of data is also required.

Excellent knowledge in Core Java and OOPS concepts required for Selenium frameworks.

Strong Presentation, written and verbal communication skills

TECHNICAL SKILLS:

Testing Tools:

HP ALM/Quality Center 12.5, Selenium Web Driver/IDE, Rally, Putty, HP Quality Center, Firebug, Web Services, Jenkins, Maven.

Bug Reporting Tools:

Test Director, JIRA,ALM, Clear Quest

ETL Tools:

Informatics, SQL Server2008/20012, Toad

Operating System:

LINUX, UNIX, Windows 10/07/08/XP, Mac OS

Web Technologies:

Web API, SOAP, XML, RESTful Services, Java Script and HTML, CSS, XPath.

Programming Languages:

Core Java, HTML, Eclipse, SQL Developer, IBM Rational Application Developer, Java Script

Microsoft Tools:

MS Word, MS Excel, MS PowerPoint, MS Outlook, MS OneNote, MS Visual Studio, MS SQL Server Management Tools

Professional Experience:

Wells Fargo, Charlotte, NC Sept 2016 – Current

System QA Analyst

Wells Fargo Home Mortgage is the largest retail mortgage lender in the United States that provides different types of mortgage services to the different types of customers. Currently, I am part of CORE QA Team.

The project I am currently working on is a web-based application which involves mortgage loan origination process from the origination of mortgage application through funding/closing. The system performs all the business functions of the loan process such as setting-up Account information, New Loan set-up, Credit, Pricing, Appraisal and Income. The project involves modules for Pre Approval, Pricing, Processing and Closing/Funding.

Responsibilities:

Attended Sprint Grooming, Planning, Stand ups, and Retrospectives and was actively involved with the agile team.

Tracked features, user stories, tasks, and defects with Rally.

Assisted in updating Acceptance Criteria based on new discoveries and requirement changes by the client.

Designed and documented Test Plan, Test Cases, Test Scenarios, and Test Strategies based on business requirements and design documents.

Worked with Developers, Business Analysts and Test Leads to verify create and execute the Test Cases and fill up the requirement gaps.

Create test cases, configured and parameterize data, if needed, based on Business requirement, used cases and the document provided by Business Analyst.

Execute negative and positive test cases and logged the defect in JIRA. Followed up the defect in status meeting and re-test, closed after fixed.

Conditioned and prepared test data for the Automation testing team and supported them in understanding the functionalities of the application.

Executed the test in multiple environments (QA01, UAT, DEV and Production) to ensure the requirements were met.

Developed automated test scripts for performing regression testing on the application using HP ALM.

Responsible for Functional, Regression and User Acceptance testing - coordinated UAT testing

Performed Functional Testing and Back-end Testing using the database comparable results Manually.

Involved in Pipeline, Functional, End to End, Regression testing and Smoke Testing for the past three releases.

Performed Continuous Integration of code and scripts using Jenkins and triggered the Continuous Delivery process using Jenkins build jobs.

Created Selenium Test cases for automation using Selenium Web Driver and Java.

Performed agile testing, reviewed the stories and participated in Daily Scrum, Iteration Planning and Release Planning meeting.

Extensively worked in Regression testing, Parallel Processing using Selenium Webdriver.

Developed test scripts for Web elements by identifying the locators using FireBug and FirePath Firefox plugins.

Used Snag It to capture image, edit it/input notes. Used Selenium Screenshots for bug reporting

Identified correct GUI elements using various Selenium Locators like ID, Name, Link Text, Partial Link Text, XPath, CSS, and DOM in creating automation scripts.

Configured application framework using Excel spreadsheets and processed the spreadsheets using Apache POI.

Performed Continuous Integration (CI) using Jenkins for scheduling the jobs using Jenkins, GIT, TestNG, and Maven.

Develops and analyzes business performance reports (e.g. for claims data, provider data, utilization data) and provides notations of performance deviations and anomalies.

Creates and publishes periodic reports, as well as any necessary ad hoc reports.

Experience in taking business issue and devising best way to develop appropriate diagnostic and/or tracking data that will translate business requirements into usable decision support tools.

Executed testcases in cucumber tool.

Executed the automated regression test cases during every release and also executed the daily regression test suites .

Participated in peer review with team and developers to review test cases/test scripts.

Regression testing was performed after each build release of the application and updated the Scripts by executing the Regression suites built using Selenium and approve for regression suite.

Created Selenium Test cases for automation using Selenium Web Driver and Java.

Worked on different tools and software such as HP ALM, JIRA, HULA, XML BLOB mapping, UCD, your loan tracker (YTL) for writing script, executed test cases, logged defect and mapping data.

Environment: Windows 07/08, XML BLOB mapping, Selenium WebDriver, Cucumber, Visio, UCD, Your loan tracker(YTL), Test Director/Quality Center 12.0, HP ALM, JIRA, UNIX, Agile/Scrum, Jenkins/Maven.

Ally Bank, Charlotte, NC April 2014 – Aug-2016

QA Analyst

Ally Bank is one of the largest well-known financial companies. The company, which has operations throughout the United States, and Canada, also provides retail deposit, consumer loans, and credit cards. Worked as a QA analyst on the following products: commodities, loan, derivatives, trading, Stock, mutual fund, option, fixed income, bond and Real Estate Portfolio Management Worked extensively with the real time trading applications, which clients can use to do trade.

Responsibilities:

Participate in requirement review question/answer session and contribute in requirement gathering, clarification, consistency and completeness.

Attend iteration planning meeting to size up the stories with points, break out the requirement, to estimate tasks and testing effort in completing product backlog within the current iteration timeframe and team velocity.

Experience in testing with high-traffic websites.

Understood the E-tail business processes such as marketing, merchandising, payment processing, logistics, reverse logistics, and customer service.

Prepare test plan/test cases from the user stories, use cases, business and system requirement (SRS).

Prepare test machines and deploy builds, execute test cases, bug reporting and resolving issues by pairing up with the developers.

Worked on core java, using file operations to read system file (downloads) and to present on JSP.

Created a deployment procedure utilizing Jenkins CI to run the unit tests.

Worked with core java concepts like Collections, Multithreading, and Memory management.

Involved in implementing the database connectivity using JDBC with Oracle database as backend.

Worked on automated test scripts for functional and regression testing using Selenium WebDriver alongside manual scripts to reduce manual effort and increase test coverage toward the end of each iteration.

Developed automated test scripts for performing regression testing on the application using HP ALM.

Responsible for Functional, Regression and User Acceptance testing - coordinated UAT testing

Performed Functional Testing and Back-end Testing using the database comparable results Manually

Involved in gathering, analyzing and documenting business requirements.

Developed and pruned artifact repository and templates to confirm the RUP standards.

Extracted the business requirements during various sessions with business leads.

Execute test cases (manual or automated) and analyze results

Track quality assurance metrics, like defect densities and open defect counts

Instrumental in writing the business Vision documents, system use cases, supplementary satisfactions and extracting stakeholder requirements.

Conducted Joint application development (JAD) sessions with extensive involvement from business development, testing terms, architects, SME's (Subject Matter Experts) of various business units.

Conducted project related presentations and provided reports to the higher management. Involved in defect management process.

Extensively used Selenium Web Driver for automating over 70% of Cross Browser Testing on IE, Firefox, Safari and Chrome .

Developed Automation scripts for new enhancements using Selenium WebDriver and TestNG .

Environment: Java, Selenium IDE/Web Driver/ GRID, Web Services, HTML, Java Script, CSS, Agile Methodology, JIRA, SQL, Oracle.

Comerica Bank, Auburn Hills MI Feb ’13- Mar ‘14

QA Analyst

Comerica Bank is one of the world's largest financial institutions, serving individuals, small- and middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services.

Responsibilities:

Analyzed Business Requirements and prepared Test Plans and Test Cases

Helped in conducting release backlog, Attended scrum meetings, conducted sprints and UAT in Agile methodology.

Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.

Conducted heavy data-driven testing using HP ALM

Tested user interface and navigation controls of the application using HP ALM

Scheduled the ETL jobs using Maestro and loaded the data into target tables from staging area using dynamic load process.

Performed web based testing with SOAP UI.

Inserted Transaction Points to test for performance and Rendezvous Points to emulate heavy load on server

Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.

Performed Continuous Integration (CI) using Jenkins for scheduling the jobs using Jenkins, GIT, TestNG, and Maven.

Developed automated test scripts for performing regression testing on the application using HP ALM.

Responsible for Functional, Regression and User Acceptance testing - coordinated UAT testing

Performed Functional Testing and Back-end Testing using the database comparable results Manually.

Performed Integration, System, Regression, Performance and User Acceptance testing of an application.

Involved in extensive DATA validation using SQL queries and back-end testing

Used SQL for Querying the DB2 database in UNIX environment

Developed Manual test scripts to conduct Regression testing on the application using JIRA

Performed Back-end testing by SQL quarries on UNIX

Experience in ETL Data Warehousing, database testing using Informatica for Workflow process.

Created test plans, identified and coordinated testers, performed user acceptance testing (UAT).

Customized Mercury Quality Center to suite the requirements of testing effort..

Reported defects using Mercury Quality Center, JIRA and followed up with developers

Environment: Windows 07/08/XP, Oracle on UNIX, IIS, QTP, ETL, SOAP UI, Quality Center, QTP

Auto trader, Atlanta, GA May ’11 - Jan ’13

QA Analyst

Auto trader Parts a new retail distribution client site by migrating all existing third party retail customers onto a portal platform. This will provide Auto trader parts clients who own life insurance, property and casualty insurance and mutual funds and annuities products, mortgage, real estate portfolio management and investor relation, financial information access to their account and policy information, as well as, other content. It also will provide support for applications and access from Agent and Manager Director desktop applications. There were 5 testers, one test lead and 8 developments member in a group. Our groups successfully completed the project at the given time.

Responsibilities:

Involved in the Review of Requirements Specification with functional manager and technical specialists of the application

Design and execute Test Plans and Test Cases, generate Test Scripts and Test scenarios.

Prepared Test Plan based on the business requirement.

Prepared proper documentation with reference to company policy

Implemented the whole life cycle of QA methodology starting from planning, capturing, creating, executing reporting and tracking the defects using QC and JIRA.

Performed Negative and Positive testing manually.

Developed RESTful and SOAP web service.

Used web services using SOAP and WSDL Technologies.

Performed testing on Web Services using WSDL and SOAPUI to check the communication between different web services.

Performed Smoke testing, Regression testing, NUnit Testing, Black Box testing, Functional testing, Database testing and System Testing.

Extensively involved in designing and creation of the database. The responsibility included creating tables, user-defined functions, triggers, indexes, functions and stored procedures using SQL Server.

Involved in creation and maintenance of Test Matrix and Traceability Matrix.

Cross-Browser and Compatibility Testing to test web applications, working as desired in different browsers and environments. Good at multi-tasking & working well under tight deadlines with high efficiency.

Good analytical and logical reasoning skills.

Experienced in facilitating User Acceptance Testing (UAT) for go-live.

Excellent analytical and good communication skills with the ability to work independently under minimal supervision and a committed team player.

Provided production support for Development as well as User Acceptance Testing environment.

Environment:Windows 07/08, UNIX, Java, Oracle, WSDL, Soap UI, Web Services, QC, HP ALM, JIRA

Emblen Health, New York Inc, NY Mar 2010 – Apr 2011

QA Analyst/Tester

Emblem Health is a Healthcare organization that offers healthcare products and services to predominately New York customers. At Emblem Health, we are dedicated to provide access to affordable, quality health coverage, in ways that respect and respond to people’s fundamental needs.

Responsibilities:

Analyzed system requirements and developed detailed test plan and test cases for testing.

Performed functionality, Data integrity and Data validation testing manually.

Performed system testing and logged results.

Performed manual testing for usability testing.

Involved in analyzing Business requirements, studying the application and collecting information from developers.

Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle.

Core responsibility involved complete manually testing of the User Acceptance Test (UAT)

Reported and tracked defects using Test Director.

Created Rendezvous points to create intense Virtual User load on the server.

Created reports using online monitors and graphs.

Participated in Walkthroughs and Inspections.

Performed Regression testing to ensure that bugs fixed did not generate new bugs.

Interface with developers to solve software problems.

Involved in gathering, analyzing and documenting business requirements.

Developed and pruned artifact repository and templates to confirm the RUP standards.

Extracted the business requirements during various sessions with business leads.

Used Requisite Pro to manage and trace requirements.

Created Business Process Flows across various capabilities.

Instrumental in writing the business Vision documents, system use cases, supplementary satisfactions and extracting stakeholder requirements.

Conducted Joint application development (JAD) sessions with extensive involvement from business development, testing terms, architects, SME's (Subject Matter Experts) of various business units.

Conducted project related presentations and provided reports to the higher management. Involved in defect management process.

Environment:Windows XP, SQL, Rational Tools, MS Visio, MS Word, Excel, PowerPoint, Access, Rational Team Test, Clear Quest

Education: Bachelor's of Computer Science and Engineering, JNTU, A.P, India, 2008

Contact this candidate