Data Sql Server

Nazia Kabeer

****, ********** *****, #***, ******, VA 22102

Mobile: 703-***-**** Email: ***********@*****.***

OBJECTIVE

• Seeking a Software Tester position that is both innovative and challenging with

ample scope to apply and improve my technical skills

EDUCATION

• BS Electronics and Communication Engineering May, 2004

Madras University, India GPA: 3.80

PROFESIONAL CERTIFICATION

ISTQB Certified Tester Foundation Level (CTFL)

PROFESSIONAL TRAINING

Data Warehousing Fundamentals

Programming with PL/SQL

SUMMARY

3 years of experience in all phases of SDLC, with primary focus on the test phase

Result oriented individual with diversified experience in Software Testing across

multiple environments including Client/Server and web based applications

Highly proficient in working with Manual and Automated Testing tools including

Mercury Interactive Test Suite (Load Runner, Win Runner, QuickTest Pro,

Test Director and Quality Center), Rational ClearQuest and defect tracking

tools like Jira and Bugzilla

Specialization includes Functional, Non functional, System, Integration,

Performance, Stress, 508, Load, Regression testing, defect tracking and

reporting

Expertise in writing SQL statements for performing Back end testing of the

application and to ensure data integrity to meet application requirements

Experience in backend specific testing such as Web Services using SOAP UI and

ETL using tools like Informatica

Experience in developing Test plans, Test scripts and Test Summary Report

Excellent team player with ability to work independently in a diverse environment

Experience in client interaction

TECHNICAL SKILLS:

Testing Tools: QuickTest Pro, WinRunner, LoadRunner, Quality Center,

Rational ClearQuest, Test Director, SOAP UI

Operating Systems: MS DOS, Windows X, Linux, Unix

Languages: SQL, C++, HTML, XML, XQUERY, XPATH, Web Services

Scripting Languages: Shell Script

Databases:

MS Access, Oracle 10g and SQL Server 2000

Defect Tracking: Jira, Bugzilla

ETL: Informatica

DB Tools: Toad

Methodologies: Waterfall, Agile

WORK EXPERIENCE:

QA Tester, UPS, Chantilly, VA September 2011 – December

2012

The Mailbox.etc system consolidates mail information between different stores

across multiple locations. The project involved compiling a large set of data and

generating reports based on specific filters.

Involved in creating source target mappings, created fact and dimension table

implementation in Star Schema model

Tested design strategy of ETL for various ODW tables, mappings, sample data,

mappings transformations like Filter, Joiner, Sequence Generator and

Aggregator and performed query overrides in lookup transformation for

performance enhancements

Prepared technical specifications and Source to Target mappings

Experience with SQL programming in developing functions, procedures, packages,

triggers and views to implement business rules and security

Experience using query tools for Oracle to validate reports and troubleshoot data

quality issues and extensively used Informatica PowerCenter for ETL

processes

Reported testing including verifying data from various Data Marts

Extracted data from various sources like Oracle, flat files and SQL Server

Validated Cube and Query Data from the reporting system back to the source

Applied appropriate validation rules and created workflow parameters to check the

validations are correct so that the workflow execution should stop.

Extensively used SQL/XQuery to validate the XML data and databases

QA Tester, TechISys, Ashburn, VA January 2010 August 2011

The Case Management System developed by TechISys tracks client

progress from the point of checking in to a health care center to getting

discharged. It stores all the pertinent patient information such as initial referral,

screening, diagnosis, progress notes, assessment, treatment plan and

discharge.

Involved in testing Web Services using SOAP UI and QTP

Used SOAP UI to discover web service clients and test them interactively. Also

used it to develop Test Suites and Test Cases and performed load tests

Used DataSource to create data driven tests and make requests with multiple

sets of data

Used DataSource Loop for testing specified number of records

Used DataSink to capture responses in reportable format

Developed Assertions in SOAP UI to validate the response with the expected

result. The results are then exported to a XLS using XPath

Developed mock services to test if the actual service is unavailable

Used XQuery extensively to query XML data

Designed descriptive programming, dynamic objects and reusable actions in

defining scenario flows using QuickTest Professional

Performed Data Driven Test using QTP

Performed Database Validation by using SQL queries in SQL Navigator

Analyzed and categorized defects based on severity using Quality Center

References:

Available upon request

Contact this candidate