Sql Server Project

_______________________________________________________________________

Monica Awasthi

Software QA Tester

Email: ***************@*****.*** Phone: 770-***-****

(Home)

Address: **** ******* *****ng, Cumming GA 30040. 214-***-****

(Cell)

_______________________________________________________________________

Summary

> Nearly 7 years of IT experience as a QA Tester using manual testing

tools like Mercury Quality Center, Test Director and Compuware CARS.

> Proficient in creating Test requirements, Test cases, Test plans and Test

Scripts based on Business requirements and design documents, Use Cases.

> Proficient in Black Box testing, Regression, System Integration,

Performance and User Acceptance Testing

> Expertise in Web, Client/Server and Database Back-end testing

> Used tools such as Test Director (Quality Center) and CARS Changepoint

for Test life cycle management and defect tracking

> Knowledge of automated testing tools such as WinRunner and QTP.

> Expertise in testing in Windows, Linux and UNIX Environments with Oracle

and SQL Server databases as back end.

> Expertise in Testing both Client server and Web-based applications in

Windows environment.

> Expertise in testing ecommerce Web Based Proficient in MS Office tools

like Word, Excel and PowerPoint

> Ability to interact with developers and business analysts regarding

testing status and defect resolution

> Expertise in testing Retail, POS, Billing (Telecom) Systems, Banking and

Insurance applications.

> Expertise on E Commerce Application for more than 5 years.

> Worked in various client servers such as Java, UNIX, Mainframe and

ORACLE.

> Experience working on a project using Agile Software Development methods.

> Ability to execute predefined manual and automated test on assigned

areas.

> Excellent communication and documentation skills, work independently with

little direction, detail oriented, time bound, responsible team player

and ability to coordinate in a team environment.

Technical Skills

Testing Tools Quality center, TestDirector, CARS, Bug Tracker

Databases Oracle 9i/10g, SQL Server 2000 /2005

Operating Systems Windows NT/2000/2003/XP/Vista, Unix Sun/HP, Linux

Red Hat/Debian

Working Knowledge SQL, Unix, TOAD, OraEdit, SQL Plus, SQL Query

Analyzer

Web Knowledge HTML, XML, Browsers like Internet Explorer,

Netscape, Mozilla Firefox

Others SDLC, MS Office tools like Word, Excel, PowerPoint

Academic Qualifications

> Masters Degree in Business Administration (MBA) from Institute for

Technology and Management (ITM) Mumbai, affiliated with University of New

Hampshire, USA.

> Bachelor's Degree in Commerce from University of Mumbai, India

Certifications

> Diploma in Information Technology from STG Computers, India

Professional Experience

The Home Depot (THD), Atlanta GA Jul 2010 - Present

Project: THD OMS (Order management Systems) v10 Upgrade Project.

OMS is a ecommerce/.com/web based application. The OMS Upgrade Project is

to upgrade the homedepot.com current Order Management System (OMS) from

version 6.4.5 to version 10.1.8. It included the following items:

. Upgrade the OMS to the current release version 10.1.x

. Stand up an instance of Blue Martini Contact Center 10.1.8 and migrate

all CSR functions for homedepot.com out of OMS and into Contact

Center.

. Modify the feeds from WCS to move from an item level feed only to a

full catalog level feed as Blue Martini is an ecommerce platform and

requires the same level of data that WCS currently receives in order

to operate.

. Using shared services, put processes in place to keep the Contact

Center and OMS order databases in sync.

. Activate support for WCS orders tendered with PayPal.

o Modify OMS Reports to include PayPal tender

o Modify full auth to skip PayPal

. Create re-auth process in the event of price override on PayPal tender

. Activate support for Super SKUs and other item relationships

Role

> Was involved in all the Testing Cycles Each test cycle consist of a

series of functional and non-functional tests like Regression\Base

Integration\New Functionality, Full Integration, Defect fixes, UAT, Maintenance .

> Gained expert knowledge of Business, Project requirements and

Application design functionality in very short time and with minimal

direction

> Created manual test cases in Quality Center by reviewing Requirement

Definition Document (RDD) and Component Requirements Specification

document (CRS).

> Created Integration test cases.

> Responsibilities include developing an updating test plans and test

scripts in Quality Center,

> Responsible for tracking, retesting and documenting defects in Quality

Center .

> Responsible for communicating with technical developers and non-

technical customers and management.

> Responsible for data validation, Created Orders in CTC application and

validated the data in OMS.

> Responsible for changing the status of an Order to Shipped, Cancelled

or Back Ordered.

> Used FTP client to find Order files and do the Perl job for changing

the status of the Order files which were in XML format.

> Responsible for validating the data in XML files.

> Responsible for creating Call Center and BORIS RMA's (Return

Merchandising Authorization) in OMS and validating that the return

process is working correctly.

> Responsible to do an actual BORIS (Buy Online return In Store) RTV

process for the Call Center associate using the RTV system in the Test

Lab and validated the results and also that the process works fine and

an RMA is created automatically in OMS.

> Responsible for moving the files in FTP server to right folders so

that the items are returned and validated that the line item status

changes to All_ Returned in OMS.

> Verified Epiphany and Micro strategy reports against Order Management

System application data.

.

Environment: Quality Center, XML, XHTML, Web sphere, JavaScript, Perl, MS

Office 2007.

Eight Hills, India

Sept 2008 - Jun 2010

QA Consulting

Eight Hills is a software consulting, technology services and out-sourcing

firm that provides onshore and offshore services for Software Companies

around the globe.

Client: Bharti Airtel

Project: RBS, Retail Billing System.

Bharti Airtel is structured into four strategic business units - Mobile,

Telemedia, Enterprise and Digital TV. The mobile business offers services

in India, Sri Lanka and Bangladesh. The Telemedia business provides

broadband, IPTV and telephone services in 95 Indian cities. The Digital TV

business provides Direct-to-Home TV services across India. The Enterprise

business provides end-to-end telecom solutions.

Retail Billing System is the enterprise billing system for the Retail

customers across various markets. It's a ecommerce/.com/web based

application It communicates with the provisioning system in real-time

(Oracle Steams replication) to gather information reg. Accounts,

subscribers, features and offerings. And loads usage data from many source

market using Loader modules running in UNIX. There is a Rating Engine that

rates daily usage based on customer's plans and overages and then runs Bill

Cycle processing to generate Bills in XML and PDF and send to customers by

posting on online website.

Role

> Was involved in QA testing the project deliverables related to the Unix

processes for Loader, Rating Engine and Bill Cycle Processor.

> Was involved in analyzing business requirements Use cases, System

Requirements and HLD (high level design elements).

> Wrote HLS (High Level Test Scenarios) and review that with the Dev team

and obtained approvals. I was involved in developing test cases and test

steps and executing them and capturing results and logging defects and

complete test life cycle to resolution.

> All test case creation, test requirements creation, test steps, results

capturing and defect logging and tracking was done using HP Quality

Center tool

> Ran unix scripts related to the application and used unix commands

(solaris) to verify log files, grepping for success. Failure messages,

set up input test files for loader batch and verify file movement within

dirs, scheduling jobs to run via Unix Cron

> Ran SQL commands to validate data in database tables related to verifying

the results for the loader, usage processing, rating and bill generation

process and for tracking process status

> Wrote a variety of sql involving subqueries, joins, built-in functions

etc. to verify test cases data in the database. I validated the presence

of DDL structures such as tables, indexes, Primary Keys using TOAD to

validate application design

> Validated Foreign Keys exist in databases using TOAD as specified in ER

diagrams to validate application delivery into QC environment

> Executed stored procedures and functions using TOAD to execute related

test cases.

> Validated the XML format of the data exchanged with Provisioning systems

to ensure conformity with XML Schema validation and created test XML

files to test Provisioning to Billing Interface

> Attended team meetings, coordinated testing effort with other testers,

developers, tracked defects till resolution

> Took initiative and assisted in setting up the regression test

environment and for developing automated test scripts and cases and data

in Win Runner

> Assisted in E2E Integrated testing efforts and assisted in post-

production testing related to project deployments

Environment: Oracle 10g, HP Quality Center, Mercury Win Runner, Java,

Apache web server, Oracle APEX, JSP, Sun Solaris Unix, Windows XP/2003.

Macy's Systems and Technology, Atlanta, GA Mar 2008 -

Jun 2008

QA Tester

Project: SPA (Size profile Analysis)

Size Profile Analysis application enables the user to create Size Profiles

via a defined analytical process using historic ordered, received, and

sales units of a category of merchandise by location or group of locations.

Role:

> Created manual test cases and test plans by reviewing Requirement

Definition Document (RDD) and Component Requirements Specification

document (CRS).

> Created Integration test cases.

> Carried out functional testing, Integration testing, End to End testing

and Regression testing

> Gained expert knowledge of Business, Project requirements and Application

design functionality in very short time and with minimal direction

> Used Bug Tracker software for entering and executing Test cases and

logging results and Defects tracking

> Used Management Studio tool for running SQL queries against SQL Server

database for verifying database data and test cases.

> Participated in team status meetings and bug review sessions every week.

> Interacted with Business users and Developers to resolve issues.

> Worked independently with minimal directions.

> Also assisted other teams like A2B and A3 in Macys.

Environment: VB 6.0, IIS WCF .Net services, Bug tracker, Management Studio,

SQL Server 2005, Windows XP/2003.

Macy's Systems and Technology, Atlanta, GA Nov 2007-

Mar 2008

QA Tester

Project: Affinity

Affinity application is a merchandising solution that enables planners in

different divisions across Macys countrywide to create plans for stocking,

purchasing, delivering seasonal and regular merchandise for its nationwide

stores. It is a .Net framework based client/server application using Oracle

10g as backend database.

Role:

> Created manual test cases and test plans by reviewing Design documents

and Use Cases

> Carried out functional testing, Integration testing, End to End testing

and Regression testing

> Gained expert knowledge of Business, Project requirements and Application

design functionality in very short time and with minimal direction

> Used Compuware CARS software for entering and executing Test cases and

logging results and Defects tracking

> Used OraEdit tool for running SQL queries against an Oracle 10g database

for verifying database data and test cases during integration testing.

> Participated in team status meetings and bug review sessions

> Interacted with Business users and Developers to resolve issues

Environment:

.Net, VB, C#, ODBC, ODP .NET, Oracle 10g, Compuware CARS, OraEdit, SQL,

Windows XP/2003

North Canara Bank, Mumbai, India Jul 2006 to Sept 2007

QA Tester

Project: Canara Online

To better serve their customers, Canara Bank provides most of its Services

Online via a ecommerce Web based application called as "Canara Online",

which enables their customers to perform most activities online. The

application delivers state-of-art Online services including Personal

Banking,,NRI Banking, Corporate Banking, Business Banking,Agri and

Rural Banking, Accounts Information, Bill payment, Transfer of funds,

Information on new product offerings, New Membership applications,

Maintaining MasterCard/Visa Credit Accounts, Insurance, Investing,

Applying and Managing Loans/Mortgages, customer correspondence with the

bank etc.

Role

> As part of QA team, reviewed the Business Requirements and the Technical

Specifications for the Development and Enhancements for the "Comerica Web

Banking" Web Application..

> Developed Test cases corresponding to design and requirements and

functionalities for various modules like Apply for Loan/Mortgages, Online

Banking, Funds Transfer, Online Bill Pay, Answer Center, Service Center,

Contact -Us pages etc.

> Performed End-to-End manual black box functional testing using

TestDirector' Requirements, Test Cases and Test Lab modules

> Recorded user actions and generated test scripts to emulate the real

user, using QuickTest Professional.

> Executed SQL queries using SQLPlus and TOAD to check the data table

updates against an Oracle 10g database after test case executions.

> Generated reports and graphs to analyze the test results.

> Used TestDirector as bug-tracking tool to centralize the bugs and also to

follow up the bug status and for interacting with development team

> Involved in regression testing after each build release of the

application.

> Tested GUI functionality of the application for compatibility between

different browsers such as Netscape Navigator 6.0, Internet Explorer 6.0

on multi platforms (Linux, Windows) and interpreted the positive tests

and negative tests results.

> Participated in the team meetings to discuss the issues arising out of

testing.

> Working closely with business analysts and developers to analyze data,

detect bugs, and verify fixes

> Assisting in writing documentation using Word, Visio for the Help/FAQ

section of the website.

> Worked in tight deadline environment and worked to improve end-to-end

quality of the software application.

Environment

TestDirector 8.2, Oracle 9i, SQL, TOAD, XML, Java, JSP, EJB, JDBC, HTML,

Apache web server, Sun Solaris Unix, Red Hat Linux 6, Windows XP/2000.

New India Insurance Company Ltd

Jul 2004- Jun 2006

Mumbai, India

QA Tester

Project: New India Connect

New India Connect is a ecommerce Web application. The application is

designed to make available online, quick and full quote & purchase

information for auto insurance. It deals with entering details of the

Driver's history and Vehicle history. This is a complete online e-

transaction application service involving customers, agents and call

centers through direct or mutual interactions. It is built using Microsoft

.NET architecture interfacing to a MS SQL Server 2000 database.

Role

> Involved in all stages of testing for the development of the application

> Analyzed business requirements and design, interacted with business and

IT development team via various design analysis meetings to prepare

comprehensive test plan for the various modules like entering customer

information, vehicle information, discount eligibility, quote delivery,

property information etc.

> Tested the validity of the Quote Premiums and Purchase Premiums while

comparing the entered Quotes and Purchases with application Data

> Involved in testing the Property & Casualty application, which delivers

the online Auto Insurance information related to the accidents.

> Setup the test data and assisted DBA in setting the test environment for

QA environment after every release and build. Certified QA pass/fail in

UAT and carried out sanity testing in production releases.

> Used Test Director to carry out manual functional and system testing and

as repository for requirement analysis, design test cases, execute test

cases, defect tracking and reporting.

> Verified the Quotes and Purchases operations from the SQL Server 2000

database by running the SQL queries using Query Analyzer.

> Interacted with the developers to sort out the issues and the defects.

Environment

Test Director 7.2, Windows NT/2000, Visual Studio .Net, MS SQL server 2000.

Somnath Transport Service, Mumbai, India Sept 2003-Mar 2004

Software Tester

Project: TAMS Dispatch module

Somnath Transports Service is a renowned transports and logistics services

provider at Mumbai, India, working as carriers and brokers with clients all

over the country. Worked as part of Testing team for the in-house developed

software product called TAMS (Transportation Administration Management

System), that integrates various modules such as Dispatch, Accounting,

Management and other advanced functions. The application is a client/server

GUI application and is developed using Visual Basic and Crystal Reports,

interacting with a MS SQL Server 2000 database.

Role:

> As part of the Software Testing team, I was involved in analyzing TAMS'

product specifications and design for documenting Test plan requirements

and test cases/results in Excel/Word. These were later migrated into

TestDirector.

> Completed on-job training in software testing and testing tool

TestDirector.

> Performed end-to-end manual black box testing using TestDirector.

> Tested DISPATCH module writing test cases for testing various software

functionality like showing and hiding system features on a per-user

basis, creating custom filters, Hot-key F1-F10 maps, Lists, Tracker, Rate

Finder, Load notes, Advances, Driver messages, Quotes, Job orders,

Research and Reports etc.

> Tested the Custom filters for the DISPATCH module Dispatch screen by

user, office, load type, Status, origin/destination zone and

Broker/company dispatch.

> Tested the DISPATCH module Tracker screen to view and maintain Status

info, histories, current locations, check calls, hours of service

tracking, mapping and equipment repositioning. Tested the Rate Finder

screen that Searches routes and finds rates charged in the past and

checks rate matrices for a route matching the rate.

> Tested DISPATCH module Advances module by storing authorize advance

checks from fuel card vendor for drivers or carriers and track advances

open at the same time. Tested Driver messaging system that send Pages to

Pagers held by Drivers.

> Tested DISPATCH module Job Orders and Last action status reporting

screens enables to repeat business, short term job contracts, all tracked

neatly and cleanly, ready for rapid fire dispatching when the time comes.

The Job Order system will count down loads performed for any job and give

you immediate feedback regarding job completion.

> Tested DISPATCH modules Research and Reports screens by using the

application to research loads and Job orders over time periods and

execute pre-defined reports and customize the crystal repots based

reports on-the-fly, and saving as new custom reports. Tested Batch

printing, user access levels, data exports to MS Word, MS Excel, and PDF

and E-Mail.

> Validating Data created/maintained by the application, by running SQL

queries using Query Analyzer against a SQL Server 2000 database.

> Used TestDirector Requirements, Test Plan and Lab modules to track test

requirements, build test plan and test cases, and store test results and

report them

> Used the TestDirector Defects module as a bug-tracking tool to centralize

the bugs and also to follow up the bug status and for interacting with

development team

Environment:

Visual Basic 6, Crystal Reports, Windows NT/2000, MS SQL Server 2000,

TestDirector 7.2, MS Office

Project: TAMS Accounting

TAMS Accounting was built to replace the off-shelf legacy accounting system

as a user friendly, very powerful, totally complete and totally integrated

with TAMS Dispatch solution to avoid doing a lot of data entry twice. It

consists of various modules like Accounts Receivable, Accounts Payable,

Banking, Payroll, General Ledger and Reporting. Built as an Add-on to the

TAMS system, it uses the same architecture as other TAMS modules.

Role:

> Performed black box system testing using TestDirector and to store test

plan, test cases, test results and generate Testing reports

> Analyzed product specifications for writing Test requirements and test

cases into TestDirector Requirements and Test Plan modules.

> Tested functionality for the A/R Accounts Receivable module like managing

customers, Aging, Load Billing, Fast Billing, Invoice generation, Cash

receipts posting, and Collections.

> Tested functionality for the A/P Accounts Payable module like managing

Vendors, inputting Bills, Paying bills, Fast Pay, Purchase Orders.

> Tested Payroll module for managing Personnel, payroll and taxes

processing, and Advances.

> Tested GL General Ledger module for managing Journal entries, recurring

entries and closing entries and Banking module for printing checks,

making deposits and reconciling bank accounts.

> Used TestDirector Test Lab and Defects modules for running test cases and

for logging and tracking defects and testing bug fixes.

> Participated in the team bug-scrub meetings and design change meetings

and changed testing requirements post analysis of design changes.

Environment:

Visual Basic 6, Crystal Reports, Windows NT/2000, TestDirector 7.

Contact this candidate