SUMMARY

• Over 9 years of IT experience in testing of various Web - based, Object oriented, Client Server, and Multi Tier applications.
• 8 years of experience in RDBMS technologies like Oracle 8.x/9.x/10g/11g, DB 2 8.0/7.0/6.0 , MS SQL Server 2000/ 2005/2008/2008 r2, TeraData12.0, Sybase 10.X/12.X and MySQL 4.X.
• Thorough proficiency of testing Web-based and Windows based applications through manual testing as well as automated testing.
• Extensive experience in creating automation environment using Quick Test Professional, Quality Center, Selenium RC, Selenium Web driver, SOAPUI.
• Analyzed defects and worked with development team and users to ensure that all defects were resolved.
• Expertise in analyzing User Requirements Specifications (URS) and Functional Requirement Specifications (FRS) and creating test plans, test data, test scenarios, test cases, and test result documents.
• Extensively worked on Oracle TOAD for checking backend validations of the applications.
• Thorough understanding and working knowledge of implementation of QTP test frameworks.
• Expertise in performing different type of Testing: Functional Testing, System Testing, Integration Testing, Performance Testing, Stress Testing, White Box Testing, Grey Box Testing, Regression Testing, Sanity Testing and Adhoc Testing.
• Understanding the screen navigation (commands), file processing, using its utilities onAS/400.
• Extensively Validated the Migrations from Oracle to SQL Server, IBM DB2 to Teradata, SQL Server to MySQL and SQL Server to Oracle for Data Completeness, Data Transformation, Data Quality.
• Excellent knowledge of Agile & Scrum development environment, multiple web browsers, and automated testing suites.
• Proficiency in End-to-End Testing and backend validation using SQL.
• Experience in documenting the testing process using MS-Office tools including Word, Excel, Power Point, Outlook and MS-Project.
• Expert in Testing theEDW(Enterprise Data Warehouse) forData Completeness,Data Transformation, Data Quality,Performance and scalability.
• Background in Quality Control, Testing, and/or Validation of large-scale software development projects.
• Coordinator in creation and execution of QA and testing processes, test strategies and plans, bug documentation and regression, and bug tracking system development using automated tools.
• Exposed to ISO 9000, CMM methodologies.

TECHNICAL SKILLS

Testing Tools: QuickTestPro 8.2/9.0/9.2/10.0 , Load Runner 8.0/7.5, Selenium RC, Selenium Web driver, SOAPUI

Defect tracking tools: Test Director 8.0/7.6, Quality Center 10.0/10.2, Rational Clear Quest, Bugzilla, JIRA

Operating Systems: Windows-95/98/NT/2000/XP, MS-DOS, UNIX

Database: Oracle 8i, 9i, 10g, 11g, MS SQL Server 2000, 2005, 2008, 2008r2, IBM DB2, Teradata 12.0, MySQL 4.0

Browsers: Netscape, IE & AOL, Safari, Mozilla

GUI: Visual Basic .NET/6.0/5.0/6.0

Languages: C, C++, VB, HTML SQL-PL/SQL, XML

Version Control: Test Director, HP Quality Center, Jenkins and PVCS

Knowledge on Environments: JAVA, ASP.NET, Web Sphere 6.1, J2EE, JUNIT, Oracle, Solaris, Mainframe, MS SQL Server Management Studio

Reporting Tools: Cognos (Report, Query, Metric - Studio’s), SSRS, SSAS, Business Objects, Hyperion, OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. QA Tester

Responsibilities:

• Created Test Plans, Test Cases as guided by the development team.
• Reviewed Functional Requirement Specifications documents for the Test Plans and Test Cases.
• Created and ran automation scripts using HP UFT and found and logged defects regularly.
• Performed UI, Functional, Integration, Back-end, Regression, and Browser Compatibility Testing using Selenium Web driver.
• Report the defects and work with development team to fix issues.
• Report the overall performance status, and test summary to Project Manager.
• Performed production validation for the release in to production.
• Participated in JAD sessions with the Business and the IT Teams to ensure that everybody is on the same page.
• Conducted Web Meetings with team members to ensure that everybody is on the same page.
• Collected weekly status reports and updated the Project MPP accordingly to ensure that all deliverables are met on time and on schedule.
• Experience with testing of Service oriented architecture (SOA) and using SOAPUI.
• Hands on experience in Agile and Waterfall methodologies.
• Experience with version controls, source code tracking, build deployments using Jenkins.
• Performed Smoke, Integration, Functional, Regression, and System testing.
• Interacted with Business users and Technical team in providing clear solutions to requirements.
• Attended Daily Scrum Meeting and updated Issue tracker for the Team.
• Worked extensively with ALM suite components like Quality Center for Preparing Test cases, Executing and bug reporting.
• Used ALM’s Quality Center as a Defect Management Tool.
• Performed Cross Browser Testing for the Application in different versions of IE/Mozilla/Chrome/Safari.
• Involved in loading the flat files into DB2 Database and involved in writing SQL Queries.

Environment: HP UFT, HP ALM, JIRA 6.2, Jenkins, SOAP UI, VBScript, SQL Server 2005/2008/2008 r2, Windows95/98/NT/2000/XP and Internet Explorer.

Confidential, Rochester, NY

Sr. QA Analyst

Responsibilities:

• Responsible for gathering Business Requirements and Functional Requirements.
• Involved in writing and executing the Test Plan and test cases based on the business and functional requirements review sessions.
• Good understanding of the Electronic Medical Records EMR.
• Involved in Database testing manually by executing and writing SQL Queries.
• Tested the Data Validations in application using the SQL Queries in TOAD.
• Defect Reporting & Defect Tracking using Quality Center and good hands on experience with running automation scripts using Quick Test Professional.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center.
• Experience in web services testing using SOAPUI and good understanding of Service oriented architecture (SOA).
• Extensive experience of testing with Agile/Scrum process.
• Performed UI, Browser compatibility testing using Selenium Web driver.
• Involved in writing T-SQL Procedures Using SQL Server / Sybase Databases.
• Used Jenkins for source code tracking.
• Written SQL queries and executed them to validate the incremental ETL Loads.
• Validated Dashboard reports and dashboards as per the requirement of users.
• Familiar using Informatica mapping, session, workflow variables and parameters.
• Verified EDW (Enterprise Data warehouse) to make sure that all expected data is loaded.
• Performed various validations to make sure all data is transformed correctly according to business rules and/or design specifications.
• Written various stored Procedures to compare the record counts between source systems and Target systems after the migration.
• Verified the ETL mappings and boundaries of each field to find any database limitations.
• Used to attend the daily scrum meeting for daily discussions on defect resolution with the development team.
• Performed testing on workflows and SharePoint lists and document libraries.
• Assigned permissions on SharePoint lists and document libraries and verified security permissions.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: HP Quality Center, Quick Test Professional, Jenkins, Selenium Web driver, SOAPUI, Oracle 10g, Oracle 11g, TOAD 9.0, Aqua Data Studio 8.0.9, Sybase ASE 12/15, MKS Integrity Client, BMC Remedy System7.1, Sagent ETL tool V5, Informatica 8.6, UNIX, AUX, Secure 4.5 and PUTTY.

Confidential, Wall Street, NY

QA Specialist

Responsibilities:

• Utilized Quality Center for defect tracking and maintained defect repository and followed defect life cycle until it was closed.
• Developed a defect management process, which included my review of all documented bugs, evaluating bug priority, bug resource assignments and their due dates with Technology.
• Tested several complex reports generated by Cognos including Dashboard Summary Reports, Master Detailed, Drill Down and Score Cards.
• Testing automated test cases in different environments and Databases and Troubleshooting execution errors.
• Wrotetest cases as scenariosto cover business functionality and mapped them intoQC requirementsmodule with the project requirements.
• Used Selenium Web driver to test browser compatibility and correct functionality of the website.
• Migrated manual test cases intoHP Quality Center usingadd-in.
• Worked on SQL and PL/SQL and performed backend validations.
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.
• Written SQL queries and executed them to validate the incremental ETL Loads.
• Validated Dashboard reports and dashboards as per the requirement of users.
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled slowly changing dimension data.
• Administrated HP Quality Center for the project in Providing User Access and also Defined Work Flow in Quality Center for the Project.
• Coordinated Offshore with Onshore team for Defect Resolution.
• Performed backend testing on Oracle, executed various DDL and DML statement.
• Extensively worked on utilizing Dashboard Module in Quality Center for generating various reports and metrics to measure and track testing effort.
• Participated in defect resolutions meetings with Technology And Business Team.
• Attended Scrums, kick-off meetings, weekly Status meetings with the clients.

Environment: HP QTP, Selenium Web driver, HP Quality Center, Oracle 10g, Oracle 11g, Cognos 8.4, DataStage 8.X, TOAD, SQL, Web Sphere, VBScript, VI editor, Windows NT/2000/XP, J2EE platform technologies comprising, XML.

Confidential, NY

QA Analyst

Responsibilities:

• Executing automated functional tests using the Mercury Interactive Tools, defect tracking, problem resolution, and reporting test results.
• Develop and maintain the QA Test Strategy document and quality assurance project plan, test case reviews and defect management.
• Defect Management and Test Metrics.
• Expertise in creating Test plans and Test cases based on the application requirements.
• Used Quality Center for tracking the bugs and then reporting those defects to help developers to enhance the application.
• Interacted with development team and BA team to discuss possible situations related to the projects.
• Expertise in gathering the System, Functional and design requirements.
• Planned and executed Functional tests on the product. Created test cases and bug reports for the above tests using Quality Center.
• Wrotetest cases as scenariosto cover business functionality and mapped them intoQC requirementsmodule with the project requirements.
• Exported around2000 manual test casesintoQuality Center Test Planmodule and performedSmoke, Functionality, Integration,System, Data Conversiontesting.
• ValidatedOracle schemafor all static and dynamic tables manually while testing usingToad.
• Tested Application Manually as well as using Automation tools.
• Tested data warehouse ETL process using DataStage.
• Involved with ETL test data creation for all the ETL mapping rules.
• Tested several complex reports generated by Cognos including Dashboard Summary Reports, Master Detailed, Drill Down and Score Cards.
• Produced status report weekly, which providesDefect metricsand Test Execution percentage.
• Extensively worked on Quality Center for reporting the defects and maintaining Test plans.

Environment: HP Quick Test Professional (QTP) 9.5/8.2, HP Quality Center 9.2, Windows 2003, XML, VBScript, Web Services, Oracle 10g, Cognos 8.1, DataStage 7.5, TOAD, MS Office.

Confidential, Lansing, MI

QA Specialist

Responsibilities:

• Experienced in rational tools like Clear Case, Clear Quest and RQM.
• Conducted performance testing on the application using Load Runner.
• Developed Test scripts for Statewide and pilot releases.
• Performed Functional Testing and Back-end Testing using the database comparable results manually.
• Did complex data validation using SQL queries.
• Involved in batch testing using Oracle SQL Developer and Web Services Using SOAPUI.
• Experienced in creation of ALM activities.
• Prepared control files (both XML and text) for the BATCH testing.
• Experienced in AGILE methodology, keen interaction with BA’s, Developers and infrastructure team.
• Performed Integration, system, Regression, conversion testing along with the execution of the test scripts in RQM.
• Through knowledge about the test scenarios and would follow the updated documents from the CLEAR CASE.
• Tested Weblogic Web Services using SOAPUI.
• Tested SOA end-to-end, Service-by-service and Interface-by-Interface.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Used complex SQL queries to check the updated data in the Data base.
• Validated the SOAP output backend results by writing SQL queries.
• Responsible for testing Crystal Reports.
• Used Clear Quest for the defect validation.
• Design and execute Test Cases, Generate Test Scripts and Test scenarios using Vugen component in Mercury Load Runner.
• Load Runner was used to generate Vuser script to simulate multiple client interactions and emulate the behavior of hundreds of real users between the browser and the web server.
• Worked with the UAT team for the defect validation and reproducing them back in developer box.
• Experienced in the testing converted data.
• Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts for various scenarios.
• Experience in working independently and multi task without negative impact to timelines or quality.
• Strong Knowledge on the phases of Software Development Life Cycle (SDLC) Methodology.

Environment: MS SQL 2008/2005 SSRS, SSAS, Clear Quest, RQM, Oracle 9i, Load Runner 11, Perl and UNIX Shell Scripting, TOAD 7.0, Crystal Reports 2008, Rational Clear Case, SQL, PL/SQL.

Confidential, Baton Rouge, LA

QA Tester

Responsibilities:

• Responsible for gathering Business Requirements and Functional Requirements.
• Involved in writing and executing the Test Plan and test cases based on the business and functional requirements review sessions.
• Implemented Testing Methodologies, Framework, Procedures and Standards.
• Involved in all phases of SDLC and helped other team members when lagging.
• Worked with the Electronic health records/Electronic Medical records EMR/EHR.
• Developed and executed test cases for tracking billing and payment status and notifications, integration test cases for user/customer logins, user/customer registration and system test cases for billing at different intervals.
• Performed manual testing in all phases.
• Involved in writing and executing test cases, maintaining test plans and tracking and reporting defects using JIRA on daily basis.
• Involved in Database testing manually by executing and writing SQL Queries.
• Prepared Traceability Matrix to map requirements to test cases to ensure there were test case for all requirements.
• Tested the Data Validations in application using the SQL Queries in TOAD.
• Participated actively in team meetings with the developers for fixing the bugs.
• Responsible for preparing bug trend reports and posting to management.
• Responsible for sending weekly bug status reports to team.
• Used command to generate different detailslike reports using wily introscope.
• Executed DB SQL queries to confirm the data in the data base tables, which hold the customer information using Toad.
• Provided 24x7 support for both Production and Development Environments.
• Involved in opening tickets to both development and Infra teams in regards to any issues.

Environment: JIRA, Oracle 9i, MS SQL Server,Windows2000/ UNIX, HTML, SQL, Java, JSP, JDBC, Web Services.