SUMMARY

• 7+ years of total IT experience and very good knowledge QA Testing. Extensive experience in testing using Manual and automated testing tools in Domains like Retail, Financial, Healthcare.
• Strong knowledge of test management tool HP Quality Center, HP Application Lifecycle Management and Rational Clear Quest tools.
• Diverse experience with various testing methods such as Functional testing, Regression Testing, System Testing, Integration Testing, User Acceptance Testing (UAT), Database Testing, End to End Testing.
• 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.
• Experienced in all phases of Systems Development Life Cycle (SDLC), including requirements analysis/design, development and testing
• Proficient in writing SQL queries, PL/SQL and executing SQL queries to perform backend testing.
• Validated Service-oriented architecture (SOA) for distributed computing using Web Services Testing.
• Ability to develop and present test plans, testing summaries, defect reports, and defect trend data throughout the projecttest cycle.
• Good Experience in QA Methodology and Validations to ensure industry standards.
• Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality Center in Client/Server.
• Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases, Test Scripts for Manual and Automated Testing
• Experience working in using Databases like Oracle, Teradata, SQL Server, DB2 9.x, DB2 9.7 luw, MS Access.
• Expertise in Database Programming (Stored Procedures, Triggers, Packages, PL/SQL) using Oracle.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experienced in Data Modeling, Erwin, Star/Snow Flake Schema Designs, Logical Data Modeling, Normalization, Physical Design, Data Analysis, Data Modeling, Reports and Report Design.
• Expertise in writing Unix Shell Scripts.
• Excellent verbal and communication skills, has clear understanding of business procedures, adapt new environment quickly, Team building, Leadership and Project Management Skills
• Quick learner, efficient, self-motivated and success oriented. Excellent written and communication skills and ability to work independently in a time sensitive environment

TECHNICAL SKILLS

OS: Sun Solaris 2.7/2.6, MS DOS 6.22, Windows 95/98/NT, Windows 2000/2003, Windows XP, Windows 7, UNIX

Functional Testing Tools: QTP11.0, Rational Robot, VSS, Selenium

Languages: VB.NET, VBScript, C#, SQA Basic, C/C++, Java, Data Structure, HTML, XML. Unix Shell Scripting, SQL, PL/SQL

Databases/Tools: Oracle 10g/9i/8i, MS Access, MS-SQL Server 7.0, DB2 9.x, DB2 9.7 luw, Teradata V2R6, TOAD, SQL Navigator, Teradata SQL Assistant 6.2, Oracle SQL Developer,SQL Server Management studio

Testing Tools: Win Runner, Load Runner 7, Quality Center 10, and HP ALM HP Quick Test Pro 11.0

Browsers: IE5.5/6.0, Netscape 6.2/7.2, Fire Fox 1.x

MS Office Tools: (MS Word, MS Excel and PowerPoint, Outlook)

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

Sr. QA Tester

Responsibilities:

• Understanding the end to end Buisness Flow and respective changes in-order to create the Test Scenarios, Test Plan and Test cases
• Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality Center in Client/Server
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Creating test scripts using Quality Center and performing regression testing on new versions of the software.
• Used HP Quality Center to perform Manual Testing and logging and tracking defect in BugZilla until the bug was fixed
• Created Manual Testing strategy and performed Database Testing using SQL Queries by retrieving data from Oracle Database
• Analyzed Manual Test Cases with QA Team for most important & high priority Requirements for conversion to Automated Test Scripts using HP QuickTest Professional (QTP)
• Identified and evaluated CIB risks and areas of risk. Managed the Risk Assessment for the CIB and Capital Markets Groups
• Mentoring senior auditors on auditing Offshore Capital Markets super captive investment vehicles
• Conducted regular Broker Dealer (Including Hedge Funds), International Trade Finance and Capital Markets Branch AML Compliance Audit and Training.
• Validated Multi-Asset Class data, from over 40 sources, with data related to cash, equities, bonds and foreign exchange investments.
• Served as an SME on implementation of business rules, with extensive knowledge of financial instruments such as bonds and swaps, hedging strategies, and SOX & BASEL II standards for Capital Calculations.
• Used SQL tools to run SQL queries and validate the data loaded in to the target table
• Responsible for defining the Test Strategy, creating the Test Plans and the Test cases basing on the Business requirements document.
• Review Business and Functional Requirements and develop Detailed Test Plan and Test Cases
• Worked in Agile Scrum project implementation performing test coordination, task management.
• Conduct Test Status meetings with the Business Team, QA Manager, and Development team to review Test Progress and discuss business critical issues identified during application validation.
• Extensively Queried through SQL to check the database record
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL
• Involved extensively in doing back end testing of the data quality by writing complex SQL
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Extensively used SQL queries to extract the data from different fiscal week, fiscal quarter for different stores as required for analysis from the Oracle databases
• Create the Oracle Workflow processes or procedures and packages
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Tested the data from different sources sources to the target.
• Designed SQL queries and fine tuned SQL queries for better performance.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked with users & analysts to understand requirements
• Participated in client meetings to review Integrated Data approaches and to interpret results
• Closely involved in gathering requirement, design, development and implementation of the project
• Defined the testing requirement documents
• Worked with Development Team to draft the Development Checklist and Plan for Iteration Releases
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing
• Performed database validation according to the business logic by comparing the source to the target in Spreadsheet
• Work with source system personnel on source data delivery issues .Interacted with DBA for setting up test environment
• Created the test environment for Staging area, loading the Staging area with data from multiple sources
• Extraction of test data from tables and loading of data into SQL tables

Environment:, HP QTP 11, PL/SQL, SQL, Quality Center 10 SOAP UI, Teradata, TOAD, Oracle 11ig, Java Script, SDLC, Agile, DB2, HP ALM, Regression, Functional, Integration, System Testing and User Acceptance Testing, XML, UNIX Shell Scripting, (MS Access, MS Excel PowerPoint Outlook)

Confidential, Richmond VA

QA Tester

Responsibilities:

• Analyzed Business Requirements document for developing Test Plan, Test Cases and providing the Test Estimations per session and prioritize the Test Cases
• Review Business and Functional Requirements and develop Detailed Test Plan and Test Cases with Agile Scrum methodology.
• Reviewed requirements for Testability and Usability, consulted Development staff regarding system functionality
• Worked with the project team to accomplish quality assurance and process improvement initiatives.
• Performed End User Testing before the Build is released for actual real time implementation.
• Prepared and contributed in creating Test plan and Test Strategy along with arranging and executing Test Cases for Manual and Automated Testing
• Wrote, prepared and executed Manual Test Cases based on Requirements and Use Cases, and Automated Test Scripts throughout Software Development Life Cycle (SDLC.
• Executed and maintained Test Plans, Test Case, Test Scripts, and Test Data for manual testing approaches using track & defect management tool HP Quality Center (QC).
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center
• Involved in Identifying of the unused test cases in the Test Plan in Quality Center and prepared a consolidated doc to delete the test cases.
• Used Quality Center as a Defect tracking tool to report the defects encountered while testing Base lined the Test Plan, Test Criteria & Project Schedule by walkthroughs and review meetings
• Executed test cases manually to perform Integration testing, compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution using Quality Center, along with logging defects with details and following up.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Identified and thoroughly analyzed defects, issues, risks, and action items along with identifying the business requirements & the system requirements as part of the project team.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Quality Center
• Worked on Various SQL Server procedures for various Bugs, executed queries in test databases using SQL queries.
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Conducted extensive database testing, passing SQL queries to the Oracle
• Validated the data loaded into the target database which extracted from multiple operational data sources DB2, Oracle, SQL Server and flat files.
• Installation, configuration, upgrade, optimization, and maintenance of Sybase 12.x and MS SQL Server Databases.
• Used System monitor, event log viewer, SQL profiler, SQL analyzer to monitor and tune the performance of SQL server.
• Tested the report generation and written complex queries using different data providers in the same report.
• Assigned in creating various testing scenarios for performing Functional & Integration Testing.
• Used Query Studio to test ad hoc reports
• Performed manual testing on different modules of the application.
• Used SQL tools to run SQL queries and validate the data loaded in to the target table

Environment: HP QTP 10,PL/SQL, SQL, SOAP UI, Teradata, TOAD, Oracle 10ig, Java Script, SDLC, Agile, DB2, QTP, HP ALM, Quality Center 9, Regression, Functional, Integration, System Testing and User Acceptance Testing, XML, UNIX Shell Scripting, (MS Access, MS Excel PowerPoint Outlook)

Confidential, San Francisco, CA

QA Tester

Responsibilities:

• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing and Performance Testing.
• Understand the business requirement and the different environment batch cycles.
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Involved in Manual Testing, Functional testing (Black Box Testing),
• Created Manual Test Scenarios and Test Scripts by analyzing Functional, Business and Technical Requirements.
• Strong testing Quality Assurance experience within agile environment..
• Good understanding of agile software development lifecycle (iterative and incremental)
• Provided Autosys expertise for batch processes running in the QA environment within the Enterprise Business Intelligence group.
• Validating the data upon each job start and end point in the database.
• Defect raising, tracking and updating of defect in QC on regular basis.
• Strong technical expertise in Integration testing, Functional testing, GUI testing, and Backend testing.
• Creating test scripts using Quality Center and performing regression testing on new versions of the software.
• Written test cases to test the application manually in Quality Center and automated using QTP.
• Used Quality Center for bug reporting
• Tracked and reported the bugs with Quality center.
• Optimizing/Tuning several complex SQL queries in SQL Navigator for better performance and efficiency
• Extracted data from various sources like Oracle, flat files and SQL Server
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata
• Involved in extensive Data validation using SQL queries and back-end testing
• Extensively Queried through SQL to check the database record
• Developed and Executed SQL statements in Toad to retrieve data and to validate data
• Worked closing with dev and BA team to do all validation checks.
• Moniter the performance of job on daily basis to see the performance.

Environment: HP QTP 9.0,PL/SQL, SQL, Webservices, Teradata, TOAD, Oracle 9ig, Java Script, SDLC, Agile, DB2, QTP, HP ALM, Quality Center 8, Regression, Functional, Integration, System Testing and User Acceptance Testing, XML, UNIX Shell Scripting, (MS Access, MS Excel PowerPoint Outlook)

Confidential, Detroit, MI

QA Tester

Responsibilities:

• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Tested the data and data integrity among various sources and targets
• Designed, developed stored procedures using PL/SQL and tuned SQL queries for better performance.
• Performed End-to-End testing manually.
• Extensively involved in testing the application in Manual Testing environment.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Involved in automation of test cases using QTP. Did functional testing using QTP
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Written complex SQL queries for validating the data stored in different database tables.
• Involved in Database testing by writing & executing SQL & PLSQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing.
• Also manually tested the application for each system build, for both negative and positive testing.
• Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.

Environment: HP QTP PL/SQL, Java Script, SQL Server 2005/2008, Unix Shell Scripting, TOAD 9.2, MVS, VSAM Files, Oracle 9.2 and 10G, Teradata V2R6, HP Quality Center 8, Regression, Functional, Integration, System Testing and User Acceptance Testing (MS Access, MS Excel PowerPoint Outlook)