SHOBHNA TYAGI

QUALITY ANALYST/TEST ENGINEER

Voorhees 08043 NJ

Contact #: 856-***-**** (H)/609-***-**** (Cell)/E-mail:

acecnw@r.postjobfree.com

Status: Permanent Resident (Green Card Holder)

SUMMARY:

V Over nine years of experience in the IT industry, Involved in complete

SDLC including requirement analysis, testing, implementation, debugging &

maintenance of applications in Client/Server and Web environments with

focus on Quality Assurance.

V Excellent experience in Quality Assurance including development of Test

cases, Test plans, Test scripts, Test traceability metrics, Test Data

Creation, Test procedures including decomposition of testing requirements

& standard.

V Delivered responsibilities as QA Analyst/Tester with clear understanding

of every phase of software development life cycle and quality assurance

life cycle

V Experience includes business requirement analysis, system specification

analysis, testing methodology, test plan formulation, system testing,

functional, UAT, UI and Performance Testing.

V Experience working with MS-Office Suite like MS Word, MS Excel, MS Visio,

MS Project and MS Outlook.

V Experience to execute DDL and DML statement against database to verify

data using T-SQL (SQL Server 2005/2000), Oracle 10g.

V Experience with Microsoft Visual Studio Team System (Visual Studio 2005,

Team Test Load agent) for Load testing.

V Experience with Automation tools like QTP, Win Runner, Test Director and

Quality center

V Expertise in browser-testing and tested application in different versions

of IE and Netscape.

V Functional Domain knowledge on Cable Industry, Insurance,

pharmaceuticals, and financial applications in client/server & web

technologies.

V Ability to quickly adapt to changing environments professionally and

personally.

V Hardworking, interested in learning new technologies and have excellent

communication skills.

V Hands on experience in SSIS and DTS tools to integrate disparate systems.

V Proven SQL programming, stored procedures, SQL queries.

V Experience data modeling, data analysis, data mining and data base

design changes.

TECHNICAL SKILLS:

Testing Tools Mercury win runner, Mercury Quick Test Pro, Load

runner

Defect Reporting Test Director 8.0/8.2, Quality Centre 9.0/10,

Tools Bug Master

Database MS SQL Server 2005/2000, TOAD, Oracle 10g

Operating Systems Windows NT/98/2000/XP, UNIX, DOS

Script Language TSL, VB Script and Java Script, Unix/Linux

Commands

Web Design HTML, XML, DHTML, JSP, ASP, and FrontPage

Languages Java, C /C++, VB, C#, .NET, HTML, ASP.NET,

PL/SQL

Hardware IBM PC, HP/COMPAQ, and PENTIUM

PROFESSIONAL EXPERIENCE:

NCIS Dec 2012 to June 2013 AND August 2013

to January.

QA Engineer.

This company deals with process serving, debt collection, Investigation,

Asset repossessions and litigation.

Responsibilities:

Involved in the QA effort through setting up the test environments, test

specification and design, bug tracking, test runs, analysis and feedback.

V Involved in developing test cases and test plan from given functional

specification.

V Involved in Back end testing, Grey box testing, Unit testing and black

box testing

V Used Toad, SQL server 2008 as editor to fetch data from RDBMS.

V Used JIRA to report bug or issue.

V Involved in issue resolution, worked in Agile environment so direct

interface with developers, business analyst

V Performed manual testing for UI requirements.

V Track and Report on Functional, System, Integration, Regression

issues.

V Performed UAT,ALPHA, BETA testing to release the application

commercially

V Used SSIS and Know how to create simple ETL package that extracts

data from single flat file, transform the data using look ups.

V Knowledge of adding looping, adding logging, adding package

configuration for the package deployment model.

V Using parameter with project deployment model.

Comcast Feb 2010 to June 2012

Test Engineer (Contractor) (Team lead)

Comcast is largest cable operator and the home internet service provider in

the United States, providing cable television, broadband Internet, and

telephone service to both residential and commercial customers.

Responsibilities:

V Contributed in developing each test plan and test case based on

the high-leveled and detailed design.

.

V Used Quality Center to perform a test plan, track executions

against plan throughout testing and handle faults from start to

resolution.

V Involved in ETL (SSIS) process to collect data from various

sources, transform the data depending on business rules/needs and

load the data into a destination.

V Led the five individual's group to achieve desirable degree of

accuracy in whole Q A process.

V Used Toad, SQL developer interface run SQL queries to make sure

new updated data was not destabilizing other rows and columns.

V Testing was performed on BUI web portal for cross browser & cross

platform compatibility and data integration, data synchronization,

data conversion and data inconsistencies at the same time.

V Testing on back office application like Transaction processing

management, Shipping management check out, Order Management was

performed to carry out End to End testing.

V Performed rigorous testing on making sure the proper interaction

was taking place between HTML pages, protocols, security

applications that run in web pages (applets, java scripts, plug

in) and application that runs on the server side ( such as CGI

scripts, DB interfaces, logging application, dynamic page

generators etc.

V Translate requirements into written test plans and detailed test

cases, both front end (Browser based) and back end (SQL Server)

V Involved in executing test cases based on VOD systems as whole

application.

V Involved in executing test cases based on UDB quail.

V Executed test cases based on CEMP, CCDN, CDN.

V Involved in CDN IP distribution and Knowledge CDN ingest and

metadata flow, Knowledge of CDN internal and external

communication, Knowledge of CDN ports, interfaces and protocols.

V Knowledge of CDN configuration and useful system and application

log files.

V Knowledge of Multi-Tier Caching (Persistent store: Libraries Mid-

Tier Caching: caching Gateways, Edge Cache: Streaming Servers).

V Knowledge of L3 network and VOD pumps and switches.

V Executed test cases on Sea Change 5.6 axiom, Sea Change 8.

V Executed test cases on BUI and its modules.

V Knowledge of BSS components product management, product

management, revenue management, Order management.

V Knowledge of Sea change software, hardware and content tools.

V Performed Functional, regression, negative, positive, grey box, ad

hoc testing.

V Knowledge of STB's configuration and integration.

V Knowledge of head end controllers like DAC, DNCS, DOCSIS and Cisco

devices.

V Worked in DOCSIS and OCAP and Tru2way.

V Worked on Axiom 5.6 more and DAC 8 and 5.

V TCP/IP, SQL, SOAP, Solaris, Linux, Windows 2003, Python, MPEG 2

and 4, Windows media streaming, Real streaming, Flash, IGMP, SNMP

V TCP/IP,SOAP, Solaris, Linux, Windows 2003, MPEG 2 and 4,windows

media streaming real streaming, Content tools Etc.

V Worked on CSG and Amdocs cable billing systems and know how to set

up new account, delete invalid account and reset up existing

account.

V Knowledge of Wire shark tool and know how to capture HTTP and SIP,

3GPP, FTP, SS7 protocols.

V Knowledge of all Application, Transport, Link internet layer of

OSI model.

V Knowledge of PUTTY, I PTV, cable card non cable card, Mac Card and

DSG.

Environment: J2EE, HTML, TOAD, SQL Developer, Quality Center 9.2, Windows

XP, UDB (data base), putty (Linux), Unix ( SOLARIS), JIRA

TekSystems, PA

Burlington Coat Factory, NJ (Oct 09 - Dec

09)

QA Analyst (Consultant)

Burlington Coat Factory is a national department retail chain store which

offers current, high quality, designer merchandise over 394 stores in 44

states nationwide. These store feature coats, apparel, shoes, and

accessories for the entire family, baby clothes, furniture, toys, home

decor items, and gifts.

Responsibilities:

V Performed functional and regression testing to ensure that up gradation

in database has not destabilized any functionality of the software.

V Involved in Testing different section of the application manually to

ensure all the requirements has been fulfilled.

V Involved in Testing application on Window based platforms.

V Performed Backend hand testing as per the need to ensure that database up

gradation has not destabilized the data.

V Wrote SQL Queries that have been made on TOAD interface with ORACLE 10g

database.

V Wrote DDL statement has been used to ensure data testing.

V Involved in issue resolution, worked in Agile environment so direct

interface with developers, business analyst.

V Used Bug Master tracking tool for issue escalation.

V Involved in test data creation for different shopping cart scenario.

V Engaged in networking side.

Environment: Java, J2EE, JavaScript, HTML, Bug Master, MS Word, MS Excel,

TOAD, ORACLE 10.2, Windows/UNIX.

Fourth Technologies, Inc., NJ (Mar 03- Oct 09)

QA analyst Oct. 08 to Oct 09.

Fourth Technologies Inc. is a rapidly expanding IT Solutions provider

company in NJ. Fortek specializes in Back office Systems Integration,

Portal development, Web-based Learning Systems, Product development,

eBusiness & Wireless Technologies.

Responsibilities:

V Performed Backend Testing to ensure authentic retrieval of data from the

database.

V Tested Masterpiece application manually for generation of different

insurance policies

V Tested the application interface manually to test the policy rating.

V Used Test Director for defect reporting and tracking.

V Created Requirements using Test Director and generated traceability

Matrices to ensure that all the requirements are covered by the test

cases.

V Responsible for Back-End Testing/Database Testing, which was done using

SQL queries.

V Performed Positive & Negative Testing and End User Testing in Windows

platform.

Environment: Test Director 8.0, Quick Test Pro8.0/8.2, Quality Center 8.2,

Oracle, SQL Server, .NET, Java/J2EE, PowerBuilder, Web Logic, MS Word,

Windows/Unix, MCAs/MCPs (credit card simulator)

DIA, Horsham, PA

QA Tester/Analyst, Feb 06 till Aug 08

DIA is a professional association of more than 18,000 members worldwide who

are involved in the discovery, development, regulation, surveillance, or

marketing of pharmaceuticals or related products. It operates as a

financially independent nonprofit organization that funds itself from

meeting and membership fees. The voluntary efforts of DIA members and

speakers allow DIA to provide programs and publications to members at a

reasonable, competitive cost.

Web Portal for DIA: The web portal for DIA is a redesign effort to create a

new portal for the company. This involves upgrade in the functionalities

and streamlining the current business processes. The site offers different

products on the site that can be purchased online.

Responsibilities:

V Involved in the QA effort through setting up the test environments,

test specification and design, bug tracking, test runs, analysis and

feedback.

V Understand Specifications to Identify Test Cases, Design Test Scripts,

Test Data & Expected Output.

V Defined template and standards to be used for writing test cases.

V Analyzed and compared the business functionality with the existing

DIA's web site.

V Created test scenarios and cases for modules like educational

offering, membership, shopping cart and My DIA.

V Involved in the test data creation for different shopping cart

scenarios.

V Performed manual testing for UI requirements.

V Track and Report on Functional, System, Integration, Regression

issues.

V Executed Test cases manually from Test Director

V Developed scripts for testing the test cases and made enhancements to

the existing scripts using QTP.

V Testing core functionalities and highlight the high priority defects

to the manager on regular basis.

V Logged defects and re-test details when applicable.

V Optimized QTP scripts for Regression testing of the application with

various data sources and data types

V Mapped the custom objects to the standard objects where necessary, and

inserted GUI, Bitmap and Text checkpoints where needed, to compare the

current behavior of the application being tested to its behavior in

the earlier version using Quick Test Pro (QTP).

V Parameterized the fixed values in checkpoint statements, created data

tables for the parameters and wrote functions for the parameters to

read new data from the table upon each iteration - Performed Data-

driven testing.

V Wrote several SQL scripts to validate the data integrity in the

application using various DML statements

V I also became team leader during my term I would lead to 4 individual

and navigate them on tools and test framework as they were newly hired

consultants.

V They would discuss with me before logging any issue on QC and I would

go through their "Bug Report" before publishing it on QC.

V I gave session to them on Modules like "Shopping carts", "Education

offering" etc.

Environment: Test Director (8.0/8.2), Quality center (9.0) QTP (9.0/9.2),

C#, SQL Server 2000, Windows 2000, ASP.NET, XML, JavaScript.

PNC Bank, PA

QA Tester/Analyst, Sep 04- Dec 05

PFPC is a leading provider of processing, Technology and business solutions

for the global investment industry. PFPC is a member of PNC financial

service companies. It has been delivering personalized solutions to the

global investment industries for over 30 years.

Advisorport: This system primarily allows advisors to profile investors

from a prospect level to the Client level. The investment amount and the

selected model are all attached to an accepted proposal and saved in the

system. Once accepted a reporting group is created and the account is

attached to the same and the reporting group is submitted. Once the Funding

action is initiated the account's performance reports start being generated

on the system from APL (Mainframe system).The overall Development/Fixes

done were on a daily basis with respect to individual accounts or for the

website. Issues in production were reported and fixes were done based on

the estimated delivery date provided.

Responsibilities:

V Involved in design, development and execution of Test Cases for all the

testing stages.

V Responsible for testing, bug tracking & Regression testing after Fix

is promoted to Test Environments and involved in build/release.

V Reviewed and analyzed business requirements and/or functional

specifications to establish testing needs.

V Interacted with Business analyst on a regular basis to solve issues

arising from requirements.

V Co-ordinate with Business analyst to conduct User Acceptance Test (UAT).

V Defects were tracked, reviewed, analyzed, compared and stored in Test

Director.

V Consulted with developers and end users to ensure accuracy and

completeness of test plans.

V Maintained proper backup and documents for each project.

V Determined project status and communicated to management, project team,

and related groups, while meeting project deadlines.

V Involved in creating test scripts for UMA branch of ADVISOR port.

V Maintained the status of the defects in all the testing environments.

V Maintain Defect Log which gives a clear indication of quality and

stability of product

V Actively participated in Project meetings and discussions

Environment: Test Director (8.0/8.2),QTP(9.0,9.1) C#, VB.NET, ASP.NET,

XML, MS Visual Source Safe, Test Track Pro, SQL Server 2000, Windows XP

MetLife, New York, NY

Quality Analyst/Tester, Mar. 03- Aug 04

MetLife is one of the leading insurance companies. This application is

designed to determine premium rates and categorize the members into classes

or groups based on demographic factors, industry characteristics or

experience and charge the same premium to all members of the same class or

group. Also worked on the group quote, premium adjustments and claim

modules. It provides the desktop solutions to the insurance agents to

instantly provide solutions to the customers. This is an intranet

application with secured server connections provided to each agent. MetLife

has many different products such as Life, Auto, Home, Long-Term care,

Disability Income and Annuities. This project was particularly involved in

testing the part of the application handling Long-Term Care products.

Responsibilities:

V Involved in the QA effort through setting up the test environments, test

specification and design, bug tracking, test runs, analysis and feedback

V Conducted Manual Testing during the Initial phase and automated testing

in later phase using Mercury Tools.

V Participating in QA/Development meetings to meet the testing standards.

V Executed Test cases manually from Test Director

V Submitted Daily Test Updates to Project Manager & Group Lead.

V Responsible for Documenting Test Plan, Test cases & Test Report

V Responsible for testing, bug tracking & Regression testing after Fix

is promoted to Test Environments and involved in build/release.

V Interacting with Business analyst on a regular basis to solve issues

arising from requirements

V Conducted Distributed and Multi-User Testing.

V Perform BVT (Build Verification Test)

V Test applications both in QA and Acceptance environment, by migrating

test data stores between the environments.

Environment: Test Director (8.0/8.2), Win Runner (6.2), Rational Clear

quest, JAVA, Java Servlets, Java script, UNIX (Sun Solaris), SQL Server

2000.

EDUCATION:

. Post graduate in Business and Finance administration. (IME Sahibabad

India)

. Bachelor in Economics. ( GDMD college Modinagar India)

. Diploma in computer science.( IGNOU Delhi India )

. Diploma in web designing and Quality Assurance. ( CMD Modinagar India)

Contact this candidate