Skills

• SQL querying knowledge of SQL Server 2005 and above.
• SQL querying knowledge of Oracle 10g and above.
• Ability to write complex SQL scripts to accomplish data conversion/validation testing
• Complete working knowledge of SDLC and STLC lifecycle modelt
• Basic knowledge of performance tuning of long - running SQL queries with Oracle SQL Server
• Experience developing and documenting analyses of business needs
• Experience with test plans and test cases.
• Produce reports of testing results.
• Development of recommendations for fixes and database performance and tuning optimizations to programmers
• Development and execution of automated test scripts for regression testing and retesting
• Experience in Windows or Linux
• Experience in automating data validation processes in similar data conversion projects
• Experience with SharePoint
• Experience with Microsoft Project
• Experience with scripting procedures/languages to automate and speed up project tasks

Education Certifications:

Confidential

Sr. QA Analyst

Responsibilities:

• Involved in QA life cycle which includes Designing, development and Execution of the entire QA Process and documentation of Test Plans, Test Scenarios and Test Cases.
• Participated in Walk through meetings with development, Business and other QA Teams
• Participated in Daily Status update and defect triage meetings.
• Followed up with standard software testing life cycle STLC to perform different types of testing for the projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Participated to develop automation scripts in QTP to automate smoke and regression testing.
• Used Quality center to execute automation scripts in batch mode or unattended mode.
• Enhanced the scripts in QTP by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests.
• Defined the Test Engagement Process for new application launch and maintenance releases.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.
• Performed backend database testing by writing SQL in SQL Developer Studio to verify data integrity.
• Performed Manual Testing and automated test scenarios for GUI, Functionality, Boundary, Security and Regression testing using QTP.
• Experience in writing Data Driven Test scripts in Quick Test Professional from scratch by hand scripting to make the best use of the native functions and reusable functions
• Tested bug fixes and performed extensive Regression Testing on each test cycle

Environment: .Net, QTP 10, VB SCRIPT, SQL, Rational Clear Quest, JIRA, SQL Server 2005, MS-Excel, MS-Visio, SDLC.

Confidential

QA Lead Tester

Responsibilities:

• Involved in development of Test Strategy and Test Plans to ensure that test cases reflect user needs for the Functional, User Interface, Performance, Usability and User Acceptance Testing requirements.
• Review requirements of functionalities requirements and provide inputs for improvements, removing ambiguity, reduce redundancy/duplicate requirements, etc.
• Create Requirement Traceability Matrix RTM to track requirements and ensure test coverage
• Creating maintaining test scenarios in QC
• Create/Document test plans from product requirements as well as from the change requests
• Identify test cases for automation Acceptance and Regression Test Cases
• Customized the QTP scripts using VB Scripting language based on the Business rules.
• Create and maintain test data in QC as well as other storage devices
• Execute automation test scripts from QTP and QC
• Used HP Quality Center as defect tracking tool
• Performed User Acceptance Test UAT on GUI screens to ensure that developers meet the user expectations
• Participating in scrum meetings, scrum calls on a daily basis
• Review enhanced LoadRunner scripts using Vugen when necessary to boost delayed projects from multiple location teams.
• Provide guidelines to Test engineers to Configure Performance Center test scenarios and Vuser according to the load model so as to take into affect the load distributed across various geographies

Environment: Java, QTP 10,LoadRunner, VB SCRIPT, Quality Center 10,Load Runner 10, JIRA, MS-Excel, ADOBE PDF, nvda, Wave, Section 508,IBM Req Pro.

Confidential

QA Analyst /Onsite Coordinator

Responsibilities:

• Coordinating with business users, development team and testing team on testing deliverables.
• Prepared Test Metrics on a weekly basis to know the status of the application.
• Involved in development of Test Strategy and Test Plans to ensure that test cases reflect user needs for the Functional, User Interface, Performance, Usability and User mAcceptance Testing requirements.
• Agile Methodology was followed for implementation of this Project.
• Involved Sprints meetings when planning, development and review the Test Cases Review with Agile/Scrum Methodology.
• Identifying various Test Data scenarios and collecting the user test data for different test regions Dev, Acceptance and QA from AS400 system before the execution starts.
• Created Test Plan and Test Design for Revenue Management and Pricing and Promotions.
• Agile Product portfolio management Integration of the project and Product information in the context of overall product development in order to streamline business processes the product portfolio and lifecycle.
• Followed managers' direction regarding project priorities, milestones and initiatives communication and test methodologies Scrum, Agile.
• Worked on Mercury's Quality Center 10, Load Runner 10 to map requirements to test cases, create test sets and carried out test runs manually as well as using automated test scripts.
• Developed implementing automation framework hybrid driven
• Create and maintain test data in QC as well as other storage devices
• Administrated and monitored the company's Siebel application
• Environment: Load Runner, Oracle 10g, PL, Siebel, Agile, Scrum, Sprint, PLM, MS-Excel, MS-Visio, SDLC, Soap, AS400, Web Services, XML.

Confidential

QA Analyst

Responsibilities:

• Worked on Fannie Mae Loan Appraisal forms1004, 1004C, 1004MC, 1025, 1073, 1075, 2055, 2090 and 2095 for all different formats ACI, AI READY and MISMO
• Diverse experience in Information Technology with emphasis on Verification, Validation, Quality Assurance, Testing, Development, and Project Management.
• Participated in analysis, design, coding, troubleshooting, filtering and passing of data, conversion, and specification development validation and coded integrity check.
• Worked on Web services thru QTP 10, created ACI, AI Ready and MISMO XML files through QTP.
• Parameterized input fields manually and automated testing QTP10.
• Involved in development of Test Strategy and Test Plans to ensure that test cases reflect user needs for the Functional, User Interface, Performance, Usability and User Acceptance Testing requirements.
• Worked on Mercury's Quality Center 10 and QTP 10 to map requirements to test cases, create test sets and carried out test runs manually as well as using automated test scripts.
• Prepared Test sets, all possible combinations of the data required to test each requirement and created Data Driven automated scripts using QTP.
• Involved in UAT testing of the application after the application was tested by the SIT team
• Active participation in decision making and Defect Tracking Meetings with Business Analysts, Developers and other stake holders
• Tested bug fixes and performed extensive Regression Testing on each test cycle
• Worked on Data Base Management and Data Migrations.
• Worked on Automation Framework to test the various customizations of the product.
• Reported various defects with complete description when there is a discrepancy between actual and expected results and tracked for their status using Defect tab of
• Conducted walkthroughs with Business Analysts and Developers to understand the functionality and the risk involved in the application and discuss about possible application changes or improvements which would increase the business value of the product
• Customized the QTP scripts using VB Scripting language based on the Business rules.
• Wrote and executed the SQL scripts using SQL Developer to validate test accounts status.
• Wrote extensive SQL queries to performed backend testing in different environments like System Testing and User Acceptance Testing.
• Used the requirement traceability matrix to compare the requirements with test cases while executing the scenarios.
• Regularly followed up with Development Team to discuss discrepancies identified during testingand performance tuning.
• Identified the different test scenarios and created appropriate test cases and test data to effectively test the application
• Performed Manual Testing and automated test scenarios for GUI, Functionality, Boundary, Security and Regression testing using QTP.
• Experience in writing Data Driven Test scripts in Quick Test Professional from scratch by hand scripting to make the best use of the native functions and reusable functions

Environment: Java, QTP 10, VB SCRIPT, Quality Center 10, XML SPY, Toad, Oracle 10g, PL/SQL, Rational Clear Quest, JIRA, MS-Excel, MS-Visio, MS SQL Server 2005, SDLC, PeopleSoft 9,ADOBE PDF, XML,SOAP,SOAPUI,WSDL.

Confidential

Test Lead

Responsibilities:

• Conduct Functionality test, Performance test and UAT with Product Test Group and report to Release Management
• Documented Master Test Plan and scheduled tasks over Microsoft Project Planner
• Creating and executing the script for Vusers using Empirix e-Load.
• Performed the Regression Testing with Empirix e-Tester to make sure that the bug has been fixed and the application is running properly
• Experience in Interface Testing Inbound and out Bound Interfaces.
• Executed process dependencies Shell Scripts and Ascential DataStage jobs in QA Environment.
• Used Data Conversion testing for the data migration.
• Worked with Microsoft Sharepoint for accessing the documents.
• Tested the mapping how it is behaving with different sources i.e. flat file data, RDBMS source.
• Extensive experience in comparing the data from back end and web based interface.
• Having good experience in Hippa 4010 EDI ANSI X12 835 and 837, 997, HIPPA 270/271,276/277 and Claims and Claims Adjudication.
• Worked in child support enforcement module and tested the functionality according to requirement
• Having good knowledge on HIPPA 834 and 820
• Verified ANSI X12 837, 270 based on Business Requirements and Conditions.
• Worked with e-load to record the load and performance on PeopleSoft financials 9.0.
• Tested PeopleSoft Query, Excel, spreadsheets and user process to automate significant post conversion updates to user data.
• Tested PeopleSoft grants billing to supplement their existing PS Financials 8.4.
• Validated DataStage transformations in Legacy and Target database by using SQL.
• Created and deployed several Reports and dashboards using Siebel platform.
• Evaluating application features and preparing several Test plans and Test cases, Test scripts for Unit, Integration, System, User Acceptance, Functional and Regression testing.
• Verified with Cognos 8.2 claims report, Hippa inbound and out bound reports like ANSI
• Tested Cognos reports like summarized, drill through reports, cross tab, list reports.
• Ran various SQL Scripts against Oracle Database using Toad.
• Written Sql queries to perform data validation and validate reports against the database.
• Interacted with child support business users and child welfare team.
• Tested with special requirements children's special health care services CSHCS .
• Tested the SQL, PL/SQL, stored procedures, triggers and cursors for implementing business rules and transformations.
• Migrated large volumes of data using DataStage from legacy systems to Staging and Target.
• Created Fields, Validation Rules, Page Layouts etc for various objects in Siebel.
• Written SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database
• Extensively used SQL queries against the Relational Databases to match the application output with the database output.
• Worked on SQL and PL/SQL and performed backend validations.
• Interacted with developers to explain problems where the application needs to modified, software bugs and re-tested the fixed issues
• Strong SDLC and Six Sigma solving skills and working individually.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Performed load testing for Web Applications and stress testing using e-Load from Empirix
• Created functional and integration test plans and test cases to validate business, system and operational requirements for a variety of applications
• Performed accessibility testing of web applications and ADA Testing with Section 508 of the US rehabilitation act thru WAVE and JAWS
• Documented through IBM-Clear Quest on the updates like passed Vusers and logon defects etc, Report and verify defect fixes.

Environment: Java,J2ee, e-Tester e-Load, Oracle ATS 8.5,Oracle Job Scheduler, Toad, Oracle 10g, PL/SQL, Rational Clear Quest, WebLogic, WAS, JCaps, MS-Excel, MS-Visio, Autosys, JCaps, Datastage7.5, Agile, SCRUMS,SPRINT PeopleSoft 9, Siebel, AS-one, Req Trace, Agile, Scrum, ADA Section 508 and sprint

Confidential

Test Analyst

Responsibilities:

• Created functional and integration test plans and test cases to validate business, system and operational requirements for a variety of applications
• Performed accessibility testing of web applications and ADA Testing with of the US rehabilitation act and the w3c's web content accessibility guidelines WCAG .
• Involved in Agile methodology SCRUMS AND SPRINT.
• Performed Data Validation Testing and manipulations using SQL.
• Conduct Functionality test, system Test for .NET application with Product Test Group and report to Release Management
• Involved in integration testing framework.
• Created Test Cases for functionality, integration, UAT and End- End testing in MS Word and Excel.
• Logging and tracking of application defects using PVCS Tracker.
• Collected Test Data according to the application and Database Model from Business users.
• Checked some of the screens and System testing and interface testing.
• Parameterized input fields manually and automated testing QTP.
• Performed the Regression Testing with QTP to make sure that the bug has been fixed and the application is running properly.
• Created the test plan and test cases for each and every module in Quality Center.
• Uploaded various test cases of the all phases of the FSP Project into Mercury Quality Center using MS Excel and MS Word.
• Tested Ad-hoc Cognos modeling reports.
• Tested the mapping how it is behaving with different sources i.e. flat file data, RDBMS source.
• Tested the lookup transformation with flat file to check whether related data is pulling or not
• Tested the mapping how it is behaving with different sources i.e. flat file data, RDBMS source.
• Created of Release Notes for application releases and each Build
• Documented all of test results for Independent Verification and Validation IV V Test Users.
• Strong PL/SQL programming for data population and table alterations, Oracle Performance tuning/SQL tuning and query optimization skills.
• Versed in System and Regression test for PeopleSoft HR and Campus Solutions
• Interacted with developers to explain where required, software bugs and re-tested the fixed issues.
• Used data conversion to protect the data and prevent data loss.
• Validated reports generated using Cognos and provided Target with key information needed to manage the business and report results.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.

Environment: Agile Methodology .NET, SQL Analyzer, MS SQL SERVER 2005, PVCS Tracker, QTP 9.2,, Quality Center QC, PVCS VM, Test Partner 5.4, PL/SQL, Oracle 10g, Mainframe, Jcl, Cognos, VISIO, MS Excel 2003, UNIX Shell Scripting, Informatica 8.X, ADA Section 508, WebSphere, WAVE.

Confidential

Sr. Tester

Responsibilities:

• Develop automated scripts to facilitate Regression testing on multiple releases
• Collected Test Data according to the application and Database Model from Business users.
• Creating and executing the script for Vusers using Load Runner.
• Performing both Job scheduling and Performance monitoring with Job Track
• Performed the Regression Testing with QTP to make sure that the bug has been fixed and the application is running properly
• Created functional and integration test plans and test cases to validate business, system and operational requirements for a variety of applications
• Configuring the applications with QTP, load runner and Quality Center
• Conduct Functionality test, Performance test and UAT for .NET application with Product Test Group and report to Release Management
• Conducted EDI Manual Testing on TIBCO BW Integration environment that meets Business Standards if any issues discussing with development team and Business Users.
• Involved in Functional Testing, System Testing, Regression Testing and Database Testing
• Created Test Cases for functionality, integration, UAT and End- End windows to UNIX testing in Quality Center.
• Facilitating test case reviews of documented formal test cases
• Generating Vusers to test the Load for the application.
• Toad is being used to extract data and make/edit changes to Oracle queries and table entries.
• Interacting with business users and development team.
• Performed User Acceptance Testing.

Environment: Java, QTP, Load Runner 7.8, DataStage, Toad, Oracle 9i,10g, SQL, Quality Center, TIBCO, MQ Series, BO XI, Windows XP, UNIX, IBM Main Frames, WebSphere, VB Script.

Confidential

Sr. Tester

Responsibilities:

• Conduct Functionality test, Performance test and UAT with Product Test Group and report to Release Management
• Parameterized input fields manually and automated.
• Creating and executing the script for Vusers using LoadRunner.
• Parameterized the script and data driven tests by WinRunner.
• Performed the Regression Testing with Empirix e-Tester to make sure that the bug has been fixed and the application is running properly
• Worked on SharePoint portals to share documents check in/check out Process.
• Widely used Informatica Workflow Manager to run as well as schedule the workflow.
• Observed the Mapping results using Workflow Monitor.
• Validated the data loading into the database tables is correct or not.
• Documented Master Test Plan and scheduled tasks over Microsoft Project Planner
• Strong SDLC and Six Sigma solving skills and working individually.
• Created functional and integration test plans and test cases to validate business, system and operational requirements for a variety of applications
• Documented through Quality Center on the updates like passed Vusers and logon defects etc, Report and verify defect fixes.

Environment: QTP, WinRunner, e- Test Suite 7.0, e-Tester e-Load, ASP.NET, Toad, Oracle9i, SQL, PL/SQL Quality Center, PVCS Tracker, Base SAS 8 and 9.1.3, SAS Connect, Macros, Proc and Data sets, Windows XP, Microsoft Office Outlook 2003, ETL-Informatica, Sql Server 2005, MS Excel 2003.

Confidential

Sr Tester

Responsibilities:

• Participated in the requirements analysis, use case preparation use case analysis and prototype development. Prepared the requirements documents for different builds.
• Involved in writing Servlets, JSP, pages for the different application UI pages
• Involved in designing the architecture using J2EE standards.
• Used Struts framework for implementing the MVC architecture.
• Conducted Load and Stress testing using LoadRunner.
• Written SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database
• Expertise Regression testing on each new builds of application.
• Used Custom tags in JSP pages based on the requirements.
• Planned and implemented various SQL, Stored Procedure and triggers in Oracle to implement business logic.

Environment: Java, JSP, Struts framework, Tiles, XML, JBOSS3.0, Servlets, JDBC, Tomcat, Ant, Junit, WinRunner, TestDirector, JavaScript, CVS, ORACLE 11i and SQL