SUMMARY:

• About 9 years of total software industry experience as Frontend and Backend database development & QA Testing Analyst involving both automated and manual testing projects
• Experience in analyzing, writing and debugging PL/SQL and advanced SQL queries
• Experience in Manual Testing and Automation Testing using QTP 9.2, Win Runner and Quality Center in Web and Client - Server applications
• Excellent know-how of Software Development Life Cycle (SDLC) and Lean Principles, a thorough knowledge of various phases such as Requirements, Analysis/Design, Development, Testing and Maintenance
• Good knowledge in Retail, Insurance, Financial and Health care segments
• Experienced in various categories of testing such as Functional, Regression, Integration, System, Database, User Acceptance Testing and Performance Testing using Manual and Automated approaches
• Proficient in preparing Test Plans, Test Specifications, Test Case Development, Bug Tracking & Reporting Systems and Traceability Matrix to map requirements to test scenarios
• Proficient in automated testing tools, especially QTP and QC
• Good Experience working in J2EE Environment and Microsoft Technologies
• Knowledge in writing advance SQL queries and Unix Scripts for data verification, backend testing and test data creation
• Experience in Database Programming creating Database Table and view definitions, stored procedures, functions and triggers
• Expertise in Back End Data Testing for the applications by writing SQL Queries, Functions and Stored Procedures
• Proficient in performing Black Box, White box, Functional, Regression, User Acceptance, Integration, System and Smoke Test
• Proficient in GUI testing by inserting various verifications and data driven testing for functionalities that requires inputting dynamic data
• Having good experience in product based testing with different builds and configurations
• Proficient in analyzing Business Requirements, Specifications, Development of Test Strategy, Test Plans, Test Scripts, Test Cases
• Swapnil works effectively with minimum supervision
• Highly self-motivated, task-oriented and has ability to drive tasks and activities to closure. Recognized and appreciated for contribution for few financial domain projects in Cognizant
• Well organized and has capacity to multitask effectively
• Have good analytical, critical reasoning with good written and oral communication skills
• Have willingness, ability and passion to work in a fast paced environment
• Has ability to understand long-term and short term perspective of situations and look thing in big-picture
• Dedicated to quality and has attention to details. Believes in reviews and avoids reworks
• Works proactively and has capacity to visualize and act in time
• Played following as in previous engagements:
• Developer and Tester
• Quality Analyst and single point of contact for Software Process Audits

TECHNICAL SKILLS:

Testing Tools: Selenium WebDriver, QTP, Quality Center, Test Director, Rational SQA Suite7.1/2001, Rational Robot, SQA Clear Quest, Clear Case and PVCS Tracker, Cognizant Prolite

Databases: Oracle 10g, MS SQL Server, MS Access, DB2

Version Controlling Tools: PVCS, Visual Source Safe, SVN

Programming and Scripting Languages: VBScript, SQL, PL/SQL, Unix Shell Scripting, HTML, Java & JavaScript, TSQL

Operating System: Windows NT/95/98/2k, Unix

Methodologies and Concepts: SDLC Concepts (Waterfall & Agile/Scrum Programming Methodologies)

PROFESSIONAL EXPERIENCE:

Confidential

Software Dev Engineer Test

Responsibilities:

• Functional testing of various online modules of Confidential including Kmart,Shopyourway.com
• Involved in testing using Selenium WebDriver and TestNg framework for automation testing
• Interacting with business analysts to understand business and technical requirements
• Creating test strategy, test plans, test cases and test logs for all the modules of the product
• Interacting with development teams and development manager on test execution strategy, brainstorming on approach and strategies and plan
• Executing test cases for functional and A/B testing and documenting test results by applying cross site scripting and Advanced SQL queries and Unix scripts for data migrations and test data creation.
• Creating defects and maintaining issue log on Jira
• Interacting with developers to evaluate defect severity and defect re-testing schedules
• Creating and maintaining of Test Coverage Matrix to ensure test coverage is adequate
• Participating in Defect Management and problem resolution during execution
• Participate in Daily/Weekly Project SCRUM meetings with Product Management team
• Interacting with product support team to understand post-production defects in existing products

Technologies, Tools & Skills used: Agile Development & Sprint Testing, Backend testing, Web Testing Advanced SQL, JavaScripts, MS Office, Selenium Web testing, TestNg, JIRA, SVN, SPIRA Test management

Confidential

EDI Testing Analyst

Responsibilities:

• Involved in EDI transaction testing (Using SAP Ariba platform)
• Creating and maintaining of Test Coverage Matrix to ensure test coverage is adequate
• Participating in Defect Management and problem resolution during test execution
• Participate in Daily/Weekly Project team meetings with Product Management team

Technologies, Tools & Skills used: Agile Development & Sprint Testing, Backend testing, Warehouse Management System (WMS), Supplier relationship management (SRM) Advanced SQL, MS Office, Quality center, SAP EDI testing, EDI/Ariba, Oracle Micros-POS testing

Confidential

QA Testing Analyst

Responsibilities:

• Functional testing of various online modules of Confidential including Kmart, Craftsman, Kenmore and Confidential
• Involved in testing using Selenium WebDriver and TestNg framework for automation testing
• Interacting with business analysts to understand business and technical requirements
• Creating test strategy, test plans, test cases and test logs for all the modules of the product
• Interacting with development teams and development manager on test execution strategy, brainstorming on approach and strategies and plan
• Executing test cases and documenting test results by applying cross site scripting and Advanced SQL queries and Unix scripts for data migrations and test data creation
• Creating defects and maintaining issue log on Jira
• Interacting with developers to evaluate defect severity and defect re-testing schedules
• Creating and maintaining of Test Coverage Matrix to ensure test coverage is adequate
• Participating in Defect Management and problem resolution during execution
• Participate in Daily/Weekly Project team meetings with Product Management team
• Interacting with product support team to understand post-production defects in existing products

Technologies, Tools & Skills used: Agile Development & Sprint Testing, Backend testing Advanced SQL, JavaScripts, MS Office, Selenium Web testing, TestNg, JIRA, SVN

Confidential

Product QA Testing Lead

Responsibilities:

• Functional testing of 3 major new products based on PL/SQL and Oracle Forms launched by Mediware.
• Interacting with business analysts to understand business and technical requirements
• Creating test strategy, test plans, test cases and test logs for all the modules of the product
• Interacting with development teams and development manager on test execution strategy, brainstorming on approach and strategies and plan
• Executing test cases and documenting test results by applying cross site scripting and Advanced SQL queries and Unix scripts for data migrations and test data creation
• Creating defects and maintaining issue log on Quality Center
• Interacting with developers to evaluate defect severity and defect re-testing schedules
• Creating and maintaining of Test Coverage Matrix to ensure test coverage is adequate
• Participating in Defect Management and problem resolution during test execution
• Participate in Daily/Weekly Project team meetings with Product Management team
• Participating in Audits for FDA approval
• Guiding and leading 4 QA testers on the team and reporting their progress to the product management team
• Communicating and documenting testing Risks and Issues
• Get Sign off from all stakeholders on the Test deliverables
• Interacting with product support team to understand post-production defects in existing products

Technologies, Tools & Skills used: Agile Development & Testing, Backend testing Advanced SQL & PL/SQL, Oracle Forms, MS Excel Macros, VB Scripting, MS Office, Unix Shell Scripting, QTP, Quality Center, Silk Software Test Management

Confidential

Responsibilities:

• Review Project Plan, participate in Requirements Planning sessions and ensure Testing Information is adequate
• Provide Test estimates and plan for resource requirements
• Create of Test Strategy
• Involve in System, Regression and Acceptance Test Planning
• Creation of System, Regression and Acceptance Test Plans
• Participate in test scenario’s and test cases review
• Creation of Test Coverage Matrix to ensure test coverage is adequate
• Execute System and acceptance Testing
• Participate in Defect Management and problem resolution during test execution
• Participate in Daily/Weekly Project team meetings
• Provide testing status to reporting manager and Project Team during System, Regression and Acceptance test execution
• Communicating and documenting testing Risks and Issues
• Get Sign off from all stakeholders on the Test deliverables.
• Hand over the tested software to Production

Technologies, Tools & Skills used: Web-Testing, Agile Testing Methodology Advanced SQL & Stored Procedures, Oracle, HTML, JavaScript, MS Excel Macros, Unix Shell Scripting and batch processing, HP QTP

Confidential

Responsibilities:

• Preparation of Test Plan
• Preparation of internal Test schedule from High level Project schedule and adhere to the same.
• Escalate issues through Issue Tracker tool and track them to closure
• Test Case Preparation / regular updation
• Test Case Execution, Regression testing, Performance testing and Adhoc Testing
• Log bugs and track them to closure
• DSR/WSR Preparation and forwarding for reporting manager’s review
• Close interaction with the developers
• Participate in weekly team meetings

Technologies, Tools & Skills used: Backend Testing & Waterfall SDLC Methodology Advanced SQL & Stored Procedures, DB2, MS Excel Macros, Unix Shell Scripting and batch processing, Quality Cente