PROFESSIONAL SUMMARY:

• 8+ years of IT experience in the Analysis, Design, development, testing and Implementation of Quality Analyst solutions using Sales force, SQL, Web and Client/Server applications. 
• Experienced Quality Analyst with strong background in design, development, and support of Web/SOA Testing.
• Strong experience in web services testing using Service Oriented Architecture tool Soap UI 
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back end testing.
• Proficiency in analysing business requirements, entity relationships and converting them to sales force.
• Custom objects, object relationships, Entity relationship data model, Pages, Classes, Interfaces, Workflow rules, Email Alerts.
• Experience working on SOA, Web Services, Web Services Definition Language (WSDL), SOAP, XML and XML Spy.
• Strong working experience on DSS (Decision Support Systems) applications.
• Well versed using UNIX commands for shell scripting.
• Testing on various methodologies for data warehouse projects and Star and Snowflake Schema.
• Planned, developed and conducted unit, function, integration, data quality and UAT tests.
• Hands on experience in testing soap UI and XML web service interfaces and running basic UNIX shell scripts.
• Extensive backend testing executed SQL queries on Teradata, Oracle, DB2, Hadoop, SQL server tables in order to view successful transactions of data and for validating data.
• Experienced in working with HP ALM/Quality Center and Rational Requisite Pro and Clear Quest for test management and defect tracking.

TECHNICAL SKILLS:\

Programming: SQL, PL/SQL, Perl, VB Script, Salesforce.com 

Web Tools: SOAP UI, XML, Web Services, Rest 

Database: Oracle SQL Server, IBM DB2, Sybase, Teradata and MS - Access 

Utilities: Toad, Oracle SQL Developer, SQL Advantage, Putty, Claim Guide wire 

Testing Tools: HP Quality Center/Test Director, Clear Quest, Rational Clear Case, ALM

WORK EXPERIENCE:

Confidential, Charlotte, NC

Sr. QA Tester

Responsibilities: 

• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.
• Worked as team member and performed the roles of sales force tester in the organization.
• Developed Web Service Test with Soap UI to test SOA platform.
• Wrote Test cases and SQL queries to validate the data pulled in from the Data Marts and populated.
• Implemented Salesforce.com web services client using Sales force web services API, Java, XML and partner WSDL.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Involved in testing SOA with Restful/SOAP Web Services.
• Created entire architecture for backend testing. internal and third party API using Test Complete and SOAP UI.
• Good experience in writing SQL in order to data validation in migration as part of backend testing.
• Involved in Testing sales force Classical and Lightening experience.
• Coordinating with UAT for validation supporting Service Oriented Architecture (SOA).
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Installed SOAP UI to test Web Services using WSDL file given by Development team and Tested.
• Validated the source data coming from various databases using complex SQL queries.
• Execute SQL queries to perform Backend testing to ensure data validation.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Logged defects using HP ALM/Quality Center, linked defects with requirements and generated defect reports in QC.
• Involved in automation of test cases using QTP and Did functional testing using QTP.
• Provided Training Sessions and Presentations to the users about using the application in Salesforce.com.
• Performed the functional testing of Web Services using SOAPUI.
• Analysing Facts, Dimension models for data warehousing FDW in Star join schema.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Used Oracle SQL developer tools for Querying source Database.
• Used to test Data Loader to load the data from csv files into Salesforce.com.
• Used Quality Center/ALM for execution, tracking and reporting for Internal High Level access and also to create reports and update bug status.
• Developed test harness for Web Services automated testing by means of SOAP UI and ANT.
• Documented and reported various bugs during the Testing process.
• Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance.
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly. 

Environment: HP ALM/Quality Center, QTP/UFT, Web services, Salesforce.com, SOAP UI, XML, Web Services, MVS, SQL, PL/SQL, SQL Server, Teradata, Oracle, Data Quality Analyst, PL/SQL, TOAD 8.0, SQL, UNIX.

Confidential, Charlotte, NC

QA Tester

Responsibilities: 

• Involved in Business analysis and requirements gathering.
• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC).
• Performed SOA testing using SoapUI and Java framework for Web Services testing.
• Reported periodic project status and updates to the QA Lead and QA Manager.
• Performed Integration Testing of different modules.
• Logging in UNIX server for checking logs in UNIX in Production & Development environment.
• Analysed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases.
• Tested request and response XML's based web services interfaces using SoapUI.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Responsible for Web Services Validation among the different API's using Soap-UI Pro, ITE tool and SOA test.
• Load new or modified data into back-end SQL server database.
• Used Quality Center to run the test scripts and to log and track defects.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Extensively involved in Web service testing using SOAP UI.
• Performed backend testing by validating data between source and target by developing SQL scripts, and verifying stored procedures.
• Tested User Interface inconsistency and application functionality.
• Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, ALM and Quality Center.
• Preparation of test data for various levels of testing.
• Verified the Data completeness, Data Migrations, Data transformations and Data Quality.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created Customized report using Soap UI tool for all the services.
• Created various stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Validated cube and query data from the reporting system back to the source system.

Environment: ALM/Quality Center, SQL, PL/SQL, SOAP UI, XML, Web Services, Teradata, DB2, SQL Server Import Export Wizard, Oracle10g, C#, SQL Server, Erwin, Windows XP, TOAD for Oracle.

Confidential, Chicago, IL

QA Tester

Responsibilities: 

• Involved in Business analysis and Requirements gathering.
• Data migration - Includes migration of data from legacy environment to Oracle System.
• Involved in Data Validation using SQL queries. Written complex SQL to validate the backend values with frontend.
• Performed web services testing with SOAP UI by validating request and response for XML, JSon files.
• Implemented manual testing of web services using XML Spy.
• Utilized Access database to collect data from multiple database sources using ODBC methods. Developed procedures for exporting information in Excel format in development server.
• Consolidated numerous scripts and revised validation logic to conform to data jobs and client data integrity requirements.
• Created user defined functions to dynamically validate data specific to clients. Used SOAPUI for testing Loader Web services.
• Processed transactions from system entry to exit. Tested functionality across applications and workflows.
• Validated Response with the XML Schema during web service testing.
• Worked with UNIX shell scripts for scheduling and running the required jobs.
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance.
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Reported bugs and tracked defects using Rational Clear Quest.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD Software for Querying ORACLE and Used Win SQL for Querying DB2.
• Created critical scenarios for each change request and defect request.

Environment: Quality Center, SOAP UI, XML, SQL, Oracle 9i/10g, SQL, PL/SQL, Stored Procedures, DB2, Toad, Erwin, Test Plans, Test Scripts, Test Cases, VSS, MS Office Suite, Tivoli, Flat Files, XML Files

Confidential, Southlake, TX

QA Tester

Responsibilities: 

• Worked with Business analyst and QA manager in gathering technical and functional specification documents for reviews to understand the functionality.
• Prepared test plan and determined testing approach and time slots for task completion.
• Coordinate with other test team, define the functionalities to be tested and assigned the tasks to other team members.
• Wrote Test Cases and design test steps according to the requirements specifications in Excel.
• Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
• Used SOAP UI tool to test SOA based architecture application to test SOAP services.
• Exported test cases into Mercury Quality Center.
• Inserted Check Points to check for the broken links, Text and standard properties of an object using Quick Test Pro.
• Performed Synchronization and Tested Applications using Quick Test Pro with different sets of data.
• Created page checkpoints to test the properties and contents of the web page using Quick Test Pro.
• Extensively used SOAP UI for functional testing of web services.
• Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
• Get sign off after completion all the test scenarios have been tested successfully.
• Worked with Business Analyst in UAT testing and involved in testing in Production region.
• Extensively involved in Database testing by writing SQL queries.

Environment: Quality Center, SOAP UI, XML, Web Services, Toad, DB2, SQL, MS Visio, SQL Server 2003/2005, HP UNIX, Oracle 9i.

Confidential, Buffalo, NY

QA Engineer

Responsibilities: 

• Develop test plans based on BRDs and Technical Specifications.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Preparation of technical specifications and Source to Target mappings.
• Involved in creating automation test suites for progression & regression testing in SOAPUI.
• Verified the Data completeness, Data Migrations, Data transformations and Data Quality.
• Written Test Plans and Test Cases on Mercury Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analysed the results.
• Used SOAP UI for test data setup in Test Driven Development.
• Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
• Extracted data from various sources like Oracle, flat files and SQL Server. 

Environment: Web Services, UNIX, SQL, PL/SQL, SOAP UI, XML, Mercury Test Director 6.5, SQL *Loader, Oracle 9i, SQL Server 2003, Java.