Summary
Overview
Work History
Education
Skills
Software
Timeline
Generic

Shubham MISHRA

Gurugram

Summary

Experienced QA Lead adept at orchestrating comprehensive quality assurance strategies encompassing automation, performance, and security testing methodologies. Possessing a robust understanding of Azure DevOps, I've effectively streamlined QA processes and fostered collaboration between development DevOps and QA teams to ensure the delivery of high-quality software products. With 8.5+ years of hands-on experience, I've lead the implementation of automation frameworks, enhancing test coverage and accelerating release cycles while maintaining rigorous quality standards. My proficiency in performance testing has resulted in optimized system scalability and reliability, contributing to enhanced user experiences. Additionally, my work in security testing has enabled proactive identification and mitigation of vulnerabilities, ensuring compliance with industry regulations and standards. As a strategic leader, I am committed to nurturing a culture of innovation and continuous improvement within QA teams. I am now seeking to leverage my skills and experience to drive excellence in QA practices and contribute to the success of "Condeco by Eptura"

Overview

7
7
years of professional experience

Work History

Lead Quality Assurance Engineer

Condeco by Eptura
Gurugram
07.2022 - 09.2022
  • Effectively manage three different Quality Assurance teams Ensure that automation efforts are well-maintained, scalable, and provide meaningful test coverage in Selenium, SOAPUI and Jmeter to support the release cycle. Prioritize performance testing to ensure that the products meet performance benchmarks under various conditions and optimize resource utilization. Integrate security testing using Burp Suite and ZAP into the QA process from the early stages of development to identify and address vulnerabilities proactively meet compliance such as GDPR and HIPAA.
  • Handling QA team of products like Microsoft Outlook Store Add-on, Microsoft Exchange Sync(On-premise and cloud base application), Microsoft Office 365 integration, Microsoft Teams Chatbot and Admin API (using Azure APIM which is Organization Central API collection used in different integrated products)
  • Coordinating and tracing progress of cross team product feature and requirement which leads beneficial discuss with managers and Product Team for time saving and futuristic vision.
  • Majorly derived Sprint Planing, teams bandwidth calculation, story point evaluation and spill over evaluation.
  • First responder for troubleshooting production environment misconfigurations issue. Provide KT time to time to QA team and DevOps Team.
  • Ensure QA team triage PRBs(Public reported bugs) within one day of reporting.
  • Maintained multiple QA Environment for Functional(Current release), Performance Testing, Backward Compatibility, In-progress Feature(Future release) and Demo environment for CSMs and Product Team with coordination.
  • Having Deep knowledge of Hosted IIS server based application (DNS Mapping with IP, Load Balancer, Host entry, app pool configuration, as well as Cloud base application.
  • 7+ years of enriched experience of Azure single tenant as well as multi-tenant application as SAAS and PAAS product.
  • Good knowledge of Azure deployment and Infra. Application deployed as Azure Web service, Azure Function app and Azure CDN base deployment, RBAC(Role Base Access Control) policies, AD App registration in Azure EntraID (Azure AD), fetching sensitive information from Azure KeyVault, load balancing through Azure front door(frontdoor design and rule), fetching feature flag info from Azure App Configuration, Store temp information in Azure table storage (using table services and queue services), SQL and Azure Cosmos DB, Azure Kubernetes services , logging in Log Analytics workspace(previously used app insight), Active and passive Event Grid and Azure service bus, Azure VM, Azure automation Run book.
  • Created confluence product knowledge, release(includes microservice version control) and limitation documentation for each setting and cases in different product application with version compatibility of integrated products of Enterprise. Also create confluence report for API automation and collective report of Performance runs.
  • Segregate tickets and bugs for different products on basis of release version and Sprints. Also relabeled on basis of product version and segregate test cases in JIRA, QTest and TestRail after reviewed.
  • Designed automated Jmeter performance suite for Integrated product which create data in one click dynamically through configuration of number of tenant, number of user per tenant and number of resource utilized with time shift. Suite include DB validation as well as azure table validation and validate whether data synced on microsoft O365 calender through Microsoft Graph API including failure and logs.
  • Ensure team automate new API test cases and maintain existing cases in SOAP UI. Enhances SOAP API automation suite using configuration file. Set configuration on project level which remove particular site dependency and create base data for new site. Also integrated VSTS which publish report using Azure blob container, Slack and Teams webhook.
  • Integrated Performance suite with VSTS (CI-CD) pipeline using powershell and bat file. implemented mechanism to publish PDF report using azure blob container which gives information about run status.
  • Created Base Data creation jenkins job, which create all the data used in selenium run through SQL queries and stored key value pair in newly generated table in DB.
  • In previous project(Enterprise product) automated and maintained more than 400 UI test cases in Selenium automation frameworks having Page Object Model (POM) and Behavior-Driven Development (BDD) frameworks Cucumber integrated through Jenkins pipeline (CICD), selenium hub and 5 node for completing entire run in 2 hrs. Jenkins pipeline use to send report on slack through webhook.
  • Maintained and keep automating new test cases for new UI feature in Microsoft Outlook Store Add-on through selenium.
  • For cloud environement Cost Optimization, created Azure Automation runbook scheduled utility for auto scale down Azure web service App plan tier and SQL db DTU in Azure Subscription through Azure automation Run book. Also having option for exclusion list.
  • Also automated adding and removal of routing rule from Azure Frontdoor in office hrs and out of office hrs using VSTS YAML pipeline for cost saving pourpose.
  • License verification for application for different product. Client Onboarding through webpage(AD app redirection URL), Onboarding APIs as well as VSTS pipeline, grant consent from client for Azure AD graph and application permission used in different products, Token mechanism for AD app.
  • Successfully released products Microsoft add-on on Microsoft store and Teams chatbot app on Teams app center, which requires to pass Microsoft benchmark and verification. Also update time to time for new feature and updates.
  • Regional Data Migration of client using Azure run book and Azure orchestration function migrated and validated Azure table storage bulk data of multiple clients to different infra region and across different Azure subscription. Utility help in production data migration activity.
  • Strategize and given KT with in teams and to cloud-ops for VSTS Azure deployment pipeline through JSON and YAML Pipeline using variable group, PAT Token, service principle and subscription ID as fresh for new and as update for existing client. Also added Snyk integration in all pipeline repository.
  • Verified and Given KT within team and to Dev-ops for release strategy using azure build artifacts and stage on basis of BitBucket, Gitlab and GitHub version control for different microservices and Azure Blue-Green regional deployments.
  • Determined in-progress feature implementation should behind feature flag and off by default. And always validate n-1 backward compatibility between integrated products.
  • Automated validation process for migration of data from obsolete(Microsoft Exchange Sync) product to New enhanced product(MS365Integration).

Senior Quality Assurance Engineer

Condeco
Gurugram
09.2018 - 06.2022
  • Relabeled and segregate test cases in Zephyr, Test Rail and QTest after cross review. Also marked obsolete test cases time to time. Test Cycle creation and execution for functional and regression cases.
  • Performed Functional, Infra and Performance Testing for Multi-Tenant SAAS product developed on Azure Cloud microservice based infrastructure.
  • Performed Smoke, Functional, Ad-hoc and majorly involved in Integration testing between Microsoft Azure APIM, Microsoft Exchange, Enterprise and Microsoft Outlook web Add-on.
  • Completed automation of regression test cases for Outlook web Add-on through Selenium BDD.
  • Created and integrated SQL script for Base Data Creation on which selenium suite run.
  • Automated IOS and Android app using Appium.
  • Integrated ZAP suite with selenium web automation.
  • Identified security bugs in application Injection(SQL and XSS), Broken Access Control, Cryptographic Failures(Sensitive Data Exposure), Identification and Authentication Failure, insecure design.
  • Created utilities which create hierarchical data in Enterprise application, Microsoft Exchange through Powershell, SOAPUI and Jmeter.
  • Validated application developed on Azure COSMOS document DB having shared as well as separate DB collection.
  • Enhance SOAPUI automation suite using JARs for fetching data from Azure COSMOS document DB. Deployment type Shared collection as well as dedicated collection.
  • Created Jmeter utility which help in creating performance run data in one click with configuration file and executed through VSTS pipeline.
  • Executed WM application performance run using Jmeter and documented on confluence for different product with proper road map.
  • Developed Jmeter script which validate data propagated properly throughout microservice base Azure application having different components, modules and Azure table storage.
  • Handled Blue-Green deployment through VSTS on multi-region infrastructure for high-availability of deployed application.
  • Verified User Subscription and renew subscription mechanism for Multi-Tenant product based on Azure storage queues.
  • Validated and deployed VSO Build JSON pipeline and YAML pipeline using inline variable, variable group, powershell and ARM template script which provision resources in Azure.
  • Verified MSMQ(Microsoft Messaging Queue), scheduler, Azure web service web jobs and Azure Service bus based application.

Quality Assurance Engineer

Condeco
Gurugram
09.2015 - 08.2018
  • Collected and analyzed knowledge for Enterprise Application as well as touch screens component(Firmware update and Kernel update).
  • Developed and maintained SQL useful Queries using joins and publish on confluence page, still fruitful for QA teams.
  • Verified Com-Addin application created for integration Enterprise application to native Microsoft outlook application.
  • Developed Coded-UI framework to automate native Microsoft outlook application using C#.
  • Learned and start writing BDD Selenium script in Cucumber framework in initial days, after developing coding reviewing skills to framework creation, enhancing and managing.
  • Automated positive and negative test case in SOAP UI and configured daily Jenkins Job which post result on SLACK.
  • Integrated Zephyr APIs in Selenium and SOAP UI framework, where automatically created Zephyr Test cycle, Add Test cases to Test Cycle and Test cycle execution and Result publishing on SLACK though Webhook.
  • Developed CI/CD Jenkins jobs to deploy build package on IIS server and run DB incremental script on SQL DB.
  • Achieved Jenkins CI/CD Job deployment for Load Balancer IIS server environment.
  • Created build comparison and DB comparison utilities using Integration of Jenkins, Beyond Compare, Red Gate and Powershell.
  • Reported highest Priority bugs Based on TimeZone Offset, DST, JWT Token and Signature, Broken Access Control, SQL injection, Cross Site Scripting (XSS), Application cache, Browser Roaming Setting, Scheduler MSMQ and Triggers.
  • Efficiently Manage Time and Task, also add logging In JIRA.
  • Initiated Microsoft Azure learning by own as technology new for company.
  • Created Chrome Extension using HTML, CSS and Java Script which help in parking system for the company.
  • Demonstrated leadership by making improvements to work processes and helping to train others.

Education

B-Tech. - ECE

Skyline Institute Of Engineering And Technology
Greater Noida
07-2015

Skills

  • Selenium, Java, JavaScript, Groovy and Beanshell
  • SQL
  • Cosmos DB (NoSQL)
  • Powershell and Bat command
  • Highly complex performance scripting in Jmeter(UI API)
  • Rest APIs
  • SOAP UI
  • Postman(JavaScript for Prerequisite Scripting and Tests)
  • Good Command in Azure Devops
  • VSTS and Jenkins
  • Bitbucket, GitLab and GitHub
  • Jira, Zephyr, Qtest and TestRail
  • Microsoft graph APIs
  • Microsoft Exchange

Software

  • Postman, SOAPUI, Jmeter
  • Eclipse and STS(Spring Tool Suite)
  • Burp Suit and ZAP (Firefox)
  • SSMS
  • Powershell IDE
  • Redgate
  • Beyond Compare
  • Notepad++
  • Azure Storage Explorer
  • Azure Data Studio

Timeline

Lead Quality Assurance Engineer

Condeco by Eptura
07.2022 - 09.2022

Senior Quality Assurance Engineer

Condeco
09.2018 - 06.2022

Quality Assurance Engineer

Condeco
09.2015 - 08.2018

B-Tech. - ECE

Skyline Institute Of Engineering And Technology
Shubham MISHRA