OBJECTIVE

• To utilize my knowledge and expertise for the betterment of existing QA processes and advance my career as a QA Tester/Analyst in a leading IT company with a scope for professional development.

SUMMARY

• 7+ years of IT experience working with clients like Confidential, Confidential & Confidential, Confidential, Confidential and Confidential Group Inc.
• 7+ years of experience in Quality Assurance testing of Client/Server, Web, GUI and Mainframe based applications on Windows platforms.
• Extensive knowledge and experience in all phases of Software Development Life Cycle from initiation to deployment and support.
• Vast experience in BI Datawarehousing, Telecommunications, Payroll, Banking, Financial (Investments) and Pharmacy domains.
• Maintains all Process Documents and Quality Center templates.
• Experience in performing Functional Readiness Review, Business Requirement Review and Test Readiness Review (TRR) based on the requirements.
• Expertise in analysing Business/System Requirement documents, Design, Development and execution Test Strategies, Test Plans and Test Cases.
• Extensive experience in Manual and Automation Testing using Black box, White box and Grey box Methodologies.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back - end testing.
• Excellent expertise in writing SQL sub queries, JOINS, CTEs, views and triggers for developing database system applications.
• Experience in Datawarehouse Testing using various ETL Tools like Informatica and SSIS.
• Expertise in developing and maintaining Test Metrics to ensure the quality of the software.
• Strong experience in Automation tools such as QTP 8.2/9.0/9.2/9.5 , TestDirector7.5/7.8 and Quality Center 9.0.
• Excellent command over bug tracking tools such as Visual studio 2012/2010/2008 (VSTF), Test Director, Quality Center, PVCS Tracker, Rational Clear Quest.
• Expertise Confidential online panel and batch program testing in Mainframe.
• Creation and modification of JCLs based on the requirement while testing.
• Expertise in writing and enhancing automated scripts for Regression, Load and Performance testing.
• Strong Experience in Insurance Enrollment and Billing System Testing.
• Ability to perform tasks effectively under pressure and great Confidential multi-tasking.
• Individual with great interpersonal and communication skills.
• Great team player and able to work independently without supervision.
• Experience in driving meetings, Conferences and daily stand-ups with Test, Dev and Business teams.

TECHNICAL SKILLS

Operating system: MS-DOS, Windows 2000/NT/2003/2008 server, XP

Languages: C, C++, XML, COBOL, SQL, Confidential -SQL and PL/SQL

RDBMS: SQL Server 2012/2008/2005/2000 , Oracle11g/8i/9i, DB2, MS Access

GUI / Front-End: Visual Basic 4.0/5.0, JAVA and C# .NET Framework, Share Point, ColdFusion

Scripting Languages: VB Script, Java Script

Testing Tools: QTP 8.2\9.0\9.2, Test Director 8.0, QC 8.2/9.0

ETL Tools: SSIS, Informatica 9.1.0

OLAP Tools: SSAS

Defect Tracking: VSTF 2012/2010/2008 , TestDirector8.0, QC 8.2/9.0, PVCS Tracker7.0, CVS, Bugzilla and Clear Quest

SCM: VSS, CVS and Clear case

Mainframe Skills: TSO/ISPF, File-Aid, MVS/ESA, OS/390, JCL, VSAM, Terminal Emulator

PROFESSIONAL EXPERIENCE

SQL BI Tester

Confidential, Issaquah, WA

Responsibilities:

• Attended the Requirements reviews (BRD), Design reviews (FSD), Code reviews (TSD) to understand the overall process flow and Source to Target Mappings, identify issue and suggest modification to conform to standards.
• Worked with Installation of SQL server and creating database.
• Responsible for Functional, Data Integrity, and System testing.
• Requirement analysis, reviewing the functional specifications and technical specifications documents, test scenarios identification, test cases preparation and documentation, reviewing the test cases, test case execution, defect management, taking the bottom line responsibility for the project
• Tested various Transformations for data stage on Acquisition, Integration, and Distribution to meet the Business rules and Technical requirements using SQL.
• Prepared test data to verify the functionality of the Data stage.
• Used VSTF to maintain Test Scenarios, Test execution and Logging the defect.
• Worked with dynamic SQL and CDC.
• Expertise in retrieving the data stored in various tables by using Joins, Views and complex queries.
• Created Informatica Workflows to as ETL Tool to load the Data Vault Tables and created the work flow dependencies as per the requirement and document the dependencies.
• Performed data transfers using BCP, Export/Import and BULK INSERT utilities.

Environment: Confidential -SQL, MS SQL Server 2008 R2/2012, Visual Studio 2010/2012, VSTF (Visual Studio Team Foundation Server), XML, Erwin.

Sr. Test Engineer

Confidential, St. Louis, MO

Responsibilities:

• Involved in writing Test Plan, created Test cases and scenarios for the affected functionalities as per the business requirements.
• Created and published Requirement Traceability Matrices to ensure test coverage so as to keep a check on all requirements being covered during testing.
• Working closely with the Quality Manager in planning, coordination and implementing the testing methodology.
• Attending Test Planning sessions, enhancement and release meetings with the business teams before every release so as to understand the changes those are to be tested in the release.
• Writing the SQL queries to retrieve, update, insert or delete the data stored across multiple tables using SQL Server 2008 while setting up test environment.
• Expertise in retrieving the data stored in various tables by using Joins, Views and complex queries.
• Using SSIS for extracting and integrating data while preparing test data.
• Involved in Datawarehouse testing from Acquisition to Distribution phases.
• Maintaining the test cases, reporting the defects in VSTF 2008 and Track bugs in triages.
• Interacting with developers, discussing the Specifications provided by the Analysts and resolve the discrepancies in the application.
• Involving in End-End Testing, System Testing and Regression Testing.
• Responsible for confirming the test scope with TP&E, the PMO and the person who generated the estimate workbook
• Ensuring ETE metrics are distributed daily by the TP&E team. Reviewed accuracy and ensure any explanations for mitigation are clearly documented prior to sending to the PTL or client.
• Involved in determining areas that CTS application must rely on non CTS teams in order to successfully execute ETE testing includes Test Case Execution, Test Case Validation, Environment set up as determined by the CTS environment & TP&E team and Data set up as determined by the CTS data team.
• Attending daily stand-ups/weekly meetings and preparing weekly status report.

Environment: SQL Server 2008, QTP 9.2, VSTF 2008, MS Office 2007, HTML, Crystal Reports, VSS, JavaScript. QC 9.2.

Sr. QA Analyst

Confidential, Tulsa, OK

Responsibilities:

• Involved in writing Test Plan, created Test cases and scenarios in QC for the affected functionalities within F&E that were in accordance with the business requirements.
• Working closely with the Quality Manager in planning, coordination and implementing the testing methodology.
• Attending Test Planning sessions, enhancement and release meetings with the business teams before every release so as to understand the changes those are to be tested in the release.
• Testing the online Terminal Emulator 3270 panels.
• Batch program testing, editing the File-Aid to update the input data, submitting the jobs and validating the output file against the TE 3270.
• Running the Data Queries on the Ideal database to validate the output data against the TE3270 online data.
• Writing the DML queries to retrieve, update, insert and delete the data stored across multiple tables using SQL Server 2008
• Expertise in retrieving the data stored in various tables by using JOINS
• Executing the test cases, reporting the defects in QC9.0.
• Interacting with developers, discussing the Specifications provided by the Analysts and also the changes and the discrepancies in the application.
• Involving in End-End Testing, System Testing, IST Testing and Co-Op testing.
• Providing support to the user groups as and when required.
• Attending daily Checkpoint calls, defect meetings with the developers and the team to clarify and discuss all the defects that are found during testing.
• Making sure the smooth closure of the defects and performing Regression testing
• Automated F&E functionality using QTP9.0
• Used descriptive programming to automate the test scripts
• Running automated scripts as and when a new patch is released to QA to ensure nothing is broken wrto functionality
• Validating the test results and fixing the scripts if any failures
• Updating the metrics in QC for the higher management to review the status of the project and performance of the team.
• Create and publish Requirement Traceability Matrices so as to keep a check on all requirements being covered during testing

Environment: TSO, ISPF, SuperCE Utility, File-Aid, JCL, SQL Server 2008, QC9.0, QTP9.2, VBScript, UNIX, Confidential Office 2007 and IE.

Sr. QA Analyst

Confidential, CO

Responsibilities:

• Requirements gathering, Analysis & Design, Coordination & Development of the enhancements using C#, ASP.Net.
• Performed Manual and Automated Testing of the C#, .Net application using numerous Test Scripts.
• Involved in tracking, reviewing, analyzing and comparing bugs using Quality Center.
• Performed Functional Readiness Review, Business Requirement Review and Test Readiness Review (TRR) based on the requirements.
• Developed Test Scenarios, High Level Test Cases and Detailed Level Test cases based on the SOBR.
• Developed detailed Test Scenarios for the entire application to establish Test Cases.
• Created detailed Test Plans, Test Cases for the application under test.
• Manually performed Back-End testing by writing SQL queries and Confidential -SQL.
• Vigorously performed Manual testing and Backend testing on all different modules of the application.
• Worked closely with developers in analyzing test results and defining different test approaches specific to the Application Under Test (AUT)
• Driven meetings, Conferences and daily stand-ups with Test, Dev teams and management.

Environment: Windows XP, C#, ASP.NET, CSS, JavaScript .NET Framework 3.5, SQL Server 2005, Mercury Quality Center9.2, MS Office 2007.

QA Tester / Analyst

Confidential, Herndon, VA

Responsibilities:

• Involved in writing Test Plan and created Test cases and scenarios for the various modules within DASH that were in accordance with the business requirements.
• I was responsible for writing and updating test plan documents for every release.
• Worked closely with the project Manager in planning, coordination and implementing methodology.
• Attended and led enhancement and release meetings with the business teams before every release so as to understand the changes that were to be tested in that release
• Conducted daily defect meetings with the developers and the business to clarify and discuss all the defects that were found during testing updated the daily metrics in our SharePoint for the higher management to review the progress and performance of the team
• Created and published Requirement Traceability Matrices so as to keep a check on all requirements being covered during testing.
• Automating the manual test cases which covers the end-to-end scenarios of the DASH application in VBScript using QTP 8.2
• Import automated tests into Quality Center, setting up the Test lab for scripts execution
• Executing the Automated test scripts based on testing plan, validating the test results and fixing the failed scripts if any.
• Interacting with developers, discussing the Specifications provided by the Analysts and also the changes and the discrepancies in the application.
• Detecting and reporting the bugs to Onsite Team\development team using DASH

Environment: Windows XP, QTP 9, QC 9, Acrobat PDF and SQL Server 2000

QA Tester

Confidential, Branchville, NJ

Responsibilities:

• Verification/Check points such as Window/object GUI checkpoints; Bitmap checkpoints, Text checkpoints, Database checkpoints and Synchronization points were implemented using Win Runner.
• Good understanding of Derivatives, Risk, Collateral, Trading and Options/Futures.
• Executed test cases manually. Compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution.
• Executed automated test scripts using QTP for Regression testing.
• Performed backend testing on Oracle, executed various DDL and DML statement.
• Involved in testing ETL applications for the warehouse according to Functional specifications using Informatica, Oracle PL/SQL and SQL
• Extensively involved in test backend applications by writing SQL, PL/SQL and Shell Scripting.
• Worked on reviewing requirements and writing/executing test plans and test cases.
• Responsible for Back end validation using SQL queries.
• Validated tests by crosschecking data in backend on Oracle using SQL Queries.
• Analyze the Business Requirement Document (BRD), Functional Specification Documents to prepare Test Cases based on Test Plans and Use case documents.
• Outlined the test case and provided Defect metrics during the test phases.
• Participated in testing various patient safety related issue.
• Creating defects, providing defect descriptions by using QC.

Environment: QTP, QC, HP Load Runner, Test Director, Win Runner, Designer, Web logic, Oracle, SQL, PL/SQL, UNIX Shell Scripts, Linux, Windows, Solaris, Java, Test Director, MS Access, .Net

QA Tester

Confidential

Responsibilities:

• Involved in writing test cases and in manual testing.
• Involved in the maintenance of the Bug Tracking and reporting system.
• Involved in Validation and Verification.
• Used RUP for collecting systems information
• Involved in testing of data entry screens and transaction screens.
• Involved in manually testing the Functionality of the item detail and company detail modules.
• Documented the Test Cases, Test Procedures, Test Scripts and Test Metrics.
• Performed acceptance and regression testing on several builds of the application using Win Runner.
• Used PL/SQL extensively for data integrity testing.
• Involved in bug reporting and testing enhancement requests after fixes.

Environment: Manual Testing, HTML, MS Office 2000, Excel, Outlook, SQL, and Windows2000.