SUMMARY:

• Over 8+ years of experience as Quality Assurance and Software Quality Assurance with hands on experience in Manual Testing, Automation Testing, Mobile Testing, Web based applications .
• Through understanding of software quality activities throughout the Software Development Life Cycle (SDLC).
• Extensive domain knowledge in diversified fields of Investment Banking, Retail and Technology, Insurance, Healthcare.
• Extensive experience in writing Test plans, Test cases and Test Execution.
• Extensively used Test management tools like Quality Center to create and update Test Cases, Test results and for reporting.
• Detailed understanding of QA methodology (Agile Methodology, Waterfall) to ensure quality control.
• Good experience in working as Team Lead.
• Good experience in developing test automation or combination of development and test experience using Selenium Webdriver, JUnit, or similar tools.
• Good experience in Abnitio, Cognos BI reporting.
• Good experience in working independently on complex reports.
• Good experience in defect tracking tools like Quality enter, JIRA.
• Proficient in different phases of Testing like Black Box Testing, White Box Testing, Functionality Testing, Unit Testing, Integration Testing, System Testing, Modular Testing, Backend Testing, Load Testing, Regression Testing, Performance Testing, Security Testing and User Acceptance testing.
• Extensively used Data warehouse ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide- ETL Solution using Informatica, Data stage and Ab initio .
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Experience in writing database queries, tuning, stored procedures, and triggers using SQL, PL/SQL and Unix scripting and automation.
• Unix scripting for automation and development and for reporting purpose.
• Excellent troubleshooting and debugging skills.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, PL/SQL, MS Access and Flat Files.
• Proficient in Oracle, PL/SQL Development Toad, PL/SQL Developer, Perl, UNIX.
• Experience working with Databases like Oracle, SQL Server, DB2 and MS Access.
• Understanding of QA testing methodologies and QA life cycle, white box, black box, functional and customer oriented testing.
• Hands on with various mobile applications including Android, Apple, RIM, BREW & WinM platforms on Blackberry, iPhones, Android & iPadsusing Device Anywhere Tool.
• Experienced in programming Database Objects like Tables, Stored Procedures, Views, Rules, Defaults, user defined data types and functions using oracle.
• Proficient in preparing the test plans, scripts and test cases by analysing Business Requirements and strong ability to Work closely with Development team and Business Analysts to analyse the test scenarios.
• Good experience in Automation applications on multiple platforms using HP-QTP.
• Good exposure to ETL testing with strong SQL skills.
• Good experience with writing and utilizing SQL queries for data verification in Oracle and other RDBMS.
• Extensive knowledge and experience in all stages of the Software Development Life Cycle (SDLC) beginning from initiation and definition to deployment and support.
• Ability to Effectively communicate testing activities and findings in oral and written formats with Excellent Analytical skills.
• Authorized to work in the US for any employer.

TECHNICAL PROFICIENCY:

Programming languages: C, C++, PL/SQL, Shell Script, Java, SQL.

GUI Tools: Visual Basic

Workflow Tools: MS-Visio, MS-Excel, MS-Word, MS-PowerPoint, MS-Outlook

Databases: Oracle, SQL Server, MS Access

Web technologies: HTML, XML, Java Script, VB Script, ASP

Operating systems: MS-DOS, Windows, UNIX, My Sql

ETL Tool: Informatica Power Center 9.1

Testing Tools: QTP / HP UFT, Selenium, H.P. Quality Center

Defect tracking tools: Quality Center, Jira, Test Director

PROFESSIONAL EXPERIENCE:

Confidential, NJ

QA /ETL TESTER

Responsibilities:

• Involved in all phases of Software Testing Life Cycle (STLC): Requirements & Design Review, Test Planning, Test Execution and Test Reporting.
• Worked in Agile project implementation, performing test coordination, task management.
• Defects are raised in the HP ALM for logging, tracking and reporting bugs in the application.
• Worked in Unix Command Center, writing scripts, logging files, setting up Unix based applications on the server.tions using HP LoadRunner.
• Assisted the project team in identifying and documenting Performance test requirements.
• Worked as a Lead, guided Team members in every aspects based on the requirement.
• Designed and developed performance testing scrips, functions, scenarios, processes for simple to
• Worked in Quality Assurance, testing stand-alone, Client Server and Web based applications using Manual Testing, HP ALM Explorer 11.5x/HP Quality Center on UNIX and Windows.
• Supported in setting up various Test Environments for Integration Testing, System Testing, User Acceptance Testing, Security Testing and Prod-Fix Testing with the goal of replicating the end users environment. Analyzing logs, database and source.
• Attended meetings, involved in QA planning, coordination and implementation of QA methodology.
• Entered and tracked defects using JIRA.
• Involved in creation Test cases Scenarios, Test case Execution and maintain defects using JIRA Tool.
• Tested web services based on data and functions by SOAPUI.
• Participated in daily SCRUM meetings and meetings involved in QA planning, coordination and implementation of QA methodology.
• Supported development team in finding the root cause of errors, by Provindng Status updated to management regarding project .
• Working as Lead for Juniors in the project, giving suggetions and solving the queries.
• Expertise in performing System Integration Testing (SIT), Business Acceptance Testing (BAT) and Performance Acceptance Testing (PAT).
• Backend testing through SQL queries and PL/SQL subprograms to support the test case results.
• Tested the PL/SQL procedures, functions, packages according to the requirements. Writing SQL Querries.
• Checking log files in UNIX for back end exceptions, and forwarding the same to developers.
• Working with offshore Team . Communicating team through email and phone calls.
• Validating the web server logs using UNIX commands and wrote Unix Shell Scripts to perform batch job.
• Participated in Daily defect calls to elaborate on newly raised defects and also to keep track on the status of existing defects.
• Wrote complex SQL queries to Oracle database for backend/frontend comparative analysis i.e., to check the correctness of the data stored in the database.
• Performed database testing to ensure the ETL process for the data being extracted from various sources (like Oracle tables, flat files, CSV files), transformed and loaded into the new Database through Informatica.
• Finalized and published Test Results in an incremental manner through thoroughly analyzed defect reports.

Environment: Selenium Web Driver, Java, Test NG, SOAPUI, Agile Methodology, HP ALM Explorer 11.5x, Oracle 11g, Unix, PL/SQL Microsoft Office 2010.

Confidential, NJ

Software QA Analyst

Responsibilities:

• Involved in all phases of Software Testing Life Cycle (STLC): Requirements & Design Review, Test Planning, Test Designing, Test Environment Setup, Test Execution and Test Reporting
• Worked in Agile project implementation, performing test coordination, task management.
• Checking log files in UNIX for back end exceptions, and forwarding the same to developers.
• Used HP ALM/Quality Center Explorer for developing Test Plan, Test Cases, Test Scripts, Test Case execution & Defect Tracking.
• Entered and tracked defects using JIRA.
• Performed regression testing on Manual scripts using HP ALM/Quality Center (QC).
• Performed Functional and Regression testing in QTP.
• Worked Manual and Automation Testing while validating and verifying software applications or products meets the technical and business requirements.
• Worked in findind bugs in application.
• Updated Requirements Traceability Matrix (RTM) to reflect the test coverage and took part in Test Plan Walkthroughs with the development teams.
• Supported in setting up various Test Environments for Integration Testing, System Testing, User Acceptance Testing and Prod-Fix Testing with the goal of replicating the end users environment.
• Expertise in performing System Integration Testing (SIT), Business Acceptance Testing (BAT) and Performance Acceptance Testing (PAT).
• Prepared and loaded the Test Data by executing Data Load Scripts for the Incremental / historical Load testing and validation.
• Backend testing through SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Worked on UNIX environment in Test and UAT environment.
• Participated in Daily defect calls to elaborate on newly raised defects and also to keep track on the status of existing defects.
• Performed database testing to ensure the ETL process for the data being extracted from various sources (like Oracle tables, flat files, CSV files), transformed and loaded into the new Database through Informatica.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer.
• Use Informatica debugger and session log to debug the defects.
• Finalized and published Test Results in an incremental manner through thoroughly analyzed defect reports.

Environment: Agile Methodology, ETL Tools Informatica 8.6.1,HP ALM Explorer 11.5x, Quality Center, Quality Test Professional(QTP), Selenium Web Driver, Oracle 11g, Unix, SQL Developer 3.0, PL/SQL, Microsoft Office 2010.

Confidential, NJ

ETL/QA Tester

Responsibilities:

• Responsibilities: Involved in creating Test Plans for the different aspects of the project according to the business specifications in coordination with the QA lead and project manager Responsible for reviewing business requirements, functional specifications, project schedules, documentation and test plans. Performed UAT, Positive, Negative and Boundary testing using the approved test cases.
• Worked using automation tools - HP UFT / QTP for Functional, regression and service Testing.
• Involved in creating test cases for regression testing and assist test lead during the testing activities
• Analyze test cases and defects being loaded in QC by QA teams to ensure the link entities and accuracy of data.
• Performed Parameterization using QTP
• Coordinate with QA team to manage and update the missing parameters of test cases and defects in QC. Performed Manual Testing to test the usability of the application.
• Conducted GUI testing to test the appearance and properties manually.
• Performed Smoke Testing, Sanity Testing.
• Performed back-end testing using SQL queries to validate data and perform Data integrity testing. Performed Data mining on defects, test cases, requirements as required by the team.
• Analysis the Weekly QA Metrics Reports for to correct the reporting errors.
• Modified test scripts created by the system test team to meet UAT needs
• Supported User acceptance testing (UAT) in preparing the test scripts and test execution.
• Documented and reported bugs using Quality Center.
• Actively participated in Status reporting meetings and interacted with Developers to discuss the technical issues.
• Analyze the requirement coverage and traceability to ensure the testing coverage.

Environment: Informatica, HP Quality Center, SQL SERVER, SQL, UNIX, Windows XP, Agile.

Confidential, Dendrite, NJ

QA Analyst

Responsibilities:

• analyzed various documents and prepared test cases covering all requirements of the application.
• Converted test cases for various test sets to organize the execution procedure to meet the project time line and timely deliverables.
• Tested functionalities of the application.
• Discussed the test cases for regression testing with the quality engineers for each build and.
• Validated and executed ETL jobs scheduled in Autosys.
• Wrote SQL queries to validate the ETL logic of the application.
• Updated and modified Unix files consumed by various process of the ETL process.
• Interacted with the development team to report bugs and discuss the status of bugs with open status or hold status.
• Good experience in PRESTIMA preclinical application and all its instruments like Chemistry analyzers, Stage Iris.
• Involved in various documentation tasks such as daily status reports, weekly progress reports, Requirements traceability Metrics (RTM) and defect logs.
• Extensively used Quality Center for test planning and Used Rational Clear Quest for bug tracking and reporting.
• Good knowledge in NuGenesis SDMS, PRESTIMA.
• Responsible for creating test bed for the application with valid and invalid data covering all positive and negative test scenarios.
• Actively participated in enhancement meetings, project review meetings, Weekly status meetings and various other meetings which were focused on making the application more effective.

Environment: HP Quality Center, Rational Clear Quest, Windows XP, Unix, MS Excel, MS Word, Oracle 10g, Putty, Autosys, Office Communicator, SharePoint