Summary

• 6+ years of Experience in Quality Assurance which includes Manual Testing in Manufacturing, Insurance and Banking domain
• Expert knowledge of Business Analysis methodologies and iterative Systems Development Life Cycle (SDLC): Rational Unified Process (RUP), Agile, Scrum, Waterfall, etc.
• Experience in software testing process with Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Test log, Test results, Test Traceability Matrix and Test Metrics.
• Involved in creation and implementation of Test Procedures, Test Plans and Test Scripts.
• Experienced in writing Test Plans, defining Test Cases, developing and maintaining test scripts, analyzing Confidential results of scripts, interaction with team members in fixing Confidential errors.
• Maintaining the Traceability Matrix, Test Data Matrix and Status report related to project.
• Highly experienced in all levels of Testing such as Black Box Testing, Positive Testing, Negative Testing, Integration Testing, ETL Testing, Functional Testing, System Testing, Regression Testing, Stress Testing, User Acceptance Testing (UAT) and GUI Testing.
• Experience in HP/Mercury Interactive Testing Tools ( Jmeter, JMeter Maven Plugin, Win Runner, Test Director, Quality Center).
• Used Blazemeter plugin to Jmeter to Access scripts (JMX files), logs and reports of previous runs and download all data files related to a specific test run.
• Worked on Web Services testing using SOAP UI 4.0/3.0, DSpace 4.0 REST API , HUDSON , Apache Axis Client 2.x , Eclipse 3.4 and IBM RAD 7.0 .
• Automated tested Oracle Service Bus using HUDSON, MAVEN and SOAP UI.
• Possess expert level of understanding of WSDL , XSD , Schema, DTD , XML documents for Web Services Testing.
• Well versed in analyzing Results, Bug Tracking & Reporting, Detailed status reporting
• Developed Test scenarios and Test cases using Quality Center/Test Director.
• Expert in writing Test Cases based on Confidential Business Requirement documents
• Generated Test Scripts executed Smoke Test, Functional Testing, ETL Testing and Regression Testing.
• Well versed with Office utility tools such as MS Word, Excel, Visio and PowerPoint
• Knowledge in DBMS and SQL, PLSQL Packages, Procedures and Functions
• Experience in working on UNIX, Sun Solaris, Linux, Windows platform. Developed Shell scripts.
• Excellent communication, presentation and interpersonal skills
• Worked in tight schedules on different web and windows based applications in a group and alone.
• Easily adaptable to any new Technologies and Business environment

Technical Skills:

Platform:Java CAPS 6.2, .NET,

Test Management Tools: Quality Center, Bugzilla, IBM Clear Quest, Jira

Databases: SQL Server, MySQL, MS Access, DB2,Oracle, Terradata

Operating Systems: Windows XP, Windows 7, UNIX

Languages: HTML, Java, SQL, PLSQL, ProtgreSQL, Shell Scripting ETLInformatica 8.6

Professional Experience

Confidential , Napa, CA
Quality Analyst

Responsibilites

• Created and developed Test Scenario , Test cases for Billing Accounts, Process Payments, Cancel policies and Refunds for different user lines for multiple states
• Worked In Agile development environment and implemented Agile (Scrum) QA methodologies.
• Performed Function Testing , Integration Testing and Conversion Testing on Confidential vista system
• Created Test Plan , Test Cases , Test Coverage Document and Reported Test Metrics.
• Developed, modified and executed test cases for Integration testing
• Executed Black Box Testing, Positive Testing, Negative Testing, Integration Testing, ETL Testing, Functional Testing, System Testing, Regression Testing, Stress Testing, User Acceptance Testing (UAT)
• Performed Concurrency testing for premium accounting modules
• Functionality testing on Lockbox process, Process batch cash and Process suspense functionality
• Developed automated test scripts for CR (Change Request) for vista and Claims legacy system.
• Involved in testing Web services(SOAP and REST) and XML with tool called SOAP UI for Confidential local WSDL / with URL and created Test cases, run them, do load testing, security testing.
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
• Testing of Web Services using web services client generated using Apache Axis , SOAP UI , TCP Monitor to track request and response SOAP Messages
• Automated tested Oracle Service Bus using HUDSON, MAVEN and SOAP UI.
• Performed data validation for Confidential migrated data sets from legacy system to Vista
• Tested invoices/payments for standard accounts and custom with ERC and Non-ERC accounts
• Performed testing on Refunds, Financial Transactions and A/R History by Policy, A/R History by Billing account, A/R History by Unit functionality
• Tested role-based security which allows/restricts access to system features and data based on roles assigned to a user
• Extensively tested flat rate, prorate and short rate cancellation procedures
• Performed test cases on Process Batch Cash, IPN, and ERC, Refunds reports that were developed using Business Objects
• Extensively tested DocuCorp XML interfaces and tested policy documents, billing document
• Tested Confidential Refund Security, Payment Plans, Primary Billing modules for existing and new policies
• Created UAT test cases and Executed them, helped Confidential end users understand and use Confidential application

Environment: Windows NT/XP/7, DB2, VBScript, HTML, XML, VB, SQL, Toad, Quality Center, SOAP UI, REST API.

Confidential TN

Quality Analyst

Responsibilities

• Reviewed requirements and design documents with developers and project manager to confirm expected functionality with technical and business needs.
• Evaluated features using risk based testing techniques. Gathered Business Required
• Documented and created Test plan and Test cases, Test Coverage Document and Reported Test Metrics
• Executed Black Box Testing, Positive Testing, Negative Testing, Integration Testing, ETL Testing, Functional Testing, System Testing, Regression Testing, Stress Testing, User Acceptance Testing (UAT) and others.
• Designed, formulated and optimized application test strategy, test scenarios, and test cases.
• Tested multiple types of Publisher & subscription model interfaces ex Web service to Database, Database to Database, FTP to Database etc.
• Validated data integrity in Confidential source and Confidential target systems for Bug free Data transmission.
• Performed Positive, Negative, load and Regression tests for given CRs. Change Requests .
• Arranged weekly meetings with responsible source and target system leads for test plan review and status.
• Communicated project readiness, status and potential risks with stakeholders.
• Used Apache Axis utility to generate client for Web Services, executed Web Services using Eclipse Java IDE and SOAP UI.
• Involved in SOAP and Restful web services using SOAP UI, axis client.
• Documented quantified and elevated risks and provided statistical reporting and analysis.
• Estimated effort required to perform QA activities and reported QA status on Daily basis.
• Managed to work independently or as a Team player in dynamic work environment.
• Quickly adapted to multiple external systems and applications to validate Confidential dataflow among systems.
• Analyzed Confidential performance of Confidential SQL queries using Explain Plan and tuned queries for testing needs.
• Created friendly user guides for team members.

Environment: Quality Center, Java Caps, PL/SQL, JAVA, Windows 7, MS Office, UNIX.

Confidential ,Minneapolis, MN
Quality Analyst

• Created Test cases for various scenarios in Confidential Quality Center.
• Created PL/SQL Packages on Confidential QA Environment for efficient testing.
• Documented and created Test plan and Test cases, Test Coverage Document and Reported Test Metrics.
• Executed Black Box Testing, Positive Testing, Negative Testing, Integration Testing, ETL Testing, Functional Testing, System Testing, Regression Testing, Stress Testing, User Acceptance Testing (UAT) and others
• Tested Oracle Stored Procedure for positive and negative scenarios
• Worked with vendors closely to get appropriate data for testing on QA environment.
• created datasets by conditioning existing datasets and delimited text files
• Validated algorithm for tagging bad records based on business rules.
• Validated Confidential lookup functionality of QDE which fetches matched records from data warehouse.
• Validated SCD Type 2, Type 3 tables which Confidential process uses for fetching data for processing account performed backend testing for data integrity, Data Accuracy and consistency.
• Executed and Validated UNIX (KSH) Shell Scripts which calls SQL jobs in sequence.
• Executed Test Cases and validated data transformations at various stages.
• Tested suppressions on Confidential main dataset based on business logic and validated results.
• Tested business algorithm on calculation of Delta exposure and assignment of line and level to Confidential chase customers.
• Tested SQL Loader to load data to target tables and validated Confidential exchange of partitions after compete load
• Installed, configured SOAP UI to test web services using WSDL file given by Development team.
• Worked in Agile, waterfall method Environments adapted and created Test scenarios.
• Logged Defects and tracked them in Quality Center and Documented potential risks identified during testing and reported to project manager.
• Involved in Testing ETL-Informatica various mappings/transformations.
• Coordinating with source systems owners, day-to-day ETL progress monitoring, Data warehouse target schema design (star schema) and maintenance.
• Used extensively Informatica Designer, Workflow Manager, Workflow monitor and Repository Manager.
• Tested Sessions, Workflows/Worklets and scheduled them in Confidential Workflow manager and Performance tune them.

Environment: Quality Center, (KSH) Shell Scripting, PL/SQL, JAVA, Windows XP, MS Office, SQL Developer, UNIX.

Confidential ,Minneapolis, MN

Quality Analyst

• Gathered Business Required Documents and understood Confidential Data Flow Diagrams of Confidential new process
• Created Test cases in Confidential Quality Center for each functionality of Confidential process
• Conditioned data in Confidential QA Environment using PL/SQL for Confidential process to pick Confidential test accounts
• Validated Business Requirements by running various SQL queries and made sure Confidential data is as per Confidential BRD.
• Documented and created Test plan and Test cases, Test Coverage Document and Reported Test Metrics.
• Coordinated with Policy team and development team and made sure both teams are in SYNC
• Identified potential issues and reported to Confidential Dev team and logged defects in Confidential Quality Center
• Worked closely with DBA to make sure Confidential process is using resources at required level and performed stress testing
• Performed testing extensively for integration and unit testing of standalone and distributed GUI-based applications and SOA Web Services.
• Involved in Testing Web Services using SOAP UI and Web Service Navigator.
• Loaded SAAS data into Oracle to run SQL queries and validate data.
• Created PL/SQL Blocks to condition Confidential data for a faster and efficient testing
• Worked closely with Production Support team for a smother Implementation into Production

Environment: Quality Center, (KSH) Shell Scripting, Windows XP, MS Office, SQL Developer, and UNIX

Confidential , Minneapolis, MN

Quality Analyst

• Created Test Cases based on Confidential Test plan to cover all Confidential requirements in the Requirement Specifications document.
• Tested Confidential process for Confidential restart logic if Confidential process fails unexpectedly
• Documented and created Test plan and Test cases, Test Coverage Document and Reported Test Metrics.
• Conducted negative testing on every process to capture Confidential Return code and pass it to TWS
• Tested Common Function library with Confidential new return code capture capability
• Recommended many code changes to existing processes to handle scenarios when there is NODATA to process
• Tested many Time sensitive shell scripts to run and append Confidential log file
• Executed all Confidential Test cases, Tracked Defects and reported status in Defects Module of QC
• Managed and Updated RunBook for Confidential Production Support team to prevent flaws during ECM Enterprise Change management
• Ran SQL Queries to inserted data from production servers to QA server and ran Confidential process at Confidential scheduled time to create real production scenario
• Coordinated with Confidential Development and Confidential TWS team to set up resources and Naming Standards for jobs and streams
• Performed Black Box , Positive, Regression and Negative testing for all Confidential assigned processes
• Opened Defects and follow up till Confidential dev team fixed Confidential defect

Environment: Quality Center, (KSH) Shell Scripting, Windows XP, MS Office, SQL Developer, UNIX and TWS.

Confidential
Quality Analyst

Responsibilities:

• Backend Database testing by writing and executing SQL queries to validate Confidential data in Confidential database
• Participated in gathering Test Input data includes Pre-condition, Test Input and Test Result.
• Reported bugs/defects in application.
• Worked with business analysts and development team to resolve issues.
• Automated Confidential Test cases using manual testing.
• Performed database testing by writing queries in Oracle database.
• Performed Functional Testing, Regression Testing, Volume, and Stress testing
• Reporting new defects during Confidential testing process by adding a defect record

Environment: Windows 2003, UNIX, SQL, Oracle 9i, SQL Server, XML, Java, HTML, Oracle 8i, Facets.6