SUMMARY

• Seven+ years of experience in Quality Assurance Testing on different platforms andTestingthe applicationManuallyusingHP Tools (QC)andAutomation usingMercury Interactive Tools (QTP, Test Director)as aQuality Analyst / Tester.
• Excellent Functional knowledge on various domains like Banking, Financial Services, Health Care, Investment Banking, Public Sector, Telecom.
• Experience in Manual and Automation testing of Client Server / Web Based application.
• Excellent Knowledge in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End - to-End Testing, Regression testing & Involved in Load Testing, User Acceptance Testing (UAT), Performance Testing & Stress Testing.
• Experience in assessing project requirements, development and test status, changes, coverage and risks using QC (ALM).
• Participated in Quality Assurance and Software Development Life Cycle using Agile and Scrum methodologies.
• Thorough understanding of Software Development Life Cycle (SDLC). Waterfall Model, Spiral Model, Quality Assurance Life Cycle (QALC)
• Expertise in maintaining of Test Matrix and Traceability Matrix.
• Proficiency in Back-End Testing/DatabaseTesting specifically in developing and executing SQL queries to interact with databases.
• Excellent skill in creating SQL Objects like Tables, Stored Procedures, Views, Indexes, Triggers, and user defined data types and functions.
• Experience in testing Database like SQL Server and Oracle.
• Extensive data validation in batch files, reports and databases; used SQL to query database extensively for data validation; expert in SQL for sub-queries, nested queries and for complex data enquiries.
• Experienced in conducting JAD sessions, project meetings, reviews and walkthroughs.
• Experience in testingStand alone, Web Based and Client ServerApplications.
• Experience with QA Methodology and QA Validations to ensure the Quality Assurance Control and identifying the Test Requirements based on User Requirements and Design Specifications.
• Experience in testing various analysis reports generated in ETL/ DW Business Objects, (SSAS) and SSRS reports.
• Ability to interact with Business Analysts and Developers regarding Testing Status, Defect & Change Tracking.
• Worked on FATCA tool to understand the detailed gap analysis that identifies improvement areas and impacts related to systems, data and processes across: account opening, documentation, withholding, depositing and reporting requirements.
• Delivers high quality results through cost effective planning, strong teamwork, and excellent communication.
• Detailed oriented, organized, strong written and verbal communication, presentation, analytical skills.
• Flexible and versatile to adapt to any new environment.

TECHNICAL SKILLS

Testing tools: Quick Test Pro, Test Director, Win Runner, Load Runner, Clear Case, Rational Clear Quest, Selenium

Bug Reporting Tools: Test Director/Quality Center

Databases: SQL Server 2005/2008/2012 , Oracle 10g, 11g, MS SQL

Configuration Management: Rational ClearCase

Scripting languages: Java script, VB Script, HTML, XML

Application environments: C++, C#, .NET Framework, EDI, .NET, Web Services, SSIS/ SSRS/ SSAS, Crystal, SOA, Java, ASP.NET

MS Suite/ Project Tools: MS Project, MS Office (Word, Excel, PowerPoint, Outlook), MS Visio

Methodologies: Waterfall, Agile, RUP, Scrum, Iterative, Spiral, Sprint

Operating Systems/ Products: UNIX, Windows - 7, Vista, XP, NT,2003,2000, LINUX, UBUNTU

PROFESSIONAL EXPERIENCE

Confidential, New York

QA Tester

Responsibilities:

• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Prepared the test cases after thorough analysis of each requirement.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Involved in creating the test data for generating sample test reports before releasing to production.
• Conducted and actively participated in reviews, walkthroughs of test cases.
• DevelopedManualScripts in BPT from Generic Script fortestingvarious features.
• Used Agile testing methodology for achieving deadlines in UAT.
• Also worked on Integration of all the processes in UAT.
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Unit, System, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing for new Reporting solution.
• Coordinated with different users in UAT process.
• PerformedUnit Testing for all reports and packages.
• Extraction of test data from tables and loading of data into SQL tables.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created and executed SQL queries to perform source to target testing on DB2 database.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Performed the following tests:data completenessvalidity, uniqueness, data integrity, data transformation, data quality and initial and incremental load tests.
• Tested the entire data reconciliation process for multiple source and target systems.
• Maintained the data integrity and security using integrity constraints and Data base triggers.
• Worked on UNIX Shell wrapper scripts.
• Analyzed the System Specification Requirements (SSR) to understand theTestRequirements in each release.
• End to end data validation, and functionality testing data warehouse projects using Informatica ETL, Oracle Database, and reports.
• Reviewed broker dealer process to write test cases and test plans.
• Involved in creating the test data for generating sample test reports for the applications related to broker dealer.
• Deployed BCP to perform the services required to the various business functions.
• Reduced the time consumption over the tasks by implementation of BCP at the work.
• Assessment of risk and preventive measures by the help of Business Continuity Plan.
• Worked on Autosys which involved in creation of Autosys jobs, execution.Good knowledge of Financial Products like Derivatives, FX trading, Swaps, Non Deliverable Funds and Fixed Income.
• Ensured that Swap module was functioning as per the requirement.
• Reviewed the functions of FX trading application.

Environment: Windows,UNIX, UBUNTU, Oracle 10g, SQL Server 2012, Java, PL/SQL,Visual Basic 6.0, Java Script, Crystal, QTP 11.0, WinRunner, Oracle 11g, BCP, XML, HTML5, QC 10.0, UML, MS Office, Outlook, MS Visio, MS Project.

Confidential, Plano, Texas

QA Tester

Responsibilities:

• Collaboratively worked with developers, business analysts and discussed technical problems.
• Analyzed system specifications and business requirements and helped create the detailed Test Plan.
• Created Test Cases to check the functionality of Application.
• Executed and managed test cases and reported bugs in Quality Center (QC).
• Ensured the existing data structures had a smooth migration to the new database.
• Performed Database Validation Testing and manipulations using SQL
• Executed the test scripts and store each iterative result with related properties (Date, Time, Defects, and Expected/Actual results).
• Developed Automated Data tables in BPT.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Used Simple and Complex SQL Queries like Joins, Select, and Update for data validation and data manipulation in the new data warehouse environment.
• Involved in writing stored procedure, triggers using SQL Server 2012.
• Wrote SQL queries for validating constraints, indexes.
• Prepared scripts, running tests, Analyzing results in Load Runner 9.1 for Performance testing.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Performed UI and FunctionalTestingthrough Web interfaces.
• Used VB script to write executable functions that are embedded in or included from HTML pages and interact with theDocument Object Model(DOM) of the page.
• Included XML check point, to check the property of the web page.
• Conducted database testing manually.
• Involved in PerformanceTesting.
• Perform functional testing and regression testing on each field of Interest and types of loans.
• Performed Manual Testing of web-based and client-server enterprise applications of Bill Track and its Invoice Processing, Inventory Management, Claim Management and Auditing modules by HP Quality Center (QC).
• Used clear case and clear quest for software development and defect tracking tool.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Reported directly to the test lead and discussed all issues occurred during testing.

Environment: VB Script, XML, UNIX, .NET, QTP, Quality Center 10, Windows XP,NT, SQL server 2012, Oracle 10i, SSIS, SSRS, Visual Studio, C++, HP Load Runner, Win Runner, Crystal Reports,Clearcase and Clear quest.

Confidential, Phoenix, AZ

Quality Analyst

Responsibilities:

• Worked with Project team to understand requirements to plan and execute Test Cases.
• Participant in the translation of Functional Requirement Specifications, Business Requirement Specifications and Detail Design Specifications into, Use Cases and Test Scripts.
• Executed the Test Scripts and logged the Defects as found and tracked the Defects at all the stages of Defect life Cycle.
• Involving in Unit Testing, Functional Integration Testing, System testing and Regression testing, and Performance Testing to guarantee high quality software end products.
• Extensively using SQL Queries to validate the Database Updates.
• Involving in reviews and documentation for reporting the status to the project manager. Maintained Test Matrices and Traceability Matrix.
• Analyzing and developing test plans and assist with development, implementation, and execution of new tests and test scripts for the project Customer Production Meter (CPM) mandated by Arizona Corporation Commission
• Worked in the environment of Agile methodology with regular sprint meetings.
• Worked with Customer Information System(CIS),Customer Care Express (CCE)
• Performed Backend testing by writing various SQL Queries to verify that the Data in the Database using QMF(Query Management Facility).
• Using Rational Clear Quest creating the defects which are related to Service plans and Service plan Ids and managing the same.
• Communicating with offshore development team and coordination with testing team to resolve various issues.
• Worked on issues with migration from development to testing.
• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
• Worked on Unix Platform and experienced in back end testing by executing SQL Queries.
• Involved and performed User Acceptance Testing (UAT) with Subject Matter Experts (SME) & UAT Team.
• Retrieved files using SQL statements and UNIX commands.
• Created parameterization for types of expenses using QTP.
• Developed automated Test scripts using QTP to perform Functional and Regression testing.
• Detailed data, system and process requirement considerations

Environment: Mainframe, Rational Quality Manager, DB2, SQL Server 2008, Java, QMF, C#, VBScript, UNIX shell Scripting, Oracle,QC ALM, Rapid SQL, Quality Center, QTP, Agile, Load Runner, Win runner 7.6.

Confidential, Lynchburg, VA

Manual QA Tester

Responsibilities:

• Reviewed Functional Specifications and assists in evaluating test automation approach profiling of Manual Test Cases for Automation Test opportunities.
• Conducted peer reviews of test plans and test cases for QA team members (onsite and offsite).
• Studied all Requirements Artifacts - FRDs, Use Cases, Change Requests to write & involve in Software Testing Artifacts - Test Strategy, Test Plan, Test Case, Requirements Traceability Matrix (RTM).
• Interacted with business client management to solicit requirements and drive issue resolution.
• Escalated Defects while studying Project Requirements and writing Test Cases by using HP Quality Center (QC) and followed logged defects throughout its lifecycle in JIRA.
• Used HP Quality Center (QC) and JIRA for reserving, executing test cases, defect tracking, and the complete test management.
• Performed Data Driven testing with multiple test data inputs with QTP and MS-Excel.
• Performed Backend Testing using SQL queries to validate the data in the Oracle database.
• Follow and enhance developed testing process, procedures and/or methodologies.
• Also Used ClearCase for version control.
• Involved in bug reporting and bug tracking using Clear Quest.
• Participated in Regression testing of the modified build.
• Involved in Extensively User Acceptance Testing with validations and verification.
• Observed all data flow in the data warehouse system and verified details
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Worked on Cloud computing technology to install applications.
• Used cloud to store data and applications for the quick and remote access.
• Used cloud to record and play back of tests, object repository, actions, checkpoints, sync points, debugging, tests.
• Worked on WMS application testing on wireless LANs.

Environment: Rational Test Manager, Rational Clear Quest, Oracle 10G, DB2, TOAD, PL/SQL, UNIX Shell scripting,J2EE, Crystal Reports, Rapid SQL Navigator, Windows, IBM Mainframes, Datastage 7.5.

Confidential

Software Tester

Responsibilities:

• Analyzed and defined clients needs and requirements for the software, defined the quality assurance objectives.
• Created and executed test plans, test cases for the project performance, functional, regression, verification, acceptance, GUI and usability tests.
• Performed backend testing on oracle, executed various DDL and DML statement.
• Reported software anomalies and defects using Clearquest bug tracking system.
• Replicated the problem and created replication log.
• Created the test data and scheduled the test execution.
• Participated in transforming business requirements into System Requirement Specifications (SRS).
• Responsible for defining and documenting system requirement specifications (SRS).
• Created analysis model and data model and used those artifacts to develop the design model, class diagrams, collaboration and sequence diagrams and state chart diagrams.
• Developed automated test scripts using Win Runner.
• Used Win Runner features like Data Driven Testing, Batch testing, Synchronization of the test scripts.
• Developed scenarios for customers data verification using data driven tests, execution, analysis of test scripts, verification of results/ reports/ graphs.
• Performed data validation followed by the manual testing of back end by writing SQL statements.
• Responsible for validation of Target data in Data Warehouse and Data Marts.
• Interacting with other team members and Developers to resolve the issues.

Environment: Win Runner 7.0, Test Director 7.6, Crystal Reports, Oracle8g, Windows Vista, XP, UNIX,LINUX, HTML, XML, Java Script, VB Script, PL/SQL, Oracle, SQL Server 2008.

Confidential

Requirement Analyst

Responsibilities:

• Created test plans, test cases, test scenarios and test strategies based on business requirements and design documents.
• Created positive, negative and boundary-value test cases for all requirements. Created test with prerequisites, design steps and expected values.
• Integrated test scripts created in QTP with test management tool Quality Center.
• Created test scenarios and reviewed them with project team members.
• Created automated test scripts for GUI validation and backend database validation.
• Used documentation in all aspect of content management and documentation.
• Created test scenarios and reviewed them with project team members.
• Used documentation in all aspect of content management and documentation.
• Tracked defects and measured the testing effort and the quality of the software by creating reports in MS word processors
• Submitted, modified and tracked change requests using MS Excel.

Environment: SQL Server 2005, MS Office, HTML, Javascript, SQL, VB Script,QTP, UNIX Shell scripting Windows 2003, 2000.