SUMMARY

• 8+years of IT experience in Quality Assurance Web based, Client/Server applications using Manual and Automated testing tools.
• Strong noledge of Business Intelligence, Data Warehousing and Business Architecture
• Gathered and articulated business requirements in order to oversee the development of test plans and test scripts.
• Extensive experience wif test management and test automation tools like Quality Center Test Director, Quick Test Professional, and Rational Clear Quest
• Extensive experience in Perl and UNIX shell scripting.
• Well versed wif SQL, PL/SQL and can write complex SQL queries to validate the data conditions against any database including Sybase, Teradata, SQL Server, DB2 and Oracle
• Proficient in development, execution, maintenance of Test Plans, Test Cases, Test Scripts, Test Specifications, Test Scenarios and Traceability Matrix
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Hands on experience wif working on Auto sys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
• Experience in testing Web - based/E-commerce and Client-Server applications on different environments.
• Solid analytical and dynamic troubleshooting skills
• Developed QA processesautomationtest scripts usingPython/Selenium to test Web based user interfaces for different type of browsers. Validated the data from Front End to Back End tables in Oracle Database
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in complex Manual and Automation Testing of GUI and functional aspects of the client-server and web based applications in all phases of SDLC
• Experience in Functional, Regression, GUI, Usability, Integration, Exploratory, Smoke, Backend, Adhoc, Load, Performance, Black Box and White Box Testing
• Experience in Mainframe Testing
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed wif UNIX shell wrappers, KSH and Oracle PL/SQL programming.
• All testing engagements completed wifin project timelines and consistently met live-date project deadlines.
• Experience in writing test plans, defining test scenarios and test cases, developing and maintaining test scripts based on business and functional requirements, documented all phases of QA process.
• Strong in Web application testing and understand architecture in terms of functionality.
• Good experience in Authoring and Reviewing test cases.
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS

Database: Oracle, SQL Server 2005/2008, IBM DB2, Teradata, Sybase

Change Mgt Tools: Test Director 8.0, Quality Center, Rational Clear Quest

Functional Test Tools: WinRunner 7.0, Quick Test Pro 8.2/8.0, Load Runner 8.0

BI Tools: Cognos 8.0 Series & Business Objects

Languages: PL/SQL, T-SQL, SQL, XSLT, Visual Basic, Python, PERL, Shell Scripting

Office Tools: MS Office Suite, MS Project, Microsoft Share Point

Operating System: UNIX, LINUX, Windows, MS-DOS

Rational Tools: Requisite Pro, Clear Case, Clear Quest, Manual Tester

Standards: VSTF 2008, METAL, SQL Server Analysis Server

Tools: TOAD 9.2, Win SQL, Teradata SQL Assistant, SSAS, SSRS, XML Spy 2010

Web Technologies: XML, HTML, JavaScript, VBScript

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

QA Tester

Responsibilities:

• Attended meetings wif the Business Team, and Build Teams to gather the information about the project and the design methodology and the testing requirements
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting wif the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Significant experience in creating requirements specifications, process models and business rules for eCommerce solutions
• Performed UAT, Usability, Cross-Platform and Regression Testing during different stages of the application development.
• Extensively worked on Selenium web Driver wif the preferred Languages Java, C Sharp, Python, Ruby and Perl.
• Write, maintain and improve automation scripts in Perl, BASH, PHP & Python.
• Implemented code in Python to retrieve and manipulate data.
• Performed End-to-End testing efforts for major projects involving on-shore and offshore resources for Financial Services and e-commerce industries.
• Coordinated other parts of the application including POS and Ecommerce.
• Implementing logical and physical data modeling wif STAR schema using Erwin in Data Marts
• Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
• Performed data centric backend testing of applications using UNIX and SQL scripts
• Performed consistency and quality checks on data centric processes on the client data warehouse.
• Part of on call support for issues relating to the internal application, Auto sys
• Manage and control daily processes of eCommerce based company
• Involved in defect reporting, defect tracking and defect reproducing using bug tracking systems Jira and Asana.
• Responsible to create defects using HP ALM
• Ran jobs using the Autosys to load the data from Source to Target.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD)
• Wrote the Insert, Update, Delete and Error Processing test cases in all the stages.
• Wrote PL/SQL stored procedures for certain data validations
• Identify business rules for data migration and Perform data validations.
• Created high level use case diagrams, process composition diagrams and data modeling
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Participate in the creation of Test Scenarios & Test Cases wif the UAT Team and the Business Analysts.
• Worked closely wif fulfillment development team in the application lifecycle to clarify and refine business and functional requirements for our ecommerce department. Efforts led to faster
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Trained the users for the User Acceptance Testing (UAT) and explained about each link, tab and search functionalities to the users.
• Responsible to create, Execute Test Sets in HP ALM Test Lab

Environment:, eCommerce, MS SQL Server 2008, data centric testing, Jira, Oracle 11g (SQL, PL/SQL), TOAD,UNIX, MS Access, SOAP,SOAP UI,QTP, Python, HP Quality Center 11/ALM, Auto Sys, Application testing, Teradata 13.0, Business Objects XIR3, XML, XSD.Petsmart, Philadelphia, PA

QA Tester

Roles & Responsibilities:

• Write, maintain and improve automation scripts in Perl, BASH, PHP & Python.
• Implemented code in Python to retrieve and manipulate data.
• Created, updated and maintained the object repository.
• Reported and tracked the bugs to closure using JIRA.
• Developed test scripts to automate process of testing in Web Driver using Testing and TestNG.
• Involved in creating automation test suites for regression testing in Soap UI (the messaging formats included REST based clients wif XML payload)
• Loaded test data from a SQL server in to the web application
• Used Maven to manage Project's build and dependencies and Jenkins for deployments to environments
• Performed functionality testing using SOAP UI by importing WSDL from Webservices.
• Performed Data Driven testing using SOAP UI.
• Worked on assertions and XPATH and in request and responses data which would be returned.
• Worked on creating XSD, SOAP Protocols and WSDL.
• Worked extensively on XQUERY and XSLT transformations in SOA to provide mapping between the consumer and provider business service.
• Tested Web Services using SOAP UI, RESTful, MQ for PCP or IPA auto assignments and also in get Provider Demographics and get Provider Risk Program Details.
• Involved in testing Basic Flows, Alternative Flows (SIEBEL) which generate the exceptions and API testing.
• Worked in TEST Environment (QA Environment), STAGE Environment testing the database in System testing, Integration, Regression, SIT, End to End, and Content Management testing, also involved in UAT.
• Documented defects, using a HP Quality Center, and report defects to Project teams.
• Identified, analyzed, and documented problems wif functionality, output files or tables.
• Monitored defect resolution efforts and track successes.
• Created Metrics and status reports for projects.
• Monitored the Defect Tracking Process and generated customized graphs and reports for the client using QC.
• Supported QA management wif information for issues escalation or concerns.
• Environment: Soap UI 4.0.1, Mercury Quality Center 11.5, Load Runner XML/SOAP, Toad, XMLSpy, SQL Server, .Net Windows XP/Vista, Web Sphere Application Server

Environment: Python, TestNG, SOAP UI, RESTful, PCP, IPA, API Testing, UAT, Soap UI 4.0.1, Mercury Quality Center 11.5, Load runner XML/ SOAP, Toad, XMLspy, SQL Server, XQUERY and XSLT

Confidential, Springfield, IL

QA Tester

Responsibilities:

• Developed unit test cases, configured environments and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Involved in defect reporting, defect tracking and defect reproducing using bug tracking systems Jira and Asana.
• Extensively worked wif Metrics, Filters, Transformations, Custom Groups, and Consolidations using MicroStrategy tools.
• Responsible for Black Box, functional testing, User Acceptance Testing (UAT), smoke testing, exploring testing and Regression testing on various releases of ecommerce website
• Possess hands-on experience in the field of construction, apparel and pharmaceutical eCommerce web application development.
• Reported and prioritized software defects utilizing Jira
• Developed a fully automated continuous integration system using Git, Gerrit, Jenkins, MySQL and custom tools developed inPythonand Bash.
• Tested several data migration application for security, data protection and data corruption during transfer
• Review the point of sales (POS), Coupon Authorization(e-Commerce/Retail)
• Performing integration testing and validating SIT and CT environments for UAT and Carrier Testing.
• Tested different reports, graphs and pivot reports in Microstrategy dashboards
• Worked wif Business analysis team to prepare a detailed Business Requirement documents.
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, GUI & Regression testing of web-based applications.
• Gained working noledge of Auto sys jils at command line for loading/force starting jobs, changing job status and monitoring job progress.
• Testing web-based ecommerce application for selling proprietary electronic devices
• Witten SQL queries to validate the reports generated from Microstrategy.
• Executed Complex SQL queries wifin UNIX shell scripts in the UNIX environment.
• Conducted user acceptance testing (UAT) to validate dat the developed application meets the business requirements and executed/monitored Auto Sys
• Experience in integration of various data sources wif Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Tested PL/SQL Programs to prepare and clean Data for data migration and also to retrieve data from the database to compare against the input sets
• Worked wif business team to test the reports developed in Microstrategy.
• Worked on notices and validated PDF notices after executed in RQM
• Created test scripts for the application which uses SOA, Web services, SOAP and WSDL..
• Written several Stored Procedures and modified existing stored procedures.
• Involved wif extraction routines to verify all the required data loaded into target systems.
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Developed QA processesautomationtest scripts usingPython/Selenium to test Web based user interfaces for different type of browsers.
• Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.
• Involved in planning, setting up test environment for and executing Smoke Testing, Sanity Testing, Functional Testing, Regression Testing and SIT various releases of ecommerce.Focused on Data Quality issues / problems dat include completeness, conformity, consistency, accuracy, duplicates and integrity.

Environment: Oracle 10g,Teradata 12.0, ECommerce, Auto Sys, Microstrategy, Application testing, SQL Server 2008, SQL, PL/SQL, SOAP, SOAP UI, Stored Procedures, HTML, Python, Quick Test Pro, HP Quality Center 10.0, Points Portal, Autosys, MS Office Suite, Rational Quality Manager (RQM), HTML, JAVA, JSP, JavaScript, Rational Clear Quest, Clear Case, RUP, TOAD, Requisite Pro, Test Manager, Automation/Manual Testing, UNIX.

Confidential, Richmond, VA

QA Tester

Responsibilities:

• Worked closely wif the development teams to replicate end user issues.
• Performed functional test and load test on SQL queries, store procedures and forms.
• Modified the design as per the changes in requirements.
• Interacted wif the client on a daily basis and attended status meetings.
• Worked wif developer to improve database performance.
• Involved in Data migration and Data distribution testing
• Created and maintained development, QA and audit database environments
• Attended status meetings and sending team status reports.
• Use of TOAD to write SQL queries and validate the backend
• Documentation of Test Results, Test Reports and Test Summary Report.
• Implementing logical and physical data modeling wif STAR schema using Erwin in Data Marts
• Worked wif QA team members and application developers; quickly capture the major business functions and technology to design and implement tests of system functionality dat exercise all critical intersystem integration points.
• Utilized mercury test suite for requirement management, test case creation, execution and defect tracking.
• Provided and mentoring to offshore QA team.
• Performed User Acceptance Testing (UAT) to ensure dat proper functionality is implemented.
• Wrote PL/SQL stored procedures for certain data validations

Environment: PL/SQL, SQL, Test Director, UNIX, Shell Scripting, VSAM Files, XML Files, data centric, CSV, COBOL II, Copy Books, Autosys, Crontab, Oracle 10g, Sybase 12.3, Business Objects XIR2, TOAD, WinSQL

Confidential

QA Tester

Responsibilities:

• Used TOAD to write SQL and validate the backend
• Used SQL Teradata Assistant for data retrieval from Teradata
• Identified bugs and interacted wif team lead and developers to resolve the bugs
• Used Back-end testing using SQL queries to validate the data in the back-end Oracle Database
• Maintained the test matrices and reported bugs using Rational Clear Case
• Created Test Strategy and Test plan for the testing effort
• Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests for various phases of this application
• Worked on issues wif Data migration from development to testing.
• Conducted Smoke, Non Functional, Functional, System and Integration testing.
• Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Conducted backend testing using Toad
• Participated in weekly meetings wif the management team
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Coordinated wif the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Autosys, SQL, Data centric testing, Business Objects, SQL, SQL Server 2000/2005, Teradata V2R4, Test Director, MS Office Suite, IE, ASP, Crystal Reports,, HTML, JAVA, JSP, JavaScript Windows NT/XP/2000, Rational Clear Quest/Clear Case