SUMMARY:

• 9 Years of Extensive experience in IT Industry with emphasis on Quality Assurance & Software Testing.
• 6 years of experience in Data Warehousing/ ETL Testing within the environment of Oracle, SQL Server and 3 years of experience in manual testing on web based, Client/Server and data warehousing applications.
• Expertise in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications.
• Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.
• Experience with Testing mobile (iOS, Android, Windows) applications over different platforms.
• Experience with working tools like MS SQL Server Management studio, SQLDeveloper, Win SQL, Teradata for creating and executing SQL Queries.
• Experienced in complete Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Extensive experience in Black Box Testing, Smoke testing, Functional Testing, Integration Testing, System Testing, Regression Testing, End - to-End Testing, User Acceptance testing (UAT)
• 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.
• Involved in preparation of Test Data to test the functionality of ETLSources, Mappings and Targets.
• Worked under Testing methodologies like Agile-SCRUM and Waterfall Model.
• Involved in Testing of Business Objects reports by executing the SQL Scripts.
• Expertise in Defect management, Bug tracking, Bug Reports and generating the graphs using Test Management Tools such as Quality Center, ALM & TFS (Team Foundation Server).
• Involved in preparation of Traceability Matrix based on High/Detail requirements and Test Cases to ensure comprehensive test coverage of requirements.
• Experience in maintaining support documents, QA Sign off Documents and maintaining Weekly Status Reports.
• Having hands-on experience in ETL tools such as Informatica and Datastage.
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• An effective communicator with strong analytical abilities combined with skills to plan, implement & presentation of projects.

TECHNICAL SKILLS:

Database: Teradata, Sybase Oracle, MS SQL Server, DB Visualizer

Platforms Known: Windows XP, Vista, 7

Languages: Unix, Linux

Tools: SQL and basics of C, Java HP Quality Center 11.52 ALM, SQLDeveloper,Oracle Data Integrator,Fitnesse tool, Talend, Beyond Compare, Oracle Express, Win SQL, Informatica, DataStage, EPIC

PROFESSIONAL EXPERIENCE:

Confidential

Test Lead

Responsibilities:

• Analysis of business and functional requirements
• Preparation of Test Strategy and Test Plan documents
• Test data preparation and writing test cases.
• Validation of business rules on data by writing SQL queries using inner, outer joins, subselects, etc for both historical and incremental load
• Co-ordinating with offshore team
• Reviewing test cases and test execution results with clients
• Defect closure and Test Summary report preparation

Confidential

Test Lead

• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirementsand business processes.
• Experience in SDLC and Agile methodologies such as SCRUM and KANBAN
• Analyzing requirements and creating and executing test cases
• Analyzing requirements, Creation and execution of test cases
• Performed Integration, End-to-End, system testing.
• Involved in Functional Testing & Regression Testing
• Used Quality Center for creating and documenting Test Plans and Test Cases and registering the expected results.
• Preparation of Weekly status report and Monthly status report
• Involved in testing web-based applications which are used to submit the health Claims and Benefits.

Confidential

Test Analyst

• Analysis of business and functional requirements
• Test case preparation and writing test scripts.
• Validation of business rules on data by writing SQL queries using inner, outer joins, subselects, etc
• Validation of reports from business objects
• Reviewing test cases and test execution results with clients
• Validation of Historical and Incremental data

Confidential

Test Analyst

• Gathering the requirement from client
• Analysis of the business functionality of MediaPad Application
• Testing the functionality of the application
• Validation of business rules/transformation logics
• Data validation using Beyond Compare tool
• Contribution for Process Improvement team towards Cycle Time reduction
• Test Cases/Execution results review with Clients
• Raising and Tracking Defects daily
• Sending daily status reports. Weekly status reports to clients
• Testing of Singapore, Australian applications

Confidential

Test Analyst

• Analysis of business and functional requirements
• Test case preparation and writing test cases.
• Validation of business rules on data by writing SQL queries using inner, outer joins, subselects, etc
• Test execution using Fitnesse tool and HP Quality Centre
• Reviewing test cases and test execution results with clients
• Raising and Tracking Defects
• Legacy System comparison
• History Data Validation
• Eventing console and Sync Testing
• Supported other teams such as NBI and AD-VOD programs

Confidential

Test Lead

• Gathering the requirement from client
• Analysis of the business functionality
• Test Strategy Preparation
• Test plan Creation
• Validation of data for mapping/business transformation logics
• Data comparison using Fitnesse and Beyond Compare
• Task Allocation to the team members
• Test Case Creation / Review
• Test Execution Review
• Raising and Tracking Defects using Hp-Quality Center
• Documentation
• Responsible for all the test deliverables related to Confidential -NCS

Confidential

Tester

• Requirements collection and analysis
• Prepare and analyze the design, which would help throughout the software development life cycle.
• Coordinating with the Operations, Network, Database and QA teams on a regular basis and brain storm on solutions.
• STLC
• Analysis, Estimation
• Test Strategy Preparation