EXPERIENCE SUMMARY:

• Around 8+ years of experience working in complete software life cycle Involved in requirement Analysis, Test case preparation and execution, defect tracking of ETL/Data warehouse testing and Web service testing.
• Worked effectively with Developers, AGILE Team, and Project Management to achieve, high quality, release deadlines and QA processes improvements.
• Responsible for onsite coordination with the offshore team to get the work scheduled/delivered on time. Worked on testing activities on timely manner and reviewed the offshore work before handing over to the client.
• Expertise in Creation of Test Plan and Test Strategies, Defect Management, Estimation, Time Management, Customer Handling and Negotiation.
• Strong Experience in Automation Web Application Testing using Selenium web driver and TestNG Framework.
• Well Versed in Handling Element in Selenium Web Driver.
• Managed System Integration Testing (SIT) /E2E /Regression/Sanity/Ad - hoc/UAT Testing on Various Retail and Banking Projects for Web Service and ETL Testing.
• Expertise in defect management, identify bugs, bug reporting, tracking the defect status work with developers, product managers and ensure they are resolved.
• Able to intelligently analyze the results of a test run and provide insight into the root cause of defects to assist in the continual improvement of the software development lifecycle processes
• Worked as a Tester/ Test Analyst/Test Lead on a number of Projects throughout my career.
• Responsible for giving high level estimation for the testing project to the customer.
• Experienced in HP ALM 12.0 for requirement, test case creation, execution and defect tracking
• Experience in working with SQL-based databases, use of queries for data retrieval.
• Expertise in Validating the Data Load in Various Database(SQL Server Management Studio 2012/ IBM DB2/ Oracle SQL Developer/Teradata/TOAD )
• Analyzed the data extraction, transfer and Load in multiple servers by running the CONTROL-M Jobs and Datastage, Informatica tool.
• Experienced in Web Service Testing using Restful client, Postman tool and SOAP UI tools.
• Implemented Page Objects, Data Driven automation frameworks using Selenium Web Driver, JAVA, and JUnit.
• Experience in create a test plan, test case, Execute the test case and managed defect lifecycle using Quality Center and HP ALM 12.00
• Worked as a Java - ibatis Develope0072

TECHNICAL SKILLS:

Testing Experience: ETL or Data warehouse testing, web services testing

ETL Tools: Datastage, Informatica, control-M (No development)

Web Technologies: Restful Web Services, SOAP

Automation Tools: Selenium (TestNG).

Data Bases: Oracle 10g/11g, SQL Server, Teradata, IBM DB2 and TOAD.

Web Related: XML, JSon

Domains: Retail and Banking.

Tools: &Utilities: SOAP UI, Restful client, Fitness semi-automation tool.

PROFESSIONAL EXPERIENCE:

Confidential, OH

Senior Test Lead - ETL Testing

• Understanding Business Requirements through conference calls and emails and Detail design document
• Execution of Test cases for UAT Testing based on the mapping(STM) document
• Co-ordination with other testing teams like SIT/E2E.
• Defect Logging and Tracking the defects to closure
• Create and Maintain status tracking sheet.

Tools: /Technologies: Teradata client14.10, Toad for Oracle 11, Informatica 9.6.1 and HP ALM 12.

Confidential, MN

Test Lead - ETL testing

• Understanding Business Requirements
• Identifying the uncovered requirements and suggesting those to business.
• Preparation and Execution of Test cases for System Testing
• Preparation and Execution of Regression test suite.
• Co-ordination with developers and business analyst.
• Defect Logging and Tracking
• Tracking the defects to closure.
• Sharing Dash board report and Weekly status report with Business team.
• Preparation of the Test closure Activities.
• Preparation of the help documents for the project

Tools: /Technologies: Microsoft SQL Server 2012, Oracle SQL Developer, Control-M EM V8, Data Stage.

Confidential

Test Lead - Web Service testing

• Analyze and understand the application and requirements
• Prepare and review test plan, test scenario, test cases and estimation.
• Resource planning
• Participating in functional specification walk through by BA
• Determine test environment hardware and software requirements
• Preparing test data
• Test case execution and bug reporting & tracking.
• Manage the defect activities
• Preparing daily status report and weekly status report
• Participate in Weekly project progress meetings
• Perform Smoke testing, System testing, System Integration testing and Performance Test Support.
• Coordinate and conduct Test Team Training
• Sharing the knowledge to team members
• Cross Project Test Coordination

Tools: /Technologies: Oracle SQL Developer11g2, IBM DB2, Restful client, XML, XSD, Json

Confidential

Tester - ETL Testing

• Analyse and understand the product and requirements
• Prepare and review test plan, test scenario, test cases.
• Test case execution and bug reporting
• Monitor Job status
• Prepare data as per the mapping document
• Prepare test scripts for execution
• Manage the defect activities
• Job scheduling in Control M application
• Conduct KT sessions for the team

Tools: /Technologies:

Oracle SQL Developer11g2, Fitness semi automation tool, Control - M.

Confidential

Java Developer

• Analysis of the specifications provided by the clients for module like Maintenance for Primary & Supplementary Cards.
• Design and Development using JAVA-iBATIS, Oracle.
• Testing - unit testing & integration testing.
• Responsible for creating Database table structures and writing SQL Queries using Oracle.

Environment: JAVA-iBATIS, SOAPUI, Oracle.

Confidential

Java Developer

• Analysis of the specifications provided by the clients for module like Maintenance for Primary & Supplementary Cards.
• Design and Development using JAVA-J2EE, Applets, JSP, Oracle.
• Testing - unit testing & integration testing.

Environment: Java, Servlets, JSP, IBM WebSphere.

Confidential

Java Developer

• Analysis of the specifications provided by the clients for module like Maintenance for Primary & Supplementary Cards.
• Design and Development using JAVA-J2EE, Applets, JSP, Oracle.
• Testing - unit testing & integration testing.

Environment: Java, Servlets, JSP, IBM WebSphere.