PROFESSIONAL SUMMARY:

• Worked as Senior Quality analyst at JP Morgan Chase & Co. India for 3 months.
• Worked as SENIOR SOFTWARE ENGINEER at Confidential Services India for 7.6 years.
• Around 8 years of experience as a Programmer in Information Technology Industry with expertise in the area of Software Testing which includes BI, ETL, Database testing, functional & Black Box Testing in Data warehouse projects, E - commerce projects, online web-based applications, Knowledge of Mobile Web / App testing techniques.
• Domain knowledge in Banking fundamentals, Healthcare, Insurance areas. Experienced with Microsoft Technologies.
• Experienced in working Data warehouse projects and understanding the flow of ETL, Informatica workflows, mainframe data creation, loading of data into staging tables and verifying the same and doing validation by writing sql queries .
• Experience and good understanding of various phases of Software Development Life Cycle (SDLC), Testing Life Cycle and Defect Life cycle
• Experience in performing the white box testing, Black box testing, integration testing, GUI testing, Regression testing and supported user acceptance testing (UAT) with business users
• Extensive knowledge in understanding Business Requirements Document, Functional Requirements Document and Software Requirement Specifications.
• Experience in working with V-Model and Waterfall testing methodologies and knowledge on Agile method.
• Experience in preparing Test plan, Test scenarios, Test cases, and Test Scripts based on User requirements and System Requirements Documents for Functional, Regression, Integration, Usability Testing and Cross- Browser Compatibility Testing
• Experience in preparing the requirements traceability matrix(RTM) to analyze changes and identify the areas of application for Regression Testing
• Expertise in Bug Reporting, Bug Tracking using various Bug Tracking Systems and Actively interacted with the development team to fix crucial bugs.
• Experience in designing and generating different Test Reports
• Active involvement in the design walkthroughs, inspections and reviews
• Knowledge of UNIX / Linux commands, FTP Tool like FileZilla
• Experienced in leading teams as Test Lead in more than one occasion.
• Highly appreciated for First Time Right (FTR) and On Time Delivery (OTD).
• Greatly commended for playing versatile team player.
• Proven capability to work both independently and in a team environment.

TECHNICAL SKILLS:

Operating System: Windows 9x, 2000, XP, Windows NT, Windows Vista & Windows 7 and Unix

Database Technologies: Oracle 9i (SQL, PL/SQL), Teradata, SQL server 2008, Sybase

Programming Languages: C, C++, Java basics

SDLC: Project Planning, Risk Analysis and Management,Defect Management

Testing Methodologies: Water Fall Model, Verification & validation Techniques, Agile Methodology

Testing tools: QC, Product studio (Microsoft), Visual Studio 2010, Mercury Quality Center,JIRA, DRAT database, IBM rational Tools, Test manager,ClearQuest

Software Tools: Toad, RapidSQL,XMLSPY,Putty, WinSCP (FTP),AquaData Studio, Teradata SQL assistant and CDP Tool,VSTF, VSTS,MTM,Informatica 8.2, Workflow manager, Selenium, Eclipse 3.0 QTP,Netezza

PROFESSIONAL EXPERIENCE:

Senior Software Engineer

Confidential

Responsibilities:

• Validate Unit Test results of the Mapping and Transformation and identify the gaps in testing.
• Develop Test conditions, Test scripts and expected results or system Integration Testing.
• Writing SQL queries for validating the transformation logic.
• Data comparison between the staging and target tables using sql queries, manual way and automated tools.
• Execute Test scripts
• Record problems and issues in accordance with the projects issue management process.
• Work with the architecture Components and attribute Mapping/Transformations teams to resolve any issues /SR’s that arise out of the testing process.
• Validate SIR fixes
• Provide status to and inform the onshore people and business analyst of any issues that may affect the schedule, budget or quality of the product or the testing process.
• Mentoring the Junior members in the team about the Testing process and day to day task allocation.

Senior ETL Tester / Offshore Lead

Confidential

Responsibilities:

• Reviewing Business Requirements Specifications Document and Functional Specification Provide daily status on test design efforts.
• Giving Estimates on the project.
• Raise and manage project issues, review project risks, initiate risk minimization actions and escalate the major risks to the higher management.
• Review of Test cases and SQL queries.
• Identify/document Test Conditions and Expected Results.
• Design SIT test cases and scripts to validate functional requirements.
• Involved in reviews of test artifacts and in corporate review comments
• Verify that SIT test cases/scripts cover all functional requirements by managing the traceability matrix.
• Writing SQL queries for verification and validation
• Execute SIT test cases, Log results and tract defects using the laid down processes
• Review the Detailed Test plan and Provide feedback
• Working on the test data preparation activities.
• Mentoring new resources.

Senior ETL Tester

Confidential

Testing Tool: IBM Rational Unified Process, Test Manager, Clear quest

Responsibilities:

• Identify/document Test Conditions and Expected Results.
• Design SIT test cases and scripts to validate functional requirements.
• Involved in reviews of test artifacts and in corporate review comments
• Verify that SIT test cases/scripts cover all functional requirements by managing the traceability matrix.
• Provide daily status on test design efforts.
• Writing SQL queries for verification and validation
• Execute SIT test cases, Log results and tract defects using the laid down processes
• Reviewing the Detailed Test plan and Provide feedback .
• Working on the test data preparation activities, data transfer process from the mainframe

Test lead & database tester

Confidential

Testing Tool: SQL server 2005, VSTF, VSTS

Responsibilities:

• Reviewing BRD, FS documents
• Identify/document Test Conditions and Expected Results
• Design SIT test cases and scripts to validate functional requirements
• Involved in reviews of test artifacts and in corporate review comments
• Verify that SIT test cases/scripts cover all functional requirements by managing the traceability matrix and daily sending the status to the high end managers and clients on the progress.
• Writing SQL queries for verification and validation
• Execute SIT test cases, Log results and tract defects using the laid down processes
• Review the Detailed Test plan and Provide feedback
• Working on the test data preparation activities, defect reports
• Mentoring new resources.

BI QA analyst

Confidential

Testing Tool: Teradata SQL Assistance, CDP database comparative tool, Citrix mainframe, DRAT ( Confidential )

Responsibilities:

• Preparing the test plans on the work requests.
• Validating the transformation rule of the columns of very table through SQL queries.
• Preparing the test cases based on the requirements and testing the same, sending daily status reports .
• Logging the defects into the defect tracking tool, be part of Triage calls with Dev and Managers, Clients.

Offshore Test lead

Confidential

Testing Tool: Mercury Quality Center 8.1, Toad, Winscp, Putty, Aqua Data Studio, Altova XMLspy

Responsibilities:

• Validate Unit test results of the Mapping & Transformation automated testing and identify and gaps in testing.
• Develop test conditions, test scripts, and expected results for System Integration testing.
• Execute test scripts. Logging defects into the tracking tool. Attending Bug calls with Dev team and Management to discuss over the bug.
• Record problems and issues in accordance with the project's issue management process.
• Work with the Architecture Components and Attribute Mapping/Transformations teams to resolve any issues/SIRs that arise out of the testing process.
• Validate SIR fixes.
• Mentoring the new comers to the project.
• Provide status to and inform the onshore people and business analyst of any issues that may affect the schedule, budget, or quality of the product or the testing process.

Test Lead / SME

Confidential

Responsibilities:

• Designing and implementation of Test cases and Updating Test Cases, Executing the Test Cases.
• Functional & Regression testing, Writing Test scripts, Reporting of bugs Into Quality Center.
• Defect Review, Evaluation of defects raised and Reporting
• Coordinating with Onsite people and interacted in client’s session(Business Review process)

Tester

Confidential

Responsibilities:

• Preparation of High Level Test Conditions, Writing Test Cases, conditions., Execution in SIT, supporting in UAT and production release, Data creation for Testing
• Reporting bugs into Quality Center
• Functional, system and Regression testing