System Project

Priyanka Seth

Email: ******@*******.***

Contact # (R) 609-***-****

(M) 732-***-****

To obtain a responsible and growth oriented position as a QA Analyst/Tester where I can apply my strong academic, analytical and technical skills.

Specific QA experience includes:

• 7 years of experience as a QA Analyst/Tester and 2 years of experience as QA Compliance Associate –IT systems

• Strong understanding knowledge of the SDLC and STLC processes

• Proficient in analyzing user and functional and business requirements and relating each requirement to the design specifications.

• Proficient in preparing Test Plans, Test Scripts and Test Cases for Web-based applications and Client-Server applications.

• Analyzing system critical functionality and creating out of the box scripts to exhaustively test them.

• Extensive working experience in Black Box, System Testing, Functionality Testing, Regression Testing, Integration Testing, UAT, Database Testing, Smoke Testing, Back-End Testing, Interface Testing, Defect Logging (using Bugzilla, Jira, MQC) and Verification of Fixed Bugs.

• Performed Database Verification & Validation testing using Oracle, MS SQL Server databases.

• Performed Computer System Validation audits of both in-house and vendor systems.

• Performed audits of IVR systems.

• Experience in writing sql queries and unix shell scripts.

• Good Interaction with developers, managers and team members including off-shore support.

Operating Systems : Unix, Windows 95/98/NT/2000/Enterprise, MS DOS.

Hardware : HP9000, IBM Compatible PCs.

Languages : SQL, PL/SQL, VC++, C++, Java, HTML, Java Script, VB Script.

Networking : Unix Shell Script, Telnet, FTP, TCP/IP.

RDBMS : Oracle 9i, Rapid SQL 12.5, Sybase.

Automated Test Tools : Win Runner 7.0/6.0, Quick Test Pro 9.2, Test Director

7.0/6.5, Mercury Quality Center 8.2.

PharmaNet Inc, Princeton NJ

QA Compliance Associate – IT Systems July ’10 – till date

1. Internal Audits and Processes

• Process Audits

• Involved in review of validation documents of internal systems (off-the shelf and home grown) and its compliance with applicable SOPs

• Involved in review of specific IT processes like Backup & Restore and Disaster Recovery

• Involved in performing QA reviews of IVR study validation documents.

• Involved in performing validation of regulated systems as per FDA requirements

• Clarified issues noted during audits (IT and IVR) with the subject matter expert.

• Involved in review of UAT documents and providing training on preparation of UAT documents and test scripts

• SOP Management

• Involved in review of draft SOPs and Policies

• Involved in creating the user requirements for a new SOP management system

• Performed UAT testing of the SOP training system

2. External Audits

• Vendor Audits

• Participated in 6 vendor audits

• Reviewed the system validation documents to verify that the SDLC cycle was followed.

• Reviewed 21 CFR Part 11 Assessment and GCP Assessment documents for systems which were being used to store clinical data

• Interviewed staff at vendor site to understand their systems

• Involved in preparing the audit plan and audit report

• Provide feedback report from a QA perspective to senior management with respect to vendor audit conducted.

Senior Systems Tester Oct’07 – June’10

Project: PharmaSoft Applications

The PharmaSoft suite of applications was a home grown EDC (Electronic Data Capturing) system used to record trial patient data in Phase IV studies. The system was developed in Java with Oracle 9i as the backend database. The user interface was created using HTML and JavaScript.

Created and executed test scripts for the core back-end system (Setup) and the following related front-end systems. JIRA was used as the project tracking tool to list system requirements as well as report any system defects.

Setup – This system was designed to provide end users with an easy to use interface for creating database tables, edit checks, derivation, user and group accounts, reports, SQL based user defined queries etc.

FaxSys –This front-end system was designed to accept faxed in patient data which would then be accessed via the WebSys application. Testing included designing form templates using Cardiff Teleform and then transferring the data on the completed forms via the teleform reader into Websys.

LabSys – This application was designed to accept patient laboratory data which was then processed using a set of sql queries which was then accessed by WebSys. Testing involved validating the LabSys application for different lab scenarios, executing sql queries and validating the database tables for the results as well as verifying the results of data processing via WebSys.

As Test Lead, managed the entire testing cycle for two other major projects - Move IT and Out of Scope Tracker.

MoveIT - This was a PharmaSoft data migration and conversion utility used to transfer PharmaSoft Application Suite data between databases. Move IT is a standalone, web-based system backed by database. The client interface is composed entirely of HTML and JavaScript. The data layer is the Oracle server database system.

Out of Scope Tracker – This was internal utility developed for Business Development and Project Managers to help them track out of scope changes to projects.

Responsibilities:

• Analyzed Functional Requirement Specification (FRS), System Design Specification (SDS).

• Designed Test cases and Test scripts based on the business requirements.

• Manually tested the functionalities of the application and validated against the requirements.

• Tested the integration of the back-end system with the front-end systems.

• Prepared the test data to test the various functional aspects of the system.

• Performed negative testing for all possible scenarios including out of the box testing.

• Interacted with the user to understand business requirements and verify whether the functionality implemented satisfies the user requirements.

• Worked closely with developers to resolve bugs by helping them to replicate the same scenario in the development environment

• Involved in System Testing, Regression testing, Black Box testing and Performance testing (applicable to LabSys)

• Defect tracking and reporting was performed using Jira.

• Was involved in UAT testing of Out of Scope Tracker and PharmaSoft Setup Application

• Was involved in maintaining a weekly status of all bugs raised and fixed.

Royal Bank of Canada Capital markets, NY

QA Analyst May’06 –Sept’07

Project: Sophis Risque

The Sophis Risque system was implemented at Royal Bank of Canada (RBC) to manage its wholesale & Investment Services. It was integrate with the existing RBC systems that were already in production. The testing was purely manual. My involvement was with the Grip Keys System, New Account System, Cost to Carry, Reconciliation of custodian accounts with Sophis, and Back End Compression engine.

Responsibilities:

• Analyzed comprehensive Functional Requirement Specification (FRS), System Design Specification (SDS).

• Designed Test cases and Test scripts based on the business requirements.

• Manually tested the functionalities of the application and validated against the requirements.

• Prepared the test data to test the various functional aspects of the system.

• Performed negative testing by editing xml file as well as entering invalid data.

• Interacted with Business analysts as well as the user to understand business requirements and verify whether the functionality implemented satisfies the business logic and the user requirements.

• Worked closely with developers to resolve bugs by helping them to replicate the same scenario in the development environment

• Performed Integration Testing, System Testing, Regression testing and black box testing and Performance testing.

• Extensively used Mercury Quality Center for planning and scheduling the tests.

• Defect tracking and reporting was performed using Mercury Quality Center.

• Assisted in UAT testing of Cost to Carry and reporting the UAT bugs to project management.

• Supported IGATE offshore QA team when testing was in progress.

• Wrote unix shell scripts to extract data from text files as well as sql queries to perform database level testing.

Project : Personnel Banking System

Client : Barclays Capital, NY Sept’04 – Mar’06

Project : Retail Account System

Client : Leehman Brothers, NJ Nov'02 – Aug’04

Project : Production & Sales Processing System

Client : Pepsi Cola India Marketing Feb'99 -Feb’00

Education & Credentials:

Bachelor of Science, with Major in Commerce and Financial Auditing

Calcutta University, India.

Professional Certification

• Professional diploma in software development from NIIT, India

• Professional diploma on e-commerce from Asset International, India

• Microsoft Certification in NT-Server 4.0

Contact this candidate