SUMMARY

• Around 9+ years of Experience as QA lead on Business Application Software Testing & ETL Testing, Quality Assurance, Testing process, Testing methodologies and strong experience on STLC and overall testing approaches.
• Currently working with Confidential technologies from past 2+ year and have 7.5 year prior experience with Confidential Consultancy Services .
• Experienced in leading teams from project inception through release planning.
• Skilled in eliciting stake holder requirements, functional and quality requirements.
• Excellent verbal, written, interpersonal, leadership and conflict resolution skills.
• Sound Knowledge in DWH Concepts and ETL Testing.
• Sound Knowledge on ETL tool Informatica Power center, Abhinito.
• Good Knowledge on Teradata SQL Assistant, Toad for Oracle,SQL devloper, SQL Server Database.
• Good Knowledge on Python Scripting .
• Good Knowledge on OBIEE and Tableau Reporting Tool .
• Experience in driving and planning the UAT Cycles from different project point of view.
• Experience in Unix Shell Scripting & Perl automation and maintaining shell Scripts for automation purpose
• Schedule ETL jobs using Control - m,TWS (Tivoli Work load Scheduler),Autosys for loading data in target tables.
• Expertise level knowledge in entire software development lifecycle (SDLC) process from business analysis to development, testing, deployment, documenting, maintaining and user training, experience on AGILE and SCRUM design methodologies
• Experience working on Dev ops .
• Worked extensively with JIRA tool to create user stories, creating dashboards and filter, updating tickets and preparing reports.
• Worked extensively with HP Quality Center /ALM to map requirements to test cases, create test sets and carried out test runs manually as well as using automated test scripts.
• Strong ETL testing experience and SQL and PL/SQL testing experience.
• Experience on analyzing PL/SQL script and testing PL/SQL scripts.
• Experience in executing/trouble shooting stored procedure as a part of testing PL/SQL script.
• Extracting defect status reports and managing defect status using the HP ALM and conducting defect status calls.
• Test harness experience from end to end process.
• Experienced in testing Web applications and client/server applications
• Preparing Test status and defect status reports and review them daily.
• Excellent experience in preparing Test plan document which includes test strategy.
• Excellent experience in preparing Test closure summary.
• Expertise in creating the test data for Extraction and Transformation processes and resolved critical data issues by following the data standards of the project.
• Extensive working knowledge in UNIX environment.
• Strong working experience in preparing the test plan, test run and managing the test run effectively using the HP ALM.
• Involved in end to end QA artifacts Preparation from Master Test Plan to Test Closure Summary
• Working closely with Business team for deploying solutions and sound experience in working closely with client.

TECHNICAL SKILLS

Databases/Client Tool: Oracle, Teradata, MS SQL server Teradata SQL Assistant, TOAD for Oracle, SQL Developer.

Scheduling Tool: TWS (Tivoli Work load Scheduler),Control-m, Autosys, Tidal

Test Management tool: HP quality center, ALM,Jira

ETL Tools: Informatica, Abhinito

MS Office: Word, Access, Power Point, Excel

Operating Systems: Windows 95/98/2000/XP/7 and UNIX.

Web Programming: HTML, XML

Programming languages: Shell and Perl scripting, SQL scripts, PL/SQL and Python programing

Reporting Tool: OBIEE and Tableau.

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Test Lead

Environment: SQL Developer, Informatica, Toad for oracle, Oracle, MS SQL server and teradata DB, Tidal scheduling tool, PL/SQL. Jira

Responsibilities:

• Data Loading in Target tables using ETL Tool Informatica
• Data comparison using Query Surge tool between source and target.
• Expertise in QA artifacts preparation from Master Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
• Creating SQL scripts to be executed on Teradata SQL Assistant and doing a source to target validation
• Posting the issues identified to all the stakeholders.
• Executing stored procedures for testing PL/SQL codes for various stages of data load to data DW and data mart.
• Keeping Track of Defects
• Communicating with Dev. Leads, BA’s, Project manager regularly and ensuring project deliverables or on Track
• Participation in daily QA scrum meetings.
• Preparing the daily status, defect reports and reviewing them with stake holders
• Participated in Daily QA Scrum with QA manager to discuss the QA updates.

Confidential, Richardson, TX

Test Lead

Environment: Teradata SQL Assistant, Informatica,, Toad for oracle, Oracle and teradata DB.TWS scheduling tool.PL/SQL

Responsibilities:

• Data Loading in Target tables using ETL Tool Informatica
• Data comparison using Query Surge tool between source and target.
• Expertise in QA artifacts preparation from Master Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
• Creating SQL scripts to be executed on Teradata SQL Assistant and doing a source to target validation
• Posting the issues identified to all the stakeholders.
• Executing stored procedures for testing PL/SQL codes for various stages of data load to data DW and data mart.
• Keeping Track of Defects
• Communicating with Dev. Leads, BA’s, Project manager regularly and ensuring project deliverables or on Track
• Participation in daily QA scrum meetings.
• Preparing the daily status, defect reports and reviewing them with stake holders
• Experience in QA life cycle testing.
• Participated in Daily QA Scrum with QA manager to discuss the QA updates.
• Experienced with VERSION ONE tool for managing the defects

Confidential, Wilmington,DE

Test Lead

Environment: Teradata SQL Assistant, Informatica,, Toad for oracle, Oracle and teradata DB.TWS scheduling tool.PL/SQL

Responsibilities:

• Providing QA estimates for all the Test deliverables
• Expertise in QA artifacts preparation from Master Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
• Extracting Data from Heterogeneous Sources and processing them to staging layer.
• Loading the data into tables using TWS (Tivoli workload Scheduler) and Control-m scheduling tool.
• Handle all testing units through Cognos framework according to the need of the projects
• Validating the data by applying all business rules and processing data till the BASE layer.
• Creating SQL scripts to be executed on Teradata SQL Assistant and doing a source to target validation
• Posting the issues identified to all the stakeholders
• Keeping Track of Defects
• Communicating with Dev. Leads, BA’s, Project manager, offshore team and onshore regularly and ensuring project deliverables or on Track
• Participation in daily QA scrum meetings.
• Writing the test cases covering the complete requirement logic.
• Preparing the daily status, defect reports and reviewing them with stake holders
• Experience in all QA life cycle testing.
• Participated in Daily QA Scrum with QA manager to discuss the QA updates.
• Experienced with ALM for managing the defects and querying the ALM for pulling Defect status reports.

Confidential

Test Lead /Analyst

Environment: Teradata SQL Assistant, Informatica,Toad for oracle, Oracle and Teradata DB.TWS scheduling tool,PL/SQL.

Responsibilities:

• Providing QA estimates for all the Test deliverables
• Expertise in QA artifacts preparation from Master Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
• Extracting Data from Heterogeneous Sources and processing them to staging layer.
• Loading the data into tables using TWS (Tivoli workload Scheduler)
• Experience in deployment code using CLM tool.
• Validating the data by applying all business rules and processing data till the BASE layer.
• Creating SQL scripts to be executed on Teradata SQL Assistant and doing a source to target validation
• Posting the issues identified to all the stakeholders
• Keeping Track of Defects
• Communicating with Dev. Leads, BA’s, Project manager, offshore team and onshore regularly and ensuring project deliverables or on Track
• Participation in daily QA scrum meetings.
• Writing the test cases covering the complete requirement logic.
• Preparing the daily status, defect reports and reviewing them with stake holders
• Experience in all QA life cycle testing.
• Participated in Daily QA Scrum with QA manager to discuss the QA updates.
• Experienced with ALM for managing the defects and querying the ALM for pulling Defect status reports.

Confidential

Test Analyst

Environment: SQL devloper, Oracle DB, TWS, HP QC10, UNIX, Informatica.

Responsibilities:

• QA artifacts preparation from Master Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
• Extracting Data from Heterogeneous Sources and processing them to staging layer.
• Loading the data into tables using TWS (Tivoli workload Scheduler)
• Validating the data by applying all business rules and processing data till the BASE layer.
• Creating SQL scripts to be executed on Teradata SQL Assistant and doing a source to target validation
• Posting the issues identified to all the stakeholders
• Keeping Track of Defects
• Communicating with Dev. Leads, BA’s, Project manager, offshore team and onshore regularly and ensuring project deliverables or on Track
• Participation in daily QA scrum meetings.
• Writing the test cases covering the complete requirement logic.
• Preparing the daily status, defect reports and reviewing them with stake holders