Post Job Free

Resume

Sign in

Quality Assurance Sql Server

Location:
Allen, TX
Salary:
100k
Posted:
September 03, 2023

Contact this candidate

Resume:

Mahesh Rajanala

+1-813-***-****

adzf44@r.postjobfree.com

PROFESSIONAL SUMMARY:

Having 10+ years of experience in Software Quality & Testing, Manual & Automation testing with expertise in the testing of Web-based Applications, Mobile Applications, APIs, and database testing.

Proficient in Software Development Life Cycle, Software Testing Life Cycle, and Defect Life Cycle.

Proficient Agile Development Model, Waterfall Model, and V Model.

Expertise in Identification of Project Objectives, Review of Business requirements, Design documents, and providing Test Effort estimates.

Proficient in formulating Test Strategies, Test Plans, Test Scenarios, Test Cases, Test Scripts, and Test Summary Reports for both Manual and Automated Testing.

Experience in Functional Testing, Integration testing, System Testing, Database Testing, Regression Testing, Exploratory Testing, UAT Testing, UI/UX Testing, Browser Compatibility Testing, Usability Testing, Accessibility Testing.

Expertise in XML Validations, Reporting Defects, and Root Cause Analysis.

Experience in using tools like Azure DevOps (VSTS), JIRA, HP-ALM, BrowserStack, SharePoint, Confluence, API Testing Tools - Postman, ARC Tool, Swagger UI, Accessibility Testing Tools - UsableNet AQA Tool, Wave Tool, and Braze Tool.

Played a key role, working in Agile Projects and participating in Sprint Ceremonies, Bug Triage meetings.

Tracked product evolution by actively collaborating with Developers, Product Owners, Scrum Masters, and project team members through the entire software development life cycle.

Experienced in web services/RESTful services/API testing using Postman/Swagger UI/Rest Client, REST-Assured Tools.

Experienced in developing Automation Framework and related tools/libraries like Selenium WebDriver with Java, Maven, TestNG, GitHub/GitLab, and Jenkins.

Experience in writing automation test scripts using the Cucumber (BDD) framework and creating feature files in Gherkin Language.

Experienced in Mobile app testing on platforms like iPhone(iOS), IPad, Samsung (Android), Windows.

Exposer on latest Mobile Automation tools like Appium WebDriver.

Experience in Code reviews and good knowledge of using Repository Hosting services using GitHub.

Extensive Knowledge of Automating end-to-end functionalities of applications across different platforms.

Experienced in performing Automation Smoke and Regression Suite Scripts executions, analysing the Summary reports.

Executed automation scripts on different browsers/environments by using Jerkins & reported defects/results to the team.

Experience in POS Software Testing, involved in setting up of QA Test environment with simulated POS test environment and validating POS transactions.

Ability to write SQL Queries and backend database testing using Microsoft SQL Server, MySQL, PostgreSQL including validating stored procedures and triggers.

Experienced in working with multiple projects simultaneously and reporting the issues to higher management and monitoring the project delivery in terms of schedule & effort.

Participated in Production support/Production Shakeout Testing by troubleshooting and identifying problems and validating of builds in the production environment.

Expertise in Software Test Management, Business Analysis, Quality Assurance, Process Engineering, CMMI, ITIL and ISO Standards. Led the implementation of CMMI, ITIL & ISO Certifications.

Experienced in working with Onsite and Offshore project teams and managing the offshore QA team.

Providing functional training and presentations to the team on new features and new functional and Integrated feature validations.

Able to apply strong analytical, problem-solving, judgment skills to balance delivery content, quality, and timing.

Excellent interpersonal skills, commitment, result-oriented, hard-working with a zeal to learn new technologies and undertake challenging tasks.

TECHNICAL SKILLS:

Operating Systems

UNIX, Windows, Android, iOS

Languages

C, C++, Java, PL/SQL, ASP, HTML, TSL

Scripting Languages

Groovy, JavaScript, Shell scripting, TSL

Databases

Microsoft SQL Server, Oracle Server, DB2, MySQL, PostgreSQL

Test Management Tools

ALM, HP Quality Center, JIRA, Rational Test Manager, TFS, Azure DevOps, ClearQuest, TRAC

Automation Tools

Selenium WebDriver, Eclipse IDE, Maven, TestNG, JUnit, Jenkins, Cucumber

API Testing Tools

REST API, Postman, Swagger UI, SOUP UI

Domains

Health Care, eCommerce, Retail,, Supply Chain Management, Logistics

Others

Microsoft Azure Cloud, HP Performance Center, JMeter, Bugzilla, LoadRunner, VuGen, SiteCore, Omnivore, AurusPay, TransactionPlus (T+), SVSGift, POSi, Cheetah, MessagingHub, Braze, Paytronix, VSTS, Onosys, QuickTest Pro (QTP), TFS, AQA for ADA, Wave tool, Test Manager, Silk Test, Silk Performer, Selenium WebDriver, BrowserStack, Appium, Rational suite, Rational Test Manager, Sitefinity, ClearQuest, Clear DDTS, ClearCase, Doors, Rational Rose, Documentum, HP Diagnosis, HTTP Watch, SiteScope, BMC, ARC Tool, AppDynamics, Dynatrace, HP Diagnosis, HTTP Watch, Perfecto Mobile

EDUCATION

»Master of Computer Applications (MCA) - Sri Venkateswara University, AP, India

»Bachelor of Science (B. Sc.,) - Sri Venkateswara University, AP, India

CERTIFICATIONS

Testing:

»Certified Software Tester (CSTE) - Quality Assurance Institute, USA

»ISTQB - Testing Certification – Certified

Languages:

»MCP - Microsoft Certified Professional for Designing and Implementing Databases using SQL Server

»MCP - Programming with Visual Basic 6.0

QA Process:

»Certified Lead Auditor- ISO 9001:2001 – DNV

»Certified Lead Auditor-ISMS (ISO 14001:2005) – IRCA certified.

»Six Sigma Black Belt Certified

Project Management:

»PMP Trained

»Certified Scrum Master (CSM) – Agile

»ITIL V3 Certified

Trainings and Seminars:

»PMP Training, Capgemini, Hyderabad

»Global SEPG summit

»Microsoft Azure Fundamentals (AZ-900) by Microsoft

»CMMI Overview Training – QAI, Software Estimation

PROFESSIONAL EXPERIENCE:

Cigniti Technologies Ltd. Period of Employment

Client: Bloomin Brands Inc (08/2016 to till Date)

Role: Senior QA Analyst

Project: eCommerce Online Ordering Applications, Brand Sites, and Mobile Apps

Description:

A Leading E-Commerce platform that will support current websites and online ordering while providing a foundation for Next Generation, personalized digital experience with integrated commerce. BBI has Online Ordering (OLO) Websites, Brand sites, and third-party websites which need to be tested to make sure orders are placed successfully. The Integration systems also need to be tested to make sure the end-to-end online ordering process is implemented smoothly.

Responsibilities:

Working on Agile methodology and participating in all scrum ceremonies

Analyzing User stories, identifying Test Scenarios, and designing Integration scenarios for test cases

Test Data Preparation, analysis, and Test environment setup

Executing Test Cases on Mobile devices, iPods, Tabs, and Desktops

Performing Smoke Testing, Functional Testing, Regression Testing, Integration Testing, Re-testing, Exploratory Testing, User acceptance testing, End-to-End testing

Executing Mobile App Test Cases on Mobile Apps, Beta Version Apps, and Production Apps

Performing API testing and validating the response and performing the Messaging Hub validations to ensure the request and response are stored in the right queue and processed as expected.

Maintaining and updating Automation test scripts and sharing the required information with the offshore team in writing scripts and validations

Perform the Automation Smoke and Regression suite executions on multiple devices, analyze the results, and share the results to the team.

Bug reporting and providing additional information to the Dev team to fix the bugs.

Participating in Bug Triage meetings in regular intervals with Dev, BA & Product Owner

Bug re-testing and updating the status with screenshots and logs.

Bug Tracking, generating Test Run results and Bug Status logs.

Identifying the Integration scenarios related to bugs, identifying the root cause of issues, and validating and updating the tests

Working with onsite and offshore product teams and assigning automation tasks to the Offshore team

Providing training/presentations to Offshore team on new tools and new features and new functional and Integrated feature validations

Sharing of Manual and Automation daily, weekly status reports, and metric reports to the team at the end of the Sprint

Technologies & Tools: Azure DevOps/ Microsoft VSTS, Site core, CMS Server, CCM Server, Store Admin Tool, Menu Admin Tool, Azure Storage Explorer, POS Systems, Mobile devices, MS SQL Server Management Studio, BrowserStack, Swagger Tool, Postman, Eclipse, Java, Selenium WebDriver, TestNG, Cucumber, GitHub

Project: Carrabba’s Online Ordering Application

Responsibilities:

Worked on Agile methodology and participated in all scrum ceremonies.

Worked with QA offshore team and lead a team of 6 members.

Planning Automation Testing Activities and assigning tasks to the team.

Prepare Test plans, Test Strategy, and Framework for the Project

Preparing automation test estimation efforts

Understanding Product requirements and Functional workflow module

Involved in the creation of a single Test Framework to test different concepts applications.

Prepare a user guide for different internal tools for the testers to use effectively.

Review Smoke, Functional, Regression and system-level Test Cases and perform executions.

Used Java as a programming language and Eclipse as IDE for automating the Test Suite with Selenium WebDriver

Design and develop the Gherkin scripts and automate them in Cucumber under BDD framework with Page Object Model (POM) design pattern and used Maven to integrate with Jenkins for easy executions, report generation, and GitHub for version control.

Executed the automation scripts in parallel on different environments/browsers using Selenium Grid, Jenkins, Maven and sent the reports to the team members.

Used Jenkins Continuous Integration tool to trigger the timely/ nightly executions.

Parallel Cross-browser testing using Selenium Grid & TestNG on IE, Safari, Firefox, Chrome

Automation ROI presentation to senior leadership

Performed Data-driven testing by passing multiple sets of data using CSV.

Create User-defined functions for reusability purposes and to avoid redundancy in the Scripts.

Responsible for testing and automating Web Services using Postman and REST Assured API tools.

Proactively identify ways to improve testing processes and techniques.

Providing daily and weekly automation testing status reports.

Technologies & Tools: Selenium WebDriver, Java, Eclipse, TestNG, Cucumber, GitHub, Azure DevOps/ Microsoft VSTS, Site Core, CMS Server, CCM Server, Store Admin Tool, Menu Admin Tool, Azure Storage Explorer, POS Systems, Mobile devices, MS SQL Server, Browser Stack, Swagger Tool, Postman

Capgemini India Private Ltd. Period of Employment

Lead Consultant (01/2010 to 05/2014)

Testing: Overall responsibility for Test Management and Quality Activities

oCoaching and mentoring testing team, Metrics, Templates, Defect Analysis

oGuiding Project Managers and Delivery teams in project Quality Assurance

oValidating the defect reports and ensuring metrics, SLA compliance

Process: Ensuring projects compliance to CMMI, ISO, ISMS, ITIL, and other certifications. Performing Gap Analysis for Process definition and implementation, Defect analysis

Setting up and ensuring implementation of processes for the Account

Preparing & Review of Process Definition, Process Implementation of CMMI

Publishing of the weekly Quality status report with comprehensive coverage of Financial, Delivery, and Process related risks and issues to Senior Management

Achieving projects compliance to Contractual terms, SLAs, and various internal and external audits (CMMI, ISO, ISMS, IAG-Internal Audits).

Supporting process improvement initiatives (M-Review, Project Health Index improvements)

Responsible for leading the testing, NOVA Project. The NOVA project is related to the lifecycle management of the Infringements, Court Orders, and Warrants modules related to the resolution of the traffic offenses committed in Victoria State. This system helps in internal and external correspondence and handling of the interfaces with other systems such as VicRoads, Print House, etc., for effective communication of the data. Worked on Website testing, Database testing, and process enhancements.



Contact this candidate