KARTHEEK GOLI

Contact # 831-***-****

Email id # adct2p@r.postjobfree.com

SUMMARY

Skilled, detail oriented and solution focused QA Analyst with 8+ years of experience in Software

Testing, Quality Assurance with zeal to deliver quality outcomes to the customer. In-depth understanding of Adaptive (AGILE) and Predictive (WATERFALL) software methodologies. Confident in all aspects of project management, delivery, SDLC, and STLC.

Core Competencies:

Agile (SCRUM) –Worked as a part of Development Team and have hands-on experience in scrum framework which includes Analyzing, estimating, and sizing the User Stories which will help Product Owners to prioritize the Story Cards and scrum artifacts which includes Product Backlog, Sprint Backlog, Definitions of done. Participated in Release Planning, Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.

Extensive experience in facilitating meetings with clients for gathering requirements, documentation of scope, functional and non-functional specifications, development of deliverables such as business process models, Use Cases, Change Requests, Traceability Matrix, Test Cases, Test Plan and Test Reports.

ETL Testing–Hands on experience in writing SQL, PL/SQL queries using SQL Developer, SQL Server, and strong knowledge of Informatica.

Enterprise Portal & Web Testing–Hands on experience in cross-browser testing, single sign-on validation, components integration testing, web content authoring and accessibility testing.

SOA and Middleware Testing–Hands on experience in handling complex middleware system based out of Linux/Windows, with different protocols like HTTP, SOAP, web services like SOAP, REST APIs. Hands-on experience in analyzing and validation of WSDLs, XML, Endpoint URI and Resources from the creation of project workspace, test suite, test steps, property transfer, assertion, reporting, import and export of projects. Working knowledge of SOAP UI and RESTful (Postman) API testing.

Automation Execution- Hands on experience in Selenium (Maven Framework), HP UFT. Experienced in Creating test script in UFT by recording, without recording, modifying manually and running the script in HP UFT 14 / HP ALM 12.20 QC saving the results in HP ALM. Hands-on experience in version control like GitHub which includes git command like status, add, commit, push, pull requests to manage the test automation suite version. Hands-on experience in integration of Jenkins with GitHub to automate the version control and schedulers to run the automation execution for the changes on the build.

Experience with Tableau reporting/data visualization tool and integration between Alteryx and Tableau.

Extensively tested several MicroStrategy Reports for data quality, fonts, headers, footers, and cosmetics.

Strong understanding of technical mainframe testing strategies

Expertise in performing Web based testing, Black box, White Box, System, Functional, Unit, System Integration, Performance, Security, Regression, Ad-hoc, End to End, (UAT) User Acceptance Testing and bug tracking system on both Windows and UNIX environments.

Expertise in Designing Test Strategies, QA Methodologies and QA guidelines in concurrence with Industry Standards, Methodologies and Best Practices.

Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and assisting in developing TEST PLAN.

Experienced in preparing and documenting the User Acceptance Test (UAT) plan and obtaining the necessary signoffs from the concerned business units.

Expertise in using Bug-Tracking tools such as JIRA, Rally, QC with a thorough understanding of all the reporting features.

Managed Incident Management process where all P1 and P2 incidents were managed through to service restoration in Servicenow (Orlando Version).

Specialized in performance testing applications using load-testing tools such as Load Runner.

Experience in functionality, performance, GUI, installation, backend, data migration, compatibility and regression testing.

Have excellent communication skills along with problem solving, documentation & stakeholder management. Solution oriented, flexible, can-do attitude and the ability to thrive in a dynamic environment within a large or small team.

TECHNICAL SKILLS

AUTOMATION TOOLS : Selenium, SOAPUI, REST API, POSTMAN

TEST MANAGEMENT TOOL : Quality Center, HP ALM 12.20, Rally, JIRA.

PROGRAMMING LANGUAGES : JAVA, .NET

FRAME WORKS : DATA DRIVEN, KEYWORD, TESTNG, MAVEN, JENKINS, GITHUB

DATABASE TECHNOLOGIES : Oracle 11g, 12c, SQL Server 2019 15.0, ACCESS, SQL PLUS 10.2.0

REPORTING TOOLS : Business Objects 3.1 and Cognos reports.

OPERATING SYSTEMS : MS-DOS, Windows -98/2000/Professional/XP-Pro, NT, UNIX.

Education: Bachelor of Engineering in Computer Science Engineering from KITS, India and Master’s in computer science.

PROFESSIONAL EXPERIENCE

Hilton Worldwide Headquarters McLean, Virginia May 2019 – Till Date

Role: Test Engineer

Description: The Delphi.fdc Corporate Reporting Project mainly focuses on Group Sales and Event Management. Room Nights and Room Revenues are part of Group Sales.

The main objective of this project is all the properties using DMPE Tool currently will be using FDC Tool for Group Bookings going forward. As part of this project initiative, the data from DMPE and FDC will be moved to Data Lake. The reports will be built in MicroStrategy both for corporate (“above-property”) and property level (“on-property”) from RedShift.

Responsibilities:

Attending daily Scrum meetings to identify interfaces that satisfy the business requirements and test them.

Extensively tested several MicroStrategy Reports for data quality, fonts, headers, footers, and cosmetics.

Extensively tested on facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect and added them to MicroStrategy Project which was created using Project Builder.

Created data blending in case of merging different sources, used Alteryx for Data blending for Tableau.

Used SOAPUI tool to test web service performance and functional testing.

Automated functional tests to be added to regression using Selenium WebDriver.

Developed automation scripts using Selenium and TestNG for common and repeatable tasks for Reservations, create customer/account, Hotel enquiry and certain service changes.

Executed ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using Alteryx 2020.1

Used Alteryx for Integration and Power BI and tableau for Business Reports.

Conducted performance testing on the application using Load Runner.

Extensively used Load Runner for performance testing and measuring the response time of the application under different load conditions.

Executed the performance testing types including Stress, Load, soak, spike, fail-over, configuration and isolation as applicable.

Used Test Management Tool for documenting the test cases and Defect Tracking/Reporting like Servicenow, JIRA.

Performed back end database testing in DB Visualizer, Ambari using SQL by writing queries using complicated Joins to verify proper mapping of data elements and ensure data integrity.

Worked on Predictive software methodologies for a different application and followed Hilton TCOE (Testing Center of Excellence) standards like test planning, test strategy, test data preparation, test execution, test summary report preparation, test closure report, Go/No-go Deck, vendor management & coordination with product owners, business analysts and stakeholders for an end to end execution and Operations validation.

Performed System testing, Regression testing, Security testing, usability testing and performance testing of the application.

Planning, leadership, and management of end-to-end test execution with a focus on test program progress to ensure that testing deliverables are on target and business, technical, functional requirements are being met.

Environment: JIRA, Servicenow, Ambari(Hive) 2.7.5.0, DB Visualizer(Redshift) 9.5.8, Spark 2.4, JIRA, Alteryx, MicroStrategy, Tableau, SQL

Bank of New York - Mellon, New York July 2018 – April 2019

Role: UAT Tester

Description: My GinnieMae - Responsible for the design and development of this test plan and built test cases based upon stories. This My GinnieMae portal used for user creation and role setup for different application and gateway for multiple application via single sign on .

Platinum: This application is responsible for creating platinum pool and after approval by operations, it goes to mainframe and Federal Govt.

Involved in doing ETL testing and backend testing along with complicated calculations. End to End responsible for testing and dealing with defect calls and retest. Responsible for end to end workflow validations.

Responsibilities:

Conducted user acceptance testing to ensure that developed systems satisfied the needs of business clients as specified in the functional requirements

Captured and tested all modifications to proposed functional requirements.

Met all project timelines and deadlines. Assisted clients and team in producing high-quality applications.

Communicated frequently with clients regarding applications functionality requirements.

Used strong time-management skills to juggle multiple projects simultaneously.

Identified issues and followed bug life cycle in HP ALM to resolve those.

Provided daily updates regarding the progress of the project to the Testing Manager.

Created the documents to track the testing progress in SharePoint.

Co-ordinated with the DBAs' to allocate user access with respective privileges for performing the database testing.

Extensively used Load Runner for performance testing and measuring the response time of the

application under different load conditions.

Extensively used and developed SQL scripts/queries in backend testing of Databases.

Developed Test Cases and SQL Queries to perform various Validations.

Checked the reports for any naming inconsistencies and to improve user readability.

Performed data validation and mainframe testing in interactive mainframe environment.

Responsible for executing and maintaining scripts in mainframe applications.

Worked on creating various reporting using crystal reports according to end user requirements

Involved in writing SQL statements to create test data for test cases and data validation tests to extract data from the tables.

Used SQL queries to test the migrated database for Back End Testing.

Written Test Cases for ETL to compare Source and Target database systems.

Responsible for developing UAT test process and monitoring SIT execution phases.

Prepared test cases based on the user stories allocated for the sprints present on JIRA.

Attend sprint planning meetings to determine the acceptable stories based on the resource availability.

Performed Smoke, Integration, Functional, Regression, and System testing.

Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.

Environment: HP ALM, Excel, OLTP DB, SharePoint, JIRA, Toad for Oracle, SQL, Informatica, Business Objects 3.1 – Web Intelligence

Nationwide Insurance Columbus, Ohio November 2016 - May 2018

Role: ServiceNow / QA Tester

Description: Nationwide Insurance offers full range of insurance and financial services across the

country, including car, motorcycle, boat, homeowners, pet, farm, life and commercial

insurance, as well as administrative services, annuities, mortgages, mutual funds, pensions,

long-term savings plans and specialty health services.

Responsibilities:

Regularly interacted with management, product owners, and scrum master on project status, priority setting and sprint timeframe.

Worked on scrum framework which includes Analyzing, estimating (Planning Poker and T-shirt sizes estimating models), and sizing the User Stories which will help Product Owners to prioritize the Story Cards and scrum artifacts which includes Product Backlog, Sprint Backlog, Definitions of done. Participated in Release Planning, Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective.

Prepared test cases based on the user stories allocated for the sprints present on JIRA.

Worked on analyzing and validation of WSDLs, XML, End URI and Resources from the creation of project workspace, test suite, test steps, property transfer, assertion, reporting, import and export of projects by Ready API.

Effectively lead issue triage meetings with scrum team to plan defect fixes for sprints by reviewing the defect priority and severity with the Product Owner.

Analyzed the Business Requirements and System Specifications and worked on test plan, test cases, test data, test scripts to carry out testing process.

Involved in Black Box testing and Integration testing of the application along with the developers.

The Black Box validation (testing) method is used by selecting valid and invalid input and determines the correct output.

Created ETL test data for all ETL mapping rules to test the functionality of the Informatica.

Interaction with business and development to understand the business functionality.

Validated data at the Backend to ensure that all the Enrollment related data has been loaded to the corresponding Data Sets in the Backend as per done as per the Standards.

Performed Smoke, Integration, Functional, Regression, and System testing.

Used JIRA to create the defects and Track the status

Involved in writing Complex SQL Queries using TOAD to validate the Enrollment Information

Mapped the Requirements to the Test Cases using the Requirement Traceability Matrix.

Developed automation scripts using Selenium and TestNG for common and repeatable tasks for Login, create customer/account, balance enquiry and certain service changes.

Used ALM for bug tracking and reporting, also followed up with the development team to verify bug and update bug status.

Created and designed Behavior driven tests cases using Cucumber and Selenium Web Driver.

Assisted the UAT sessions with the users which were not just limited to flow of transactional data, through the system, performance test and updating the defect tracking list for with UAT feed backs.

The Black Box validation (testing) method is used by selecting valid and invalid input and determines the correct output.

Handle the tasks of ensuring that the Pre-UAT activity is performed accurately and efficiently.

Responsible for developing UAT test process and monitoring SIT execution phases.

Established and reviewed QA signoff criteria, software builds and test process with scrum team.

Ensuring the acceptance criteria is met for each product increment at the end of iteration/sprint.

Followed “Definition of Done” process for all the iterations.

Environment: ServiceNow, HP ALM, Excel, RTC, SQL, TOAD, PL/SQL,SOAP UI, REST API, Selenium, SAP Business Objects 3.1 – Crystal Reports and Dashboard.

OCLC Dublin, Ohio May 2016 – October 2016

Role: QA Tester

Description: OCLC, a global library cooperative, supports thousands of libraries in making information more accessible and more useful to people around the world. OCLC, currently incorporated as OCLC Online Computer Library Center, Incorporated, is an American nonprofit cooperative organization "dedicated to the public purposes of furthering access to the world's information and reducing information costs”.

Responsibilities:

Gathered requirements and application information from Business Analysts (BA) and Subject Matter Experts (SME's) in the form of User stories on TFS and developed test cases in HP ALM.

Prepared detailed test plan explaining the test scope, testing environment, test system hierarchy or file system, test naming conventions, testability issues, and test system data, procedural steps describing test procedure and expected results

Estimated the testing effort using Planning Poker and T-shirt sizes estimating models

Worked on analyzing and validation of WSDLs, XML, End URI and Resources from the creation of project workspace, test suite, test steps, property transfer, assertion, reporting, import and export of projects by Ready API and Postman.

Effective defect tracking through HP Quality Center.

Prepared Kanban chart, Sprint Burndown, Epic/Release Burndown, Velocity, Control Chart and Cumulative Flow Diagram.

Established and reviewed QA signoff criteria, software builds and test process with scrum team.

Ensuring the acceptance criteria is met for each product increment at the end of iteration/sprint.

Followed “Definition of Done” process for all the iterations.

Involved in Functional testing, System testing, Database testing and Compatibility testing of applications.

Used SQL Queries to verify the data from the Oracle and MS SQL Server databases

Conducted Test Plan walkthroughs and wrote test scripts for manual testing.

User Acceptance Test (UAT) Planning, Designing UA Test Cases, Executing Test Cases, Documenting the Defects found during UAT, retesting after bug fix.

Performed smoke, functional and regression testing on QA, SIT, UAT and PROD environments.

Prepared Test Plans, Test Cases for both positive and negative scenarios and mapped the same to requirements in Quality Center.

Validation of Back End data using SQL database querying, log file and data grid cache analysis

Used SOAPUI tool to test web services.

Worked on Continuous Integration using Jenkins to execute automation scripts using Selenium and SOAP UI.

Responsible for construction process of server (Linux) and client (SOAP and WEB Based application) testing

Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.

Implemented the open source approach with Selenium

Involved in automation infrastructure setup using Selenium with Java

Hands on experience in GitHub and git command like add, commit, push, pull requests to manage the test automation suite version.

Hands-on experience in integration of Jenkins with GitHub to automate the version control and schedulers to run the automation execution for the changes on the build.

Connected to database to Query the database using Toad for Data Verification and Validation of the data in the back end.

Defects tracking and management performed using Quality Center 12.20 and ALM

Performed regression testing against the various builds of the application.

Prepared test cases for the ETL application per technical specification document and Extensively tested data extraction, transformations and loading processes.

The Black Box validation (testing) method is used by selecting valid and invalid input and determines the correct output.

Environment: Sybase, Greenplum, Oracle, SQL, MySQL, Hadoop, .Net, Selenium, UFT, Postgres, SOAP UI, Service now, TOAD.

McKesson Charlotte, NC June 2015 –February 2016

Role: QA Team Lead

Description: The objective of this project is to develop and test a new Ambulatory product which aims to provide health care solutions to various clinics and hospitals. Ambulatory EMR software is part of Paragon – a comprehensive hospital information system, incorporates the existing and enhanced features for use in hospitals to create, maintain and update patient medical records.

Responsibilities:

User Acceptance Test (UAT) Planning, Designing UAT Test Cases, Executing Test Cases, Documenting the Defects found during UAT, retesting after bug fix.

Used SQL to extract, transform, import, export data from Oracle tables to flat files.

Prepared Test Plans, Test Cases for both positive and negative scenarios and mapped the same to requirements in Quality Center.

Developed new and updated existing Automation test cases using Selenium Web Driver and TestNG, using SVN as VCS for a Java based Web application, using Maven as build tool and Jenkins to create and run deployment jobs

Worked on Continuous Integration using Jenkins to execute automation scripts using Selenium and SOAP UI.

Defects tracking and management performed using Quality Center 12.20 and ALM.

Responsible for construction process of server (Linux) and client (SOAP and WEB Based application) testing.

Extensively involved in Functional testing, System testing, Database testing and Compatibility testing of applications.

Used SQL Queries to verify the data from the Oracle and MS SQL Server databases.

Prepared Test Plans, Test Cases for both positive and negative scenarios and mapped the same to requirements in Quality Center.

Worked on Continuous Integration using Jenkins to execute automation scripts using Selenium and SOAP UI.

Version controlling of scripts using GIT, STASH.

Prepared test cases for the ETL application per technical specification document and Extensively tested data extraction, transformations and loading processes.

Validated ETL process and reports using SQL queries.

Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.

Responsible for the work done by team and conducting performance appraisals/review for the Team.

Understanding and participating in the AGILE scrum ceremonies (Release and Sprint planning, daily standup meetings, Task estimation and story pointing).

Conducting Iteration retrospective meetings and collecting feedback from the team to ensure same mistake shouldn’t happen.

Environment: Sybase, Greenplum, Oracle, SQL, MySQL, Hadoop, PostgreSQL, Jenkins, Selenium, Restful API (Postman), Service now, Linux, TOAD.

Bank of America, Charlotte, NC August 2014 - May 2015

Role: QA Analyst

Description: This application gives customer access to their accounts through the ATM Channel. Customers can check their account balance, view accounts activity, pay bills, transfer funds/balances from other accounts, credit cards, home equity, personal loans, education financing services. Video Teller Machine (VTM) combines traditional ATM capabilities and video conferencing capabilities with people interaction to perform routine banking transactions. VTM represents a new service model that provides customer with “Electronic” face-to-face interaction when required or as requested by the customer while performing the ATM transaction.

Responsibilities:

Creating functional and regression handoffs to move test cases from Functional projects to Regression Projects.

Coordinate meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.

Responsible for helping test a variety of ATA VTA products and assisting testing a related product when necessary. Responsibilities include test plans, test cases, test execution, test reports, opening and verifying work requests/bug reports, and helping recreate customer issues.

Coordinate the review, presentation and release of test plan and test cases.

Report defects in Quality Center, work closely with analysts, developers to resolve the problems, and change the status of the defect accordingly.

Involve in end-to-end test of Sales and Non-sales data in downstream applications, key and poll is the process where sale data originating from stores POS flows to the backend applications

Developed UFT scripts with object model and description programming.

Developed automated test scripts using VBScript in UFT.

Used UFT to execute automation test cases after manually verifying application functionalities.

Conducted automated parameterization of dynamic content, multiple data sets within application by using UFT.

Inserted synchronization, standard, bitmap and image checkpoints for greater accuracy of testing in UFT.

Performed functionality testing of the web-based application by testing various modules of the application using UFT.

Develop optimized UFT scripts for regression testing with data sources.

Tested the sections of POS transactions like Sale, Trade, Return, Pre-order, Web in store, Void, Post Void, Suspend and Resume using different tender types Credit card, Debit card, POSA card, Cash, Gift card, Trade card, Cashier check and Star card.

Involved in creating test data for POS though inventory-controlled application.

Tested POS systems POS functions and RMS systems.

Worked on automating UI test cases using Selenium.

Manual testing of web services (SOAP, XML/HTTP, WSDL) using SOAP UI tool.

Worked closely with the Development team in getting fixes for the defects that have been in open status.

Environment: QC, Base24, Bridge Tool, UFT, Tandem, ATM/ATA/LTA/Next Gen Machines/ Target Application, POS, DMART, SQL.

Consulate General of India SFO, CA September 2013 - August 2014

Role: QA Engineer

Description: This application gives customer access to their online application through the Internet. Customers can check their Passport Status, PIO Card, OCI Card and Visa Information.

Responsibilities:

Analyzed the user requirements by interacting with users, developers and business analysts.

Created Test Plans, test cases and test procedures that ensure the product adheres to the application requirements.

Conducted Functional, Security, User Interface, Regression testing and UAT on the AUT.

Performed browser compatibility testing on different platforms.

Parameterized the test scripts and performed Data driven Testing with different sets of input data using Win Runner.

Tested the ETL business logic for different feeds and checking the log files for data counts.

Worked with Quality Center for executing test cases and reporting defects.

Analyzed test results, generate test reports, file bugs and follow up on resolution with development & support team.

Used Informatica workflows to run the data load jobs.

Performed manual testing on various modules of the ETL applications.

Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.

Monitored the workflows using Informatica workflow monitor and performed end to end testing of Informatica data load jobs.

Involved in Unit testing and integration testing of Informatica mappings. Designed and implemented basic SQL queries for QA testing and report/ data validation.

Assisted the QA team in designing the test plan and test cases. Performed User Acceptance Testing.

Executed the test cases and analyzed the test results using Win Runner.

Extensively used Load Runner for performance testing and measuring the response time of the

application under different load conditions.

Effectively involved in Daily Stand Ups, Scrum Planning (Iteration Planning Meetings) and Retrospective meeting.

Environment: Win Runner, Load Runner, Windows NT, MS-Access, VB, MYSQL, TOAD for Oracle.

Robert Bosch India limited, India August 2012 - April 2013

Role: Software Quality Consultant

Description: A general-purpose package (2 tier) for Payroll Management using MS Access as the back-end to store data and Visual Basic 6.0 as the front-end tool. It covered different aspects like Employee Personal details, Employment details, Salary, Allowances and Deductions, Leave Details, Net salary calculation etc. Given the employee gross salary, net salary was calculated considering the medical insurance, taxes deductions, etc.

Responsibilities:

Requirement Analysis and Clarifications with end users

Defect Reporting and Verifications Mapped the Requirements to the Test Cases using the Requirement Traceability Matrix.

Creation of Manual Test Cases and Automated Test Scripts using Quick Test Professional.

Upload of Manual Test Cases into Quality Center from Excel sheet.

Execution of the Test Cases Manual running as well as Automation using Quick Test Professional

Logging the Defects in the Defects Tab of Quality Center.

Solving the Defects.

Preparation of test data for Back end testing as well as front end testing.

Tested the functionality of each screen to monitor proper navigation.

Regression tests were performed after every build of the application.

Environment: Win runner, Manual Testing, Visual Basic 6.0, MS Access, Windows 98/NT, SQL.

Contact this candidate