VANDANA SINGH

Email: acptj2@r.postjobfree.com Cell Phone: 678-***-****

SOFTWARE QA TESTER

OBJECTIVE Face the challenges in the area of Software testing and

contribute to the growth of the organization, along with updating myself

with the latest emerging technologies.

SUMMARY

> 5 years of extensive experience in Software Quality Assurance and

Testing with strong knowledge of Software development life cycle

(SDLC), Software Testing Life Cycle (STLC) and QA methodologies

> Hands on experience in analyzing Business Requirement, Functional

Requirement, Design specification documents and developing Test plan

and Test scenarios

> Hand on experience in Functional testing, Integration testing, System

testing, Regression testing and End to End testing

> Experience in various domains such as Financial, Health Care,

Insurance, Banking and web applications integrated with various legacy

systems

> Extensive experience in all testing methods including Waterfall,

Spiral, V model, Agile and Scrum

> Expertise in creating/developing Test cases, Test scenarios using

standard and modular approach

> Experience in developing Requirements Traceability Matrix to map

requirements to test cases to achieve requirement coverage and change

management

> Experience in working as a single point of contact for all testing

activities and as liaison between different teams members and the

manager

> Expertise in writing simple and complex SQL queries using TOAD, SQL

Navigator

> Experience in testing/validating the Source, Stage and Target (End-to-

End) data systems

> Experience with Quality Center/HP ALM to maintain Business

Requirements, Create and update Test Cases, Test Runs, and Test

Results for every iteration and report defects and link them back to

the requirements.

> Expertise in Defect Tracking, Defect management and Bug Reporting

using tools like Quality Center

> Experience in testing/validation of Actuate reports, Business standard

and ad hoc reports

> Experience in End-to-End testing of an application/process. Performed

backend testing using SQL Queries

> Proficient in creating automated test scripts using UFT

> Web services validation using SoapUI

> Hands on with HP Loadrunner - VUGen, Controller and Analysis tools for

performance testing ( Non-Functional Testing).

> Experience with ETL Testing - Extract - Transfer - Load, Data

warehousing concepts, Familiarity with Mapping documents, OLAP, OLTP,

database schemas, Star schema, data marts, fact table.

> Ability to work as independent and team member in challenging and

cross platform environment

> Highly motivated team player with excellent analytical, problem

solving, interpersonal and communication skills

> I have 14 years of past IT experienceas Unix Admin. and Data Base

administrator.From that experience apart from the technical experience

gained, I have also developed strong documentation and people skills,

problem solving techniques, and Analytical aptitude.

TECHNICAL SKILLS

Databases : Oracle7/8i/9i/10g/11g, Terradata, SQL Server 2005/2008

Operating System : Unix, Linux, AIX, Windows

Database Tools : TOAD, SQL Developer

Test Management : Quality Center, HP ALM

Languages : SQL, VB Script, Perl, Unix Shell script

Testing Tools : Quick Test Professional, HP ALM, LoadRunner

Education/Professional Qualification:

. Bachelor of Science - 1986 - DEI, Agra, India

. Diploma in Systems Design, NIIT - 1989 - Lucknow, India

Executive Course in 'C' / UNIX

. [pic]Oracle certification for 8i.

. Brainbunch certification for Oracle 8.0

. Comprehensive course in QA

Henkel Corporation,

Sept., 2014 - Mar.,2015

(QA Tester - Work From Home)

. Good experience with Software Development Life Cycle (SDLC) and hands

on Software Testing Life Cycle (STLC)

. Familiarity with multiple development and testing methodologies like

Waterfall, Agile and Agile Scrum etc.

. Good hands on with developing test plan, test cases and RTM (

Requirement traceability Matrix)

. Good understanding of test automation and QA processes

. Experienced with preparing test data by executing SQL queries and

joins.

. Good Experience in writing SQL queries

. Practical experience with Quality Center / HP ALM to develop Test

plan, test cases, executing test cases in Test lab, and creating and

tracking defects in Defects module

. Experience in Unix shell scripting, it comes in handy when dumping

large data in the flat/txt files and manipulate it. Automate daily

routine tasks.

. Hands on with preparing reports to track the execution of Test cases

and defects.

. Experienced with data driven testing

. Good hands on with various testing and can perform dexterously. For

Example Regression testing, User acceptance testing(UAT), Functional

testing, black box testing techniques, System testing, Unit testing,

Smoke testing, sanity testing, performance testing, load testing,

stress testing, Exploratory testing, browser compatibility testing,

integration testing, cross browser testing

. Good Team player, good analytical skills, problem solving skills,

communication skills

Maximus INC, Austin Texas

July 2013 - July 2014

(Database Tester/ Senior Quality Analyst)

. Performed the database testing on the large integrated Medical

application for State.

. Executed and monitored test cases and track defects using Quality

Center and QTP.

. Followed the HIPPA rules heavily while creating/ testing /using

Test/Actual patient data.

. Manipulated (Insert/update/delete) the backend data to create the test

data as expected

from different systems to complete test before integration of the app.

. Worked on different types of TIERS Flat files formats and live

patient data as

a part of data creation.

. Extensive involvement with Developers, Project Managers, Systems

Analysts, DBAs throughout the SDLC.

. Performed the Unit testing for the developers

. Completed the step by step integration testing using plsql querying.

. Responsible for retesting the Jobs data results after every changes

in the code.

. Worked on validating the completeness, integrity and accuracy of data

in backend and

Frontend.

. Worked on Automating modules in Test Complete.

Environment: Unix, Oracle, Agile

Client Connect Sept.,

2012 - Jun., 2013

Senior Quality Analyst

. Conducted Performance validation testing before build release.

. Created and Updated the test cases using Excel sheets as per the new

requirements and acceptable

. working changes as per the client.

. Reported and provided detail defect information for developer to re-

perform

. Performance testing manually, to record time taken during various

actions.

. Coordinating with cross-functional team for requirement changes.

. Handle testing process during Unit Testing and Integration Testing.

Guiding Functional .

. Adherence to development standards - coding, testing, quality, design.

Environments: Excel, Windows

Cadenza Services June, 2006-June, 2008 & June 2009-

Aug.,2011

. Worked from home.

. This included imparting DBA support and service to different Cadenza

clients

. preparing quick Ref. handouts for different processes

. Executing pre-written SQL from monitoring of RBS, Temp TS for space

management

. Components testing for many startups

. Mentoring their new recruits for DBA Tasks.

. All the above was for Terradata and Oracle DBs.

BellSouth Corporation, Atlanta, GA (Enterprise Data Warehouse Program,

MKIS)

Sr.Oracle Data ware house Consultant Sept. 2002 - Feb. 2005

BellSouth Corporation, doing business as AT&T South, provides

telecommunications and broadband services in the United States. It offers

various wire line Communications services.

The project was MarKetingInformation System. It was 24 hrs support

environment, there were three shifts to maintain all the ongoing ETL

processes. It was team of 10 DBAs in rotation to all the shifts.

Environment: Oracle 8i, Shell Scripting, Teradata, Sun-UNIX Environment

. Developed ETL Process to load the data from different in house

customer's database to data ware house and tailored them on need

basis.

. Thorough Software Development life cycle (SDLC) experience including

development, designing, analysis, coding, testing and implementation.

. DBA support activities involved daily troubleshooting and Backup and

in case of any crash recovery.

. Database Migration from one version to the latest version.

. Experience in Oracle 7.1, 7.3 and 8i including Configuration and

Installation, Data Analysis, Data Modelling, Designing, Data

Warehousing.

. Developed ETL process for getting the changed data into staging tables

and there by Implementing the business logic and data was loaded into

tables.

. Prepare translation table to data cleansing

. Involved to write UNIX Scripts to perform various data filtrations,

automation of various jobs.

. Coordinated with other teams like Data analyst team, User interface SW

developers and QA to create, maintain and remove database in Sun-UNIX

Environment, Oracle 8i, Teradata and Shell Script.

Denver Police, Denver, CO June, 2002 -

Sept., 2002

Oracle Consultant

I was responsible to prepare backend server with Sun solaris and Oracle 8i,

migrate the data from Oracle 7X to Oracle 8i server and setup process and

procedures. Define the need of daily/monthly/weekly data backups. End user

training.

Environment: Oracle 7.X/8i, Shell Scripting, Sun-UNIX Environment

. Installed and Created New database as per redefined standards and

securityon Oracle 8i on UNIX server and transported confidential data

from Oracle 7X/WINNT to Oracle 8i/Unix.

. Established end user application connectivity with the server

. Unix Shell script creation for various management tasks for database

at OS level. (Environment: Sun- UNIX & NT Oracle 7.X,8i)

. DBA support activities involved daily troubleshooting and Backup and

in case of any crash recovery.

Frontier Technology Inc., Goleta, CA April, 2001 -

March, 2002

Sr. Oracle Consultant (Lead)

FTI Services offers a wide range of solutions ranging from Server

Virtualization and Groupware systems. Whether your organization is looking

at implementing a 20 Site WAN, a Point to Point Wireless Solution, and a

new Email System or is simply looking at ways to lower IT costs, FTI

Services can assist. I was responsible for the DBA service provided to

Government and private company clients.

Environment: Oracle 8i/9iAS/11i, Shell Scripting, Sun-UNIX Environment

. Installed Oracle 8i database, Oracle 9iAS and Oracle Apps 11i

. Provided DBA support to Govt. & Defense clients in addition to private

clients.

. Involved in pro-active maintenance, monitoring, and tuning of Oracle

production databases.

. Planning a effective backup plan for the clients and recover of

databases in case of any crash with minimal data loss.

. Shell scripts, database triggers and procedure to automate many of the

OS and DB level tasks.

. On requirement basis for development and test instances. (Environment:

Sun-UNIX & NT, Oracle 8i, Oracle 9iAS & Oracle Applications 11i).

The Boeing Company, Seattle, Washington - DCAC/MRM - (Define and Control

Airplane Configuration/ Manufacturing Resource Management - One of the

largest Client/Server Configurations)

Sr. Oracle Consultant April 1999- March 2001

Boeing is the world's largest aerospace company and the leading

manufacturer of commercial jetliners and military aircraft combined.

Additionally, Boeing designs and manufactures rotorcraft, electronic and

defense systems, missiles, satellites, launch vehicles and advanced

information and communication systems. I was associated with DCAC/MRM.

Environment: HP-UNIX, Sun-UNIX, Oracle 7.3 & 8i, Kron shell

. Performed database design, development, implementation and maintenance

activities that supported computing applications in accordance with

company guidelines, methodologies and security practices.

. Worked with application process developers to apply access, security

and performance requirements to functional data models.

. Applied DB design skills to translate functional data models into

operational physical databases. Loaded external data into Oracle DB

using SQL* Loader.

. Created shell scripts to perform hot backups, monitor databases,

perform batch updates and the loading of data from other sites

. Involved in pro-active maintenance, monitoring, tuning,

defragmentation, image copying, shell scripting of Oracle production

database.

. Developed ETL process for getting the changed data into staging tables

and there by Implementing the business logic and data was loaded into

tables.

. Prepare translation table to data cleansing

. Involved to write UNIX Scripts to perform various data filtrations,

automation of various jobs.

Netacross Communication Inc., New Delhi, India

Dec. 1998- March 1999 - Lead Oracle Consultant/Analyst

Environment: SCO-UNIX 5.0.2, Oracle 7.3 on IBM, Windows 95 with Designer

2000 and Developer 2000 on Pentium Machines

Cosmic Software, New Delhi, India

Oct.1996- Nov.1998 - DBA Team Leader

Environment: SCO UNIX 5.0.2 & AIX 4, Oracle 7.1 & 7.3

Pepsico India Holdings, Lucknow

From Jun,1996- Oct.1998 - MIS Executive

Environment: SCO UNIX 5.0.2 & AIX 4, Progress RDBMS, Pepsi Sales and

Distribution Application.

Prosix Softron (P) Ltd., Lucknow, India

From Mar, 1992 - Sept. 1998 - System Executive

Environment: Winix Oracle 6.0, DBMS systems, Windows 2.0, LAN Networking

Siddhartha consultancy

From Jul, 1991 - Feb., 1992 - Trainee and Jr. System Executive

Above mentioned companies, I performed various tasks. As follows -

. DBA/Unix Admin. Tasks

. Triggers and procedures

. Configures two tier architecture, Client server.

. performed corporate trainings

. designed and prepared training material

. Telephone Revenue and Billing system Implementation and user training

. Software installations

. Data Processing

. Mentoring to new recruitments

. software development

. End user support

Contact this candidate