SUMMARY

• 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.
• Worked as Onshore ETL test SME for the Confidential client in Pittsburgh, USA for 6 months duration.
• 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

Testing Knowledge: 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

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.
• 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

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

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

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.