Qa Analyst Sql Server

MOSAM PATEL

*************@*****.*** M : 469-***-**** linkedin.com/in/mosam-patel175

Current Location: San Antonio, Texas, USA

--

OVERVIEW:

A proven and exceptionally dedicated QA analyst with 10+ years IT experience and solid knowledge in development of requirements, specifications and testing process within the SDLC. PROFILE:

Extensive experience in Manual/Automated testing Web-based applications on several platforms.

Expertise in working with different databases like Microsoft SQL Server, Oracle.

Proficient in developing complex SQL queries, Stored Procedures.

Strong knowledge of Software QA methodologies, Testing Strategies and Techniques.

Comprehensive exposure to the complete Software Development (SDLC) and Software Testing

(STLC) Life Cycle including requirements gathering & analysis, test planning, execution and defect tracking & reporting.

Experience of reviewing Business Requirements Document, System Requirement Specifications, Functional Requirements Document and Use Case Document to developing Test Cases and Scripts.

Ability to interact with different teams across the organization and follow up on activities in support of project schedules.

Experience in performing testing on Front-end and Back-End Applications.

Proficient in all levels of testing including Integration, Functional, Regression, UAT, Database, Browser Compatibility and Ad hoc testing.

Excellent analytical, planning, reporting and communication skills developed through years of work experience.

Able to work collaboratively with Testers, Developers and other team members in testing complex projects.

Experience in Data Driven and Hybrid testing.

Experience to integrate automated test into CI/CD pipelines. TECHNICAL SKILLS:

Operating Systems : iOS, Android,Windows

Programming Languages : C, C++, Java, JSP, HTML

Testing Tools :Quality Center, ALM, Jira, Selenium, Postman,Soap UI, Maven, Jmeter

CI/CD :Github, Jenkin

RDBMS : Oracle, SQL Server 2008, MS SQL

Testing Artifacts : Test Plans, Test Strategy, Test Cases, Test and Defect Summary Reports, Traceability matrix

Testing Methodologies : Waterfall, Agile

EDUCATION AND CERTIFICATION:

Software Quality & Assurance Testing from Centennial College, ON, Canada – 2013

Master of Science in Computer and Information Technology - Gujarat University, India – 2007 PROFESSIONAL EXPERIENCE:

HELICORE INFO PVT.LTD,India (Oct2020-Jan2024)

Sr.QA Analyst

Worked on project gujaratpharmacycouncil.org, gscpt.in Responsibilities:

Review and Understand Business, Software and Functional requirements.

Created and reviewed Test plan documents.

Created Test Cases based on Business and Functional requirements.

Involved in Gap Analysis, Sanity/Smoke Testing, Regression Testing, Ad hoc testing.

Performed Database testing. Extensively used SQL queries to check storage and accuracy of data in database written tables.

Automated test cases using TestNG.

worked on cross browsing testing using selenium Webdriver.

Performed performance testing of web application and database queries using Jmeter

Identified, Analyze and document defects using Jira. Environment: ALM, Window 7, Java, SQL server, Jira, Maven, Selenium, Jmeter, Jenkins, Github EmergenceTek Group Inc., Buffalo, NY(March2017-March2019) Sr.QA Analyst

Worked on Health system (Care source)

Responsibilities:

Analyzed Software Requirement Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives.

Created and reviewed Test plan document.

Created Test Cases based on Business and Functional requirements.

Involved in Regression Testing and Functional testing.

Interact with Developers and Business Analysts to perform various types of testing throughout Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC).

Performed Database testing. Extensively used SQL queries to check storage and accuracy of data in database written tables.

Environment: ALM, Window 7, Asp .net, SQL server

Scotiabank, Toronto, Canada(Oct2014-Feb2017)

QA Analyst

Worked on multiple project like NFC and UA Kony App (Digital Banking) Responsibilities:

Review and Understand Business, Software and Functional requirements. Created and review Test plan documents.

Created Test Cases based on Business and Functional requirements.

Involved in end-to-end testing of the Mobile Application.

Identified, analyzed, and document defects using Jira.

Automated test cases using TestNG.

worked on cross browsing testing using selenium Webdriver.

Tested API using PostMan.

Executed SQL queries to validate data.

Environment: ALM, Window 7, Java, C, Github, Jenkins, Maven, Jira, Soap UI, Postman, Selenium, SQL Server

Incom Web & E-marketing Solutions, Toronto, Canada(Oct2013-July2014) QA Analyst

InCom Real Estate Web & e-Marketing Solutions creates websites for real estate agents and brokers. The focus of service is to deliver informative features that meet the demands of today’s buyers and sellers.

Responsibilities:

Created Test Cases based on Business and Functional requirements.

Tested and certified online systems, functionality of various websites and mobile applications.

Executed SQL queries to validate data.

Assists development with analysis and verification of software defects reported to determine validity and clarification.

Created test summary reports.

Environment: SQL Server, Windows 2008, Fengoffice, Aptana Studio 3, HTML TheAppLabb, Tronto, Canada(Jan2013-Sept2013)

QA Analyst

TheAppLabb is a leader in Strategy, Design & Development of Mobile & Web Apps. I worked on multiple projects like Shakespear at play app, Survey app, IRIE Music festival app and web based applications like Locawoka.com, finchwestonheath.com.

Responsibilities:

Review and update Test Cases as per requirement for different releases.

Involved in several projects in different SDLC stages.

Performed compatibility testing with various mobile platforms such as iOS & Android to ensure that functionality worked as expected.

Involved in Gap Analysis, Sanity/Smoke testing, Integration testing, Localization Testing

(Repository Testing), Regression Testing, and Ad hoc Testing.

Involved in the user acceptance testing to make sure that the application should work according to the client requirements.

Environment: Word press, SQL Server, Windows XP, Mobile Roadie, MS Office, Basecamp Jeenec Technology Pvt.Ltd, India(June 2007 -Aug2010) Int.QA Analyst

Jeenect Technology provides ecommerce solutions. It also provides eCRM solutions and MLM software solutions. I have worked for Model Cruz website. Model Cruz is an ecommerce website from where you can buy beauty products online. It gives information about models and you can also search for modeling job. You can get information about the modeling world. And worked on many more projects. Responsibilities:

Analyzed requirements to ensure they are concise and testable.

Created Test Cases based on Business and Functional requirements.

Performed Functional, Regression and Database Testing.

Executed Manual test cases and created traceability between requirements and Test Cases.

Analyzed test results to make sure that application was according to the specifications. Environment: Window7, SQL sever2008, Php, Base Camp

Contact this candidate