SUMMARY:

• Over 8+ years of experience in manual testing on web based, Client/Server and data warehousing applications.
• Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
• Well - versed with all stages of Software Development Life Cycle(SDLC) and Software Testing Life Cycle(STLC).
• Experience in Web based applications like online banking, transactions applications.
• Expertise in Web Services (API) testing using SOAPUI (RESTful and SOAP).
• Experience in Cross-Browsers/Platforms Testing of many web based applications including Mobile Devices like iPhone, iPad, and Android.
• Experience in SQL and PL/SQL scripting
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experience in Automation using Mercury Interactive Tools such as Win Runner, QTP, Selenium, Load Runner.
• Experience in using Bugzilla, Test Director, Jira and HP Quality Center for Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Experience in Reports testing in Crystal Reports XI Environment.
• Experience with Agile and Waterfall software development process or releasecycles.
• Strong working experience in Windows NT/2000/XP and UNIX/LINUX environments
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Committed to Delivering high Quality deliverables. Equally adapt at working in teams or independently.

TECHNICAL SKILLS:

Languages: JAVA, JavaScript, C#, VB Script, CSS, HTML, DHTML, XML, SQL

Testing Tools: Selenium Web Driver/IDE, Mercury QTP, HP Quality Center, JUnit, Cucumber, Firebug, FirePath, TestNG, SOAPUI, Manual Testing, Appium (Mobile Testing)

Frame works: Junit, TestNG, TDD, BDD, Protractor

SOA Technologies: SOAP, REST, WSDL, Web Services, SOAP UI

Bug Tracking Tools: HP Quality Center (9, 10, 11.0), BugZilla, JIRA.

Database: MS SQL Server, Oracle 9i/10g/11g, Oracle PL/SQL, SQL*Plus, TOAD, SQL*Plus, SQL*Loader, MYSQL

Build Tools: Ant, Maven, Jenkins

Operating Systems: Windows 2000/XP/Vista/7, UNIX, Linux, Solaris, DOS, Mac-OSX, Android, iOS

Other Technologies: Log4J, XHTML, XSL, MS Office, Adobe Photoshop, Flash, firebug, XPATH

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Sr. QA / ETL Tester

Responsibilities:

• Write complex SQL queries and procedures to validate data source table and target table
• Working in Agile environment attend daily stand up, sprint planning, backlog grooming refinement and retrospective meeting.
• Load the test cases in the ALM under test plan and execute the test cases in the test lab
• Create task, update the task and input actual work
• Check store procedure to understand the logic and build up own query to make sure data accurate in the target table base on the development changes
• Write the test cases and update as per the design documents and follow the mapping doc for the system Integration region
• Write SQL queries to validate that actual test results match with expected results
• Identify the complete test scenario for report testing and ETL testing.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source
• Performed backend database testing by writing SQL scripts to verify data integrity
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
• Involved in all testing phases: Smoke Testing, Functional Testing, System Testing, Performance Testing, Regression Testing, Integration Testing, and Quality Assurance Testing
• Involved in validating the aggregate table based on the rollup process documented in the data mapping
• Assisted in creating test data and test cases and execute function system tests as needed.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Environment: SSIS, SQL, PL/SQL, SCM database, Flat Files, Csv file, Text file, UNIX, Winscp, ALM, Oracle 10g, 11g.

Confidential, Hartford, CT

Sr. QA Web Tester

Responsibilities:

• Tested the application with manual test cases and automated test cases.
• Tracked the defects through the JIRA tool and created test cases in JAMA tool.
• Performed Integration testing between module releases.
• Performed smoke testing after every code drop in different environments (SIT, Sandbox, UAT1, IIT1, CIT1 and Conversion Mock)
• Involved in writing the business documentation for eligibility, funds and payments module.
• Worked on end to end flow of the application
• Worked at the client site with case workers in gathering requirements in Hartford, Connecticut
• Attended sessions with Client and gathered information to enhance the existing functionality
• Responsible for emphasizing the Agile Methodology.
• Worked extensively in Agile environment and wrote and executed SCRUM-Based test Cases.
• Maintained a Product and Sprint Backlog, created Stories for month long Sprints, ran daily Scrum, held Monthly Scrum Reviews in accordance with Agile methodology.
• Participated in all phases of the Software Testing Life Cycle.
• Worked on core modules like Eligibility, Provider Management, Enrollment, Funds Management and Payments
• Worked on Web Services Testing using ARC REST Client, SOAP UI 5.0
• Worked on executing batches for notices, alerts, provider information, funds recovery, payments issuance (based on mode of payment like check, direct deposit and debit card)
• Worked on web service call related to data exchange between child care portal and provider portal
• Developed Test related documents including Test Plans, Test Scenarios, Test Cases and Test Scripts.
• Conducted Regression, Functional, and Performance and Multi-User tests manually.
• Investigated and documented software faults and interfaced with developers to resolve technical issues.
• Involved in database testing and wrote complex SQL queries to retrieve data from database and compare the data that is displayed on the web application
• Used SQL Developer for creating and executing various types of SQL queries and procedures.
• Performed test execution at the system integration level, performed feasibility studies and evaluated system requirements.
• Provided the QA Lead with the ongoing status and updates in the daily stand up meeting.

Environment: IBM RAD JAVA development, Oracle SQL Developer, JIRA defect tracking tool, JAMA Test Manager, ARC REST client for web service

Confidential, Lake Success, NY

QA Engineer / Mobile Tester

Responsibilities:

• Participating in system specification meetings, design reviews, requirement study and the preparation of the test plan outlining the scope of the project.
• Working in a continual test mode in Agile based development process
• Performing QA tasks as they relate to creative, functional, backend new system launches, existing application upgrades and enhancements.
• Involved with all aspects of application phases from design through deployment, following agile process.
• Documenting detailed test scenarios and test scripts derived from defined business requirements and supported the QA manager to coordinate test plans across multiple parties.
• Participating in multiple Project Releases.
• Executing formal test plans with attention to detail, ensuring all system components function per defined requirements and were production ready prior to launch.
• Developing, and maintaining functional test cases and other test artifacts like test data, test matrices, data validation, harness scripts and automated scripts.
• Held and facilitated test plan/case reviews with cross-functional team members.
• Executing and evaluating manual and automated test cases and reporting test results.
• Performed raw data structure and content validation especially in the support of feeds integration testing including product, content translation, warehouse, sales, and marketing feeds.
• Isolated, replicated, and reported defects and verified defect fixes using JIRA.
• Identified potential quality issues and escalated them immediately to management.
• Ensured validated deliverables meet functional and design specifications and requirements.
• Performing Black-box testing, functional testing, UI testing, integration, end-to-end testing, Regression Testing, performance testing, UAT and build acceptance (smoke) testing after each build.
• Performing Cross-Browsers/Platforms Testing of many web based applications including Mobile Devices like iPhone, iPad, and Android.
• Performed Manual Testing for Native Mobile Applications on iOS and Android devices
• Validated the data after running the batch process from different Mainframe systems
• Working closely with Off-shore testing team on creating and executing test cases and test data.
• Writing complex SQL queries (DB2) and statements to test Data Integrity, Referential Integrity for Back-End/database testing for the Application.
• Reporting the status and results to the management and team lead in timely matter
• Attending Stand up, planning meeting, reviews and other project and QA related meetings.

Environment: IBM Rational Quality Manager 3.0.1.2, IBM Rational Clear Quest 8.2.3, Web Services SOAP UI, IBM Clear Case 8.2.1, Java, XML, JIRA, JSP,Oracle 11g, DB2 10, Windows7, Linux, Firefox, IE10, SAP BI Crystal Reports

Confidential, Austin, TX

ManualQATester

Responsibilities:

• Involved in creation of automated test cases for testing various web modules like supplier data, inventory tracker, exchange tracker, damage tracker.
• Performed mobile application automation for iOS and Android using tool Appium and Selendriod.
• Designed and implemented different automation frameworks from scratch.
• Identified Automation Scenarios from the set of Test-cases/User stories identified in cycle.
• Worked with back end testing using SQL, Server including creating MYSQL queries to verify or manipulate test data.
• Extensively involved in all stages of testing life cycle, Test Driven Development methodologies, Software Development Life cycle (SDLC) using Agile methodologies.
• Use existing tools and techniques to execute test cases and build/script new tools for performing testing/validation function.
• Extensively used iTKO LISA and SOAP UI for functional testing of web services.
• Experience with Web Services, Soap UI, RESTFUL, WSDL technologies. Involved in the Continuous Integration of the automation framework with Jenkins.
• Worked on Templates and Modules.
• Worked on Adobe CQ5 Photoshop for Designing Purpose and developing templates.
• Performed regression Testing on various OS devices and their respective simulators and actively participated in executing the test scripts on Android & IOS.
• Experience editing video with desktop tools like premiere pro .
• Used Protractor for Applications developed using Angular JS.
• Used JIRA for Identifying, logging, tracking and escalating bugs.
• Performed smoke testing in UAT and production environments for deployment verification

Environment: Java, XML, PL/SQL, UFT, ALM(HP Quality Center 9.2), HP Quick Test Professional, ETL testing, Soap UI, Agile, GIT.