SUMMARY:

• Certified Test Specialist having 13 years of experience and expertise in Delivery & Client relationship management, Project & Team Management, DWH /ETL Testing, Database/SQL Testing, Manual Functional Testing, Automation Testing, Quality Center - HP QC/ALM, Requirement Analysis, Leadership.
• Motivated achiever who guides organizations to implement new quality standards to ensure the optimized execution of projects and project deliverables in a timely manner.
• Good knowledge of Health Care Domain & Banking domain.
• Good experience in Rally project management tool & Agile scrum framework
• 13 years of work experience in managing, leading & testing various software applications end to end on different platforms i.e. Data Warehousing/ ETL, Big data, Java, Microsoft .net etc.
• CSTE (Certified Software Tester), ISTQB (ISEB), OCA (Oracle Certified Associate) certified
• Managing and tracking complete test process through HP ALM Test Management tool
• Expert in ETL/DWH Testing, Functional Testing, System Testing, Regressing Testing
• Expertise in Test Designing, Execution and Defect Reporting
• Experience in using different tools i.e. HPALM, Bugzilla, Team Track, Jira and Rally
• Designing automation scripts using QTP 9.0 (Quick Test Pro)
• Working knowledge of Informatica ETL tool
• Understanding of Dimensional Modeling concepts & ETL fundamentals
• Experience in Fact & Dimension, Structural & Count Testing of data marts/data warehouses
• Good in writing SQL queries to validate business rules
• Understanding of Business Object (BO) reporting
• Basic knowledge of Unix & Unix Shell Scripting
• Experience in User Acceptance Testing (UAT)
• Participating in Reviews and Walkthroughs
• Experience in Agile software development process and SCRUM framework

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 8.6.1, 9.1, DataStage

Databases: Oracle, Teradata

Languages: SQL, PL/SQL, Unix Shell Scripting

Reporting Tool: Awareness on Business Objects

Testing Tool: QTP, HP ALM, Bugzilla, eTeam, Jira, TeamTrack, Rally

GUI Tools: TOAD

Operating Systems: Sun Solaris, Windows Server 2008, XP

Others: MS Visio, MS Office, Control-M, VB Script, TWS

PROFESSIONAL EXPERIENCE:

Confidential

Engineering Manager/Sr. Lead

Responsibilities:

• Managing end to end testing for project
• Understanding of business requirements
• Involved in Planning and Estimation for tasks
• Update user stories in Rally
• Assigning and tracking tasks assigned to team members
• Understand complete Dimensional Model (fact and dimensional tables)
• Using HP ALM (HP QC) Test Management tool for test case designing, execution and defect reporting
• Validate ETL solutions (mappings and workflows) developed through datastage, Unix Shell Scripts
• Writing SQL to understand source data and to test the load of target data
• Evaluating testing results (Test & Defect Reports) for each potential release build
• Peer review of different artifacts like test cases, test scripts & test scenarios and submitting review reports

Confidential

Test Expert/IT Consultant

Responsibilities:

• Assigning and tracking tasks assigned to team members
• Coordinating with onsite counterpart and delivering final documents
• Designing, updating and executing QTP automation scripts
• Designed and executed functional test cases to test complex business rules
• Used check points, output value and parameterization
• Created Role requests forms for second and third level support role
• Understand complete Dimensional Data Modeling for fact and dimensional tables
• Using HP Quality Centre (QC) Test Management tool for test case designing, execution and defect reporting
• Validate ETL solutions developed through Informatica PowerCenter
• Validate ETL jobs and its execution flow using Control-M Scheduler
• Testing various transformations like Source Qualifiers, Joiner, Aggregator, Filter, Router, Update Strategy, Sequence Generator transformations in the mapping
• Verify lookup and filter conditions to enhance mapping performance
• Experience in validation Sessions and Workflows including Assignment, Command, Control, Decision, Event tasks
• Used Mapping variables and parameters as well as Workflow variables for parameterization and reusability
• Writing SQL to understand source data and to test the load of target data

Confidential

Senior Test Associate

Responsibilities:

• Designed & Executed test cases and reported defects
• Performed System, Functional, Regression testing
• Validate ETL solutions developed through Informatica PowerCenter
• Designing automation scripts using QTP 9.0 (Quick Test Pro)
• Experience in GUI, Bitmap and Text checkpoints where needed, to compare the current behavior of the application being tested to its behavior in the earlier version using Quick Test Pro (QTP).
• Participate in weekly meeting with the management team and walkthroughs
• Member of the UAT team and worked with the perspective of the user
• Coordinated with developers to fix the bugs
• Involved in maintaining Requirement Traceability Matrix - RTM
• Maintain Defect Log which gives a clear indication of quality and stability of product
• Ramped up QA testing staff to support testing process
• Prepared Defect and Test Closure Reports

Confidential

Test Engineer

Responsibilities:

• Analyzed requirements to get the requirement understanding and clarified requirement gaps from client
• Prepared requirement understanding documents
• Responsible for test design and execution
• Reporting and tracking defects for failed test cases
• Created test coverage matrix to assure complete test coverage
• Written Test scenarios to validate flow of application
• Designed and executed automation test scripts in QTP 9.0
• Used check points, parameterization and descriptive programming
• Done SQL(Data Base) Testing to validate the application data
• Compared application data with host data by executing SQL queries
• Executed User Acceptance Testing test cases in UAT environment
• Ramped up QA testing staff to support testing process
• Prepared Defect and Test Reports

Confidential

Test Engineer

Responsibilities:

• Assigning task to team members
• Daily status reporting to manger
• Performing gap analysis for requirement understanding and maintaining gap analysis sheet
• Responsible for system and system integration test case design and execution
• Reporting and tracking defects
• Prepared RTM requirement traceability matrix to assure complete test coverage
• Written test scenarios to positive flow of application
• Provided application functionality to new team members
• Compared application data with host data by execution SQL queries in host system
• Involved in Usability, Functional, System and Regression Testing

Confidential

Test Engineer

Responsibilities:

• Responsible for system test design and execution
• Reporting and tracking defects
• Designed System test cases for end to end testing
• Identifying candidate test cases for regression suite
• Performed smoke and sanity testing for new builds
• Wrote Test scenarios to validate flow of application
• Involved in Usability, Functional, System and Regression Testing
• Compared application data with host data
• Test Scripts creation, review and execution

Confidential

Test Engineer

Responsibilities:

• Performing Gap Analysis and maintaining Gap Analysis sheet
• Responsible for test design and execution
• Reporting and tracking defects
• Written Test scenarios to validate positive flow of application
• Involved in Usability, Functional, System, Integration and Regression Testing
• Compared application data with host data by execution SQL queries