SUMMARY:

• 15 years of experience in Software Testing - Datawarehouse Testing. Proficient in Testing (Datawarehouse, ETL - Informatica, DataStage, Data migration, Database, Report testing - MicroStrategy, Cognos, SAP Business Objects, Tableau, SSRS, Excel Cube & Functional - Manual and Regression, E2E, Web Service).
• Extensive work experience with Resource planning, Estimation, Requirement Gathering, RTM preparation, Test Planning, Test Data Preparation, Test Execution, Test Results Analysis and Defect Tracking. Experienced as aBusiness Analystwith solid understanding ofBusinessRequirements gathering,BusinessProcess flow,BusinessProcess Modeling, Data Mapping and Data Analysis.Anchored Quality Compliance audits and organized
• Excellent experience of Data warehouse testing and Performed extensive data analysis in data migration and data warehouse testing.
• Experience in Waterfall and Agile testing methodology.
• Extensive experience in gathering business and application requirements, business processes, identifying risks, impact analysis, UML modeling, Sequence and Activity Diagrams using Microsoft Visio.
• Excellent skills in writingBusinessRequirement Documents, Functional Requirement Documents, System Design Specification and Workflows diagramming skills such as activity diagram, sequence diagram, use case diagram, and class diagrams.
• Involving in End-to-End ETL testing including validation of data movement between Source, Landing, Staging area and Core tables, and Core to Views and Reports.
• Experience in Database, Data Migration and Datawarehouse testing with Informatica, DVO, Cognos, SAP Business Objects, DataStage, AQT, MS SQL Server 2005, MS SQL Server 2008, Teradata, Oracle, iSeries Navigator, MS-Access, PL/SQL Developer, SQL Server & Teradata Utilities like Export and Import and Knowledge of DBMS and Data warehousing concepts.
• Experience in functionality testing, regression and Web Service testing in Windows 10, Windows Vista, Windows 2000, Window 2007, Windows XP.
• Using JIRA, HP Application Lifecycle Management 11.00, HP Quality Center 9.2, TestDirector 5.0 for Defect Tracking and Bug Reports.
• Worked on complex projects with different clients/business stakeholders by gathering requirements and thoroughly understanding various testing methodologies with high quality.
• In depth knowledge of SDLC and STLC phases, Methodologies and best practices.
• Anchored Defect Prevention activities in the team and played a major role in improving CMMi level of the current project in internal assessments by the SQA team.
• Experience of Version control tools like VSS.
• Strong Analytical, Decision making and Communication skills.
• Team player and self-starter with excellent communication, coordination, documentation, project planning, and interpersonal skills.
• Excellent skills in standard Microsoft Office products like Excel, Word, Outlook, Power Point, ServiceNow and VBA Macro, Valium, Log Miner, XML parser, UC4, FileZilla.
• Basics Knowledge of Automation and Performance tools like QTP and LoadRunner.
• Basics of other languages like Visual Basic 6.0, C, C++, HTML, Java, ASP and UNIX.

TECHNICAL SKILLS:

• Operating SystemWindows
• ETL ToolsInformatica
• DatabaseTeradata, SQL Server, Oracle
• ScriptingUNIX Shell Scripting
• ReportingMS-Excel, Salesforce

PROFESSIONAL EXPERIENCE

Confidential

Technology ETL/Salesforce

Responsibilities:

• BSA & Test Lead at Onsite and Interacting with Business Stakeholders/Clients for Requirement Gathering and Analysis.
• Following all BSA processes in SNOW application.
• Performing all the testing activities like Test design, Test execution & Reporting defects.
• UAT support and post-production validation.
• Working with other Vendor and managing Onsite & Offshore communication.
• Reviewing all the Testing deliverables and ensure the success of each release with zero post-production defects.
• Project management activities like metrics preparation of DSR, WSR, Release summary reports.
• Mentor for new joiners for all the domain/process knowledge.
• Team Lead at offshore and managing onsite-offshore communication.
• Working & Managing all the testing activities like estimation, design analysis, test design, test execution & reporting defects. Also providing support for UAT and performing post-production validation.
• Communicating with business stakeholders for requirements gathering and clarifying the observations raised by offshore team.
• Reviewing all the Testing deliverables and ensure the success of each release with zero post-production defects.
• Project management activities like metrics preparation of DSR, WSR, Release summary reports.

Confidential

DomainCommunications

Responsibilities:

• Team Lead at offshore client location and managing onsite-offshore communication.
• Managing all the testing activities at Client location.
• Reviewing & maintaining all the Testing deliverables without any schedule slippages.
• Presenting Demo to Client for successful completion of user story of sprints.
• Project management activities.
• Team Lead at offshore client location and managing onsite-offshore communication.
• RTM, Test Plan, Test Design, Test Execution & Defects Tracking.
• Reviewing & maintaining all the Testing deliverables without any schedule slippages.
• Project management activities.
• Team Lead at offshore client location and managing onsite-offshore communication.
• Resource planning, Project Estimation, RTM, Test Plan, Test Design, Test Execution & Defects Tracking.
• Reviewing & maintaining all the Testing deliverables without any schedule slippages.
• Managing the team including tasks allocation, daily status reporting, weekly status reporting.
• Project management activities.

Confidential

DomainEntertainment

Roles and Responsibilities:

• Team Lead for six members at offshore and managing onsite-offshore coordination.
• Resource planning, Project Estimation, RTM, Test Plan, Test Strategy, Test Scenarios and Test Cases for Integration Testing.
• Maintaining all the Testing deliverables without any schedule slippages.
• Involving in Integration Testing, Triaging and reporting bugs using JIRA along with reviewing execution of the team members.
• Mentoring team for JIRA, Informatica functionalities and Knowledge Transfer sessions to the team and new joiners.
• Anchoring Defect Prevention and Configuration Management activities in the team.
• Preparing artifacts for project audits and submit to SQA auditor.
• Managing the team including work distribution, status reporting, effort estimates, timesheet approvals by verifying authenticity in the efforts submitted.
• Managing team members leaves, certification credits, appraisal performance.
• Leading a team of six from Onsite/Offshore and managing onsite-offshore coordination.
• Involving in preparing/reviewing of Project Estimation, RTM, Test Plan, Test Scenarios and Test Cases for Integration and System Testing.
• Maintaining all the Testing deliverables without any schedule slippages.
• Involving in Integration Testing, System Testing, Triaging and reporting bugs using HP Application Lifecycle Management 11.00 along with reviewing execution of the team members.
• Developing SQL Server scripts for data validation and Test data/Test environment set up.
• Mentoring team for creation of Test Scenarios, Test Scripts, execution and QC functionalities and Knowledge Transfer sessions to the team and new joiners.
• Anchoring Defect Prevention and Configuration Management activities in the team.
• Supporting for UAT, Postproduction Support and Maintenance Release.
• Knowledge Management activities.

Confidential

Technology ETL/ MicroStrategy Reports

Responsibilities:

• Mentored the team with 10 team members from Offshore and managing the team activities.
• Managed onsite-offshore coordination and offshore tasks delegation.
• Maintained Requirement Traceability Matrix.
• Involved in Requirement Analysis, Preparing Test plans and Authoring Test cases.
• Developed SQL Server scripts for data validation.
• Test case execution and Defect management using HP Quality Center 9.0.
• Coordinated with the Developers regarding the Defects clarification and retesting against the application.
• Performed Regression testing for the areas of the application dat could be effected.
• Supported for UAT, Postproduction Support and Maintenance Release.
• Played the role of Configuration Control anchor.
• Maintained all the Testing deliverables without any schedule slippages.
• Knowledge Transfer sessions to the team and new joiners.
• Performed Manual Testing on Web Based Application and data validation against DB.
• Understanding and analyzing of business requirements.
• Prepared Test cases and Test Data/Test Environment set up.
• Test case execution and Defect management using TestDirector 5.0.
• Supported for UAT, Post Production Support and Maintenance Release.
• Co-ordination with onsite team, management, and Status Reporting.
• Maintained all the Testing deliverables without any schedule slippages.
• Prepared Test Summary Reports.
• Involved in Configuration Management, Defect Prevention and Knowledge Management activities.