PROFESSIONAL SUMMARY:

• 5 years of experience in Software Development and Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications, Data Warehousing, BI and ETL Testing.
• Experience in entire Software Development Life Cycle and Test Development Life Cycle which includes requirement analysis, Design and Development and performing Integration Testing, Validation Testing, Functionality Testing, Regression Testing and User Acceptance Testing.
• Software testing experience, with experience in Waterfall and Agile/Scrum Methodologies.
• Ability to manage multiple project in testing by managing team, automate process and delivered all task.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects in Quality Center/ALM
• Expert in review and analyze requirements, use cases, technical specifications and database designs.
• Expert in Develop Test Plans, Test Designs, Specifications, Test Cases and Scenarios.
• Experienced in documenting defects, generate defect and test progress graphs with overall test summary
• Extensively Used Quality Center for Test Case and defect tracking management.
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.

TECHNICAL SKILLS:

ETL Tools: DataStage, Informatica Power center, Ab Initio, SSIS

Big Data tools: Hadoop Eco System, HDFS, Map Reduce, Hive, Pig, Sqoop

Languages: C, C++, Unix Shell Programming, SQL, PL/SQL

Database Tools: Oracle 10g/11g, SQL Server 2000/08/10, DB2, SQL*Plus, TOAD, SQL

Testing Tools: QTP(Now UFT), Selenium, Soap UI, MS Access

Bug Defect tools: HP Quality Center, HP ALM, JIRA, Confidential RTC

Web Technologies: HTML, JavaScript, VB Script, XML

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

SQL/ETL/Functional Test Analyst

Responsibilities:

• Performed System testing, Regression testing, Systems Integration testing, and also User Acceptance testing.
• Interacted with Business users and Technical Architects to analyze the data & gathering the requirements from various sources.
• Participated in Daily scrum call to update the status and discussed on blockers.
• Interacted with DBA for setting up test environment in Oracle/Netezza database.
• Worked on the Pre - deployment validations and post-deployment validations and provided the production support also.
• Performed database validation using SQL according to the business rules and specifications.
• Created System Integration test cases and executed them in HM ALM.
• Used Version One to track the requirements and used HP ALM to track the Defects.
• Developed Test Plan and Test Strategy for multiple data feed applications.
• Written several complex SQL queries for data validation and data verification.
• Identifying duplicate records in the staging area before data gets processed and ensured that the mappings are correct and conducted data validation.
• Created test data in SIT region to cover all test scenarios.
• Executed test scripts in different regions like SIT, QA, UAT and generated test reports.
• Updated the status of the Development and testing to the product owner in the Daily Scrum call.

Environment: Informatica, ETL, Netezza, Oracle, SQL, Version One, Windows, Unix, Z/OS Mainframe, Flat Files, XML, Windows, SQL Developer, HP ALM

Confidential, Southbury, CT

ETL Systems Analyst

Responsibilities:

• Interacted with Business users and Technical Architects to analyze the data & gathering the requirements from various sources.
• Participated in Daily scrum call to update the status and discussed on blockers.
• Created test data in SIT region to cover all test scenarios.
• Executed test scripts in different regions like SIT, QA, UAT and generated test reports.
• Developed Test Plan and Test Strategy for multiple data feed applications.
• Written several complex SQL queries for data validation and data verification.
• Created Unit and System Integration test cases and executed them in Confidential RTC.
• Design and Developed Datastage applications to process the Data from multiple sources into Staging area and then apply the business transformations and load the data into Data warehouse.
• Worked on Datastage Director to view the logs and status.
• Created ETL mapping document to understand the data movement between source and Target.
• Integrate the data from the Source system into the target database.
• Used Confidential RTC to track the requirements and Defects.
• Identifying duplicate records in the staging area before data gets processed and ensured that the mappings are correct and conducted data validation.

Environment: Confidential Infosphere Datastage 11.3, ETL, DB2, Oracle, SQL, Confidential RTC, Windows, Unix, Z/OS Mainframe, Flat Files, XML, Confidential Notes, SQL Developer, Control M/In Touch, Confidential Hybrid Cloud

Confidential, San Francisco, CA

ETL/QA Tester

Responsibilities:

• Used HP ALM to create manual and automated tests, build test cases, Test cycles, run tests, report and track defects.
• Developed Test Plan and Test Strategy for multiple data feed applications.
• Written several complex SQL queries for data validation and data verification.
• Identifying duplicate records in the staging area before data gets processed and ensured that the mappings are correct and conducted data validation.
• Conducted review sessions on test case and regression test scripts in HP ALM.
• Created test data in SIT region to cover all test scenarios.
• Executed test scripts in different regions like SIT, QA, UAT and generated test reports.
• Involved in validating both functional and automated business processes using HP ALM.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.
• Worked on database upgrade project from Oracle 11g to 12c to ensure the data is being migrated as per the requirement.

Environment: Informatica Power center, ETL, Oracle 11g/12c, SQL Server, SQL, HP ALM, Windows, Unix, Flat Files, Microsoft office, SQL Developer, Traceability Matrix

Confidential, Providence, RI

ETL/QA/Data Warehouse Tester

Responsibilities:

• Queried databases using SQL queries in AQUA Data studio to validate the between source and targets.
• Developed Test Plan and Test Strategy for multiple data feed applications.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and tested the testing programs.
• Tested multiple source files in UNIX command line.
• Written several complex SQL queries for data validation and data verification.
• Testing the source and target databases for conformance to specifications
• Conducted review sessions on test case and regression test scripts in HP ALM.
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: Confidential InfoSphere Datastage 8.7, ETL, Oracle 11g, DB2 8.x/9.x, MS SQL Server 2000/8/10, SQL, AQUA data studio, Traceability Matrix, HP ALM/Quality Center, PL/SQL, Windows 2000/NT & Confidential AIX, Autosys.

Confidential

Software Test Engineer

Responsibilities:

• Involved in Test plan and Test case preparation.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Executed automation scripts in Selenium and QTP(UFT)
• Interacting with developers for the Bug Fixes and Problem resolution
• Involved in preparing Daily status report.
• Provided weekly management status reports.
• Executed SQL Queries to check table updates and data retrieval

Environment: Informatica Power Center, Clear Quest, Oracle 11g, PL/SQL, Aix, Toad, QTP, Java, VB Script, Win Runner, Selenium, XML, XSLT, Oracle SQL, Test Cases, Test Scripts, Test Plan, Traceability Matrix.