Professional Summary

11 years of Quality Assurance experience in software industry as a QA Lead, Co-ordinator and Analyst. Performed Software Analysis, Design, Script Development and Software Testing (Manual / Automation) of Web, Client Server and Data warehouse Applications experience in credit\\debit\\Gift card, Telecommunications, Retail supply chain, Point Of Sale, Banking\\Finance, Insurance, and pharmaceutical.
Managed and lead a team of tester's in onshore as well offshore, expertise in cost and resource estimation.

• Participate in functional and technical meetings, from the beginning of the project through the entire life cycle (SDLC).
• Experienced in defining the QA Strategy to cover Functional, Performance, Regression, System integration testing and Interface testing.
• Verification of QA team build test deliverables and documents to ensure quality standards is met.
• Managed process plan and schedule to ensure deliverables are completed on time and on budget.
• Experience in managing QA risks and issue based escalation process and mitigation plans.
• Responsible for performing various types of process evaluations during each phase of the software development life cycle, including review, walk through and good understanding on software testing methodologies (Agile).
• Involved in gathering requirements from the business users and created Test plans, Test Data and Test scripts.
• Converted Business requirements and design documentation into test design products and executed Test Cases and Test Scripts.
• Develop and execute both manual and automated test plans and scripts to ensure the product adheres to the system / application requirements.
• Design and created automated test script using QTP and Win runner Automation tools for the web based application testing.
• Experience writing and configuring VB scripts, adding checkpoints, parameterize and perform database checks validation using QTP. Experienced in VBScript function creation and function library creation for QTP.
• Performed Functional, Smoke, System integration, Regression, andSecurity testing during different stages of the application development.
• Experience in writing complex SQL queries and Performed Database integrity system testing.
• Expertise in validating ETL process for data warehouse application.
• Expertise in testing and development of Data Warehouse, Business Objects reports, BO universe and Hyperion cubes
• Executed load and stress testing using load runner validated the performance.
• Used Informatica client tools Designer, Workflow Manager, Workflow Monitor and tested data warehouse application.
• Track and report test results and bugs using Test director for the product\'s compliance to the functional specifications. Used VSS for version control.
• Worked with software change control management and associated and mentor with UAT teams Involved in Alpha and Beta testing.
  Interpret test data, and interface with development teams data field

Technical Skills
Databases : Teradata V2R6, Oracle 10g, SQL Server, DB2-AS400,
MS Access.
ERP-CRM : Siebel, Oracle, People soft8
Middleware : Web Sphere
Reporting Tools : Business Objects, HYPERION CUBES, Crystal Reports
Operating Systems : Windows NT/XP, MS-Windows, unix, OS/400
Design Tools & Methodology: Toad, SQL Plus, Query Analyzer, Enterprise Manager,
Erwin, Primavera, Visio, WinSCP, MS Project, Informatica, Teradata sql assistant(12), Pentahoe

Test & Defect Tracking Tools : Quick Test Pro9.0, Win Runner8.0, Mercury Test Director8.0, Bug Tracker, Clear Quest, Compuware Cars. Load runner, Quality center10.0.

Version Management Tools : VSS, Share point.
Web Technologies : VB.net, C#, JAVA, JAVA script, WEB SERVICES, VB script,
Bea Web logic, iis, ASP, XML, SOAP, HTML

Professional Experience

Confidential, GA
QA Lead Aug2009 to present
Working as a consult for setting up of a new system developed to support various stored value merchants and partners. My responsibility includes managing a team of testers, validation of gift card transaction cycle, Customer service website, cardholder website, IVR, ETL transaction to Master data, Data warehouse and Reporting system.

• Design, develop and executed the Test Plans and Test cases based on Business requirement.
• Review the test plan and test cases with the project team and get approval.
• Executed system, regression and end-to-end system integration testing.
• Assign targets to the team members, guide and monitored the progress of testing.
• Validated the transaction request and response based on ISO8583V3.0
• Performed complex sql queries to validate back end transactions and ETL process.
• Executed system testing and system integration Customer service website and IVR
• Validated System and system integration testing for card holder website
• Validation of share point role based security access for the intranet portal.
• Validation of data sharing, upload and down load of business doc.
• Validation of billing to merchants using Oracle finance module.
• Validated ETL transaction data to IBO and Data warehouse system
• Tested daily, weekly, monthly reports for various merchants.
• Used automation tool QTP for website validation by scripting and configuring VB scripts, adding checkpoints, parameterize and performed database checks validation using QTP.
• UAT environment set up and test support
• Postproduction testing and certification.
• Managed 3 week sprints in scrum (Agile) environment

Environment: SQL server 2008, Jboss, Soap, Java, Web services, Pentaho, JIRA, XML, QTP, Iunit, ASP, .net, Sharepoint, Oracle finance 11i,SSRS, iRIS

Confidential, GA
SR- QA Analyst June 2008 to Aug2009
Worked as Sr. QA analyst for AT & T data warehouse system. Responsibility includes validation of end to end data integration, Business object reports and BO universe, extracts, Hyperion cube for BID, Mercury, Data pipe and BMG system.

• Design, develop, Test Plans, Test data and Test cases.
• Develop an integrated Test Plan, Traceability matrix covering the main functions based on BRD, HLD and FRD.
• Review the test plan and test cases with the project team and get approval and loading to Share point.
• Perform Functional, integration, Regression, System integration testing during different stages of the application development.
• Wireless handset testing for various applications.
• Validation of share point, data sharing, uploads and down load of business doc.
• Validated the conversion project People Soft HR module to SAP.
• Design test data and validation for OPUS, PDC2, PHEONIX, SYSTEM-X, Amdocs CLARIFY, TELEGENCEBilling system.
• Back end validation for I-Phone, Uverse, DSL, business and retail wireline and mobileproducts.
• Validated canned reports generated from the data warehouse using Business Object and provide test data and environment access to UAT team.
• Validation of business universe and ad-hoc reports.
• Performed validation for Hyperion Cubes rollup testing, Dimensions calculation, Aggregation and data load
• Expertise in validating ETL process for data warehouse application.
• Used complex SQL queries to validate and analyze the Teradata and Oracle database
• Performed end to end OLAP system integration testing, which involves all AT & T front end system, middleware, billing, Provisioning, Datawharehouse and down stream-commissioning system.
• Tested extracts files end to end in pipe delimited, XML formats in UNIX box and create and run shell scripts.
• Software testing life cycle in agile development environment.
• Used Quality center and Clear quest for defect tracking.

Environment: Teradata V2R6, Oracle10g, Business Object, UNIX, Solaris 10, Informatica, Hyperion Cubes, Telegence, Quality CenterV.10, Clear quest, XML, shell script, Teradata SQL Assistant (12), Peoplesoft, SAP, Excel, Visio, Share point.

Confidential
QA - Lead July 2007- June 2008
The application will facilitate the creation of pre-season and in-season planning data for the Macy's merchandising divisions. Including validation of data history data to the target Mainframe/Teradata systems.

• Managed a team of four testers and involved in the project through the entire software development life cycle (SDLC).
• Assign targets to the team members, guide and monitored the progress of testing.
• Design, develop and executed the Test Plans and Test cases, Review the test plan and test cases with the project team and get approval.
• Report the daily status to the PM and escalation of project related issues.
• Performed Functional, Integration, Regression and System testing during different stages of the application development.
• Experience in writing complex SQL queries to validate and analyze Teradata database
• Validation of reports generated from OLAP using Business Objects
• Validation of business universe and ad-hoc reports.
• Identified software problems, wrote easy-to -follow bug reports, logged them into bug trackingtool, monitored their progress and verified their fix.
• Extensively used VBScript functions, Parameterize the test, run the test using regular expressions,

Environment: Retech , Oracle, VB.net, TeradataV2R5, Mainframe, QTP, Cobol, Informatica, Business Objects Xi, Quality center, Compuware Cars, Bug Tracker, Unix, Excel, Citrix

Confidential, INC NY

QA Onsite LEAD Jan 2007 - July 2007

Worked as onsite lead for a leading pharma IT solution provider. RAVE is a web-based system for capturing, managing and reporting clinical research data designed to help pharmaceutical companies to optimize the research by streamlining the clinical process. It provides the electronic data capture and clinical data management; user configurable workflow design; simple and complex edit check, customizable security parameters and integration to other data sources.

• Participate in functional and technical meetings, from the beginning of the project through the entire software development life cycle (SDLC).
• Managed a team of ten testers in offshore, provides mentoring, training.
• Prioritize the work orders as per QC target date and assign to the offshore team members.
• Perform QC testing and complete the documentation for the QC audit.
• Coordination between various project managers and Project analyst, escalating project related issues.
• Record and track defect uncovered during testing and retest, script, data on rest.
• Effectively managed multiple project and tasks.
• Executed load and stress testing using load runner validated the performance.
• Used SQL queries validating MS SQL database.
• Validation of SAS integration with web
• Software testing life cycle in agileScrum development environment.
• QTP action library creation and enhancing and test script creation from Quality Center.
• Experience writing and configuring VB scripts, adding checkpoints, parameterize and perform database checks validation using QTP.
• Categorized bugs based on the severity and interacted with developers to resolve them.
• For Regression testing used QTP for automated testing, Performed web specific testing like Link Checking (external, internal), Browser page testing, Application testing, and Security testing.

Environment: QTP9.0, Quality center, C#, XML, SOAP, Web service, MS SQL, ASP, IIS, Query Analyzer, Enterprise Manager, Loadrunner 9,SAS, Windows XP

Confidential, Publix FL
SR.QA ANALYST May 2006 - Jan 2007

Forecast tool kit is an intranet system which reviews and modify the forecast generated by the planning system for specific business promotions, external events like holidays, hurricanes and various market conditions to the item-store level which makes forecasting accurate to the desired level. Involved in the analysis and validation of store causal management system for meals, promotions and price reductions, back end Data base testing for their POS system, credit card validation and authorization, process flow for payments, reversals.

• Involved in gathering requirements from the business analyst and created Test Plans.
• Design, develop and executed the Test Plans and Test cases.
• Validated the Point of Sale system, Credit card validation, Terminal verification,Card verification results, authorization and payback for Master card, Visa and Amex.
• Performed Smoke, Functional, Regression, System, integration, Acceptance testing during different stages of the application development.
• For Regression testing used QTP for automated testing, Performed web specific testing like Link Checking (external, internal), Browser page testing, Application testing.
• Experience in writing complex SQL queries validating Oracle and MS SQL database
• Validation of functional and regression testing of oracle CRM product and customer management
• Extensively used VBScript functions, Parmeterizing, test objects in shared objective repository file
• Identified software problems, wrote easy-to -follow bug reports, logged them into bug trackingtool, monitored their progress and verified their fix.
• Categorized bugs based on the severity and interacted with developers to resolve them.
• Used SCRUMIterative methodology in software testing life cycle in agile development environment.
• Executed load and stress testing using load runner validated the performance.

Environment: JAVA, J2EE, QTP, Test Director7.6, Oracle 9i, Toad, VB.NET, DB2, Cobol, MS SQL, Query Analyzer, Loadrunner, Enterprise Manager Windows XP, IE, XML, Manugistics.

Confidential, Allstate TX
QA ANALYST July 2003 - May 2006

Project description:

Worked as a consultant for Confidential, is the leading U.S. based insurance organization and the largest underwriters of commercial and industrial coverage's in the United States. PRS is a streamlined, user-friendly desktop application that will determine rates of insurance policies sold by ALLSTATE Specialty auto. PRS is responsible for tracking users (agents), gathering customer information, building a rate, printing out policy for the customer.

Involved in gathering requirements from the business users, creation of business use case, Technical use case, preparation of functional requirements and flow charts.

• Converted Business requirements and design documentation into Test plan, Test Cases and Test Scripts.
• Developed an integrated Test Plan covering the main functions of the designated parts of the application.
• Created the ad-hoc reports using business objects, tested and delivered to business managers.
• Performed Smoke testing, Functional testing, and Cross-Platform, Regression, System, Acceptance and Usability testing during different stages of the application development.
• Performed data driven test using QTP and winrunner for multiple scenarios with different sets, conducted data validation testing using SQL queries.
• Validated Informatica mapping using client tools Designer and work flow manager
• Validated and tested datawarehouse application and reports.
• Expertise in validating ETL process for data warehouse application.
• Used complex SQL queries for validating Oracle database.
• Validation of canned reports generated from OLAP using Business Objects
• Validation of business universe and ad-hoc reports.
• Identified software problems, wrote easy-to -follow bug reports, logged them into bug tracking tool, monitored their progress and verified their fix.
• Created test case for UAT team and did walkthrough for the business.

Environment: QTP8.0, Winrunner8.0, Quality center 8.0, oracle8i, AS/400, SQL server, VB .Net, MS Project, Windows NT4, MS Office, Visio, VSS, Informatica 7.1,Unix, Perl script, Business objects.

QA Analyst Confidential, GA
Nov 2001 - July 2003

Worked as a QA analyst for a leading telecommunication co testing of telephone ordering and billing system.

• Front-end testing of systems for Land lines, Cell phones, DSL (Data) and Video (Cable) Ordering System on GUI Interface.
• Tested Siebel CRM module for ordering, Product management, Customer management, Scheduling and field service, Address and credit verification, trouble logging telecommunication services.
• Assisted management in approval of tools, techniques, methodologies for software enterprise application testing.
• Validated billing process, invoices, customer payments, and uncollectable accounts.
• Test plans / test cases documentation using MS Office products.
• Involved in end-to-end testing escalating testing issues with developers, test-plan, traceability reviews and daily status reporting.
• Interaction with developers, customers, management.
• Sieble CRM, Test director, Java,J2ee, oracle8i, SQL server,Windows NT4, MS Office, Visio,

Educational Qualification
Bachelor of Engineering