PROFILE SUMMARY:

• 14 years of experience in the field of IT with focus on manual testing in various domain and technologies
• Handling the team of 10 offshore members.
• Have working experience on Test Management tools Quality center & Application Life Cycle management and defect tracking tool Rational ClearQuest.
• Exposure to all stages of Software Development Life Cycle (SDLC) and Software Testing Lifecycle (STLC).
• Extensive experience in designing Test Plan and Test cases, preparing Test data setup, responsible for Test Deliverables, status reporting to management and issue escalations.
• Complete understanding and working experience of Usability, Functionality, Sanity, Regression, SQL Tuning, Security, Database, Application Logging, System Integration and Performance testing (Manual).
• Experience on Agile process. Experience on Agile tools Rally.
• Hands on experience on python coding and mainframe file testing.
• Command over UNIX and Structure Query Language (SQL).
• Quick learner, excellent team player, ability to meet tight deadlines.
• Experience on Analytical models testing.
• Experience on Build deployment in all test regions and debug on the issues if any failure.

SKILL SUMMARY:

• ETL Testing (SSIS, DataStage and Informatica)
• Database testing (Oracle, SQL Server, Teradata, Hadoop (Hive and Impala))
• Reports testing (BO webi, SAP OBIEE and Cognos)
• Web services testing (SOAP UI Tool)
• UNIX (HP - UX, Linux and Sun Solaris)
• UI testing (web application)
• Devops tools Git, Jenkins, Fitnesse and Symphony CPC
• HP Application Life cycle Management and Rally
• Functional Test Planning and Test Data Management.

PROFFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Create detailed, comprehensive and well-structured test plans and test scenarios based on the technical, functional specification and mapping documents.
• Deploy the build in all test environments using Jenkins and ensure the build is successfully deployed
• Involves in testing of stored procedures, DataStage jobs, UNIX bteq scripts and Views
• Based on the technical specifications, data mapping and data model, build the code in SQL and perform System Testing on the data which got loaded to the application.
• End to end integration testing by coordinating and providing/requesting the input data/files with the external teams
• Works closely with development team to perform root cause analysis of defects/issues.
• Prepares test acceptance document for certifying the changes are as per requirements and implementing the changes to production.
• Involve in Review of functional and technical requirements with Client Team to understand/analyze the requirements and impact of upstream & downstream applications due to each enhancements/changes/termination made to Enterprise Data warehouse.
• Performs source data gap analysis (Flat files/SQL server/Oracle/Teradata) by utilizing expertise on project architecture and in Confidential Domain.
• Forecasting risks on deliverables, anticipate post production issues and provide mitigations upfront

Confidential

Responsibilities:

• Regular calls with offshore on the daily status update and assiging tasks on daily basis
• Clarifying the requirement/access releated issues/clarifications
• Ensure team followed testing process standards
• Resource fore casting.
• Reviewing the test artifacts and prepare test plan.
• Providing updates in daily Scrum call and Ensure team updated hours in Rally
• Involved in Integration Testing (Test Plan & Test case preparation & Execution) and PVS testing
• Estimating the user stories in Sprint planning session.
• Testing the migration of models from Java and oracle environment to Python/R/SAS and Hadoop environment
• Testing of the source database changes and main frame files
• Continuous integration of the deliverable using devops tools.
• ETL DB automation using Fitnesse, Jenkins and Git.

Confidential

Responsibilities:

• Under standing and analysing the FSD and TDD documents.
• Involved in System Testing (Test Plan & Test case preparation & Execution)
• Involved in testing of the BO webi reports & Informatica ETL jobs.
• Regular calls with onshore on the daily status update or understanding the requirements.

Confidential

Responsibilities:

• Under standing and analysing the FSD and TDD documents.
• Involved in System integration testing (Test Plan & Test case preparation & Execution)
• Involved in testing of the OBIEE reports & Informatica ETL jobs.
• Involved in sending the daily status report.
• Test execution and defect raising in ALM

Confidential

Technologies Used : SQL Server 2005, Java, .Net, XML, BO webi

Tools Used : Application Life cycle Management, Starteam, QTP 11 and Rational ClearQuest.

Responsabilités:

• Involved in System testing (Test case preparation & Execution) of all changes and UAT testing of some of the changes in each Monthly release
• Involved in testing of the BO, Web services, ETL and Frontend.
• Involved in integration testing for some of the changes.
• Managed the team of 4 members which involves the below tasks
• Tracking of Demand & Capacity for the next two months b. Raising the Issues/Risks in the Clear Quest tool, if any c. Cross train the resources d. Regression test suite plan
• Involved in preparing the QA Monthly status report, CAR Analysis, Quality Metrics report.
• Regular meetings with onshore coordinator on status of the testing of each change and discuss on issues/challenges.

Confidential

Technologies Used : SQL Server 2008, UNIX, Data Ware house, SSIS and BO webi.

Tools Used : Rational ClearQuest

Responsibilities:

• Involved in test environment setup
• Analyzing & understanding the technical design document.
• Involved in test cases preparation, test cases execution and daily status calls.
• Involved in defect tracking using rational clear quest.
• Involved in database testing and BO reports testing.
• Involved in BI functional testing

Confidential

Technology Used : Oracle Server 8.1.7, UNIX, JDK 1.3, Websphere 4 and Site minder.

Tools Used : Quality Center 9.2 and Toad

Responsibilities:

• Analyzing & understanding the requirement documents.
• Preparing the Test Deliverables (Test Plan, Test Cases, Test Report, Defect Report, Project Status report and Post Release Document etc.) for each release.
• Involved in weekly status meetings and preparing MOM.
• Managed the team of 2 members.
• Involved in Build verification Testing, System Testing, Database Testing and Unix Testing.
• Involved in Integration Testing and manual perfomance testing for some releases.