Quality Assurance Project Test

HEMANTH KOYALKAR

email: **********@*****.*** Mobile: 713-***-****

PROFILE

PROJECT TEST LEAD

Software QA professional with over 15 years experience. I am passionate about Software Quality assurance analysis, testing, designing testing frame- works, managing testing teams and testing efforts, collaborating with cross functional teams to ensure efficient testing practices are implemented and desired business objectives are achieved. EDUCATION

SVU, California, USA - Masters (Computer Science) - 2008 SEC-JNTU, India - Bachelor of Technology (Electronics & Communications) - 2005 TESTING/PROJECT SKILLS

Manual, Automation, Performance, Security, API, UAT, POS, Accessibility, ETL, Project Test Management - Cre- ation of Test Strategy, Test Plans, Test Cases,Defect Management, Reporting, Post Production Implementation Support, Business Analysis

TESTING TOOLS

HP Test Suite (UFT, ALM, Load Runner), Test rail, Test Complete,Smartbear - QA Complete, Tricentis – TOSCA,Perfecto, BrowserStack,Sauce Labs, Web Inspect, Sonar Cloud, Selenium with Python (Webdriver, Ap- pium),Cucumber (BDD)

PLATFORMS/ TOOLS/LANGUAGES

JAVA,C#.NET, ASP.NET, ADO.NET,Python,Java Script, GitHub,CI/CD(Jenkins), Microsoft Visual Studio 2003/2005/2008,Share Point,Microsoft SQL, Webdam,Sitecore,Magento,Shopify,Jira, Jira - Confluence, Mi- crosoft Azure,In river PIM,Klevu,SOLR, COVEO, Salesforce,Blue Zone Mainframes,POS (NCR -Radiant, Alo- ha, POSIFLEX, Kiosks, HH Devices), Netezza,DataStage, Biztalk PROJECT METHODOLOGY/FRAMEWORK/TOOLS

Agile-SCRUM, Kanban (Tools - VersionOne, Rally, Leankit),Waterfall 1

WORK EXPERIENCE

QA Project Test Lead

LITTLEFUSE INC., September 2022 - April 2024

Led the test management for redesigning Company’s website project and other crucial acquisition projects as part of Global and Digital Management. Managed the onsite and offshore testing teams and mentored testers to improve testing quality and efficiency. Conducting Functional and Non-Functional testing and creating test strategies, test plans, test cases for redesigning the company website project for both web and mobile instances. Worked closely with onsite project team to understand their needs and goals to translate them into effective testing solutions. Demonstrated experience integrating automated test suites with CI/CD pipelines utilizing GitHub Actions.Supporting business users with UAT set up and leading the UAT Testing efforts.

Environment: TestRail, POSTMAN, Jira, In river PIM, WebDam, Sitecore, TOSCA, Browser- Stack, SOLR, COVEO, Load Runner, GitHub

QA Lead

SRS DISTRIBUTION INC., November 2021 – June 2022

Led the testing for company's e-commerce platform projects, to incorporate integration partners and resulting in better retail performance of the website. Conducted usability testing to test and inform design decisions and improve the user experience. Collaborated with development teams to ensure requirements were implemented, tested accurately and efficiently. Monitoring the creation of test strategy and test cases, defect management..Responsible for onsite and offshore testing activities and reporting back to the project team for both functional, UAT testing. Environment: SQL Server, POSTMAN, Azure DevOPs, Inriver PIM, Klevu, Magento, Java 2

Project Test Lead

LBRANDS, December 2020 – October 2021

Worked as a Project Test lead on website Migration project. Planning out Test Strategy and helping the team with Test Plans, Test scenarios, Test Cases. Performed Quality Assurance management activities. Helped test team with test execu- tion in line with the production deployment timelines. Track the defects, clarifications, and suggestions in Jira- Confluence, Jira- Kanban Board and provide QA sign off for all the requirements. Provide defect report and project status report on a regular basis to the project management. Forecast the future workload and provide estimations for intake of new re- sources. Publish the test summary report for every release and provide support to User Acceptance Testing (UAT) and Post implementation activities.

Environment: SQL Server, HP ALM, Test Rail, Jira – Kanban, Jira- Confluence, Azure DevOPS, Salesforce (customer data application).,

QA Project Test Lead

UMB/SANTANDER, April 2020 – November 2020

Worked as a QA Lead/Onsite Manager Coordinating with Offshore team on Universal Online Banking Up- grade Project (Cor- porate Banking) and helping team to communicate client requirements, test planning, test execution, reporting back to the client with the test results. Performed Quality Assurance management activities. Tracking defects, clarifications and sug- gestions in HP ALM and Salesforce and provide QA sign off for all the requirements. Help the team to design Desktop au- tomation framework, scripts, and execution. Provide defect report and project status report on a regular basis to the project management. Publish the test summary report for every release and provide support of User Acceptance Testing (UAT) and Post implementation activities. Conducting SIT on QA and STAGE environments. Monitoring UAT tests for code validation. Working with cross functional teams for project coordination and tracking functional, UAT testing progress. Environment: Java, SQL Server, Mainframes – TSO and RDS (HOGAN), UI Validation tools - Check Vision, Microsoft Office Suite, Smart Bear QA Complete (Test Management), ACH (Pep plus), Wires (MTS),HP-ALM 3

QA Test Lead Analyst

AMC Theaters, June 2016 – March 2020

Worked as Test Lead for AMC Theatres Loyalty Program Validating AMC Loyalty Member- ships, Points Earn, Rewards, Push notification, Campaigns, Discount Offers. Testing loyalty program functionalities at Website, Mobile App, Point of Sale systems. Review Loyalty program details and content with customer care and Marketing teams. Writing Test plans, Test cases. Publish the test summary report for every re- lease and provide support of User Acceptance Testing (UAT) and Post implementation activities. Execut- ed DataStage jobs and validated the requirements with the provided mapping documents by creating SQL scripts. Monitor Performance tests for Website, POS Software Configurations, Implementations and Trouble shooting, and Mobile Apps. Validated the transaction reports out of ETL in Power BI. Validated the data movement from Files/SQL Server to SQL Server/Netezza/Hive via DataStage and Biztalk jobs. Environment: .NET, POS (Radiant & ALOHA), Netezza, Data Stage, POSTMAN, HP ALM, iOS, Android, Biztalk server, Lean kit (Kanban), Elmah logs, Oracle, Microsoft SQL Management Studio, Analytics, DataStage, Data Mapping Tool, Beyond Compare, Power and Tableau BI, Selenium (Webdriver,Appium) Sr.QA Analyst

Quest, January 2016 - May 2016

Worked on Q-Screen patient portal project for validating patient forms workflow. Worked on deploying builds using Team City tool to test environments. Validating error logs using Elmah logs capturing error logs data for troubleshooting. Worked with Kofax system for verifying the third-party faxing system to test scanning the physician forms. Worked with POSTMAN plug-in in testing the API’s. Validated HL7 for data input to process through data processors. Worked with functional and UAT teams for User acceptance testing implementation.

Environment: .Net, SQL Server 2008 R2 Management Studio, Rally, HP ALM 11.52, KOFAX, JSON Viewer, Team City.

4

QA Test Lead Analyst

AMC Theaters, July 2015 – January 2016

Worked as Test Lead for AMC Theatres Loyalty Program on AMC E-commerce retail website. Validating AMC Loyalty Memberships, Points Earn, Rewards, Push notification, Campaigns, Discount Offers. Testing loyalty program func- tionalities at Website, Mobile App, Point of Sale systems and check out journey. Review Loyalty program details and content with customer care and Marketing teams. Review Loyalty program details and content with customer care and Marketing teams. Writing Test plans, Test cases. Publish the test summary report for every release and provide sup- port of User Acceptance Testing (UAT) and Post implementation activities. Executed DataStage jobs and validated the requirements with the provided mapping documents by creating SQL scripts. Monitor Performance tests for Website, POS Software Configurations, Implementations and Trouble shooting, and Mobile Apps. Working with business and marketing teams in conducting, assisting UAT in QA environment Assisting in configuring QA lab systems timely re- lease patches from the Development team.

Environment: .NET, POS (Radiant & ALOHA), Netezza, Data Stage, POSTMAN, HP ALM, iOS, An- droid, Biztalk server, Leankit (Kanban), Elmah logs, Oracle, Microsoft SQL Management Studio, Analytix, DataStage, Data Mapping Tool, Beyond Compare, Power and Tableau BI, Selenium (Webdriver, Appium) QA Test Lead Analyst

UMB Bank, July 2014 – July 2015

Led the team for UMB Investment Banking and Investment Solutions project for validating investment banking solutions implementation. Worked with Blue Zone- Mainframes for both TSO and RDS to analyze Batch Input and Output data set files and Reports for validations in matching up UI and Batch program files and UI validations. Worked on Data Stu- dio client for database validations. Acted as liaison among the IT area and user development groups. Assisted in the project quality reviews for my assigned applications. Reviewing all project deliverables to promote standardization across the test team. Worked on the IT Project Life Cycle Standardization to review each document/ task, identified any differences and recommended a best practice. As a result of the reviews several documents were standardized, and templates created. Logging defects to the Test Complete ALM for Defect Management and Test Management. Analyzed and reviewed the requirements and scope of testing for UAT, produced Weekly Status reports and different kind of on- demand metrics. Analyze the current system/process and perform in depth GAP Analysis to understand the needs of various components for the future deployments.

Environment: Java, Oracle 11 g, Mainframes – TSO and RDS, Agile –Scrum and Waterfall Method- ologies, HP ALM, UFT, UI Validation tools - Eye dropper/Check Vision/ Meazure, Microsoft Office Suite 5

QA Test Lead Analyst

Capital One, October 2013 - May 2014

Worked as Test Lead for Capital One bank SQL upgrade and impacted business components project. Work- ing with the Product Owners and Project Manager in reviewing Business requirements of the applications. Involved in writing the Test Cases and Test Scripts based on Technical Specs of the applications. Performed all testing activities for initiatives across one or more assigned projects, utilizing processes, methods, met- rics, and software that en- sure the quality, reliability and systems safety and security. Understanding the interfacing applications, test environments and our tools and methodologies. Worked on Test strategy formu- lation which included decomposing the business and technical requirements into test case scenarios, defin- ing test data requirements, managing test case creation, devising contingencies plans and other preparation activities. Logging defects on HP ALM for Defect Management. Performed backend database validations and impacted business units. Validations of legacy server files migrated to the upgraded DB servers. Working with business teams, assisting UAT in Stage environment. Environment: .net 4.0, SQL Server 2000, SQL Server 2008, Winocular Imaging Tool, HP ALM 11.5 Sr.QA Analyst

CANRIG, May 2011 – August 2013

Led testing activities for RigWatch application project for various subsidiaries. Designing the full applica- tion's automation suite that performs extensive functional testing including multiple iterations of data entry. Created test scripts using QTP 10.00 and 11.0 to automate the full end-to-end workflow testing of the product. Performed full setup and installation of the product both on the server and on client machines us- ing Linux. Creating Infrastructure for testing application that has other dependencies. Performing the Inte- gration testing of EDR and Tour Sheet applications to one consolidated product called RigWatch. Perform- ing consolidation of test plans and automated test scripts. Performed backend testing with SQL, PLSQL while testing the module. Setup Hardware Infrastructure in the QC Lab. involved setting up a Rig specific severs by imaging and installing software using Linux, then configuring various clients to them. Worked on Enterprise solutions products related with RIG daily activities. Environment: Windows XP, Oracle 9i, XML, MS ACCESS, MS suite, SQL, PLSQL, MySQL Query browser, TOAD, QTP 10.0 and 11.0, ALM 11.0 Spectrum, Scarab, Jira, MS Office Suite, JDK1.5/1.6, Java, J2EE,Windows 2000, Winscp, Putty, Linux - vi editor, Visual Studio IDE, Visual SourceSafe, IIS 5.0 and 7.0, Crystal Reports 10, TList 8 OCX, Easy Mail Objects for SMTP, Iphone, Ipad -IOS 6,Android-4.2 Jelly bean, Microsoft Office Suite, TestTrack, Visio, SharePoint. 6

QA Analyst

Harland Clarke Corporation, July 2010 – March 2011 Performed functional testing activities for e-commerce website customer experience and check out journey and Odyssey Customer Care application projects. Involved in writing the Test plan, Test Cases and Test Scripts based on Business Requirements and Technical Specs of the application. Tested data Consistency, data integration, and data validation.Working with different client websites (E-Commerce) to perform Func- tional Testing, and End to End testing. Working with E-Commerce team for the requirements for Product and Data Testing. Re- viewed Defect Management using HP Quality Center. Attending Defect Call Meet- ings to dis- cuss the raised defects and working with concerned developers to get the bugs resolved. Environment: .NET, Java, SQL Server 2008, QTP 10.0, HP Quality Center 9.1 QA Analyst

P4 Healthcare, March 2009 - June 2010

Worked on SQL migration project. Involved in writing the Test plan, Test Cases and Test Scripts based on Business Requirements and Technical Specs of the application. Involved in developing Test architecture. Followed SDLC from Requirement, Design, Implementation, Testing and Maintenance. Developed scripts to perform functional tests, content retrieval to test database tables and data validation. Performed GUI Func- tional testing, Data Driven Testing, Regression Testing, Integration Testing, Backend Testing and Smoke Testing of Client-Server Application. Participated in QA/Development meetings to meet the testing standards and integration testing. Perform End-to-End testing manually. Identify the areas to be automated/existing- developed scripts in QTP. Performed functional testing using automated testing tool QTP. Communicating with Management to provide status and alert any critical bugs or showstoppers. Involved in conducting re- gression testing by using automated scripts. Tested data Consistency, data integration, and data validation. Data validation for the data representing in the Front-end by running the SQL Queries in SQL 2005 and SQL 2008.

Environment: NET, SQL Server 2008, SQL Server 2005, Crystal Reports, Quality Center, UNIX, Visual Safe Source (VSS) and QTP, Microsoft Office suite, Visio, Share point. 7

Contact this candidate