PROFESSIONAL SUMMARY:

• Around 8+ years of experience in testing large scale enterprise, Client/Server and web applications in all phases of software development life cycle, including requirements gathering, risk analysis, planning, scheduling, testing, defect tracking and maintenance.
• Specialized in ETL and Data warehousing Testing.
• Having good knowledge about Test Data Management and Test Data Management Activities like Data Subsetting, Data Masking, Data Refresh, Data Archiving, Data Repository and Version Controlling.
• Explored an Open source Tool Pentaho SPOON. With the R&D and Analysis converted it to a TDM tool from ETL tool by the transformations.
• Worked with Clients Like BANK of the WEST, Confidential, Confidential, Confidential, Confidential etc.
• Good hands on designing TCER (Test Conditions and Expected Results) and Test scripts based on the Business requirements (BRD) and Technical specifications.
• Having knowledge in Basics of J2EE, Oracle, DB2 and Unix Shell Scripting.
• Experience in Informatica, Defect management and Bug reporting using Bug - Tracking tool (Quality Center, Microsoft Test Manager and Clear Quest).
• Skilled in planning/execution of all facets of Verification and Validation effort for Software Application/Product.
• Has good knowledge over SDLC (Software Development Life Cycle) and STLC (Software Testing Life Cycle).
• Involved in Test Case Review Process as a part of peer review and Audit process.
• Possess good communication skills, resulting in excellent rapport with peers and onshore counterparts.
• Ability to create test plans that outline deliverables for projects which addresses test environment, requirements traceability, configuration management, and defect tracking.
• Strong proficiency with SQA concepts, methods and deep STLC understanding
• Demonstrated skill for independently solving problems, analyzing root cause, pinpointing the issue and proposing fixes
• Good experience of working in Healthcare and Manufacturing and Banking Domain.

TECHNICAL SKILLS:

Tools: Informatica, Toad, HP Quality Center(QC), RationalClear Case, Rational Clear Quest, Microsoft Test Manager, RADAR,Pentaho SPOON, SQL Developer, Cross Database Studio, Teradata.

OS: MAC 10.6 (Leopard), Windows, Unix

Languages: Unix Shell Scripting, PL/SQL

Database: Oracle, DB2

Domain: Banking, Manufacturing Industry, US Health careInsurance industry with focus in Medicare applications, USCommercial Insurance

PROFESSIONAL EXPERIENCE:

Sr.SQA Engineer

Confidential

Responsibilities:

• Responsible for Analysis and Testing of Requirements from the Client.
• Involved in Preparing ETL Test Cases.
• Testing of migrated data at every stage (Source to Stage and datastore, Stage to EDR and EDR to FARM) of ETL process by verification through SQL query against the business rules.
• Analyze the requirements and understand product functionality.
• Participated in the product knowledge transfer sessions with the business team.
• Estimating the testing scope of the project based on the requirements.
• Authored test cases using business requirements and Technical requirement documents.
• Preparing the Test Traceability matrix for mapping the requirements against Test Case Index and Test cases.
• Review of authored test cases.
• Prioritize the test cases for execution.
• Executing test cases, analyzed for issues in test environment.
• Performed adhoc testing and Smoke testing on the product.
• Identifying defects in the product, drafting and posting the same to the defect tracking tool.
• Preparing and sending daily and weekly status reports to Managers.

Confidential

Responsibilities:

• Assisted in the development and implementation of new procedures due to process changes or client requirements.
• Research on various kind of TDM tools and information to meet client requirement.
• Responsible for Analysis and Testing of Requirements from the Client.
• Involved preparing the process related Test Data Management Documents and Templates.
• Involved giving Solution for the Test Data Management activities to the Client.
• Detailed analysis and Working on the TDM tool (SPOON) Gathering the information regarding TDM process related activities.
• Giving Demo regarding the TDM tools along with Documentation, PPT and videos
• Analyze and Identify Test Data Requirement for each application and preparing the same for the Applications.
• Exploring completely in and out of the Spoon with all the R & D
• Gave board room presentation for the Spoon tool to the all the members of the Vertical and got appreciations for the same.
• Prepared the White Paper on this tool and Test data management as this is very much a new and unexplored tool for CSC.

Confidential

Responsibilities:

• Responsible for Analysis and Testing of Requirements from the Client.
• Involved in Preparing ETL Test Cases.
• Testing of migrated data at every stage of ETL process by verification through SQL query against the business rules.
• Analyze the requirements and understand product functionality.
• Participated in the product knowledge transfer sessions with the business team.
• Estimating the testing scope of the project based on the requirements.
• Using Informatica ran the Unix jobs to load data in the target tables. Handled the errors from error logs.
• Authored test cases using business requirements and Technical requirement documents.
• Preparing the Test Traceability matrix for mapping the requirements against Test Case Index and Test cases.
• Review of authored test cases.
• Prioritize the test cases for execution.
• Executing test cases, analyzed for issues in test environment.
• Performed adhoc testing and Smoke testing on the product.
• Identifying defects in the product, drafting and posting the same to the defect tracking tool.
• Preparing and sending daily and weekly status reports to Onsite Co-Coordinators.

Confidential

Responsibilities:

• Worked at Client location for Confidential project at Sunnyvale, CA, USA for Confidential Workshop.
• Involved in Cross- Compatibility, Localization and URL testing of Confidential ’s product pages.
• Involved in defect triage meetings among delivery team
• Detailed analysis and reporting of defects posted onto RADAR.
• Gathering and maintenance of all client-supplied resources and documents.
• Involved in maintaining all process related documents on configuration management tool MS-VSS.
• Involved in Bug Review, Tracking and Severity analysis.

Confidential

Responsibilities:

• Authoring and executing Test cases.
• Performing functional and Regression testing.
• Drafting of the defects and mapping them to test cases.
• Tracking the Defects to Closure.
• Running jobs in Mainframes.
• Involved in the Design and Review of test cases

Confidential

Responsibilities:

• Requirement analysis, Test Strategy preparation, planning, scripting, execution and production checkout.
• Preparing queries and running them in DB2 to extract data for testing.
• Mapping the source data with the target data w.r.t Business Rules.
• Comparing the data as per the requirement given.
• Logging Defects in Rational Clear Quest.

Confidential

Responsibilities:

• Requirement analysis, Test Strategy preparation, planning, scripting, execution and production checkout.
• Testing of mainframe jobs (JCLs) used in the process.
• Testing of the Extraction Transformation and Load (ETL) process for the entire risk score calculation process.
• Testing of the Extraction Transformation and Load (ETL) process for the entire revenue calculation process.
• Preparing queries and running them in DB2 to extract data for testing.
• Crystal Report Testing.
• Logging Defects in Rational Clear Quest.

Confidential

Responsibilities:

• Involved in the Requirement analysis, Test Scripting and Web Application testing
• Authoring and executing Test cases.
• Performing functional and Regression testing.
• Drafting and posting of the defects in Radarand mapping them to test cases.
• Tracking the Defects to Closure.
• Involved in the Design and Review of test cases

Confidential

Responsibilities:

• Involved in the Requirement analysis, Test Scripting and Web Application testing
• Authoring and executing Test cases.
• Performing functional and Regression testing.
• Drafting and posting of the defects in Radar and mapping them to test cases.
• Tracking the Defects to Closure.
• Involved in the Design and Review of test cases