Payal Kumari

acgjm0@r.postjobfree.com

Cell: 404-***-****

Experience Summary

. Six years of experience in Software Quality Assurance in web-based

applications and data warehousing applications.

. Extensive knowledge in Software Development Life Cycle (SDLC) - Business

Requirement Analysis, Design, Development and Testing procedures and

best practices

. Expertise in designing and developing Test strategies, Test plans, Test

Cases, Test scripts and through analysis of system requirement

specifications and design documents

. Experience in Manual and Automated Testing of both web-based and data

warehouse applications.

. Sound working experience in designing, development and execution of

performance test cases and test scripts

. Effectively involved in defect tracking, reporting, reviewing and

analyzing the test results using Defect Tracking tool HP Quality Center

. Extensive experience with a detailed approach of test planning, testing

process definition and documentation

. Sound database experience using TERADATA, Oracle10g/11g, SQL, PL/SQL

. Strong Data analysis skills including data model, source to target

mapping, database object testing, Indexing etc.

. Extensive experience in database testing and performance testing with

focus on application speed, stability and scalability

. Expertise in writing and executing test scripts using SQL Scripts, UNIX

Shell Script and Perl Script

. Proficient in various test methodology such as GUI, Functional,

Regression, System Performance, Integration, Validations, Compatibility,

Batch Testing, Database and End-to-End testing.

. Good working understanding on Data Extraction, Transformation and Loading

with relational and dimensional data model

. Strong understanding of Logical/Physical, Relational and Dimensional data

model and data modeling processes and data warehousing system and

processes

. Experience in all phases of the Software Development Lifecycles, system

requirement, analysis, design, coding, testing, implementation and

support.

. Experience in coordination with user, development team and architects.

. Possess excellent communication, interpersonal and analytical skills

creative problem-solving abilities, ability to succeed, learn quickly

and lead in complex challenging environment

. Highly organized and an enthusiastic team player dedicated to team

success and customer satisfaction.

Technical Skills:

Operating Systems : UNIX, Linux, Windows, Sun Solaris

Databases : TERADATA, Oracle 9i/10g/11g

Software Testing Tool : HP QC, Load Runner 8.1, QTP

Languages : C, UNIX Shell Scripting, Perl, SQL,

PL/SQL, HTML, XML

Software Tools : TERADATA SQL Assistant 12.0, TOAD, PL/SQL

Developer, ERWIN 7.0/7.2

Business Tools : MS Office, MS Visio. Snagit

Academic Qualification:

. Master in Bioinformatics

. Bachelor of Science

Professional Experience:

Project#1

Project Title: The Dmitri System

Period: Feb 2012 -Till Date

Client Name: Crawford & Company, Atlanta USA

Position: Sr Quality Assurance Analyst

Project description:

Risk and Sciences Group

The Dmitri system is a risk management analysis and powerful analytic tool

that gives users of all levels a holistic understanding of their risk

profile with the flexibility to drill down into the details necessary to

instill action. The application provides user with a central repository

where statistical information and data can be imported from various

sources, such as from insurance companies, and stored within the

application database. The user can then view and analyze this data, in

whatever format he prefer to help identify potential risks and develop more

effective risk management measures and programs. Having up to date

information and statistics readily available facilitates monitoring of risk

mitigation and allows user to continually reevaluate risk management plans

for their effectiveness.

Dmitri is Java based Web Application and I am involved here as Quality

analyst to do end to end testing of the new functionality added/changed

based on Business requirements. Starting from creating test plan, creation

of test cases, test scripts using automated tool QTP.

Role and responsibility:

. Perform various testing of Web Application and ODS System

. Interact with Business Analysts and Developers in requirement analysis,

design reviews, testing and documentation for application developed in

Agile methodology

. Prepare system test plan and test cases, execute test cases and analyze

test results and defects and ensure defects resolution and closure

. Plan and design performance tests, executes performance test cases and

scripts through analysis of design document and SQL scripts.

. Write comprehensive SQL queries to test data scenarios and ensure data is

stored and pulled correctly and consistently

. Test application load time, response time, application endurance on heavy

load of concurrent users and its performance

. Coordinate with business analyst and business user on system

functionality and application performance acceptance in varying test

scenario

. Perform Functional testing, Backend database testing in Oracle and

Teradata environment.

. Perform GUI, Functional, Batch testing, Performance, Backend, Regression

and End-to End testing.

. Recommend correct usage of Indexes, partitioned columns, correct joins

and data filter criteria

. Ensure that all system tests, functional and non-functional are

successfully completed and documented and all problems are resolved

. Perform defect logging and tracking in Quality Center till the defects

are resolved and further validation is performed and closed.

. Coordination with architect and development team on issues found during

testing and defects resolution.

. Lead defect meetings; communicate daily and weekly status to the PM on

defects matrix, status, Issues, QA tasks and initiatives

Software/Tools Used: TERADATA, Oracle 11g, PL/SQL, JAVA, HP QC, CA ERWIN

v7.2, MS office, MS Visio

Project # 2

Project Title: Geneious Pro

Period: June 2010 - Sep 2010

Client Name: Bioware systems, Bangalore India

Position: Lead Quality Analyst

Project description:

Geneious Pro is revolutionary bioinformatics software that is both ultra-

powerful and easy to use. This is powerful server software package designed

specifically for highly data intensive computing and for faster analysis

of large volumes of sequence data and leading to more discoveries (designed

specifically for Scientists, researchers and world leading

universities).Worked on this enhancement project as analyst QA engineer .

My work was of multitasking nature and primarily involved in data analysis

using different Linux commands along with Perl Programming, performed

functional analysis interacting with domain experts, end-to-end testing

functionality testing and data validation.

Role and responsibility:

. Designed, developed and executed test plans and all the test cases

aligned to system functionality and

. Coordinated with development team and Test Manager on the progress of

test initiatives, testing efforts, Issues and testing completion

timeline.

. Performed end to end testing of software product according to functional

specifications using Linux based environment, Oracle and PL /SQL

. Performed GUI testing, functional testing, regression testing,

integration and system testing and coordinated UAT.

. Coordinated in preparing Testing and UAT environment, performed Load

testing, Volume testing and scalability testing as part of system

performance testing

. Tested application load time, response time, application endurance on

heavy load of concurrent users and its performance

. Performed Batch testing and generated test reports.

. Tested data model and database objects in db as per enterprise standard,

guidelines and naming standards

. Ensured correct indexes are created, Joins are applied on right columns

and correct filter criteria is applied in PL/SQL code.

. Provided fixes for critical bugs and assisted code moves to QA and

production system

. Performed data quality checking and interacting with the development team

and business analyst on functionality and data related issues

. Participated in design discussion, coordination with development leads

and lead analyst to clarify and resolve functionality and data related

issues

. Lead and support all quality initiatives that are implemented during each

phase of the system development life cycle.

. Ensured that all system tests are successfully completed and documented

and all problems are resolved before release and code deployment

Software/Tools Used: JAVA, UNIX, Perl scripting, ERWIN v.7.0, Oracle10g,

PL/SQL, PERL, XML, HTML, HP QC, Load Runner, MS Office

Project # 3

Project Title: OS-Mirbase

Period: Jan 2010 - May 2010

Client Name: Bioware systems, Bangalore, India

Position: Quality Analyst /Sr.Test Engineer

Project description:

One of the most exciting new areas of molecular biology, miRNA and non

coding RNA (ncRNA) play a central role in how the genome is regulated and

how traits are passed on or eliminated by environmental and genetic

factors. Project was to develop software tool to specifically perform

computation on large data sets and uncover connections to diseases and

discover data trends that could lead new classes of therapies .I was

involved in functional analysis end to end testing of the product through

data profiling, quantization, validation, backend testing and functional

analysis.

Role & responsibility:

. Participated in system requirement, high level design, detailed design

discussion

. Developed and executed test plans and test cases based on software

requirements and design documents

. Lead software quality initiative -QA plan, tracking, analysis, reporting,

problem resolution

. Performed GUI testing, functional testing, regression testing,

integration testing, system testing

. Involved in analysis of production data issues reported by user and its

resolution.

. Tested database objects as per enterprise standard, guidelines and naming

standards

. Involved in QA environment set up and test data preparation

. Coordination with architect and development team and users on issues

found during testing and defects resolution.

Software/Tools Used: UNIX, UNIX Shell Scripting, Perl, Java, Oracle 10g,

Toad, SQL, HP QC, QTP, Load Runner,CA ERWIN, TERADATA, SQL Assistant 12.0

Project # 4

Project Title: EGENE SYS

Period: Nov 2008 - Dec 2009

Client Name: Delhi University, New Delhi, India

Position: Senior Research Analyst

Project description:

Understanding the biology of bacteria relies on identification and analysis

of essential genes, genes required for growth to a fertile adult. The main

aim of this project was identification of Essential Proteins using Database

of Essential Genes responsible for the viability of the fungus. Such

proteins are the most suitable drug targets, with condition that they don't

have a homologous protein in humans. The purpose was to develop a cost and

time efficient strategy for finding the drug targets and providing new

ventures to the pharmaceutical development in designing new and effective

anti fungal drug.

Role & Responsibility:

. Involved in the system requirement analysis, design discussion,

functional analysis of the system

. Performed data analysis on huge volume of data collected from different

sources and filtered the relevant data and further performed data mining

using different Unix commands along with Perl Programming and SQL queries

to determine patterns within the data with the goal of identifying

relationships and predicting future trend and events.

. Performed data modeling and pattern based analysis on research

information

. Prepared detailed Test Plans on final sets of data and solution

. Developed test cases and performed unit test and system test

Software/Tools Used: Oracle 9i, PL/SQL, ERWIN, UNIX, UNIX Shell Scripting,

HTML

Project # 5

Project Title: Molecular Biosystem

Period: March 2008- Oct 2008

Client Name: National Institute of Immunology

Position: Research Associate

Project description:

The main theme of the research project was to understand the structural

principles that govern sequence to structure relationships in proteins and

binding of various ligands to proteins. These structural principles has

been used to develop novel knowledge based computational methods for

prediction of substrate specificity of proteins and also for predicting

structural folds for proteins in absence of detectable sequence homology.

Role and responsibility:

. Involved in data analysis, and data mining to recognize patterns and

exceptions in research database collected from many sources

. Pattern discovery and finding predictive information in a large database

to accurately predict data behavior and data pattern

. Data modeling to recognize significant facts, relationships, trends and

data anomalies

. Prepare and maintain data artifacts documents

. Analysis and root cause findings of data inconsistencies, uneven data

pattern

Software/Tools Used: UNIX, SUN Solaris, Perl scripting, TERADATA, TERADATA

SQL Assistant, PL/SQL

Project # 6

Project Title: HPOS-DWH

Period: July 2007 - Feb 2008

Client Name: Hutchison Telecom

Position: Test Engineer

Project description:

HPOS-DWH is the point of sale data warehouse system. The objective of the

DWH system is to address MIS reporting requirements and data feed to the

various downstream systems. DWH mainly stores data on subscriber,

subscription plan, sales of product and services, channel management,

customer information management, new connections, cancellation, and

inventory management at different stages in the channel, bill statement and

invoicing data

Role & responsibility:

. Developed and executed test plans and test cases, performed different

types of testing - black box testing, white box testing, system,

regression and load testing

. Prepared system test plan and test cases, defined system test criteria to

test data flow from

multiple source system is loading into target system properly into

related tables in right format and data is consistent.

. Responsible for stress testing of Load process to make sure that Load job

don't break during heavy loads of data.

. Coordination with architect and development team on issues found during

testing and defects resolution and closure

. Closely involved in development and testing of logical and physical data

model using data modeling tool ERWIN as per the system data requirement

. Tested database objects as per enterprise standard, guidelines and naming

standards

. Tested MLOAD, FASTEXPORT and TPUMP script for loading data into Teradata.

. Worked on complete SDLC from extraction, Transformation and Loading of

data using Informatica, Teradata utility in UNIX environment

. Providing testing status to project stakeholders; focusing on project

quality related processes and QA artifacts documents

. Interact with development team end business users in a support role to

fulfill requests and resolve issues.

Software/Tools Used: TERADATA, UNIX, Oracle10g, PL/SQL, Teradata Queryman,

TOAD, Informatica 8.0, QTP, HP QC, Load Runner 8.1

Project # 7

Project Title: Molecular Dynamics

Period: Jan 2007- June 2007

Client Name: JNU, Delhi, India

Position: Sr. Research Associate

Project description:

The purpose of this project was to study the dynamics of proteins both for

local fluctuations to correlated motion of sections of the protein using

Molecular dynamics method. Molecular dynamics (MD) is a computer simulation

of physical movements of atoms and molecules. The atoms and molecules are

allowed to interact for a period of time, giving a view of the motion of

the atoms.

Role & responsibility:

. Involved in the system requirement, functional analysis and quality

assurance activity

. Involved in data modeling and data analysis and resolution of unexpected

data trend issues

. Correlation analysis of Wild and Mutant protein.

. Prepared system test plan and prepared system test cases for this data

intensive application

. Performed through database testing and data validation

. Deeply analyzed and ensured application data accuracy

Software/Tools Used: UNIX, C, Perl, ERWIN V 4.0,Oracle10g, PL/SQL, MS

Visio, MS Word, MS Excel

Contact this candidate