SUMMARY:

• ISTQB certified Test Lead with 10 years of experience in leading and managing the projects in various phases of STLC.
• Experienced Test data consultant responsible for planning, requirement gathering, discovery, design, development and maintenance of test data, using appropriate Confidential tools and techniques.
• Extensive experience in creating Test Plan, Test strategy, Test Data strategy, Test summary/closure reports.
• Experience in developing Confidential strategies and plans to provide right sized, production like, reusable and secured test data, per test data requirements.
• Experience in providing production copy subset data to test systems, masking sensitive test data and maintaining test data by refreshing, roll forward, roll backward, aging, archive and cleaning techniques using Ab Initio and IBM OPTIM.
• Experience in Data - Subset by creating Application data model and subset jobs using Oracle OEM.
• Creating ETL jobs with complex transformations using Talend open studio 6.2 to refresh the test regions.
• Experience in performing root cause analysis and resolving issues of data load and downstream data impacts using SQL, PL SQL .
• Working knowledge in cloud based applications deployed in Amazon Web Services (AWS EC2, S3, VPC, IAM and Redshift).
• Hands on NoSQL database experience - HIVE, HBASE, MongoDB
• Experience in Business Intelligence testing with reporting tools such as Business Objects.
• Experience in testing of Data Warehouse and ETL processes consisting of data transformation, sourcing, mapping, conversion and loading.
• Analyzing/reviewing the Mapping Sheet to validate the source and target mapping.
• Writing and executing ETL Test cases on the basis of Transformation Rules defined in mapping/requirement documents
• Good Exposure on web services, XML and SOAPUI .
• Thorough knowledge of Software Development Life Cycle and Test Life Cycle.
• Extensive hands on experience in carrying out various levels of testing such as Smoke Testing, Functional Testing, Integration Testing, System Testing, Regression Testing, Database Testing and User Acceptance Testing.
• Expertise in strategic planning and technical knowledge with strong management, communication and leadership skills to contribute to business goals .

TECHNICAL SKILLS:

Testing Skills:   Confidential, ETL, DWBI Testing

Test data management Tool:  IBM OPTIM 9.1, Oracle OEM 12C

ETL Tool:  Ab Initio 3.1, Talend Open Studio 6.2

Databases:  MS SQL Server 2005, Oracle 10g, Teradata V13

Reporting Tools:  Business Objects XI R2, SQL Server Reporting Service 2008

Tools:  Toad 8.6.1, SQL Server Management Studio, Oracle SQL Developer, PuTTy, Unix

SDLC Models:  Agile, V model.

Languages:  SQL, PL SQL, Python

Bug Tracking Tool:  Bugzero, HP Quality Center 10

Domain:  Retail Banking, Healthcare, Life sciences, Insurance

SOA Tools:  SOAP UI PRO4.6.3

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, Arizona

Test Data Lead

Responsibilities:

• Responsible for all in-scope deliverables within Test data design and prepare work stream.
• Test data status reports with demand, fulfillment plan and status
• Develop recommended framework, processes and methodologies for Confidential
• Develop data mining and reservation capabilities
• Test Data refresh of the data mining environment using Talend Open Studio 6.2
• Data sub setting using Oracle OEM.

Confidential, Richmond

Test Data Lead

Responsibilities:

• Creating Ab Initio graphs for Extracting, Converting and loading the data.
• Identifying and masking sensitive test data u sing IBM Optim and OPTIM Z for generating production like test data.
• Refreshing the test regions/tables with production copy subset data.
• Creation and conditioning of Test data using Automated QTP scripts, Excel Macros and VB .Net based automated tool.
• Verification of the test data across applications and databases.
• Preparing the Test data strategy and weekly Test data status report.

Confidential  

Test Data Lead

Responsibilities:

• Leading Test data team of 5 members and managing efforts close to 9000 hours spread across various testing phases.
• Preparing Test Data Strategy, Test Data plan and Test plan for ETL testing of Batches.
• Responsible for the test data end to end delivery across testing phases (Unit Testing, Integration Testing, System Testing, User Acceptance Testing)
• Creation of Test data using Automated QTP scripts and SAP GUI.
• Verification of the test data in Mainframe, CDI (Customer data Interface) and ODS databases.
• Verification of the test data using SOAP UI and SAP PI.
• Preparing the Test data strategy and weekly Test data status report.
• Responsible for coordinating with the backend team and the shared services team to facilitate the test data.
• Co-ordinate between onsite and offshore team to stream line the process for data request and response.

Confidential 

Senior Test Engineer

Responsibilities:

• Attending Requirements Walkthrough, Development and Testing discussions, Defect resolution meetings, weekly Status calls,
• Analyzing requirement and preparing Test Plan, Test Schedule, designing, reviewing and executing test scenarios.
• Conducting ETL testing to verify the source and Target database as per the mapping sheet.
• Report Testing, Database Testing using SQL queries.
• Bug Tracking and Reporting.
• Involved in ad-hoc testing of the application.

Confidential  

SSE - Testing

Responsibilities:

• Attending RD, FSD and Business Requirement Specification walkthroughs
• Visualizing requirement from end user’s perspective, preparing Test Plan, Test Schedule, designing, reviewing and executing test scenarios.
• Report Testing, Database Testing, monitoring and reporting issues at the Application server.
• Test Bed creation, Application Installation and Deployment.
• Data verification using SQL queries.
• Involved in Review process of Application User Guides, Installation and Database guides. Also involved in Review and Execution of Validation Kits.
• Bug Tracking and Reporting.

Confidential 

 QA Engineer

Responsibilities:

• Requirement Analysis and Impact Analysis
• Client Interaction, weekly status calls with the client and Onsite co-coordinator.
• SPOC for the Client/Onsite lead for testing related issues/queries.
• Test Scenario identification.
• Test Case preparation and execution.
• Involved in ad-hoc Test Execution (Functional and UI testing).
• Involved in data verification using SQL queries.
• Bug Tracking and Reporting