Test Lead
Wipro Technologies
Total years of experience :17 years, 4 Months
12.3 years of experience in Information Technology arena, primarily focused in Manual and ETL Testing and Quality Assurance of Client Server and Web Applications on different platforms and environments in Pharmaceutical and Retail industry.
• Having good experience in product based testing on the various domains like Pharmaceutical and Retail.
• 8 years of experience in Data warehousing testing (ETL testing) using DataStage and Xtelligent.
• Experience in MDM, ETL & Mainframe CISC application testing.
• Experienced in Bug Tracking and Bug Reporting using HP ALM (Previously Quality Center), Clarify, Teamtrack and JIRA.
• Hands on experience in SQL Server, Teradata and Oracle databases
• Worked with esteemed Clients like WALMART, Sanofi-Aventis and Pfizer etc.
• Functional Study of the system, analyzing & Understanding the requirement specification.
• Thorough understanding of SDLC and STLC.
• Participated in the Project Kick off meetings, Requirements walk through and Audit meetings.
• Skilled in authoring Test Plan, Test Conditions and framing Test Cases, Traceability Matrix and Test Summary Report.
• Experience on managing the team (Team Size 8) for more than 4 years and extensive experience in Black Box testing and Functional testing.
• Specialized in analyzing the functional specifications and writing detailed test cases, execution of test scenarios, analyzing the actual results against the expected results, creation of test data for system and regression testing and analyzing bug tracking reports.
• Performed Sanity Testing, GUI Testing, Functionality Testing, Regression Testing, Installation Testing, Database Testing, Validation Testing, Data Migration and System Testing.
• Flat/Data file creation, reference data/look-up tables, working with high volumes of data. Good in SQL, able to write complex queries for data retrieval and data manipulation using joins.
• Having experience on experience on L10N (Localization) testing.
• Ability to validate the completeness, integrity and accuracy of data.
• Very good Knowledge of automation tools QTP.
• Proven ability to work efficiently in both independent and team work environments.
• Visited the client places Sydney (Australia) and New Jersy (USA) for requirement study and business understandings of the product.
• Having B1 Visa for USA till 13th July 2017
Having good experience in product based testing on the various domains like Pharmaceutical and Healthcare.
•3 years of experience in Data warehousing (ETL testing) using DataStage and Xtelligent.
•Having working experience in Quality Center.
•Functional Study of the system, analyzing & Understanding the requirement specification as per PCW, WO, DID, IRD and CRD.
•Thorough understanding of SDLC and STLC.
•Participated in the Project Kick off meetings, Requirements walk through and Audit meetings.
•Skilled in authoring Test Plan, Test Conditions and framing Test Cases, Traceability Matrix and Test Summary Report.
•Handled projects of team size 6-8 and extensive experience in Black Box testing and Functional testing.
•Specialized in analyzing the functional specifications and writing detailed test cases, execution of test scenarios, analyzing the actual results against the expected results, creation of test data for system and regression testing and analyzing bug tracking reports.
•Performed Sanity Testing, GUI Testing, Functionality Testing, Regression Testing, Installation Testing, Database Testing, Validation Testing and System Testing.
•Flat/Data file validation, reference data/look-up tables, working with high volumes of data. Good in SQL, able to write queries for data retrieval and data manipulation using joins.
•Ability to validate the completeness, integrity and accuracy of data.
•Experienced in Bug Tracking and Bug Reporting using Clarify and JIRA.
•Very good Knowledge of automation tools QTP.
•Willing and has ability to take up automation testing.
•Proven ability to work efficiently in both independent and team work environments.
.
•Participated in requirements walkthrough to understand the client requirements & implementation gaps.
•Provided estimates for the QA Activities and created Test Plan.
•Explained requirements to the team members in business perspective.
•Assigning test scripts creation task to the various modules to each team member.
•Reviewing Test scripts created by the team members and preparing QA measurement forms.
•Attended QA Audit meetings and requirements walkthrough.
•Identifying the DB's specific to Configuration and cut the DB’s and download them.
•Setting up the test environment as per the PTP.
•Pulling the jobs from the Datastage Manager to Datastage director.
•Conducted different types of testing i.e., Functional testing, Regression testing, Installation Testing, Volume testing, Sanity testing.
•Database testing using SQL, for various data verification between database and front end application.
•Preparing the test data files for the ETL (Extract-Transform-Load) jobs.
•Loading the sales data using datastage.
•Executing the Interface jobs through Datastage and Xtelligent, checking the log files and reject files
•Verifying the correctness of data from source to target.
•Involved in Functional, Data verification, data validation testing and ETL Testing.
•Data Validation within Target tables to ensure data is present in required format and there is no data loss, Bad data from Source to Target tables
•Analysis the Reason for the data Rejection during ETL Process.
••Conducted meetings with team members on daily basis for status reports and discussing issues with Development team and onsite TPM.
•Creation of Test Summary report and Traceability Matrix.
•Monitor the testing project in JIRA and ensuring defects are being entered, tested, and closed.