SUMMARY:

• Experience of 10+ years in Software Testing involving functional testing, regression testing in Data Ware house Testing, database testing in Finance, Cable, media, Telecom, HR, Health, Media, agriculture, Retail and Travell
• Currently working with Confidential at Saint Louis(MO) as data warehouse tester
• Experience in end - to-end DW testing including creation of test plan & test strategy, preparation of test estimates, test approach, defect tracking, test cases review and Metrics collation.
• Working in Agile Scrum methodologies
• Proficient in analyzing Business Requirements, System Requirements, Functional Requirement Specification (FRS), Design Documents, Use Case Specifications, and User Stories.
• Closely worked with business to understand the features and design the test approach.
• Experience in User Acceptance Testing, GUI Testing, System & Functional Testing,
• Ad-hoc testing, Black Box Testing.
• Experience in Defect management, defect analysis and defect reporting using various Defect Tracking Tools.
• Worked extensively with technical skill sets of Teradata, RedShift, S3,EC2, Golden Gate, and INFORMATICA. Worked on UNIX, Windows NT, 2000 platforms. Good knowledge in ETL process consisting of data profiling, data cleansing, data transformation, developing ETL objects, data loading and Report (Hyperion, Business Object and TIBCO-Spotfire) testing
• Experience of working on customer issues, interaction with real end customer(s), reproduction of customer issues
• Hands-on experience in diversified fields of Software Development Life Cycle and Software Testing Life Cycle
• Exposure in cross browser testing to ensure the integrity of the application on various browsers
• Proactively taken responsibilities for the testing deliverables during all phases.
• Optimum use of documentation to avoid any form of miscommunication or misinterpretation during the entire software development process
• Having Valid H1-B Visa

TECHNICAL SKILLS:

Database: Oracle10g, SQL Server 2008 & Teradata, Redshif

ETL Tools: Informatica

Reporting Tools: Business Object and Hyperion

Test Management Tools: HP ALM

Operating System: Windows, UNIX

Defect Tracking Tools: JIRA

Version Control Tools: SVN

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Associate

Responsibilities:

• Responsible for writing test strategy and test plans
• Leading a team of 3 associates and responsible for overall QA deliverable of the team
• Entirely responsible for Planning, prioritization and allocation of testing tasks to team members
• Designing and execution of the System test cases, parallel test cases defect logging
• Perform end to end ETL or data warehouse testing
• Working on BO (Business Object) report as per business needs
• Test the normalized table ETL jobs for both history and incremental loads.
• Tune the SQL query, data profile, improving the ETL performance.
• Job schedule designing and schedule application development.
• Performing the test runs and validating the data.
• Defect logging using JIRA

Confidential

Test Engineer

• Responsible for writing test strategy and test plans
• Entirely responsible for Planning, prioritization and allocation of testing tasks to team members
• Designing and execution of the System test cases, parallel test cases defect logging
• Responsible for designing and executing complex SQL scripts for data validation
• Working on Hyperion report as per business needs
• Prepare ETL Specifications & ETL Design Documents.
• Perform end to end ETL testing.
• Test the normalized table ETL jobs for both history and incremental loads.
• Tune the SQL query, improving the ETL performance.
• Performing the test runs and validating the data.
• Defect logging using Mercury Quality Center
• Responsible for doing the root cause analysis for UAT defects

Technology & Tools: Windows 7, UNIX, Informatica, Teradata, SQL server, Autosys, Hyperion, ALM,

Confidential

Senior Test Engineer

• Designing and execution of the System test cases, parallel test cases defect logging
• Responsible for designing and executing complex SQL scripts for data validation
• Conducting test case reviews
• Test the stage and EDW tables
• Test the normalized table ETL jobs for both history and incremental loads.
• Tune the SQL query, improving the ETL performance.
• Performing the test runs and validating the data.
• Defect logging using Mercury Quality Centre

Technology & Tools: Windows 7, UNIX, Informatica, Teradata, SQL server, Autosys, Hyperion, ALM

Confidential

Software Test Engineer

• Analyze the requirement coverage and traceability to ensure the testing coverage
• Participated in extensive Informatica ETL and BI applications validation
• Perform Functional testing, system testing, Adhoc Testing, end to end testing and Regression Testing
• Performed manual Functionality, Front-End and GUI Testing
• Defect logging using Mercury Quality Center
• Involved in Reporting defects and attending defect review meetings

Technology & Tools: UNIX, Informatica, Teradata, SQL server, Autosys, Hyperion, ALM

Confidential

Software Test Engineer

• Responsible for writing test strategy and test plans
• Participated in extensive Informatica ETL and BI applications validation
• Perform Functional testing, system testing, Adhoc Testing, end to end testing and Regression Testing
• Experience in defining the test case dependencies and design the test data sets according to the test scenarios
• Responsible for doing the root cause analysis for UAT defects
• Involved in Reporting defects and attending defect review meetings

Technology & Tools:Informatica 9, HP Quality Centre 9.2,Teradata

Confidential

Senior Test Engineer

• Detailed study of the software requirement specification.
• Analyzed the existing business scenario and understood the business rules
• Creation of test plan
• Functional testing, end-to-end testing and regression testing
• Monitoring and Performance tuning - Tune the SQL query, Improving the ETL performance.
• QA weekly meetings, bug triage meeting, proposals for resolving the conflicts
• Maintaining Offshore-Onshore status calls
• Preparing various Reports like CAR and SMR.

Technology & Tools:WinXp Teradata, HP Quality Centre 9.2, Unix

Confidential 

Software Test Engineer

• Providing inputs to test manager for process improvement.
• Understanding Tariffs signed off sheet and creating Test Cases based on TSO in Quality Centre 9.0
• Creating Test Completion report and test script execution and verification of call data with bill.
• Prepare the testing closure certificate (TCC).
• Maintaining Offshore-Onshore status calls and Handing the team.

Technology & Tools:WinXp, SQL Server 2008, CSG, Oracle

Confidential

Test Engineer

• Understanding change requests
• Creating Test Cases based on the score of RBT Register & change requests.
• Effective defect reporting and tracking and Creating Test Completion report
• Updating automation scripts in QTP and Test the web services using SOAP UI tool
• Data build and test case execution.
• Perform end to end functional, system, integration testing.

Technology & Tools:Win XP, ORACLE, SQL Server 2008, HP Quality Centre 9.2

Confidential

Quality Analyst

• Involved Requirements review meeting and designing of the System Test cases.
• Designing the test cases and implementing them into Manual test cases.
• Execution of System Test cases, Regression Test Cases and Defect logging
• Provided training to new team members for team ramp up.
• Designing and executing test cases.
• Attended bug review meeting with client managers

Technology & Tools:Win XP, ORACLE 10g,front end