SUMMARY

• Over 12 years of experience in the field of Software Quality Assurance testing in Logistics, Banking, and Healthcare systems.
• Comprehensive knowledge of Agile software Development Life Cycle (SDLC)
• Hands on experience in creating, executing and maintaining test specifications for Functional, Integration, Smoke, Performance, Regression and User Acceptance Testing.
• Expert in writing Advanced SQL queries using TOAD and SQL for Database/Backend testing.
• Experienced in Web services testing using SOAP UI and Postman.
• Experienced with Automation testing tools like UFT using VB script and Selenium Web Driver, Selenium IDE using Python.
• Experience with Test Management tools like Quality Center, JIRA, and Rally.
• Worked as a principal & Validation SAS programmer in the production of analysis datasets, tables, graphs, and listings from clinical trial data.
• Hands on experience in Client/Server, web based and Database testing.
• Extensively worked in V - Model, Waterfall and Agile SDLC methodologies.
• Used SVN and GitHub as a source repository system to store and share code.
• Used Jenkins for Continuous Integration to Build, deploy/promote the build in various environments.
• Excellent presentation, problem solving, decision-making, documentation and communication skills.

TECHNICAL SKILLS

Operating System: Windows, UNIX, Linex, MS-DOS

Databases: Oracle, Sql Server, Sybase, MS Access, MS-SQL Server

Languages: .NET, Angular JS, Python, C, Shell, HTML, XML, VB Script, SQL, SQL Plus, PL/SQL

Test Build Tool: Jenkins

Testing Tool: Postman, Selenium IDE and Selenium Web Driver, SOAP UI, UFT, QTP 10.0

Defect Tracking tool: Jira, ALM, MS Office, HP Quality Center, Rally, Bug Tracker

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Quality Assurance Analyst

Responsibilities:

• Performed extensive testing in Web services/API testing with Postman.
• Validated Request and Response payloads in XML/JSON, SOAP, Restful Web service calls.
• Developed extensive Joins and Nested SQL queries to validate the correctness of data. Performed CRUD operations on database as needed.
• Executed PL/SQL scripts using SQL Plus.
• Developed automated test scripts in Selenium with Python and updated when required.
• Experienced in Microservices testing.
• Used SVN for version control and source repository
• Used CI/CD tools such as Jenkins to build and deploy in lower environments.
• Actively conducted/participated in all the Agile ceremonies.
• Analyzed functional requirements and estimated timelines on QA tasks as part sprint planning.
• Documented and maintained Test Scenarios, Test Cases, Test Scripts based on prioritized sprint stories.
• Ensured Definition of Done is met and business requirements are satisfied by the end of each sprint.
• Performed continuous Integration testing with multiple in-house systems/teams like EBM (Event and Billing Management), EBS (Oracle E-Business suite), SOA (Middleware), Confidential Connect and EZ-Book ( Confidential ’s Customer Facing application) in various environments.
• Used Jira for logging defects and tracking development and defect life cycle.
• Participated in Backlog Grooming sessions to review Epics and prioritize future sprints.
• Presented the developed MVP to Stake holders for review as part of Sprint Review meetings.
• Interacted with End Users and Subject Matter Experts as part of UAT support.
• Actively participated and supported in Defect Triage meetings during the phases of Mock Go-Live and Go-Live of the project
• Always a great team player with ability to collaborate with multiple Agile teams (Product Owners, Scrum Masters, and Development Team members)
• Worked to meet tight deadlines under immense pressure.

Environment: Oracle 12c, SQL Developer 4.0, Toad, Postman, Selenium with Python, Eclipse IDE, Robot Framework, UFT, Angular JS, .NET, SVN, Jenkins, Jira

Confidential, NJ

Software Quality Analyst

Responsibilities:

• Reviewed all Marketing Requirements and Software requirements to provide feedback from a user perspective.
• Developed Test Plan, Test specifications and tracked defects based on Software requirements and design specifications in Quality Center.
• Performed Installation testing, Functional testing, Regression testing and System Integration testing.
• Executed QTP Automated test scripts with Integrated Environment.
• Extensively worked in Waterfall model SDLC methodology.
• Provide Tech Support to NJ, GA, IL customers for installing new versions of DWOM release and answer all questions related to the new features.
• Resolve any show stoppers by Reinstalling, uninstalling, updating the LMSS system.
• Helped troubleshoot any technical problems faced immediately after production.
• Provided post-production support when product quality was affected by debugging and performed thorough testing to resolve the issues immediately.

Environment: Sybase, .Net 2008(Visual studio), C++, Quality center 9.2, QTP 10.0

Database QA Tester

Responsibilities:

• Extensively involved in reviewing requirements, creating Test design and Test plan development including requirement traceability.
• Executed complete test cycles for each product release, monitoring and analyzing test results, collecting test metrics and conducted test reporting.
• Coordinated with Business Analysts to synchronize the data across various systems and documented the white box test scenarios.
• Developed & executed complex SQL queries to analyze source data in SQL developer and reported data quality issues to the Data Management Team.
• Reported all the defects using Quality Center.
• Validated the data whether it is consistent with DEV/SIT/UAT environments and assisted analyzing the target data in all these environments.
• Performed both Integration testing, and User Acceptance testing.

Environment: Informatica Power Center 7.1/6.2, Oracle 10g, SQL Developer, Quality Center, and SharePoint

Database QA Tester

Responsibilities:

• Developed Test Plans, Test Cases and reviewed with the team.
• Validated that the data movement and transformations are done correctly
• Prepared status summary reports with details of executed, passed and failed test cases.
• Participated in regular project status meetings related to testing.
• Responsible for Creating Test Cases, Tractability Matrix and Test Coverage reports in Quality Center.
• Performed SIT, Functional, UAT and Regression testing.
• Extensively used SQL queries and SQL joins to verify Test scenarios.
• Responsible for the validation of data quality and consistency.
• Wrote SQL queries in SSMS to validated data within Target tables to ensure data is presented in the required format and there is no data loss from Source to Target tables.

Environment: ASP.Net 3.5, MS SQL Server 2008, SSMS(Sql Server Management Studio), Mercury Quality Center

Confidential, PA

Responsibilities:

• Performed Validation of Derived Datasets, Tables and Listings for clinical trial data
• Responsible for testing the clinical trial information systems, patient monitoring systems and Patient Scheduling applications.
• Responsible for developing Functional Test specification, Test Results and Regression Test cases based on MRS and SRS.
• Write, modify, and maintain Test Plan, Test Specification and Test Results Documents.
• Used In house Bug tracking tool (Bug Tracker) to report defects.
• Participated in end user training and submitted status reports weekly.
• Provided programming support for Phase I, Phase II, and Phase III clinical studies.
• Created Analysis Datasets from raw data files and modified existing datasets using Set, Merge, Sort, Functions and conditional statements.
• Reviewed validated Statistical Analysis Plan and annotated Case Report Forms developed by programmers.
• Worked on Pharmacokinetic data Validation Requirements Analysis.
• Generated Safety & efficacy datasets and tables.
• Extensively used SAS procedures like Proc Freq, Proc Means, Proc Univariate, Proc Compare, Proc Sort, Proc Transpose, Proc Format, Proc Sql, Proc Report, etc.
• Worked closely with System engineers, program developers, Statisticians, and Data managers.
• Generated output files in text format, HTML & PDF format using SAS ODS.

Environment: .Net, Sybase, Windows NT, SAS V9.0, SAS/BASE, SAS/MACRO, Multi Edit, Word, Excel.