SUMMARY:

• Around 8+ years of experience in testing software systems as QA Analyst.
• Participated and worked in various stages of software testing including Functional, Integration, End - to-End, and Regression testing.
• Performed various Black Box testing - Functional testing, Stress testing, User Acceptance Testing (UAT), System testing, Smoke testing, Load testing, and Usability testing.
• Proven experience creating Test Plans, Test Scenarios, and Test Cases.
• Experience working with Client/Server and Web based systems developed using WinForms, ASP.NET, and J2EE.
• Extensive experience in testing database objects Stored Procedures, Views, and Triggers using complex queries in T-SQL and PL/SQL for SQL Server and Oracle databases.
• Experience testing ETL processes in the data warehouse (DW) environment. Tested data load, extract SSIS packages and validated various transform rules.
• Experience working with various testing tools - Control-M, Jira, PR tracker, Test Director 7.x -8.x, HP Quality Center v9.0 and QTP v6.x - v8.x.
• Ability to adapt to changing requirements, prioritize tasks and manage time efficiently.
• Excellent people and communications skills.

TECHNICAL SKILLS:

Test Tools: Test Director v8.0, Quality Center v9.0, and QTP 6.5-8.0.

Relational Database: SQL Server v7.0, 2000, 2005, 2008, Oracle 8i/9i/10g, DB2, and Access.

Languages: C, Java, XML, ASP.NET, VB 6.0, VB.NET, T-SQL, PL/SQL, SSIS, and DTS.

Operating Systems: Windows XP/NT, Windows 2000/2003 Workstation and Servers, NT4.0 Workstation and Server, Windows 95, 98 MS-DOS, and UNIX.

Software Applications: MS Office Professional Suite 97/2000/XP, MS Project, Internet Explorer, Mozilla Firefox, and Visio 2000.

PROFESSIONAL EXPERIENCE:

Confidential, Newton, MA

QA Analyst

Responsibilities:

• Primarily responsible for testing the functionality of College Savings (529 plan) and Retirement Saving plans for SSRP, Oregon and Illinois state plans.
• Created Test matrix, Test plans, performed front-end and back-end testing. Performed feed testing using Control-M and used Jira and PR tracker for bug tracking.
• Performed data validation using PL\SQL (Oracle 10g) for validating Employer and Employee modules which includes Payroll, Web registration, Secure login, Opt-in/Opt-out, Account overview, Manage contributions, Investments and Withdrawals.
• Performed validation of quarterly statements, validated beginning/ending balances, contributions, investments, withdrawals, beneficiary detail against back-end tables. Written various PL\SQL queries to validate the statements.
• Performed regression testing on the newly added features to projects to ensure there are no breaking changes. Responsible for final production release testing performed before the applications are released to production.
• Collaborated with Business Analysts and Business Owners to gather requirements and worked with Developers to ensure requirements are implemented per specification. Responsible to final summary report on the projects to get approval from the Business Owners.
• Participated in company provided Agile training.

Technology: Putty, SQL Developer, Oracle 10g, Jira, PR tracker, Control-M.

Confidential, Wellesley, MA

QA Analyst

Responsibilities:

• Primarily responsible for testing the features and workflows of the Accounting and Data Management components of Eagle STAR and Eagle PACE modules Fixed Income, Mutual Funds, Brokerage, Insurance, and Data Analytics using the internally developed automation systems.
• Performed manual testing as part of the ad-hoc testing on failed tests on the regression environments and tracked and submitted defects found during the testing to the bug tracker.
• Developed new data exporters, message streams and rules, and configured event packages, report schedules for the nightly automation cycles. Also Developed and distributed multiple SQL Server (SQL Server 2008) and Oracle (Oracle 10g) DB scripts which are used routinely by the user community.
• Captured, analyzed, compared nightly cycle results with the baseline test cases, and disseminated the discrepancies to the Development, BA, and QA teams for the review in a timely manner.
• Participated in many cross-team trainings on the new product enhancements and worked collaboratively with the offshore teams in order to transfer the details of the enhancement knowledge diligently without any delay.
• Prepared monthly time based ‘QA test case metrics for all component layers of the product (i.e., Accounting, Data Management, Performance, Enterprise, Information Delivery) in order to provide the management a required information on how new features been incorporated to the software for a given release and to provide the approximate measure of the testing is taking place.

Technology: SQL Server 2008, Oracle 10g, Eagle STAR Tools (Message Center, Scheduler), PACE Advance Report and HP Quality Center v9.0.

Confidential, Boston, MA

QA Analyst

Responsibilities:

• Tested order management module of the E-commerce website, by creating and executing manual test cases.
• Applied boundary value analysis and equivalence partitioning techniques in user interface testing.
• Performed back-end testing on various database objects Stored Procedures, Functions, Views and Triggers in Oracle database using PL/SQL.
• Created 50+ repeatable automated Test Scripts using QTP for regression testing the business functionality.
• Involved in System testing and performed various types of tests including Integration, Functionality, Regression, and GUI Testing.
• Participated in the User Acceptance Testing (UAT) and worked with user groups to identify and report defects found in this phase.
• Worked with operations and DBA teams in setting up QA and UAT environments.
• Worked with developers to test fixes for the defects found during testing.
• Reported the daily and weekly testing progress to the QA manager.

Technology: Oracle 8i, Java, J2EE, Quick Test Professional 8.0, Test Director 7.6.

Confidential, Virginia Beach, VA

System Tester

Responsibilities:

• Experience with test case development, preparing requirement traceability matrix, test execution and identifying automation candidates.
• Report application issues/defects, analyze them and work with cross-business teams in driving the issues to resolution
• Instrumental in creation and execution of regression suite for on-going dev/enhancement efforts of the core software applications that had dynamically changing requirements.
• Identified critical QA/test paths, defined entry/exit criteria for a given application-under-test based on intuitive and adaptive knowledge of custom web applications.
• Analyzed, prioritized and communicated defects effectively between cross functional teams for timely resolution.
• Tested the quotes module by issuing, adjusting and canceling quotes for before and after effective dates.
• Tested claims process modules by creating and opening claims, issuing payment and adjusting claim for both Auto and Property losses for P & C Application.
• Performed back-end testing by running complex queries (Inner and Outer joins) against database.
• Tested DTS packages used for loaded data into the database.

Environment: Test Director 7.6, C++, IMS, JCL, JSP, DB2, T-SQL, DTS, SQL Server 2000.