Home

Rohit Mishra - QA Automation lead

[email protected]

Location: Ridgefield, New Jersey, USA

Relocation: Yes

Visa: h1b

Resume file: Rohit Mishra- Resume (1) (1)_1752855173678.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Rohit Mishra QA analyst/ Automation Lead [email protected] (734) 821-5129 Professional Summary Senior QA Lead with 18+ years of IT experience including 15+ year at onsite (USA) in Quality rule management, Usability, UAT, Mobile & Cloud, Automation , Performance, Accessibility, POS, Supply Chain, OMS, Manhattan WMS(TLM), Portal, Web Services (HTTP and Rest), SOA, Resiliency, Verification n Validation, Share Point, ServiceNow, MDM, Data Migration, BI Reports, Integration, Web UI,TDM, API (IBM), BPM (PEGA), Network testing in the Agile-Scrum, Waterfall & Iterative Model. UAT Lead with 12+ Year experience on developing UAT test plans including test scripts, test scenarios, RTM, test schedules, defect tracking and reporting. Scheduling and leading UAT team meetings such as status, project kick-off, stand-ups, defect tracking, etc., and meeting with the business stakeholders to prioritize work and projects. Mobile Application testing with 8+ Year experience on different Mobile Platforms, such as iOS and Android. Automation Tester with 8+ Year experience in Web Application Testing using Selenium WebDriver, IDE (Java) with TestNG framework. Writing Test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations. Experience in Data driven Testing, Cross browser testing and Parallel Test execution using Selenium WebDriver, Jenkin, Cucumber (Gherkin), TestNG and selenium Grid. SOA Tester with 5+ Year Experience in API testing with Rest- Assured, Ready API, Postman, SOAPUI tools. Usability Tester with 5+ Year Experience with systems, user controls, error prevention, consistency & std. Security Tester with 5+ Year experience with Implementing, testing and operating advanced software security techniques in compliance with technical reference architecture. Performing on-going security testing and code review manually and with Nmap, Burp-Suite, IBM app scan few other tools to improve software security. BSA with 8+ Year experience on functional, technical and security testing requirements an act as a strategic partner between the business community and IT development teams to resolve functional, security and technical issues related to business applications, to troubleshoot data or transaction issues. Scrum Master cum QA Project Manager with 10+ Year experience to facilitate the daily stand-up, maintain their burn-down chart, setting up retrospectives, sprint reviews or sprint planning sessions, Shielding the team from interruptions during the sprint, removing obstacles that affect the team, Walking the product owner through more technical user stories, Encouraging collaboration between the Scrum team and product owner. BPM (PEGA) with 2+ Year experience to perform BPM (PEGA PRPC) Architecting, PEGA Branding, Thought Leadership, solution Architecture, capturing and documenting non-functional (architectural) requirements, preparing estimates and defining technical solutions to proposals (RFPs) along with design to deployment related activities, provide guidance, perform reviews, prevent and resolve technical issues. 13+ year experience in Agile/Scrum, 15+ Year experience in Water Fall and Iterative Model. Subject Matter Expert in banking & financial, CCAR, Compliance Rules, WCAG2.0 section 508, WAI-ARIA Regulatory Compliance, Life Insurance, Annuity n Commercial line, Property and Causality(PnC), Medicare, Medicaid, Long Term Care, Pharmacy Benefit Management (PBM) Domain, Credit Ratings and Retail. 15+ Year experience on documenting business requirements, burn charts, Gap Analysis, Estimation sheets, test strategy, test plan, matrix, QA project estimates, analyzing business specification documents, developing test plans, Requirement Trace Ability Matrix, defining test cases, status reports, BI Reports, analyzing test results, Defect Tracking, Bug Reporting (HP Quality Center, ALM/Jira and APPM) and dashboards. Quality Management, change control, Document Management, Training Management, Release Process through QC/ALM, Jira, Rally, Confluence, share Point tools and Microsoft Team Foundation Server 2013/Microsoft visual studio 2013/Microsoft test manager. Experience in test automation, script preparation and execution within framework and in Selenium/Cucumber/QTP11.5/UFT12.5 integrated environment (step generator, synchronization, data tables, actions, recovery scenarios). ACOMPLISHMENT/AWARDS CIO award received in 2011 by Moody s for best QA. Global Test Lead Performance award received in 2015 by Northwestern Mutual. EDUCATION MBA - Master s in business administration Indiana University (USA) B Tech (CS) Bachelor of Technology in Computer Science and Engineering 2006 (U.P.T.U. India). CERTIFICATE Certification Issued By Date Obtained Certification Number Expiration Date PMP PMI Sep-22 3307135 Sep-25 CSM Scrum Alliance Sep-22 1417355 Sep-25 TECHNICAL EXPERIENCE PROFESSIONAL EXPERIENCE End Client: State of Ohio (Dept of Medicaid) Location: Columbus, Ohio Duration: Jan 2018- June 2025 Role: QA Lead and UAT Lead SDLC & STLC: Agile and Scrum QA Project Lead Responsibilities: Led and coordinated daily QA activities across business stakeholders to deliver secure, high-quality applications through Big Data, ETL, and BI (Tableau/Cognos) testing within Agile and Scrum frameworks. Developed and maintained detailed test strategies, test plans, test scenarios, and test cases, ensuring full traceability through ALM and JIRA for Medicaid and Data Integration projects. Authored and executed manual and automated test scripts, including functional, regression, integration, and UAT phases, validating cloud-based web applications and backend systems. Managed end-to-end defect lifecycle using ALM/QC and JIRA, providing detailed defect reports, metrics, and dashboards to stakeholders. Performed security testing of cloud-based applications, including manual vulnerability assessments and validation of authentication, authorization, data protection, and compliance standards. Ensured data privacy and PHI compliance by validating claim data workflows and payer information. Conducted performance testing using LoadRunner, assessing application responsiveness and stability under peak load conditions. Developed Project Plan & Test Strategy, update and maintain testing standards and procedures, Risk Based Test strategy, QA Process and Procedure, QA Templates, QA Metrics (using excel macros and pivot), Reports, Test Plan, Test Cases, Test Scripts and Testing Estimation in each sprint and releases. Established and controlled the test environments and Test Data set up for Product Testing with manual, database, API (IBM), and Automation Testing. Managing claims and PBM test data in the informatica test data center. Experienced in Functional or System testing, Unit Testing, Integration testing, Regression testing, UAT, GUI on cloud-based web application testing. Conduct structured walk-through a well as performed demo s and participate in the retrospective meetings in each sprint for Medicaid Data and Reports. EDI 837, 835, and 834 compliance testing with different data extracts and reports. Work with Test Team members to enhance their testing skills, build technical and business knowledge as well as define test team member roles, responsibilities and deliverables. Determine time estimates and schedule for work efforts as well as coordinate the efforts of other testers. Performing Master Data Management (TDM) and implementing TDM strategies for Claims with Microsoft SQL Server data services with complex queries using multiple data repositories and tables in the share point. Performing Data Cleansing with Informatica tool and Data Management. Validate Physical and Logical Model, DDLs and Source to Target Mapping. Execute Data Integration and BI test cases (Cognos/Tableau/SaaS) based for all the Medicaid Products. Conduct usability testing with systems, user controls, error prevention, consistency & std. Perform manual security testing of Medicaid Products on cloud-based web applications. Perform Job scheduling and batch processing with Autosys tool for the CSV/Flat Files. Analyze large amount of data provided in spreadsheets using Excel features with macros. Ensure adherence to testing best practices and database testing (Store procedure testing, performance and data validation testing). Designed and maintained automation test scripts using Java within data-driven and hybrid frameworks to validate backend processes and database integrity. Independently managed test environment configuration and implemented robust Test Data Management (TDM) strategies, including Informatica-based data cleansing and data provisioning using SQL Server. Collaborated effectively with DevOps and development teams, using Git for version control and Jenkins for continuous integration to support automation and deployment workflows. Led peer reviews of test deliverables, facilitated structured walkthroughs, and provided quality input in Agile ceremonies such as sprint planning, reviews, and retrospectives. Demonstrated the ability to work both independently and collaboratively, managing tasks efficiently across multiple priorities to meet tight deadlines without compromising quality. Tracked and reported test progress, defects, and risks using JIRA, ensuring full visibility for stakeholders throughout the test lifecycle. Debug investigate ad perform inspections to resolve issues/defects and determine root cause as well as manage expectations for daily metrics of test execution and defects in the QC/ALM, Jira. Create Defect Documentation during all the test phase, defect tracking, management and reporting of found defects via Jira/ALM/QC. Create and maintain high-quality Dashboards, documentation of all relevant specifications, systems, procedures, measurements and metrics to make effective and useful measures of the testing process status reports, BI Reports which provides progress toward testing objectives in MTM n TFS. Signed of the projects and Involved in the software deployment in QA and production release process with DevOps tool then support to production support teams. End Client: Abercrombie & Fitch Location: New Albany, Ohio Duration: Jan 2016 Dec 2017 Role: QA Lead SDLC & STLC: Agile n Scrum QA Project Lead Responsibilities: Led end-to-end QA strategy and execution across Agile projects involving web, mobile, and cloud-based applications, ensuring high-quality deliverables through structured test planning, execution, and reporting. Designed and developed robust automation frameworks using Java, Selenium WebDriver, Cucumber (Gherkin), and TestNG, enabling scalable, maintainable, and reusable test scripts. Executed automated regression and cross-browser testing using Selenium Grid, integrated with Jenkins for continuous testing and reporting. Utilized Git for version control and source code management, collaborating with developers and DevOps teams in CI/CD pipelines via Jenkins and Azure DevOps. Performed extensive mobile application testing across Android and iOS platforms using Appium and manual testing techniques, validating responsive design, UI/UX, and cross-device compatibility. Conducted thorough security testing including penetration testing, authentication/authorization checks, session management, and vulnerability scanning using tools like Nmap, Burp Suite, and Metasploit. Validated API and web services (SOAP and REST) using tools like Postman, SOAP UI, and Rest-Assured, verifying request/response structures, payloads, and integration logic. Authored and executed complex SQL and PL/SQL queries for backend data validation, ETL testing, and end-to-end data flow verification across structured and unstructured data sources. Defined and executed performance and load testing scenarios using LoadRunner, identifying bottlenecks and optimizing system response under varying user loads. Oversaw defect lifecycle and reporting through HP ALM/Quality Center and JIRA, ensuring timely triage, resolution, and metrics reporting for stakeholders. Managed test execution in Azure DevOps, ensuring traceability from user stories to test cases and aligning with sprint goals. Led the setup and maintenance of test environments, test data management, and execution tracking using both manual and automated approaches. Participated in Agile ceremonies (daily stand-ups, sprint planning, retrospectives), collaborated with cross-functional teams to define test scope, and aligned testing efforts with product goals. Ensured adherence to QA best practices and compliance standards by maintaining detailed documentation, test metrics, risk logs, and quality dashboards for continuous improvement. Managed QA deliverables using ALM, JIRA, and Azure DevOps Boards, tracking test progress, defect metrics, and ensuring traceability of all testing artifacts. Conducted code reviews of automated scripts and ensured adherence to coding and QA best practices. Implemented test data management (TDM) strategies to create, manage, and validate large volumes of test data across multiple data sources and environments. Coordinated with cross-functional teams to define Definition of Done (DoD) for testing, ensuring QA involvement from early stages of the SDLC. Provided technical leadership and mentoring to QA team members, enhancing their automation and domain skills, while promoting a culture of quality and continuous improvement. Conducted root cause analysis and triaged defects across functional, performance, and integration areas to provide quick resolutions. Defined and enforced QA process standards including risk-based testing, entry/exit criteria, automation ROI tracking, and regression strategies. Engaged in test environment setup and configuration, including validation of microservices, databases, data lakes, and API endpoints in Dev, UAT, and staging environments. End Client: Northwestern Mutual Location: Milwaukee, Wisconsin Duration: Dec 2014 Dec 2015 Role: BA -QA Test Lead Domain: Health Care, Life Insurance, Annuity, Retirement Solutions, Regulatory Compliance, Policy admin System with Annuity products Property and Causality/Loyalty (PnC), Medicaid, Pharma (PBM) n Medicare Domain. SDLC & STLC: Agile n Scrum Model Project 1: SRC (Life Insurance and Annuity Applications): The Service Request Centre (SRC) project s purpose is to provides a simplified way to request service transactions and new applications in a consistent, secure, and easy-to-use manner . Project 2: BPM Migration (Life Insurance and Annuity Applications): The Business Process Management (BPM) and Business Activity Monitoring (BAM) migration effort will migrate the Service Request Center (SRC). QA Project Lead and Tester Responsibilities: Create a cross team testing calendar (by business day) to expose the required test activities on a daily/weekly projection. This will serve as a road map in test planning to ensure data, system test environments, software & hardware s, resources and tools are available proactively. Developed Project Plan & Strategy, update and maintain testing standards and procedures, Risk Based Test strategy, QA Process and Procedure, QA Templates, QA Metrics, Reports, Test Plan, Test Cases, Test Scripts and Testing Estimation in each sprint and releases within PPQA/CMMI. Established and control of the test environments and Test Data set up (TDM) for manual, database, API Penetration, Performance and Automation Testing. Perform as business system analyst on functional, Resiliency and security testing requirements for Life Insurance, Property and Causality (PnC) (WINNS Applications) and Guidewire Policy Center _ Claims to create user stories in JIRA as well as especially related to coaching and or teaching agile teams. Gathered and analyzed requirements with end-users and product specialists and created traceability metrics. Assistance in the development of user stories, acceptance criteria and product backlog grooming and especially related to coaching and or teaching teams. Create Test Strategy to provide the overall testing approach including team members, tools, guidelines, policies & processes for defects for PnC in Guidewire. Create Test Plan to presents the test objectives, scope, approach, assumptions, dependencies, risks and schedule for a release for web based and mobile (as iOS and Android) applications and defects for PnC in Guidewire. Conduct structured walk-through a well as performed demo s and participate in the retrospective meetings. Work with Test Team members to enhance their testing skills, build technical and business knowledge as well as define test team member roles, responsibilities and deliverables. Create knowledge transition plan for offshore team, implement and measure effectiveness on regular intervals. Review of Manual/Website Test scenarios (Risk Based) and Test cases prepared by Offshore and Onshore teams and get approvals from the Business Teams Prepared Requirement Traceability Matrix defects for PnC in Guidewire. Allocated and supervised tasks to other team members for website testing. Determine time estimates and schedule for work efforts as well as coordinate the efforts of other testers. Define and utilize entry and exit criteria for testing. EDI 837, 835, and 834 compliance testing with different data extracts and reports. Perform Master Data Management (TDM) with Microsoft SQL Server data services in the share point. Create Test Cases for specific tests defined to ensure business requirements are met and capture defects when not met for web based and mobile (as iOS and Android) applications. Execute functional/website test cases based on windows and mainframe, C#.Net and J2EE/Java web based and mobile (as iOS and Android) applications defects for PnC in Guidewire. Well versed in Hadoop ecosystem - Map Reduce, Pig, Hive, HBase and Sqoop. Installing, configuring, debugging and troubleshooting Hadoop clusters. Importing and exporting data from relational database into Hadoop cluster using Sqoop. Creating Hive, Pig and custom map reduce programs for analyzing data. Loading multiple larger datasets into HDFS and processing the datasets by using the Hive and Pig. Validating map-reduce jobs to support distributed processing using java, hive and pig. Writing Hive Queries for analyzing data in Hive warehouse using Hive Query Language (HQL). Experience in validating connectivity products that allow efficient exchange of data between core database engine and Hadoop ecosystem. Perform manual, penetration testing of client systems, web sites and networks to discover vulnerabilities along with configure, run and monitor automated security testing tools with Nmap, Burp and Metasploit. Perform application security testing with Authentications, Authorizations, Data protections, XSS, Inter & Intra N/W, Session Management etc. Collaborate with software development, system engineering and architect peers to continually improve system design, implementation and operations. Perform the PHI and Non PHI Data & Claim Payer analysis and data validation Guidewire Policy Center Clams. Perform source code analysis and programming on Java & .Net and manual validation on Git. Perform Web Services testing with soap UI and Rest for JASON and XML Files. Perform API testing with page filler tool for web-based applications. Perform white box testing for Java and .Net Based applications. Perform verification and validation on Oracle EBS and SCM apps. Perform database/ETL testing executing SQL and TSQL statements to test outcomes. Create and run tests for various purposes by using a broad range of tools for tasks such as synchronizing with WSDLs and validating messages and data with IBM RIT. Analyze large amount of data provided in spreadsheets using Excel features with macros. Ensure adherence to testing best practices and database testing (Store procedure testing, performance and data validation testing). Performed E2E & Integration testing with collaboration of other test teams to ensure test coverage between organizations meets expectations and exposes gaps expeditiously for websites. Performed Manual Functional, Mobile, ETL and Mobile testing in each sprint of the product using black box testing and track in the Rally/Jira/ALM/QC for website testing. Performed Functional and Penetration testing of the product using black box testing. Ensure adherence to testing best practices and database testing (Store procedure testing, performance and data validation testing). Perform BPM (PEGA PRPC) Architecting, PEGA Branding, and Thought Leadership, solution Architecture, capturing and documenting non-functional (architectural) requirements, preparing estimates and defining technical solutions to proposals (RFPs) along with design to deployment related activities, provide guidance, perform reviews, prevent and resolve technical issues. Debug, investigate ad perform inspections to resolve issues/defects and determine root cause as well as manage expectations for daily metrics of test execution and defects in the QC/ALM, Jira. Perform automated regression test strategies/tools for batch, flat file and web service-based interfaces. Involved in Development of Test automation framework and Developed automation suite (Cucumber-Selenium-Java) for regression testing. Experienced in developing and implementing Data Driven Framework, generic and application-based Keyword Driven Framework and Hybrid Framework in Selenium-Java. Writing Test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations. Experience in Data driven Testing, Cross browser testing and Parallel Test execution using Selenium WebDriver, Jenkin, Cucumber (Gherkin), TestNG and selenium Grid. Executing Selenium, Jenkin and Cucumber (Gherkin) Test Cases and Reporting defects in ALM/QC. Analyze and interact with complex sets of automated test assets and an ability to provide insights into alternatives or improvements to test systems, test framework components, test databases and test servers. Provide recommendations for execution of performance, automated tests and troubleshoot complex failures including failures of the system under test. Create Defect Documentation during all the test phase, defect tracking, management and reporting of found defects via Jira/ALM/QC. End Client: Moody s Investor Services Duration: Oct 2006 Nov 2014 Role: QA Project Lead Domain: Banking and Finance, Landing (Asset management) CRM, CCAR, Regulatory n Compliance Reports, HR system, Fixed Income and Derivative SDLC & STLC: Agile n Scrum Model, Water Fall and Iterative Model Project 1: Dodd Frank: Implementation of CCAR, Regulatory Rules, Disclosure with Rating Action, Disclosure Form, Credit Rating Action Definition, Implementation of Conflict-of-Interest changes, Disclosure corrections, Attestation, Affirmation, Jurisdictions, automatic jobs (Batch Files, Control M), Disclosure weekly reports and Internal Control reports. Project 2: Infrastructure (Windows 7 Certification MIS/MSS, MSP authorization changes, Arizona Project/DVL/Sybase Upgrade/CDC Infrastructures changes) and BPM Migration QA Project Lead and Tester Responsibilities: Create a cross team testing calendar (by business day) to expose the required test activities on a daily/weekly projection. This will serve as a road map in test planning to ensure data, system test environments, software & hardware s, resources, and tools are available proactively. Developed Project Plan & Strategy, update and maintain testing standards and procedures, Risk Based Test strategy, QA Process and Procedure, QA Templates, QA Metrics, Reports, Test Plan, Test Cases, Test Scripts and Testing Estimation in each sprint and releases. Established and controlled the test environments and Test Data set up for manual, database, API, Penetration, Performance and Automation Testing. Perform as business system analyst on functional and security testing requirements and create user stories in JIRA as well as especially related to coaching and or teaching agile teams. Gathered and analyzed requirements with end-users and product specialists and create traceability metrics. Assistance in the development of user stories, acceptance criteria and product backlog grooming and especially related to coaching and or teaching teams. Handling the test management in the agile environment for the landing portal with asset and wealth management. Analysis and knowledge/experience to implement and maintain framework components to support test execution; ability to share with others to create a sustainable system. Understand and involve in extensive interaction with onsite counterpart on BRS/SRS - prepared and provided by client/onsite coordinator. Create Test Strategy to provide the overall testing approach including team members, tools, guidelines, policies & processes. Create Test Plan to presents the test objectives, scope, approach, assumptions, dependencies, risks and schedule for a release. Work with Test Team members to enhance their testing skills, build technical and business knowledge as well as define test team member roles, responsibilities and deliverables. Create knowledge transition plan for offshore team, implement and measure effectiveness on regular intervals. Review of Manual Test scenarios (Risk Based) and Test cases prepared by Offshore and Onshore teams and get approvals from the Business teams Prepared Requirement Traceability Matrix. Allocated and supervised tasks to other team members. Determine time estimates and schedule for work efforts as well as coordinate the efforts of other testers. Define and utilize entry and exit criteria for testing. Perform Master Data Management with Microsoft SQL Server data services. Create Test Cases for specific tests defined to ensure business requirements are met and capture . Execute functional test cases based on windows and mainframe, C# .Net and J2EE/Java web-based applications. Perform manual, penetration testing of client systems, web sites and networks to discover vulnerabilities along with configure, run and monitor automated security testing tools with Nmap, Burp and Metasploit. Knowledge of various corporate security rules, legal and regulatory obligations such as PCI, SOX or similar standards. Perform Stress testing, Regulatory Reporting, Operational and Spreadsheet Risk, decision making and transparency with scenario analyzer tool. Collaborate with software development, system engineering and architect peers to continually improve system design, implementation and operations. Perform programming & development on Java and .Net to perform white box testing. Perform Web Services testing with soap UI and Rest. Perform white box testing for Java and .Net Based applications. Ensure adherence to testing best practices and database testing (Store procedure testing, performance and data validation testing). Performed E2E & Integration testing with collaboration of other test teams to ensure test coverage between organizations meets expectations and exposes gaps expeditiously. Performed Manual Functional, ETL and Mobile testing in each sprint of the product using black box testing and track in the Rally/Jira/ALM/QC. Performed Functional and Penetration testing of the product using black box testing. Coordinate the day to day activities of SIT and UAT/ATDD test phases with emphasis on collaboration with Business stake holders, Dev team, Release Team and Support team to deliver project on time. Perform IT ticketing systems, SNOW (Service Now), single sign-on, multi factor authentication, network based, VPN tunneling...etc. Ensure adherence to testing best practices and database testing (Store procedure testing, performance and data validation testing). Analyze large amount of data provided in spreadsheets using Excel features with macros. Debug, investigate ad perform inspections to resolve issues/defects and determine root cause as well as manage expectations for daily metrics of test execution and defects in the QC/ALM, Jira. Planned and executed regression test cycles manually and through automation QTP11.5 and UFT12.0. Define product test plans, criteria for user acceptance, user acceptance test cases along with define process, scenarios and test plan for manual user acceptance testing. Coordinate and create test models, Plan, Release control and execute assist application teams for assembly or product or component tests. Perform automated regression test strategies/tools for batch, flat file and web service-based interfaces. Involved in Development of Test automation framework and Developed automation suite (QTP11.5/UFT12.0) for regression testing. Experienced in developing and implementing Data Driven Framework, generic and application-based Keyword Driven Framework and Hybrid Framework in QTP/UFT. Extensively experienced in designing and creating reusable automated scripts using UFT descriptive programming, environment variables, and function library with delivering customized test results. Analyze and interact with complex sets of automated test assets and an ability to provide insights into alternatives or improvements to test systems, test framework components, test databases and test servers. Provide recommendations for execution of automated tests and troubleshoot complex failures including failures of the system under test. Create Defect Documentation during all the test phase, defect tracking, management and reporting of found defects via Jira/ALM/QC/Rally. Create and maintain high-quality documentation of all relevant specifications, systems, procedures, measurements and metrics to make effective and useful measures of the testing process status reports which provides progress toward testing objectives. Signed of the projects and Involved in the production release process then support to production support teams. Keywords: csharp continuous integration continuous deployment quality analyst business analyst user interface user experience business intelligence active directory information technology hewlett packard procedural language