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
Onshore Test LeadResponsibilities:
- 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
Team LeadResponsibilities:
- 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
Senior Software EngineerResponsibilities:
- 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
Senior Software EngineerResponsibilities:
- 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
Senior Software EngineerTechnologies 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
Senior Software EngineerTechnologies 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
Senior Software EngineerTechnology 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.