SUMMARY

• Over 8+ years of experience in Manual and Automation as a Software Test Engineer.
• IT experience in testing ETL and Business Intelligence solutions, Data - Warehousing solutions, and Quality Assurance and Software Testing of various business applications inClient/Server environments, Web-based applications.
• Excellent working experience of Software Development Life Cycle(SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle
• Experienced in Functional testing, Integration testing, System Testing, Regression testing, Black Box testing, Smoke Testing, Batch Testing and GUI Testing
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Test cases
• Involved in preparation of Requirement Traceability Matrix (RTM), Master Test Plan, Defect Report, and Weekly Status Reports
• Knowledge in Facets, ICD10, Claims Xten, EDI, ANSI X12
• Test results analyzing, sending suggestions and defects
• Experience in Test Automation, scripts preparation and execution within the framework
• Good exposure in using of QTP integrated environment (Synchronization, Data Table, Actions, Recovery scenarios, methods etc.)
• Experience in Jenkins and JD Edwards
• Strong Exposure on Automation testing with “descriptive programming” and expert in “VB scripting” by manually
• Handle the flat files using the data driven technique Visual script using descriptive programming Strong work experience with software automation testing tools like Selenium WebDriver/RC/IDE/ Grid and QTP.
• Good experience in Selenium Test environment setup expert using the entire open Source tools.
• Expert in SQL and PLSQL programming, wrote complexSQL queries and Stored Procedures for back-end testing
• Proficient in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like ALM
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification
• Experience in Leading Offshore team, on-site-offshore coordination and Defect Triage participation
• Extensively worked in Agile/Scrum Methodology.
• Strong understanding of JD Edward file structure and ability to mine data as world writers,SQL
• Strong ability to trouble shoot the errors generated while processing files and programs
• Excellent interpersonal, communication, documentation and presentation skills

TECHNICAL SKILLS

QA Tools: Quick Test professionals, Quality Center/ALM, Test Director,Selenium

QA Methodologies: Agile Scrum, Waterfall Methodology

Operating Systems: Windows - 7, Vista, XP, 2000, NT 4.0, UNIX - Sun Solaris, HP-UX

Databases: Oracle 11g, 10g, 9i, 8i, MS Access, SQL Server 2005/2008, DB2, Netezza and Teradata V2R5, TD12, TD13.

DBMS Tools: SQL plus, TOAD, SQL Developer, Sql Server Management Studio.

BI/Reporting Tools: Cognos, Business Objects, SSRS and Micro Strategy.

ETL Tools: Informatica Power Center 9.1, 8.x/7.x, Data stage 8.x/7.x, Ab-Initio, SSIS.

WEB Technologies: HTML, Java script, CSS, Path, XML, HTMl, Fire bug, Adobe Flash, PHP, CSS, .Net, J2EE, JDBC, MAVEN, Firebug, UIAutomatorviewer.

Languages: Java, .Net, JUnit, Finesse, Cucumber, VBScript, Shell Script, Python, XML

PROFESSIONAL EXPERIENCE

Confidential, Sacremento, California

QA Tester

Responsibilities:

• Analyzed business requirements and functional documents, created the test strategy document that define the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.
• Attended Release Planning, Daily SCRUM meetings and created tasks and defects in Rally
• Developed detailed test plans and test cases, as well as an Entrance and Exit criteria for the application being tested ensured along with standards for documentation to be followed.
• Involved in analyzing system specifications, design, development and execution of test plans and test cases for Manual and Automated testing.
• Performed security testing, system testing, positive and negative testing, Cross browser testing manually.
• Performed Functionality Testing and Regression testing usingSeleniumWebDriver
• Wrote and executed automated test cases usingSeleniumWebDriver to automate testing solutions.
• Implemented wide range of UI functional testing with Key Word and Data Driven framework for Selenium.
• Used XPath, Firebug, UI Automation Viewer to work with dynamic (AJAX) and static objects with Web Driver.
• Implemented open source tool Appium,SeleniumWeb Driver for cross browser and cross platform web testing.
• Worked and updated theSeleniumtesting Custom Common components (XLS reader using JXL, JDBC
• Utility, property files readers) and Hybrid Test Automation Framework
• Updated Maven pom.xml from to retrieve the necessarySeleniumartifacts from Maven Repositories
• Responsible for Log4j, Testing configurations files for logging the information while executing seleniumtests
• PerformedUnittestingforJavaapplicationsusingJUNIT4
• Executed Web Services functional testing and created test suites for validating SOAP and REST based services using SOAP UI.
• Created and Maintained Traceability Matrix to ensure test coverage of all requirements.
• Performed and Analyzed setups, supervised the flow from Old Test cases ofSeleniumto make it more efficient.
• Used QC, divided the application into modules or functions to be tested, defined tests for each module and specified the steps for each test.
• Submitted defects detected in the application and tracked the progress of defect fixes.
• Used SQL queries for retrieving data from database for executing user specific test cases.
• Documented Business requirements in Requirements grid for Quality Center.

Environment: SeleniumIDE/ WebDriver, Python, Java, J2EE, JDBC, HTML, JavaScript, CSS, Log4j, Android SDK, APPIUM, JUnit4, Firebug, .NET Framework, Maven, Web Services, SOAP, REST, SOAP UI, SQL, Quality center, Rally, Agile, Oracle11g, SQL, TOAD, MSWord, MS Excel, UNIX, Windows 7.

Confidential, CAMPBELL, CA

QA Tester

Responsibilities:

• Analyzed the Requirements from the client and developedTest cases based on functional requirements, business requirement document and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• PerformedSmoke Testing, GUITesting, FunctionalTesting, Backend Testing, System Integration Testing, Sanity Testing.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in the Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Performed complex data validation using SQL queries.
• Written several complex SQL queries for data verification and data quality checks and for extracting data from multiple tables and multiple databases.
• Used Informatica Director to run/monitor the ETL jobs and tested the functionality according to data mapping requirements
• Tested the Cognos reports for Layout, Data presentation and quality.
• Used Data Stage Director to validate, run and monitor the Data Stage jobs.
• Tested theETLInformatica mappings and otherETLProcesses (DW Testing).
• Validated the data loaded by SSIS packages and monitored the performance of the SSIS packages.
• Effectively coordinated with the development team for closing a defect.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Tested reconcile and incremental ETL loads for the project.
• Tested data migration to ensure that the integrity of data was not compromised.
• Extracted data through an ETL tool in order to produce an XML file and validated XML and XSD files.
• Used Rational Clear Quest as defect tracking tool.
• Performed smoke test before the Load acceptance for system testing
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Performed data validation for the Cognos reports.
• Also part of the Agile implementation in sometimes to deliver quicker results.
• Tested reports in Cognos using Analysis studio, Report studio and query studio.

Confidential, Hoffman Estates, IL

QA Tester

Responsibilities:

• Involved in manual testing.
• Analyzed Functional Requirement & High level Design documents to prepare and execute the test cases and end-end scenarios.
• Performed functional, regression, UAT, cross browser testing in different operating systems like windows, UNIX and Mac.
• Conducted regular reviews to enhance the test cases.
• Involved in Run test Plan, Test cases & Test Execution.
• Interacted with other QA Team members to discuss the issues before reporting them to development.
• Reported the defects to the development team in Quality centre.
• Exported Manual Test Cases from Microsoft Excel into HP Quality Center (QC) and converted them into Test Scenarios for automating in Test Plan and executing in Test Lab module.
• Reviewed Test Plans uploaded in HP Quality Center (QC) with teammates and coworkers to continuously evaluate team’s progress and tasks completion.
• Maintained Test Logs and Test Summary Reports.
• Mostly Focused on Regression Testing.
• Supported technical issues for the product, post go live.
• Participated in all review meetings.
• Participated in daily stand up meetings, sprint planning meeting and retrospective meeting.

Environment: Manual Testing, Quality Center, Clear Case, JAVA, Oracle, SQL, TOAD, Windows XP, Python, Jira,Eclipse, LINUX, MS Office Tools.

Confidential, New York

QA Analyst

Responsibilities:

• Analyzed the Business requirements and Technical specifications
• Testing Acceptance criteria based on the user stories created by Business Analyst
• Involved in creating Test plan, Test Scenarios.
• Created Test cases by reviewing Technical document.
• Performed manual testing and maintained the documentation for various stages of testing.
• Day to Day Stand-up meetings with team and updating the Task Board with progress of stories
• Tested the application using various black box testing techniques like BVA, EP.
• Performed functional testing, Database testing, regression testing.
• Communicated defects to development using Quality center found during testing and ensured all high and urgent priority defects were resolved prior to implementation
• Performed cross browser and cross platform testing on various browsers like Firefox, Chrome, IE and Safari.
• Reviewed test cases and pursue the business to prioritize and sign-off the defect log.
• Provided end-user consultative support

Environment: UNIX, Informatica, Data Stage, Perl Scripting, Mercury Test Director 6.5, SQL *Loader, Oracle8i, SQL Server 2003, Teradata, SQL Assistant, Putty, Remedy, SSIS.

Confidential, NY

Freelance Data Entry Volunteer

Responsibilities:

• Prepare data for inputting into databases.
• Input data in an accurate and efficient manner
• Verify accuracy of information prior to keying
• Corroborate data accuracy after performing data entry procedures
• Update records and information in the database
• Compile statistical data for analysis purposes
• Retrieve data for informational purposes as directed
• Compare entered data with the source documents
• Process forms as directed

Environment: MS Word, MS Excel, MS Outlook.

Confidential

QA Analyst

Responsibilities:

• Responsible for developing test plans for various systems under operations and maintenance projects.
• Responsible for conducted system testing, user interface testing, regression testing, and User Acceptance Testing on the migration applications.
• Participated in daily scrums and assigned tasks to the team
• Attended project level meetings and represent QA team with issues, status and reports.
• Management and execution of all system testing activities to include System functional testing, Integration testing and Production Implementation testing
• Responsible for documenting testing-related risks and developed mitigation plans for the same.
• Responsible for creating test cases from the user stories/acceptance criteria.
• Participated in peer review of test cases.
• Involved in defect re-testing and regression testing.
• Worked with several testing teams for various applications testing.
• Responsible for interacting with developers in defect meetings.
• Create Test Cases, determined Testing Scope and Data\ Needs for Project validation in a UAT Environment and attended all project meetings for business user testing
• Created Requirement Traceability Matrix for the releases.
• Knowledge transfer to the new employees in our team and client team.

Environment: Dot Net, Manual Testing, Windows7, SQL Server 2008, html, css