SUMMARY:

• 7+ years software QA tester with full system development life cycle experience, including designing, developing and implementing test plans, test cases and test processes fueling swift corrective actions, significant cost savings and fault - free audits.
• Have good knowledge in testing applications in various industry domains like Healthcare, Banking, Telecommunication and retail.
• Experienced in defining Testing Methodologies, Designing Test Plans and Test Cases, Verifying and Validating Web based e-Commerce applications and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC) methodologies such as Waterfall and Agile (Scrum).
• Experience in coordinating and mentoring offshore and onsite QA .
• Experience in setting up the test environment, installations and configuration.
• Expertise in Manual and Automated testing of various Web based applications.
• Created Test Plans, Test Cases, Test Procedures and Test Script .
• Strong expertise in establishing QA policies, procedures, strategies and developing appropriate process to ensure the quality of product.
• Expert in web technologies like HTML and XML.
• Experienced in creating Requirement Traceability Matrix to ensure comprehensive test coverage of requirements.
• Well versed in automation testing tools such as Quick Test Professional (QTP), Load Runner and Selenium .
• Developing and Maintaining Test Scripts, analyzing bugs and interacting with development team members in fixing the defects.
• Knowledge of Defect/Bug tracking system with the use of tools like HP Quality Center and Bugzilla.
• Experience in importing/ exporting the Scripts /data into QC by using MS Word and Excel Add-ins.
• Strong working experience in various databases such as Oracle, MySQL, SQL Server and MS Access.
• Strong knowledge and experience in constructing and executing queries in PL/SQL .Working experience in ETL projects. Validation of every step of ETL process.
• Experience in using JOINs, database views, Sequence, Indices, performance tuning.
• Good understanding and knowledge of UNIX commands.
• Experience in UNIX shell scripting, job scheduling using Crontab.
• Extensive experience in Web applications, Web services and Web methods . (Middle ware Testing) SOA
• Vast experience in different testing methods such as Functional, System, Regression, Integration, Performance, Security, Positive, Negative, End to End, UAT and Load testing.
• Worked with Developers, Business Analyst and Project manager to test and document new product and new product enhancements.
• Exceptional analytical, trouble shooting and problem solving skills .
• Excellent Analytical, Decision-Making and Organizational Skills coupled with good co-ordination, communication and interpersonal skills describing a committed Team Player with an ability to handle/organize multiple projects simultaneously.

TECHNICAL SKILLS:

Packages: MS Office (Word, Excel (VBA), Access, PowerPoint, Visio, Front Page)

Environment: MS-DOS, LINUX, Windows NT/9X/2000/XP, UNIX.

Databases: SQL Server 2000, MS Access, Oracle 8i/9i/10g/11g

Languages: HTML,SQL,SAS,PL/SQL, Shell Scripts, XML, DHTML, C/C++, Java, VBA, VB.Net

Testing Tools: HP Quality Center 9.0/11.0 (ALM), QTP 9.0, Perfecto(Mobile Testing), SOAP UI(Service Testing), Zeenyx Ascential Test (Automation Testing)

Tools: TOAD, SQL*Loader, SQL*PLUS, PL/SQL Developer, Business Objects 3.1 and Cognos reports

PROFESSIONAL EXPERIENCE:

Confidential

Pega and database Tester

Responsibilities:

• Attended daily standup meeting within team. Part of various Scrum ceremonies like Backlog Grooming,Backlog refinement, Confidential Retrospective.
• Attended Confidential demo sessions by Business Analysts.
• Worked closely with Product owners,Scrum masters,scrum coaches and development team.
• Project strictly adheres to SaFe Agile framework.
• Participated in PI event,planning for the next five consecutive sprints.
• Experience in creating and modifying stories in JIRA.
• Involved in regression testing every two weeks as each Confidential lasts for two weeks.
• Functional testing of Pega application, running on Pega 7 platform.
• Database testing using Bethic Golden 6 client for Oracle database.
• SOA testing using Swagger UI.
• Web services testing using Soap UI 5.0
• Involved in automating existing regression test cases.
• Writing automation scripts in Soap UI.
• Creating test cases in qTest, approving them and thereby executing them.
• Working on functional and technical JIRAs by providing evidence in the form of attached screenshots.

Tools: - Benthic Golden6, Pega7,Soap UI 5.0.0,qTest,JIRA

Confidential

ETL Tester

Responsibilities:

• Developed Test Plans, test scripts and executed the test scripts for Confidential - Enterprise Data warehouse Project.
• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)
• Defects identified in testing environment are communicated to the developers using Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Worked on issues with migration of Data from development to QA-Test Environment
• Extensively tested several Business Objects Reports - Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.

Environment: Oracle 10g/11g, Informatica Power Center 8.1(Power Center Designer, workflow manager, workflow monitor), SAP Business Objects 3.1 - Crystal Reports and Dashboard, HP QC 9.0/11.0, SQL developer, TOAD, SQL and PL/SQL, Web Services.

Confidential

ETL Tester

Responsibilities:-

• Attended Scrum meeting every day.
• Documented details of test plans, test cases and expected results in Test Director.
• Extensively documented Test Requirements and Test Plan using Test Director to track the stakeholders requested enhancements and changes.
• Created VB scripts, enhancing, and debugging the test case using QTP.
• Created test scripts using Automation tool QTP and checked the functionality of the application for every release.
• Used Synchronization, Call function, Parameterization, Checkpoints, Regular Expressions to enhance test affectivity also created reusable actions.
• Performed Smoke, Functional and Regression testing using QTP.
• Performed manual and automation tests on various modules using positive and negative scenario.
• Manually manipulate data directly from Oracle database using TOAD.
• Analyzed the end-to-end functionality by testing the application manually.
• Carried out security tests to check that only valid users could access certain sections of the site.
• Writing and reviewing Manual test cases and customizing Test Director as needed.
• Performed Back End testing of the database by using SQL queries to verify data conversion and data repetition. Used Joins like Inner and Outer joins while testing from multiple tables.
• Analyzed test monitoring and take quick test control decisions by the Reports and Graphs using Test Director.
• Grouped Manual test cases in sets and scheduled them for execution using Test Director.
• Monitored test results, tracked defects and communicated them using Test Director.
• Actively participated in bug meetings with QA team and developers to discuss and resolve outstanding defects.

Environment: Windows XP, QTP 9.0, Test Director 8.0, Bugzilla, UNIX, TOAD, Oracle 9i/10g, MS-Excel.

Tools: - QC, Atlas Log, Oracle Pl/SQL developer, UI Testing, Performance Testing, CSS, HTML

Confidential

Retail Automation Tester

Responsibilities:

• Extensively involved in all phases of SDLC (Software development Life cycle) and follows Agile methodology.
• Worked on POS self check out / POS QA Testing was involved in setting of QA Test environment with simulated POS test environment.
• Involved in Preliminary discussions of the Project with the Core Team according to Business Requirement Document.
• Prepared test plans and test cases for manual and automated testing.
• Tested different functions of the POS system like scanning, payments and returns. Moreover, make sure that the system met the requirements and expectations.
• Developed the test cases according to requirement.
• Responsibilities of checking of data in database by writing and executing SQL statements and UAT on NGPOS Environment consist of MPOS, KIOSK, PHARMACY and PHOTO Ecommerce testing.
• Validated Inbuilt CMS tool along with web application on different browsers.
• Extensively worked on Web Service testing using SOAPUI.
• Involved in Functional, Regression and Smoke testing.
• Prepared the traceability matrices to fill the gap between the requirements and the test cases covered.
• Used VB Scripting in QTP, Generated test results using QTP and analyzed Actual Result and Expected result.
• Developed data driven scripts in Quick Test Professional and executed scripts.
• Used checkpoints to check the functionality in QTP.
• Used synchronization, call function, parameterization, and reusable actions to enhance test affectivity.
• Interacted with developers and Managers to identify and resolve technical issues while performing automation testing using Selenium in Twist.
• Used Firefox browser to installed Selenium IDE to test the Catalina test portal BPT server.
• Wrote SQL queries for searching, creating and updating test data.
• Interacted with DBA\'s, Developers, Systems Engineers and Network Engineers during testing and isolated bottlenecks at different levels.
• Performed Load testing by bombarding the server with users to test the performance of the application under stress conditions using Load Runner.
• Managed and executed test cases and logged defects in defect reporting tool using Bugzilla.
• Provided status reports to Project Manager.
• Interacted with developers for resolving the defects and setting the priorities.

Environment: Quality Center 10, QTP 10, Selenium IDE 1.7.2, Load Runner 7.8, UNIX, Java, J2ee Windows XP, IE, Firefox, Mozilla, SQL Server, Bugzilla, Confidential in house tools Jump server .

Tools: /Technology: - SOAP UI, Java, XML, Zeenyx AscentialTest, Zee Language, Java, AS400, Version One (Defect Tracker)

Confidential

Functional Tester

Responsibilities:

• Complete set-up of Jboss server in Solaris box
• Involved in the deployment of code in the server using JBoss and Tomcat and troubleshooting
• LDAP testing
• Developed and maintained Scripts using SQL *PLUS to test Data Integrity
• Designing test cases and test data preparation.
• Execution of test scripts
• Tested programs to ensure proper functionality doing unit testing.
• Logging and tracking defects.

Tools: - Oracle10g/11g,Bugzilla, LDAP studio, TOAD, Shell Script, SQL*Loader and Unix (Sun Solaris 5.9), SVN, CSS,HTML, Java, Windows 2000

Confidential

Fusion Application tester

Responsibilities:

• Perform Functional Testing on banking MasterCard application in multi-channel like mobile, desktop and tablet
• To perform functional end to end and regression testing on a banking application on a multi-channel /multiple device to make sure the application should work in any devices (Desktop, Mobile, Tablet) and any OS (android, iOS)
• Involved in development and implementation of Test cases, Test plans, Test data and Test scripts
• Involved in performing various kinds of testing like Unit Testing, System testing, Integration testing, Regression testing etc on PDA (Personal Digital Assistant) & Laptops and Synced the PDA & Laptops to host.
• Involved in writing of Modification Reports for Errors Identified in Testing and clearly communicate with development via defect tracking database (Clarify).

Environment: Clarify, VC++, Oracle 8.0, Windows 2000

Tools: - Perfecto, Mobile Testing, QC, FDR, IBS